Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
TUMC
Level 1

multiple bank accounts for one company using Quickbooks Online Pro

I'm using QB Online Pro for a nonprofit.  Everything is entered manually with no electronic banking used.  They have several checkbooks which I have separated for each bank account.  However, the income and expenses are included in all the reports.  Is there anyway I can get separate reports for each account?

Thanks so much.

1 Comment 1
Mark_R
Moderator

multiple bank accounts for one company using Quickbooks Online Pro

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:

 

  1. Sign in to your QuickBooks Online (QBO) account.
  2. Click Reports from the left menu.
  3. Search for the Transaction Detail by Account report.
  4. Select the reporting period you want to show.
  5. Click the Customize button.
  6. Go to the Filter section, then choose the specific bank account from the Account drop-down.
  7. Click Run report.
  8. Once done, click the Export icon and select Export to Excel.
  9. 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!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us