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

Deposit Issue - Reconciling

I had a client switch accounts and a check that was reconciled on Nov. 2021 bank statement came back bad.

 

I deleted the line item from the Nov. 30, 2021 deposit and now need to re-insert it because the amounts do not match. 

 

I have accessed the deposit but cannot create the entry into undeposited funds acct.

 

How can I correct my mistake and make the deposit match the reconciled one?

3 Comments 3
MaryLandT
Moderator

Deposit Issue - Reconciling

I can help you match the bank deposit to the reconciled one, ColaStar.

 

The deleted one will affect the balance on the reconciled account starting November 2021. You need to start by entering the deposit with the correct amount.

 

Here's how:

 

  1. On the Homepage, select Record Deposits / Make Deposits.
  2. In the Payments to Deposit window, select the payments you want to combine. Then select OK.
  3. In the Make Deposits window, select the account you want to put the deposit into from the Deposit to dropdown.
  4. Check the deposit total. Make sure the account and selected payments match the deposit slip from your bank. Use your deposit slip as a reference.
  5. Enter the date you made the deposit at your bank.
  6. Add a memo as needed.
  7. When you're done, click Save & Close.

 

After entering the deposit, you can undo previous reconciliations until November and redo them. Before proceeding, make sure you back up the company file.

 

Here's how:

 

  1. Go to the Reports menu, then select Banking, then Previous Reconciliation.
  2. Select the appropriate Account and Statement Ending Date. Select Display.
  3. Compare this report to past statements from your financial institution.
  4. In the Begin Reconciliation window, select Undo Last Reconciliation.
  5. When prompted, select Continue then OK.
  6. Close and reopen the Begin Reconciliation window.
  7. Start reconciling the bank account again.

 

I'm adding these links to fix mismatches and other reconciliation issues.

 

 

Stay in touch with me if there's anything else you need about fixing the reconciled bank account. I'm always right here to guide you.

ColaStar
Level 1

Deposit Issue - Reconciling

Thank you, but I'm not sure I accurately described my issue.

 

I reconciled Nov. - all was good. 

 

Then, a client switched banks and let me know a check on my Nov. 30 deposit was not good, so I went in and deleted that line item from the deposit (thus decreasing the total deposit by $355). 

 

They since mailed in another check and so I simply applied that to the invoice, so the invoice is satisfied and the new check is on another Dec. deposit.  

 

The issue is that I messed up the ability to correctly reflect my error, so I just need to re-enter the line item on the Nov. 30 deposit in QB so that it matches my deposit receipt from the bank where I deleted it. 

 

When I go into that  Nov. 30 deposit to try to do that, QB won't let me add the line item for the $355 back in because it does not match the account for AR.

 

??

RenjolynC
QuickBooks Team

Deposit Issue - Reconciling

Thanks for your prompt reply and for clarifying out your concern, ColaStar.

 

When you're unable to add the line item, you'll want to undo the previous reconciliations until November. Before doing so, please create a back up copy of your company file

 

Here's how:

 

  1. Go to Banking > Reconcile.
  2. In the Begin Reconciliation window, select Undo Last Reconciliation.
  3. When prompted, click Continue then OK.
  4. Close and reopen the Begin Reconciliation window.

Once done, update the deposit with the correct amount for November. Then, reconcile the account again. Here's an article for the instructions: Reconcile an account in QuickBooks Desktop.

 

If you're unsure about making any changes on the past reconciled transactions, please reach out to your accountant. The process can get tricky and they know how to handle the next steps. Don't have an accountant? We can help you find one.

 

I'll re-share these articles to help you fix and manage the reconciliation balance:

 

You're always welcome to reply on this thread if you have any additional questions or concerns. Me and my colleagues are here to help. Take care!

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

Need to get in touch?

Contact us