Earnings Release Workpaper: Flux Analysis, Talking Points and Tie-out
Prepares and supports the quarterly earnings release and call: quarter-over-quarter and year-over-year flux with explanation thresholds, talking points tied back to the flux, and a tie-out of every release figure to the 10-Q / 10-K draft, the call script and the Template 09 non-GAAP reconciliation – plus the Item 2.02 Form 8-K date.
Tab structure
- Instructions
- Setup (with workpaper header) – plus release date and time, call date, listing exchange and filing due date; derives the Item 2.02 Form 8-K date (four business days after the release) and the current, prior and prior-year quarter labels
- Summary & Tie-out
- Flux – current quarter vs prior quarter and prior-year quarter, plus YTD vs prior YTD; $ and % changes against the Setup thresholds; driver explanation and talking-point reference
- Talking Points – each key message with the flux line it relies on, the workpaper amount, the figure as stated in the script, a tie, non-GAAP and forward-looking flags, reconciliation location and IR / Legal review
- Release Tie-out – every figure in the release vs the filing draft, the call script and Template 09
- Judgments
- Completeness & Controls
- Open Items
- Sign-offs & Refs
- Tickmarks
- Lists
- Holidays
Built on the common workpaper framework – see the templates overview.
Key checks and flags
- Flux lines over the $ or % threshold read EXPLAIN until a driver explanation is entered
- Every talking point traces to a flux line, and the figure as stated must agree to the workpaper amount
- Release figures tie to the 10-Q / 10-K draft, the call script and Template 09 (per-share amounts to the cent)
- Non-GAAP figures in the script need a reconciliation location – in the release or on the website for the call (Regulation G)
- Forward-looking statements need cautionary language; each talking point needs IR / Legal review
- Item 2.02 Form 8-K date calculated four business days after the release, with holidays; release-after-filing order is flagged
Who uses it
SEC reporting, FP&A and investor relations preparing the quarterly earnings release, the call script and the Item 2.02 Form 8-K.
Primary sources
Previews
Rendered from the actual workbook with illustrative sample data ("Example Company, Inc.", period end December 31, 2026). Scroll sideways on small screens.
Flux
Flux tab: quarter-over-quarter and year-over-year changes with thresholds, flags and drivers.
Release Tie-out
Release Tie-out tab: each release figure tied to the filing draft, call script and Template 09.