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

Matching sales and bank deposits

Hello!

 

If I don't already have a sale recorded in quickbooks online when the bank deposit gets pulled into the bank feed, can I create a sale after the fact (so I can record the full amount plus any sales tax and Square CC processing fee, in separate accounts) and then match it to the bank feed when I reconcile? Or if I haven't created the sale prior to pulling in bank transactions, do I have to just categorize the deposits and then do a journal entry to properly account for the actual sale, sales tax, and CC processing? I am using an external banking institution, not Quickbooks checking or any Quickbooks affiliated bank account. I just have my external bank linked to my QBO (Quickbooks Online).

 

Thanks in advance!

2 Comments 2
acct_rakib
Level 1

Matching sales and bank deposits

Hello, you can opt for either of these approaches. If you create a sales invoice with the full figure, ensure you match it with the bank feed by splitting. Alternatively, you can categorize it directly as sales.

IrishNinoJ
QuickBooks Team

Matching sales and bank deposits

Hello there, CarlaE1. I'm here to ensure you'll matched your sales and bank deposits.

 

I agree with acct_rakib, both methods will work. First you can create a sales receipt and make sure to tick the Tax box.

 

Here's how:

 

  1. Go to + New, then select Sales receipt.
  2. From the Customer dropdown, select a customer.
  3. Enter the product or service that you sold.
  4. On the next line, add the processing fee item.
  5. Fill out the other necessary fields in the sales receipt and tick the Tax box.
  6. Select Save.

 

Alternatively, you can directly categorize or add as sales to make it easier for you to find the transactions when you reconcile. After that you can create a journal entry to properly account your transactions.

 

Check these articles for more tips and tricks on how to properly reconcile, find previous reconciliations, and fix any discrepancies:

 

If you have further concerns about bank transactions, feel free to come back here in the Community. We're here to assist you 24/7.

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

Need to get in touch?

Contact us