QuickBooks Auto Data Recovery- Recover Lost Data with Ease

No matter what accounting platform you use, data will always be your most valuable asset. Thus, it is essential that your accounting software, be it QuickBooks or any other program, safeguards the data it handles. When it comes to QuickBooks, you get QuickBooks Auto Data Recovery, which is an advanced feature that helps recover lost QuickBooks data in unforeseen situations like data theft, loss, or damage. This guide will help you understand the Auto Data Recovery Tool for QuickBooks and how to use it to recover your lost QuickBooks data.

As a QuickBooks user, data loss is one of the most distressful situations you can be in. If you don’t feel comfortable recovering the data using Auto Data Recovery on your own, reach out to the support team at 833-802-0002 and let the experts handle the situation for you

How to Run QuickBooks Auto Data Recovery

QuickBooks Auto Data Recovery helps you recover the following:

• Restore all the lost/missing/corrupted transactions using the QuickBooks Transaction Log file and a copy of the company data file.
• Restore all the missing/corrupted transactions except the last few hours using a copy of both the company data and the Transaction Log files.

Before using ADR, keep the following reminders in mind –

• Ensure you update QuickBooks Desktop to the latest version to get the best outcomes from ADR.
• Make sure the file size limitations are followed. QuickBooks won’t generate the ADR file if the backup is larger than 1.5 GB.
• The ADR feature is only available in QuickBooks Pro, Premier, and Enterprise and not in the Accountant Editions.

Once these points are considered, use the ADR and recover the lost/corrupted transactions by going through the following steps –

Restore All the Recent Lost/Corrupted Transactions

You can perform the steps given below to recover all the recent transactions by using the Transaction Log file and the ADR version of the company file –

1. Make a new QBTest folder on the PC, then open the company file folder and find the .TLG file, which has the same name as your company file.
   Note: If you can’t find the company file folder, locate it in the Product Information window (press F2 or Ctrl + 1) or go to the No Company Open window.
2. If you can’t locate the Transaction Log file, modify the Windows settings to display the file extensions in the following manner –
   • Press the Windows + E keys to open Windows File Explorer and go to the Organize tab.
   • Now, click Folder and search options, unmark Hide extensions for known file types, and click Apply & OK.
3. Further, copy the Transaction Log file corresponding to your company file and paste it into the QBTest folder.
4. Open the QuickBooksAutoDataRecovery folder from the same location as your company file and copy your company file’s ADR version (.QBW.adr).
5. Paste the .QBW.adr file into the QBTEST folder to have both the .QBW.adr and .TLG files in it.
6. Right-click the .QBW.adr file, choose Rename, then delete .adr from the end of the file name and hit Enter to save the changes.
7. Open QBDT, open the company file saved in the QBTest folder, and review the transactions.
8. Use the account register to ensure all transactions are present, then move to the File tab and select Utilities.
9. Next, click Verify Data to verify the data integrity of the recovered file and check if it is in good condition.
10. If the recovered copy of the company file confirms integrity, move the damaged company file to another folder/location and transfer the copy of the company file from QBTest to the original file location.

Once the process is complete, you will have restored all the recent missing/corrupted transactions in QuickBooks Desktop. If you want to recover all the transactions except the last 12 hours, follow the steps in the next section.

Restore All Except the Last 12 Hours of Lost/Corrupted Transactions

Follow the detailed steps below to restore all but the last 12 hours of transactions using the ADR versions of the Transaction Log and company file –

1. Create a QBTest folder on your desktop, then open the company file folder and find the QuickBooksAutoDataRecovery folder.
   Note: If you can’t find the company file location, go to the Product Information screen (press F2 or Ctrl + 1) or the No Company Open window to locate the company file folder.
2. In the QuickBooksAutoDataRecovery folder, locate the .TLG.adr and .QBW.adr files having the same name as your company file.
3. If you can’t locate the ADR versions of the Transaction Log and company files, change the Windows settings to display file extensions (see point 2 in the ‘Restore All Recent Lost/Corrupted Transactions’ section above).
4. Now, copy the .TLG.adr and .QBW.adr files and paste them into the QBTest folder, then proceed to rename them.
5. Right-click the files, select Rename, and remove .adr from the end of the file names (you will now have the .QBW and .TLG files in the folder).
6. Next, run QuickBooks and open the company file saved in the QBTest folder, then use the account register to verify the transactions.
7. Verify that all transactions are present, then navigate to the File menu and select the Utilities tab.
8. Further, click Verify Data to run the QuickBooks Verify Data Tool to confirm the recovered file’s integrity and ensure it is in good condition.
9. If the recovered copy of the company file is in good shape, transfer the damaged company file to another folder/location and move the copy from QBTest to the original file location.

Conclusion

This guide was about recovering the lost QuickBooks data using QuickBooks AutoData Recovery. Although the instructions to recover the data are straightforward, if you get stuck in the process or do not get the desired results, another way to rescue the lost data is to get in touch with the experts. Dial 833-802-0002 and let the support team run advanced data recovery to get you back on track.

FAQs