Free tool, no sign-up
QuickBooks budget vs actual: find the biggest variances
Add the Budget vs. Actuals export from QuickBooks Online and see every variance in dollars and percent, the five biggest, and which ones helped or hurt profit. No budget in QuickBooks? Add a Profit and Loss and a budget sheet instead. Files stay in this browser: nothing is uploaded.
Your variances appear here
Add the Budget vs. Actuals export from QuickBooks Online, or a Profit and Loss with a budget file. Or see how it works first.
How to export Budget vs. Actuals from QuickBooks Online
About two minutes. Budgets are part of QuickBooks Online Plus and Advanced, per Intuit.
- 01
Open the report
ReportsGo to Reports and search for Budget vs. Actuals. Or open Financial planning, then Budgets, and pick Run Budgets vs. Actuals report under Options.
- 02
Set the period
Month or yearChoose the report period and run it. If the columns are split by month, the tool lets you pick the month or the total.
- 03
Export it
ExcelSelect Export/Print, then Export to Excel (in the classic view, the Export icon).
- 04
Add the file
In the toolDrop it into the tool above. Totals and headings are skipped and recomputed from the account lines.
- 05
Read the top five
Then actStart with the biggest unfavorable gaps, explain each, and carry what is permanent into the forecast.
- From Xero
- Run the Budget Variance report, export it to Excel and add the file. The tool reads its Actual and Budget columns.
- No budget in QuickBooks
- Export the Profit and Loss, then add the Budget Overview export or any sheet of account and budget. Or paste rows of account, budget and actual.
- Sources
- Intuit: create budgets in QuickBooks Online and export reports to Excel (checked November 2026). QuickBooks is a trademark of Intuit Inc. and Xero of Xero Limited; Decipher is not affiliated with either.
What the numbers mean
Variance
Actual minus budget, the same as the over Budget column in QuickBooks, which Intuit staff describe as actual minus budget (QuickBooks community).
Variance %
The variance divided by the budget. Lines with no budget show n/a. QuickBooks shows % of Budget instead: actual divided by budget, so 112% of budget is a 12% variance.
Favorable or unfavorable
Favorable helps profit: income above budget or costs below it. Unfavorable is the reverse (AccountingTools). Income and cost come from the report's sections; switch a line in the full list if one is read wrongly.
The five biggest
Ranked by the size of the variance in dollars, favorable or not. A large favorable gap can still be a problem, such as spending that slipped to next month.
Explaining variances, setting materiality thresholds and running the monthly review are in budget vs actual analysis: formula, template and example.
QuickBooks budget vs actual: common questions
How do I run a budget vs actual report in QuickBooks Online?
Go to Reports and search for Budget vs. Actuals, or open Reports, then Financial planning, then Budgets, and choose Run Budgets vs. Actuals report from the Options menu next to the budget. Set the report period and run it. To use it here, select Export/Print (or the Export icon), then Export to Excel.
Which QuickBooks Online plans have budget vs actual?
Intuit says budgeting is available in QuickBooks Online Plus and Advanced, so the Budget vs. Actuals report needs one of those plans. On other plans, export the Profit and Loss for the period and add a budget spreadsheet of account and amount; this tool matches the two by account name.
What does the % of Budget column show?
Actual as a percent of budget. 90% means the account came in at 90% of its budget: below plan for an income line, under spend for a cost line. The over Budget column next to it is actual minus budget, so a positive number on a cost line is overspending and on an income line is extra revenue.
Why does net income on Budget vs. Actuals differ from the Profit and Loss?
Check three things: the same dates, the same accounting basis (cash or accrual), and whether every account with activity has a budget line. To find the gaps, export the Profit and Loss and the Budget Overview for the same period and add both here: the tool counts the accounts with no budget and the budget lines with no actual.
Does Xero have a budget vs actual report?
Yes. Xero calls it the Budget Variance report, which compares actuals with a budget set up in Xero. Export it to Excel and add the file here: the tool reads its Actual and Budget columns and its income and expense sections the same way it reads the QuickBooks report.
More free tools
The browser tools need no sign-up, and nothing entered leaves the browser.
Startup runway calculator
Months of runway, the zero-cash date and a default alive check from cash, revenue and costs. Calculate startup runway
QuickBooks cash flow forecast
A 13-week cash view built from the Open Invoices and Unpaid Bills exports, in the browser. Build the QuickBooks cash flow forecast
13-week cash flow forecast template
The Excel workbook to keep the weekly forecast going, with a sample company built in. See the 13-week template
Further reading
Decipher's FP&A services
Want the budget vs actual review run every month, with commentary and a reforecast? It is part of a Decipher FP&A engagement.
Get the sample budget board deck
See how budget vs actual reads in a board pack: an excerpt of the budget deck Decipher builds for clients. Or book a 30-minute call to talk through your numbers.
Or email contact@decipherhq.com