Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
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!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up