Which expense categories are over or under budget?
A budget only works if you compare it to reality every month. Here's how to run a budget vs. actual comparison in your accounting software and spot the categories that need attention.
The short answer
Budget vs. actual compares what you planned to spend in each category against what you actually spent. Both QuickBooks and Xero have budget features that let you enter targets and then run comparison reports. Below, we show you how to set this up and read the results.
Why budget comparisons catch problems that the P&L misses
Your P&L shows you spent $14,800 on advertising last month. Is that good or bad? Without a budget, you have no idea. Maybe you planned to spend $10,000 and went 48% over. Or maybe you budgeted $16,000 and actually came in under.
The P&L tells you what happened. A budget comparison tells you whether what happened matches what you intended. That distinction is the difference between flying blind and flying with instruments.
Most small businesses either have no budget at all or have one that they created in January and never look at again. The value is not in creating the budget. It is in comparing against it every single month and understanding the variances.
What a budget vs. actual comparison tells you
- Favorable variance (under budget): You spent less than planned. This is good if the category is discretionary (marketing). It might be bad if it means you underinvested (skipped maintenance, delayed a hire you needed).
- Unfavorable variance (over budget): You spent more than planned. Investigate why. Was it a one-time event (equipment repair) or an ongoing trend (ad spend creeping up)?
- Revenue variance matters too: If revenue came in 15% above budget, some expense overages may be justified (you hired to support growth). If revenue missed budget, even small overages are concerning because there is less money to cover them.
How to compare expenses to budget in QuickBooks Online (6 steps)
- 1Create a budget (if you have not already)
Go to Settings (gear icon) → Budgeting. Click Add Budget. Choose the fiscal year and enter monthly targets for each income and expense account. QuickBooks lets you enter amounts by month or copy from last year's actuals and adjust.
- 2Go to Reports → Budget vs. Actuals
From the left sidebar, click Reports. Search for “Budget vs. Actuals.” Select your budget and set the date range to the current month.
- 3Read the report
The report shows three columns for each account: Budget, Actual, and Over Budget(or “Remaining”). Positive numbers in the variance column mean you went over.
- 4Sort by the largest variances
Look at the “Over Budget” column. Which categories have the largest overages? Focus on those first. A $200 overage in office supplies matters less than a $3,000 overage in advertising.
- 5Check revenue variance too
Scroll to the top of the report. Is revenue above or below budget? This context changes how you interpret expense variances.
- 6Run year-to-date for the bigger picture
Change the date range to year-to-date. A single month can have timing differences (an annual payment hitting in one month). YTD smooths these out and shows true trends.
Total time: about 8 minutes if you have a budget. Creating the budget the first time takes 30-60 minutes. After that, the monthly check is quick.
How to compare expenses to budget in Xero (5 steps)
- 1Create a budget in Xero (if needed)
Go to Accounting → Reports → Budget Manager. Click Create New Budget. Enter monthly targets for each account. Xero lets you copy from last year's actuals as a starting point.
- 2Go to Accounting → Reports → Budget Summary
This report compares your budget to actuals for the selected period. Set it to the current month.
- 3Review the variance column
Xero shows Actual, Budget, and Variance columns. Negative variances on expense accounts mean you went over budget.
- 4Click into problem categories
Click any account with a large variance to see the underlying transactions. Identify whether the overage is from one large transaction or many small ones.
- 5Run the Budget Variance report for year-to-date
Switch to year-to-date to see cumulative variances. This smooths out monthly timing differences and shows which categories are consistently over or under.
Total time: about 8 minutes if the budget exists. Budget creation in Xero takes 30-45 minutes using the Budget Manager.
What it takes to track budget variances every month
- 30-60 minutes upfront to create the budget. This is the part most people never do.
- 8 minutes per month to run the comparison and review variances.
- Budget updates. Your budget from January may not reflect reality by June if your business grew, added staff, or changed strategy. Updating the budget quarterly adds another hour but keeps the comparison meaningful.
Or see budget variances automatically, every month
Bottomline shows each expense category against its budget target and flags overages. If you do not have a formal budget, Bottomline uses your rolling 3-month average as the baseline, so you still get variance alerts:
Bottomline flags the two or three categories with the biggest overages each month, so you know exactly where to focus. And it shows whether the overage is a one-time event or part of a multi-month trend, which changes how you respond.