Miscellaneous Expense with Security & Include Unrealized Gains in Current Budget Report problem
I found an anomaly in the Current Budget report when I use the Miscellaneous Expense transaction from an investment account with the Security option selected and choosing the optional "Include unrealized gains" selection in the report. I was able to recreate this report behavior in a new quicken file by following these steps:
1. Add a manual investment account with an opening balance.
2. Add a security and purchase shares at a price that leaves an unrealized gain.
3. Enter two miscellaneous expense transactions one with and one without the optional security selected to the purchased security. I chose different dates and different categories for each. My example: $50 without security, category "Interest Exp" and $40 with security, category "Misc".
4. Create a Budget selecting the chosen categories and including _UnrlzdGain. I included some other arbitrary budget amounts and categories.
5. Then use the Current Budget report:
a) as is. The report looks fine.
b) change report settings Advanced tab select "Include unrealized gains". The miscellaneous expense with security item ($40) is zero for the line item, but is in the total ($90). The miscellaneous expense without security shows correctly ($50). The unrealized gain does not show for item _UnrlzdGain but is in the total ($108). Clicking into either "0" actual, the detail report shows the correct data.
c) change settings Display tab under Organization from "Income & Expense" to "Category Group". The miscellaneous expense w/security still zero, but NOT in the total (changed from $90 to $50). Now the _UnrlzdGain shows the correct $108, but the total is increased to $148. The Net Difference total is still correct ($108 -50 -40 = 18), but the Personal Income total - Person Expenses total ($148 -50 = 98) is wrong.
I prefer to use the Category Group layout and I have been using the _UnrlzdGain along with my entire budget/valuation spreadsheets. I have only just recently started using the miscellaneous expense transaction tied to a security. I think it is very good idea as various fees are tied to specific securities. (I see that the ability to enter a negative dividend adjustment was removed from QW.) Please figure out why this report behavior is occurring as I cannot use the mis exp with security as it is functioning with this report.
Thank you.
