QuickBooks Online Budget vs Actuals Showing the Full-Year Budget? Why and How to Fix It

Run the report for February and the budget column shows the whole year. It looks like a bug, and sometimes it is, but there are four things to check before you give up on it.

You run Budget vs Actuals in QuickBooks Online for January and February. The actual column shows two months of results. The budget column shows twelve months of budget. Nothing lines up, and every variance on the page is meaningless.

This is one of the most common complaints in the QuickBooks Community, and it has a few distinct causes. Work through them in this order.

What the report is actually doing

The actual column follows the date range you pick. The budget column follows the budget, and how it behaves depends on how that budget was entered and on the report period you chose. Intuit's own support staff describe the budget column as displaying "based on your budgeting configuration," which is a polite way of saying the problem is usually upstream of the report itself.

Fix 1: Use a custom date range instead of a preset

Several users report that presets such as "Prior fiscal quarter" or "This fiscal year to date" return a full year of budget, while the same report run with a Custom date range returns only the months they asked for. Intuit staff have recommended Custom for exactly this. Behavior has changed more than once over the years (some users say Custom used to give them the full-year budget they wanted and then stopped), so test both and use whichever gives you the window you need.

Fix 2: Check how the budget was entered

A part-year report can only slice a budget that has amounts in the months you're reporting on. If the budget was entered as one annual figure, or the months you need are empty, there's nothing to slice and you'll see the annual number. Open Settings → Budgeting, edit the budget, and confirm the amounts are spread across the months. Intuit's staff give the same first instruction: check that the correct amounts are set per month.

Fix 3: Check your fiscal year setting

If your fiscal year doesn't start in January, the company's fiscal year start month matters. Users have reported budgets landing in the calendar year, not the fiscal year, when that preference was never set, which leaves the report comparing the wrong twelve months. Intuit's advice is to set the fiscal year start in your company preferences (in Account and settings, under Advanced) and then rebuild or re-check the budget.

Fix 4: Check you're on the right report, budget and plan

• Budget Overview vs Budget vs Actuals. Budget Overview only shows the numbers you entered. Budget vs Actuals is the comparison. Make sure you ran the second one.
• Which budget. If you have more than one budget, the report asks which to use. A leftover test budget is a classic cause of strange numbers.
• Plan. Budgeting is available on Plus and Advanced, not on every QuickBooks Online plan.
• Budgets split by class or location. These are much harder to report on. Users with class-level budgets describe QuickBooks Online as unable to show the budget broken out by class in a standard report.

What if you want the full-year budget next to year to date?

Plenty of people have the opposite problem: they don't want the full year trimmed away, they want it beside their year-to-date actuals so they can see how much of the budget is left. QuickBooks Online builds Budget vs Actuals around a single date range, so the usual route is running the report twice, once for year to date and once for the full year, and joining the two in a spreadsheet every month.

In DrillFi the full-year budget is a column you switch on, the same way you switch on last year or a forecast. Turn on FY Budget and Budget left and every line shows its year-to-date actual, the whole year's budget and what remains of it, including the calculated rows such as Net Revenue and EBITDA. The same two columns can be added to the Excel export and the monthly package. Try them in the demo with the "Show full-year budget" button.

Why the report keeps tripping people up

The deeper issue is that your budget and your chart of accounts rarely match one-to-one. Budgets are usually built on categories a board understands, such as trade spend, logistics and marketing, while QuickBooks books spending into many accounts. When the two don't line up, any report that assumes they do will look wrong in a way that's hard to debug. That mismatch is the problem DrillFi was built around: you map your budget categories to accounts once, and the comparison works for whatever period you pick.

Frequently asked questions

Why does QuickBooks Budget vs Actuals show the full-year budget?

The actual column follows your date range, but the budget column follows how the budget was entered. Common causes are a preset date range, a budget with empty months, a fiscal year start that was never set, or the wrong budget or report.

Should I use a preset or a Custom date range?

Several users report that presets like "This fiscal year to date" return a full year of budget while a Custom range returns only the months they asked for, and Intuit staff have recommended Custom. Behavior has changed over the years, so test both.

What's the difference between Budget Overview and Budget vs Actuals?

Budget Overview only shows the numbers you entered. Budget vs Actuals is the comparison against your actual results. Make sure you ran the second one.

Which QuickBooks plans include budgeting?

Budgeting is available on Plus and Advanced, not on every QuickBooks Online plan.

Can QuickBooks Online show a budget by class or location?

Users with class-level budgets describe QuickBooks Online as unable to show the budget broken out by class in a standard report, so budgets split by class or location are much harder to report on.

QuickBooks menus, report behavior and plan features change over time, and this post describes them as of its publish date. Check each step against your version. Intuit and QuickBooks are registered trademarks of Intuit Inc. Used with permission. DrillFi is not affiliated with or endorsed by Intuit.