Incorrect or missing data on reports
Incorrect or missing data on Profit and Loss, Balance Sheet, and Transaction by Account reports. The causes of this issue may be incorrect report dates, filters, or display option settings, or list damage.
Your reports will be correct.
You have the latest QuickBooks version and tax table update.
Check for report parameter mistakes.
- Report dates are incorrect.
- From the report Dates drop-down arrow, select All.
- Look for the missing data.
- Report basis is incorrect.
- Check whether the basis of the report is Cash or Accrual, as this affects the data.
- Report filters are incorrect.
- Click Customize Report, and click the Filters tab.
- Check that the filters have not been changed in a way that would hide the missing accounts. For example, filtering the report for specific accounts leaves out all other accounts.
- If you want to remove all filters, in the Current Choices list, click each line, press Delete, click OK, and view the report.
- Report display options are incorrect.
- Click Customize Report, click the Display tab, and click the Advanced button.
- If you do not see a Display Rows section, skip to the procedure for list damage later in this article.
- If you see a Display Rows section, click All, click OK, and click OK again to view the report.
- The report will display all appropriate accounts regardless of account activity or balance.
- If the report does not display the accounts, the cause could be list damage.
- If the report displays the accounts, but the amounts are zero, check the filters again.
- Check the actual transactions that should be showing on the report to determine whether they are affecting the correct accounts or items. In particular, look for the last account on the report, as this is most likely where the damage is occurring on the list.
If there were no parameter mistakes, check for list damage.
- An account of one type shows as a sub-account of different account type. For example, a bank account may show indented under another current asset account, or an income account may show indented under an expense account.
- An account has no name.
- A rebuilt account has the name [#] Rebuilt.
- An account that used to be a sub-account is now a parent account (not indented).
Correct any list damage.
- Choose Lists > Chart of Accounts (or press CTRL + A).
- At the bottom of the window, click the Account button, and click Show All Accounts, if it is available.
- If Show All Accounts is available, view the report to see if the issue was resolved.
- If Show All Accounts is not available, click Account again, click Re-sort List, and click OK.
- View the report to see if the issue was resolved.
- If you see an account of one type showing as a sub-account of another type, edit the sub-account:
- In the Chart of Accounts window, select the sub-account that is not the right sub-account.
- Click the Account button, and click Edit.
- Click to clear the Subaccount of checkbox, and click OK.
- Check to see if this resolved the issue.
- If this didn't resolve the issue, in the Chart of Accounts list, to the left of the account,click the diamond, and drag it to the left.
- View the report to see if this resolved the issue.
- If the issue is not resolved, close QuickBooks, re-start QuickBooks, and then repeat this sub-procedure.
- Look for a rebuilt account, which is a damaged account that appears in the Chart of Accounts list as [#] Rebuilt. To fix a rebuilt account, follow these steps:
- Select the rebuilt account, click the Report button, and click QuickReport.
- View the transactions in the QuickReport to determine what account this should be.
- Close the QuickReport.
- With this account still selected in the Chart of Accounts, click Account, and click Edit.
- Re-name the account to its original name, and from the Type drop-down arrow, click the correct account type.
- Click OK to save your changes.
- You are unable to edit the damaged account.
- One or more of the damaged accounts are of the following types: accounts receivable, accounts payable, undeposited funds, or sales tax.
- Once the Chart of Accounts is in order, you run a report, and the account is still not showing the correct accounts.