Sales tax info not importing to QB correctly

Started by bobbininc, April 20, 2020, 01:04:18 PM

Previous topic - Next topic

bobbininc

Hi,
We are now collecting sales tax in many states. When we import to Quickbooks, it recalculates the sales tax amount. We do not want it to do that - the amount is calculated by an external service in the Yahoo Store. We just want QB to accept the amount calculated, since QB cannot know the specific tax rate, as many states have multiple rates.

Is there a way to force QB to accept the sales tax amount as shown in Supermanager?

David Johns

SuperManager does have a way to adopt the shopping cart calculated tax. This is actually the first method of taxes that we implemented way back when we added support for exporting to QuickBooks for this very reason. To acheive this, go to "View", "Store Settings", select the "Accounting Export" tab and find the "Tax Reference Item" export option. Change this option to a tax item you have defined in QuickBooks that has a 0% rate. You likely already have one since I beleive before the time of this post you were using this default approach.

Thanks,
David
SuperManager Support
info@thesupermanager.com

bobbininc

Okay, one follow-up question: If I make this change, will the state detail be preserved in QB? In other words, will the sales tax amounts for each state still be listed separately in the QB sales tax reports/

David Johns

No, it does not. Currently it's only possible to have a single sales tax item, which means it is  to one state. There are likely ways to query the transactions in QuickBooks to split it out into different states.

Thanks so much,
David
SuperManager Support
info@thesupermanager.com