cancel
Showing results for 
Search instead for 
Did you mean: 
Kristy2
Level 2

I have 4 bank accounts and I want to run a report on each one of those accounts with all transactions showing. I don;t want one report with all 4 bank accounts in it.

 
3 Comments 3
Bonny_
Moderator

I have 4 bank accounts and I want to run a report on each one of those accounts with all transactions showing. I don;t want one report with all 4 bank accounts in it.

Hi Kristy2,

 

If you're using QuickBooks Online Essentials or Plus, you can run the Transaction Detail by Account Report, then filter the report by bank account. 

 

To do this, 

  1. Go to the Reports menu.
  2. Find and open the Transaction Detail by Account Report.
  3. Use the basic filters at the top of the report to adjust things like the report dates.
  4. Select Customise to open the customisation window.
  5. In the window, select the Filter ▼ icon.
  6. Select the Distribution Account drop-down.
  7. Select the bank account you want to view from that list.
  8. When you're ready to apply the filters, select Run report.

You can then select Save Customisation to save that particular report's filters. Repeat the steps above for the 3 other bank accounts, and you will effectively be running one report for each bank account.

 

Bonny

 

Kristy2
Level 2

I have 4 bank accounts and I want to run a report on each one of those accounts with all transactions showing. I don;t want one report with all 4 bank accounts in it.

Thanks so much for this.  I am still a little confused though...

 

One of my accounts has 239 transactions to reconcile however when I produced the report it only showed 62 transactions.  I have no other filter on except for the Distribution Account.

FritzF
Moderator

I have 4 bank accounts and I want to run a report on each one of those accounts with all transactions showing. I don;t want one report with all 4 bank accounts in it.

Thanks for getting back to us, @Kristy2.

 

You may haven't selected the right date on the report causing the other transactions not to show. If that's the case, ensure that you've chosen the correct one on the Report period section. This is located on the upper left of the report or by clicking the Customise option.

 

Here's a sample screenshot from my test account.

 

 

Just in case, I'll add this article for future reference: Customise your reports in QuickBooks Online.

 

Please know that I'm only a post away if you have any other issues or concerns. I'll be here to assist. Have a great weekend!