Hey there, @rhondakjos. Happy to help out here. If you've deleted transactions that had the Reconciled status, you will need to re-create them. To find the information from the transactions you deleted, you can check out the Audit Log. It's super easy and only takes a few clicks. Take a look: Go to Gear ⚙, then Audit Log.Click the Filter drop-down, pick the dates when the transactions were deleted, then choose the Show only these events radio button.Tick the Transactions checkbox, then select Deleted/Voided Transactions from the Show drop-down.Hit Apply.The Audit log will now be filtered to only show deleted transactions based on the filters you applied. Find the transactions that were deleted in the list and click View.You can use the information displayed here to re-create the transaction. Be sure to change the transactions status in the register back to R for Reconciled. If you aren't sure how to change the transaction's status back to Reconciled from within the register, it's super easy. Check it out: From the account register, locate the transaction you just recreated.Change the reconciliation status to "R" by clicking on the blank box in the column marked with a check mark. Once your transaction has an R next to it, it's reconciled. That's it! Please reach out if there's anything else I can do to help, I'm determined to be your number one resource for QuickBooks Online.

Solved

How do I fix a reconciled transaction I accidentally deleted in QuickBooks Online?

Forum|Forum|6 years ago
February 11, 2020
45 replies
794 views

No text available

QuickBooks Online

Best answer by katelynner

When a reconciled transaction is deleted, QuickBooks can't restore it automatically, so the fix is to look up its details in the Audit log, recreate it with the original date, and then set its status back to reconciled in the register. Doing both steps is what keeps the account reconciling correctly, since recreating alone leaves it looking unreconciled.

Step 1: Find the deleted transaction's details in the Audit log

Go to Settings (gear icon), then select Audit log.
Select Filter, then narrow by the user, the date range when it was deleted, and the Events option for deleted/voided transactions.
Select Apply, find the transaction, and select View in the History column to see everything you need to recreate it.

Full steps: Use the audit log to re-enter deleted transactions in QuickBooks Online.

Step 2: Recreate the transaction

Re-enter it using the details from the audit history, and be sure to use the original date so it lands in the right reconciliation period.

Step 3: Mark it reconciled again in the register

Recreated transactions come back as unreconciled, which is why they reappear on your reconcile list until you do this.

Go to Settings (gear icon), then Chart of accounts.
Find the account, then select View register.
Select the recreated transaction to expand it.
In the checkmark column, select the box until it shows R (reconciled).
Select Save.

Note: bank and other balance-sheet accounts have a register (View register), while income and expense accounts show Run report instead.

If the deleted item was a deposit tied to a customer payment

A deposit that recorded a customer's payment is a bit different from a simple expense, because the payment and the deposit are linked. If recreating the deposit alone doesn't clear it and it keeps appearing on your reconciliation discrepancy report, recreate the customer payment first, then the deposit that grouped it, so the link is rebuilt before you re-mark it as reconciled. If it still won't clear, that's a good point to have your accountant or QuickBooks support look at it with you.

If your beginning balance is now off

Deleting and re-marking reconciled transactions can change the ending balance of a prior reconciliation, which throws off the next beginning balance. When you start your next reconciliation and see the alert, select the "We can help you fix it" link to open the discrepancy report and work through each flagged change until the total discrepancy is $0.00.

Full steps: Fix issues with your beginning balance for accounts you've reconciled before. When everything lines up, continue with Reconcile an account in QuickBooks Online.

If a recreated transaction still won't clear or your discrepancy won't reach zero, reply with what the discrepancy report shows and we'll help you track down the difference.

Michael K

Level 4

Hey there, @rhondakjos. Happy to help out here.

If you've deleted transactions that had the Reconciled status, you will need to re-create them. To find the information from the transactions you deleted, you can check out the Audit Log. It's super easy and only takes a few clicks. Take a look:

Go to Gear ⚙, then Audit Log.
Click the Filter drop-down, pick the dates when the transactions were deleted, then choose the Show only these events radio button.
Tick the Transactions checkbox, then select Deleted/Voided Transactions from the Show drop-down.
Hit Apply.
The Audit log will now be filtered to only show deleted transactions based on the filters you applied. Find the transactions that were deleted in the list and click View.
You can use the information displayed here to re-create the transaction. Be sure to change the transactions status in the register back to R for Reconciled.

If you aren't sure how to change the transaction's status back to Reconciled from within the register, it's super easy. Check it out:

From the account register, locate the transaction you just recreated.
Change the reconciliation status to "R" by clicking on the blank box in the column marked with a check mark. Once your transaction has an R next to it, it's reconciled.

That's it! Please reach out if there's anything else I can do to help, I'm determined to be your number one resource for QuickBooks Online.

C

Cmharvey

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

C

Cmharvey

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

J

JamesDuanT

QuickBooks Team

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:

After recreating the transaction, click Accounting on the left menu.
Go to the Chart of Accounts tab and look for the account that affects the recreated transactions
Click View register and look for the recreated transactions.
Under the Reconcile (✓) column, click on the blank field to mark the transactions as reconciled (R).
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!

D

Dash27

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.

F

Firstclassbrenda

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

F

Firstclassbrenda

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

F

Firstclassbrenda

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.

R

Rasa-LilaM

QuickBooks Team

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.

F

Firstclassbrenda

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.

U

UniIlo

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.

M

Mich_S

Level 5

I know exactly how you can add the deleted transaction back to QuickBooks Online, @UniIlo.

When a reconciled transaction is deleted, you'll have to first review the Audit Trail page, then locate and take note of the transaction detail. Once done, you can proceed in recreating it:

Open the Gear icon and hit Audit Log.
Choose the Filter drop-down and select the right user, date, and event(s).
Once done, hit Apply.
Then, find the deleted transaction.
When you locate the deleted item, hit View under the History column.
You'll see all the information needed for the transaction under the Event section.
Use that details to re-enter the transaction with its original date.

After that, manually reconcile the transaction by going to your account register.

Select the Gear icon and pick Chart of Accounts.
Search for the account where the transaction is allocated. Then, hit View register.
Choose the transaction to expand the view.
Go to the check column, and continuously hit the box until you see R (reconciled).
Then, hit Save.

Here are helpful modules you can read about handling bank reconciliation in QuickBooks Online:

The Community is always available 24/7. Fill me in if you need extra help with banking or QuickBooks in general. Your efforts are much appreciated, stay safe!

B

bookkeeper_99

okay so I deleted a reconciled entry in qbo as it was incorrect. I added in the correct entry from open uncollected deposits. this was done multiple times as the accountant wanted the uncollected deposits cleared up. They are now cleared up; however I cannot reconcile because now my beginning balance is off and it's because of all the deleted reconcile transactions. please help!

K

kandyjk

I have recreated and marked reconciled any transactions I deleted or changed from the previous reconciliation.....but it still won't let me reconcile. Any other ideas? I've checked that all entries are correct for the 2022 year I'm working in. It says my beginning balance is off my a certain amount but all past entries have been reconciled from the previous year.??

katelynner

Answer

Community Manager

When a reconciled transaction is deleted, QuickBooks can't restore it automatically, so the fix is to look up its details in the Audit log, recreate it with the original date, and then set its status back to reconciled in the register. Doing both steps is what keeps the account reconciling correctly, since recreating alone leaves it looking unreconciled.

Step 1: Find the deleted transaction's details in the Audit log

Go to Settings (gear icon), then select Audit log.
Select Filter, then narrow by the user, the date range when it was deleted, and the Events option for deleted/voided transactions.
Select Apply, find the transaction, and select View in the History column to see everything you need to recreate it.

Full steps: Use the audit log to re-enter deleted transactions in QuickBooks Online.

Step 2: Recreate the transaction

Re-enter it using the details from the audit history, and be sure to use the original date so it lands in the right reconciliation period.

Step 3: Mark it reconciled again in the register

Recreated transactions come back as unreconciled, which is why they reappear on your reconcile list until you do this.

Go to Settings (gear icon), then Chart of accounts.
Find the account, then select View register.
Select the recreated transaction to expand it.
In the checkmark column, select the box until it shows R (reconciled).
Select Save.

Note: bank and other balance-sheet accounts have a register (View register), while income and expense accounts show Run report instead.

If the deleted item was a deposit tied to a customer payment

A deposit that recorded a customer's payment is a bit different from a simple expense, because the payment and the deposit are linked. If recreating the deposit alone doesn't clear it and it keeps appearing on your reconciliation discrepancy report, recreate the customer payment first, then the deposit that grouped it, so the link is rebuilt before you re-mark it as reconciled. If it still won't clear, that's a good point to have your accountant or QuickBooks support look at it with you.

If your beginning balance is now off

Deleting and re-marking reconciled transactions can change the ending balance of a prior reconciliation, which throws off the next beginning balance. When you start your next reconciliation and see the alert, select the "We can help you fix it" link to open the discrepancy report and work through each flagged change until the total discrepancy is $0.00.

Full steps: Fix issues with your beginning balance for accounts you've reconciled before. When everything lines up, continue with Reconcile an account in QuickBooks Online.

If a recreated transaction still won't clear or your discrepancy won't reach zero, reply with what the discrepancy report shows and we'll help you track down the difference.

Sign up

Login with SSO

Let's get you signed in

Login with SSO