Sync QuickBooks Sales Tax

Maxio doesn't calculate Sales Tax itself. Sales tax calculation is supported through the direct Avalara integration within Maxio, or through the sales tax calculation methods available within QuickBooks. Both QuickBooks-based methods require your Invoices to sync with QuickBooks before Sales Tax is calculated there and added back to your Maxio Invoices.

1. Use Avalara connected to your QuickBooks account instead of Maxio's direct integration. Avalara computes Sales Tax and inserts it into QuickBooks Invoices as an Invoice Line Item.
2. Use QuickBooks' own native Sales Tax or VAT Tax functionality, which QuickBooks calculates itself using Sales Tax settings you configure beforehand in QuickBooks Online or QuickBooks Desktop.

Using Avalara to calculate Sales Tax via QuickBooks

Avalara is a third-party tool that adds Sales Tax to Invoices in QuickBooks based on address and product rules defined and managed in Avalara. Sales tax added by Avalara is added as a Line Item on a QuickBooks Invoice, not the Invoice's own Sales Tax field.

Any Item in QuickBooks that's itself a Sales Tax Item must have Is Sales Tax checked in its Maxio Item settings.

QuickBooks needs to connect to and communicate with Avalara as you create an Invoice, so there's a real-time, but not sub-second, delay before Sales Tax is calculated. Since Maxio's own sync steps run in sub-second timeframes, a single sync often completes before QuickBooks has retrieved the Sales Tax amount from Avalara, so it doesn't yet appear on the Invoice in Maxio.

Important: If an Avalara-calculated Sales Tax amount isn't showing on an Invoice in Maxio after a sync, wait a few minutes and sync again. You can also open the Invoice directly in QuickBooks to check whether the Sales Tax Line Item is there yet. If it is, but a re-sync still doesn't bring it into Maxio, contact support@maxio.com.

QuickBooks Online native Sales Tax

Maxio sends Invoices to QuickBooks without Sales Tax. For QuickBooks to add Sales Tax automatically during the sync, mark the Product as taxable in QuickBooks Online: only when its Is taxable box is checked does QuickBooks add Sales Tax to a synced Invoice.

The Customer must also be marked as taxable. A Customer's Sales Tax Code can be set in either Maxio or QuickBooks Online.

QuickBooks Desktop native Sales Tax

Maxio sends Invoices to QuickBooks without Sales Tax. For QuickBooks to add Sales Tax automatically during the sync, mark the Item as taxable in QuickBooks Desktop: only when its Tax Code is set does QuickBooks add Sales Tax to a synced Invoice.

The Customer must also carry a taxable Sales Tax Code. This can be set in either Maxio or QuickBooks Desktop.

When Sales Tax blocks an Invoice from syncing

The Send Invoice Taxes as Item setting is required if both of the following are true:

• You use Maxio's Avalara integration to estimate or commit Sales Tax.
• You sync Invoices between Maxio and QuickBooks.

Without this setting configured, populating a Sales Tax amount on an Invoice blocks that Invoice's sync. Maxio flags this in two places: a warning on your Home page ("AvaTax Autocommit Enabled With No Sales Tax Item"), and a banner directly on the affected Invoice itself.

You'll see this if you select Re-estimate Sales Tax or Commit Sales Tax on an Invoice that hasn't yet synced to QuickBooks. This happens because Sales Tax in Maxio needs to sync to QuickBooks as an Invoice Line Item representing the full Sales Tax amount, and nothing tells QuickBooks which Item to use for that until this setting is configured.

Resolving the warning

To sync Maxio Invoices that have Sales Tax amounts to QuickBooks, tell QuickBooks which Item represents that Sales Tax by setting the Send Invoices Sales Tax as default.

To set the Sales Tax Item default

1. Go to Configure QuickBooks Integration Settings and set an Item as your default for Send Invoices Sales Tax as, under the Settings section.

   

2. Save the setting.

3. Sync to send every affected Invoice to QuickBooks.

The Item you select must be marked Is Sales Tax in its Maxio Item Profile settings.

If you need to create a new Item to represent Sales Tax, create it in QuickBooks first, then set up its Maxio Profile and select Is Sales Tax. You can edit an existing Item's Profile from Admin > Items, selecting the Item.

Is Sales Tax also affects future Invoices synced from QuickBooks to Maxio: instead of creating a separate Invoice Line Item for that Item, Maxio adds its Amount into the Invoice's Sales Tax total.

Related information

For an overview of how Maxio and QuickBooks share data, see Understand the QuickBooks Integration.

For the full set of Invoice sync conditions, see Sync QuickBooks Invoices.