How do I fix a deleted transaction in a already reconciled report

Hey there, rusticfarmtofork,

Deleted transactions shouldn't be a worry for you. We have methods on how to fix them in QuickBooks, and I'd be happy to show you.

All you need to do is re-enter the transaction and re-reconcile it. This process is called mini reconciliation or special reconciliation. If this transaction was downloaded from your bank, you can simply go back to the online banking section and add it again.

Here's an article for more details: Reconcile previously deleted and re-entered checking or credit card transactions

The Comments section below is the best place to ask questions or post any other concerns, if you have any. Don't hesitate to give me a shout and I'll be with you right away.

A payment from 3 years ago  was deleted in error. My  current reconciliation is off by this amount. How do i rectify this?

I'd be glad to help you correct your reconciliation, Tashie.

In QuickBooks, create the payment transaction with the correct information first. Then, reconcile again. 

The articles below can help you troubleshoot reconciliations: 

• About beginning balance discrepancies
• Fix an opening balance to match a bank statement
• Reconcile hub

Don't hesitate to comment below or post again if you have further questions. 

Last week, I manually entered and reconciled transactions through March. I opened QB Desktop Pro 2017 today and let it update the software. Then when I went in and entered April transactions and went to reconcile, it showed the wrong beginning balance and when I ran a discrepancy report, it shows 5 deleted transactions that have completely thrown off my reconciliation. I restored from the most recent backup and the deleted transactions are still there - they were NOT there before I ran the software update.  Help!!

Thank you for posting here in the Community, @ksholgate.

You have the option to re-enter the transaction or undo and redo the previous reconciliation. Let me provide additional details about this and help you.

There are multiple reasons why your beginning balance is incorrect. Some of these include:

• No balance or an incorrect balance was entered when the account was set up.
• Previously cleared and reconciled transactions were voided, deleted, or modified.
• The file was converted from a different version of QuickBooks.
• Possible data damage.

You can correct your beginning balance by either undoing and redoing the previous reconciliation. Or by re-entering the transaction in QuickBooks.

If you prefer to undo then redo your previous reconciliation, you can follow these steps:

1. Click on Banking from the menu bar.
2. Choose Reconcile.
3. Select the Undo Last Reconciliation button from the Begin Reconciliation page.
4. Select Continue, then OK.
5. Close and reopen the Begin Reconciliation window.

You may refer to this article for more information: Zero or Incorrect Beginning Balance in the Begin Reconciliation Window.

Don't hesitate to tag me in your comment if you have any other concerns. I'll be sure to get back to you.

Thank you for your reply. The only cause in your list that's even remotely possible is that that, following an update yesterday, my data has been damaged. Last week, all accounts were reconciled successfully. I had done no data entry prior to yesterday so since the accounts were properly reconciled last week and now the ending balance from the previous reconciliation is wrong and there are five transactions that were not in there last week, something happened when I updated the software.  I rolled back to the backup I did last week before I entered data yesterday, but all that did was delete the transactions I entered yesterday; the ending balance from the last reconciliation is still wrong. How can I revert to the account prior to the software update?  The only explanation I can come up with is that the software update corrupted my data. Thank you for your help.

Thank you for your reply. The only possible explanation on your list is that my data was damaged yesterday when I updated my software. 

Last week, all accounts were correctly reconciled. I opened QB yesterday, updated the software from the popup box, entered one month's data, went to reconcile those entries and found that the ending balance from the previous month's reconciliation was wrong. When I went to undo that last reconciliation, those numbers were wrong too. When I ran a discrepancy report, it showed 5 transactions listed as deleted. I did no such thing. Between last week's successful reconciliation and entering yesterday's transactions, the only variable is the software update. I rolled back to the previous backup and all that did was delete my work from yesterday; the prior month's ending balance was still wrong.  

How do I take the software back to before the update yesterday? This is very frustrating! I appreciate any help you can give me. 

Thanks for getting back to us, @ksholgate.

Even if the data is damaged, QuickBooks doesn’t have the power to delete transactions during updates. Also, reverting back to the previous release is currently unavailable.

Let’s check the Audit Trail Report to see if someone else made the changes. Here’s how:

1. Go to the Reports menu and select Account & Taxes.
2. Select Audit Trail.
3. Choose the dates in the report’s page.
4. Click Refresh to update the report.

Once verified, re-enter the 5 transactions in QuickBooks with the exact information. Then, perform a mini or special reconciliation to resolve the incorrect ending and beginning balances. 

Check out the following articles for more information: 

• Zero or incorrect Beginning Balance in the Begin Reconciliation window.
• Reconcile previously deleted and re-entered checking or credit card transactions. 

That should get you on the right track.

Keep me updated on how this goes or if you have any questions. I’m always here to help. Take care!

I will have to try to work on this later this week. I am the only one who has access to this program.  So no one made these changes. SOMETHING happened when I updated. As a reminder: at my last access, all accounts reconciled correctly. There were no issues whatsoever. I updated using the popup on my screen when I opened the program. Immediately following the update, I entered the April/May transactions and went to reconcile and all of a sudden the ending balance from the previous reconciliation was wrong.  The only logical conclusion is that something bad happened during the update.  

Hi jaffakatie,

I know reconciliation can be challenging at times, especially if you’re dealing with historical transactions. I got your back and we’ll get through this.

Please double-check your bank register to see if the old transactions have duplicates or if they are really marked as reconciled. I know you deleted the old ones and reconciled (has R marks) the replacements. However, only the unreconciled and duplicates ones will show up when you reconcile.

If you can’t find duplicates or unreconciled transactions, you can do the basic browser troubleshooting steps to see if this is caused by a browser issue.

You can log in to QuickBooks in a private window and then reconcile. This is a good way to start checking it. If it looks good, you can go back to your regular browser and clear its cache. If you still see them, please try using other browsers like Chrome, Edge, Mozilla Firefox, or Safari to isolate the case.

Going forward, if you will upload transactions, just exclude the ones you've already entered in the register. To do this, just select the them, click Batch Actions and choose Exclude Selected.

I'm just around if you need more help with your reconciliation.

We deleted a deposit that was inadvertently entered twice prior to our fiscal year end (6/30/19).  We didn't notice this error until August, after we had already filed our tax return 990.  When we re-ran the Balance Sheet this year (Aug 2020)  for the same period (7/1/2018 to 6/30/2019), the amount is off from what we reported last year by the exact amount of that deleted deposit ($220) and the amount is actually $220 greater than prior to deleting the transaction.  How can we rectify this problem so our accounting is correct?  

QB saying I deleted transaction in prior reconcilation but it is still in check register and shows as cleared.  We upgraded right around this time, so could this be an error happening due to that?  Anyone know how I can fix this?  I don't want to undue a year's worth of reconciliations.  Ugh

I'd be glad to help you fix your reconciled transactions, @acimlee.

We can do a special reconciliation to correct this. Let me show you how:

1. Go to the Banking menu and select Reconcile.
2. Select the bank account with the transactions you need to reconcile.
3. In the Date of Statement field, enter the date for an off-cycle reconciliation.
4. In the Ending Balance field, enter the balance of your last successful reconciliation and then select Continue.
5. In the Reconcile window, check off the transactions you are fixing and re-reconciling.
6. Make sure the Difference field shows $0.00.
7. When everything looks good, select Reconcile Now.

I've also added these articles below that can help you troubleshoot reconciliations: 

• Fix issues when reconciling
• Fix an opening balance to match a bank statement

Don't hesitate to comment down below if you need further assistance in reconciling accounts in QuickBooks. I'll be more than happy to help.

Good Afternoon, 

We have a payment that was deleted from 2019, our reconciled balance is off by $700 which was the amount that was deleted. I tried added a general journal for that amount but the balance is still off by $700. Do you have any insight on what we can do? 

Thanks.

Hello @adejohn! Thanks for reaching out to us here in the Community. Hope you had a great weekend. :)

I'd recommend double-checking your journal entry and making sure the date on it is correct. If it isn't dated for 2019, that could be why the balance is still off. You can do this by finding that entry in your register for that account. 

1. While logged in as Master Admin, go to Accounting and then Chart of Accounts.
2. Click on View Register to the right of the account.
3. Find the journal entry and check the date.
4. Then, click in the blank box that is after Deposit until you see an "R".

If you need any more clarity or have any questions, please don't hesitate to respond to this post. We're all happy to help you!

Hi acimlee! Did you ever get this fixed?  We had the exact same thing happen this month.

What if it was an AP transaction from a previous year. The check was fine. I reentered the AP transaction and apply the check that belongs to it. How does this affect my balance sheet and the expense at last year's end. 

What if it was an AP transaction from a previous year. The check was fine. I reentered the AP transaction and apply the check that belongs to it. How does this affect my balance sheet and the expense at last year's end.

Welcome to the Community, BLRaf.
 

When deleted transactions display on your check register as cleared, you can perform a special reconciliation to correct them. This includes re-entering the transaction, then re-reconciling it. Detailed steps for this process can be found in Rubielyn_J's post.
 

As for identifying how correcting the information will affect your balance sheet and a prior year's ending expense, I'd recommend working with an accounting professional.
 

If you're in need of one, there's an awesome tool on our website called Find an Accountant. Each ProAdvisor listed there is QuickBooks-certified and able to provide helpful insights to drive your business's success.

Here's how it works:

1. Go to our Find an Accountant webpage.
2. In the Find an expert in section, choose what you're looking for, then use your search field to enter a City or ZIP code.
3. Click Search.
   
4. Browse through the results and find one that works best for your business. You can access each ProAdvisor's profile to learn more information about them.
   

Once you've found an accounting professional, they can be reached through their Send a message form:

1. Use your available text box to introduce yourself. Be sure to include details about the services you're looking for.
2. Enter the appropriate info in the Your name, Your email, and Your phone number (optional) fields.
3. Select Send message. 
   

You can also find many detailed resources about using QuickBooks in our help article archives.
 

I'll be here to assist if there's any additional questions. Have a wonderful day!

Thank you Rubielyn J from your post on Nov!  This is the answer that so many people are looking for.  Lots of people saying to Undo Last Reconciliation and that isn't necessary using your method!  Thanks you saved me from having to UNDO and REDO a full month of reconciling; just when I only needed to fix 2 known deposits where deleted and re-entered.  When re-entered, even if you correct the Reconciliation status to "clearer" it still messes up your next reconcilation statements opening balance.  As you said Reconcile the problem month and it is all fixed!!

I'm delight that the resolution above works fine for you, @kmggdc.

You are always welcome to come to us again if you have other concerns with customer, vendor, and payroll task. 

We are always available 24/7. Don't hesitate to visit us anytime.