Deleted reconciled transaction. How to correct?

I’ve re created mine but they are still in the list?

I’ve recreated mine but they are still showing on my list to reconcile.

Thanks for joining in on the thread, Cmharvey.

Recreating the transaction will bring them back to your register. Hence, they're also showing in your Reconcile page. We'll need to change their reconcile status manually to correct your data. Here's how:

1. After recreating the transaction, click Accounting on the left menu.
2. Go to the Chart of Accounts tab and look for the account that affects the recreated transactions
3. Click View register and look for the recreated transactions.
4. Under the Reconcile (✓) column, click on the blank field to mark the transactions as reconciled (R).
5. Click Save and select Yes to confirm the action.

Once you go back to the Reconcile page, these transactions should no longer display. You can use this link for reference: Undo and remove transactions from reconciliations in QuickBooks Online.

Then, you can already continue reconciling the account.

Let us know how this goes so we can further assist you. Additional screenshots would be much appreciated. Have a great day!

I have 3 transactions from the December reconciliation that for some reason now are no longer reconciled.  When I did the January reconciliation they showed as uncleared and when I manually make them reconciled, my beginning balance is off.

Help!  I'd like to undo the jan and dec reconc's but cannot do that in qbo without involving the accountant.

I would gladly help you undo bank reconciliation in QuickBooks Online, @Dash27.

When undoing bank reconciliation, you have the option to manually unreconciled each transaction without involving your accountant. However, it's still best to consult one, for they understand the cause and effect of doing the process. This is to ensure also that your book will not be messed up. 

To unreconcile a transaction, here's how:

1. Select the Accounting menu.
2. Choose Chart of Accounts.
3. Find the account holding the transaction and then click View register. 
4. Choose the transaction you want to unreconcile to expand the view.
5. Review the check column and if the transaction is reconciled, you’ll see an “R.”
6. Click the checkbox. Keep selecting it until the box is blank. This removes the transaction from the reconciliation.
7. Once done click Save and close the account register.

After unreconciling, you can reconcile the transactions again. You can also check this resource to guide you on how to handle reconciliation: Learn the reconcile workflow in QuickBooks.

If you have other concerns about QuickBooks, let me know by commenting below. I'm just one post away. Have a safe and productive rest of your day!

How can you correct the reconciliation if the transactions were intentionally deleted? Must you create, change to not reconciled and then delete those transactions again?

Thank you for reaching out to us, HMFSM.

I'll be glad to help you with your reconciliation concern.

We can't undo a deleted transaction. But, we can review the Audit Log to see the details and recreate it manually.

What we can do is recreate the deleted transactions.

Here's how:

1. Choose the Gear icon.
2. Select the  Audit Log.
3. View the deleted transaction.
4. Select View.
5. Look when it was created and deleted.
6. Notate the transaction details.
7. Select Create menu to recreate.

After we recreate, go to register and switch its status to Reconciled. 

You can also check on this article: Reconcile an account in QuickBooks Online for more information about Reconciliation.

We're always here in the Community to help if you have other questions related to Reconciliation in QuickBooks. Stay safe!

A deposit was deleted after the bank rec was done now I cant reconcile my bank because of the discrepancy.

Originally the deposit amount was entered wrong then instead of it being changed, it was deleted and a new one was created

How do i recreate a bank deposit that was done through paying customers invoices?

Hi CJumaga!

Thanks for joining this thread. Allow me to assist you with the reconciliation.

You're right. QuickBooks Online won't allow you to make a new reconciliation if there's a discrepancy or problem from the previous one. However, you can still re-reconcile it to fix the issue.

Once you recorded the customer invoice payment, make sure to deposit it as you normally do. Then, follow these steps:

1. Go to the Gear icon and select Reconcile.
2. Select the affected bank account under the Account drop-down.
3. Enter the new Ending balance after you deposited the right amount and the same Ending date from the previous reconciliation.
4. Add other necessary details and tap Start reconciling.
5. Reconcile the new deposit transaction. Make sure the difference is zero, then tap Finish now.

Here are some links you can check. These will show you how to fix reconciliation issues if you encounter one again, and how to save a report for future use:

• Learn the reconcile workflow in QuickBooks

• How do I view, print, or export a reconciliation report?

Do you need help in reviewing the activities made on your account? You'll want to use the audit log in QuickBooks Online.

Keep on posting here if you need additional assistance. Take care!

Hi there, 

I pulled up one vendor and accidentally deleted 5 bills that we had already paid in the last few months. I called quickbooks and a support rep had me create new expenses that we reconciled. 

At some point in the call, we realized these expenses created a larger balance. We went back to the vendor, changed each bill to "paid" and then deleted the expenses we had created. At this point, I have no idea if I have to go back in reconcile again and if I do, do I have to create another expense and then link it to the paid bills?

I called Quickbooks and asked to speak to the same representative, but they said that isn't allowed. 

Can you help?

Hi there, smm9bv.

I'm here to help you in restoring the deleted transaction. 

After recreating the bills, you'll have to apply the existing bill payments and then manually mark them as reconciled. Please make sure to use the actual payment date to keep your books are accurate and up-to-date. Once done, follow these steps to mark the transaction as reconciled:

1. Go to the Accounting menu.
2. Select Chart of Accounts.
3. Find the account holding the bill payments, then select View register. 
4. Select the transaction to expand the view.
5. Review the checkmark column.
6. Keep selecting the box until it shows the letter R.
7. Click Save, then close the account register.

I'm also adding these articles to learn how to resolve common reconciliation mistakes and errors in QuickBooks Online:
 

• Fix opening balance issues
• Fix beginning balance issues
• Fix issues while you're reconciling

I'm just a post away if you need more help in reconciling your accounts. Have a pleasant day ahead.

how to correct a DEPOSIT that was accidently deleted after reconciled?

FOR DELETED DEPOSITS does not work the same as other transactions.  Please assist.

2/24/22 this is not solved the person on line with me did not know as much and I have learned on my own.  She had me on hold for long time and NO solution.  frustrated.  Can someone who knows how to correct for a DELETED DEPOSIT please leave instructions.  Reminder, this is not the same as other a deleted transaction.

thank you in advance.

Thank you for posting on this thread, Firstclassbrenda.
I want to ensure your concern about the deleted deposits is taken care of. However, I have to ask for some details about the issue. This way, I can provide the best solution.

May I know if this is a merchant deposit? Have you tried recreating the transaction? If yes, did you encounter any issues?

I appreciate any information you can provide. I’m looking forward to working with you again. Have a good one.

Thank you for your response.  The deleted deposit was applied to a customer for payment on their account.

Yes, I have two deleted deposits, recreating the deposit in the customer did not solve the problem.

When clicking on reconciling and I go to Reconciliation Discrepancy Report both deposits are listed, I can view under the history tab, but it will not allow me to make any changes from here like it does if you need to re-create other transactions.  The key here is the type is DEPOSIT.  I sure appreciate your help.  thank you.

I want to make sure the deleted deposit in QuickBooks will rectify shortly, Firstclassbrenda. 

Thanks for the quick reply and additional information. I'm pleased to share some steps to help fix the deleted deposits in QuickBooks Online. 

Ensure to create a bank deposit and choose Accounts Receivable in the Account drop-down. This way, you can link this to the customer transaction. 

Proceed as follows: 

1. Go to the +New menu and select Bank Deposit. 
2. Choose the account you want to put the money into in the Account box.
3. Pick the customer name in the Receive From drop-down. 
4. In the Account box, select Accounts Receivable.  
5. Complete the other details, then click Save and close. 

For complete instructions, click this link: Record and make bank deposits in QuickBooks.

After that, re-link the client's transaction to that deposit by receiving the payments.

Once done, manually reconcile the deposit in the chart of accounts page. This way, the discrepancy will resolve.

Follow the steps below: 

1. Go to the Accounting menu and select Chart of Accounts. 
2. Double-click the bank account.
3. Locate the deposit and click the ✓ row until you see the letter R. This means the transaction is reconciled. 
4. Click Save. After that, the discrepancy amount should be fixed. 

Further, check out these articles below on how to troubleshoot reconciliation errors and personalize a chart of accounts: 

• Learn about the chart of accounts in QuickBooks Online
• Fix issues for accounts you've reconciled in the past in QuickBooks Online

Continue posting here if you need additional help in your customer transactions. I'm happy to help you again. Keep safe, Firstclassbrenda.

I did exactly this procedure and was able to re add the transaction back to the register, except when I go back to the register to click it as reconciled "R", that area is grayed out and I can't click anything.

I did exactly this procedure and was able to re add the transaction back to the register, except when I go back to the register to click it as reconciled "R", that area is grayed out and I can't click anything.

I'm here to take care of your concern, mhanson4.

Since your option is greyed out, first make sure you're the admin or allowed to access the reconciliation page.

To be more familiar with the different user access in QBO, kindly visit this article: User roles and access rights in QuickBooks Online.

If the issue persists, let's try using a private browser or incognito window as an initial step to fixing this issue. This will eliminate any browser history that may cause a glitch inside QuickBooks. You can refer to the following keyboard shortcuts below:

• Google Chrome: Ctrl + Shift + N
• Microsoft Edge: Ctrl + Shift + P
• Firefox: Ctrl + Shift + P
• Safari: Command + Shift + N

If it works, close out the private window and clear the cache on the regular browser. This will remove previously-stored browsing data that might have caused the issue. Otherwise, you can try other supported browsers to help narrow down the cause of this behavior.

I'm sharing there articles for your guidance when reconciling your account in QBO:

• Reconcile an account in QuickBooks Online
• Learn the reconcile workflow in QuickBooks

You might also want to learn more about managing reconciliation reports in QuickBooks Online by visiting this link: How do I view, print, or export a reconciliation report?

Get back to me if you need help with reconciliation or anything QuickBooks. I'd be happy to assist. Enjoy the rest of the day

I see many comments in these threads about how to recover a reconciled transaction that was deleted in error.  In my situation the transaction was not deleted in error - it was a duplicate transaction and needed to be deleted - it should have been marked as unreconciled before deletion, but was not.  The transaction was a transfer between 2 bank accounts.  The second of the duplicate transfers has been matched to the bank feed and cleared.  What are the steps to clear that error in the opening balance when there is no transition to restore? 

I'll help you fix this, scottca001

Since there is no transaction to be restored, you can enter an adjusting journal entry. This will force your accounts to balance so you can continue reconciling your accounts. Take note that you may need to consult your accountant before doing this to ensure that everything is recorded accurately. Here's how to create a journal entry:

1. Click the + New button, then choose Journal entry.
2. On the first line, select an account from the Account field. 
3. On the next line, select the other account you're moving money to or from.
4. Make sure you have the same amount in the Credit column on one line and the Debit column on the other.
5. Enter information in the memo section so you know why you made the journal entry.
6. Click Save and close.

I've also included some resources that will help you resolve common reconciliation issues in QuickBooks Online:

• Fix issues the first time you reconcile an account
• Fix issues for accounts you've reconciled in the past 
• Fix issues at the end of reconciliation

Just click the Reply button below if you need more help in dealing with your other tasks. Have a good one.

The remedy says to go to "View Register" in the Chart of Accounts. This expense account where the "deleted and reconciled" transaction allows only to Run Report or Edit the Account - NOT View Register. My user status is both an Admin and the Accountant.