Skip to main content
I
IRG42
July 14, 2021
Question

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

  • July 14, 2021
  • 2 replies
  • 0 views

I am using QuickBooks Online Plus.

 

I want to create an account that shows spending by Category per account.  I.E. I would like to have a list of all the categories (i.e. taxes, bank charges, restuarants, COS, etc) down the left.  And the across the top the various bank accounts/credit cards used.  

 

Goal is to see what is the breakdown by account for each category.

 

Is this possible?

 

The 'Account Transaction detail' shows spending in each account, but does not enable summarizing by Category (in this report 'Category' is listed as 'Split').  Profit and Loss report shows summaries of categories but I cannot find a way to break it out by Bank Account/Credit Card.  I also looked at the 'Custom Summary Account' report  (Avail at URL: https://qbo.intuit.com/app/reportv2?token=CustomSummary).  But this cannot summarize based on category or account.

 

I understand that you cannot create truly custom reports in QuickBooks Online.  Maybe do I need to get a third party tool for this?

 

Thanks for any help on this.

 

Ian Graham

2 replies

S
SelenaN
July 14, 2021

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
IRG42Author
July 14, 2021

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

T
Tammy_H
July 14, 2021

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!

 

 

 

 

 

I
IRG42Author
July 18, 2021

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

A
Alex M
July 19, 2021

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,

Terms & ConditionsAccessibility statement