Square Import on Discounts Calculates incorrect Tax

Ensuring your sales receipts are imported correctly is essential to keep the QuickBooks tax calculation and reporting accurate, CColotiHTF. I'm here to help you sort this out.

Integrating Square with QuickBooks Online (QBO) automatically imports your sales data into QuickBooks. However, the accuracy of QBO relies on factors such as how the integration settings are configured, how transactions are imported, and the completeness of the data synced from Square.

To rectify this, I recommend checking the mapping setting in the Square program. This way, we'll be able to ensure all the details in your sales receipts will sync accurately.

If the settings are correct, I suggest contacting the Square Support Team. They have access to your account details and can provide insights into why the receipts discounts aren't populating in the correct field, which causes incorrect tax calculations. They can also ensure this gets resolved.

In the meantime, I suggest manually editing the sales receipts. Then, place a checkmark under the Tax column to ensure the correct calculation will reflect.

Finally, I recommend visiting our FAQ page to learn more about how the Square program works. Then, run the Sales Tax Liability report to check how much sales tax you owe in QuickBooks Online.

Please let me know by clicking the Reply button here or starting a new thread if you need additional assistance managing your sales receipts, tracking the payments in QBO, and recording other sales entries. I'm ready to assist you in ensuring your transactions are tracked correctly in QBO.

This has been a proiblem qith QBO since "auto" sales tax was enabled 2 years ago.

First the import does NOT check the tax box to properly adjust the total on import which makes no sense why it's not checked since it's "reverse" taxable and needs to be removed from the taxable total.  Making the line item NON taxable still does not adjust the totals right.

Also the rounding is ALWAYS off from what Square has in it's reports and then what your auto calculations are...so we have to manually override the tax to MATCH square's tax collected on the register report.  There is no way to disable auto calculations, so everything becomes MORE cumbersome with integrations not easier to use.

We now have to use soley the sqaure reports for sales tax filing so since that is what is actually been collected by customers, your quto calculations plus the lack of the line item being excluded make for a mess with this integration.  I can't believe someone has not looked more into this such as DO NOT apply auto calculations when importing from square, just insert the tax number square collected as a raw value.