Blog · Board and management reporting · Finance and FP&A teams
A monthly treasurer's report explains opening cash, receipts, payments and closing cash against budget. Build a concise US organization report with a worked reconciliation, consistent variance signs and a clear distinction between cash receipts and accounting income.
A monthly treasurer's report reconciles opening cash to closing cash and compares receipts and payments with the approved cash budget. It should show what changed, why the month differed from plan and how much cash remains available for the organization's next decisions. Keep this report on a stated cash basis so income does not get confused with unpaid sales.
State the month, organization, currency, accounts covered and budget version. This example is an October 2026 cash report for a US industrial services company, with all amounts in USD. Its cash budget and actual results cover the same accounts and categories.
The SBA's explanation of accounting methods distinguishes recording a sale under accrual accounting from recording the payment when cash is received. Apply that distinction here: collecting an earlier invoice is a current cash receipt even though its revenue was recognized earlier.
Bring the prior month's signed closing cash balance, current cash-ledger export, bank statements, reconciliation schedules and approved cash budget. Keep account, transaction reference, settlement date, receipt or payment category, amount and transfer identifier on each row.
The report is a cash accountability document. Use the broader management reporting package for the company's full performance discussion, and the monthly financial report template for the wider financial statements.
Remove duplicate transaction rows and identify transfers before summarizing. Preserve the source references so the reviewer can move from a category total back to the individual transactions. An unexplained residual category makes a report shorter at the cost of making it harder to review.
In this example, the opening cash balance is $520,000. The month has these external receipts:
| Receipt category | Cash budget (USD) | Actual receipts (USD) | Favorable variance (USD) |
|---|---|---|---|
| Customer collections | 240,000 | 220,000 | -20,000 |
| Service collections | 10,000 | 12,000 | 2,000 |
| Interest received | 2,000 | 3,000 | 1,000 |
| Total receipts | 252,000 | 235,000 | -17,000 |
On a receipts worksheet, put headers in row 1, categories in A, budget in B and actual in C. Favorable receipt variance in D2 is:
=C2-B2
Copy down through row 4. The totals use =SUM(B2:B4), =SUM(C2:C4) and =C5-B5. Receipts were $17,000 below budget, driven by customer collections rather than the smaller categories.
Payments use the opposite favorable-variance convention because spending below budget is favorable:
| Payment category | Cash budget (USD) | Actual payments (USD) | Favorable variance (USD) |
|---|---|---|---|
| Payroll | 145,000 | 150,000 | -5,000 |
| Suppliers | 45,000 | 50,000 | -5,000 |
| Equipment | 30,000 | 25,000 | 5,000 |
| Administration | 12,000 | 14,000 | -2,000 |
| Bank charges and interest paid | 1,000 | 1,000 | 0 |
| Total payments | 233,000 | 240,000 | -7,000 |
On a separate payments worksheet with the same column arrangement, use:
=B2-C2
Copy through row 6 and sum the categories in row 7. Label both tables clearly: positive variance means favorable, negative means unfavorable. All example amounts are whole dollars; no rounding is applied.
Closing cash = Opening cash + Cash receipts − Cash payments
| Cash bridge | Budget (USD) | Actual (USD) | Favorable variance (USD) |
|---|---|---|---|
| Opening cash | 520,000 | 520,000 | 0 |
| Receipts | 252,000 | 235,000 | -17,000 |
| Payments | 233,000 | 240,000 | -7,000 |
| Net cash change | 19,000 | -5,000 | -24,000 |
| Closing cash | 539,000 | 515,000 | -24,000 |
Actual receipts of $235,000 less payments of $240,000 produce a $5,000 cash decrease. Adding that decrease to the $520,000 opening balance proves closing cash of $515,000. The budget expected a $19,000 increase, so the $24,000 shortfall equals the $17,000 receipts gap plus $7,000 of extra payments.
For the bridge arranged as shown, with headers in row 1 and budget and actual in B and C, net cash change in C5 is =C3-C4, and closing cash in C6 is =C2+C5. The same formulas apply in column B. Closing variance is =C6-B6.
Do not call the $5,000 cash decrease a net loss. Equipment payments, settlement of earlier receivables and other timing differences separate cash movement from accounting profit.
The bank reconciliation provides an independent check on the $515,000 closing figure. Here, all bank fees have already been recorded in the cash ledger.
| Account | Statement balance (USD) | Deposits in transit (USD) | Outstanding checks (USD) | Adjusted bank balance (USD) |
|---|---|---|---|---|
| Operating | 318,000 | 7,000 | 12,000 | 313,000 |
| Reserve | 202,000 | 0 | 0 | 202,000 |
| Total | 520,000 | 7,000 | 12,000 | 515,000 |
For columns B through E, the adjusted balance is =B2+C2-D2. Deposits in transit increase the bank side because the books already include them; outstanding checks reduce it because the books have already recorded payment.
IRS Publication 583 explains these timing differences and the requirement for adjusted bank and book balances to agree. Keep the itemized deposit and check schedules behind the report, with dates for follow-up.
Of the reconciled closing cash, $90,000 is contractually restricted in this example. The remaining unrestricted book cash is $515,000 less $90,000, or $425,000. That figure is not automatically today's bank availability: the reconciliation still contains an uncleared deposit and checks.
Ask the collections owner to explain the customer receipt shortfall, and the payroll and purchasing owners to explain their unfavorable differences. Determine whether each gap is a settlement delay, an approved change or a lasting change in expected cash. The tables show where to ask; they do not establish the cause.
A short narrative can follow the logic of a movements page: identify the largest supported change and distinguish it from a classification or timing effect. Use a flash report when management needs an earlier provisional view, with its cutoff clearly labeled.
Upload your cash-ledger export, reconciliation schedules and approved cash budget. Covirage maps the columns, and its tools compute and check the cash bridge and budget comparisons; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; creating the account takes about a minute.
See Covirage for finance teams for the supporting finance workflow.
Include the reporting month, opening cash, receipts, payments, closing cash, a bank reconciliation and comparisons with the approved cash budget. Add restrictions and explanations of material differences. Identify the preparer and reviewer so unresolved items have an owner.
A statement balance alone does not explain money already recorded but still clearing, such as outstanding checks or deposits in transit. Reconcile each account to the books, then combine the adjusted balances. Report funds unavailable for general spending separately.
Keep unpaid invoices out of cash receipt and payment totals because they have not settled. Material obligations can appear in a separate upcoming commitments note. Use the organization's accrual financial statements for revenue earned and expenses incurred regardless of payment timing.
The organization's governance arrangements should identify the reviewer, such as a finance director or board finance committee. The person checking the bank reconciliation should have access to its supporting statements and schedules, rather than relying only on the treasurer's narrative.