Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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
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.
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!
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....
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here