Quarters and Half-Years, Reported the Way They Were Actually Filed
Interim filings get treated as annual reporting's rough draft. Here is how quarterly and half-year data should be extracted, verified, and turned into TTM figures.
By The Rexfin team
Annual filings get the careful treatment: full audit, a signed opinion, a format everyone’s tooling expects. Interim filings (Q1, half-year, nine-month) tend to get treated as the rough draft in between, something to eyeball rather than actually process properly. That is a strange gap, because most people tracking a business day to day are not waiting for the annual report. They are living on the quarterly trend and the trailing-twelve-month number, and if your tools only understand annual audited filings, that is exactly where the blind spot sits.
Interim filings are not smaller annual filings
The first thing that goes wrong when annual-shaped logic gets pointed at an interim filing is the assurance label. An annual report is audited. An interim report is typically reviewed (a materially lighter standard, reported under ISRE 2410), and treating the two as interchangeable overstates how much scrutiny the numbers actually got. Rexfin reads the audit grade off what the review report itself says, rather than assuming “reviewed” or “audited” by default, so a half-year figure is never quietly presented with more confidence than its own auditor gave it.
The second problem is the face of the statement itself. A half-year or nine-month filing often prints four columns side by side: the discrete three-month period, its prior-year comparative, the year-to-date figure, and its comparative. Grab the wrong column and a quarter’s number gets mislabeled as a half-year YTD figure, or vice versa. Rexfin only extracts the printed year-to-date column, and checks it against the span banner printed above it, something like “six-month period ended,” before trusting it. If the label and the header don’t agree, that column is refused rather than shipped mislabeled.
Building quarters and TTM without inventing numbers
Companies print YTD figures, not always discrete quarters, so a Q2 number often does not exist on the page at all: it has to be derived as H1 minus Q1. Rexfin treats that arithmetic as exactly that: downstream calculation, never a fabricated atom pretending to be a printed figure. The same logic builds trailing-twelve-month views (last full year, minus last year’s year-to-date, plus this year’s year-to-date), and when that calculation mixes periods of different assurance grades, the result is honestly labeled with the weakest grade among its inputs. A TTM built partly from a reviewed-only quarter does not get presented as if every input were audited.
What this gives a finance team
For anyone preparing a quarter-end flash report, feeding numbers into the regular board reporting cycle, or assembling a bank financing pack between annual reviews, this means the quarter-over-quarter and TTM views you are working from actually tie back to what was printed and reviewed, not a smoothed estimate standing in for missing data. Combined with the discipline that carries into monthly close work, it means the interim numbers you show a board or a lender hold up the same way your annual figures do.
The honest limits
Interim segment-level detail (the note-level breakdowns companies sometimes include) is deliberately not extracted yet, because configuration calibrated for full-year statements tends to mislabel three- or six-month figures as annual ones. And a TTM calculation needs the matching prior-year interim filings to actually exist in the corpus; if they are missing, you get an honest gap rather than a filled-in guess.
For more on how finance teams use Rexfin across the reporting calendar, see the finance team use cases hub.
Part of Finance Team Use Cases: Real Workflows on Verified Numbers