Blog · Territory, capacity and quota planning · Finance and FP&A teams
Diagnose recurring cash shortfalls by comparing expected and actual movements. Reconcile the cash bridge, identify customer and supplier drivers, and test specific corrective actions against the next payment window.
Cash management problems and solutions become clearer when finance traces a cash shortfall to the receipts and payments that caused it. Reconcile the balance first, compare actual movements with the expected movements, and assign each material difference to an owner who can change its amount or timing.
A lower bank balance does not identify the cause. It may reflect late collections, inventory bought ahead of demand, a supplier catch-up payment, a tax date, or a forecast assumption that was never supported.
Export bank transactions, customer receipts, supplier payments, payroll totals, tax payments, and capital purchases for the same period. Retain transaction ID, settlement date, entity, currency, counterparty, category, and signed cash amount. Compare them with the forecast version that existed before the period began.
Use positive amounts for receipts and negative amounts for payments. Exclude transfers between the included bank accounts from both receipts and payments; otherwise, moving money between accounts inflates activity without changing company cash.
The SBA's financial management guidance calls for managing receivables, payables, available cash, and bank reconciliation. Those records need to connect: a clean payment listing without a bank reconciliation is not yet a proven explanation of the cash balance.
Define the cash boundary before comparing balances. Restricted cash, a separate entity, or an unavailable currency balance may not fund the obligations under review. Apply that boundary consistently to the forecast and actuals.
A US parts distributor reviews one completed week. The table uses exact USD amounts, with no rounding. Put category in column A, expected movements in B, actual movements in C, and the difference in D.
| Cash bridge | Expected (USD) | Actual (USD) | Actual less expected (USD) |
|---|---|---|---|
| Opening cash | 200,000 | 200,000 | 0 |
| Customer receipts | 300,000 | 240,000 | −60,000 |
| Other receipts | 10,000 | 10,000 | 0 |
| Supplier payments | −180,000 | −215,000 | −35,000 |
| Payroll payments | −90,000 | −90,000 | 0 |
| Tax payments | −20,000 | −35,000 | −15,000 |
| Equipment purchases | −40,000 | −40,000 | 0 |
| Closing cash | 180,000 | 70,000 | −110,000 |
Enter the row variance in D2 and fill through D8:
=C2-B2
Calculate expected and actual closing cash in B9 and C9, followed by the reconciliation check:
=SUM(B2:B8)
=SUM(C2:C8)
=SUM(D2:D8)-(C9-B9)
The check returns zero. The $110,000 unfavorable closing variance consists of $60,000 fewer customer receipts, $35,000 more supplier payments, and $15,000 more tax payments. These differences explain the shortfall against the forecast; they do not describe every reason cash changed from the opening balance.
Start with the categories that explain the variance, then inspect their transactions. A category label is a starting point, not a cause.
| Difference | Supporting driver | Unfavorable amount (USD) | Action owner |
|---|---|---|---|
| Customer receipts | Confirmed customer payment arrived late | 40,000 | Collections |
| Customer receipts | Invoice dispute remains unresolved | 20,000 | Sales and credit |
| Supplier payments | Additional inventory bought ahead of demand | 25,000 | Procurement |
| Supplier payments | Previously overdue supplier invoice paid | 10,000 | Accounts payable |
| Tax payments | Payment date was earlier than forecast | 15,000 | Tax and treasury |
| Total explained | 110,000 |
The customer rows total $60,000 and the supplier rows total $35,000. Combined with taxes, they agree with the bridge. A delayed receipt needs a new supported date; an invoice dispute needs resolution. Calling both "slow collections" would obscure the different actions.
For a transaction sheet named Movements, with settlement date in A, category in B, and signed amount in C, aggregate supplier cash over dates stored in H1 and H2:
=SUMIFS(Movements!$C:$C,Movements!$B:$B,"Supplier",Movements!$A:$A,">="&$H$1,Movements!$A:$A,"<="&$H$2)
Microsoft's SUMIFS documentation describes this use of multiple criteria. Preserve the signed amounts so larger payments produce a more negative total. Covirage is not affiliated with Microsoft.
Use the receivables collection workflow for invoice-level payment timing. Review working capital when inventory purchases repeatedly run ahead of collections. Do not count the inventory balance increase as another cash outflow after the supplier payments have already been included.
Management's stated operating buffer is $100,000. The completed week closes at $70,000, leaving a $30,000 gap to that internal threshold. Corrective actions belong in the forward view; they cannot revise historical cash.
The following week begins with that $70,000. Collections obtains evidence that the delayed $40,000 will arrive during the week. Procurement and a supplier agree to move $20,000 of scheduled payments to a later date.
| Next week's bridge | Baseline (USD) | With supported actions (USD) |
|---|---|---|
| Opening cash | 70,000 | 70,000 |
| Customer receipts | 160,000 | 200,000 |
| Supplier payments | −110,000 | −90,000 |
| Payroll payments | −60,000 | −60,000 |
| Closing cash | 60,000 | 120,000 |
The actions improve the projected close by $60,000. The baseline is $40,000 below the buffer; the revised close is $20,000 above it. Check daily settlement dates as well: a positive closing balance does not prove payroll can be paid before the week's collections arrive.
Carry the deferred supplier amount into the later payment window. The 13-week cash flow layout supports that wider view, while a cash management report can track the recurring drivers and named owners.
Bring your cash transaction export, forecast comparison, and customer or supplier schedules to Covirage. Covirage maps the columns, its tools compute and check the variances and supplied balances, and the external AI model explains the drivers with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See FP&A reporting for the supporting reporting context.
Revenue can be recognized before customers pay, while inventory and supplier payments consume cash before the related sales are collected. Debt repayments and equipment purchases also use cash differently from income statement expenses. Reconcile cash movements rather than treating profit as spendable cash.
Confirm that the opening and closing balances agree with reconciled bank records for the same accounts and dates. Then compare actual receipts and payments with the forecast. A missing account, duplicate transfer, or posting cutoff problem can otherwise look like an operating shortfall.
Only where terms or an explicit agreement permit it and the operational consequences are understood. A delay moves an obligation into a later period rather than removing it. Test that later payment alongside expected collections before treating the change as a sustainable improvement.