Blog · Board and management reporting · Finance and FP&A teams
Compare cash flow by quarter using discrete operating, investing and financing movements. Extract quarters from year-to-date statements, reconcile them to annual totals and separate seasonal patterns from changes in cash performance.
Cash flow by quarter measures the cash generated or used during each separate quarter, rather than the cumulative movement since the year began. Extract the discrete amounts first, reconcile them, then compare matching fiscal quarters. Otherwise, a growing year-to-date total can look like improving cash performance when the latest quarter actually weakened.
Start with the cash-flow statement export and the prior year's comparable statements. Record the entity, currency, units, fiscal-year start and period end alongside every column. Preserve whether the source is discrete, year to date or full year.
For US Form 10-Q reporting, Regulation S-X, Rule 10-01(c)(3) generally calls for cash-flow statements from the end of the preceding fiscal year through the latest fiscal quarter, with the corresponding prior-year period. A column headed six months ended is therefore not a second-quarter-only amount.
Private company management packs can use a different presentation. Read the heading rather than inferring the period from the file name. A calendar-year company and a company with a different fiscal year also need different quarter labels.
Keep actual-quarter extraction separate from predicting future cash. The cash flow forecast guide covers the latter; these steps analyze completed periods.
Discrete quarter = Current year-to-date cash flow - Previous quarter's year-to-date cash flow
Fourth quarter = Full-year cash flow - Nine-month cash flow
The first quarter already equals year to date. Apply the subtraction separately to operating, investing and financing activities, retaining negative signs for outflows.
An illustrative US seasonal distributor provides this calendar-year statement export. The full-year column plays the role of the final cumulative amount. All amounts are USD, and all calculations below are exact with no rounding.
| Statement row | Q1 YTD (USD) | Q2 YTD (USD) | Q3 YTD (USD) | Full year (USD) |
|---|---|---|---|---|
| Operating cash flow | 120,000 | 300,000 | 690,000 | 1,000,000 |
| Investing cash flow | -100,000 | -260,000 | -340,000 | -500,000 |
| Financing cash flow | 200,000 | 150,000 | 0 | -60,000 |
Place this table in A1:E4. Put a second table's quarter headings in G1:J1 and enter these operating formulas in G2, H2, I2 and J2, respectively:
=B2
=C2-B2
=D2-C2
=E2-D2
Fill down through row 4. The resulting discrete quarters are:
| Cash movement | Q1 (USD) | Q2 (USD) | Q3 (USD) | Q4 (USD) | Full year (USD) |
|---|---|---|---|---|---|
| Operating | 120,000 | 180,000 | 390,000 | 310,000 | 1,000,000 |
| Investing | -100,000 | -160,000 | -80,000 | -160,000 | -500,000 |
| Financing | 200,000 | -50,000 | -150,000 | -60,000 | -60,000 |
| Net cash movement | 220,000 | -30,000 | 160,000 | 90,000 | 440,000 |
The third quarter's operating cash is $690,000 less $300,000, or $390,000. It is not $690,000. Fourth-quarter operating cash is $1,000,000 less $690,000, or $310,000.
For each activity, the sum of the discrete quarters must equal the annual total. On the worksheet above, this operating check must return zero:
=SUM(G2:J2)-E2
Then add operating, investing and financing cash vertically in every quarter. The SEC's statement-of-cash-flows primer explains those activity groups and the reconciliation from beginning cash through net movement to ending cash.
For this example, there are no exchange-rate effects or other cash reconciliation items. Beginning cash is $500,000:
| Cash roll-forward | Q1 (USD) | Q2 (USD) | Q3 (USD) | Q4 (USD) |
|---|---|---|---|---|
| Beginning cash | 500,000 | 720,000 | 690,000 | 850,000 |
| Net cash movement | 220,000 | -30,000 | 160,000 | 90,000 |
| Ending cash | 720,000 | 690,000 | 850,000 | 940,000 |
Annual movement is $440,000, matching $940,000 less $500,000. In a real export, preserve any exchange-rate or other reconciliation line and use the statement's cash definition consistently. Do not force a difference into operating cash.
The distributor's prior-year operating cash figures, already extracted into discrete quarters, show why consecutive-quarter movement is not enough:
| Operating cash comparison | Q1 (USD) | Q2 (USD) | Q3 (USD) | Q4 (USD) | Full year (USD) |
|---|---|---|---|---|---|
| Prior year | 150,000 | 210,000 | 360,000 | 360,000 | 1,080,000 |
| Current year | 120,000 | 180,000 | 390,000 | 310,000 | 1,000,000 |
| Current less prior | -30,000 | -30,000 | 30,000 | -50,000 | -80,000 |
The current third quarter improved by $30,000 against its seasonal counterpart. Full-year operating cash nevertheless fell by $80,000. Neither finding cancels the other. Ask collections and procurement owners to explain the quarter-specific differences through dated customer receipts, inventory purchases and supplier payments.
The investing comparison answers a separate question: when did the business deploy capital? Financing shows how it funded the pattern. Use the broader cash flow analysis method to investigate underlying drivers after quarter extraction. If the change followed an approved operating decision, incremental cash flow analysis isolates the with-and-without difference.
Bring the current and prior-year cash-flow statement files, with their period headings, to Covirage. Covirage maps the columns; its tools compute and check the period differences, and 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 statements.
See Covirage for finance teams for analysis across your financial exports.
Check its period heading. A quarterly report commonly presents cash flows from the start of the fiscal year through the reporting date. That means a later report can contain several quarters of cash movement rather than one discrete quarter.
Subtract the first nine months' year-to-date cash flows from the full fiscal year's cash flows, line by line. Use the same reporting scope and latest comparable figures, including revisions, before treating the difference as the fourth quarter.
Use both for different questions. Consecutive quarters show the immediate movement in funding and liquidity. Comparing the same fiscal quarter across years better controls for recurring seasonal patterns, although payment dates, acquisitions and calendar differences still need review.