How to get quarterly revenue from 10-Q filings into Google Sheets
Companies file a quarterly report (the 10-Q) after their first, second and third fiscal quarters. There is no 10-Q for the fourth quarter: the annual 10-K covers it. That one fact causes most of the confusion with quarterly numbers.
Working out the fourth quarter
The fourth quarter is the full year from the 10-K minus the first nine months from the third-quarter 10-Q. Apple's fiscal 2026 (October 2025 to September 2026) shows how the quarters add up to the year:
| Apple fiscal 2026 | Source | Revenue ($ millions) |
|---|---|---|
| Q1 (to 27 Dec 2025) | 10-Q | 143,756 |
| Q2 (to 28 Mar 2026) | 10-Q | 111,184 |
| Q3 (to 27 Jun 2026) | 10-Q | 109,417 |
| Q4 (to 26 Sep 2026) | 10-K minus nine months | 114,477 |
| Full year | 10-K | 478,834 |
Per-share figures such as EPS can't be worked out this way, because the number of shares changes during the year. Use the company's own quarterly earnings release for Q4 EPS.
Cash flow lines are year-to-date
Most companies report cash flow in their 10-Qs only as a year-to-date total. To get one quarter, subtract the previous quarter's year-to-date figure. Apple's operating cash flow for fiscal 2026 Q2 is 28,702 ($ millions): the six-month total minus the first quarter.
With a formula
AsFiled Pro does both calculations and says so in a note:
=FILING("AAPL", "revenue", "2026 Q4")
=FILING("AAPL", "revenue", "2026 Q4", "note")
The first returns 114,477,000,000. The second explains that Q4 is the full year minus nine months. Quarterly numbers need an AsFiled Pro key; there is a ready-made quarterly results tracker template.
Try it without writing anything
Our free Google Sheets templates already contain these formulas. Make a copy, type a ticker, and the numbers fill in.
Free templates · Guides · AsFiled Pro · Terms · Privacy · Refunds · Support
AsFiled is made by Eagle Eye Insights LLC. Numbers come from companies' own filings with the U.S. Securities and Exchange Commission; AsFiled is not affiliated with the SEC.