QBO incorrectly imports split payment transactions from Square - cash will be placed in a separate sales receipt to card but added to the bank deposit. Can this be fixed?

Welcome to the Community, crosstherubiconi.

If data is sent to QuickBooks from a platform like Square, the data's entered into your books based on the transactions you're working with. If you're looking to change records that were imported a certain way, I'd initially recommend confirming with an accounting professional whether you should or shouldn't be doing so. After confirming the best course of action, they can also confirm how you should be entering the particular transactions.

If you're in need of an accounting professional, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.

Here's how it works:

1. Go to our Find a ProAdvisor page.
2. Use the City or ZIP search field to specify a location.
3. Select Find a ProAdvisor.
4. Browse through your results and find one that works best for the business. You can click on each ProAdvisor's profile to learn more information about them.
   
   

Once you've found an accountant, they can be contacted through their Send a message form:
 

1. Use the available text box to introduce yourself. Be sure to include details about which services you're looking for.
2. Enter your appropriate info in the Your name, Your email, and Your phone number (optional) fields.
3. Hit Send message.

You'll also be able to find many detailed resources about using QuickBooks in our help article archives.

If there's any additional questions, I'm just a post away. Have an awesome Thursday!

Thanks ZackE, it’s definitely an import error by the Connect to Square app in QBO. In Square you can see the transaction is appropriately split between card and cash, contributing to the totals for that day. The error in QBO is assigning the cash part of the payment to the electronic deposit erroneously, so you have to go in manually and remove it from that bank deposit to allow a match to occur with the transaction feed from my checking account.

Is there anyway to escalate this to the QBO/app team to get it fixed?

Hello there, crosstherubiconi. I'm here to help you track the mapping of your square transactions.

Incorrect account mapping may cause discrepancies in fee display between card and cash. Please verify and correct the mapping setup.

Here's how:

1. Select Apps on the left navigation bar.
2. Find Sync with Square.
3. Select Settings.

For more details, check this link: Sync with Square - Default Accounts and Names.

If everything is fine, I suggest contacting our Customer Support Team. This way, they can pull up your account securely and check the cause of the problem.

1. Go to the (?) Help icon.
2. Select Talk to a Human.
3. Enter a short description of your concern.
4. Click on I still need a human.
5. Tap Contact Us to connect with our live support.
6. Choose to Get a callback.

You might find the following articles helpful about adding and matching transactions in QBO: 

• Download, match, and categorize your bank transactions
• Reconcile an account

Keep me posted if you have any other questions about importing transactions into QuickBooks. I'm always here to help.

Thanks Maybelle_S, it is actually the newer "Connect to Square" app that I'm using now. I'll contact the Customer Support Team as described and let people know if there is a solution.

Did you find a solution? I'm having the same issue. 

Allow me to share some information about this matter, @thehootsfamily.

QuickBooks Online (QBO) is designed to seamlessly integrate with Square and other third-party apps, allowing for the easy transfer of data between platforms. This integration means that QBO can receive any data provided by Square. 

To avoid any discrepancies, it is important to ensure that the account mapping is correct. I recommend contacting Square Support to verify and correct the mapping setup.

If everything is fine, I suggest reaching out to our Support Team. This way, they can securely pull up your account and determine the root cause of the problem. 

Here's how: 

1. Go to the Help (?) icon.
2. Select the Search tab, then Contact us.
3. Choose a topic to connect with the right expert.
4. Select how would you like to connect with us.

I'll be leaving these articles that'll help you straighten out your books:

• Download, match, and categorize your bank transactions
• Reconcile an account

Don't hesitate to post again or hit the Reply button below if you have other concerns with QuickBooks application integration. I'm always around and happy to help. 

Hi @thehootsfamily , I haven't had much success. Square suggested I needed to use a new integration that requires a manual setup with a company called Amaka. Here was the link they provided to set it up:

setup guide

I didn't proceed given the errors are occasional for me, so didn't want to jump into the unknown.  Really frustrating you can't get support for an existing integration!  Hopefully someone hears us and fixes the existing integration so we don't keep running into these errors....