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

Reconcile: Past entry mistakes.

I made a few mistakes when first starting quickbooks by entering bank account charges as credit card charges. Oops! When you enter one of those entries quickbooks will not let you exit from the entry until you change the account associated with the charge to a credit card. Due to this I had to delete the CC charge entry and re-enter the charge as a debit card charge against the bank account. But now I have entries that are no longer cleared/reconciled. They are causing my beginning blance when trying to reconcile the account to be incorrect. How do I clear/reconcile just those entry mistakes (now correct as debit card charges) so that I can continue with my monthly reconciliation?

5 Comments 5
JonpriL
Moderator

Reconcile: Past entry mistakes.

Hi there, @JTBcafe!

 

You have the option to manually reconcile your recently created transactions. I'm here to share a few insights and help you from there.

  1. Go to Banking.
  2. Select Use Register.
  3. Choose your bank or credit card account.
  4. Click OK.

From there, you can manually reconcile your transactions so you can fix your opening balance when reconciling again your accounts.

 

However, if you're still unable to fix your opening balance, I'd recommend contacting your accountant. He/she has the tool to undo your reconciled transactions and help you correctly reconcile your accounts.

 

Lastly, you can also read this article which can be your guide for any future tasks: View Previous Bank Reconciliation Reports.

 

As always, you can leave a comment below or start a new thread if you have any other concerns. I'll be always around ready to help.

JTBcafe
Level 1

Reconcile: Past entry mistakes.

I manually reconciled the entries by checking the entry. When that was done I went to reconcile last months transactions and it still showed the previous wrong amount. Why did QB's not clear those entries from needing to be reconciled? It asked if I wanted to before recording and I said yes. 

GarlynGay
Moderator

Reconcile: Past entry mistakes.

There's another way correct the previous reconciliation, JTBcafe.

 

We can undo the previous months of reconciliation instead. Before doing so, please make sure to save a backup copy of your company file for safe keeping. Click on the File menu, select Back Up Company and create a local backup.


Then, the steps below helps you to undo previously reconciled account: 

  1. Click on the Banking menu.
  2. Select Reconcile.
  3. In the Begin Reconciliation window, click on the Undo Last Reconciliation
  4. Click on the Continue.
  5. Click on OK
  6. In the Begin Reconciliation window, click on Cancel.

1.PNG

 

Repeat the steps above until you're able to undo the oldest reconciliation.

 

For example, the latest reconciliation month was on June 2019 but the incorrect beginning balance was on January 2019. By clicking on the Undo Last Reconciliation button, you're unreconciling the month of June. Click on that button again to undo the May, then go on until you've reach the January's beginning balance.

 

However, if you have more than a year worth of reconciliation, run the Reconciliation Discrepancy report. It'll help us determine if QuickBooks created adjustments for these incorrect transactions. These amounts are added due to force reconciliation. Go ahead and delete them. Then, go to the register and manually put a letter "R" for these charges.  


Once done, start reconciling the bank account. We're right here to help if you need anything else.  

JTBcafe
Level 1

Reconcile: Past entry mistakes.

Wow. So the mistakes are in the first half of 2018.  So ill have to go back over a year of reconciliations to correct the mistakes? Theres no more effiecient way of correcting a poor entry? Not including the chance of causing new mistakes.

 

IamjuViel
QuickBooks Team

Reconcile: Past entry mistakes.

I can share additional information to correct your reconciliation, @JTBcafe.

 

Let's first run the reconciliation discrepancy report and perform a mini-reconciliation to fix the incorrect entry.

 

To run the discrepancy report, here's how:

  1. Go to Reports.
  2. Choose Reports Center.
  3. In the Search Box, type in Reconciliation Discrepancy Report.
  4. Click Run.
  5. Select the account you want to run the report.
  6. Hit Ok.

You can filter the date range of the report to last year and verify which among the transactions caused the discrepancy. You may refer to this article for more detailed information: Fix Reconciliation Discrepancies.

 

If there are new transactions added or modified the previously reconciled transactions,  you can now perform a mini reconciliation. For step-by-step instructions, you can check this article:

Reconcile previously deleted and re-entered checking or credit card transaction.

 

You can always swing by here in the Community if you have other questions. 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us