How to See the Transactions Behind a Budget vs Actual Variance in QuickBooks Online

Budget vs. Actuals tells you Marketing is $53,000 over. It does not tell you why. Here is how to get from the variance to the vendor and the invoice behind it in QuickBooks Online, what each route can and cannot do, and what to do when you need it every month.

The Budget vs. Actuals report in QuickBooks Online is built around accounts. Each row is an account, each column is a budget or actual total, and the variance sits at the end. That is enough to see that a line is off. It is not enough to see which invoice made it so, and that is the question a controller or a board actually asks next.

In community threads, Intuit's support team has said that a Budget vs. Actuals report with transaction-level detail, such as vendors and invoice dates, isn't something QuickBooks Online produces. You can still get there with a few reports. Here are the routes, from quickest to most thorough.

Route 1: Click the Actual amount

On the Budget vs. Actuals report, click the amount in the Actual column for an account. Intuit's support replies describe this as the way to see the transactions behind the number. It is the fastest check for one account and one period.

The limit is that it is one account at a time. You will not see the account's transactions grouped by vendor, and you cannot compare them with the budget in the same view.

Route 2: Run Profit and Loss Detail

The Profit and Loss Detail report lists every transaction under every account, with the date, transaction type, number, name (the vendor or customer), memo and amount. Set it to the same period and the same accounting method as your Budget vs. Actuals report, then expand or filter to the account that is over.

Sort or scan by name and the biggest vendor is usually obvious. This is the best built-in route when you already know which account to look at.

Route 3: Transaction List by Vendor or Customer

If the question is "what did we pay this vendor," run Transaction List by Vendor for bills and expenses, or Transaction List by Customer for sales. Intuit's own answer to this question points to these two reports. They are organized by who, not by which budget line, so you have to filter to the account yourself.

Route 4: Export and pivot

1. Export Profit and Loss Detail for the period to Excel.
2. Insert a pivot table with the account in rows, the name in sub-rows and the amount as the value.
3. Sort each account by amount, largest first.
4. Add the budget from your Budget vs. Actuals export next to the account total.

This is the most flexible version, and it is also the one that has to be rebuilt every month.

What to look for once you have the transactions

• One large invoice. A single bill that explains most of the variance. Check whether it is real, whether it belongs in this period, and whether it is a duplicate.
• Timing. An annual or quarterly bill that landed in one month against a budget spread evenly.
• A price or volume change. Many small bills from the same vendor, each a little higher than before.
• Wrong account. A vendor whose bills belong somewhere else. See why QuickBooks keeps putting the same vendor in different accounts.
• A missing class or location. Spend that is in the books but outside the budget line you are comparing it to.

When you need this every month

The routes above work, but each one means leaving the variance report, running another report, and matching the pieces by hand. DrillFi keeps the whole path in one place: click a line on the P&L, then the budget category, the GL account, the vendor, and finally the transactions. Each level shows actual, budget or last year, and variance, and transactions that triggered one of the 15 automated checks are tagged right in the list.

On the sample company, Marketing is $53,500 over budget. Three clicks take you to a single $46,000 invoice from a vendor with no history last year. Try that drill-down yourself.

DrillFi is an advisory and reporting tool. It is not an audit, review or compilation, and it is not tax preparation or legal advice. QuickBooks menus and plan features change, so check the labels in your own file.