Budget Variance Analysis in QuickBooks Online: Formulas, Thresholds and Commentary Examples

A variance is only useful if someone explains it. This is the working version: the two formulas, which direction is favorable, how to decide which lines deserve a closer look, and the wording of a commentary that a board will actually read.

Budget variance analysis compares what you planned with what the books show and asks why they differ. QuickBooks Online will calculate the difference for you in its Budget vs. Actuals report. The part it leaves to you is the judgment: which differences matter, what caused them, and what you are going to do about them.

The two formulas

• Dollar variance = actual minus budget.
• Percent variance = dollar variance divided by the budget, times 100.

Use both. A $1,500 overspend is 12.5% of a $12,000 line and 1.25% of a $120,000 line. The dollars tell you how much money moved, and the percent tells you how surprising it is.

Favorable and unfavorable

The sign alone does not tell you whether a variance is good. It depends on what the line is.

More revenue than planned is favorable. More expense than planned is unfavorable. Pick one convention for the whole package and say which one you used.

Decide what is worth explaining

If every line gets a paragraph, the important ones get lost. Set a threshold with two tests: a percent and a dollar amount, for example 10% and $1,000. Many small businesses use something in the 5% to 10% range with a dollar floor, and then adjust it as the business grows. Explain a line only when it clears both. The same logic, applied to the history of each group rather than to the budget, is flux analysis.

Sort the cause before you write

1. Timing. The spend is real but landed in a different month than planned. It will reverse.
2. A one-time item. A single large invoice or an unusual event. It will not repeat.
3. A rate or volume change. Prices went up, or you simply did more. It will continue unless you act.
4. A budget that was wrong. The plan did not reflect how the business works. Fix the budget, not the spending.
5. An error. A duplicate, a wrong account, a missing class. Fix the books and the variance goes away.

Finding which one it is means looking at the transactions. Here is how to get from a variance to the invoice in QuickBooks Online.

Commentary you can copy

Good commentary says what happened, why, whether it will repeat, and what is changing. Three short examples:

• Marketing, +$1,500 (12.5%) unfavorable. A trade show deposit budgeted for September was paid in August. Timing only, and September will be under by the same amount.
• Freight, +$13,500 (27%) unfavorable. Volume was 12% above plan, which explains about a third of it. The rest is a carrier rate increase from July. We are re-quoting and expect to recover part of it next quarter.
• Revenue, +$4,000 (8%) favorable. A retail reset pulled forward two orders from next month. We expect next month to come in below budget by roughly the same amount.

Doing it in QuickBooks Online

1. Run Budget vs. Actuals for the month and again for year to date, on the same accounting method.
2. Export both to Excel and add a percent variance column and a flag column using your two-part threshold.
3. Filter to the flagged lines and investigate each one.
4. Write the commentary next to each line, and keep the file so next month starts from it.

Where DrillFi fits

DrillFi calculates dollar and percent variance on every line, marks each as favorable or unfavorable, and lets you click down to the vendor and invoice behind it, so the investigation step is a few clicks. For the explanations, its flux analysis keeps a note against each flagged group and month, and reopens the item with your earlier note attached if a later sync changes the difference. Walk through a flux example.

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.