cancel
Showing results for 
Search instead for 
Did you mean: 
therealdealgrill
Level 1

How can I import the total daily Square deposit that is deposited directly daily to the Square debit card in QB without each sale transaction? I'm getting all transaction

I don't have my funds transferred to my bank. I get them transferred to the Square Debit card. When I import them its each transaction not a daily total and that what I need
3 Comments 3
SarahannC
Moderator

How can I import the total daily Square deposit that is deposited directly daily to the Square debit card in QB without each sale transaction? I'm getting all transaction

Hi there, therealdealgrill.

 

Let me share with you some information about downloading the daily sales summary in QBO.
 

Can you share with me if the Square syncs with QuickBooks? If yes, downloaded transactions depend on what you've sync from Square.

 

If it's how the mapping works, I would recommend manually recording the daily sales within QuickBooks Online. For more tips and detailed information, please consider checking here. It contains step by step guide on how you can do it properly.

 

On the other hand, if you haven't synced with Square yet, you can look for a third-party application to help you bring the daily sales and integrate it with QuickBooks. 

 

Know that I'm always here to guide you in case, you still need my assistance. I hope you're well and safe. Take care!

therealdealgrill
Level 1

How can I import the total daily Square deposit that is deposited directly daily to the Square debit card in QB without each sale transaction? I'm getting all transaction

No it is not syncing automatically, I use the square debit card square offers to have my money deposited on. 

I get this error: (I Manual Import done a manual import from 4/1 - 4/30)

There were failed Settlements
a2f1e7dd-75f1-4300-8bfb-df162c0c4ddc:The total amount on the deposit is not matching to the Square settlement amount.ac5a43ac-6e92-4c3a-9485-953edcdf7c39:The total amount on the deposit is not matching to the Square settlement amount.

AlcaeusF
Moderator

How can I import the total daily Square deposit that is deposited directly daily to the Square debit card in QB without each sale transaction? I'm getting all transaction

Welcome to the Community, @therealdealgrill.

 

Allow me to chime in for a moment and share some information about importing transactions in QuickBooks Online.

 

The import process from Square will bring over each of the transactions into the system. You can either use the Bank deposit or Sales receipt option in QuickBooks to record your total daily deposit manually (see screenshot below).

 

 

For the error message, I suggest contacting the Square Support Team. One of them will need to take over and check the cause of the issue when importing.

 

Additionally, here are some helpful references that you can check out about entering deposits, as well as daily sales:

 

 

Please know that the Community has your back if you need assistance. Feel free to post a question, get answers, share tips, ideas, and more. Wishing you and your business continued success.

Need to get in touch?

Contact us