A budget vs actual report compares your planned numbers to what really happened so you can catch material variances and correct course this month, not next quarter. It typically lays out three columns side by side: budget, actual, and variance, with the variance calculated as actual minus budget and expressed as both a dollar amount and a percentage. That simple layout turns raw numbers into a decision tool.
TL;DR:
- Small businesses should compare actual expenses and revenues against their budget monthly to identify significant variances early.
- Variance analysis should include both dollar amounts and percentage differences, calculated from the actual minus budget figures.
- Consistent categorization of variances helps determine if deviations are due to volume, rate, timing, or one-off events.
- Implementing a formal process with clear documentation, threshold filters, and notes improves the reliability of insights.
- Using tools like pivot tables, conditional formatting, and period-based views enhances clarity and supports decision-making efforts.
Table of Contents
- What a budget vs actual report is and when to use it
- Key components and formulas your report needs
- How to build and present the report step by step
- Types of variances and what usually causes them
- How to turn variances into decisions, not just numbers
- Best practices for keeping the process reliable
- How an outsourced accounting partner handles this in practice
- Get help building your own budget vs actual process
- Primary sources and tools referenced
- Sources
- FAQ
What a budget vs actual report is and when to use it
A budget vs actual report lines up what you planned to spend or earn with what actually happened, giving you a fast read on whether your business is tracking to plan. Small business owners lean on this report during the monthly close, when reviewing individual project budgets, and when preparing numbers for a management or board meeting.
Most companies run this report on a set cadence, then pull an extra version whenever something looks off, a big client cancels, a vendor raises prices, or cash gets tight.
- Monthly close: confirms the books match expectations before you report results to owners or lenders.
- Project tracking: flags overspending on a specific job before it eats the margin.
- Management reviews: gives leadership a shared reference point for decisions.
The numbers themselves come from your general ledger, supporting subledgers like accounts receivable and accounts payable, payroll records, and sales exports from your point-of-sale or invoicing system.
Key components and formulas your report needs
A usable budget vs actual report follows a consistent structure so anyone on your team can read it the same way every time. The standard column order is budget, actual, variance, and variance percentage, with rows organized by revenue, cost of goods sold, operating expenses, capital expenditures, and net income.
- Set up the columns. Budget first, actual second, variance third, variance percentage last: this order matches how Wall Street Prep describes standard variance analysis, comparing actual results against a predetermined budget, plan, or rolling forecast.
- List the core rows. Revenue at the top, then cost of goods sold, then operating expenses broken into payroll, rent, and marketing, then capital expenditures, ending with net income.
- Calculate variance. Variance equals actual minus budget. If you budgeted $10,000 in marketing spend and actually spent $8,500, your variance is negative $1,500, a favorable variance because you spent less than planned. If revenue was budgeted at $50,000 and actual revenue came in at $45,000, the variance is negative $5,000, an unfavorable variance because you earned less than expected.
- Calculate variance percentage. Divide the variance by the budget and multiply by 100. The marketing example above gives you a variance of negative 15%.
- Add period and year-to-date columns. A single month can look alarming in isolation but normal once you see the year-to-date trend, and vice versa: a strong single month can mask a slipping annual pace.
The sign convention matters here. For expenses, spending less than budgeted is favorable (a negative variance in dollar terms but a positive outcome). For revenue, earning more than budgeted is favorable (a positive variance). Keeping that convention consistent across every row avoids confusion when someone scans the report quickly.
How to build and present the report step by step
Start by mapping every general ledger account to a managerial category, revenue, cost of goods sold, payroll, rent, marketing, and so on, so your budget and your actuals speak the same language. Skipping this step is the most common reason a budget vs actual report looks wrong on the first try: the accounts simply do not line up.
- Build the table. Rows for each category, columns for budget, actual, variance, and variance percentage, with a period view and a year-to-date view side by side.
- Add charts where they help. A variance bar chart shows which categories moved the most, and a waterfall chart shows how each variance rolled up to the total.
- Use pivot tables in Excel. They let you slice the same data by department, project, or month without rebuilding the report from scratch.
- Write the variance formula once and copy it down.
=Actual-Budgetfor the dollar variance and=(Actual-Budget)/Budgetfor the percentage. - Apply conditional formatting. Red for unfavorable variances beyond your threshold, green for favorable ones, so the report highlights itself.
Pro Tip: Freeze your budget once it is approved so nobody edits the original figures midyear: track changes in a separate revision column instead.
If you export actuals from QuickBooks Online or another accounting system, check that the export uses the same fiscal period boundaries and account structure as your budget file before you paste anything into Excel. A common pitfall is importing a budget that was built on a different chart of accounts version, which throws off every variance calculation downstream. Keep a dated copy of each budget version so you always know which plan you are comparing against.
For drill-downs, the Budget vs Actual Monthly Variance Detail Report used at UC San Diego offers a useful model: it displays Period, Year-to-Date, and Annual views, with hyperlinks in the actual columns that lead straight to the underlying general ledger transactions. Building that same link structure into your own report, even a simple hyperlink to a filtered GL export, saves real time when someone asks “why did this number move?” Attach a short variance note next to any figure beyond your threshold so the explanation travels with the number.
Types of variances and what usually causes them
Not every variance means something went wrong. Some come from timing, some from volume, some from a single unusual event, and knowing which is which keeps you from chasing noise.
- Volume variance happens when you sell more or fewer units than planned, changing revenue and variable costs together.
- Rate variance happens when the price or cost per unit changes, a supplier raises prices, or you win a client at a different rate than modeled.
- Timing variance happens when a payment or invoice lands in a different period than budgeted, a common issue with payroll that spans month boundaries.
- One-off events include a lawsuit settlement, an equipment breakdown, or a one-time grant, items that will not repeat next month.
Payroll timing is a frequent surprise for small businesses: a biweekly pay cycle occasionally produces three pay periods in one month instead of two, creating a variance that has nothing to do with actual labor cost trends. Seasonality causes similar confusion in retail and hospitality, where a slow February looks like a problem until you compare it to last February. For a closer look at where these patterns originate, our guide to common budget leaks in small businesses walks through the usual culprits.
Categorize each variance as volume, rate, timing, or one-off when you write your notes, and that habit alone makes next quarter’s trend analysis far easier to read.
How to turn variances into decisions, not just numbers
A long list of variances is not an analysis. The goal is to filter, decompose, and investigate only what actually matters to the business.
- Apply a materiality filter. Set a dollar or percentage threshold to focus your review, and only dig into variances that cross this materiality filter. Wall Street Prep recommends this kind of threshold specifically so finance teams do not burn hours on noise.
- Decompose the variance. Separate volume effects from rate effects before you draw a conclusion: a revenue miss driven by fewer units sold calls for a different response than one driven by discounting.
- Drill into the general ledger and transaction detail. Pull the actual entries behind the number rather than guessing at the cause. Our piece on the role of the general ledger in small business finance covers how that structure supports this kind of tracing.
- Talk to the person responsible. A department head usually knows within a minute whether a variance was a planning miss or an execution problem.
Compare the current period against prior periods and against year-to-date totals before reacting: a single bad month often looks different once you see it against a full-year trend, which is exactly the comparison Wall Street Prep recommends alongside prior-year comparisons.
A repeatable variance workflow, applied consistently, tends to catch real problems earlier than a report reviewed only when something already feels wrong.
Track a few key metrics alongside the report itself: gross margin percentage, cash burn rate, and budget burn versus plan for the year. Together they tell you whether a variance is isolated or part of a bigger shift in how the business is running.
Best practices for keeping the process reliable
A budget vs actual report is only as good as the process behind it. Assign one person as the owner of the report, document how each general ledger account maps to its managerial category, and require a short variance note for anything material before the books close.
- Set a monthly close checklist that includes pulling actuals, updating the budget file, and reviewing variances before the numbers go to leadership.
- Move toward driver-based budgeting where the budget updates automatically when a key driver, like headcount or unit sales, changes.
- Add a rolling forecast so the plan itself stays current instead of going stale halfway through the year.
- Keep transaction hygiene tight so actuals are accurate the first time. Our guide to bookkeeping best practices for small business owners covers the habits that make this easier.
Pro Tip: Write your variance narrative in plain language a non-finance owner can understand: “Marketing spent 15% less than planned because a campaign was delayed to next month” beats a bare percentage every time.
Spreadsheets work well for most small businesses through the early growth stages. Once you are managing multiple departments, several budget versions, or frequent forecast updates, a dedicated FP&A tool or accounting system integration usually saves more time than it costs. Our roundup of profit analysis tools for entrepreneurs walks through when that upgrade makes sense. If a variance touches tax payments or filing timing, the IRS Topic 306 guidance is worth checking before you draw conclusions about the cause.
How an outsourced accounting partner handles this in practice
Budget vs actual reporting can be incorporated into recurring bookkeeping and consulting work rather than treated as a separate project. We map general ledger accounts to managerial categories once, then carry that structure forward every month so the numbers stay comparable period over period.
Monthly close support often includes pulling actuals, updating the budget file, and writing variance notes for anything material, following recommended best practices. This approach aims to provide a decision-ready report without requiring owners to build the Excel model themselves or to learn the mechanics of GL drill-downs. The goal is fewer surprises at month end and a clearer view of where the plan and the reality are drifting apart.
— Kelli
Get help building your own budget vs actual process
You do not need an in-house FP&A team to run a real budget vs actual process. KelliWorks offers full-service bookkeeping and accounting support, including budgets and financial forecasting, cash flow management, and monthly reporting built around your actual chart of accounts.
If you would rather hand off the monthly close and variance review than build it yourself, schedule a consultation and we will walk through what a managed reporting setup would look like for your business.
Primary sources and tools referenced
The variance formulas and analysis workflow in this guide draw on Wall Street Prep’s explanation of budget-to-actual variance analysis, including its guidance on materiality thresholds and variance annotation. The report layout and drill-down approach reference the Budget vs Actual Monthly Variance Detail Report from UC San Diego, which separates Period, Year-to-Date, and Annual views. For variances tied to tax timing, consult IRS Topic 306 directly. Check your own accounting system’s documentation for its specific GL drill-down capabilities, since export formats and permissions vary by platform.
Sources
- Budget to Actual Variance | Formula + Calculation Example — Wall Street Prep
- Blink
- IRS — Topic No. 306 (Tax)
FAQ
What is the difference between budgeted and actual figures?
Budgeted figures are the amounts you planned to earn or spend before the period started, while actual figures are what really happened, pulled from your general ledger and other financial records. The variance between them, actual minus budget, tells you whether you outperformed or underperformed the plan.
What does “actual” mean on a budget sheet?
On a budget sheet, “actual” refers to the real, recorded financial results for a given period, as opposed to the projected or planned figures in the budget column. Actual figures come from posted transactions in your accounting system, not estimates.
How do I present a budget vs actual report in Excel?
Lay out your data with budget, actual, variance, and variance percentage as columns, and revenue, cost of goods sold, operating expenses, and net income as rows. Use conditional formatting to flag variances beyond your threshold, and add a pivot table if you need to view the same data by department or project.
How do I run a budget vs actual report in an accounting system like QuickBooks Online?
Most accounting systems, including QuickBooks Online, offer a built-in budget vs actual report once you have entered a budget for the fiscal year. Export the actuals to confirm they use the same account structure and period boundaries as your budget before comparing the two, since mismatched charts of accounts are a common source of reporting errors.
How often should a small business run this report?
Most small businesses review a budget vs actual report monthly, with an additional look at year-to-date totals to catch trends a single month might hide. Wall Street Prep notes that variance analysis is typically performed monthly, quarterly, or annually depending on the organization’s needs.
