Blog · Finance metrics and formulas · Finance and FP&A teams
Cash flow analysis explains where business cash came from and where it went. Compare operating, investing and financing movements, reconcile profit with cash and trace changes back to receipts, payments and working capital.
Cash flow analysis explains where a company's cash came from, where it went and why the pattern changed. Separate operating, investing and financing activity, prove the change against cash balances, then investigate the transactions behind it. A higher bank balance alone does not show that operations improved.
Use completed periods with the same entity scope, currency and cash definition. Gather the cash ledger or cash-flow statement, opening and closing cash balances, and the bank reconciliations supporting those balances. Keep transaction dates, account codes, counterparties, amounts and activity classifications in the export.
Exclude transfers between included bank accounts from company receipts and payments. Retain the evidence of the transfer so both sides can be matched. Investigate duplicate rows and unmapped account codes before summarizing; a correct formula cannot repair an incomplete cash population.
If a statement column is year to date, extract the period you want before comparing it with a single month or quarter. The cash flow by quarter guide covers that extraction. Keep actual cash movements distinct from invoice and expense recognition dates.
The SEC's cash-flow statement guide groups movements into operating, investing and financing activities and reconciles the net change to beginning and ending cash.
| Activity | Business question | Typical supporting file |
|---|---|---|
| Operating | Did ordinary trading generate cash? | Customer receipts, supplier payments, payroll and tax cash records |
| Investing | What long-term assets were bought or sold? | Fixed-asset purchases and disposal receipts |
| Financing | What cash came from or went to capital providers? | Loan draws, principal repayments and owner transactions |
Use the classifications approved by the controller. Do not classify all payments to a supplier as operating: the same supplier might sell inventory and production equipment. For more detail on long-term asset movements, use cash flow from investing.
An illustrative Pennsylvania distributor has the following reconciled cash movements for April and May 2026. Receipts are positive and payments negative. The company has no exchange-rate effects or other cash reconciliation items. All figures are USD and exact, with no rounding.
| Ledger group | Activity | April (USD) | May (USD) |
|---|---|---|---|
| Customer collections | Operating | 1,000,000 | 1,120,000 |
| Supplier payments | Operating | -650,000 | -790,000 |
| Payroll and other operating payments | Operating | -230,000 | -240,000 |
| Cash income taxes | Operating | -20,000 | -25,000 |
| Equipment purchases | Investing | -150,000 | -40,000 |
| Equipment disposal receipts | Investing | 0 | 10,000 |
| Loan proceeds | Financing | 200,000 | 0 |
| Loan principal repayments | Financing | -30,000 | -25,000 |
| Net cash movement | 120,000 | 10,000 |
Place this table in A1:D10, with the transaction groups in rows 2 through 9. In a separate summary, compute operating cash for April and May:
=SUMIFS(C2:C9,B2:B9,"Operating")
=SUMIFS(D2:D9,B2:B9,"Operating")
Replace the criterion with "Investing" or "Financing" for the other activity totals. Microsoft's SUMIFS documentation describes how the function sums values matching specified criteria. These formulas use Excel syntax. Covirage is not affiliated with Microsoft.
| Summary | April (USD) | May (USD) | May less April (USD) |
|---|---|---|---|
| Operating cash flow | 100,000 | 65,000 | -35,000 |
| Investing cash flow | -150,000 | -30,000 | 120,000 |
| Financing cash flow | 170,000 | -25,000 | -195,000 |
| Net cash movement | 120,000 | 10,000 | -110,000 |
The activity totals explain the apparent contradiction. April's cash increase depended on financing. May generated less operating cash, but lower equipment spending reduced the investing outflow. A single net-cash number hides both facts.
Ending cash = Beginning cash + Operating cash flow + Investing cash flow + Financing cash flow + Other reconciliation items
April begins with $300,000. Adding its $120,000 movement produces $420,000. May begins with that same $420,000 and adds $10,000, ending at $430,000.
Put beginning cash in C12 and the independently reconciled ending balance in C13. With April's signed rows above, this check must equal zero:
=C12+SUM(C2:C9)-C13
Copy the check to May. If a real statement includes exchange-rate effects or a cash-scope reconciliation, include those lines explicitly. Do not add a balancing amount to operating cash. The combined movement must also equal $430,000 less $300,000, or $130,000: April's $120,000 plus May's $10,000.
May's operating cash fell by $35,000. The transaction table gives the bridge: collections increased by $120,000, supplier payments increased by $140,000, payroll and other payments increased by $10,000, and taxes increased by $5,000. Those changes sum to negative $35,000.
Next ask why supplier payments grew faster than collections. Separate purchase volume, price, inventory accumulation and payment timing. A payment catch-up is different from a permanent cost increase, although both consume cash now.
Use the profit and balance-sheet exports as a second check. May has these approved reconciliation amounts, with no other noncash adjustments or operating balance changes:
| May profit-to-cash bridge | Cash adjustment (USD) |
|---|---|
| Net income | 90,000 |
| Add depreciation | 20,000 |
| Subtract increase in receivables | -40,000 |
| Subtract increase in inventory | -25,000 |
| Add increase in supplier payables | 20,000 |
| Operating cash flow | 65,000 |
The bridge reconciles to the direct receipts-and-payments result. Rising receivables and inventory absorbed cash, while the increase in payables provided a timing benefit. These are explanations of the $65,000 already measured; subtracting them again from that amount would count their effect twice.
Finance owns the reconciliation. Credit and collections own overdue customer actions; procurement and operations explain supplier and inventory movements; treasury explains borrowing and repayments. Assign each material difference to the person who can verify its cause.
Bring your cash ledger, statements and supporting working-capital schedules to Covirage. Covirage maps the columns; its tools compute and check the activity totals and differences, and the external AI model explains the cash drivers with every figure traced to its rows. Create a free Covirage account and bring a sample of your own files.
See Covirage for finance teams, then use your verified historical patterns to inform a cash flow forecast.
Start with cash-flow statements, bank-reconciled cash balances and the cash ledger for matching periods. Add receivables aging, inventory movements, supplier payables and debt schedules when you need to explain changes beyond the statement's activity totals.
Yes. Borrowing, owner contributions or asset sales can increase cash while operations generate less. Read each activity separately and identify the source of the increase before treating a stronger ending balance as evidence of stronger operating performance.
Analysis explains cash that already moved and tests the reasons for changes across completed periods. A forecast estimates future receipts, payments and balances using stated assumptions. Historical analysis supplies evidence for those assumptions, but it does not establish future collection dates.
Revenue may be earned before customers pay, inventory may be purchased before sale, and supplier balances may change. Noncash charges also affect profit. A reconciliation identifies these timing and accounting differences instead of assuming profit is available cash.