How to Restore Deleted Transactions in QuickBooks Desktop

QuickBooks Desktop does not have an “undo delete” button. Once a transaction is deleted, it is permanently removed from your company file. You can, however, recover the transaction’s details and get it back into your books through a few different methods: using the Audit Trail report to find the original details and re-enter them, restoring a backup file that still contains the transaction, or recovering bank-fed transactions through your bank connection.

Find the Deleted Transaction in the Audit Trail

Every action taken in QuickBooks Desktop is logged, including deletions. The Audit Trail report preserves the full details of deleted transactions: the date, amount, accounts, payee, and the user who deleted it. This is your primary tool for recovery.

To pull up the Audit Trail, click Reports in the top menu bar, choose Accountant & Taxes, then select Audit Trail. The report that generates will show every change made to your company file, which can be overwhelming. To narrow it down, click Customize Report, go to the Filters tab, and search for “Transaction type.” Select the type of transaction you’re looking for (invoice, check, bill, journal entry, etc.) and click OK.

If you know the transaction number, you can filter by “Number” as well. Set the date range to the approximate date of the original transaction or the date it was deleted. Deleted transactions will appear with a “Deleted” label in the report. Review the entry carefully and note every detail: the date, amount, account, memo, class, and any line items. You will need all of this to recreate it.

Re-Enter the Transaction Manually

With the Audit Trail details in front of you, open the same transaction type (invoice, check, bill, etc.) and recreate it from scratch. Use the original transaction date, not today’s date. This keeps your books accurate for the period the transaction actually occurred in and prevents problems if you’ve already reconciled that month’s bank statement.

Match every field to what the Audit Trail shows: the payee or customer name, the account(s) affected, the dollar amount on each line, the memo, and any class or job assignments. If the original transaction had multiple line items, add each one individually rather than lumping them into a single line. A mismatch in accounts will throw off your reports and could cause issues at tax time.

After saving the recreated transaction, check whether the affected account balances look correct. If the deleted transaction was part of a previously reconciled period, you may need to re-reconcile that month. Open the reconciliation window for the relevant bank or credit card account and verify that the ending balance still matches your statement.

Restore a Backup That Contains the Transaction

If you have a recent backup file (.qbb) from before the deletion happened, you can restore the entire company file to that point and retrieve the transaction. This approach works best when the deletion just happened and you haven’t entered much new data since the backup was made. If days or weeks of work have been entered since the backup, restoring it means losing all of that newer data, which usually isn’t worth it.

To restore a backup in QuickBooks Desktop:

  • Go to the File menu and select Open or Restore Company.
  • Select Restore a backup copy, then click Next.
  • Choose Local Backup and click Next.
  • Browse to the location of your backup file (it will be named something like YourCompanyName.qbb).
  • Choose a folder to save the restored file, then click Open and Save.

If your backup is stored on an external drive or a cloud storage service, copy it to your local hard drive first before starting the restore process. QuickBooks can have trouble reading directly from external or network locations.

Here’s the critical part: do not save the restored file into the same folder as your current company file unless you intentionally want to overwrite it. QuickBooks will warn you if you’re about to overwrite existing data. The safest approach is to save the restored file in a separate folder, open it, find the deleted transaction, write down all the details, and then switch back to your current company file and re-enter it manually. This way you get the transaction back without losing any recent work.

Recover Deleted Bank Feed Transactions

If the deleted transaction originally came in through a bank feed, you may be able to get it back without the Audit Trail. When you delete a bank feed transaction in QuickBooks Desktop, it sometimes moves to the Excluded tab in the bank feeds window rather than disappearing entirely. Open your bank feeds, look for an Excluded or Hidden tab, and check whether the transaction is sitting there. If it is, you can move it back to the For Review list and re-add it.

If the transaction isn’t in the Excluded tab, try disconnecting and reconnecting your bank feed. QuickBooks will re-download recent transactions from your bank, typically covering the last 90 days (though this varies by financial institution). Any transactions that no longer exist in your QuickBooks file will reappear in the bank feeds window for you to match or add.

You can also download a Web Connect file (.qbo) directly from your bank’s website. Log into your bank, export the transactions for the relevant date range in QuickBooks Web Connect format, then import the file into QuickBooks Desktop through the File menu. The deleted transaction will appear in your bank feeds for processing.

Prevent Future Accidental Deletions

QuickBooks Desktop lets you restrict who can delete transactions by setting up user permissions. Go to the Company menu, select Set Up Users and Passwords, then Set Up Users. For each user, you can limit their access so they can create and edit transactions but not delete them. Reserving deletion rights for one or two administrators significantly reduces the risk of accidental loss.

Set up automatic backups as a safety net. Under File, go to Back Up Company and choose Create Local Backup. In the options, you can schedule automatic backups every time you close QuickBooks or at set intervals. Keep at least a few days’ worth of backup files so you always have a recent restore point. Store copies on an external drive or cloud service in addition to your local machine, so a hardware failure doesn’t take both your working file and your backups at once.

QuickBooks Desktop also has a Closing Date feature that locks transactions before a certain date. Go to Edit, then Preferences, then Accounting, and set a closing date with a password. Once set, no one can delete (or modify) transactions dated before that cutoff without entering the closing date password. This is especially useful after you’ve filed taxes or completed a quarterly review.