Go back to prior bank rec

I'm here to ensure your books are accurate, mforest.

Let's run the discrepancy report. This helps us find the transactions giving you problems. Here's how:

1. Go to Reports, then select Banking, and then Reconciliation Discrepancy.
2. Select the Account, and then select OK.
3. You'll have a list of transactions that changed since your last reconciliation. Use this report to identify the transaction(s) causing the issue.
4. If you find a discrepancy, note the transaction date and the Entered/Last Modified, which will tell you when the change happened.

To correct the discrepancy, you'll need to undo a previous reconciliation and redo it. For the detailed steps, please see these steps: 

1. Back up your QuickBooks company file.
2. Go to Banking, and then Reconcile.
3. Select Undo Last Reconciliation.
4. When prompted, select Continue and then OK.
5. Close out of reconciliation and open it again.

For more details, please see this article: Fix beginning balance issues in QuickBooks Desktop.

Once done, reconcile the previous transactions.

If you need to review a reconciliation report later on, please see these steps:

1. Go to the Reports menu, then select Reports Center.
2. Search and open a Previous Reconciliation report.
3. Select the account you reconciled, then either Detail, Summary, or Both.

Please keep us posted if you need additional assistance reconciling your account. We're always here to help.

Hello, thank you for your answer.  I ran the reconciliation discrepancy and I have many deposits that have been deleted.  My receivables balance, so how do I go about entering these deleted deposits without affecting the receivables?  

I've gone into my checking account, and have found that many of the deposits QB says were deleted are actually there.  These deposits also have the check mark indicating that they have been cleared. Why is QB saying these deposits were deleted when they are there and checked as clearing?

Thank you for coming back to the thread and adding further details about your concern, mforest.

To start with, I suggest reviewing all the deleted entries if they are appearing on the Chart of Accounts. Once verified that they show from there, compare them to what's in your register on your past statement. This is to verify if those deleted transactions are duplicates and if they are, you can just ignore them since those are already cleared in your QBDT.

However, if those deleted transactions are not duplicates and need to re-enter the program, you may refer to this article to see detailed steps and make sure everything is recorded accurately: Record and make bank deposits in QuickBooks Desktop.

Furthermore, you can open this article to see extra details on how you can edit or enter the transactions again to correct the discrepancy: Fix beginning balance issues in QuickBooks Desktop.

Lastly, you may refer to this article to see guidelines that might help you fix any reconciliation problem that you might encounter: Learn the reconcile workflow in QuickBooks.

Please don't hesitate to click the Reply button below if you still have other concerns related to reconciliation in QBDT. I'm always here to help you out, Hellocarwash. Have a good one!

“To start with, I suggest reviewing all the deleted entries that being shown are appears on the Chart of Accounts.”

I don’t understand this.  All these transactions appear in the checking account which is certainly in the Chart of Accounts. And yes these same entries are on my bank statement.

“However, if those deleted transactions are not duplicates and need to re-enter the program. You may refer to this article to see detailed steps and make sure everything is recorded accurately: Record and make bank deposits in QuickBooks Desktop.”

Yes I understand that several deposits are grouped so that they total the amount in my bank statement.

“Furthermore, you can open this article to see extra details on how you can edit or enter the transactions again to correct the discrepancy: Fix beginning balance issues in QuickBooks Desktop.”

The problem with undoing a bank reconciliation is that the beginning balance remains incorrect.  The first entry in my “Previous Reconciliation Discrepancy Report is on 11/5/2020.   The next entry is on 3/31/2022 and proceeds through 11/6/2022.

So again I need to know why it is that the so called “Deleted Deposits” are actually in my business checking account.  This does not make sense to me. How am I going to correct this by undoing and redoing bank reconciliations? 

I appreciate you for getting back to this thread, @mforest.

To fix an incorrect balance, we need to find the transactions giving you problems by running a Reconcile Discrepancy. For detailed steps, you can utilize the steps provided by CharleneMae_F in this thread. 

Then, to correct any discrepancy, you may need to edit or enter the transactions again. You can try one of the following options:

• Undo a previous reconciliation and redo it
• Ignore the discrepancy and let QuickBooks enter an offsetting adjustment

For more information, please see this article: Fix beginning balance issues in QuickBooks Desktop. 

Once done, you can go back to reconciling your accounts, so they match your bank and credit card statements.

Feel free to get back in here if you have further questions about fixing beginning balance in QuickBooks. I'm always around to help. Keep safe!

But the first deleted deposit in my "Previous Reconciliation Discrepancy report occurred on 11/05/2020. The rest are all in 2022. So do I have to repeatedly undo two years of reconciliations? 

Thanks for your prompt reply, @mforest.

The resolution given by my colleagues above is for fixing reconciliation discrepancies. However, in the process of undoing reconciliation from your two years' previous transactions, It would be best to seek professional advice from your accountant to ensure the accuracy of your books. If you're not affiliated with one, you can utilize our Find an Accountant tool to look for one in your area.

If need be, you're also free to reach out to our QuickBooks Desktop Support Team. They have tools to look into your accounts in a safe environment to help find the discrepancies and give possible fixes. 

Here's how:

1. Go to the Help menu, then select QuickBooks Desktop Help.
2. Select Contact Us.
3. Please give a brief description of your issue, then select Continue.
4. Sign in to your Intuit account and choose a way to connect with us.
   
   

You can check our availability hours when contacting support to ensure we handle your concern promptly.

I appreciate your patience while fixing your concerns with your transactions. You can always reply or reach out to us again if you need anything else. We're always here to guide and assist you whenever you need help. 

Hello, yes I may contact support, but is there a way to undo two years of bank recs to get to where the problem started. I still don't understand why the discrepancy report is showing deleted deposits when the deposits are actually there.

I appreciate you returning to the conversation and providing more information on your concern, @mforest. 

Let me chime in and share additional details about reconciling transactions in QuickBooks Desktop (QBDT). 

Yes, you can undo the reconciliation to locate where the problem started. However, since it's 2 year's worth of reconciliations, we suggest backing up the company before he can undo it. 

Here's how you can undo reconciliation in QuickBooks Desktop:

1. Go to the Banking menu.
2. Choose Reconcile.
3. Then click the button Undo Last Reconciliation. 
4. Review the fields. If the info is correct, select Continue and then OK.

Also, it would be best if you consult your accountant if undoing the transactions is the best option for you or they can suggest another way to fix the reconciliation. If you don't have one, no worries. Here's a link so you can find one near you: Find ProAdvisor. 

I also found these handy articles you can read more about managing reconciliation in QuickBooks Desktop:

• Reconcile previously deleted and re-entered checking or credit card transactions.
• Reconcile an account in QuickBooks Desktop.

Please let me know if I can be of any help with your reconciliation in QBDT. I'm here to help you achieve your goals. Take care always.

I am going in circles here.  I talked to tech support and she had QB do an adjusting entry so my beginning bank balance is correct.  Then  these "deleted" deposits that really were not deleted  show up in my bank reconciliation as outstanding  deposits.  So I go into the check register and delete them.  Now they just show up in my Payments to Deposit  window as undeposited amounts.  Please stop giving me solutions that you just look up to fix one thing without looking at the whole picture.  IS THERE ANYONE OUT THERE THAT UNDERSTANDS QB WELL???  I have work to do here, but I can't till this nonsense is fixed!!!

Hi mforest,

I understand how you feel knowing the instructions seem to go back and forth and nothing is resolved. Let me continue to help you with your reconciliation.

If you created a backup file before following the instructions, you can restore it so we can start over.

• If the change/s on a reconciled month affected the bank balance, you would need to re-reconcile that month down to the next affected reconciled months. Uncheck (unreconcile) the transactions in the affected periods and re-reconcile month by month.
• If the change only affected the reconciliation statuses, categories, or anything but NOT the balance, you only need to reconcile edited, added, or replacement transactions. Learn more about special or off-cycle reconciliation.
• Always check for the running balances in the BALANCE column of the register, and make sure they coincide with the running balances on your bank statement/s.

On the other hand, the Reconciliation Decripancy Report will show your deleted transactions even if you replace them with another entry or re-create a similar type of transaction. This maintains the integrity of the reconciliation and tells you that a particular transaction has been deleted from that month. Some users will re-reconcile that month to get a new reconciliation report.

You can always go back to this thread if you need more help. We're just around to continue assisting you.

Thanks for answering.  The deposits listed as "deleted" in the reconciliation report were all in my check register.  I don't understand why QB was not recognizing them. Prior posters recommended I undo prior bank recs, but you are stating to just uncheck them?

Thank you for visiting the QuickBooks Community again, mforest. I'll be sharing extra details on how undoing reconcilation works in QuickBooks Desktop. Then, I'll ensure you can manage your reconciled entries so that your account remains accurate.

To start with and as I mentioned above, it could be the deleted transactions that also appear on your check register are duplicates. Then, once verified that they are, you can just ignore them since those are already cleared in your QBDT.

Furthermore, if those deleted entries are not duplicates and need to be re-entered into the program, you can start recording them. You may refer to this article to see detailed steps and make sure everything is recorded accurately: Record and make bank deposits in QuickBooks Desktop.

On the other hand, when undoing bank reconciliation in QBDT, there are two methods available. The first is to select Undo Last Reconciliation, as suggested by my colleague above. The second option is to manually undo the transactions by going to the bank register and unchecking the checkmark column.

Lastly, you can view this article to see how QuickBooks Desktop provides various reports that will inform you about various aspects of your business so that you can manage your reconciled transactions: Understand reports.

Please feel free to leave a reply on this thread if there's anything else you need about your reconciliation in QuickBooks Desktop. I'll be around to help you out again, mforest. Have a good day ahead.