Blog · Board and management reporting · Finance and FP&A teams
Quarterly reporting combines reconciled monthly results into a business review against plan and prior periods. Follow a workbook method for quarter and year-to-date totals, weighted margins, checks and action owners.
Quarterly reporting turns reconciled monthly results into a review of the quarter and year to date against plan and comparable periods. Build it from the monthly exports, recalculate the ratios, and connect each material difference to a decision and an owner. The method below is for an internal business review.
Write the quarter's opening and closing dates on the workbook. Confirm the fiscal calendar, included entities, reporting currency and version of the budget. A fiscal quarter need not follow calendar months, so use the company's approved period dates throughout.
Keep the latest forecast in a separate column if management wants it. Replacing the original budget hides whether the company delivered the plan it approved. For the recurring monthly workflow beneath this review, use management reporting.
Distinguish activity from balances. Revenue and expenses accumulate through the quarter; closing cash and receivables describe a date. The SEC's financial statement guide makes this distinction between income statement periods and balance sheet snapshots. Adding monthly closing cash balances would not produce quarterly cash.
Export reconciled actual results, the approved monthly budget and the corresponding prior-year periods. Retain period date, entity, department, account, amount and source reference. Apply the same account mapping to every comparison.
The following inputs are from an illustrative US equipment distributor. Operating profit is already reconciled to its monthly income statement. The first row carries the closed first-quarter totals; the remaining rows are the months being assembled into the second quarter. All financial columns are USD.
| Period | Revenue actual (USD) | Revenue plan (USD) | Revenue prior year (USD) | Operating profit actual (USD) | Operating profit plan (USD) | Operating profit prior year (USD) |
|---|---|---|---|---|---|---|
| First-quarter total | 1,300,000 | 1,300,000 | 1,200,000 | 270,000 | 260,000 | 230,000 |
| April | 460,000 | 480,000 | 420,000 | 90,000 | 96,000 | 75,000 |
| May | 480,000 | 500,000 | 450,000 | 100,000 | 100,000 | 90,000 |
| June | 560,000 | 520,000 | 480,000 | 130,000 | 104,000 | 90,000 |
Do not mix that first-quarter subtotal into the monthly source sheet. Subtotals are useful for presentation but become duplicate activity if they sit beside the transactions being summed.
For a detailed Excel sheet named Monthly, put period-end dates in column A, actual revenue in B, plan revenue in C, prior-year revenue aligned to the current period in D, and the corresponding operating profit amounts in E through G. Keep H2 as the quarter start and I2 as the exclusive end date, the day after quarter end.
Actual quarterly revenue is:
=SUMIFS(Monthly!B2:B1000,Monthly!A2:A1000,">="&$H$2,Monthly!A2:A1000,"<"&$I$2)
Use the same boundaries for every financial column. Microsoft documents SUMIFS as adding values that meet multiple criteria. To calculate year to date, replace H2 with the fiscal year's opening date; keep the quarter's exclusive end date.
The supplied inputs produce:
| Measure | Second quarter actual (USD) | Second quarter plan (USD) | Second quarter prior year (USD) | Year-to-date actual (USD) | Year-to-date plan (USD) | Year-to-date prior year (USD) |
|---|---|---|---|---|---|---|
| Revenue | 1,500,000 | 1,500,000 | 1,350,000 | 2,800,000 | 2,800,000 | 2,550,000 |
| Operating profit | 320,000 | 300,000 | 255,000 | 590,000 | 560,000 | 485,000 |
The first proof is addition: April through June revenue equals $1,500,000. Add the first-quarter $1,300,000 and year-to-date revenue equals $2,800,000. Perform the same check for profit and each comparison column.
Put actual, comparison, difference and percentage difference in separate columns. With actual in B2 and comparison in C2:
=B2-C2
=IF(C2=0,"Not comparable",B2/C2-1)
Use the percentage formula only where the comparison base makes business sense. A negative profit base needs an explanation rather than a conventional growth label.
| Comparison | Calculation | Result |
|---|---|---|
| Revenue against previous quarter | 1,500,000 / 1,300,000 - 1 | 15.4% |
| Revenue against same quarter last year | 1,500,000 / 1,350,000 - 1 | 11.1% |
| Year-to-date revenue growth | 2,800,000 / 2,550,000 - 1 | 9.8% |
| Actual quarterly operating margin | 320,000 / 1,500,000 | 21.3% |
| Planned quarterly operating margin | 300,000 / 1,500,000 | 20.0% |
Percentages are rounded to one decimal after calculation. Divide total profit by total revenue; do not average monthly margins. The gross profit margin example explains the same weighting principle at the gross profit level.
Revenue met plan: $1,500,000 less $1,500,000 equals $0 variance. Operating profit exceeded plan by $320,000 less $300,000, or $20,000. Ask the cost owners to identify the expense lines behind the difference before calling it a lasting improvement. Record whether each explanation is supported, still being checked or dependent on a later posting.
Set a refresh cadence for the underlying measures so the package clearly distinguishes closed financial results from operating figures still being updated.
Bring your monthly actuals, budget and prior-period export to Covirage; it maps the columns, and its tools compute and check the quarter and year-to-date comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; account creation takes about a minute.
See Covirage for finance teams for the supporting reporting context. Covirage is not affiliated with Microsoft.
Include the reporting period, reconciled financial results, a small set of operating measures, plan and prior-period comparisons, and year-to-date totals. Explain the largest differences with supporting rows. End with decisions, action owners and dates rather than an unexplained collection of charts.
Use both when they answer different questions. The previous quarter shows recent movement, while the same quarter last year helps reveal seasonal patterns. Keep the business scope and fiscal dates consistent, and label acquisitions or calendar changes that make either comparison less useful.
Calculate the quarterly margin by dividing total quarterly profit by total quarterly revenue. A simple average gives a small month the same influence as a large month. Keep the original profit and revenue columns so reviewers can rebuild the ratio directly.
Finance normally assembles the package and checks financial totals. Operating teams own the definitions and explanations of their measures. Leadership owns the decisions that follow. Assign one person to each unresolved variance so a reporting meeting produces an action rather than a request for another report.