Fix Reporting Subcategories

Help.Me.Help.You

Hi. My paycheck is deposited to a brokerage account. I record it in quicken as a paycheck (split transaction with gross income less deductions, net is deposited). When I run a report and select "hid subcategories", the subcategories for my paycheck are broken out in the report anyway. This seems to happen with all subcategories in transactions in brokerage accounts. Please fix this. It makes reporting difficult to use.

Jim_Harman

What standard report is your report based on?

Does the report behave differently if you make the deposit into a banking account?

You mention both splits and subcategories. Is it the categories in the splits or the subcategories that you want hidden? (Subcategories are categories that make up a main Category, like Taxes:Federal and Taxes:State)

Help.Me.Help.You

This problem is still happening. Response to questions above:
* Income/Expense by Category (though it happens in all reports)
* The issue does not happen when I enter transactions in other types of accounts
* Why I mention splits and subcategories:
--I enter a transaction in a brokerage account
--The amount is split between several categories, some of which are subcategories
--for example, I pay an "Education Expense" bill in which the total amount is split across "tuition", "fees for this", and "fees for that"
--the categories "tuition", "fee for this", and "fee for that" are subcategories of "Education Expense"
--I then run an "Income/Expense by Category" report, and I indicated I do not want to see subcategories
--All subcategories are hidden, EXCEPT FOR THE SUBCATEGORIES USED IN TRANSACTIONS LIKE THE ABOVE IN A BROKERAGE ACCT
--If I enter the same transaction the same way using a bank account in quicken, the subcats are hidden in the report

This is makes reporting difficult b/c I pay several large bills this way using a brokerage account

UKR

If a regular brokerage account (not a retirement account) is used as a frequent checking account, there's an option you can use to create a linked Cash/Checking account and then use that as if it was a separate checking account for all your banking transactions in the investment account.

This may help solve your category reporting issues.

To enable this function:

• First create a backup of your data file.
• Go into Edit Account Details on the brokerage account.
• Look for "Show cash in a Checking account" and set the radio button to Yes. Click OK.
• This will now take some time to create a new account register, e.g., "XYZ Brokerage (Cash)" and move all banking transactions from the investment register to the banking register.

You may have to review your reports and other views to ensure that the new banking register is included in the reports/views.

Help.Me.Help.You

Thanks for the tip! This is a long-standing account, so am a bit tentative. I may create a copy of my file and see what happens.

I suspect I'll run into problems with downloaded transactions and reconciling? For instance, if cut a check from the brokerage account, then download transactions in quicken, I expect the check will show up in the brokerage account? (...not the linked cash account)?

Jim_Harman

Help.Me.Help.You said:

Thanks for the tip! This is a long-standing account, so am a bit tentative. I may create a copy of my file and see what happens.

I suspect I'll run into problems with downloaded transactions and reconciling? For instance, if cut a check from the brokerage account, then download transactions in quicken, I expect the check will show up in the brokerage account? (...not the linked cash account)?

No, if you have selected the Show cash in a checking account option, all cash transactions for the account, including downloaded Write Check transactions, will appear in the linked account. Dividends received in cash will appear as DivX transactions in the investing account, with the cash automatically transferred to the linked account.