Transaction report by expense category by last year report using 2023 QBO version? THX in advance!

A warm welcome to the Community, @rerocks. I understand this is new to your end but don't worry I'm here to share some insights.

When you state that you used to be able to customize a transaction report before, but not in today's online version, are you referring to the new enhanced experience or modern view of QuickBooks Online? If so, I can definitely walk you through how to customize expense transaction reports.

Here's how:

1. Go to Reports.
2. Find the transaction report you want to customize.
3. Customize the report according to your preference.

Customize a report

You can apply multiple filters to customize your report. Most reports have the same set of filters. Some filters are only available on certain reports.

Here's an overview of what you can customize:

• General section: Change things like the accounting method, reporting period, and number format.
• Rows/Columns section: Choose which rows and columns appear on the report.
• Filter section: Select which customers, distribution accounts, vendors, accounts, and products appear on the report.
• Header/Footer section: Decide what appears in the header and footer.

Once you're done customizing a report, give your report a name then select save customization.

If you feel at ease using the old way of customizing your transaction, you are free to do so. By switching to classic view, you can customize it to your preferred way.

Here is a sample photo if you want to switch to classic view, and you're a visual person. For your reference.

Furthermore, to learn how to custom reports in QuickBooks Online you can always refer to this article.

Feel free to reach back if you have other concerns. We'd be glad to assist!

First of all THX to everyone that read my conundrum, especially "ShaniamarieC" who was generous in sharing her initial (and my only) reply.

THX too for overlooking the newbie nature in the phrasing of my question.

That said, please allow me a "take 2"...

The report I'm interested in is a Transaction Report of Expenses by Category.

Regardless of classic or newer view of my data, I'm unable to see or discern any report in the initial "Find report by name" drop down search bar that speaks to my needs or even remotely resembles it.

The closest I can reach for seems to be a n "Expense Report" or a "Transaction List by Date Report". The problem I see there is neither option seems to be able to Group by (expense) Category.

Perhaps I'm over looking something but the report I had saved and used to be able tun at will was a report that showed all my expenses grouped by Categories in QBO (that I initially set up as per a Schedule C).

As I ran that report it would display all my expenses by Category for a chosen time frame.

In other words it would show me as an example my YTD Utilities (as a Category) w all my individual expense or sub Category types (phone, data, electric, heat, ISP, etc) regardless of Payee or how Paid (check, credit card via split expenses, etc) lined up under that primary Category.

That way I could run that report and fill in the blanks on a Schedule C w confidence and use my QBO report as back up.

If anyone has suggestions as to where and how I might get or replicate a report as I've outlined please LMK.

Once again THX too for your kind attention!

You are always welcome here in the Community, rerocks1. We make sure to answer all your concerns here. Thank you for the appreciation, especially to my colleague who previously handled your initial concern. 

Since you want to run an Expense report showing the categories, let me show you how:

1. Go to Reports.
2. Under the Find report by name dropdown▼, type in Transaction Detail by Account, then select it.
3. Click Switch so classic view.
4. Select Customize, then adjust the Report period that you want to show up. 
5. Choose Account on the Group by dropdown▼.
6. Under filter, tick the box for Account and Transaction type.
7. Beside the Transaction Type dropdown▼, Choose Expense.
8. Run Report.
   
   

I can also show you an article that will show you many ways in customizing reports in QuickBooks Online. This will help you filter specific accounts for customers or format the layout, so the right data shows up in the right place: Customize reports in QuickBooks Online (intuit.com).

If you have further concerns with running an Expense report, feel free to comment below. We are always here to help. 

THX again Camelle T!

Your reply comes closer as close as I've been of late but still doesn't quite get me there.

I'm seeing a lot of promise but no totals by expense Category.

I'd prefer to see expenses by payee by Category as a sub total (for sub Categories) then a total of subs by primary expense Category.

That (those) number (s)  should represent my Chart of Acct expenses and be able to be plugged into my Sched C.

Again all the expenses Categories and their subs are in my QBO Chart of Accts I just need a report that shows what they are within a chosen time frame.

Is there a support phone I can call or method to have them call me?

That way I can have a real time conversation w someone and get the result vs typing a story that comes close but misses the mark.

Especially since a handicap prevents me from typing and this forum doesn't appear to support voice to text.

THX for understanding and your kind attention once again!

KA

Thanks for getting back to the thread and clarifying your concern, @rerocks1.

We're sad to hear that the recent steps provided by the previous representative didn't work on your end. However, let us give you another way to see your expense category by last year. In this case, you can run the profit and loss report and choose the reporting period you want to see to show all expense account totals and the total amount accumulated to the expense account you have from the previous year. I'll show you how:

1. Go to Reports
2. In the Standard panel, choose Profit and Loss report.
3. Click Customize then choose the date you wish to pull up in the Report Period. 
4. Hit Run report.

If it still doesn't work, we suggest contacting our team support so they can help you with your queries. Feel free to check this article for more details: QuickBooks Online Support.

In addition, I've also added this article to guide you on how to memorize reports in QuickBooks Online. Memorize reports in QuickBooks Online. 

@rerocks1, feel free to post here again if you have any additional questions related to the program. We've got you covered, and we'll get back to you. Take care.