WooCommerce sales tax in QuickBooks Desktop: three ways to make it match

Your store charges sales tax on each order. QuickBooks Desktop also works tax out, from the tax item on the invoice. The two don’t always agree, and when they don’t, the invoice total stops matching what the customer paid. Here are the three ways to book web orders so they do agree, and how to pick one.

Why the two figures drift

QuickBooks calculates tax from the taxable lines on the invoice and the rate of its tax item, rounding each rate on its own. WooCommerce may round per line, per rate, or (with a tax plugin) use a rate for each street address that no single QuickBooks item has. Most of the time the difference is a cent or nothing. Sometimes it’s more, and that “more” is the thing to catch.

1. One QuickBooks tax item works it out

Best for: a store that charges one rate, or one combined rate, wherever it collects tax.

Pick the tax item (or tax group) for taxed orders and a 0% item for untaxed ones. QuickBooks does the arithmetic. When its rounding lands a cent or two off the store’s, add a small rounding line so the invoice still equals the order. A bigger gap means something is wrong: the item’s rate, or part of the order paid with something that isn’t on its lines.

2. A tax item for each store rate

Best for: stores using WooCommerce’s own rate table with a handful of rates (state, county, city).

Pair each store rate with the QuickBooks tax item of the same rate. When an order is taxed at several rates together, pair that combination with a QuickBooks tax group that holds the same members. Your QuickBooks sales tax reports then show each jurisdiction properly.

3. The exact tax as one line

Best for: stores using a tax service such as TaxJar or Avalara, which works out a rate for each address.

No single QuickBooks rate can match an address-level rate, so don’t ask QuickBooks to calculate it. Put the products on the invoice untaxed, under a 0% tax item, and add the tax the customer paid as one line on its own item, posting to your sales tax liability account. The invoice equals the order to the cent, and the tax you owe sits in one account. File from the tax service’s reports, since QuickBooks’ own tax reports won’t show those sales as taxable.

Two traps

Groups with mixed members. QuickBooks taxes each member of a group item by its own tax code. A taxed product paired with a group that has non-taxable members can come out short on tax, and an untaxed product paired with taxable members picks up tax it shouldn’t. Check groups before pairing them with web products.
Rate changes. When a rate changes, change it in both places on the same day. An invoice booked with the old rate in one system and the new one in the other is exactly the difference you’ll be hunting at quarter end.

In NemoWorks Sync

All three ways are built in (Settings, Sales tax, “How tax is written”). The rounding line covers up to a cent per taxed line per rate, never more than a dollar, and any larger gap stops the order before anything is written, with both tax figures in the message. The details are in the sales tax guide.