Learn how to resolve data damage on your QuickBooks company file
QuickBooks Data Damage is one of the chief problems that usually appear in software like QuickBooks. However, with some necessary manual troubleshooting steps, this problem can be resolved quickly to retrieve the data file/files. But it’s imperative for you to understand the minor setups and arrangements that trigger QuickBooks data damage or company file corruption issues.
Through this blog post, we intend to help you resolve data damage on your QuickBooks company file with the manual solution best of our knowledge. You can also skip performing the troubleshooting steps provided herein and contact our QuickBooks enterprise support team.
Things to remember before proceeding
- First of all, You need to ensure to run the rebuild and Verify Data Utilities on the same computer system.
- After this, the Rebuild utility will make a backup of that file
- Now you can save the file anywhere you want
Resolve Data Damage on Your QuickBooks Desktop Company File
Mainly there are two steps to resolve this problem. You can take help from your IT professional or contact our error support team in case you get stuck somewhere by following given steps.
Step 1: Run the Rebuild Data Utility
- Go to File menu, choose ‘Utilities > Rebuild Data‘
- Select ‘OK‘ button in the backup of the data of QuickBooks company file.
- (There are chances that your computer will show that QuickBooks is not responding.) But if the cursor is moving, it means that Rebuild is going on. Let it complete.
- When Rebuild is complete, Select ‘OK‘ button.
Step 2: Run the Verify Data Utility
- Go to ‘File menu‘ and choose ‘Utilities > Verify Data‘
- Select ‘OK‘ if you get the message ‘QuickBooks detected no problem with your data‘.
- If there is an issue with the data, you will get the prompt ‘Rebuild Now‘ or ‘View Errors‘.
- Now, choose ‘Close‘ and perform the steps below:
Important Note: You can follow the steps below if you find yourself comfortable in reviewing the QBWin.log or QuickBooks.log file.
- Find QBWin.log or QuickBooks.log files
- Go to the ‘Tech Help‘ window if you are working with a support agent. Go to ‘Open File‘ tab, highlight the log file and select ‘Send log files‘ to Intuit Support. This will send the file as well as enable the agent to view the log files.
- Now, check the log file
- For Mac: Scroll down to the most recent verify information
- For Windows: Search for start verify and locate the most recent file
- In the opened file, you need to search by pressing ‘Ctrl+F keys’ for the start ‘Verify‘
- Now, find the line which is LVL_ERROR, and look for it in check QuickBooks Learn & Support Site. Also you can see that there is a data damage top LVL errors library
Why should you use Verify and Rebuild features?
- Encountering fatal errors while using QuickBooks Desktop
- Discrepancies on invoices, bills and other reports that post negative values
- Already deposited payment showing in the payment to deposit window
- Some accounts are missing from the balance sheet
- Some names are missing from lists
- Few transactions are missing from the record
- Checking if your company file is free from errors
Data damage troubleshooting for QuickBooks desktop Mac
If you are a QuickBooks Mac user then the below given steps will help you to resolve the data damage issues of QuickBooks:
Step 1: Re-Sort Files
Re-sorting the lists will help you putting your records back in order. In case you have changed the order of a list, resorting will do the needful.
Step 2: Identify Problem
- Go to ‘Reports menu‘, and select ‘Company & Financial‘ > ‘Balance Sheet Detail‘
- Now, select ‘Options‘, choose ‘Accrual or Cash‘.
- If you find that the total assets do not get equal with the liability and equity in all the reports, then you better determine the transaction which is causing the problem.
- Take a backup of the company file, ‘Delete and re-enter‘ the transaction
After this, compare the Account report totals to the balances on Chart of Accounts:
- Compare the open invoices to accounts receivable balance on the ‘Chart of Accounts‘.
- Compare the total in ‘Unpaid Bills report‘ to the ‘Accounts Payable balance‘ on the ‘Chart of Accounts‘
- Now, backup your company file, delete and re-enter the transactions or you can also modify the transaction.
Step 3: Check Specific Accounts
There are two specific accounts which include:
- Uncategorized Expenses:
- To balance the transaction, rebuild will put out-of-balance transactions in this account. You may also see voided checks in this account
- Other than voided checks, you will also find the transactions. Now, again delete and re-enter the transactions.
- Undeposited Funds:
- Go to ‘Activities‘, select ‘Make Deposits‘ and then, select all. Make sure that the total amount is equal to the balance shown for ‘Undeposited Funds‘ on ‘Chart of Accounts‘. Also, ensure that there are no deposits showing on the deposit.
Read Also: How to Resolve QuickBooks Error Code C=88?
Step 4: Merge the Damaged Accounts/Items/Names
- Go to ‘Lists‘ and select ‘Chart of Accounts‘.
- In the control key, select the account that has been damaged. Click on ‘Edit Account‘
- Make sure you put an asterisk (*) on the name of account
- Then, click on ‘Cancel‘
- While holding the ‘Control Key‘, select any account and click on ‘New Account‘
- Choose the type and enter the original name of the account having problem
- Click ‘OK‘
- Hold the ‘Control key’ and select original account. Choose ‘Edit Account‘
- Now remove the asterisk and select ‘OK‘ button
- Click on ‘YES‘ as this will confirm that you desire to merge the accounts
- To merge items and names, the same steps will be followed as the ones followed for merging accounts
Step 5: Delete Customer Reports
- Go to ‘Reports menu‘ and click on ‘Report Center‘
- Select ‘Reports‘ you want to delete and click on name once.
- Select ‘Red X‘ and click on ‘OK’ button.
Step 6: Delete Memorized Transactions
- Go to ‘Lists‘ and choose ‘Memorized transactions‘
- Go to ‘Edit menu‘ and choose ‘Delete memorized transactions‘
- Click on ‘OK‘ and the transactions will be deleted.
See Also: How to fix QuickBooks error code 15218?
We hope that the above-prescribed information is helpful for you to get rid of the QuickBooks company file data damage problems. In case, you are unable to perform the systematic steps of the solution or you seek expert assistance – chat with our QuickBooks data recovery number.