QuickBooks Data Is Missing After Update? Fix it Now!

Are you facing an issue where QuickBooks data is missing after update? This common issue can occur due to a corrupted company file or connectivity issues, among other reasons. It can lead to the risk of losing essential data, so it needs to be fixed on time. Follow this article till the end to learn how to find and recover your missing QB data.

Missing crucial QuickBooks data after an update is a critical issue that must be addressed on time, as it can lead to permanent data loss. If you require immediate assistance fixing the issue, contact our team of professionals at 1-855-856-0042.

Reasons Why All QuickBooks Data is Gone After Update

There can be several reasons why QB data is missing after the update. Before troubleshooting this issue, you must learn about these reasons for better clarity. The following list of reasons is responsible for the missing data issue in QB –

• Damage to the company file and data integrity issues can lead to missing data.
• You have condensed the QB data recently, which can delete info before a particular date.
• If someone else on the network works on a different file, the missing data might sometimes be stored in another company file.
• The backup file in QB is frequently moved from one location to another.
• There are internet connection issues, or the connection was disrupted while backing up QB data.
• You have recently upgraded QuickBooks or moved to a new device, and some data has not been restored.
• Your recent QuickBooks data backup was unsuccessful, or it was accidentally deleted.
• QuickBooks is incompatible with the new system, leading to missing records in the data backup.
• You have moved the company file to another location, and QuickBooks is still searching for the file in its default location. 
• The file access permissions might be incorrect during or after updating QuickBooks.
• Software glitches and malware infections in the PC can be other reasons your QB data is missing.
• If QuickBooks is damaged or incorrectly installed on the new PC, it can lead to missing data or invoices.

These are some of the leading causes behind the missing data issue in QuickBooks. Now, in the next section, let’s learn how to fix this issue with practical solutions.

Practical Solutions to Perform When QuickBooks Data Disappeared After Update

Until this issue is resolved, you risk permanently losing your QB data. Thus, after understanding the reasons behind this issue, troubleshoot it by performing the solutions given below –

Solution 1 – Review the Audit Trail Report

You need to check the Audit Trail Report, which contains all the transactions recorded in the company file. These transactions include the deleted ones; thus, the report can help find all past transactions and their changes. Follow the steps given below to review the Audit Trail Report and find the QuickBooks data lost after the update –

1. Open the Reports menu in QBDT, select Accountant & Taxes, and choose the Audit Trail at the end.
2. Customize the report to suit your needs in the audit trail location, then click Customized Report at the top of the report.
3. Further, move to the Filters tab and add filters, like the Transaction Type, Name, and Date, to find your transaction.
4. Next, locate the person linked to the transaction on a specific date and hit OK to view the report.
5. Now, you will see various items and some lines with slight changes to the same transactions.
6. Look for a bold section highlighting the parts of transactions that were changed and saved from their previous amount, then select the Last Modified By column.
7. Lastly, find which users were logged into QuickBooks when the modifications were made and look for missing transactions after the QB update.

If you cannot find the missing transactions by reviewing the Audit Trail Report, proceed to the next troubleshooting solution.

Solution 2 – Check for Data Condensation

When you condense your data, it can remove info before a specific date to reduce the file size. This can sometimes lead to missing data; thus, you need to inspect for data condensation as follows –

1. Firstly, open QuickBooks Desktop and press the F2 key to access the Product Information window.
2. Wait for the Condense Information section to appear on the right, then check this section to determine if the data has been condensed. Also, check the last run and last payroll deleted date.

Once the data is inspected for condensation, check if the missing data is found. Move to the next solution if you still can’t find the missing data.

Solution 3 – Locate the Company File and Move it to its Default Location

You might find QuickBooks data has disappeared after the update if QuickBooks cannot find the company file at its default location. This can happen if the file is moved to another location and the new location is not updated in QB. To fix this issue and find the missing data, move the company file to its default location using the instructions below –

1. Open the search panel, type your company file extension (.qbw) with an asterisk (*) mark at the start to narrow down the search, and go to the company file location.
2. Right-click on the data file, select Copy, and follow this path – C: Users\Public\PublicDocuments\Intuit\QuickBooks20XX\CompanyFiles.
3. Lastly, paste the company file in this location and try opening it in QB Desktop in the following manner –
   • Move to the File menu in QuickBooks and click Open or Restore company.
   • Select Open a company file, hit Next, then choose your data file and click Open.

Now check if all the missing data is found after moving the file to its original location. However, if you are still missing QuickBooks data after the update, move to the next troubleshooting solution.

Solution 4 – Configure the Windows File & Folder Permissions

You might find missing data if QuickBooks is unable to connect with the company file after the update. This can happen if the Windows file permissions are incorrect or reset after the update. To fix the missing data issue, configure the permissions in the following manner –

1. Close QuickBooks, follow this path – C:\ProgramFiles\Intuit, and right-click the Intuit folder.
2. Click Properties, move to the Security tab, then select Advanced.
3. If the ownership of the Intuit folder is mentioned as SYSTEM or anything else, change it to USERS in the following manner –
   • Select Advanced Security Settings in the Intuit Permissions window, and click Change.
   • Type Users in the text field, hit Enter, then mark the Replace owner on the sub-containers and objects checkbox.
   • Select Users (PC Name\Users), click Full Control, and select OK to proceed.
4. Further, go to the Security tab on the Intuit Properties window and click Edit.
5. Mark the Full Control checkbox for your User Account, click OK, and exit the Intuit Properties window.

Now, try opening the company file in QuickBooks Desktop again and check if you can find the data. However, if QuickBooks data is still missing, move to the next solution.

Solution 5 – Look for Missing Transactions in Another Company File

Sometimes, another company file might contain the missing transactions. This can happen if someone on the network works on a different file. In such a case, you can look for the missing data by checking another company file as follows –

1. Launch QuickBooks Desktop, press the F2 key to open the Product Information window and check the information about the current company file.
2. Scroll down the window to view the File Information section, then note down the File Path of the file you’re currently using.
3. Ensure the path is the same as your regular company file where everyone is working, then perform these steps on all the network computers.

If you find a different file path on any of the PCs on the network, look for missing transactions in the company file saved in that other location. However, if QuickBooks data is still missing after the update, move to the next solution and check the network connectivity.

Solution 6 – Ping the Server to Check the Network Connectivity

Network connectivity issues can be another reason why your QuickBooks data is lost after an update. This happens if you try to access the company file from the network, but the workstation isn’t connected to the server. To fix the connection issue, first ping the server in the following manner –

1. Press the Windows + R keys to open the Run window, then type the CMD command and hit OK.
2. Next, enter ‘ipconfig/all,’ press Enter, and note down the host/server name.
3. Type ping [name of your server], then hit Enter, and check the reply for the data packets.

If you receive replies for each packet in a timely manner, the connection between the server and workstation is reliable. However, you must fix the Database Server Manager issues in the next section if there are slow replies or packet loss.

Resolve Database Server Manager Issues

To fix the connection problems while locating your company files, rectify the multi-user network issues that arise when the QuickBooks Database Server Manager is not running correctly. Follow the steps below to ensure that the DBSM isn’t restricted by antivirus and repair the .ND (Network Data) file –

1. Press the Windows + E keys to open Windows File Explorer and follow the path – C: Users\Public\PublicDocuments\Intuit\QuickBooks20XX.
2. Next, right-click the damaged .ND file inside the folder, select Rename and add ‘.old’ after the extension in the file name.
3. Press Enter to save the modified file name, then run QuickBooks DBSM and go to the Scan Folders menu.
4. Further, select Browse and specify the folder location where you renamed the Network Descriptor (.nd) file.
5. Click Start Scan, and once the folder contents are scanned, try accessing the company file on your workstation.

Once the network issues are resolved, check if you have the lost data back in QuickBooks. However, if the missing QB data issue persists, try to restore the data backup using the next solution.

Solution 7 – Restore the Company File Backup

If your company data is lost after the update, you can restore the backup to fix the issue. Before restoring the company file backup, make sure the backup file is stored on the local hard drive, then go through the following steps –

1. Launch QuickBooks Desktop, go to the File menu, and select the Open or Restore Company option.
2. Select Restore a backup copy, click Next, select Local Backup, and click Next again.
3. Browse the PC to find the backup company file, which should look like [company name].qbb, then select a folder to save the restored version.
4. After finding a suitable folder, click Open, and hit Save when ready.

Note: If you open the backup file in the same folder as your existing company file, you might risk overwriting the data. To avoid this, rename your existing company file or the backup file to ensure the names are unique. Another option is to save the backup in a separate folder to avoid the risk of overwriting.

5. If you see any messages about overwriting the data, select the option that suits your needs, and do not overwrite anything unless you are sure.

After restoring the backup file, rerun QuickBooks and access your data file. If the company data is still lost after the update, run the Verify/Rebuild Data tool in the next solution.

Solution 8 – Use QuickBooks Verify/Rebuild Data Utility

Damaged or corrupted company files can be a reason why your QuickBooks data is lost after the update. To address the data integrity issues, run the QB Verify/Rebuild Data tool by implementing the following steps –

Step 1 – Verify the Company Data

You can use the Verify Data tool to verify the company file and identify data integrity issues by following the steps given below –

1. Firstly, open the Window, select Close All, then move to the File section.
2. Next, click Utilities and select the Verify Data tool, then take the following actions as per the results after verifying the data –

• If no issues are detected in your company data, it confirms integrity, and you don’t need to proceed with the following steps.
• If you receive an error message after verifying the data, search it on our website and find effective solutions to fix it.
• If you get the “company data has lost integrity” message, the data file is damaged or corrupted, and you need to rebuild it to resolve the issue.

Once the data is verified, run the Rebuild Data tool in step 2 below.

Step 2 – Rebuild the Company Data

You can use the Rebuild Data tool to rebuild the company data and fix the integrity problems in the following manner –

1. Launch QuickBooks Desktop, navigate to the File menu, and select the Utilities tab.
2. Now, select Rebuild Data, and when QB asks to create a backup, click OK to create the company file backup.
3. Save the backup file to an easily accessible location, hit OK, and do not replace another one. Then, enter a new name in the File Name field and hit Save to confirm the name.
4. Next, click OK when you get the “Rebuild has completed” message, and go to the File tab in QuickBooks.
5. Click Utilities and select the Verify Data tool to check for additional data damage, then take the following actions –
   • If the Verify Data tool finds more data damage, troubleshoot the issues manually. You can search for the issue/error in the qbwin.log file and find practical solutions on our website. 
   • However, if no data issues are found, restore the file backup by clicking Open or Restore Company from the File menu.

Note: Do not replace your QB company file while creating the backup version. You must re-enter the information after the backup file is created.

After running the tool, rerun QuickBooks and open the company file. If the data is still missing, follow the next solution to recover the missing QuickBooks data after the update.

Solution 9 – Recover Missing QB Data with Auto Data Recovery

If none of the above solutions help, you can recover the missing data using Auto Data Recovery. The ADR utility helps recover all or almost all of your corrupted or missing data in the following two ways –

1. Restoring the lost/missing transactions using the Transaction Log file and a copy of your company data file.
2. Recovering all the missing transactions except the last few hours using a copy of the company file and the Transaction Log file.

Before running the ADR tool, ensure QuickBooks is updated and the file size limitations are followed. If the file size exceeds 1.5 GB, QB will not generate the ADR file. Moreover, you can use the ADR tool in QuickBooks Pro, Premier, and Enterprise and not in the Accountant Editions.

Now, let’s run the ADR tool and recover missing QuickBooks data after the update in the following manner –

Use the Transaction Log File & the ADR Version of the Company File to Recover Recent Transactions

You can use the QuickBooks Transaction Log file and the ADR version of the company file to recover all recent transactions by implementing the following steps –

1. Firstly, create a new QBTest folder on the computer and open the company file folder. If you don’t know the company file location, find the location in the Product Information window (press F2 or Ctrl+1) or go to the No Company Open window.
2. Locate the .TLG file with the same name as your company file, but if you can’t find it, modify Windows settings to display the extensions of the file using the instructions below –
   • Open Windows File Explorer by pressing the Windows + E keys and click Organize.
   • Next, click Folder and search options, select Hide extensions for known file types, and hit Apply & OK to confirm the action.
3. Further, copy the corresponding .TLG file of your company file and paste it to the QBTest folder created in step 1.
4. Open the QuickBooksAutoDataRecovery folder, which has the same location as your company file and copy the .QBW.adr file.
5. Paste the .QBW.adr file into the QBTEST folder, and you will now have both the .QBW.adr and .TLG files in this folder.
6. Next, right-click the .QBW.adr file, click Rename, remove .adr from the end of the file name, and hit Enter.
7. Open QBDT, open the company file saved in your QBTest folder and review the transactions.
8. Use the account register to ensure all transactions are present, then go to the File tab.
9. Now, select the Utilities option and click Verify Data to verify the data integrity of the recovered file.
10. If the recovered copy of the company file is in good condition, move the damaged company file to another folder/location and transfer the copy from QBTest to the original file location.

You have now successfully restored all the recent missing transactions in QuickBooks. However, if you wish to recover all transactions except the last 12 hours, follow the steps in the next section.

Use the ADR versions of the Transaction Log and Company Files to Recover All transactions except the Last 12 Hours

You can use the ADR versions of the Transaction Log and company data files to recover all except the last 12 hours of transactions in the following manner –

1. Create a new folder named QBTest on your desktop, then open the folder with your company file. If you don’t know the company file location, find it in the Product Information screen (press F2 or Ctrl+1) or in the No Company Open Window.
2. Next, find the QuickBooksAutoDataRecovery folder and locate the .TLG.adr and .QBW.adr files with the same name as your company file. If you can’t locate the files, modify Windows settings to display the extensions of the files (see point 2 in the ‘Use the Transaction Log File & the ADR Version of the Company File to Recover Recent Transactions’ section of this solution).
3. Copy the .TLG.adr and .QBW.adr files, paste them into the QBTest folder and then proceed to rename them.
4. Right-click both files, click Rename, and remove .adr from the end of the file names, which will give you .QBW and .TLG files in the folder.
5. Next, launch QuickBooks, open the company file saved in the QBTest folder, and use the account register to verify the transactions.
6. Verify that all transactions are there, then go to the File menu and select Utilities.
7. Further, click the Verify Data tool to confirm the data integrity of the recovered file.
8. If the recovered file is free from issues, move the damaged company file to another location and transfer the copy from QBTest to the original file location.

Once you have successfully used ADR to recover the files, reopen QuickBooks to ensure that the missing data is restored.

Solution 10 – Repair QuickBooks Desktop

If your data or invoices are lost after moving to a new computer, it is likely that QuickBooks is not correctly installed or damaged. This issue can be fixed using QuickBooks Tool Hub in the following manner –

Step 1 – Download & Install QB Tool Hub

The first step is downloading the QuickBooks Tool Hub to access the troubleshooting tools. You can download and install this program by implementing the following steps –

1. Close QuickBooks, download the latest QuickBooks Tool Hub version (click HERE), save the .exe setup file on your local storage, and then open the file.

Note: If you have already installed the QB Tool Hub on your PC, find the current version at the bottom of the Home menu. If you don’t have the most recent QuickBooks Tool Hub version (1.6.0.5), follow these steps to download and install the latest version.

2. Further, follow the on-screen instructions and accept the terms and conditions for installing the program.
3. Once the installation is complete, double-click the QB Tool Hub icon on your Windows desktop to launch it.

Note: If you face trouble locating the QB Tool Hub icon, manually search for “QuickBooks Tool Hub” in the Windows search panel and select it to launch the program.

Once done, run a program repair with the Quick Fix My Program tool in the next step.

Step 2 – Use the Quick Fix My Program Utility

You can run a program repair using the Quick Fix My Program tool if your invoices are lost after updating QuickBooks. This tool terminates background processes that QuickBooks uses and can resolve general program problems. To use this tool, follow the detailed steps mentioned below –

1. Launch QB Tool Hub and click the Quick Fix My Program tool from the Program Problems menu.
2. Further, run the tool and repair QuickBooks Desktop. Once the tool stops running, open QBDT and open your company file.

Now, check if you can find the missing data and invoices. If the issue persists, run the QuickBooks Install Diagnostic tool in the next step.

Step 3 – Run the QB Install Diagnostic Tool

The QuickBooks Install Diagnostic utility helps resolve the QBDT installation problems. You can run this tool to perform an installation repair by following the steps below –

1. In the QuickBooks Tool Hub program, go to the Installation Issues section and click the QuickBooks Install Diagnostic tool.
2. Run the tool and let it fix the QBDT installation issues, which can take up to 20 minutes.
3. Once the process is complete and the tool stops running, restart the PC and relaunch QB.

Ensure QuickBooks is updated to the latest release, then check your company data to ensure the missing data issue is resolved.

Conclusion

We hope this comprehensive guide helped you resolve the QuickBooks Data missing after update issue. However, if you find QuickBooks data is missing after update, even after following the troubleshooting solutions, you can contact our team of experts at 1-855-856-0042 for immediate troubleshooting assistance.

FAQs

Summary

Article Name

QuickBooks Data Missing After Update? Fix it Now!

Description

Are you unable to find your QB data after the update? Follow this guide to learn about the solutions for when QuickBooks data is missing after an update.

Author

Erica Watson

Publisher Name

Pro Advisor Solutions

Publisher Logo