Losing QuickBooks data can be stressful, especially when the missing information includes transactions, invoices, customer records, or other important accounting details. The way you recover the data depends on what happened and whether you have a backup.
QuickBooks Desktop users can restore a previous company file backup. QuickBooks Online users have different recovery options, such as using the Audit Log to find details of deleted transactions.
Before making major changes, avoid entering new information into a damaged or incorrect company file. This can make it harder to identify what was lost.
Sometimes your data has not been deleted. The company file may simply have been moved, renamed, or saved in another folder.
For QuickBooks Desktop, search your computer for files ending in .QBW and .QBB. A QBW file is the working company file, while a QBB file is a backup file. QuickBooks also provides a way to search for company files from the No Company Open window.
If you find your original QBW file, you may be able to open it without restoring a backup.
If your company data was deleted, damaged, or lost because of a computer problem, a backup can be the easiest way to recover it.
QuickBooks Desktop backup files normally use the .QBB extension. When you restore one, QuickBooks creates a new company file from that backup.
To restore a backup:
Open QuickBooks Desktop.
Go to File > Open or Restore Company.
Select Restore a backup copy.
Select Local Backup and choose Next.
Find your QBB backup file.
Choose where you want to save the restored company file.
Select Save.
It is safer to restore the backup to a different folder instead of overwriting your current company file. This allows you to compare the restored data with your current file.
If you are not sure where your backup is saved, search your computer for .QBB files.
You can also check external drives, USB devices, cloud storage, or other locations where you normally save QuickBooks backups.
Look at the file's date and time to identify the backup that is most likely to contain the missing information.
Remember that an older backup may not contain transactions entered after the backup was created.
If you use Intuit Data Protect for QuickBooks Desktop, you may be able to restore an older version of your company file.
Open Intuit Data Protect and select Restore from Backup. Choose the files or folders you want to restore and select the backup date you need. Intuit recommends restoring the files to a temporary location first and then moving them to their permanent location after checking them.
This can be useful if your current company file is damaged and you need an earlier version.
QuickBooks Online works differently from QuickBooks Desktop.
A deleted transaction cannot simply be restored from the Audit Log. However, you can use the Audit Log to find information about the deleted transaction and manually enter it again.
Go to Settings > Audit Log and use the available filters to find the deleted transaction.
Open its history and review details such as the transaction date, amount, customer, and other available information.
You can then recreate the transaction manually in QuickBooks Online.
If the data is not actually deleted but the company file has data damage, restoring an older backup may not be your only option.
QuickBooks Desktop includes the Rebuild Data tool, which can fix some minor company file data problems.
Go to File > Utilities > Rebuild Data and follow the instructions. QuickBooks asks you to create a backup before rebuilding the file. After the process finishes, use Verify Data to check the company file again.
Do not immediately overwrite your existing company file with an old backup.
An older backup may contain the information you lost, but it may also be missing newer transactions.
Keep a copy of your current file and restore the backup separately. This gives you a safer way to compare the files and decide which information needs to be recovered.
Regular backups can make data recovery much easier.
QuickBooks Desktop lets you create local backups and schedule automatic backups. Intuit recommends creating backups so you have a previous version of your company file if something goes wrong.
Keep backup copies in a different location or on another device. This can protect your accounting data if your computer fails.
Can I restore lost QuickBooks data without a backup?
It depends on the situation. If the company file is only missing, you may be able to locate it. For deleted QuickBooks Online transactions, the Audit Log can provide details that you can use to recreate them.
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 overwrite data if you restore it over your existing company file. To avoid this, save the restored backup in a separate folder with a different file name.
What if my QuickBooks company file is missing?
Search your computer for QBW and QBB files. If you find the correct file, you can open the company file or restore the backup through QuickBooks.
Can QuickBooks repair damaged data?
QuickBooks Desktop includes the Rebuild Data tool, which can fix some minor data problems. Always create a backup before running the repair process.
The best way to restore lost QuickBooks data depends on what happened. If your Desktop company file is missing, search for the original QBW file or a QBB backup. If you have a backup, restore it to a separate location before replacing your current file.
For QuickBooks Online, deleted transactions cannot be directly restored, but the Audit Log can provide information needed to recreate them.