Skip to main content
M
mophidaho
May 31, 2024
Question

The only reports I have now combined all 3 into one report. I have 3 checking accounts and want a set of reports from each.?

  • May 31, 2024
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

A
ArielI
May 31, 2024

Hello, @mophidaho.

 

I'd be happy to help you in creating a report for each checking account in QuickBooks Online (QBO).

 

To do this, you can pull up the Transaction List by Account report in QuickBooks Online. If you're using a Modern view, you can filter the report by individual accounts.

 

  1. Go to the Reports menu.
  2. Search and select Transaction List by Account.
  3. Click the Filter. Select the account you want to filter.
  4. Finally, click Save as.

 

However, if you're using the Classic view, I recommend customizing the Transaction Detail by Account report. I'll guide you through the steps:

 

  1. Go to the Reports menu.
  2. Search and select Transaction List by Account.
  3. Click the Customize button. From the Account drop-down, select the checking accounts.
  4. Hit Run report.

 

Another option is to pull up a quick report. I'll help you how:

 

  1. From the Gear icon, click the Chart of accounts and find the checking account.
  2. Click the drop-down next to the View register,
  3. Then select Run report.

 

Furthermore, I've also included additional articles that can be useful in managing your reports and how to reconcile your accounts.

 

 

Let me know if you have other concerns aside from managing your financial reports. I'll be here to help.

M
mophidahoAuthor
June 2, 2024

I do not have a Transaction List by Account listed. The Gear Option works, and I got a Quick Report. That is a good start. 

The current report, while functional, presents all the transactions in a single column with a balance at the end. This layout is not ideal for my needs.

How can I put the deposits and expenses in two columns, different ones with Balances, and then save them as reoccurring management reports for each account?

 

S
Shania_C
June 2, 2024

Thanks for getting back to the Community, mophidaho.

 

Let me dive into your conversation to help you manage your report according to your preferred custom reports in QuickBooks Online.

 

The ability to put the deposits and expenses in two columns, different ones with balances, and then save them as recurring management reports for each account in QuickBooks Online is not yet available. However, I can show you a workaround that presents the deposits and expenses transaction type that can be seen in the management report tab.

 

Here's how:

 

  1. At the left navigation panel select Reports.
  2. Search and select Transaction Detail by Account
  3. Click the Filter. Under the:

 

  • Filter by, select Account type.
  • Options choose equals.
  • Value pick Bank.

4. Then +Add Filter.

  • Under the Filter by, select Transaction type
  • Options, choose equals
  • Then for the Value, pick Expense

5. Also, make sure to select the Report period according to your date preferences
6. Finally, click Save as.

 

Here's a photo for your reference:

 

 

 

Furthermore, for the next step:

 

  1. Go to Custom reports tab.
  2. Select the report you customize then under the Action column, select Add to Management reports.
  3. Choose Create a new management report.
  4. Enter a name, then go to manage report.
  5. There you can access the report you added to.

 

To add the deposit report, here's how:

  1. At the left navigation panel select Reports.
  2. Search and select Transaction Detail by Account
  3. Click the Filter. Under the:
  • Filter by, select Account type
  • Options choose equals
  • Value pick Bank

4. Then +Add Filter.

  • Under the Filter by, select Transaction type
  • Options, choose equals
  • Then for the Value, pick Deposit

5. Also, make sure to select the Report period according to your date preferences
6. Finally, click Save as.

 

Then repeat the process, moreover, to check the custom reports tab, select the report you just customized then under the Action column, select Add to Management reports then choose Add to an existing management report from there you can access the report you added to by clicking Preview.

 

Additionally, you can refer to this article to learn more about the available reports. Also view the table listing reports available for your version in QBO:

 

 

If you have any more questions or need further assistance in managing your reports in QBO, I'm just a reply away. Have a lovely day!

Terms & ConditionsAccessibility statement