Hi there, @giannibyte.
I appreciate you for providing details about your concern.
QuickBooks report generates all accounts that include activities. You'll want to pull up two reports and export them to Excel. Let me guide you through the process.
While zero balance items are still showing on the P&L report, you can export it to Excel. Then, remove those items from there.
Let me show you how:
- Go to Reports, then type Transaction Detail by Account.
- Select Customize and Filter.
- Mark the Distribution Account box, then choose All Income/Expense Accounts.
- Click Run report. Make sure to change the Report period to your desired report date.
- Hover towards the Export icon. Then, Export to Excel.
Then, pull up the account list report and export it to Excel. Here's how:
- Go to Reports, then type Account List.
- Select the Export icon beside the Printer icon.
- Click Export to Excel.
Once done, you can then compare which accounts have zero balance with no activity. You also have the option to delete or merge rows and columns in your Excel.
To learn more about the solution above, check this out: Export reports as Excel workbooks in QuickBooks Desktop. This article will also help you get updated reports while working in Excel.
To learn more about running and customizing reports in QBDT, you may check these articles:
You can check the damaged transactions/s shown in QBWin.log and apply the solution once it finds an issue.
Don't hesitate to leave a comment below if you have any other questions about the report. Have a good one.
