Skip to main content
November 16, 2023
Question

Deposit

  • November 16, 2023
  • 2 replies
  • 0 views

My client has three deposits with no corresponding sales receipt or invoice. I have completed Bank Reconciliation till 10/31/2023. I was looking at the summary of reconciliation as of 10/31/2023 and realised that there were 3 deposits dated 4/13/23 - $300.00,05/09/23 - $395.00 and 08/31/23 - $19.05 that has been uncleared. There was Sales Tax on the last one. Can I have the client create individual invoices in November 2023 and have it cleared when I do reconciliation for November 2023.

Please help and advise. Thank You.

2 replies

November 16, 2023

There are two ways we can sort out your concerns about clearing entries in QuickBooks Online (QBO), schand.

 

First, we can manually reconcile the transaction from the bank register to ensure the accuracy of your books. Thus, we can perform the manual reconciliation with these three deposits to clear them. You can perform the steps below on your client’s book:

 

  1. Go to the Bookkeeping menu and select Chart of Accounts (COA).
  2. Locate the account you previously reconciled and click View Register.
  3. Locate the three deposits and select them to expand the view.
  4. Look at the box if it has a C or blank, and make sure that the transactions are accurate.
  5. Tap the box in the checkmark column until you see an R. Once it has, you can leave it alone.
  6. Once done, select Save.

 

Please know that after performing the steps above, you may notice a slight difference in your balances. With that, you can correct the amount on your next reconciliation by making sure to add the same amounts you have reconciled on your opening balance for the next reconciliation.

 

If you prefer to keep a record of the sales transactions to match with these deposits, you can also record the invoices and I’ll outline to steps below to connect them to your deposits. 

 

Assuming that you’re done entering the invoice in your QBO. We can proceed to change the posting account of the deposit to Account Receivable (A/R). Doing so will give us an option to link them:

 

  1. Go back to your bank register and locate the deposit.
  2. From there, tap the transaction and click Edit.
  3. In the Bank Deposit window under the Add funds to this deposit section, select the name of the customer where you received the invoice in the Received From column.
  4. Select the Accounts Receivable in the Account.
  5. Add additional details you may need and click Save and Close.

 

After that, let’s record the invoice payment by utilizing the Receive Payment option. You can do so by following the instructions in this article: Record invoice payments in QuickBooks Online.

  

From there, select the invoice from the Outstanding Transactions and link this to the deposit by marking check the transaction under the Credits section. Then repeat the first process I have outlined in manually reconciling the transactions.

 

Moreover, you can tap your accountant to ensure the transactions are well associated and double-check the accuracy of your books.

 

Let me know if you have more questions about reconciliation and other QuickBooks-related matters. I’ll be right back on this thread to assist you. Take care!

Rainflurry
November 16, 2023

@schand4462 

 

Take @RoseJillB 's response with a grain of salt.  From what I've seen, QB employees do not know how to handle the accounting for situations like this.   

 

Did the deposits ever clear the bank?  Were these deposits that were made from undeposited funds as a result of a payment receipt and are, therefore, showing as customer credits?  Or, were they made using the Bank deposit function (New > Bank deposit)?  How can there be sales tax on the last deposit if there is no invoice or sales receipt?  The proper way to handle this depends on the answers to those questions.