Skip to main content
December 10, 2024
Question

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

  • December 10, 2024
  • 2 replies
  • 0 views

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.

2 replies

December 11, 2024

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.

December 11, 2024

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.

December 11, 2024

@ScarletCleopatra 

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

December 11, 2024

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.