Blog · Finance metrics and formulas · Finance and FP&A teams
A net working capital schedule reconciles monthly operating assets and liabilities and shows the cash absorbed or released. Build it from balance-sheet and subledger exports, with exact spreadsheet formulas, component rollforwards and a cash reconciliation.
A net working capital schedule reconciles operating balances month by month and explains the cash absorbed or released by their movement. Build it from dated balance-sheet and supporting exports, retain a consistent account scope, and connect each closing balance to the next month's opening balance. The proof is both a balance reconciliation and a movement reconciliation.
The general working capital definition is current assets minus current liabilities. This schedule uses a narrower operating scope: trade receivables plus inventory minus trade payables. Cash and financing balances are excluded, and the example has no other operating current accounts.
The SEC's financial statements guide distinguishes balance-sheet snapshots from cash flows over a period. It also explains that operating cash flow adjusts earnings for noncash items and changes in operating assets and liabilities. That distinction is why the schedule needs both balances and movements.
Collect month-end ledger balances, receivable aging, inventory valuation and payable aging for each reporting date. Add invoice, collection, purchase and payment exports to explain movements. Keep account codes, entity, currency, reporting date and source reference in the working file. Convert currencies consistently before combining entities.
Consider a US industrial distributor's first quarter of 2026. All balances below are USD. Receivable allowances are unchanged, and there are no acquisitions, foreign-currency effects, write-downs or other noncash movements in the operating accounts.
| Account or calculation | December 31, 2025 (USD) | January 31, 2026 (USD) | February 28, 2026 (USD) | March 31, 2026 (USD) |
|---|---|---|---|---|
| Trade receivables | 400,000 | 450,000 | 480,000 | 460,000 |
| Inventory | 500,000 | 550,000 | 520,000 | 540,000 |
| Trade payables | 250,000 | 280,000 | 300,000 | 290,000 |
| Operating NWC | 650,000 | 720,000 | 700,000 | 710,000 |
| Change in operating NWC | — | 70,000 | −20,000 | 10,000 |
| Cash effect | — | −70,000 | 20,000 | −10,000 |
Use row 1 for the headers, rows 2–4 for the balances, row 5 for operating NWC, row 6 for its change and row 7 for the cash effect. Column B is December and column C is January. Enter these formulas in the January column and fill across:
C5: =SUM(C2:C3)-C4
C6: =C5-B5
C7: =-C6
Calculate opening NWC in B5 with =SUM(B2:B3)-B4. January's closing NWC becomes February's opening NWC without a manual re-entry.
For aggregation, assume the Raw tab has month-end dates in A, account categories in B and positive balance amounts in C. The date headings must be spreadsheet dates, and the account labels must match the source categories. In C2:
=SUMIFS(Raw!$C$2:$C$10000,Raw!$A$2:$A$10000,C$1,Raw!$B$2:$B$10000,$A2)
Fill across and down through the operating account rows. Microsoft's SUMIFS documentation explains how the function sums rows meeting multiple criteria. Keep liabilities positive for this layout because row 5 subtracts payables. Covirage is not affiliated with Microsoft.
January's supporting registers produce these rollforwards. All inventory purchases are on credit, and the payment figure covers those inventory suppliers.
| Component | Opening (USD) | Addition (USD) | Reduction (USD) | Closing (USD) |
|---|---|---|---|---|
| Receivables | 400,000 | Credit sales: 900,000 | Collections: 850,000 | 450,000 |
| Inventory | 500,000 | Purchases: 670,000 | Cost of goods sold: 620,000 | 550,000 |
| Payables | 250,000 | Credit purchases: 670,000 | Supplier payments: 640,000 | 280,000 |
Each line follows opening plus addition less reduction equals closing. With this second table in A1:E4 on a separate worksheet and numeric amounts in B:D, E2 is:
=B2+C2-D2
Enter the numbers without the explanatory text in the addition and reduction cells. Put the descriptions in adjacent notes. Fill the formula down, then compare the result with the month-end schedule.
The receivables aging must total $450,000, the inventory valuation $550,000 and the supplier aging $280,000. Each must also tie to its corresponding ledger balance. Investigate differences before drawing conclusions about cash.
If receivables move because invoices were delayed, examine the booking-to-invoice cycle separately; activity waiting to be invoiced may sit outside this trade-receivable scope.
The component changes provide an independent check of row 6:
| Period | Receivable change (USD) | Inventory change (USD) | Payable change (USD) | NWC change (USD) | Cash effect (USD) |
|---|---|---|---|---|---|
| January | 50,000 | 50,000 | 30,000 | 70,000 | −70,000 |
| February | 30,000 | −30,000 | 20,000 | −20,000 | 20,000 |
| March | −20,000 | 20,000 | −10,000 | 10,000 | −10,000 |
| Quarter | 60,000 | 40,000 | 40,000 | 60,000 | −60,000 |
Receivable change plus inventory change less payable change must equal NWC change. The monthly changes also telescope: $70,000 minus $20,000 plus $10,000 equals $60,000, matching March NWC of $710,000 less December NWC of $650,000.
The $60,000 cash use is one piece of the cash bridge. Suppose the quarter's other source figures are opening cash of $180,000, net income of $240,000, depreciation of $30,000, capital spending of $90,000 and net financing outflows of $20,000. There are no other reconciling items. Closing cash is:
$180,000 + $240,000 + $30,000 − $60,000 − $90,000 − $20,000 = $280,000
Tie that result to the closing cash ledger. If other operating accounts exist, include their movements before expecting the bridge to reconcile.
Upload your monthly operating balances with the supporting actuals and any prepared plan; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains the movements with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See financial planning and reporting for the related reporting workflow.
Use the accounts covered by the schedule's stated purpose. An operating schedule often includes trade receivables, inventory, prepayments, trade payables and operating accruals, while excluding cash and financing balances. Preserve the mapping so every month uses the same scope.
Receivables and inventory represent resources the business has not yet converted to cash, while supplier credit funds part of that investment. When operating assets rise more than operating liabilities, the business absorbs cash, after separating noncash movements and other reconciling items.
No. The schedule reconciles balances and their changes. A cash forecast also needs the dates and amounts of receipts, payments, investing activity and financing activity. Working capital movements provide one input, rather than the complete cash picture.
Keep actual and prepared plan amounts in separate columns or clearly labeled rows, with the same account mapping and month-end dates. Reconcile actuals to the ledger first, then compare balances and cash effects without overwriting either version.