Accounting
Financial Management
Budget vs Actual Reports: Building Them in Your Accounting System
Last updated: October 8, 2026 · Independent guide · We do not sell rankings or coverage.
A budget vs actual report compares planned revenue and spending with what the general ledger recorded, line by line, in dollars and as a percentage of budget. A useful one also labels each variance favorable or unfavorable, cuts results by department or class, and explains every material variance in writing. Below is a copy-ready template built that way, followed by how QuickBooks Online, Xero, NetSuite, Sage Intacct and FP&A tools produce the same report.
How to use this template
Fill in the header block first so every reader knows which entity, period and budget version they are looking at. Then complete the grids, add a dimension view and write a commentary line for every variance above your threshold. All figures below are an illustration for a fictional US equipment and services company closing September 2026. Replace them with your own ledger and budget data.
The budget vs actual report template
Part 1: Report header
| Field | What to enter (illustration) |
|---|---|
| Entity | Operating company, consolidated (or name the subsidiary) |
| Period and as-of date | September 2026; ledger data as of October 6, 2026 |
| Budget version | FY2026 original budget, board-approved (name any reforecast separately) |
| Close status | Preliminary or final |
| Dimension filter | All departments, all classes, all locations |
| Sign convention | Variance = Actual minus Budget; F = favorable, U = unfavorable |
| Commentary threshold | Explain any line with a variance of $10,000 or more, or 10% of budget or more |
| Prepared and reviewed by | Senior accountant / Controller |
Part 2: Month grid (illustration, September 2026)
| Line | Budget | Actual | Variance $ (% of budget) F/U |
|---|---|---|---|
| Revenue | 1,250,000 | 1,198,000 | (52,000) (4.2%) U |
| Cost of goods sold | 687,500 | 671,000 | (16,500) (2.4%) F |
| Gross profit | 562,500 | 527,000 | (35,500) (6.3%) U |
| Gross margin % | 45.0% | 44.0% | (1.0 pts) U |
| Payroll and benefits | 265,000 | 268,000 | 3,000 (1.1%) U |
| Marketing programs | 45,000 | 58,500 | 13,500 (30.0%) U |
| Professional fees | 20,000 | 31,000 | 11,000 (55.0%) U |
| Rent and facilities | 38,000 | 38,000 | 0 (0.0%) |
| Software and other | 47,000 | 45,200 | (1,800) (3.8%) F |
| Total operating expenses | 415,000 | 440,700 | 25,700 (6.2%) U |
| Operating income | 147,500 | 86,300 | (61,200) (41.5%) U |
| Headcount (statistical) | 62 | 60 | (2) |
Part 3: Year-to-date grid (illustration, January to September 2026)
| Line | YTD budget | YTD actual | Variance $ (% of budget) F/U |
|---|---|---|---|
| Revenue | 10,800,000 | 10,915,000 | 115,000 (1.1%) F |
| Cost of goods sold | 5,940,000 | 6,048,000 | 108,000 (1.8%) U |
| Gross profit | 4,860,000 | 4,867,000 | 7,000 (0.1%) F |
| Total operating expenses | 3,690,000 | 3,802,000 | 112,000 (3.0%) U |
| Operating income | 1,170,000 | 1,065,000 | (105,000) (9.0%) U |
Part 4: Dimension views (illustration, September 2026)
| Dimension value | Budget | Actual | Variance $ (% of budget) F/U |
|---|---|---|---|
| Revenue, class: Equipment | 800,000 | 735,000 | (65,000) (8.1%) U |
| Revenue, class: Service contracts | 450,000 | 463,000 | 13,000 (2.9%) F |
| Opex, department: Sales and marketing | 180,000 | 196,500 | 16,500 (9.2%) U |
| Opex, department: Operations | 95,000 | 93,200 | (1,800) (1.9%) F |
| Opex, department: General and administrative | 140,000 | 151,000 | 11,000 (7.9%) U |
Part 5: Commentary log (illustration)
| Line and variance | Driver | Timing or permanent | Action and owner |
|---|---|---|---|
| Revenue (52,000) U | Two equipment orders slipped to October; early service renewals offset part of it. | Timing | Confirm October ship dates. VP Sales. |
| Gross margin (1.0 pts) U | Higher inbound freight on equipment components. | Permanent until rebid | Rebid freight in Q4. Operations director. |
| Marketing programs 13,500 U | Trade show invoiced in September, budgeted in October. | Timing | No action; reverses in October. Marketing director. |
| Professional fees 11,000 U | Unbudgeted legal work on a customer contract dispute. | Permanent | Add Q4 legal cost to reforecast. Controller. |
Walking through each part of the template
Header
The header ensures everyone in the review is looking at the same numbers. Name the budget version explicitly. A report that silently switches between the original budget and a reforecast makes variances appear or disappear. State whether the close is preliminary, because accruals booked after the report runs will change the actuals.
Line structure
Build the rows at the level your budget was built, not at the level of your chart of accounts. If the budget has one marketing programs line, listing eleven marketing GL accounts gives eleven variances with budget on only one. Roll accounts up to the budget grain and keep detail as a drill-down. Add budgeted statistical lines such as headcount, which explain payroll variances.
Budget, actual and variance columns
Pick one sign convention and print it in the header. This template uses Actual minus Budget, so a positive number means you earned or spent more than planned. The favorable or unfavorable label depends on account type. Calculate the percentage on the budget amount, and show “n/a” when the budget is zero rather than a division error or an infinite percentage.
Ratios such as gross margin need their own row with the variance shown in percentage points. Otherwise a margin drop hides behind a “favorable” cost of goods sold line that fell only because revenue fell.
Month and year-to-date grids
A single month is noisy. The year-to-date grid shows whether a monthly miss is a trend or will reverse. In the illustration, September revenue is $52,000 below budget, yet year-to-date revenue is still $115,000 ahead, so September looks like timing. Where your system allows, add a full-year budget and latest forecast as a separate view.
Dimension views
Department, class and location dimensions turn one variance into an owner. The revenue miss in the illustration comes entirely from the equipment class, and the expense overrun sits in sales and marketing and in general and administrative. This only works if the budget was entered at the same dimension; a company-level budget shows no budget against individual departments.
Commentary log
Write one line per variance above threshold. Name the driver in business terms, say whether it is timing or permanent, and give an action and owner. The timing column tells you whether to change the forecast.
Common mistakes
- Comparing against the wrong version. A reforecast loaded over the original budget erases the variance the board approved against.
- Budget phased evenly by month. Dividing an annual budget by twelve creates false variances for seasonal revenue, annual insurance renewals and trade shows.
- Mismatched grain. Budget by department, actuals coded without a department, so the variance lands in an “unassigned” column nobody owns.
- Running the report before accruals. Missing vendor invoices make expenses look favorable for a month.
If cost of goods sold includes standard cost variances, see our explainer on standard cost vs actual cost.
How accounting systems and FP&A tools produce this report
| System | Where budgets live | Dimensions | Main limitation |
|---|---|---|---|
| QuickBooks Online Plus or Advanced | Reports > Financial planning > Budgets | Subdivide by class or location | Plus caps classes and locations at 40 combined; import covers profit and loss budgets only |
| Xero | Budget Manager | Two tracking categories | Profit and loss budgets only; one custom layout per tracking category |
| NetSuite | Budget records, set up in NetSuite or by CSV import | Department, class, location, subsidiary, customer or project, item | Custom segments not available in budget report columns |
| Sage Intacct | Budgets repository | Location, department, employee and other dimensions (optional) | Dimensions are optional, so a budget entered without them cannot be cut by department later |
QuickBooks Online
Intuit’s pricing page lists budget planning on Plus ($140 per month list price) and Advanced ($340), checked October 8, 2026. Intuit’s usage limits article caps Plus at 40 classes and locations combined and gives Advanced unlimited classes and locations. You create budgets under Reports > Financial planning > Budgets, subdivide them by class or location, and run the Budgets vs. Actuals report from the budget list. Import supports profit and loss budgets only; balance sheet budgets are entered in QuickBooks. Intuit’s article does not describe a commentary field, so plan to keep the log in Part 5 in Excel or a reporting add-on.
Xero
Xero holds budgets in Budget Manager and reports them through the Budget Variance report. Calxa, which sells a Xero budgeting add-on, documents that Xero budgets cover profit and loss accounts only, that the standard variance layout uses the overall budget, and that a tracking-category budget needs its own customized report. Xero’s developer documentation says an organisation can have a maximum of two active tracking categories, and a customer request to raise that limit was marked “In discovery” on September 1, 2026. For a company tracking departments, classes and locations, that ceiling usually decides the question.
NetSuite
Oracle’s documentation says NetSuite budgets can be set by customer or project, item, department, class, location and subsidiary, alone or in combination, that the Multiple Budget feature allows several budgets per period, and that statistical accounts such as headcount can carry budgets. The Budget vs. Actual report footer shows amounts by period, class, department, location or subsidiary, but custom segments are excluded from budget report fields. Budget columns show zeros if the Report by Period preference is set to Never.
Sage Intacct
Sage Intacct keeps budgets in the Budgets > All > Budgets > Budgets repository, created manually, copied or imported by CSV, with dimensions such as location, department and employee. Its Financial Report Writer has the fullest set of variance columns of the four, including normalized variances that set the sign by favorability, budget ratio, remaining budget and prorated forecast. Because dimensions are optional on a budget, decide before loading it which dimensions the report will be cut by.
FP&A tools
Planning tools pull actuals from the ledger and hold budget versions as scenarios. Workday Adaptive Planning builds a variance report as a matrix report with Actuals and plan versions in columns and an Excel template for the variance formula. Cube, an FP&A vendor, documents spreadsheet-calculated variances and a Smart Analysis feature that ranks the top variances by amount and percentage, with AI-generated driver notes that consume credits. Our guide to ERP and FP&A integration covers how the data flows between the two.
When to move from a spreadsheet to software
A spreadsheet works for one entity, one budget version and a few departments. Move the report into the ledger or an FP&A tool when you rekey actuals every month, when you need more than two dimensions (which rules out native Xero), or when reforecasts start overwriting the original budget. NetSuite and Sage Intacct handle multi-dimension budgets natively. QuickBooks Online Advanced suits companies that need only class and location. If you are reconsidering the core system, our mid-market accounting software buyer’s guide covers that decision.
How we researched this
We read the pages that rank for “budget vs actual report”, including guides from Founder’s CPA, Vena, Coefficient and Basedash. None combined a full template, dimension views and a commentary log with how each accounting system behaves natively. We checked vendor documentation from Intuit, Oracle NetSuite, Sage Intacct, Workday and Cube, plus Xero’s developer documentation and ideas forum, on October 8, 2026. All template figures are illustrative.
Related guides
- NetSuite Planning and Budgeting (NSPB): Features and Pricing
- Flux Analysis: Month-End Thresholds and Explanations
- NetSuite Reporting: Reports, Saved Searches and Workbook
Frequently asked questions
What should a budget vs actual report include?
It needs budget, actual, dollar variance and percentage variance for each line, for the month and year to date. A report managers can act on also labels variances favorable or unfavorable, splits results by department or class, and explains every variance above a set threshold.
Can QuickBooks Online do budget vs actual by class?
Yes, on Plus and Advanced. You subdivide the budget by class or location when you create it and then run the Budgets vs. Actuals report. Plus limits you to 40 classes and locations combined, while Advanced allows unlimited classes and locations.
What variance threshold should trigger commentary?
No standard figure exists. Pairing a dollar amount with a percentage catches small accounts with large swings and large accounts with small swings. Set it at the level your management team will act on.
Should I compare actuals to the original budget or the forecast?
Compare to both, in separate columns or separate reports. The original budget shows performance against the plan that was approved, and the latest forecast shows whether the current outlook is holding. Never overwrite the original budget with a reforecast.
Sources
- Intuit, QuickBooks Online pricing, no date shown (checked October 8, 2026). quickbooks.intuit.com
- Intuit, How to create, edit, and manage budgets, September 22, 2026. quickbooks.intuit.com
- Intuit, Learn about usage limits in QuickBooks Online, updated August 5, 2026. quickbooks.intuit.com
- Calxa (sells a Xero budgeting add-on), Xero budget reports, June 24, 2025. calxa.com
- Xero Product Ideas, Tracking Categories: increase maximum number of active tracking categories and tracking options, status update September 1, 2026. productideas.xero.com
- Xero Developer, Accounting API: Tracking Categories, no date shown. developer.xero.com
- Oracle NetSuite, Budgets in NetSuite, no date shown. docs.oracle.com
- Oracle NetSuite, Budget vs. Actual Report, no date shown. docs.oracle.com
- Sage Intacct, Overview of creating budgets, September 17, 2026. intacct.com
- Sage Intacct, Column types, Financial Report Writer, October 1, 2026. intacct.com
- Workday, Example: build a variance report (Adaptive Planning), September 6, 2024. doc.workday.com
- Cube (FP&A vendor), Ad hoc reporting help article, July 16, 2024. help.cubesoftware.com
- Cube (FP&A vendor), Smart Analysis help article, February 24, 2025. help.cubesoftware.com
Sherman Hsieh
Independent analysis of enterprise software — ERP, CRM and more
