Hi @nytcpa,
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.
- 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.
After that, 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.
I'm attaching our page about reports and accounting for more tips and recommendations.
That'll do it. Please don't hesitate to reach out if you need help with anything else. I'll be around to assist you. Thanks for visiting us today and have a good one.
