Guides

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 2026SourceRevenue ($ millions)
Q1 (to 27 Dec 2025)10-Q143,756
Q2 (to 28 Mar 2026)10-Q111,184
Q3 (to 27 Jun 2026)10-Q109,417
Q4 (to 26 Sep 2026)10-K minus nine months114,477
Full year10-K478,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.

See the templates

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.