Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
posted
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.
- Go to the Reports menu.
- Search and select Transaction List by Account.
- Click the Filter. Select the account you want to filter.
- 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:
- Go to the Reports menu.
- Search and select Transaction List by Account.
- Click the Customize button. From the Account drop-down, select the checking accounts.
- Hit Run report.
Another option is to pull up a quick report. I'll help you how:
- From the Gear icon, click the Chart of accounts and find the checking account.
- Click the drop-down next to the View register,
- 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.
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:
- At the left navigation panel select Reports.
- Search and select Transaction Detail by Account
- 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:
- Go to Custom reports tab.
- Select the report you customize then under the Action column, select Add to Management reports.
- Choose Create a new management report.
- Enter a name, then go to manage report.
- There you can access the report you added to.
To add the deposit report, here's how:
- At the left navigation panel select Reports.
- Search and select Transaction Detail by Account
- 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!
