cancel
Showing results for 
Search instead for 
Did you mean: 
lisa_costa
Level 2

DoorDash integration with Square and passing data to Quickbooks fails due to tax rates

Hello, We use Square at our ice cream shop and have DoorDash integrated with Square.  We use Commerce Sync to pass data from Square to QuickBooks.  All of the sales tax information passed to QB flawlessly before we added DoorDash.  When we added DoorDash, all of the DoorDash transactions come with a new tax called "DoorDash Tax" in Square.  It's the same rate as our Square tax rate, but it records it as a separate tax rate.  This caused the integration to fail, as QuickBooks Online cannot handle multiple tax rates, at least that's what CommerceSync said. Now I have to manually add sales tax for all my Square transactions as a journal entry.  Has anyone else solved this problem more elegantly?
9 Comments 9
KlentB
Moderator

DoorDash integration with Square and passing data to Quickbooks fails due to tax rates

Hi there. lisa_costa.

 

I know how convenient to have those transactions accurately imported into the program. This way, you don't have to manually enter the sales tax.

 

Commerce Sync controls how the data is sent and received by QuickBooks Online. To ensure that this will be taken care of, I'd recommend contacting their support. They'll be able to review your integration and advise you on handling the sales tax. You can get their contact information here: Square by Commerce Sync.

 

For more tips and resources in managing your sales tax in QuickBooks Online, you can check out some topics from this page: Sales tax help articles.


Fill me in if you have any other concerns or follow-up questions. Have a good one.

Fiat Lux - ASIA
Level 15

DoorDash integration with Square and passing data to Quickbooks fails due to tax rates

@lisa_costa 

You should explore another connector to replace Commerce Sync.

lisa_costa
Level 2

DoorDash integration with Square and passing data to Quickbooks fails due to tax rates

CommerceSync said that the problem is on QuickBooks end, unable to accept multiple sales tax rates. Is this true?

JessT
Moderator

DoorDash integration with Square and passing data to Quickbooks fails due to tax rates

Hi Lisa!

 

Yes, that is correct. With Automated Sales Tax in place, QBO only supports one tax code on a transaction.

 

If there's anything that you need help with, feel free to go back to this thread. Take care and have a good one!

lisa_costa
Level 2

DoorDash integration with Square and passing data to Quickbooks fails due to tax rates

Thanks for confirming this. Is it possible for me to switch off this feature and go to manual? I assume it would then accept the sales tax records from CommerceSync without rejecting them?

 

 

Fiat Lux - ASIA
Level 15

DoorDash integration with Square and passing data to Quickbooks fails due to tax rates

@lisa_costa 

Afaik, you are not allowed to disable it. That's why I recommended exploring another connector to replace CS.

lisa_costa
Level 2

DoorDash integration with Square and passing data to Quickbooks fails due to tax rates

I appreciate you making the time to respond, but you seem to be missing the point. The data as it is in Square (with multiple sales tax rates) cannot be accepted by QBO. No other connector will be able to fix that problem. I can’t be the only business using Square, DoorDash and QBO together…

Fiat Lux - ASIA
Level 15

DoorDash integration with Square and passing data to Quickbooks fails due to tax rates

Most connector apps can only mark products as taxable or nontaxable based on any tax coming or not coming from the payment processor (e.g Square). The tax percentage itself is calculated by QuickBooks Online as we know it. However, you can utilize another connector app to record taxes into the tax field for correct tax reporting. The app will do the tax calculations. If you want the tax to be simply included in the sales total, you can disable that feature.

 

DrabComp
Level 1

DoorDash integration with Square and passing data to Quickbooks fails due to tax rates


@Fiat Lux - ASIA wrote: Panorama Charter

Most connector apps can only mark products as taxable or nontaxable based on any tax coming or not coming from the payment processor (e.g Square). The tax percentage itself is calculated by QuickBooks Online as we know it. However, you can utilize another connector app to record taxes into the tax field for correct tax reporting. The app will do the tax calculations. If you want the tax to be simply included in the sales total, you can disable that feature.

 


Looking great work dear, I really appreciated to you on this quality work. Nice post!!

Need to get in touch?

Contact us