When you see a difference between the total amount of your order in your sales channel compared to the invoice in QuickBooks Commerce and Xero, this is likely due to the way the taxes are calculated on the order.
When an order is imported from your sales channel, we will look for the tax rate and use that tax rate on the order in QuickBooks Commerce. QuickBooks Commerce then calculates the tax PER LINE ITEM and rounded off before the total. This method is generally accepted and is also used by multiple accounting software like Xero. However, since other sales channels have a different way of rounding off the totals, variances are often the result.
To bridge this difference, you can enable the “Rounding” option during Xero integration. This toggle will create a separate rounding line item that will bridge the gap between the invoice totals. You can assign a specific ledger where the value of the rounding line item will sync and reconcile it later on.
This option can also be enabled by going to My Apps > Xero > Ledger Accounts tab then click on "Automatically create Xero rounding line items."
To find out how we round off the tax totals on your sales orders, click here.
Have more questions? Submit a request