In this Post we will understand how you can use the QuickBooks Auto Data Recovery tool in order to recover the damaged or lost QuickBooks company files.
Recover recent transactions using the original.TLG file with .QBW.adr file
Utilize the original Transaction Log file and ADR version of the company file to recover all recent transactions.
Create a new folder on your Desktop named QBTest.
Open the folder where the company file is saved.
Tip: You can check the location of the company file on the Product Information screen (press F2 or Ctrl+1 on your keyboard) and No Company Open Window.
Look for the .tlg file in your company file's folder. It has the same name as your company file.
Show file extensions
If you cannot identify the .tlg file, perform these to show file extensions.
To open File Explorer press Windows+E on your keyboard.
Select Organize, then choose Folder and search options.
For Windows 10, 8.1 & 8: Choose View, then select Filename extension.
Select Hide extensions for known file types.
Select Apply, then OK.
Copy the corresponding .tlg file of your company file, and paste it to the QBTest folder on your Desktop.
Open the QuickBooksAutoDataRecovery folder. It is in the same location as your company file.
Copy the .QBW.adr file and paste it into the QBTest folder. You should now have a .QBW.adr and .tlg file on your QBTest folder.
In your QBTest folder, right-click the .QBW.adr file and select Rename.
Delete .adr at the end of the file.
Open QuickBooks.
Open the company file that is saved in your QBTest folder. Use your account register to verify all transactions are there.
Select File then Utilities and then Verify Data to check the data integrity of the recovered file.
If this copy of the company file is good, you can move the damaged company file to a different location and transfer the copy from QBTest to the original location.
Recover recent transactions using .QBW.adr and .TLG.adr files
This solution will utilize the ADR version of both the . QBW and.TLG files. This should recover all but the last 12 hours of transactions.
Create a new folder on your Desktop named QBTest.
Open the folder where the company file is saved look for the QuickBooksAutoDataRecovery folder.
Tip: You can check the location of the company file on the Product Information screen (press F2 or Ctrl+1 on your keyboard) and No Company Open Window.
Look for the.TLG.adr and .QBW.adr files. These files have the same name as your company file.
Show file extensions
If you cannot identify the.TLG.adr and .QBW.adr files, perform these to show file extensions.
To open File Explorer press Windows+E on your keyboard.
Select Organize, then choose Folder and search options.
For Windows 10, 8.1 & 8: Choose View, then select Filename extension.
Select Hide extensions for known file types.
Select Apply, then OK.
Copy the .TLG.adr and .QBW.adr files and paste them to the QBTest folder.
On your QBTest folder, remove the .adr from the end of the file name. That should give you a .qbw and .tlg files on your QBTest folder.
Open QuickBooks.
Open the company file that is saved in your QBTest folder. Use your account register to verify all transactions are there.
To check the data integrity of the recovered file: in the top left, select File then Utilities, and then Verify Data.
If this copy of the company file is good, you can move the damaged company file to a different location and transfer the copy from QBTest to the original location.
Recover recent transactions using the original.TLG file with .QBW.adr file
Utilize the original Transaction Log file and ADR version of the company file to recover all recent transactions.
Create a new folder on your Desktop named QBTest.
Open the folder where the company file is saved.
Tip: You can check the location of the company file on the Product Information screen (press F2 or Ctrl+1 on your keyboard) and No Company Open Window.
Look for the .tlg file in your company file's folder. It has the same name as your company file.
Show file extensions
If you cannot identify the .tlg file, perform these to show file extensions.
To open File Explorer press Windows+E on your keyboard.
Select Organize, then choose Folder and search options.
For Windows 10, 8.1 & 8: Choose View, then select Filename extension.
Select Hide extensions for known file types.
Select Apply, then OK.
Copy the corresponding .tlg file of your company file, and paste it to the QBTest folder on your Desktop.
Open the QuickBooksAutoDataRecovery folder. It is in the same location as your company file.
Copy the .QBW.adr file and paste it into the QBTest folder. You should now have a .QBW.adr and .tlg file on your QBTest folder.
In your QBTest folder, right-click the .QBW.adr file and select Rename.
Delete .adr at the end of the file.
Open QuickBooks.
Open the company file that is saved in your QBTest folder. Use your account register to verify all transactions are there.
Select File then Utilities and then Verify Data to check the data integrity of the recovered file.
If this copy of the company file is good, you can move the damaged company file to a different location and transfer the copy from QBTest to the original location.
Recover recent transactions using .QBW.adr and .TLG.adr files
This solution will utilize the ADR version of both the . QBW and.TLG files. This should recover all but the last 12 hours of transactions.
Create a new folder on your Desktop named QBTest.
Open the folder where the company file is saved look for the QuickBooksAutoDataRecovery folder.
Tip: You can check the location of the company file on the Product Information screen (press F2 or Ctrl+1 on your keyboard) and No Company Open Window.
Look for the.TLG.adr and .QBW.adr files. These files have the same name as your company file.
Show file extensions
If you cannot identify the.TLG.adr and .QBW.adr files, perform these to show file extensions.
To open File Explorer press Windows+E on your keyboard.
Select Organize, then choose Folder and search options.
For Windows 10, 8.1 & 8: Choose View, then select Filename extension.
Select Hide extensions for known file types.
Select Apply, then OK.
Copy the .TLG.adr and .QBW.adr files and paste them to the QBTest folder.
On your QBTest folder, remove the .adr from the end of the file name. That should give you a .qbw and .tlg files on your QBTest folder.
Open QuickBooks.
Open the company file that is saved in your QBTest folder. Use your account register to verify all transactions are there.
To check the data integrity of the recovered file: in the top left, select File then Utilities, and then Verify Data.
If this copy of the company file is good, you can move the damaged company file to a different location and transfer the copy from QBTest to the original location.
Learn more about: Cloud based QuickBooks | QuickBooks Pro vs Premier | QuickBooks for Nonprofits