Blog · Board and management reporting · Finance and FP&A teams
A cash management report reconciles company bank accounts and shows whether upcoming payments can be funded. Build a liquidity review from bank, ledger, receivables and payment exports with worked checks and spreadsheet formulas.
A cash management report reconciles company cash and tests whether dated receipts can cover upcoming payments. Start with bank and ledger balances, explain the differences, then separate usable funds from restricted or uncleared amounts. A positive month-end forecast is insufficient if payroll falls due before the expected collections arrive.
List the legal entity, bank account, currency and balance timestamp. This example uses only USD accounts for one US company, so no currency translation is required. Keep other entities separate until treasury confirms that funds can be transferred between them.
The report should answer which accounts can pay, what remains unreconciled, and when the company approaches its minimum cash balance. Assign the bank reconciliation to accounting and settlement assumptions to treasury, with collection dates confirmed by receivables owners.
The SBA's finance guidance identifies available cash, bank reconciliation, receivables and payables among the responsibilities businesses need to manage. This report connects those responsibilities in one dated review. It complements the broader management reporting package, which also explains performance and financial position.
Bring bank transaction exports, ledger cash-account detail, outstanding payment lists and deposit records. Give every reconciling item a reference, date, amount and owner. Deposits in transit below have been recorded in the books but have not reached the bank; outstanding payments have reduced the books but have not cleared the bank.
Adjusted bank = Statement balance + Deposits in transit − Outstanding payments
Adjusted books = Book balance + Unrecorded bank credits − Unrecorded bank charges
The IRS reconciliation guidance explains that bank charges and uncleared deposits or checks can cause differences, and that adjusted bank and book balances should agree.
At the close of October 23, 2026, the company's accounts show:
| Account | Bank balance (USD) | Deposits in transit (USD) | Outstanding payments (USD) | Adjusted bank (USD) | Books before fees (USD) | Unrecorded fees (USD) | Adjusted books (USD) |
|---|---|---|---|---|---|---|---|
| Operating | 250,000 | 18,000 | 32,000 | 236,000 | 236,400 | 400 | 236,000 |
| Payroll | 70,000 | 0 | 0 | 70,000 | 70,000 | 0 | 70,000 |
| Reserve | 120,000 | 0 | 0 | 120,000 | 120,000 | 0 | 120,000 |
| Total | 440,000 | 18,000 | 32,000 | 426,000 | 426,400 | 400 | 426,000 |
Place headers in row 1, with account names in A and the remaining columns in B through H. Enter these formulas in E2 and H2, then copy down:
=B2+C2-D2
=F2-G2
Check each account with =E2-H2 and the combined total with =SUM(E2:E4)-SUM(H2:H4). Both must return zero. Accounting must review and post the supported bank fees; the report itself does not change the ledger.
The reserve account includes $40,000 unavailable under a contractual restriction. The $18,000 deposit in transit is also unavailable at the cutoff. These are distinct constraints: one concerns permitted use, the other settlement timing.
| Liquidity bridge | Amount (USD) |
|---|---|
| Reconciled book cash | 426,000 |
| Less restricted balance | -40,000 |
| Less deposit still in transit | -18,000 |
| Usable cash after reserving outstanding payments | 368,000 |
This $368,000 already reserves the $32,000 of outstanding payments through the reconciliation. Do not subtract those payments again when they clear. A bank's displayed available balance may use a different treatment of holds and pending transactions, so compare its definition with this report's basis.
Use expected settlement dates from collection confirmations and approved payment files. Invoice due dates are useful evidence, but they do not establish that a customer will pay on that date. The cash management and receivables review covers that collection question in more detail.
Treasury expects the transit deposit to become usable on October 26. The schedule starts with $368,000, includes that release once, and excludes the already-reserved outstanding payments.
| Date | Event | Change in usable funds (USD) | Running usable cash (USD) |
|---|---|---|---|
| October 23 | Opening usable funds | 0 | 368,000 |
| October 26 | Transit deposit becomes usable | 18,000 | 386,000 |
| October 26 | Customer collections | 125,000 | 511,000 |
| October 27 | Payroll settlement | -180,000 | 331,000 |
| October 28 | Supplier payment run | -72,000 | 259,000 |
| October 29 | Customer collections | 45,000 | 304,000 |
| October 30 | Tax payment | -38,000 | 266,000 |
With changes in column C and running balances in D, enter =D2+C3 in D3 and copy down. The transit release changes availability; it is not another receipt in the books. All example amounts are whole dollars without rounding.
Assume treasury sets a minimum usable balance of $250,000. Headroom is =D3-250000, copied down. The lowest projected balance is $259,000, leaving $9,000 above that minimum. If the October 29 collection slips beyond the horizon, closing usable cash becomes $221,000, or $29,000 below the minimum.
That timing change calls for a specific response: confirm collection, adjust discretionary payment timing where allowed, or arrange approved funding. Consolidated sufficiency also needs an account check; funds sitting in reserve do not pay payroll until the required transfer settles.
Keep the petty cash report as a separate custody reconciliation, then include its actual cash balance consistently in any wider company cash total.
Upload your bank and cash-ledger exports with expected receipt and payment rows. Covirage maps the columns, and its tools compute and check the balance bridges and dated movements; 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.
The cash flow statement explains historical cash changes under a financial reporting framework. A cash management report supports near-term treasury decisions, often by account and payment date. It includes reconciliation items, restrictions and expected settlements that a historical statement does not present as a payment schedule.
Show undrawn facilities separately from bank cash. A facility may provide additional funding capacity, but access can depend on conditions, borrowing limits and notice periods. Treasury should confirm those terms before treating a draw as a dated receipt in the projection.
Match the update frequency to payment activity and liquidity risk. A company with large daily settlements may review cash every business day. Keep a fixed cutoff for each version and refresh expected dates when collections or payment approvals change.
They affect each account's ability to make payments, so keep both sides in the account view. At the consolidated company level, eliminate matched internal transfers. A transfer does not create customer receipts or external spending merely because it appears on two statements.