Blog · Board and management reporting · Finance and FP&A teams
Working capital reporting explains monthly changes in receivables, inventory and payables by business unit. Build a movement bridge from reconciled balance exports, identify the responsible teams, and distinguish balance changes from confirmed cash effects.
Working capital reporting explains how receivables, inventory and payables changed during the month, by business unit and responsible team. Start with reconciled opening and closing balances, calculate the movement, and investigate the transactions behind it. A useful report shows where funds became tied up and what someone will do next.
The SEC's financial statement guide defines working capital as current assets minus current liabilities. This monthly operating review uses the narrower subtotal of trade receivables plus inventory minus trade payables. Label it operating working capital so readers do not confuse it with the full balance-sheet measure.
The working capital formula guide covers the broader definition and cycle calculations. Here, keep the focus on monthly movement and accountability. State whether receivables and inventory are gross or net of allowances, and use the same basis at both dates.
Take month-end receivables aging, inventory valuation and payables aging exports for both dates, plus the ledger control balances. Retain business unit, account or component, currency, reporting date and balance. Use transaction detail only after the balance comparison identifies where an explanation is needed.
An illustrative US distributor compares August 31 with September 30, 2026. All balances are in USD on the same reporting basis. The simplified example has no intercompany balances, acquisitions, currency effects or noncash adjustments.
Put this table on a sheet named Balances, starting in A1. Columns C and D are opening and closing balances; E is closing minus opening.
| Business unit | Component | Opening (USD) | Closing (USD) | Change (USD) |
|---|---|---|---|---|
| East | Receivables | 120,000 | 135,000 | 15,000 |
| East | Inventory | 80,000 | 92,000 | 12,000 |
| East | Payables | 70,000 | 76,000 | 6,000 |
| West | Receivables | 90,000 | 84,000 | -6,000 |
| West | Inventory | 60,000 | 58,000 | -2,000 |
| West | Payables | 50,000 | 47,000 | -3,000 |
In E2, fill down:
=D2-C2
Store payables as positive balances here, then subtract them when calculating operating working capital. An increase in payables reduces the amount funded by the company; a decrease has the opposite effect.
On a Review sheet, put East and West in A2 and A3. Columns B, C and D will hold opening operating working capital, closing operating working capital and the change. The opening formula in B2 is:
=SUMIFS(Balances!$C$2:$C$7,Balances!$A$2:$A$7,$A2,Balances!$B$2:$B$7,"Receivables")+SUMIFS(Balances!$C$2:$C$7,Balances!$A$2:$A$7,$A2,Balances!$B$2:$B$7,"Inventory")-SUMIFS(Balances!$C$2:$C$7,Balances!$A$2:$A$7,$A2,Balances!$B$2:$B$7,"Payables")
For closing balances in C2, use the same formula with Balances!$D$2:$D$7 as each sum range. Set D2 to =C2-B2, then fill the formulas down. Microsoft's SUMIFS instructions document summing rows that meet multiple criteria, such as a unit and a balance component.
| Business unit | Opening operating working capital (USD) | Closing operating working capital (USD) | Increase / decrease (USD) |
|---|---|---|---|
| East | 130,000 | 151,000 | 21,000 |
| West | 100,000 | 95,000 | -5,000 |
| Total | 230,000 | 246,000 | 16,000 |
East's opening balance is $120,000 plus $80,000 minus $70,000, or $130,000. Its movement is $15,000 plus $12,000 minus $6,000, or $21,000. West releases $5,000 on the same basis, leaving a company increase of $16,000. No rounding is needed for these whole-dollar figures.
The first check adds the business units: $21,000 minus $5,000 equals $16,000. The second check builds the company movement from its components:
| Component | Opening (USD) | Closing (USD) | Change (USD) | Effect on operating working capital (USD) |
|---|---|---|---|---|
| Receivables | 210,000 | 219,000 | 9,000 | 9,000 |
| Inventory | 140,000 | 150,000 | 10,000 | 10,000 |
| Payables | 120,000 | 123,000 | 3,000 | -3,000 |
| Net effect | 16,000 |
The component effect is $9,000 plus $10,000 minus $3,000. It must equal $246,000 minus $230,000. Reconcile the component totals to each subledger and then to the ledger at both dates; a matching net movement can conceal offsetting errors.
East is the first review priority because its increase exceeds West's release. Open its receivables detail by customer and invoice, its inventory detail by item, and its payables detail by supplier. Distinguish late collections from higher current billing, and excess stock from inventory deliberately purchased for confirmed demand.
For every material item, record the supported cause, owner, due date and expected next movement. Investigate billing delays separately through the booking-to-invoice cycle. A report of balances cannot show the time lost before an invoice exists.
Use working capital days when growth makes dollars difficult to compare, and working capital turnover for the relationship to sales. Those measures support this review rather than replacing the reconciled balance bridge.
Covirage is not affiliated with Microsoft.
Upload your balance exports as a file or Google Sheet; Covirage maps the columns, and its tools compute and check the business unit comparisons. The external AI model explains the results with every figure traced to its rows, supporting the discussion of movements and responsibilities. Create a free Covirage account and bring a sample of your own data.
See FP&A reporting for the supporting finance workflow.
Include opening and closing balances for receivables, inventory and trade payables, their movements, the resulting operating working capital change and reconciliation exceptions. Add an explanation, responsible manager and next action for material movements, supported by the relevant transaction exports.
An increase generally indicates more funds tied up in operating balances, but the balance change alone does not prove a cash movement. Currency translation, write-offs, acquisitions and reclassifications can change balances without the corresponding operating cash effect. Reconcile those items separately.
Finance assembles and reconciles the report. Credit and collections explain receivables, operations or purchasing explains inventory, and accounts payable explains supplier balances. Business unit leaders own the operating actions, while treasury uses the confirmed cash implications in liquidity planning.
Yes, when balances can be assigned consistently and the unit has meaningful responsibility for them. Keep centrally held balances separate, identify intercompany items, and reconcile the unit totals to the company view. Avoid allocating cash or debt merely to fill a table.