Report by category
Hi,
I am looking for a way to get my transactions pivoted on categories. For example how can I see what is my income by interest and dividend per month. I am
Able to filter them by category but it does not give me the sum total by category. Is there a way to do it?
thanks.
Comments
-
@simplira try this:
- Breakdown: By Payee
- Date Range: [Select a pre-set date range or select a custom date range]
- Filters: Categories > Personal Income > [select the income categories you want to see in the report]
- In the Report you can select how to display the results
Danny
Simplifi user since 01/22
”Budget: a mathematical confirmation of your suspicions.” ~A.A. Latimer0 -
I tried that. And this is what I got. :( Is your solution based on bank accounts or Investment accounts?
Using Categories and not Personal income gives a better outcome. HOWEVER, not being able to search on TYPES, has left out over 20 transactions in the last 5 days since TDA became SHB.
Being forced use of Types and no option to add to list is a killer.
0 -
@neon45 make sure you are on the income tab.
I don't know if this will give you what you are looking for. You may have to check to make sure interest and dividend income isn't marked to be excluded from reports.
Danny
Simplifi user since 01/22
”Budget: a mathematical confirmation of your suspicions.” ~A.A. Latimer0 -
All I know for sure is I wish I had Mint back.
Thought I'd try a spending report since the Investments don't really work.
I ran a Spending REPORT using 3 credit cards for last month. I only spent $588 !!! And, if I include all categories, my bank and credit cards I end up with $78. !!!!
Pretty much useless, and if I'm doing it wrong it's a poorly programed feature.
0 -
Thanks DannyB,
Appreciate your efforts, but, as you can see, I used Net Income for that example. I also used Income for another try.
I am looking for what simplira was looking for. I want to know how much I have made in Dividends, Interest, etc, in the last month, year to date.
I tried the Report you suggested.
Thanks… appreciate the replies.
0 -
how are you entering credit card payments, are you using the linked transfers category? That might explain it if you are not.
—
Rob Wilkens0 -
Indeed, with the exception of "Payment/Income" "Action" types, by default QS will exclude all other investment Actions. However, this is how you can bring investment dividend and interest income into your Income report.
- Hover over the menu on left of screen and select Investments
- Click on the "Transactions" tab
- Changed "Action" from "Income Dividend" to "Payment/Deposit"
- Changed "Description/Category" to "Personal Income" > "Dividend Income"
- Clicked on the 3-dot menu and selected View Transaction
- In the Transaction Detail window deselected "Exclude from reports"
- Clicked "Update"
Now on the Reports > Income tab you can Breakdown by Category, select date range and Filter for Category>Personal Income>Dividend Income.
You should be able to follow the same process for any interest income in your investment accounts with the same results.
I opened one of my connected investment accounts and searched the transactions for "Income Dividend" which brought up all my dividend transactions. I clicked the select box for several of these transactions and clicked on the edit icon to see about doing a batch "Action" change, but "Action" is not in the list of editable fields.
Danny
Simplifi user since 01/22
”Budget: a mathematical confirmation of your suspicions.” ~A.A. Latimer0 -
Hello Danny,
The recommendation; "Changed "Action" from "Income Dividend" to "Payment/Deposit"" is what I have done, and commented on in an earlier discussion.
The problem comes when Ordinary dividends, Qualified dividends, CD interest, T bill interest and money market interest is payed. I have to change 100 Incomes to Payments. That, is not something I look forward to. This whole mess is a result of TDA being bought out by Schwab and the 2 different reporting headers. 😫
0 -
Ah yes! I started way back with Scottrade who was gobbled up by TDA who was gobbled up by Charles Schwab!
I only track my grandkids’ custodial accounts in Quicken Simplifi which are relatively small investment accounts and the number of transactions per month are low. I don’t bother with tracking in QS the dividend or interest in these accounts since there is no income impact on me.
My major investments accounts are manual for net worth purposes only. Those are managed by our financial advisors and held at Pershing and the only income I want to track on those accounts is our monthly draw.
If I was an active trader and tracking investment income, I wouldn’t use QS since it’s not primarily set up for that type of accounting. I do use my advisors dashboard which does an excellent job of keeping track of all our accounts but it’s budget feature is very basic and thus QS!
Danny
Simplifi user since 01/22
”Budget: a mathematical confirmation of your suspicions.” ~A.A. Latimer0 -
Thanks Danny,
Yeah, I started with Scottrade as well. Got into Mint about TDA time. Agreed, this isn't the place to track investments, but, it was the best of the evils when Mint folded up shop.
It's sad that we can't search on a silly date range or sort / modify the Type transactions. Makes no sense. And not being able to save a list of Categories for a Report that you would do every month. And I just noticed the report pulls up my home & car insurance in the monthly report twice. :(
Not a thrilled puppy, but stuck for now. Thanks for the help.
0 -
Hi Rob,
I'm not sure what the Transfer Category is, but my Bank account categorizes payments to my credit card companies by the Credit Card name.
In my credit card statements the payment from my bank is categorized by the Bank Name.
0 -
Bank name is likely a subcategory of transfer category... so that much is right
—
Rob Wilkens0
