How To Recover Lost Data In the QuickBooks Program?

There could be times when you might lose your financial data due to unintended deletion, corruption, or any glitch in the software itself. If you are experiencing this trouble right now, then don’t worry. QuickBooks provides an auto data recovery feature that you can utilize to recover your data. But keep one thing in mind: using this tool should be your last option. In this blog, we will discuss how to recover lost data in the QuickBooks program using the auto data recovery feature.

Before you proceed, take care of these points

• You can use ADR only in QuickBooks Pro, Premier, and Enterprise Solutions, which are designed for Windows. 
• ADR is unsupported in Accountant Editions. 
• ADR file size limit is 1.5 Gigabytes only. If you have bigger file than the allowed limit, then QB will not create an ADR file.
• Make sure you have updated your QuickBooks so that the ADR feature can work properly.

Recovering Lost Data Using ADR Feature

Is your QuickBooks Data Is Missing After Update? Don’t worry, below steps will help you recover them.

Restore recent transactions with the help of the original .TLG file with .QBW.adr file

• Create a new folder.
• Name it QBTest.
• Save it on the Desktop.
• Open the company file folder.
• Search for the .tlg file. 
• It should have the exact name as the company file.

Show file extensions

If you cannot identify the .tlg file, then these steps should help you.

• Press Windows+E. 
• Open File Explorer.
• Select Organize.
• Choose Folder and search options.
• Select Hide extensions for known file types.
• Select Apply.
• Click OK.

1. Copy a similar .tlg file to the company file.
2. Paste it to the QBTest folder.
3. Open the QuickBooksAutoDataRecovery folder.
4. Copy the .QBW.adr file.
5. Paste it to the QBTest folder. 
6. Now, you will have both .QBW.adr and .tlg files in the QBTest.
7. Access the QBTest folder.
8. Right-click the .QBW.adr file.
9. Select Rename.
10. Delete .adr extension. 
11. Open QuickBooks.
12. Open the company file present in the QBTest folder. 
13. Verify all transactions. Take help from the account register.
14. Select File. 
15. Click Utilities.
16. Select Verify Data.
17. Check its integrity.
18. If your company file data is good and accurate, then transfer it from QBTest to the original location.
19. Lastly, move the damaged file somewhere else.

Recommended to read : How to fix QuickBooks Migrator tool not working issue

Retrieve recent transactions (With .QBW.adr and .TLG.adr files)

• Make a new folder.
• Name it QBTest.
• Open the company file folder.
• Search for this folder: QuickBooksAutoDataRecovery.
• Search the .TLG.adr &.QBW.adr files.

They will have the same name as the company file.

Show file extensions

If you are unable to locate the .TLG.adr and .QBW.adr files, then do this  

• Press Windows+E.
• Open File Explorer.
• Select Organize.
• Choose Folder and search options.
• Select Hide extensions for known file types.
• Select Apply. 
• Select OK.

1. Copy the .TLG.adr and .QBW.adr files.
2. Paste them to the QBTest.
3. Access your QBTest folder.
4. Remove the .adr extension.
5. Open QuickBooks.
6. Access the QBTest folder.
7. Then, open the company file.
8. Verify all transactions. Use the account register. 
9. Select File.
10. Click Utilities.
11. Select Verify Data.
12. If your data is accurate, then transfer the file to the original location.

Conclusion 

We hope you now understand how to recover lost data in the QuickBooks program using the ADR feature.

You may read also :  How to fix QuickBooks Update Errors: step-by-step guide