Using Excel, the CUPE electronic ledger automatically totals columns, inserts information needed for Treasurer’s reports, budget worksheets, and the Trustees’ Audit Report.
If using an annual budget, use the budget feature ledger (Jan-Dec) as it automatically calculates the remaining amount of budget available in each account category on the monthly Treasurer’s report. This feature will only work properly if the budget amounts are entered at the start of the fiscal year.
The six-month ledger should be used for any six-month period, just enter the months you are reporting in the “BEGIN HERE” worksheet.
Locals that have a different fiscal period other than the Jan-Dec year can use the twelve-month ledger. Just enter the 12 months you are reporting in the “BEGIN HERE” worksheet.
For locals that transfer funds from their operating account to savings, or other investment accounts should use the ledger below. It was designed to not affect your Income or Expense accounts but will still account for it accordingly in your operating account for balancing purposes.
For inquiries about the ledger, please send an email to ledger@cupe.ca
