It's good to have you here in the Community, @TUMC.
I'm here to help run separate reports for each bank account that show the income and expense transactions.
The Transaction Detail by Account report is the best report you can run to get the information you need for each account. You can customize the report to the specific bank account and export it to an Excel file. This way, you'll have separate reports on each account. Here's how:
- Sign in to your QuickBooks Online (QBO) account.
- Click Reports from the left menu.
- Search for the Transaction Detail by Account report.
- Select the reporting period you want to show.
- Click the Customize button.
- Go to the Filter section, then choose the specific bank account from the Account drop-down.
- Click Run report.
- Once done, click the Export icon and select Export to Excel.
- Then, repeat steps 4 to 8 for the remaining bank accounts.
I'm adding this article to learn more about customizing reports in QBO: Customize reports in QuickBooks Online.
Come back to this post and let me know how it goes, @TUMC. I want to make sure this is taken care of.
You may also want to reconcile your bank accounts in the future. This will help make sure your QuickBooks transactions match your bank statement.
Wishing you all the best!