Cash Flow Report Question about _Rlzdgain

Geobrick

I'm trying to look at all the income and expenses of several accounts in Quicken (H&B2017) in a set timeframe. Using a "Cash Flow" report seemed to cover what I needed except the income section of the report shows only the realized gains (_RLZDGAIN) of a stock sale instead of the total cash generated from the sale. I see what they're trying to accomplish but it's not what I'd expect from something called a cash flow report. 

When a stock is sold for $10, that $10 is added to the cash balance of the account. $10 cash 'flowed' into the account. (Yes, the share of stock equal to that value has "flowed out" of the account but it's not an asset flow report). If I paid $2 for the stock prior to the time frame of the report, I don't think it should be reflected in the cash flow since it "flowed out" prior to the time frame I set for the report. In my opinion, the report should show the cash generated by the sale not just the realized gain. 


If this behavior is by design, what other type of report can I use to get a full representation of cash added and cash removed from a set of accounts in a specific timeframe?

Unknown

Jim_Harman

Geobrick

QPW, Thanks for the quick reply. I tried the different transfer settings but it never brought in the cash transactions I was looking for. I'm not really looking for what transfers between accounts within the accounts selected for the report. I'm just trying to see every transaction that either adds or removes cash. It the case of the stock sale, the cash and securities are contained in the same account (there's no separate checking account) so the cash is never leaving the account. In my example above, I'd expect to see the $10 added to the account in the report not the realized gain of $8. I can remove the _RLZDGAIN category from the report but I don't know what category would pull the gross amount of the sale into the report.

Geobrick

Unknown

Geobrick said:

QPW, Thanks for the quick reply. I tried the different transfer settings but it never brought in the cash transactions I was looking for. I'm not really looking for what transfers between accounts within the accounts selected for the report. I'm just trying to see every transaction that either adds or removes cash. It the case of the stock sale, the cash and securities are contained in the same account (there's no separate checking account) so the cash is never leaving the account. In my example above, I'd expect to see the $10 added to the account in the report not the realized gain of $8. I can remove the _RLZDGAIN category from the report but I don't know what category would pull the gross amount of the sale into the report.

Yes that is sort of what I figured, but I really didn't see a way to do that, like I said the cash flow report is for in and out of categories, and there really isn't a category that tracks what you wanted.  That is given that I didn't think of Jim Harman's way.

Note that linked cash accounts can be setup even after transactions have been put in, but they are restricted to brokerage accounts, no retirement accounts.

And in the past I has problems if I tried to reverse that decision and let Quicken recombine the two accounts.

I might also add that even though it has been requested a few times, I don't think there is an investment report that would give you what you want if Jim Harman's suggestion doesn't work for you.

Jim_Harman

Geobrick

Geobrick said:

QPW, Thanks for the quick reply. I tried the different transfer settings but it never brought in the cash transactions I was looking for. I'm not really looking for what transfers between accounts within the accounts selected for the report. I'm just trying to see every transaction that either adds or removes cash. It the case of the stock sale, the cash and securities are contained in the same account (there's no separate checking account) so the cash is never leaving the account. In my example above, I'd expect to see the $10 added to the account in the report not the realized gain of $8. I can remove the _RLZDGAIN category from the report but I don't know what category would pull the gross amount of the sale into the report.

Maybe this is one of the reasons quicken seems to encourage the split checking account. To allow it to include these types of transactions in various reports. 

Jim_Harman

Geobrick said:

QPW, Thanks for the quick reply. I tried the different transfer settings but it never brought in the cash transactions I was looking for. I'm not really looking for what transfers between accounts within the accounts selected for the report. I'm just trying to see every transaction that either adds or removes cash. It the case of the stock sale, the cash and securities are contained in the same account (there's no separate checking account) so the cash is never leaving the account. In my example above, I'd expect to see the $10 added to the account in the report not the realized gain of $8. I can remove the _RLZDGAIN category from the report but I don't know what category would pull the gross amount of the sale into the report.

Yes, and to support the situation where you pay living expenses directly from an investing account. This is often called a "cash management account"

The down side is that all the cash from Buys and Sells runs through this account, even if you are exchanging one security for another in the investing account.

Jim_Harman