When users open an older customerinvoice in QuickBooks and try to view it, they may encounter Error Code 267 when rebuild is not working. If they try to close the invoice, a dialog box will appear asking for credentials for modification before the closing date. This error also appear when users open the balance sheet after performing other tasks in QuickBooks.
This article will providesolutions for Steps to troubleshoot the QuickBooks Error Code 267 specifically in cases where the balance sheet is unbalanced.Thus, keep reading..!
Causes of QuickBooks Error Code 267
This error code indicates that theQuickBooks company file is either damaged or corrupted. Check out the following
possible causes related to such errors:
- There was an imbalance in the balance sheet.
- If there is amissing sales tax code in Target, token headers pertaining to the user may
refer to NULL. - If there is amissing sales tax code, discrepancies can arise in reports such as invoices.
- Bills havebeen recorded with negative values.
- There areaccounts that are not displayed in the balance sheet reports.
DIY Methods to Troubleshoot QuickBooks Error Code 267
To resolve this error, you can try the following solutions:
Step 1: Verify the Data
To verify data, first close allwindows, go to the File menu, and select Utilities. Then, click on Verify Data.
The following messages may appear:
- If there areno issues with the data, no action is required.
- If there is aspecific issue, a message will explain the cause.
- If themessage reads "Your data has lost integrity", it means thereis data damage in the file.
- If there isan issue, proceed to the next step to rebuild the data.
Step 2: Rebuilding the Data
Rebuilding the data will fix theintegrity concerns identified during the data verification. To rebuild the
data, follow these steps:
- Open the Filemenu, select Utilities, and choose Rebuild Data.
- A warningmessage will appear, reminding you to back up the company file before rebuilding, as the process may involve deleting transactions, invoices, or list entries to resolve the issue.
- Select thelocation to save the backup file, and click OK.
- If promptedto replace another backup file, select No and enter a new name for the backup file.
- If the backupfails, you can choose to cancel the rebuild or seek help from the payroll helpdesk support.
- Once thebackup is complete, click OK when you receive the message that the rebuild is
finished.
Method 3: Verify the remaining data damage
Verifying the remaining data damage is crucialto ensure that the data is error-free. Here are the steps to follow:
- Open the Filemenu and select Utilities.
- Then, clickon Verify Data to check for any remaining damage.
- If anyadditional damage is found, it will need manual correction.
- Locate theissue within the qbwin.log file and find a solution from the QuickBooks Desktop official support website.
- If no erroris detected, restore a backup that was previously created.
- To do this,go to the File menu and select Restore.
- Whilerestoring, make sure not to overwrite the existing company file. After completing the restore process, you may need to manually re-enter the entries.
Method 4: Use the QuickBooks Auto Data Recovery feature
The QuickBooks Auto Data Recovery feature is a built-in tool that can help recover lost or damaged data inyour QuickBooks company file. It creates a duplicate copy of the QuickBooks company file and saves it in a separate folder. Here are the steps to use the Auto Data Recovery feature:
- Locate thefolder where QuickBooks stores the Auto Data Recovery files. This folder is usually located in the same folder as your company file, with the suffix "AutoRecovery"added to the end of the file name.
- Look for thetwo files with the extensions .QBW.adr and .TLG.adr. These files are the Auto Data Recovery files.
- Copy bothfiles and paste them into a new folder on your desktop or in another location on your computer.
- Rename the.QBW.adr file to .QBW and the .TLG.adr file to .TLG.
- OpenQuickBooks and open the company file from the new folder you created.
- Verify thatall of your data is intact and that the error has been resolved.
Note that the Auto Data Recoveryfeature is not always successful in recovering data, and it can take some time to complete the process. If the Auto Data Recovery feature is not able to recover your data, you may need to restore a backup copy of your company file.
Wind Up!
We hope the above steps have beenhelpful in resolving QuickBooks Error Code 267. However, if youencounter any further difficulties or require additional assistance, please
don't hesitate to reach out to us at 1-800-615-2347. Our QuickBooks error support team will be more happy to help you.