QuickBooks Auto Data Recovery Tool: Get Your Lost Data 

We all know how crucial the company file data is, and having a backup copy or a plan to recover the data file is necessary. The company file data might get damaged or corrupted due to technical issues in the program, company file or your system. This is when such a backup plan comes into play, letting you get your data recovered fully. QuickBooks Desktop introduces you to one tool, QuickBooks Auto Data Recovery, which lets you recover your recent data. This guide covers how you can recover your data using the tool in different ways and the type of data you can recover. Let’s walk through this extensive guide thoroughly. 

Has your company file been lost, and you're wondering if you can recover it completely? Connect with our QuickBooks professional team at 1.833.460.8006 and let them recover the data for you without worrying about damage or corruption.

Use the Auto Data Recovery Tool to Regain Your Lost Data 

There are two methods to recover the lost company file data in QuickBooks Desktop, one of which is the QuickBooks Auto Data Recovery tool. To perform this, you will need the .adr copy of the company file and Transactions Log file and an original one for the Transactions Log file. 

Move to the section below to recover your data using the ADR tool, and ensure you follow the steps mentioned. 

Keep this in mind before proceeding: 

  • The Auto Data Recovery tool is only available for Windows on the QuickBooks Desktop version.

  • The ADR feature to recover your data is unavailable in Accountant Editions.

  • You can only recover 1.5 Gigabytes of file size using ADR. If the backup is bigger than 1.5 Gigabytes, QuickBooks will fail to generate an ADR file.

  • Make sure the QuickBooks Desktop version is up-to-date to maximize the data recovery. 

Recover recent transactions using the .QBW.adr and original .TLG files

Recover you all transactions using the original copy of Transaction Log file and ADR version of your company file:

  • Log in as an administrator to your system.

  • Make a brand-new folder and call it QBTest.

   Note: To check the company file location, press F2 or Ctrl+1 keys on the keyboard to launch the No Company Open Window.

  • In the company file folder, look for the .tlg file. The file will be the same as your company file but with the extension at the end.

   Check file extensions  

   If you cannot find the file, perform the below steps: 

     - Launch the Windows Explorer by pressing the Windows logo + E keys.

     - Click on Organize, then select Folder and search options.

     - Hit on Hide extensions for known file types.

     - Click Apply, then OK.

  • Locate the QuickBooksAutoDataRecovery folder and open it. You will find this in the same location as your company file. 

  • Copy the .QBW.adr file and paste it to the same folder. Your QBTest folder will contain a .QBW.adr and .tlg file.

  • In the QBTest folder, right-click the .QBW.adr file and choose Rename. 

  • Remove .adr extension from the end.

  • Launch QuickBooks Desktop.

  • Now, open the company file you saved in the QBTest folder. Confirm all transactions using your account register.

  • Navigate to File> Utilities, then Verify Data to verify the data integrity.

  • If this copy of the company file is good, you can move the damaged company file to another location and transfer the copy from QBTest to the original location.

Recommended to read : Fix QuickBooks Running Slow in Multi-User Mode

Recover the lost transactions using both .adr version .QBW and .TLG files

This method to recover your data requires the ADR version of both the .QBW and .TLG files. You can recover all but the last 12 hours of transactions.

  • Create a new file folder on your computer and name it as QBTest.

  • Open the folder where your company file is saved and look for the QuickBooksAutoDataRecovery folder.

   Tip: If you can’t find the file, press F2 or Ctrl+1 on your keyboard on Product Information to launch the No Open Company window.

  • Find the .TLG.adr and QBW.adr files are in the folder. These files have the same name as your company file but with the extension at the end of the company file name.

   Check file extensions

   If you cannot find the .TLG.adr and .QBW.adr files, perform these steps: 

     - Press the Windows+E keys together to launch File Explorer.

     -  Select Folder and Search options after selecting Organize.

     - Tap on Hide extensions for known file types.

     - Select Apply and click OK.

  • Select and right-click on the .TLG.adr and .QBW.adr files and select Copy.

  • Now, paste these files to the QBTest folder.

  • Delete the .adr file from the end of the file name from the folder. The folder has a .qbw and .tlg files in your QBTest folder.

  • Open the company file located in the QBTest folder after launching QuickBooks. Verify all the transactions using the account register

  • Verify the data integrity of the recovered file: Select File> Utilities, then Verify Data.

  • You can relocate the damaged company file to a different location and move the QBTest copy back to the original location if this copy of the company file is in good condition.

You may read also : QuickBooks Populates Form 941

Summary 

In this article, we have covered everything you need to learn to recover your lost data using the QuickBooks Auto Data Recovery tool. You can get your data back using the ADR copy of the QBW.adr and TLG file or with QBW.adr and TLG.adr. Hopefully, the above steps have helped you with the same. 

In case you fail to recover your data or face any challenges, connecting with QuickBooks professionals is recommended. Dial TFN and connect with a ProAdvisor now!

Read Also: How to improve QuickBooks Desktop Performance issues in multi-user mode