Blog · Board and management reporting · Finance and FP&A teams
Use a monthly business review template to connect budget, actual results, operating measures and decisions. This reusable layout includes worked tables, spreadsheet formulas, reconciliation checks and an action register for finance and department owners.
A monthly business review template connects actual results with budget, operating performance and actions that someone owns. Build it from closed exports, reconcile the totals, then explain the differences that require a decision. Use one set of checked tables across the spreadsheet, written review and presentation.
The layout below works for a fictional US distributor reviewing September 2026. Its purpose is a cross-functional review; the monthly sales report template covers the more detailed sales-only view.
| Section | Columns or fields | Example entry | Completion check |
|---|---|---|---|
| Reporting scope | Period, cut-off, currency, included departments | September 2026; closed ledger; USD | Every table uses the same period |
| Financial scorecard | Measure, budget, actual, difference, difference % | Revenue and departmental costs | Reconciles to approved budget and ledger |
| Operating scorecard | Measure, numerator, denominator, result, owner | On-time orders / shipped orders | Counts tie to the shipment export |
| Variance explanation | Measure, evidence, cause status, decision needed | Revenue below plan; customer detail under review | Evidence supports the explanation |
| Action register | Action, owner, due date, completion evidence | Review freight charges | Named person accepts the action |
Add the report preparer and approval date to the cover. If the cut-off changes after circulation, update the tables and label the new version. The broader monthly business review guide covers how to run the meeting; this page supplies the layout to populate.
Use separate, identifiable versions of the approved budget and posted actuals. Each export needs period, department, account or reporting measure, version and amount. Map accounts consistently before grouping them, and document how credits and expense signs are handled.
In the worked table, expenses are positive amounts. Difference means actual minus budget for every row. A positive cost difference is unfavorable, so explain the sign rather than coloring every positive number green.
Place measure in column A, budget in B, actual in C, difference in D and difference percentage in E. Start the first data row at row 2.
| Worksheet row | Measure | Budget (USD) | Actual (USD) | Difference (USD) | Difference % | Calculation |
|---|---|---|---|---|---|---|
| 2 | Revenue | 250,000 | 240,000 | -10,000 | -4.00% | Sum mapped revenue rows |
| 3 | Product cost | 150,000 | 148,000 | -2,000 | -1.33% | Sum mapped product-cost rows |
| 4 | Gross profit | 100,000 | 92,000 | -8,000 | -8.00% | Revenue - product cost |
| 5 | Sales and marketing | 20,000 | 22,000 | 2,000 | 10.00% | Sum mapped department rows |
| 6 | Operations | 30,000 | 31,000 | 1,000 | 3.33% | Sum mapped department rows |
| 7 | General and administrative | 25,000 | 24,000 | -1,000 | -4.00% | Sum mapped department rows |
| 8 | Operating profit within scope | 25,000 | 15,000 | -10,000 | -40.00% | Gross profit - rows 5 through 7 |
This example includes only the displayed cost categories. It does not represent a complete GAAP income statement. Use your company's approved mapping for a formal management P&L; the profit and loss statement template provides a dedicated layout.
For an Excel table named Inputs containing both versions, total actual revenue for the review month as follows:
=SUMIFS(Inputs[Amount],Inputs[Period],DATE(2026,9,1),Inputs[Measure],$A2,Inputs[Version],"Actual")
Use the same formula with "Budget" for the budget column. Store Period as the first calendar date of each month, not a mixture of dates and text. Microsoft's SUMIFS documentation explains the multiple-criteria calculation.
Calculate gross profit with =B2-B3 in B4 and =C2-C3 in C4. Calculate operating profit with =B4-SUM(B5:B7) in B8 and =C4-SUM(C5:C7) in C8. In D2, calculate the dollar difference:
=C2-B2
In E2, calculate the percentage difference:
=IF(B2=0,"N/A",D2/ABS(B2))
Copy D2 and E2 through row 8. Format E as a percentage with two decimal places. Keep full precision in the cells; displayed rounding should not alter totals.
A cross-functional review needs enough operational evidence to test the financial story. Show counts behind percentages so a department owner can challenge both the definition and the result.
| Measure | Budget inputs | Actual inputs | Budget result | Actual result | Owner |
|---|---|---|---|---|---|
| Shipped orders | 250 orders | 240 orders | 250 | 240 | Operations |
| On-time shipment rate | 240 on-time / 250 shipped | 228 on-time / 240 shipped | 96.00% | 95.00% | Operations |
| Gross margin | 100,000 / 250,000 (USD) | 92,000 / 240,000 (USD) | 40.00% | 38.33% | Finance |
For this review, on-time means shipped by the promised ship date. It is not an on-time delivery measure. Keep the promised-date rule fixed, and count each order once; a shipment-line export needs grouping to order before counting.
If an Orders table has one row per order, Ship month is the first date of the month, and On time contains Yes or No:
=COUNTIFS(Orders[Ship month],DATE(2026,9,1))
=COUNTIFS(Orders[Ship month],DATE(2026,9,1),Orders[On time],"Yes")
The first formula produces shipped orders; the second produces the on-time numerator. Microsoft documents that COUNTIFS counts entries meeting all specified criteria. Divide the second result by the first, with an explicit no-orders check.
The scorecard establishes that revenue missed budget by $10,000 while total displayed costs stayed flat: budget costs are 150,000 + 20,000 + 30,000 + 25,000 = $225,000; actual costs are 148,000 + 22,000 + 31,000 + 24,000 = $225,000. Operating profit therefore fell by $10,000.
That identity proves the bridge. It does not explain why revenue missed. Lower shipped orders and a weaker shipment rate are observations to investigate, not proof that delays caused the revenue shortfall.
| Issue | Evidence now available | Next action | Owner | Due date | Completion evidence |
|---|---|---|---|---|---|
| Revenue below budget | Scorecard and customer sales export | Separate customer volume and price differences | Sales director | October 8, 2026 | Reconciled customer bridge |
| Operations cost above budget | Department ledger detail | Review freight and temporary labor entries | Operations director | October 9, 2026 | Documented cost explanation |
| On-time shipment rate below plan | Order counts and promised ship dates | Review late orders by reason | Fulfillment manager | October 9, 2026 | Checked exception list |
Use the same tables in a document for commentary and in slides for discussion. Keep the spreadsheet as the calculation record. For the longer planning horizon, use the quarterly business review approach rather than extending this monthly pack without revisiting its questions.
Covirage is not affiliated with Microsoft.
Bring the departmental budget, actuals and relevant operating exports. Covirage maps the columns, and its tools compute and check the actual-versus-plan figures; the external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See analytics for finance teams for applying those checked figures to a recurring business review.
Include the reporting scope, actual-versus-budget results, operating measures that explain performance, material variances and decisions requiring approval. End with an action register containing owners, due dates and evidence of completion. Keep the source totals and reconciliation results available alongside the review.
Use a spreadsheet for the calculations and checks. A document can hold the written explanation, while slides can display the few comparisons needed for discussion. Keep the same definitions and cut-off across formats so the presentation does not become a separate set of figures.
Finance typically assembles the consolidated view and checks financial totals. Department owners validate their operating measures, explain differences and propose actions. A designated business leader approves the decisions and resolves conflicts between departmental priorities.
Show the dollar difference and label the percentage as not applicable when budget is zero. A percentage variance would require division by zero. Ask the owner whether the spending was approved separately, miscoded or absent from the original budget.