Skip to main content
B
Bram DHoest
August 14, 2020
Question

Quickbooks Online Square

  • August 14, 2020
  • 1 reply
  • 0 views

Hi, 

 

I use the Square app to sync my transactions to Quickbooks. 

Yesterday I had to add a new Tax code to Quickbooks because of an out of province whole sale order. 

 

The Square sync is now giving me an error in the log file: 

"Could not create the invoice in QuickBooks Online. Error: We encountered an error when creating an invoice in QuickBooks Online: Error: 400 Invalid Reference Id Invalid Reference Id : TaxRate"

 

I assume it's maybe related to adding a new tax code?

I've also checked the "defaults section" in the app "Integration Options and Logs" and set the default Tax there to HST ON and did a manual import but still the same error message.

 

Anybody else have this problem? Or know how to fix it? 

 

Thanks a lot!

Bram 

1 reply

L
LauraAB
August 14, 2020

Hello Bram,

 

Thanks for joining us and for the amount of detail you've gone into here with what's happening when syncing your data from Square to QuickBooks Online. Noting the change you made to account for sales tax in other provinces is also a good detail to have included as it may help us with determining what's going on. I'll get you started with some things you can consider to resolve the error.

 

Since you're working with sales tax, an important detail here is making sure you have the particular tax code you need set up in both Square and in QuickBooks Online. Since QuickBooks is reading and mapping the information from Square, it could produce errors when codes are missing in QuickBooks since it won't know where to map. If you haven't taken the step to add the code in QuickBooks Online in addition to Square, check out this article to learn the steps to take to do so: How to set up a new sales tax code

 

Next, it'll help to know which app you're using to connect Square to QuickBooks. Some apps, such as the Sync with Square app, are handled by the Intuit team, whereas others are handled by third-party developers. You'll want to make sure you're reaching out to the appropriate support team for the app you're using since it's in the sync, and therefore part of the app connection, that you're seeing the error. To check which team you need to contact, follow these steps.

  1. Click the Apps tab in QuickBooks Online's left menu.
  2. Choose My Apps.
  3. Select the app you're using.
  4. Review the App information section to see contact details.

If it's a third-party developer, reach out to that team to learn what troubleshooting steps you can take. If it's Intuit's Sync with Square app, here are some additional steps you can try before contacting support to make sure your Internet cache isn't causing troubles with the cloud.

If after that you're still getting the error message when trying to sync, I encourage you to review the following articles about this app to make sure everything is lining up as it should be.

That should get you on your way, but let me know if you have more questions!

B
Bram DHoestAuthor
August 15, 2020

Hi Laura,

 

Thank you for your suggestions, It is still giving me  the same error. I use both FireFox and Chrome on Windows with cache disabled for years without any issues. 

I also disconnected and reconnected the app after I made the Tax Code change in QBO just to make sure. 

 

Here are some screenshots.....  I should say that it has worked perfectly for years up until a couple of days ago and the only thing I changed was adding  the tax code in QBO. 

 

 

The app is  the one by Intuit:

 

Tax codes in QBO (added the HST NS):

 

Tax code is Square (no change):

 

Default settings:

 

Error file:

Thanks,

Bram

 

 

 

Let me know if you have any ideas....

 

L
LauraAB
August 17, 2020

Hello again, Bram. It's great that you're using the Sync with Square app and I appreciate you sending the screenshots. From looking at these, I can see it'll be better to troubleshoot outside of the Community platform so support can gather more details from you and have a one-on-one conversation. It may be as simple as making sure both platforms have the same sales tax codes set up, even if you're not using the HST for Nova Scotia in Square, but it may be more than that.

 

You've taken great troubleshooting steps so far and I want to make sure this gets resolved. Please don't hesitate to reach out using the number in the app's information tab as I outlined in my original response or by using one of the following methods.

 

Schedule a Callback or Chat: click (?)Help in the upper right > click Contact Us > explain your situation > click Let's Talk > choose Get a callback or Start a Chat

Social Media: Facebook, Twitter, and Instagram

 

We're here to help.

Terms & ConditionsAccessibility statement