When exporting invoices or items to QuickBooks, it’s important to control whether prices include tax or are tax-exclusive — especially to avoid duplication or calculation errors when QuickBooks applies tax automatically.
Scenario: Ensuring All Items Either Include Tax or Exclude Tax in Export
You have two options when exporting to QuickBooks:
✅ Option 1: Include Tax in Exported Amounts
-
This means the price shown for each item already includes the tax.
-
Useful if your system calculates and applies tax before export, and you do not want QuickBooks to apply any additional tax.
-
What to Do:
-
On the Export page, ensure the setting or toggle for “Prices Include Tax” (or similar wording) is enabled.
-
In QuickBooks, configure the item or invoice template to not apply tax again, or set the tax code to non-taxable to avoid double-taxing.
-
✅ Option 2: Exclude Tax and Let QuickBooks Apply It
-
The export will contain net prices, and QuickBooks will apply the appropriate tax rates based on your settings.
-
Recommended if QuickBooks is your source of truth for tax rules.
-
What to Do:
-
On the Export page, disable any setting that includes tax in prices.
-
In QuickBooks, ensure the correct tax codes are applied so tax is calculated automatically upon import.
-
⚠️ Important Notes:
-
Mixing tax-included and tax-excluded items in a single export can cause incorrect totals or syncing errors in QuickBooks.
-
To avoid this, standardize your tax setting across all items before exporting:
- Either make all items tax-inclusive, or all tax-exclusive — never both in the same export.
-
You may need to re-check or edit the tax settings in the invoice or item setup screen before finalizing the export.
🔧 Need Help Updating Export Settings?
If you're unsure where the “Include Tax” setting is on the Export page, or how your QuickBooks instance is handling tax, please reach out to Support. An agent can:
-
Confirm which tax setting is currently applied in your system,
-
Help configure the correct export format for QuickBooks,
-
Provide guidance on syncing tax codes between platforms.