A working reference for bookkeepers and CPAs: cleanup, the close, and books that hold up under review.


Bookkeeping

Inclusive or Exclusive of Tax Missing in QuickBooks Online? Fix the Cause

The Inclusive and Exclusive of Tax options stay hidden until tax tracking is enabled. Here is what that means for your ledger and your close.

Updated 2026-08-20 · 3 min read


Setting up tax handling in QuickBooks Online trips up many bookkeepers the first time. You open a product or service, expect to mark its price as tax-inclusive or tax-exclusive, and find no such field anywhere. The option is not broken and your data is fine. The software simply hides every tax toggle until tax tracking has been switched on.

Why the tax options are hidden?

QuickBooks Online keeps its tax machinery dormant until you activate it. Until then, the Inclusive and Exclusive of Tax settings do not appear on product and service profiles, on sales forms, or anywhere in the menus. This is deliberate. The software will not let you describe how a price behaves toward a tax regime that, as far as it knows, does not exist for your file.

The fix is to enable tax tracking first. Open the Taxes menu in the left navigation, which may be labelled VAT or GST depending on your region, and run the setup guide. It asks for your tax registration details and standard rates. Once complete, the tax options appear across the file automatically.

Where the setting actually lives?

After activation, you do not set inclusive or exclusive status on each individual item. Instead, an Amounts are dropdown appears on invoices and sales receipts, letting you choose how prices behave on that form. This is a form-level decision, not an item-level attribute, and that distinction matters for consistency.

If some invoices are entered inclusive and others exclusive for the same customer, the net revenue and the tax liability will still be correct, provided the entry is right. But the gross figures on statements will look inconsistent, and customers may query their balances. Pick one convention per customer, or per product line where pricing genuinely differs, and document it.

What this means for your ledger?

The accounting treatment is straightforward. On an inclusive invoice, the entered amount is gross, and the software backs out the net and the tax. On an exclusive invoice, the entered amount is net and tax is added. Either way, the posting should be the same: net to revenue, tax to the tax payable liability.

Where it goes wrong is at reconciliation. If a supplier invoice is recorded exclusive when the bill was quoted inclusive, the payable is understated by the tax portion. The bank reconciliation then shows a difference equal to the tax, which is your first clue. Check the form's Amounts are setting before assuming a posting error.

A worked example

Suppose a supplier bills 1,200 inclusive of 20 percent tax. Entered as exclusive, the file records 1,000 net plus 200 tax, a payable of 1,200, and all is well. But if the 1,200 is treated as the net figure, the payable becomes 1,440 and the tax account is overstated by 240. The bank payment will not match, and the tax return, if filed from these figures, would overstate the liability.

When to involve a specialist?

This is ordinary bookkeeping, not data damage. The setting is a preference, and correcting it means adjusting the affected entries, not repairing a file. If you find large numbers of historical transactions entered under the wrong convention, or the tax payable account will not tie to filed returns after correction, that is the point to bring in a QuickBooks Online specialist before the next filing deadline.


General information for people who keep the books. It is not accounting, tax or legal advice, and it is not a substitute for your own professional judgement on your own figures.

← All articles