How do I restore a deleted reconciled transaction in QuickBooks Online (and is it excluded rather than deleted)?Before recreating anything, check whether the transaction is only excluded rather than truly deleted, because if it disappeared during a bank sync it may be sitting in your Excluded tab where a single Undo brings it back. If it's genuinely deleted, you'll recreate it from the details in the Audit log and then mark it reconciled again in the register.Step 1: Check the Excluded tab (the quick fix)Go to All apps, then Accounting, then Bank transactions.Open the Excluded tab.If you see the transaction there, select it and choose Undo to move it back for review.This is also why the transaction vanished and never came back on its own: once you exclude (or accept) a downloaded transaction, QuickBooks stops the bank from pulling it into the feed again, so undoing it from the Excluded tab is how you get it back rather than waiting for a re-download.Reference: Exclude a bank transaction you downloaded into QuickBooks Online.Step 2: If it's truly deleted, recreate it from the Audit logGo to Settings (gear icon), then Audit log.Filter by the date and event, find the deleted transaction, and select View to see its full details.Select + New, choose the same transaction type, enter the same details using the original date, then Save. Recreate it once; don't add an offsetting entry, or you'll create a duplicate.Reference: Use the audit log to re-enter deleted transactions in QuickBooks Online. On QuickBooks Desktop, use Reports, then Accountant & Taxes, then Audit Trail.Step 3: Mark it reconciled againGo to Settings, then Chart of accounts, find the account, and select View register.Select the recreated transaction, then click the checkmark column until it shows R, and Save.If the recreated transaction isn't showing in the register, use the Audit log to confirm which account it posted to, then open that account's register.If reconciliation still flags a differenceAfter recreating, the item may still appear on the Reconciliation Discrepancy Report, but the Total Discrepancy Difference should read $0.00; confirm your beginning balance, then resume reconciling. Guide: Fix issues with your beginning balance for accounts you've reconciled before.If you tell us whether the transaction shows in your Excluded tab, we can point you straight to the one-click undo or the recreate steps.

Hello Krystal, We won't be able to undo a deleted transaction. However, we can review the Audit Log to see the details and recreate it manually. Here's how: Click the Gear icon in the upper-right corner and select Audit Log. Look for the deleted transaction and click View. Click the arrow on when it was created and deleted. Take note of the transaction details. Recreate the transaction manually by clicking the Create menu (+).After we recreate the transaction, we can go back to your register and change it's status to Reconciled (R) manually. You can use this article for the detailed steps: How to Unreconcile a Transaction or Undo a Reconciliation. Let me know how this goes so I can give you a hand if necessary. Thanks!

Level 7

Solved

How do I fix a deleted reconciled transaction, I want it undone?

Forum|Forum|7 years ago
January 27, 2019
49 replies
436 views

No text available

QuickBooks Online

Best answer by sofiamdc-2341

How do I restore a deleted reconciled transaction in QuickBooks Online (and is it excluded rather than deleted)?

Before recreating anything, check whether the transaction is only excluded rather than truly deleted, because if it disappeared during a bank sync it may be sitting in your Excluded tab where a single Undo brings it back. If it's genuinely deleted, you'll recreate it from the details in the Audit log and then mark it reconciled again in the register.

Step 1: Check the Excluded tab (the quick fix)

Go to All apps, then Accounting, then Bank transactions.
Open the Excluded tab.
If you see the transaction there, select it and choose Undo to move it back for review.

This is also why the transaction vanished and never came back on its own: once you exclude (or accept) a downloaded transaction, QuickBooks stops the bank from pulling it into the feed again, so undoing it from the Excluded tab is how you get it back rather than waiting for a re-download.

Reference: Exclude a bank transaction you downloaded into QuickBooks Online.

Step 2: If it's truly deleted, recreate it from the Audit log

Go to Settings (gear icon), then Audit log.
Filter by the date and event, find the deleted transaction, and select View to see its full details.
Select + New, choose the same transaction type, enter the same details using the original date, then Save. Recreate it once; don't add an offsetting entry, or you'll create a duplicate.

Reference: Use the audit log to re-enter deleted transactions in QuickBooks Online. On QuickBooks Desktop, use Reports, then Accountant & Taxes, then Audit Trail.

Step 3: Mark it reconciled again

Go to Settings, then Chart of accounts, find the account, and select View register.
Select the recreated transaction, then click the checkmark column until it shows R, and Save.

If the recreated transaction isn't showing in the register, use the Audit log to confirm which account it posted to, then open that account's register.

If reconciliation still flags a difference

After recreating, the item may still appear on the Reconciliation Discrepancy Report, but the Total Discrepancy Difference should read $0.00; confirm your beginning balance, then resume reconciling. Guide: Fix issues with your beginning balance for accounts you've reconciled before.

If you tell us whether the transaction shows in your Excluded tab, we can point you straight to the one-click undo or the recreate steps.

J

JamesDuanT

QuickBooks Team

Hello Krystal,

We won't be able to undo a deleted transaction. However, we can review the Audit Log to see the details and recreate it manually. Here's how:

Click the Gear icon in the upper-right corner and select Audit Log.
Look for the deleted transaction and click View.
Click the arrow on when it was created and deleted.
Take note of the transaction details.
Recreate the transaction manually by clicking the Create menu (+).

After we recreate the transaction, we can go back to your register and change it's status to Reconciled (R) manually. You can use this article for the detailed steps: How to Unreconcile a Transaction or Undo a Reconciliation.

Let me know how this goes so I can give you a hand if necessary. Thanks!

P

poolinspectorpd

Where is the Create menu?

C

Charies_M

Level 9

Hello there, poolinspectorpd.

Thanks for getting back. Let me help clear this up for you.

You can manually recreate the transaction by click the Plus (+) icon or the create menu and choose what transaction you want to recreate.

I've attached a screenshot for a better view.

Stay in touch if you have additional questions about this. I'm always around in the Community to help you out.

A

Akami7H

1- how to fix beginning balance discrepancy of reconciled deleted transaction?

2- How to fix reconciled deleted transactions

A

AnneMariee

Thanks for joining the thread, Akami7H.

Let me provide answers to your questions about fixing reconciliation issues.

First, you'll want to review your last reconciliation to fix the beginning balance discrepancy. The opening balance for the current reconciliation could be affected by any changes made to the last reconciliation.

Additionally, you can review the Audit log to view the details of the deleted transactions. Then, you can recreate them manually.

Here's a step-by-step guide on how:

Click the Gear icon.
Under Tools, select Audit log.
Locate the deleted transaction. Then, click View.
Take note of the transaction details.
Recreate the transaction manually.

Once done, you can change the status its status to Reconciled (R) in the bank register. Check this article out for more details: Undo or remove transactions from reconciliations in QuickBooks Online.

For future help, here's a guide on adjusting entries: Enter an adjusting entry for a reconciliation in QuickBooks Online.

Keep in touch if you have other concerns about reconciling your accounts. I'm just one post away to help you out. Stay safe!

sofiamdc-2341

Answer

Community Manager

How do I restore a deleted reconciled transaction in QuickBooks Online (and is it excluded rather than deleted)?

Before recreating anything, check whether the transaction is only excluded rather than truly deleted, because if it disappeared during a bank sync it may be sitting in your Excluded tab where a single Undo brings it back. If it's genuinely deleted, you'll recreate it from the details in the Audit log and then mark it reconciled again in the register.

Step 1: Check the Excluded tab (the quick fix)

Go to All apps, then Accounting, then Bank transactions.
Open the Excluded tab.
If you see the transaction there, select it and choose Undo to move it back for review.

This is also why the transaction vanished and never came back on its own: once you exclude (or accept) a downloaded transaction, QuickBooks stops the bank from pulling it into the feed again, so undoing it from the Excluded tab is how you get it back rather than waiting for a re-download.

Reference: Exclude a bank transaction you downloaded into QuickBooks Online.

Step 2: If it's truly deleted, recreate it from the Audit log

Go to Settings (gear icon), then Audit log.
Filter by the date and event, find the deleted transaction, and select View to see its full details.
Select + New, choose the same transaction type, enter the same details using the original date, then Save. Recreate it once; don't add an offsetting entry, or you'll create a duplicate.

Reference: Use the audit log to re-enter deleted transactions in QuickBooks Online. On QuickBooks Desktop, use Reports, then Accountant & Taxes, then Audit Trail.

Step 3: Mark it reconciled again

Go to Settings, then Chart of accounts, find the account, and select View register.
Select the recreated transaction, then click the checkmark column until it shows R, and Save.

If the recreated transaction isn't showing in the register, use the Audit log to confirm which account it posted to, then open that account's register.

If reconciliation still flags a difference

After recreating, the item may still appear on the Reconciliation Discrepancy Report, but the Total Discrepancy Difference should read $0.00; confirm your beginning balance, then resume reconciling. Guide: Fix issues with your beginning balance for accounts you've reconciled before.

If you tell us whether the transaction shows in your Excluded tab, we can point you straight to the one-click undo or the recreate steps.

How do I restore a deleted reconciled transaction in QuickBooks Online (and is it excluded rather than deleted)?

How do I restore a deleted reconciled transaction in QuickBooks Online (and is it excluded rather than deleted)?

Sign up

Login with SSO

Let's get you signed in

Login with SSO