All that you need to know about QuickBooks auto data recovery tool

QuickBooks is an accounting program from Intuit that has been gaining immense popularity in the last few years. Since it comes with powerful tools for managing the finances of a business, raising invoices and managing payments, storage of crucial accounting data, and many more small and medium companies have begun to heavily rely on QuickBooks. As a software program, this application isn’t invulnerable to errors or technical issues. Many times, users encounter problems that slow down their operations.

One of the most frequent issues that users encounter is losing their data. If you are using this software, you may discover an extra folder that has new folders. The folder is called QuickBooks Auto Data Recovery folder which basically creates an back-up of your company’s files. If you lose all your data, this tool can assist you to retrieve all of your crucial data. Thus, In this article, we will discuss in details how QuickBooks Auto Data Recovery works.

What is Auto Data Recovery Function in QuickBooks and How It Works?

ADR is a very important tool that helps in taking backup of your data. The loss of your data can severely affect your business operations and that’s when this tool comes to your rescue. The Auto Data Recovery feature uses your current Transaction Log file and a copy of your company file to restore back all the lost transaction except the ones done in the last few hours.

This recovery tool can offer a couple of benefits to QuickBooks users, which are listed below:

  1. Restoring the lost transactions using the current Transaction log file and a copy of the company file.
  2. Also, restoring all but the last few hours of transactions with a copy of both the company file and the transaction log file.

There are many other details related to QuickBooks Auto data recovery tool. If you are eager to unleash those facts, be sure to go through this post to the end. You can easily connect via the QuickBooks support team by calling 800-761-1787. Our representatives will connect you to our experts in the shortest possible time, and your queries will be addressed within a few seconds.

Points to remember before using QuickBooks Auto Data Recovery Tool

  • If you have QuickBooks Pro, Premier, or Enterprise Solutions for Windows, then only you can use Auto Data Recovery tool.
  • The QuickBooks Auto Data Recovery Tool (ADR) is not available in Accountants Edition.
  • You can take backup of maximum file size of 1.5 Gigabytes. In case, the file size is more that 1.5 Gigabytes, then QuickBooks will not be able to create the Auto Data Recovery file.
  • To get the maximum efficiency from the tool try using the latest updated version of QuickBooks.

You may also like: What are the steps to resolve QuickBooks error h505?

How to Use the QuickBooks Auto Data Recovery Tool to Restore the Data?

The below mentioned steps will help you in recovering your lost data by using the QuickBooks Auto Recovery Tool:

Step 1: Recover lost data using the original .TLG file with .QBW.adr.file

The original Transaction Log file and the current version of ADR can be used to recover the recent transactions that you have lost. Follow the below steps for the same:

  1. Create a new folder on your desktop and name it QBTest.
  2. Open the folder where you have saved the company file. You will find the company file location on Product Information screen and No Company Open Window. (Note: To open the Product information Press F2 or Ctrl+1 keys on your keyboard).
no company open-screenshot
  1. Search for the .tlg file on your company file’s folder. The company file that you are looking for will have the same name as your company file.
  2. Just in case, you aren’t able to identify the .tlf file then you have the follow the below mentioned steps to Show File Extension:
    • At first hit a click on Windows +E keys to open File Explorer.
    • Select Organize option and then choose Folder to search for options (Windows 10,8.1 and 8) to move further.
    • Choose View option to choose the File Name Extension.
    • Next, select the Hide Extensions for Known file types option.
    • Once you have selected the promoted option, click on Apply and then on OK button.
  3. Once you have found the .tlg file, copy and paste it in the QBTest folder that you had created earlier on your desktop.
Auto data recovery - Screenshot
  1. Open QuickBooksAutoRecovery folder. You will find it in the same location where your company file is stored.
Auto data recovery 2- Screenshot
  1. Now open the QBTest folder and right click on .QBW.adr file and the select on Rename option.
  2. Choose the .adr option which is located at the end of the file name and delete it.
Auto data recovery 3- Screenshot
  1. In QuickBooks, open the company file that you have stored in the QBTest folder.
  2. Check and confirm of All transactions are there in the file by using the account register.
  3. Follow the given series of action to make sure the data integrity: File >> Utilities >> Verify Data.
Verify hosting data - Screenshot
  1. You can now move the damaged file to some other location and replace it with the copied file that you saved in QBTest folder to the original location.

Read Also: What is QuickBooks abort error?

Step 2: Recover recent transactions using the .QBW. adr and .TLG.adr files

The .QBW and .TLG files for this solution will both be present in the ADR format. All transactions prior to the last 12 hours should be recovered with this procedure.

  1. Firstly create a new folder on your Desktop and name it QBTest.
  2. Now by using the QuickBooks company file feature, open the QuickBooksAutoDataRecovery.

It is recommended to check the location of the company file on the product information screen, by pressing F2 keys or Ctrl + 1 keys and No company open window.

  1. Access the .TLG.adr and .adr files. These files have the same name as your company file. Show file extensions. In case, you are unable to identify the .TLG.adr and .QBW.adr files, then these steps should be performed to show the file extensions.
    • Initially open File Explorer by pressing Windows + E keys on your keyboard.
    • Choose Organize and then then choose the Folder and search options.
    • Now select View option and then choose File name extension.
    • Choose Hide extensions for known file types and finally choose Apply, then OK button.
  2. Copy the .TLG.adr and .QBW.adr files and also paste them to the QBTest folder.
  3. Opt for the two files and paste them in the QBTest folder and then delete .adr
  4. You will have then have to open QuickBooks.
  5. Open the company file saved on the QBTest folder. It is recommended to use the account register to verify the transactions.
  6. Follow the listed series of actions to verify if the integrity of data is intact- File >> Utilities >> Verify Data.
Verify hosting data - Screenshot
  1. If the recovered data is not damaged in any way then you can copy it from the QBTest folder and paste it in the original QuickBooks company file folder.

See Also: Fix Loan Manager or Cash Flow Projector is missing after upgrading QuickBooks Desktop problem

To Wrap it Up!

With the help of QuickBooks auto data recovery tool you can easily get back your lost data. In case, you aren’t able to restore them or have any queries regarding this tool then you can always take help from QuickBooks enterprise support team who are available all through the day to help you out. So dial hassle free on our helpline i.e. 1-800-761-1787 and get in touch with our experts today!


Other helpful articles to read:

How to Fix QuickBooks Error 502?

Features discontinued in QuickBooks Desktop 2022 and Enterprise 22

How to resolve QuickBooks error code 15215?

Voiced by Amazon Polly
Call Now +1-800-761-1787