Skip to main content
February 13, 2024
Question

Matching sales and bank deposits

  • February 13, 2024
  • 2 replies
  • 0 views

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 replies

acct_rakib
February 29, 2024

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.

February 29, 2024

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.