Quarterly vs year-to-date numbers in a 10-Q
A 10-Q presents financial numbers in two columns: one for the quarter, one for year-to-date. This dual presentation confuses many investors. A Q2 10-Q shows results for April–June (the quarter) and April–June-plus-January-through-March (year-to-date). Which number should you use to assess performance? How do you compare quarters without double-counting? This article demystifies the structure and shows you how to extract the truth from a 10-Q's two-column format.
Quick definition: A 10-Q presents an income statement in two columns: one for the quarter (three months) and one for year-to-date (fiscal year start through the current quarter). The balance sheet is presented at quarter-end and at the prior fiscal year-end. The cash flow statement is year-to-date only. Understanding which is which is essential to avoid misinterpreting results.
Key takeaways
- The 10-Q income statement and balance sheet are presented side-by-side: the quarter column shows just three months, while the year-to-date column shows cumulative results.
- For the balance sheet, there are only two columns: quarter-end (current) and prior fiscal year-end (a point in time, not cumulative).
- The cash flow statement in a 10-Q is presented year-to-date only; there is no separate quarterly cash flow statement.
- To calculate a single quarter's cash flow, subtract the prior quarter's year-to-date total from the current quarter's year-to-date total.
- Comparing quarter-to-quarter revenue requires careful subtraction: Q2 revenue equals YTD revenue through Q2 minus YTD revenue through Q1.
- Many investors mistakenly add a quarter's revenue to get annual revenue without understanding that YTD revenue already includes all prior-quarter revenue.
- The balance sheet shows only two time periods (quarter-end and prior year-end), never quarter-to-quarter snapshots. This can make quarter-to-quarter balance sheet changes look larger than they are.
- Understanding the dual-presentation format is critical to avoid errors in growth rates, margins, and trend analysis.
The dual presentation: income statement
The income statement in a 10-Q is presented in two columns:
| Item | Three Months Ended June 30, 2024 (Quarterly) | Six Months Ended June 30, 2024 (Year-to-Date) |
|---|---|---|
| Revenue | $100 million | $180 million |
| Cost of goods sold | $60 million | $105 million |
| Gross profit | $40 million | $75 million |
| Operating expenses | $20 million | $38 million |
| Operating income | $20 million | $37 million |
In this example:
- Quarterly column: Q2 alone (April–June) generated $100 million in revenue and $20 million in operating income.
- Year-to-date column: The first half of the fiscal year (January–June, assuming a January 1 fiscal year-start) generated $180 million in revenue and $37 million in operating income.
The quarterly column tells you what happened in the latest three months. The year-to-date column tells you what has happened since the start of the fiscal year through the end of the current quarter. Neither is wrong; they answer different questions.
Deriving prior-quarter numbers
Suppose you want to know Q1 results (January–March). The 10-Q does not give you a separate Q1 column. But you can derive it by subtraction:
Q1 Revenue = YTD Revenue (Q2) minus YTD Revenue (Q1) Q1 Revenue = $180 million − (YTD-through-Q1) = $180 million − $80 million = $100 million
This assumes the Q1 10-Q (or the annual 10-K) showed YTD revenue of $80 million through the end of Q1. By comparing the Q2 10-Q's YTD total to the Q1 10-Q's YTD total, you extract Q2-only revenue.
This is a critical investor skill. Every time you read a 10-Q, you should:
- Note the quarterly revenue (e.g., $100 million in Q2).
- Note the year-to-date revenue (e.g., $180 million through Q2).
- Calculate the implied Q1 revenue by subtraction: $180 − Q1 YTD.
- Compare Q1 to Q2 on a like-for-like quarterly basis.
Without this exercise, you might see "YTD revenue of $180 million" and think the company earned $180 million in one quarter, which is false—it earned that amount over two quarters, or an average of $90 million per quarter.
How to compare quarter-to-quarter
Here's the right way to build a quarter-by-quarter comparison:
From the Q1 10-Q (filed May 2024):
- Q1 YTD Revenue (through March 31): $80 million
From the Q2 10-Q (filed August 2024):
- Q2 Quarter Revenue (April–June): $100 million
- Q2 YTD Revenue (through June 30): $180 million
Calculation:
- Q1 Revenue (derived): $80 million (stated in Q1 10-Q as YTD)
- Q2 Revenue (derived): $180 million − $80 million = $100 million
- Q-o-Q growth: (100 − 80) / 80 = 25% quarter-over-quarter growth
Alternatively, you could use the quarterly column directly:
- Q2 Revenue (from quarterly column in Q2 10-Q): $100 million
- But to compare to Q1, you need Q1's quarterly number, which requires subtraction from the Q1 10-Q's YTD total.
The most efficient approach is to use the quarterly column for the current quarter (Q2 = $100 million) and derive prior quarters by subtraction.
The balance sheet: two time periods only
The balance sheet in a 10-Q is simpler than the income statement, but it trips up many investors.
The 10-Q balance sheet shows:
- Left column: Assets, liabilities, and equity at the end of the current quarter (e.g., June 30, 2024).
- Right column: Assets, liabilities, and equity at the end of the prior fiscal year (e.g., December 31, 2023).
There is no separate "three months ago" column. The balance sheet is a snapshot at a point in time, not an accumulation like the income statement.
| Item | June 30, 2024 (Q2 End) | December 31, 2023 (Fiscal Year End) |
|---|---|---|
| Cash | $50 million | $60 million |
| Accounts receivable | $80 million | $70 million |
| Total assets | $500 million | $480 million |
| Total liabilities | $300 million | $290 million |
| Shareholders' equity | $200 million | $190 million |
This shows the balance sheet at quarter-end versus the prior fiscal year-end. To understand what happened in Q1 or Q2, you have to infer from the change between these two points.
Change in cash Q1–Q2: You cannot see Q1 ending cash directly in the Q2 10-Q. However, if the Q1 10-Q showed cash of $55 million at March 31, then you know:
- Cash at March 31 (Q1 end): $55 million
- Cash at June 30 (Q2 end): $50 million
- Q2 change in cash: $50 − $55 = −$5 million (a $5 million decrease in Q2)
To track balance sheet movements quarter-to-quarter, you must piece together data from consecutive 10-Qs.
The cash flow statement: year-to-date only
The cash flow statement in a 10-Q is presented in one format: year-to-date (from fiscal year-start through the current quarter).
| Item | Six Months Ended June 30, 2024 (YTD) |
|---|---|
| Operating cash flow | $50 million |
| Investing cash flow | −$20 million |
| Financing cash flow | −$10 million |
| Net change in cash | $20 million |
This tells you that over the first six months, the company generated $50 million in operating cash flow. There is no separate "Q2 only" cash flow statement.
To derive Q2 cash flow, you subtract: Q2 CFO = YTD-through-Q2 CFO minus YTD-through-Q1 CFO
If the Q1 10-Q showed YTD operating cash flow of $25 million (through March 31), then: Q2 Operating Cash Flow = $50 million − $25 million = $25 million
This is similar to deriving quarterly revenue, but cash flow statements force you to do the arithmetic every time.
Why the dual presentation can mislead
Many investors make mistakes because they do not keep the dual presentation in mind:
Mistake 1: Adding all four quarters' "yearly" results. An investor reads Q1 revenue of $80 million, Q2 revenue of $100 million, Q3 revenue of $110 million, and Q4 revenue of $120 million (from the 10-K). They add them: $410 million for the year. This is correct, but only if they are using the quarterly column consistently. If they accidentally mixed year-to-date from one period and quarterly from another, they'd overcount.
Mistake 2: Comparing YTD to quarterly carelessly. An investor sees "YTD revenue of $180 million" and thinks, "That's only $90 million per quarter, below last year's average." But the $90 million per quarter is an average of the full half-year, not a single quarter's figure. Q2 alone might be $100 million, which is above average.
Mistake 3: Forgetting the balance sheet is a snapshot, not cumulative. An investor sees accounts receivable increase from $70 million (year-end) to $80 million (Q2 end) and worries that receivables are growing too fast. But they do not know if receivables were $85 million at the end of Q1 (falling in Q2) or $60 million (rising every quarter). Without the Q1 10-Q for reference, they cannot tell.
Mistake 4: Assuming the cash flow statement covers only the quarter. An investor reads "Operating cash flow: $50 million" in a 10-Q without realizing it is the six-month YTD total, not a quarterly number. They think operating cash flow is higher than it actually is on a quarterly basis ($25 million per quarter, if evenly split).
How to organize 10-Q data for analysis
To avoid confusion, create a simple spreadsheet:
| Item | Q1 YTD (from Q1 10-Q) | Q2 YTD (from Q2 10-Q) | Q2 Quarterly (Derived) |
|---|---|---|---|
| Revenue | $80M | $180M | $100M |
| Operating Income | $15M | $37M | $22M |
| Operating Cash Flow | $25M | $50M | $25M |
By organizing data this way, you keep both the cumulative (YTD) and single-period (quarterly) numbers visible and can compare accurately.
For the balance sheet, create a separate table:
| Item | March 31 Q1 | June 30 Q2 | YoY (Dec 31 Prior Year) |
|---|---|---|---|
| Cash | $55M | $50M | $60M |
| A/R | $75M | $80M | $70M |
| Total Assets | $490M | $500M | $480M |
This format makes quarter-to-quarter balance sheet changes explicit.
Real-world example
TechCorp files its Q2 10-Q on August 1:
From Q2 10-Q (ended June 30, 2024):
- Q2 Revenue (quarterly column): $150 million
- Q2 YTD Revenue (year-to-date column): $280 million
You want to know Q1 revenue. You find the Q1 10-Q (filed May 1) and note:
- Q1 YTD Revenue: $130 million
Calculation:
- Q1 Revenue: $130 million (from Q1 10-Q YTD column)
- Q2 Revenue: $280 million − $130 million = $150 million
Comparison:
- Q1 Revenue: $130 million
- Q2 Revenue: $150 million
- Q-o-Q growth: (150 − 130) / 130 = 15.4%
Without doing this work, you might read only the Q2 10-Q and see $150 million in Q2 revenue, thinking that was a strong quarter. But comparing it to Q1's $130 million shows 15% growth—valuable context.
Common mistakes
Mistake 1: Misunderstanding "year-to-date" in a Q3 10-Q. Year-to-date in a Q3 10-Q means fiscal year-start through September 30, not just the last three months. An investor might see "YTD operating income: $60 million" in a Q3 10-Q and think that Q3 alone was $60 million, but it's actually the sum of Q1 + Q2 + Q3.
Mistake 2: Forgetting to adjust for fiscal year changes. If a company changes its fiscal year-end mid-year, the YTD numbers in one 10-Q might cover a different period than the prior 10-Q. This is rare but can wreak havoc on comparisons.
Mistake 3: Comparing a balance sheet at quarter-end to an unrelated point. The Q2 10-Q balance sheet is at June 30. The 10-K balance sheet is at December 31. These are six months apart, so comparing them directly can be misleading. Always know the dates.
Mistake 4: Using averaged quarterly numbers as fact. If YTD revenue is $180 million over six months, the average is $90 million per quarter. But Q1 might have been $70 million and Q2 might have been $110 million. Never assume evenness; extract actual quarters by subtraction.
Mistake 5: Forgetting that the cash flow statement is always YTD in a 10-Q. An investor reads "Operating cash flow: $50 million" and thinks that is Q2's cash flow. It's actually H1's (six months') total. Always subtract prior-period YTD from current-period YTD to isolate the quarter.
FAQ
Q: Why does the 10-Q show both quarterly and year-to-date on the income statement?
A: Investors care about both. The quarterly column shows the latest three months' performance (momentum); the year-to-date column shows cumulative performance and helps you isolate prior quarters by subtraction.
Q: How do I calculate annual revenue if I only see quarterly and YTD numbers?
A: If the company has filed Q1, Q2, and Q3 10-Qs, derive each quarter, add them, and add Q4 from the 10-K. Example: Q1 + Q2 + Q3 + Q4 = Annual.
Q: Can I compare the Q3 10-Q balance sheet directly to the Q2 10-Q balance sheet?
A: Not without doing work. The Q3 10-Q balance sheet shows June 30 and December 31 (year-end prior year). The Q2 10-Q shows March 31 and December 31. You cannot directly compare a balance sheet from two 10-Qs unless you note the different dates.
Q: If the Q2 10-Q shows YTD revenue of $180 million, is that revenue from January–June?
A: Only if the company's fiscal year starts in January. If the fiscal year starts in April, then "YTD through June 30" means April–June, and the number would be smaller. Always check the fiscal year-end when interpreting YTD numbers.
Q: Why is the cash flow statement only year-to-date and not quarterly?
A: The SEC format for 10-Qs presents cash flow as YTD only. This is because cash flow is driven by many timing factors that swing month-to-month, and a quarterly number alone might be misleading. Investors are expected to derive quarterly cash flow by subtraction.
Q: How do I know what the prior quarter's YTD number was?
A: Look at the prior quarter's 10-Q. If you're reading a Q3 10-Q, look at the Q2 10-Q to find the YTD-through-Q2 number. Then subtract it from the Q3 YTD to get Q3's quarterly result.
Related concepts
- Year-to-Date (YTD): Cumulative results from the start of the fiscal year through the current date.
- Quarterly Results: Results for a single three-month period (Q1, Q2, Q3, or Q4).
- Quarter-over-Quarter (Q-o-Q) Growth: Percentage change from one quarter to the next.
- Year-over-Year (Y-o-Y) Growth: Percentage change from the same quarter in the prior year.
- Balance Sheet Snapshot: A point-in-time picture of assets, liabilities, and equity as of a specific date.
- Fiscal Year: The 12-month period a company uses for financial reporting, which may or may not align with the calendar year.
Summary
The dual presentation of quarterly and year-to-date figures in a 10-Q is not a design flaw—it's an intentional feature. The quarterly column shows the latest performance; the year-to-date column allows you to derive prior quarters and understand cumulative results. The balance sheet, by contrast, shows only two snapshots: quarter-end and prior year-end, requiring you to compare with prior quarters' 10-Qs to see progression. The cash flow statement is year-to-date only, and deriving quarterly cash flow requires subtraction from prior 10-Qs.
To read a 10-Q correctly, you must understand the format. Keep a spreadsheet handy where you track both YTD and quarterly numbers, note the specific dates, and always ask: "Is this figure quarterly, year-to-date, or a balance-sheet snapshot?" Answering that question will save you from costly misinterpretations of growth rates, margins, and trends.
Next
Learn how the unaudited nature of 10-Qs affects their reliability and how to think about audit status when assessing financial data.