cancel
Showing results for 
Search instead for 
Did you mean: 
leann9
Level 1

HOW DO I ADD BACK A RECONCILED DELETED ITEM

I NEED TO REVERSE A DELETION
14 Comments 14
DivinaMercy_N
Moderator

HOW DO I ADD BACK A RECONCILED DELETED ITEM

I've got here steps that will surely help you, @leann9.

 

You'll have to manually recreate the deleted reconciled item in QuickBooks Online (QBO). To get the details of that deleted transaction, you'll have to check your Audit Log. Here's how:

 

  1. Click the Gear icon and select Audit Log.
  2. Select the Filter drop-down and pick the appropriate user, date, and event(s).
  3. Once done, click Apply.
  4. Then, locate the deleted transaction.
  5. When you found the deleted item, click View under the History column.
  6. You'll see all the information needed for the transaction under the Event section.
  7. Use that details to re-enter the transaction with its original date.

 

Once finished recreating the deleted item, go to your account register to manually reconcile the transaction. Let me guide you how:

 

  1. Click the Gear icon and choose Chart of Accounts.
  2. Look for the account where the transaction is allocated. Then, select View register
  3. Select the transaction to expand the view.
  4. Under the check column, continuously click the box until you see (reconciled).
  5. Then, select Save.

 

For your reference, feel free to visit this article: Undo or remove transactions from reconciliations in QuickBooks Online. It also includes steps in fixing reconciliation errors.

 

You can also generate a handy copy of your reconciliations to have a reference guide in the future. You can also print or export it and save it on your desktop folder. 

 

I'm here to back you up again if you have more questions about adding back a deleted reconciled item in QBO. Just leave the details here and I'll get back to you as soon as possible.

Churchbooks2
Level 1

HOW DO I ADD BACK A RECONCILED DELETED ITEM

I do not have a gear on the right upper corner and the gear I found does not have Audit log under it

RenjolynC
QuickBooks Team

HOW DO I ADD BACK A RECONCILED DELETED ITEM

Thanks for joining in on this thread, Churchbooks2.

 

It seems like you have the desktop version of QuickBooks. The Audit Log is called Audit Trail for this this version, and you can find this report by following these steps:

 

  1. Go to Reports located at the top.
  2. Select Accountant &Taxes, then choose Audit Trail.
  3. Click the Customize Report button to filter the report.

To learn more about the different reports and how to customize them in QuickBooks Desktop, you can check out these guides:

 

As for fixing your reconciliation, please feel free to read this article: Learn the reconcile workflow in QuickBooks.

 

You can reach out to me again if you have any additional questions or other concerns. I'll be right here to help you out. Have a good day ahead!

cu_out
Level 3

HOW DO I ADD BACK A RECONCILED DELETED ITEM

how to re-enter transaction with its original date as I clicked deleted on the initial transaction in error.

Carneil_C
QuickBooks Team

HOW DO I ADD BACK A RECONCILED DELETED ITEM

Thanks for joining the thread, @cu_out. I've got some information you need so you can re-enter a deleted transaction in QuickBooks Online.

 

You have the option to recreate the deleted item on your account register to manually reconcile the transaction.

 

Here’s how:

  1. Click the Gear icon and choose Chart of Accounts.
  2. Look for the account where the transaction is allocated. Then, select View register
  3. Select the transaction you recreated and enter the necessary details.
  4. Under the check column, continuously click the box until you see (reconciled).
  5. Then, select Save.

 
Please know that when the transaction isn’t reconciled yet, there is no need to follow Step 4.

 

Also, you can check this article for further details on how to undo or remove transactions from reconciliations.

 

In addition, here are a few extra articles that can help you along the way: 

I’m always ready to assist you if you have any other questions or concerns about managing your bank transactions. Tag me in your reply and I’ll sprint back into action. Have a good one and keep safe. 

GBRSHRM
Level 1

HOW DO I ADD BACK A RECONCILED DELETED ITEM

Your #3 step - Select the transaction you recreated and enter the necessary details.

How do you actually recreate the transaction? 

jackieh
Level 1

HOW DO I ADD BACK A RECONCILED DELETED ITEM

By mistake I deleted a transaction that had already been reconciled, and now that I am going to reconcile again my initial balance has a discrepancy, how do I correct it?

 

we have Quickbooks enterprise.
Can I re-enter a transaction that has already been reconciled? Will it affect the final balance - initial in my next reconciliation?

QueenC
Moderator

HOW DO I ADD BACK A RECONCILED DELETED ITEM

Thanks for joining the thread, @jackieh. I can see that you're experiencing the same issue with other users on the thread but with a different product. Mistakes do happen and I can see how this delayed your reconciliation process. No worries, I know a way to fix a mistakenly deleted reconciled transaction in QuickBooks Desktop.

 

 First, let's identify the deleted transaction by going to your Audit Log:

 

  1. Go to the Reports menu then select Accountant and Taxes.
  2. Choose Audit Trail from the side menu.


     
  3. Customize the report by filtering specific date range to easily find the deleted transaction.

 

When found, take note of the details then re-enter the transaction with the same details such as the date and amount. When done, you can reconcile it again.  You can refer to this article for detailed instructions on performing a mini or special reconciliation to get your books accurate as they should be: Reconcile previously deleted and re-entered checking or credit card transactions

 

By performing the steps above, we'll be able to get rid of the discrepancy and ensure that the initial balance for your next reconciliation won't get affected. 

 

I've also included additional articles that'll help you fix reconciliation issues or discrepancies:

 

 

Moreover, did you know that QuickBooks Desktop has an available report that'll help us locate transactions that cause reconciliation discrepancies? Yes, you heard it right and it is the Reconciliation Discrepancy report. To help you run this report and any other available reports, feel free to check out this article: How to run and customize reports in QuickBooks Desktop.

 

Feel free to drop by again if you need more help in handling a deleted reconciled transaction in QuickBooks Desktop. Rest assured, we are committed to your success and are here to support you every step of the way. Stay safe.

A Khan
Level 1

HOW DO I ADD BACK A RECONCILED DELETED ITEM

Hey there, I'm trying to reconcile my bank account but opening balances doesn't match as some reconciled transactions were deleted. When I go into audit log to view history, it doesn't show anything. Please help!

GebelAlainaM
QuickBooks Team

HOW DO I ADD BACK A RECONCILED DELETED ITEM

Hello there, Khan.

 

I'll ensure you can flawlessly reconcile your account in QuickBooks Online (QBO).

 

Since you're unable to see the deleted transactions in the Audit log, you can review the discrepancy report instead. From there, you can check each missing transaction and recreate it.

 

Here's how to review discrepancy reports:

 

  1. Go to the Gear icon.
  2. Select the We Can Help You Fix it link to open your discrepancy report.image (3).png

  3. Review the discrepancy report. Use it to decide if and how to make changes.
  4. Before editing anything, talk with whoever made the changes - they may be intentional.

 

You can refer to this article for additional details: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

If you've recreated the transactions, you can go back to your register and change its status to Reconciled (R) manually. You can use this article for the detailed steps: How to Unreconcile a Transaction or Undo a Reconciliation.

 

Additionally, you'll need to pull up a statement from your bank for that specific period to compare what entries are missing so you'll know what details to recreate if you're still unable to view the deleted reconciled transactions in the discrepancy report.

 

I'm attaching these articles for future reference:

 

 

If you have clarification about the process or other QuickBooks-related concerns, tag me in the comment section. I'm just a post away.

Sophiya
Level 1

HOW DO I ADD BACK A RECONCILED DELETED ITEM

Why won't anyone actually answer the question: How do I recreate a transaction? Found the audit log, found the transaction details, found the register. Great, now how do I actually recreate the transaction for it to show up in the register? 

JoanaC
QuickBooks Team

HOW DO I ADD BACK A RECONCILED DELETED ITEM

Hi there, Sophiya.

 

If a transaction is deleted, it must be manually recreated exactly as it appears in the Audit Log.

 

Here's a step you can follow to recreate a transaction:

  1. Go to your left panel.
  2. Click +New.
  3. Select the appropriate transaction base on the audit log.
  4. Fill up the necessary information.
  5. Click Save and Close.

 

Once done, we must mark it as "R" to indicate that it has been reconciled in your register if the transaction was previously reconciled.

 

Here's how to mark it as "R": 

 

  1. Go to Chart of Accounts.
  2. Click View Register.

p1.png

3. Find the recreated transaction an click the transaction. 

4. Under the check mark, click it until "R" will show.

p3.png5. Click Save.

 

Let me share an article for your reference: 

 

Learn the reconcile workflow in QuickBooks.

 

Let me share some articles that can assist you with your reconciliation:

 

If you still have concerns with recreating your transactions, you can always reply on the thread or create a new post. Have a lovely day!

JessEavesPlus8886
Level 2

HOW DO I ADD BACK A RECONCILED DELETED ITEM

I accidentally deleted a reconciled journal entry. When I try to re enter it and manually Reconcile it, it gives me an error saying that "inclusive tax type is not aloud"   the tax is exempt. There is no tax. How do I get around this so o can continue to Reconcile? 

Ivan_G
QuickBooks Team

HOW DO I ADD BACK A RECONCILED DELETED ITEM

Thanks for dropping by this thread, Jess. I've got the details about the "inclusive tax type is not allowed" error and how to get past it.

 

The error occurs when you enter Journal Entry (JE) data with a specific tax code or amounts applied. Since the transaction has a tax-exempt setup or if you didn't add any tax values, but the error persists, let's initiate some troubleshooting steps.

 

To proceed, let's open your account using a private browser, and from there, try reentering and reconciling the JE. Refer to these keyboard shortcut keys to proceed:

 

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

 

If you can successfully generate and reconcile the JE seamlessly on a private session, revert to your regular browser and clear its cache and cookies. Doing so eliminates excessive data build-up that causes the system to demonstrate abnormal behaviors. Nevertheless, consider using another supported browser if you encounter the same problem.

 

I'm also attaching these resources that can be handy in employing JE to your unpaid invoices and printing a copy of your JE in QuickBooks:

 

 

Tap the Reply button if you have follow-up concerns with your JE entries and the reconciliation process or need help managing other transactions or reports. I'm always here for you every step of the way.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us