How to Set Up Budget vs Actual in QuickBooks Online Without Rebuilding Your Budget

Most budget vs actual setups fail at the same step: getting a budget that someone built in Excel to line up with the accounts in QuickBooks. Here is the order that works, and the checks that tell you it's right before anyone sees a report.

You already have a budget. It lives in a spreadsheet, it uses the categories your board or owner understands, and it has been right enough to run the business on. The job is not to build a new one. It is to connect that budget to the accounts that actually book the spend, so every month's actuals land under the right line without a rebuild.

Setup comes down to five steps. If you do them in this order, the last one tells you whether the first four worked.

1. Start from the accounts QuickBooks already has

Begin by pulling the chart of accounts and looking at what's there: which are income, cost of goods, expense, and other income and expense, and which are inactive or not part of the P&L. This takes a few minutes and saves the most time later, because every question in the next steps is really "which of these accounts goes where?" Knowing the list first means you aren't discovering accounts halfway through mapping.

2. Bring the budget you already have

There are three honest ways to start, and the right one depends on what exists today:

• You have a budget spreadsheet. Upload it. Your own lines and your own categories come across, along with the monthly numbers. You don't reformat it into someone else's template first.
• You have no budget, but you know the structure. Type the lines in, or fill in a simple template, and add numbers later.
• You have neither. Build the structure from your QuickBooks accounts and adjust from there. It's a reasonable first pass, and you can rename and regroup it.

Whichever you pick, you end up in the same place: a list of sections with budget lines under them.

3. Shape the lines your board actually reads

A budget line is a business category: "Trade spend," "Freight," "Marketing." A section is a financial statement group such as revenue, contra revenue (discounts and returns), cost of goods, and expenses. Set these up the way you want to read them, not the way the chart of accounts is organized. One budget line can be one account, or ten.

If a line in your spreadsheet bundles things you want to see separately, split it. If two lines are really one, combine them. This is the part where setup is a decision, not a mechanical step, and where a controller's judgment matters.

4. Match every account to one line

Now each GL account that matters goes under exactly one budget line. Every account lands in one place, the same way your chart of accounts already assigns it. The goal is zero accounts left over. Anything that carries real dollars and isn't mapped is activity your report will silently leave out.

Do this once. After that, every sync pulls fresh activity and drops it under the same lines, so you aren't re-exporting and re-running lookups each month.

5. Check it against QuickBooks before you trust it

This is the step most setups skip, and it's the one that matters. Before the first report goes to anyone, compare your mapped Net Income for a few closed months to the net income QuickBooks reports for the same months. They should match. If they don't, the difference is almost always one of three things:

• Unmapped accounts. Real activity that no budget line is picking up. This is the most common cause by far.
• A sign problem. Discounts and returns are the usual one. QuickBooks records them as negative income, and a formula that subtracts them will overstate revenue if the sign is handled the wrong way.
• A section in the wrong place. An account that is other income, for example, sitting inside operating expenses.

When Net Income ties, you have proof the mapping is complete, not a feeling that it is. When it doesn't, the gap tells you where to look.

What to expect after setup

Once the structure and the tie-out are done, the budget vs actual view works on your own lines: this month, year to date and last year, drilled from any line to the GL account, the vendor and the transaction. New accounts that appear mid-year show up as unmapped, so they get caught instead of disappearing. The monthly package and the alert checks use the same mapping, so you do the work once.