Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
ScarletCleopatra
Level 2

Why does the square integration interact so poorly with a sync'd bank account?

I have connected my square account to my Quickbooks account since my business uses square for processing transactions. Why in the world does Adding a transaction from the app transactions page and then matching with the bank transactions tool work differently than adding the transaction from the bank transactions and then matching from the square app transactions?

 

Doing it the wrong way completely screws up the journal entry for my bank account.

 

Also, why does the connect to square app not have any method for syncing product and customer names? The documentation for doing it manually isn't very helpful either. I am quite disappointed in the experience I am having with Square/QBO integration.

6 Comments 6
Anonymous
Not applicable

Why does the square integration interact so poorly with a sync'd bank account?

Thank you for detailing your issues with Square and QuickBooks Online (QBO), @ScarletCleopatra. I understand your frustration and am here to clarify how transactions are managed differently in QBO's Bank transactions tab versus the App transactions tab to streamline your process. Let's dive in.

 

Bank transactions in QBO specifically refer to funds moving in and out of your financial accounts. They are automatically pulled from financial institutions and require approval or categorization.

On the other hand,
App Transactions (like Square) in QBO are manually inputted or come from integrated applications, reflecting operational activities such as sales or expenses that might not yet be mirrored in your bank transactions. 

 

Connecting your Square account to QuickBooks Online brings your sales transactions automatically.

 

Additionally, you need to add your bank for Square in QuickBooks, download your bank transactions, and then match them to your Square app transactions.

 

Lastly, connecting to Square only matches exact customer names unless you manually assign a customer to an imported transaction. This setting applies to future transactions for both customers and products/services.

 

If you encounter further challenges with Square and QuickBooks integration, please reach out. I’m here to address them and help streamline your setup. Message me anytime.

Chrea
Level 8

Why does the square integration interact so poorly with a sync'd bank account?

@ScarletCleopatra 

Connect to Square app is a free app and it is not reliable. Consider having a paid connector app instead.

ScarletCleopatra
Level 2

Why does the square integration interact so poorly with a sync'd bank account?

They shouldn't offer it if it isn't reliable. Right now, I have had it destroy my books with multiple hour recoveries at least twice.

ScarletCleopatra
Level 2

Why does the square integration interact so poorly with a sync'd bank account?

I understand the distinction. That distinction is not my problem.

 

The problem is that it is so easy to mess up. Click the wrong accept button first or the wrong match button and all hell breaks loose leading to broken line items in journal entries that to hard to find and undo.

 

I clicked a few match buttons on the square app the other day and literally had to spend ten hours deleting the bogus lines from hundreds of journal entries.

 

The Connect to Square app doesn't act like a production app. It's more like an intern's side project proof of concept.

ScarletCleopatra
Level 2

Why does the square integration interact so poorly with a sync'd bank account?

I think I replied to the wrong comment. I mean to write this in reply to @Anonymous.

 

I understand the distinction. That distinction is not my problem.

 

The problem is that it is so easy to mess up. Click the wrong accept button first or the wrong match button and all hell breaks loose leading to broken line items in journal entries that to hard to find and undo.

 

I clicked a few match buttons on the square app the other day and literally had to spend ten hours deleting the bogus lines from hundreds of journal entries.

 

The Connect to Square app doesn't act like a production app. It's more like an intern's side project proof of concept.

TimotiSbr
Level 3

Why does the square integration interact so poorly with a sync'd bank account?

Check item mapping taxes and time zone first since those cause most Square issues. When I need cleaner totals I pull Square payouts and orders through Skyvia and post summarized entries into QBO so deposits and fees tie out. You can find it here.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us