Skip to main content
M
MrTizzy
October 28, 2023
Question

How do you handle missing square deposit transactions?

  • October 28, 2023
  • 2 replies
  • 0 views
There are Deposit transactions missing from Square to match up with my bank account. How do you all handle this? I likely need to manually create the transaction, but not sure the details on how to do it. The Sales receipt is in there, and it matches the total dollar figure, but there's simply no Deposit transaction copied over to QBO. 

I'm using daily summaries in Square app integration.

2 replies

J
jeanbiverly_
October 28, 2023

I've got your back, @MrTizzy.

 

QuickBooks Online relies on the information provided by Square. If a deposit transaction isn't cleared on Square's end, it won't appear in QBO. 

 

Also, please note that the Connect to Square app doesn't have the functionality to support disputed transactions. If you have any such transactions, QBO will prompt you to exclude them. However, you can manually enter the deposit into QBO. Let me guide you how. 

 

  1. Click the +New button.
  2. Under the OTHER column, select Bank Deposit.
  3. Go to the Account dropdown, then choose the account you want to put the money into.
  4. Tick the checkbox for each transaction you want to combine.
  5. Ensure that the total amount of the selected transactions is the same as the amount on your deposit slip.
  6. Hit Save and close.

 

Alternatively, if Square deposits money to the same bank, you can add the transaction from the Banking tab.

 

In case you encounter issues when manually uploading bank and credit card transactions into QBO, you can visit this article for more guidance: Fix bank upload errors in QuickBooks Online.

 

Please feel free to reach out if you need further assistance with your missing transactions. I'm always here to help.

M
MrTizzyAuthor
October 31, 2023

Thank you for the response, but for a business that does an reasonable number of sales, that process isn't feasible. There really no way for me to know the amount that Square deposited and what specific item sales were in that deposit, minus the fees. Now if you are saying that there's a screen in Square that has the details which would allow me to enter them by transaction number to match up - please do let me know. Or, if there's a way to re-process specific days via the Connect to Square app, that might work as well (despite how buggy it is). 

 

Additionally, since posting this thread, I have realized that the integration has not only skipped deposits here and there, but has also skipped entire days - no sales or deposit records imported into QBO. It's not feasible to manually enter hundreds of transactions into QBO. 

Fiat Lux - ASIA
Fiat Lux - ASIA
October 31, 2023

@MrTizzy 

Consider having a 3rd party connector to reconcile Square transactions.

D
DebSheenD
October 31, 2023

I understand the importance of resolving the issue related to importing .qbo files from your bank accounts as quickly as possible, @MrTizzy. Rest assured that I'll route you to the department that can help sort this out. 

 

I would like to reiterate what my colleague mentioned about missing transactions from Square to QuickBooks.  The information in QuickBooks Online (QBO) is reliant on the data provided by Square. With this, you can a deposit report from Square to compare the transactions that flow in QBO.

Once done, you'll have to upload the missing deposit using a CSV file. Let me guide you through these steps:

 

  1. From the Transaction page, select Bank Transaction. Then click Link account.
  2.  Choose Upload from file.
  3. Click Drag and drop or select files and select the file you downloaded from your bank.
  4. Select Continue.
  5. Choose the account you want to upload the transactions.
  6. Click Continue.
  7. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.
  8. Select the transactions you would like to import. 
  9. Click Continue.
  10. Select Yes.
  11. Hit Done.


However, if you're unsure how to generate a transaction list from Square, I suggest reaching out to their support team for assistance.

Additionally, once the file is uploaded, you can review the entries and match them with transactions you've already entered into QuickBooks. Feel free to pin these articles for the detailed steps of the process:

 

 

Feel free to post a reply below if you have other questions about managing your bank transactions. I'll be here to help you. Stay safe.

Terms & ConditionsAccessibility statement