How to Create a Custom Report - Category Spending by Bank Account

Hi Ian Graham,

I'm glad that you have joined the Community for support with using Quickbooks. If you are working with an accountant already, you can navigate to the My Accountant tab and invite your accountant using their email address. When they accept the invitation, they will be able to work with you in QuickBooks to customize a report.

If you don't have an accountant yet, you can click https://quickbooks.intuit.com/ca/find-an-accountant/ to get in touch with a certified ProAdvisor, who are more than happy to support you on this issue.

If you have more questions related to QuickBooks, don't hesitate to reach out to us. We are here to help you achieve your QuickBooks goals.

I would like to be able to do this myself and not through an accountant.  

Any ideas on how to create a report like this?

Thanks

Ian Graham

Hi Ian,

I know finding the right setup for your reports is key to tracking your accounts. QuickBooks Online has several reports that can be customized in various ways, and it's just a matter of finding the one that works for you. I can help you find the correct report and how to customize the report.

Go to Reports in the left menu > Select the Transaction List by Date Report > Click Customize and check Payment method in the Rows/Columns dropdown > In Group by choose Payment Method > In the Sort dropdown, select Account > Click on Run Report.

I hope this helps. If you have any other questions, let me know. Have a wonderful evening!

Thanks, but this still does provide a summary of the amount spend in each spending category.  It would just allow summary by payment method. 

Looking for  a report that has all the spending categories down the left and all the bank accounts across the top.  Or even just all the spending categories per account and I could re-run it fore each account.

Ian Graham

Hi there 

It's important that you're able to keep an eye on the financials of your business. QuickBooks Online allows you to view transaction reports of each account to be able to see how much was spent on each account. I can provide some assistance.

One way to see the number of transactions spent in an account as well as some details would be to run a transaction report for that account. You can do so by navigating to the Accounting tab, then Chart of accounts. Choose an account you want to view transactions in, then select Run report from the drop-down menu in the right column of the row. You can customize which period you want to see in the report as well as some columns you want to see.

If you have any other questions, feel free to reach out here,