Monthly business review: agenda, metrics and decisions

A monthly business review turns closed financial results and operating measures into decisions with named owners. Start with reconciled actuals against an agreed budget, investigate the largest differences, and end with actions that can be checked at the next review.

The meeting is company-wide. Sales, delivery, operations, and finance need to explain how their results fit together, including where one department's apparent improvement creates a problem elsewhere.

Start with one period and one version of the plan

Use the general-ledger export after the monthly close, the approved budget by department, and operating exports covering the same dates. Record the extract date, reporting currency, budget version, and any late adjustments. Label an unfinished close explicitly rather than comparing provisional figures with a final plan.

For a fictional US services and products company, the example covers September 2026 in USD. The review measures revenue less the operating costs included in its management pack. This is an internal operating result; it is not net income, and the team must document any excluded expenses.

Both the Actual and Budget worksheets have these columns: A, month; B, department; C, line type; and D, amount in USD. Month is stored consistently as text such as 2026-09. Revenue and cost amounts are positive, with their type in column C. Map accounts to departments once, and retain any unassigned balance for resolution.

If the sales team needs its own account and pipeline detail, use the narrower monthly sales report before this meeting. Bring its conclusions into the company review.

Build the department comparison

On a Summary worksheet, put the reporting month in K1 and department names in A2:A4. Columns B through E hold budget revenue, actual revenue, budget cost, and actual cost. Enter these formulas in B2 through H2, respectively, then fill down:

=SUMIFS(Budget!$D$2:$D$999,Budget!$A$2:$A$999,$K$1,Budget!$B$2:$B$999,$A2,Budget!$C$2:$C$999,"Revenue")
=SUMIFS(Actual!$D$2:$D$999,Actual!$A$2:$A$999,$K$1,Actual!$B$2:$B$999,$A2,Actual!$C$2:$C$999,"Revenue")
=SUMIFS(Budget!$D$2:$D$999,Budget!$A$2:$A$999,$K$1,Budget!$B$2:$B$999,$A2,Budget!$C$2:$C$999,"Cost")
=SUMIFS(Actual!$D$2:$D$999,Actual!$A$2:$A$999,$K$1,Actual!$B$2:$B$999,$A2,Actual!$C$2:$C$999,"Cost")
=C2-B2
=E2-D2
=F2-G2

Microsoft documents SUMIFS as summing amounts that meet multiple criteria. Extend every range together if the export runs beyond the stated rows.

Every gap is actual minus budget. Higher revenue improves the result; higher cost reduces it. Product spent $15,000 less than budget but still delivered a $45,000 unfavorable operating result gap. Calling that department favorable because spending fell would miss the business issue. Use variance analysis when a gap needs a deeper breakdown.

Prove the total before explaining it

Budget operating result is $900,000 minus $700,000, or $200,000. Actual operating result is $870,000 minus $708,000, or $162,000. Their difference is negative $38,000.

The department gaps must produce the same result:

=SUM(H2:H4)-((SUM(C2:C4)-SUM(E2:E4))-(SUM(B2:B4)-SUM(D2:D4)))

That check returns zero. Independently tie actual revenue and cost to the closed management accounts and budget totals to the approved plan. A zero mathematical check does not prove that missing departments were included.

Then bring in the operating evidence:

With budget activity in B2 and actual activity in C2 on a separate worksheet, enter the activity gap in D2 and percentage gap in E2:

=C2-B2
=IFERROR(C2/B2-1,"Review denominator")

Percentages are rounded to one decimal place. Microsoft's IFERROR documentation explains how to return an alternative value when a formula errors. Review that flag; an absent budget is not zero growth. Covirage is not affiliated with Microsoft.

Orders and revenue both fell for Product. That is an investigation lead, not proof that volume alone explains the result. Check realized price, product mix, returns, and cost timing before choosing a response. Never total orders and hours together.

Use an agenda that ends with decisions

Distribute the checked comparison before the meeting. Ask each owner for the recorded driver, the evidence still missing, and the decision needed. The meeting should test explanations rather than collect first impressions.

For Product, the sales leader could own a review of uncompleted orders before the next planning update. The operations leader should confirm whether delivery capacity or customer timing constrained completion. Record their findings separately from any proposed spending change.

Use the monthly business review template for the pack layout. Reserve the broader quarterly business review for decisions that need a longer horizon.

Where it goes wrong

• Changing the comparator. Replacing the approved budget with a recent outlook hides the original commitment. Show each separately.
• Calling every underspend favorable. A cost reduction may accompany missed revenue or unfinished work. Read costs alongside output and service obligations.
• Mixing close dates. A late invoice can move revenue without changing delivered work. Keep timing adjustments visible.
• Leaving actions vague. A department name is not an accountable owner. Record a person, a due date, and the evidence that will close the action.

Prepare your monthly review on your own files

Bring the budget, closed actuals, and matching operating export to Covirage. Covirage maps the columns; its tools compute and check department comparisons, and 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; creating the account takes about a minute.

See Covirage for finance teams for the supporting reporting context.