is it possible to create a report with the months across the top columns and the categories along the left side?
Category Month 1, Month2, Month 3, etc
A 50.00 20.00
B 100.00 100.00 100.00
C 70.00 25.00 15.00
In Quicken, a Category is like Groceries or Salary.
Your Column A does not look like Quicken Categories or subcategories, it looks like Payees.
Which do you want?
For a report like your example, you could run the Spending by Payee report, set the date range as desired, and set the Column to Month. Click on the gear at the top right to customize the report and on the Category tab, pick Groceries or whatever. That will show all your grocery expenses with a column for each month and a row for each store.
Have you taken a look at "Income and Expense By Category"? It does exactly that.
Yes, i looked at it, that is not what I am looking for, I am looking to see my list of categories displayed down the left column (A) and their associated expense amounts by month going across columns B-M . What the income and expense category does is Combines Prior year Jan- Dec 2022 to current YTD amounts
That doesn't do what I want.
Huh? That is not what I am seeing. If I run the report for a period of 1/1/22 up to today I see one column for each month:
You can also use Spending by Category and choose Month from the Column dropdown. It produces pretty much the same report except it doesn't show income by default.
I saw that, but it still doesn't do what i need. Picture a spreadsheet where
Column A is a specific category Sub categories and B-M are each individual months.
That was perfect, exactly what i needed.