How to Export Invoice Data Without Tax From QuickBooks

QuickBooks Online makes it easy to export your data as a whole, but there isn't a single button that says "export invoice amounts without tax." If you need net amounts specifically, for reconciling against a vendor statement, feeding a different system, or just keeping your own records tax-exclusive, it takes a couple of extra steps on top of the standard export.

The standard export, for reference

QuickBooks Online's own general export tool is under the gear icon for Settings, then Export data in the Tools column. After picking a reason for the export and continuing, the Reports tab lets you choose a date range and switch on the reports and lists you want, including the transactions that cover invoices, receipts, and bills. Clicking Export to Excel produces a .zip file of Excel spreadsheets. This covers the general case well, but it exports whatever columns the underlying report normally shows, tax included in the total, not broken out as a separate net figure.

Getting to a net-of-tax figure

For net amounts specifically, the more useful starting point is a sales report rather than the general export tool. Reports like Sales by Customer Detail or Sales by Product/Service Detail can be customized: open the report, use Customize, and look under the Rows/Columns section for columns such as Tax Amount, Taxable Amount, or Net Amount, depending on what's offered for your QuickBooks region and tax setup. Adding the Tax Amount column alongside the invoice total gives you what you need to calculate the net figure directly, either in QuickBooks' own column if one is available, or by exporting to Excel and subtracting the tax column from the total yourself.

It's worth being upfront that QuickBooks' own support team has said in its community forum that a dedicated, always-available "net of tax" column isn't guaranteed on every report type. The export-and-subtract approach above is the practical workaround, not a hidden built-in feature, and the exact column names you'll see can vary by country edition and tax settings. If you're on QuickBooks Online Advanced, the Custom Report Buildergives more control over exactly which fields get exported, which is worth checking if the standard reports don't offer the columns you need.

Why there isn't a single "net of tax" switch

It helps to understand why this isn't a one-click setting. Tax treatment on an invoice can vary line by line, some line items may be taxable and others exempt, different tax rates can apply within the same invoice depending on your region and product setup, and QuickBooks Online's report engine is built around a general-purpose set of columns that has to work across every country edition and tax configuration it supports. A single universal "net amount" column would have to make assumptions about how you want partial tax, multiple rates, and exemptions handled, assumptions that won't be right for every business. Letting you build the column yourself from Tax Amount and Total, via Customize, sidesteps that rather than guessing wrong for some subset of users.

A quick sanity check on your export

Before relying on a net figure you've calculated by subtracting a Tax Amount column from a Total column, spot-check a handful of rows against the original invoice PDFs. It's a fast way to catch a column that's actually showing a different kind of tax (withholding tax instead of sales tax, for example) or a report that's including voided or draft invoices you didn't mean to export. A report that looks right on the first few rows isn't automatically right for every row, especially once multiple tax rates or partially-taxable line items are involved.

What to do once you have the net figures

Once you've got vendor, total, and tax amount in a spreadsheet, the net calculation itself is just a subtraction, but it's worth deciding upfront whether you want that as its own column (Total minus Tax) or whether you'd rather keep tax as a separate line and let whatever system consumes the spreadsheet next handle the arithmetic. Keeping both the gross total and the tax amount as separate columns, rather than only exporting a pre-calculated net figure, tends to be more useful later, since it lets you reconcile against the original invoice or a vendor statement without having to reverse the calculation if something doesn't match.

What tends to go wrong with this workaround

A few failure modes come up often enough to mention. Draft or voided invoices can slip into a report if the filters aren't tightened, inflating totals without anyone noticing until the numbers don't reconcile. Multi-currency invoices add another layer, since the Tax Amount and Total columns need to be in the same currency for the subtraction to mean anything, which isn't always the default. And if a customer is tax-exempt or a product/service is marked non-taxable, the Tax Amount column may simply be blank or zero for that row rather than genuinely representing "no tax to subtract," worth confirming rather than assuming.

If the invoice isn't in QuickBooks yet

All of this assumes the invoice is already entered in QuickBooks. If what you're actually trying to do is get net invoice amounts out of emails before they're entered anywhere, InboxDoc reads vendor, total amount, and tax amount directly from incoming invoice emails and exports the result to Excel, which means the net figure is just a subtraction away without opening QuickBooks at all for invoices you only need recorded in a spreadsheet, not fully booked.

See the InboxDoc pricing page for plan details, or read how this compares to rule-based tools in our InboxDoc vs Docparser comparison.

Keep the workaround repeatable

If you're going to repeat this export regularly, save your customized report (with the Tax Amount and Total columns added) rather than rebuilding the customization from scratch each time. QuickBooks Online lets you save a customized report so it keeps its column setup and filters the next time you open it, which turns this from a multi-step process you have to remember into something closer to opening a report and clicking export.

Start a free trial and process your first 5 invoices at no cost, no credit card required. Try InboxDoc.