Budget vs Actual Template

By Nupur Mittal

Co-Founder, OCTA

This is a free budget vs actual template for accounting firms and their clients — the standard columns and variance formulas to compare budgeted to actual results, in dollars and percentages, for the period and year-to-date. Copy it into a spreadsheet to turn a P&L into a management report that explains what happened, not just what the numbers were.

The budget vs actual template

Header

The report body

                        CURRENT PERIOD                    YEAR TO DATE
Account          Actual   Budget   Var $   Var %   Actual   Budget   Var $   Var %
--------------  -------  -------  ------  ------  -------  -------  ------  ------
REVENUE
 Product sales   $_____   $_____   $____    __%    $_____   $_____   $____    __%
 Service revenue $_____   $_____   $____    __%    $_____   $_____   $____    __%
 Total revenue   $_____   $_____   $____    __%    $_____   $_____   $____    __%

COST OF SALES
 COGS            $_____   $_____   $____    __%    $_____   $_____   $____    __%
 Gross profit    $_____   $_____   $____    __%    $_____   $_____   $____    __%
 Gross margin %    __%      __%                      __%      __%

OPERATING EXPENSES
 Payroll         $_____   $_____   $____    __%    $_____   $_____   $____    __%
 Rent            $_____   $_____   $____    __%    $_____   $_____   $____    __%
 Marketing       $_____   $_____   $____    __%    $_____   $_____   $____    __%
 Other opex      $_____   $_____   $____    __%    $_____   $_____   $____    __%
 Total opex      $_____   $_____   $____    __%    $_____   $_____   $____    __%

 Net income      $_____   $_____   $____    __%    $_____   $_____   $____    __%

Variance formulas

• Variance ($) = Actual − Budget
• Variance (%) = (Actual − Budget) / Budget
• Revenue: actual above budget is favorable (positive).
• Expenses: actual below budget is favorable — so a negative expense variance is good.

Variance commentary

How to read the variances

Watch the sign convention: for revenue, actual above budget is favorable; for expenses, actual below budget is favorable, so the same positive dollar variance means opposite things depending on the line. Read both the current period and year-to-date columns — a bad month can be noise, but a widening YTD variance is a trend. Set a materiality threshold (say, any variance over 10% or $5,000) and write commentary only for the lines that clear it. The commentary is the deliverable; a client can read the numbers, but they're paying you to explain the movers.

Common mistakes and tips

• Wrong sign on expenses. Flag over-budget spending as unfavorable even though the dollar variance is positive. Automate the color/sign so it's never ambiguous.
• No commentary. A budget vs actual with no explanation just raises questions you'll answer on a call anyway.
• Chasing immaterial variances. Set a threshold; don't explain a 2% wobble on office supplies.
• Unstable accounts. If the chart of accounts shifts, budget lines stop mapping to actuals. Keep it consistent.

Run this template automatically in OCTA Flow

Building the variance report and drafting commentary every month is recurring analytical work. In OCTA Flow, the budget vs actual Skill pulls actuals from QuickBooks, Xero, Sage, or Zoho against the loaded budget, calculates the dollar and percentage variances with the correct sign convention, and flags the lines that clear your materiality threshold — even drafting first-pass commentary for your team to refine. Flow logs every step for the audit trail; your team reviews and signs off before it reaches the client. See budget vs actual automation, build it on top of the financial statement preparation checklist, and keep the chart of accounts stable so the lines map.

Frequently Asked Questions

How is a budget variance calculated? Variance in dollars is actual minus budget; variance in percent is that difference divided by budget. For revenue, positive is favorable; for expenses, spending below budget (a negative dollar variance) is favorable.

When is a variance worth explaining? When it clears a materiality threshold you set in advance — commonly any variance over 10% or a set dollar amount. Below that, movements are usually noise not worth commentary.

Turn every client P&L into an explained management report → start a 30-day OCTA Flow trial.