Quarterly vs Year-to-Date Results: How to Reconcile the Numbers
Avoid double-counting quarterly results: reconcile Q1, H1, nine-month and annual financial statements, handle cash flows correctly and flag incompatible reporting bases.
Quarterly and year-to-date financial statements can be reconciled by subtracting compatible cumulative flows, not by adding every published number together. Revenue, profit and cash flows cover periods; cash and debt balances describe a position at a date.
Confusing those two ideas is an easy way to create a spreadsheet that calculates perfectly and describes the business incorrectly.
Indian financial reports commonly place quarter, cumulative and annual columns beside one another. The column heading is part of the data. An analyst who captures the value but loses its period has not captured the financial fact.
For the accounting context, ICAI’s educational material on Ind AS 34 explains interim reporting and its presentation periods. The worked examples below are original hypothetical calculations, not actual results for a company.
Build a period map before calculating growth
For an April-to-March financial year, label the periods explicitly. Q1 covers April through June, H1 covers April through September, nine months covers April through December, and the full year covers April through March.
These labels should be stored alongside company, reporting basis, currency, units, filing date and source. Consolidated and standalone results are not two interchangeable versions of the same number. Neither are ₹ lakh and ₹ crore.
Do not infer a period solely from the date printed at the top of a PDF. A September-end document may contain a three-month result, a six-month result and a balance sheet at the same date.
A revenue example that reconciles exactly
Assume the company reports these compatible cumulative revenue values:
| Observation | Covered period | Hypothetical revenue |
|---|---|---|
| Q1 | April to June | ₹100 crore |
| H1 | April to September | ₹230 crore |
| Nine months | April to December | ₹390 crore |
| Full year | April to March | ₹600 crore |
Derive the missing quarters from differences:
| Quarter | Calculation | Derived revenue |
|---|---|---|
| Q1 | Directly reported | ₹100 crore |
| Q2 | ₹230 − ₹100 | ₹130 crore |
| Q3 | ₹390 − ₹230 | ₹160 crore |
| Q4 | ₹600 − ₹390 | ₹210 crore |
Now verify the identity: ₹100 + ₹130 + ₹160 + ₹210 = ₹600 crore. Adding the original cumulative observations would instead produce ₹1,320 crore, a meaningless total with repeated months.
Keep the derived label. A quarter obtained from subtraction is not a separately filed quarterly observation, even when the arithmetic is sound. If a direct quarter is also available, reconcile the two and investigate material differences.
Cash flows need the same discipline
Suppose operating cash flow is ₹30 crore for H1 and ₹45 crore for the first nine months. The third-quarter contribution is ₹15 crore if definitions and scope match.
It is not ₹75 crore. Adding H1 and nine-month figures counts April through September twice.
If Q1 cash flow was not disclosed, H1 cash flow cannot tell you the split between Q1 and Q2. Do not divide it equally just to populate a quarterly chart. The correct state is that the individual-quarter values are unavailable.
This matters when comparing profit with cash generation. A quarterly PAT figure and six-month operating cash flow do not share a denominator period. Align their windows before calculating a cash-conversion measure. Our cash-flow statement guide covers the interpretation after the periods are aligned.
Balance sheets are snapshots
A September-end cash balance of ₹80 crore and a December-end balance of ₹90 crore are not cumulative flows. Their difference is a ₹10 crore change in the balance, but that does not by itself equal operating cash flow.
Similarly, adding quarterly closing debt balances does not produce annual borrowings. A bridge between balances needs the relevant flows, classifications and other movements.
Keep stock and flow measures separate in the data model. Analysts often recognize this distinction in principle and then violate it when automated exports place every metric into the same quarterly table.
EPS is not a simple subtractable flow
Revenue in a cumulative period can be additive under consistent definitions. EPS is a ratio with a share denominator, not merely another income-statement amount.
If shares were issued, bought back or affected by corporate actions, the weighted-average share count can differ across the quarter and cumulative period. Diluted EPS introduces further denominator and earnings adjustments.
Consequently, subtracting H1 EPS from nine-month EPS is not a general-purpose way to derive Q3 EPS. Reconcile the underlying earnings and the applicable share basis, or use the company’s directly reported quarter. Label any calculation and retain the denominator evidence.
Restatements can break apparently obvious identities
Suppose the original Q1 revenue was ₹100 crore, but a later filing restates Q1 to ₹105 crore while reporting H1 at ₹230 crore. Subtracting the original Q1 gives ₹130 crore; using the compatible revised Q1 gives ₹125 crore.
Both subtractions are arithmetic. Only the latter describes the stated revised basis in this example.
Store filing vintages, not just period-end dates. A latest-view analysis can use revised history consistently. A historical investment test must not pretend the revised value was known before its publication. That distinction is central to point-in-time research.
A five-check release gate for the worksheet
Before updating a financial model, verify period coverage, consolidated-versus-standalone basis, units and currency, accounting definitions, and compatible filing vintages. Then reconcile the annual total against quarters and investigate exceptions rather than overwriting them to force agreement.
March-quarter differences can reflect year-end adjustments, reclassifications or changed scope. A residual is a research question, not necessarily a data error. A tolerance for rounding should be explicit and should never excuse a material mismatch.
Keep both raw reported observations and labelled derivations. Attach the exact source to the figure, not merely a generic investor-relations homepage.
Where Altys fits
Altys’s source-linked research and exportable outputs are useful when analysts need to inspect periods, assumptions and evidence in a spreadsheet. The platform is part of the checking workflow, not a reason to stop checking. Missing observations should remain unavailable rather than being replaced by zero or an AI estimate.
Once the periods reconcile, build a revenue-growth bridge and use the quarterly-results checklist to separate what changed from what matters. Request Altys access to explore a verifiable workflow from reported data to model updates and monitoring.
Frequently asked questions
How do you derive Q2 revenue from half-year results?
Subtract Q1 revenue from first-half revenue only when both observations have matching scope, basis, currency, units and accounting definitions. Use compatible restated figures where applicable and label the result as derived.
Can you add half-year and nine-month cash flows?
No. Both are cumulative from the financial-year start, so adding them double-counts overlapping months. Derive a quarter by subtracting compatible cumulative periods if both are available.
Can quarterly EPS be derived by subtracting YTD EPS?
Not safely as a general rule. EPS uses a weighted-average share denominator that can differ between periods, with additional rules for diluted EPS. Reconcile earnings and shares rather than subtracting EPS values mechanically.