How Can You Recover Lost QuickBooks Data and Restore a Backup File?

Losing access to QuickBooks data can be stressful, especially when the missing information includes transactions, invoices, customer records, or other important accounting information. The appropriate recovery method depends on what happened to the data and whether you have a backup available.

QuickBooks Desktop users can restore an earlier company file from a backup, while QuickBooks Online provides different recovery options for deleted transactions. In some situations, the company file may not actually be deleted and may simply have been moved, renamed, or saved in another location.

Before making major changes, it is important to avoid entering additional information into a damaged or incorrect company file. First determine whether the original file can be located or whether a suitable backup is available.

How Can You Check If Your QuickBooks Company File Is Missing?

Before restoring a backup, make sure the original company file is actually missing.

A QuickBooks Desktop company file normally uses the .QBW extension, while a QuickBooks backup file normally uses the .QBB extension.

Search your computer for:

• .QBW files

• .QBB files

You can also use the No Company Open window in QuickBooks Desktop to search for company files.

If you locate the original QBW file, you may be able to open it directly instead of restoring an older backup.

How Can You Restore a QuickBooks Desktop Backup File?

If your company data was deleted, damaged, or lost because of a computer problem, a QBB backup can provide an earlier version of your company file.

Follow these general steps:

1. Open QuickBooks Desktop.

2. Select File.

3. Choose Open or Restore Company.

4. Select Restore a backup copy.

5. Choose Local Backup.

6. Select Next.

7. Locate your .QBB backup file.

8. Select the backup you want to restore.

9. Choose where to save the restored company file.

10. Select Save.

QuickBooks creates a new company file from the backup.

Should You Restore the Backup Over Your Existing Company File?

It is safer not to immediately overwrite your current company file with an older backup.

An old backup may contain the information you need to recover, but it may not contain transactions entered after the backup was created.

Instead, restore the backup to a separate folder or use a different file name. You can then compare the restored company file with your current file and determine which information needs to be recovered.

This approach reduces the risk of accidentally replacing newer accounting information.

How Can You Find an Older QuickBooks Backup?

If you are unsure where your backup was saved, search your computer for files ending in .QBB.

Also check locations where you normally store backups, including:

• External hard drives

• USB devices

• Cloud storage

• Other computer folders

• Backup locations used by your business

Check the date and time of each backup to identify the version most likely to contain the information you need.

Remember that an older backup may not include transactions entered after that backup was created.

How Can Intuit Data Protect Help Recover QuickBooks Data?

If you use Intuit Data Protect with QuickBooks Desktop, you may be able to restore an older version of your company file.

A general process is:

1. Open Intuit Data Protect.

2. Select Restore from Backup.

3. Choose the files or folders you want to restore.

4. Select the required backup date.

5. Restore the files to a temporary location first.

6. Review the restored information.

7. Move the files to their permanent location when appropriate.

Restoring to a temporary location first provides an opportunity to check the files before replacing anything on your computer.

How Can You Recover Deleted Transactions in QuickBooks Online?

QuickBooks Online works differently from QuickBooks Desktop.

A deleted transaction cannot simply be restored directly from the Audit Log. However, the Audit Log can provide information about the deleted transaction that you can use to recreate it manually.

To review the Audit Log:

1. Sign in to QuickBooks Online.

2. Open Settings.

3. Select Audit Log.

4. Use the available filters to locate the deleted transaction.

5. Open the transaction history.

6. Review the available details.

7. Recreate the transaction manually in QuickBooks Online.

Depending on the available history, you may be able to review details such as the transaction date, amount, customer, and other information.

What If Your QuickBooks Desktop Company File Is Damaged?

Data loss is not always caused by deletion. Sometimes the company file is still available but has data damage.

QuickBooks Desktop includes the Rebuild Data tool, which can help address some minor company-file data problems.

To access it:

1. Open QuickBooks Desktop.

2. Select File.

3. Choose Utilities.

4. Select Rebuild Data.

5. Follow the instructions provided by QuickBooks.

6. Create the required backup.

7. Allow the rebuild process to complete.

8. Use Verify Data afterward to check the company file.

Always create a backup before attempting to rebuild or repair company-file data.

What Should You Do Before Replacing Your Current QuickBooks File?

Before replacing an existing company file with an older backup, consider the information that may have been entered since the backup was created.

An older backup may contain the missing information, but it could also be missing newer transactions.

For a safer recovery process:

• Keep a copy of your current company file.

• Restore the backup separately.

• Use a different folder when possible.

• Compare the restored and current files.

• Determine which information needs to be recovered.

• Avoid deleting the current file until you are confident about the recovery.

This gives you an opportunity to review the restored data before making a permanent change.

How Can You Prevent Future QuickBooks Data Loss?

Regular backups can make future recovery much easier.

QuickBooks Desktop allows you to create local backups and, depending on your setup, schedule automatic backups. Keep backup copies in a different location or on another device when possible.

Good backup practices include:

• Create backups regularly.

• Keep more than one backup when appropriate.

• Store a copy separately from the computer.

• Check that backup files are available.

• Use clear file names and dates.

• Avoid relying on only one backup location.

• Keep the current company file available before restoring an older version.

Having multiple recovery options can reduce the impact of computer problems or accidental data loss.

QuickBooks Data Recovery Checklist

Before restoring or changing your QuickBooks company file, review this checklist:

• Search for the original .QBW company file.

• Search for available .QBB backup files.

• Check external drives and USB devices.

• Check cloud storage locations.

• Review backup dates.

• Keep a copy of the current company file.

• Restore an old backup separately.

• Compare restored and current data.

• Use Intuit Data Protect if available.

• Review the QuickBooks Online Audit Log for deleted transactions.

• Use Rebuild Data for supported Desktop data problems.

• Create a backup before major changes.

Frequently Asked Questions

Can I restore lost QuickBooks data without a backup?

It depends on what happened. If the company file was simply moved or renamed, you may be able to locate the original QBW file. For deleted QuickBooks Online transactions, the Audit Log can provide information that may allow you to recreate the transaction manually.

What is a QBB file?

A QBB file is a QuickBooks Desktop backup file. QuickBooks can use it to create a restored company file.

What is a QBW file?

A QBW file is the working QuickBooks Desktop company file. If the original QBW file is still available, you may not need to restore a backup.

Can I restore an old QuickBooks backup?

Yes. QuickBooks Desktop can restore a QBB backup and create a new company file from it.

Will restoring a backup delete my current QuickBooks data?

It can if you restore the backup over your existing company file. To reduce this risk, restore the backup to a separate location and use a different file name when possible.

Can QuickBooks Online restore a deleted transaction?

The supplied source indicates that a deleted QuickBooks Online transaction cannot simply be restored from the Audit Log. Instead, the Audit Log can provide details that you can use to recreate the transaction manually.

Can QuickBooks repair damaged company data?

QuickBooks Desktop includes the Rebuild Data tool, which can address some minor company-file data problems. Create a backup before using the repair process.

Conclusion

Recovering QuickBooks data depends on whether the information was deleted, the company file was moved, the file became damaged, or an earlier backup is available.

For QuickBooks Desktop, first search for the original QBW company file and available QBB backups. If you have a suitable backup, restore it to a separate location rather than immediately replacing your current company file.

If you use Intuit Data Protect, an earlier version of the company file may also be available. For QuickBooks Online, the Audit Log can help you find details about deleted transactions so they can be recreated manually.

If the company file is damaged rather than missing, QuickBooks Desktop's Rebuild Data tool may help with certain data problems. Most importantly, create backups regularly and keep copies in separate locations so that you have safer recovery options when unexpected data loss occurs.