cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Square Import and QB invoice

So i have a more unique issue with Square and QB.  I have an ecommerce that use square and the money from all the orders get deposit nightly in one lump sum. 10 orders for $800.

Now i also manually create invoices that use square as payment as well. I set the payment to undeposited fund account.  This then get grouped together with the nightly deposit from the site.  1 invoice for $200.      

So the imported nightly deposit will show $1000. 

So how do I make the invoice payment that shown as (Paid - not deposited) to reflect that it was already deposited via the nightly import? Now I have a bunch of money in Undeposited Fund account and a bunch of invoices that show as not deposit.  I don't want to create deposit slip since it would double count the invoices.

2 Comments 2
Fiat Lux - ASIA
Level 15

Square Import and QB invoice

Utilize the trial period of this connector to reconcile them.

https:// synder.grsm.io/quickbooks

 

JamesDuanT
Moderator

Square Import and QB invoice

Hello there, duy1.

 

Aside from the option provided by Fiat Lux - ASIA, you can also follow the suggestion of SkinnyRaven which is to initially deposit the invoice payment to the Undeposited Funds account. Then, enter the bank/merchant fee as a negative amount.

 

You can find the detailed steps of that process in this article, too: Record and Make Bank Deposits in QuickBooks Online.

 

Feel free to get back to us if you need clarification about it. Have a great day!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us