Budgeting & Planning

Budget vs. Actuals: The Monthly Variance Review

Run the monthly BvA review in Fintra: the command center, the compare engine across month, quarter, and year, variance commentary, and the exec KPI page.

Updated 9 min read1 labOwner / FounderAccountant

A budget only earns its keep at the monthly review: budget vs. actuals (BvA), line by line, with a human explanation attached to every variance that matters. Fintra’s BvA command center is built around that meeting - the compare engine does the arithmetic across month, quarter, and year, and variance commentary keeps the explanations attached to the numbers they explain.

The BvA command center and compare engine

The command center shows budget, actual, variance ($ and %) per account line. The compare engine drives the columns: pick the period lens and the comparison basis, and the same budget answers different questions.

LensQuestion it answersUse it for
MonthDid this month go to plan?The core monthly review
QuarterIs the quarter on track, netting monthly timing noise?Board and quarterly reviews
Year to dateWhere do we stand against the annual plan?The one number owners actually remember
Full-year (YTD actual + remaining budget)Where will we land if the rest goes to plan?Early-warning for annual targets; the input to reforecasting
Compare engine lenses
  • Variances display in dollars and percent - triage on dollars, diagnose with percent. A 40% variance on a $500 line matters less than 4% on payroll.
  • Drill down from any line to the underlying actual transactions, so "what is in that number" is a click, not an export.
  • Filter by cost center or department to run the same review per team (see Cost Centers & Pivot Reports).

Variance commentary: the explanation layer

Every material variance gets a comment attached to the line and period: what happened, whether it is timing or permanent, and what (if anything) changes because of it. Commentary persists, so the November review can read what you believed in August.

A complete variance comment answers

  • What drove it? (one sentence, business language - "two techs on overtime for the Riverside onboarding", not "wages high")
  • Timing or permanent? Timing washes out next period; permanent changes the full-year landing
  • Action? "None - expected", "shift Q4 marketing", or "reforecast the line"
  • Owner - whose line is this to watch next month

The exec KPI page

The exec KPI page condenses the review for people who will not read a grid: headline KPIs (revenue, gross margin, opex, net income, cash) against budget, with trend and the attached commentary surfaced. It is the artifact you share after the review - the grid is where you work, the KPI page is what leadership reads.

  1. 1Run the review in the command center, writing commentary as you go.
  2. 2Open the exec KPI page for the same period - the numbers and comments carry over.
  3. 3Share it with leadership (or paste it into the board pack) with the full-year lens included.

Hands-on labs

Practice against a realistic scenario. Each lab lists the steps, what you should see, and the checkpoints that confirm you got the same result.

Lab 1

Run Acme’s July BvA meeting

Scenario

July is closed. Acme’s BvA shows: Revenue $184,200 vs. $175,000 budget (+$9,200); Wages $93,100 vs. $87,000 (+$6,100); Supplies $13,300 vs. $10,400 (+$2,900); everything else within $500 of plan. Materiality policy: comment on anything over $1,000 or 10%.

Steps

  1. 1

    Open the BvA command center for July, monthly lens, sorted by absolute dollar variance.

    Expected: Revenue, Wages, and Supplies float to the top; the rest of the grid is quiet.

  2. 2

    Drill into the Revenue line to find the driver.

    Expected: The Riverside Property Group invoices explain the overage - the contract started early.

  3. 3

    Write commentary on all three material lines, tagging each as timing or permanent, with an action and owner.

    Expected: Three comments saved: revenue permanent/favorable, wages timing (ends September), supplies timing (August budget spent in July).

  4. 4

    Switch to the full-year lens.

    Expected: Projected landing shows revenue ~$18k favorable and costs roughly on plan - the annual target is intact.

  5. 5

    Open the exec KPI page for July and confirm the three comments surface with the KPIs.

    Expected: The page shows headline numbers vs. budget with your commentary attached.

  6. 6

    Decide explicitly: does anything here trigger a reforecast?

    Expected: Not yet - one favorable month is a note, not a new plan. Log the decision in the revenue comment.

Checkpoints - you got it right if…

  • Exactly three variance comments written (the materiality policy held)
  • Each comment classifies timing vs. permanent and names an owner
  • Full-year lens reviewed and the annual landing stated in one sentence
  • A deliberate reforecast/no-reforecast decision was recorded

Frequently asked questions

What variance threshold should an SMB use?

A common starting policy: comment on any line variance over $1,000 or over 10% of budget, whichever is smaller in impact terms for your size. Tune it until the monthly review covers 5–10 lines - fewer means you are blind, more means you are narrating noise.

What is the difference between a timing variance and a permanent one?

Timing washes out: the expense (or revenue) belongs to a different month than budgeted, and the year is unchanged. Permanent variances change the full-year landing and are the ones that should feed a reforecast. Classifying every material variance as one or the other is the core discipline of the review.

Actuals changed after I ran the review - why?

The period probably was not closed when you ran it, and late postings moved the numbers. Always close first; if a closed period was deliberately reopened and adjusted, re-run the review and update commentary on any line that moved materially.

Can department managers see only their own BvA?

Structure the budget by cost centers mapped to departments, and each manager’s review can be filtered to their slice. The company roll-up stays with owners and finance.

How does commission expense show up in BvA?

If you use the sales commission add-on, approved commissions can be pushed to the budget module so the commission line compares plan vs. actual automatically - see Leads to Commission for the push step.

Ready to try it in your own workspace?

Fintra is the AI Finance Operating System for SMBs - accounting, payroll, planning, HR, and compliance under one login, with governed AI doing the heavy lifting.

Talk to us