QuickBooks has really helped businesses across the globe with its highly effective accounting solutions. To avail of its features, organizations need to store their crucial business data in the company file. But have you ever thought about what would happen, if your crucial business data gets corrupt or goes missing for some reason or other?
Don’t bother! Here is a piece of good news if you are a QuickBooks user. You have at your disposal, one of the many amazing tools QuickBooks can offer the Auto Data Recovery(ADR) Tool. In case of an unfortunate data corruption/loss, this tool can recover nearly all your data.
If you are struggling to recover your lost data, you just can’t afford to skip this blog! Go through it till the end. We will look at how you can recover missing data with this important tool from QuickBooks.
Here we go!
What are Causes of Missing Data in QuickBooks?
Some of the primary reasons are listed below-
- QuickBooks database files may have become corrupt/damaged
- Virus/malware affecting QuickBooks files
- Issues with QuickBooks updates
- Multiple company files present on a drive
- Issues while upgrading company files to .QBW
Procedure to Recover Recent Transactions using the Original .TLG File with .QBW .adr File?
Here, the QuickBooks ADR tool uses the ADR version of the company file and the original Transaction Log file to recover your recent transactions
- On your Desktop, create a new folder
- Name it QB Test
- Open the folder where your company file has been saved.
- Search for the .tlg file in this folder. It will have the same name as that of your company file.
Please note-If you are not able to locate the .tlg file, perform the steps below to view file extensions.
- Press Windows+E to open the File Explorer
- Select Organize
- Click on Folder and search options.
- (For Windows 8, 8.1 and 10:click on View, and then choose Filename extension)
- Now click the tab named Hide extensions for known file types.
- Click Apply
- Click OK.
Copy the .tlg file and paste it to the QBTest folder you have created on your desktop
- Now go to the location where your company is stored
- Open the QuickBooks Auto Data Recovery folder.
- Copy the .QBW.adr file
- Paste it to the QBTest folder on your desktop.
- Your QBTest folder should look like as shown below-
- In this folder, right-click on the .QBW.adr file
- Select Rename.
- Delete the. adr extension at the end
- Now open QuickBooks.
- Open the company file saved on your QBTest folder.
- With the account register, verify if all the transactions are there.
- Select File
- Go to Utilities
- Click on Verify Data.
If you are satisfied with the integrity of this copy of your company file, move the damaged file to another location and bring the copy from the QBTest folder to the original location.
What is the Procedure to Recover Recent Transactions using the .TLG.adr file and .QBW.adr file?
With this method, you can recover the transaction within the last 12 hours.
- On your Desktop, create a new folder
- Name it QBTest
- Open the folder where your company file has been saved.
- Open the QuickBooks Auto Data Recovery folder
- Search for the .QBW.adr and .tlg.adr files. They will have the same name as that of your company file.
- Copy the .QBW.adr and .tlg.adr
- Paste them to the QBTest folder.
- On this folder, remove the .adr extension from the file names. This should give you files with .qbw and .tlg extensions on this folder.
- Now open QuickBooks.
- Open the company file saved on your QBTest folder.
- With the account register, verify if all the transactions are there.
- Select File
- Go to Utilities
- Click on Verify Data.
- If you are satisfied with the integrity of this copy of your company file, move the damaged file to another location and bring the copy from the QBTest folder to the original location
Missing data or loss of data is so common these days, right? With this Auto Data Recovery Tool, QuickBooks has tried to address the concerns of its users. Intuit Data Services can also help you recover data. However, it takes some more time as compared to ADR and you cannot use QuickBooks for a number of days. Using the ADR tool can be a faster method of recovering missing/corrupted data in QuickBooks. But remember that you should use this tool only after you have tried all the other troubleshooting methods.
FAQs
How can the QuickBooks ADR Tool Recover Missing or Lost Data?
ADR can help recover lost data by:
· Restoring the transactions of the last few hours with a copy of your Transaction Log file and Company file
· Restoring lost data/transactions with the help of a copy of your Company file and the current Transaction Log file
Are there any Pre-requisites before the QuickBooks Auto Data Recovery Tool can be used?
You should keep the following points in mind before using the QuickBooks Auto Data Recovery Tool –
· An ADR file size cannot be more than 1.5 Gigabytes. If your data backup is of size over 1.5 Gigabytes, QuickBooks will not be able to generate an ADR file
· To get the maximum benefits, please make sure your QuickBooks Desktop includes the latest updates
· The ADR tool is available only in QuickBooks Premier, Enterprise and Pro versions for Windows. ADR is not available in QuickBooks Accountant Editions.
How to Locate the Folder Where my Company File has been Saved?
You can find out the location of the company file as given below –
· Open QuickBooks
· Press Ctrl+1 or F2 on your keyboard
· The Product Information screen will open up on your screen
· Go to the No Company Open Window
· You can view the location of the company file
