Sales Tax Rate may change when invoice is created
Sales tax is recalculated when an invoice is created, so the tax rate at the time of invoicing might not match the original sales quote or order.
Sales tax in Acctivate is not locked based on the original Sales Order unless it's imported from a web store and no changes are made to the quantity and/or prices.
For manually entered orders, sales tax is recalculated at the time of invoice creation. This ensures the most current tax rate is used, which can cause discrepancies if tax rates change between order entry and invoicing.
Here’s what happens and how to handle this scenario:
-
Sales tax is recalculated when creating an invoice – When you open the “Create Invoice” window in Acctivate, sales tax is calculated using the current rate from QuickBooks or based on the Invoice Date with Avalara (if integrated).
-
Changes to sales tax rate affect invoicing – If a tax rate is changed after the order was entered but before the invoice is created, the invoice will reflect the new tax rate.
-
This behavior is expected – Because QuickBooks does not support historical effective dates for tax rates, it always uses the current rate, even for backdated invoices.
- To maintain the original rate manually (workaround) - This may only work if you are using an invoice date prior to the rate change (accrual basis) or the payment date was prior to the sales tax rate change (cash basis).
Workaround for QuickBooks Desktop users
- Switch QuickBooks Desktop to Single-User Mode.
- Void the invoice in Acctivate.
- Run a QuickBooks sync in Acctivate.
- Temporarily change the sales tax rate back to the original rate in QuickBooks.
- Sync QuickBooks again with Acctivate.
- Open the Sales Order, click Refresh (you may need to Edit then Save) to pick up the new sales tax rate.
- Re-create the invoice in Acctivate (now using the old rate).
- Sync with QuickBooks.
- Change the tax rate back to the new/current rate in QuickBooks.
- Run a final sync and return QuickBooks to Multi-User Mode.
Workaround for QuickBooks Online users (with Custom Rates)
- Void the invoice in Acctivate.
- Temporarily change the sales tax rate back to the original rate in QuickBooks.
- Sync with QuickBooks in Acctivate.
- Open the Sales Order, click Refresh (you may need to Edit then Save) to pick up the new sales tax rate.
- Re-create the invoice in Acctivate (now using the old rate).
- Change the tax rate back to the new/current rate in QuickBooks.
- Run a final Sync with QuickBooks.
⚠️ Important: This workaround is time-consuming and should only be used if matching historical tax rates is critical for business or customer service reasons.
Alternative: Apply a discount – If adjusting the rate is not feasible, you can apply a manual discount to offset the increased tax and preserve the customer’s original total and payment.