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.

7 min read

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)

  1. 1
    Create 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.

  2. 2
    Go 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.

  3. 3
    Read 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.

  4. 4
    Sort 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.

  5. 5
    Check revenue variance too

    Scroll to the top of the report. Is revenue above or below budget? This context changes how you interpret expense variances.

  6. 6
    Run 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)

  1. 1
    Create 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.

  2. 2
    Go to Accounting → Reports → Budget Summary

    This report compares your budget to actuals for the selected period. Set it to the current month.

  3. 3
    Review the variance column

    Xero shows Actual, Budget, and Variance columns. Negative variances on expense accounts mean you went over budget.

  4. 4
    Click 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.

  5. 5
    Run 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:

Budget vs. Actual
Payroll$44,000+$4,200
Advertising$10,000+$4,800
Software & tools$6,000+$340
Insurance$4,200$0
Vehicles & equipment$4,000-$200
From a real Bottomline report. Budget targets come from your accounting software or rolling averages.

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.

Get your answer. Every month, automatically.

Connect your accounts in 5 minutes. Your first report arrives within 24 hours.

Works with QuickBooks, Stripe, HubSpot, Google Ads, and more
© 2026 Bottomline