Primary Sort Report by Category Group, then Categories within the groups
bri2kay
Quicken Windows Subscription Member
I have a basic Income Expense Report that I would like to view with expenses separated by Personal and Business. I have successfully created the Category Groups and assigned expenses to each. According to Help, I should be able to select Category Group tab in customize report however tab does not exist.
Any suggestions?
Ex. INCOME category group
income categories detail
PERSONAL EXPENSE category group
personal expense categories detail
BUSINESS EXPENSE category group
business categories detail
TRANSFERS...
Any suggestions?
Ex. INCOME category group
income categories detail
PERSONAL EXPENSE category group
personal expense categories detail
BUSINESS EXPENSE category group
business categories detail
TRANSFERS...
0
Best Answer
-
If we've created a category group, when we customize a summary, comparison, or budget report there should be a Category Groups tab presented that allows us to filter the report's transactions by the selected categories filtered by the selected category groups. For example, select Reports > Spending > Income and Expense by Category, press Alt + C, and select the Category Groups tab. The generated report will not be sorted by category group but we may create a generate a report for each category group.
6
Answers
-
If we've created a category group, when we customize a summary, comparison, or budget report there should be a Category Groups tab presented that allows us to filter the report's transactions by the selected categories filtered by the selected category groups. For example, select Reports > Spending > Income and Expense by Category, press Alt + C, and select the Category Groups tab. The generated report will not be sorted by category group but we may create a generate a report for each category group.
6 -
Or you might try the surprisingly flexible report at Reports > Banking > Cash flow by Tag.
Click the gear to customize, then set Row to Category, Column to the date interval you want, and Organization to Category Group.
The only downside I see to this is that the category groups are arranged alphabetically, so you might have to do some creative naming of the groups to get them in the order you want.QWin Premier subscription1 -
Did you happen to find a resolve for this? I was trying to do the same thing. The two suggestions didn't really do it for me. I don't really want to create new categories of Personal, Business, Rental and rearrange everything since they are already organized in Groups. I just want to sort by Group then Category.0
This discussion has been closed.