Income & Expenses Report

I am confused by the Transfers at the end of the Income & Expenses report.
It seems to double count on the bottom line.

If I purchase $1000 in stock from my savings, the transfer shows a -$1000
(negative because I have taken $1000 out of my cash and transfered it to an
investment).

If I sell that stock for $1500. My report shows $500 capital gain in
income, and a positive tranfers of $1500 (positive because I have transfered
the money back into my cash). However these are added and thus shows a
positive $2000 on the bottom line. It doubled the bottom line impact of the
capital gain.

It does this with dividends to, A $100 dividend shows up as $100 of income
and a positive $100 transfer - thus a $200 positive impact.

Why does this report double these figures?

Dick
Sun Aug 26 08:12:11 CDT 2007

It includes them because the customization is set to include them. You can
clear that setting on the Rows & Columns tab. (Assuming M04 or earlier,
M05-M+ Advanced Reports and not Money Essentials (MEss) or M+Ess.)

Note that the options on this are don't include / include transfers to or
from asset or liability accounts / include transfers to or from accounts
that aren't included in this report. If you just want to know your income
less expenses, use the first, if you want different views of net cash flow,
use the second (the default) or the third and play with which accounts are
included.

I agree you have to be very mindful of what this is actually showing to make
sense of the bottom line.

"mb" <mb@discussions.microsoft.com> wrote in message
news:B1AC6718-9774-469F-945D-973F76F76518@microsoft.com...
>I am confused by the Transfers at the end of the Income & Expenses report.
> It seems to double count on the bottom line.
>
> If I purchase $1000 in stock from my savings, the transfer shows a -$1000
> (negative because I have taken $1000 out of my cash and transfered it to
> an
> investment).
>
> If I sell that stock for $1500. My report shows $500 capital gain in
> income, and a positive tranfers of $1500 (positive because I have
> transfered
> the money back into my cash). However these are added and thus shows a
> positive $2000 on the bottom line. It doubled the bottom line impact of
> the
> capital gain.
>
> It does this with dividends to, A $100 dividend shows up as $100 of
> income
> and a positive $100 transfer - thus a $200 positive impact.
>
> Why does this report double these figures?

mb
Sun Aug 26 09:52:04 CDT 2007

Thank you for taking the time to respond. I did know the option to not
include transfers, but I do want to include them. I ultimately want the
report to show my income, less my expenses, less the money I transfer into
investment accounts.

Ideally I would like to see:
1) Investments sold and kept as cash to show as a positive transfer (it does
this).
2) Investments purchased from cash to show as a negative transfer (it does
this).
5) Income gained from an investment and reinvested to show as income gained,
and then a negative transfer, for a net-zero gain on the bottom line.
4) Income (like a dividend) gained and kept as cash to show as either as
income gained or a positive transfer - but not both, which effectively
doubles the bottom line. I don't understand is why MS Money.

Is there a different report (or upgrade) that will give me this cash flow
analysis. I would think it would be a standard way of evaluating and
managing ones budget?

I am using MS Money 2005 Delux. I am tempted to see how Quicken handles
this, but I have used MS Money religiously for 5 years and cringe at the
thought of getting all that data transfered accurately).



"Dick Watson" wrote:

> It includes them because the customization is set to include them. You can
> clear that setting on the Rows & Columns tab. (Assuming M04 or earlier,
> M05-M+ Advanced Reports and not Money Essentials (MEss) or M+Ess.)
>
> Note that the options on this are don't include / include transfers to or
> from asset or liability accounts / include transfers to or from accounts
> that aren't included in this report. If you just want to know your income
> less expenses, use the first, if you want different views of net cash flow,
> use the second (the default) or the third and play with which accounts are
> included.
>
> I agree you have to be very mindful of what this is actually showing to make
> sense of the bottom line.
>
> "mb" <mb@discussions.microsoft.com> wrote in message
> news:B1AC6718-9774-469F-945D-973F76F76518@microsoft.com...
> >I am confused by the Transfers at the end of the Income & Expenses report.
> > It seems to double count on the bottom line.
> >
> > If I purchase $1000 in stock from my savings, the transfer shows a -$1000
> > (negative because I have taken $1000 out of my cash and transfered it to
> > an
> > investment).
> >
> > If I sell that stock for $1500. My report shows $500 capital gain in
> > income, and a positive tranfers of $1500 (positive because I have
> > transfered
> > the money back into my cash). However these are added and thus shows a
> > positive $2000 on the bottom line. It doubled the bottom line impact of
> > the
> > capital gain.
> >
> > It does this with dividends to, A $100 dividend shows up as $100 of
> > income
> > and a positive $100 transfer - thus a $200 positive impact.
> >
> > Why does this report double these figures?
>
>
>

Tom_0127
Thu Aug 30 06:01:05 PDT 2007

I had a similar problem, and I did the following to fix it:

1) In "Rows & Columns" check "include transfers to or from asset or
liability accounts"

2) In "Accounts", your investment accounts should appear twice. It should
look like this:

Account Name __
Account Name (cash) __

You should have checks for all of your accounts, but clear the checks for
the (cash) accounts.

Tom


"mb" <mb@discussions.microsoft.com> wrote in message
news:811F2228-4AB3-4B25-A9F1-87255608E836@microsoft.com...
> Thank you for taking the time to respond. I did know the option to not
> include transfers, but I do want to include them. I ultimately want the
> report to show my income, less my expenses, less the money I transfer into
> investment accounts.
>
> Ideally I would like to see:
> 1) Investments sold and kept as cash to show as a positive transfer (it
> does
> this).
> 2) Investments purchased from cash to show as a negative transfer (it does
> this).
> 5) Income gained from an investment and reinvested to show as income
> gained,
> and then a negative transfer, for a net-zero gain on the bottom line.
> 4) Income (like a dividend) gained and kept as cash to show as either as
> income gained or a positive transfer - but not both, which effectively
> doubles the bottom line. I don't understand is why MS Money.
>
> Is there a different report (or upgrade) that will give me this cash flow
> analysis. I would think it would be a standard way of evaluating and
> managing ones budget?
>
> I am using MS Money 2005 Delux. I am tempted to see how Quicken handles
> this, but I have used MS Money religiously for 5 years and cringe at the
> thought of getting all that data transfered accurately).
>
>
>
> "Dick Watson" wrote:
>
>> It includes them because the customization is set to include them. You
>> can
>> clear that setting on the Rows & Columns tab. (Assuming M04 or earlier,
>> M05-M+ Advanced Reports and not Money Essentials (MEss) or M+Ess.)
>>
>> Note that the options on this are don't include / include transfers to or
>> from asset or liability accounts / include transfers to or from accounts
>> that aren't included in this report. If you just want to know your income
>> less expenses, use the first, if you want different views of net cash
>> flow,
>> use the second (the default) or the third and play with which accounts
>> are
>> included.
>>
>> I agree you have to be very mindful of what this is actually showing to
>> make
>> sense of the bottom line.
>>
>> "mb" <mb@discussions.microsoft.com> wrote in message
>> news:B1AC6718-9774-469F-945D-973F76F76518@microsoft.com...
>> >I am confused by the Transfers at the end of the Income & Expenses
>> >report.
>> > It seems to double count on the bottom line.
>> >
>> > If I purchase $1000 in stock from my savings, the transfer shows
>> > a -$1000
>> > (negative because I have taken $1000 out of my cash and transfered it
>> > to
>> > an
>> > investment).
>> >
>> > If I sell that stock for $1500. My report shows $500 capital gain in
>> > income, and a positive tranfers of $1500 (positive because I have
>> > transfered
>> > the money back into my cash). However these are added and thus shows a
>> > positive $2000 on the bottom line. It doubled the bottom line impact
>> > of
>> > the
>> > capital gain.
>> >
>> > It does this with dividends to, A $100 dividend shows up as $100 of
>> > income
>> > and a positive $100 transfer - thus a $200 positive impact.
>> >
>> > Why does this report double these figures?
>>
>>
>>

mb
Thu Aug 30 18:58:01 PDT 2007

Tom -

Thank you. You have solved my problem. I did not realize that by having
both the investment account and the corresponding cash account checked that I
would be double counting. I have found by having the cash account checked,
but not the investment account, gives me the report info I am looking for.
If I do the opposite, then I do not see the transfer of cash from budget into
new investments.
Thanks!!!!

"Tom_0127" wrote:

> I had a similar problem, and I did the following to fix it:
>
> 1) In "Rows & Columns" check "include transfers to or from asset or
> liability accounts"
>
> 2) In "Accounts", your investment accounts should appear twice. It should
> look like this:
>
> Account Name __
> Account Name (cash) __
>
> You should have checks for all of your accounts, but clear the checks for
> the (cash) accounts.
>
> Tom
>
>
> "mb" <mb@discussions.microsoft.com> wrote in message
> news:811F2228-4AB3-4B25-A9F1-87255608E836@microsoft.com...
> > Thank you for taking the time to respond. I did know the option to not
> > include transfers, but I do want to include them. I ultimately want the
> > report to show my income, less my expenses, less the money I transfer into
> > investment accounts.
> >
> > Ideally I would like to see:
> > 1) Investments sold and kept as cash to show as a positive transfer (it
> > does
> > this).
> > 2) Investments purchased from cash to show as a negative transfer (it does
> > this).
> > 5) Income gained from an investment and reinvested to show as income
> > gained,
> > and then a negative transfer, for a net-zero gain on the bottom line.
> > 4) Income (like a dividend) gained and kept as cash to show as either as
> > income gained or a positive transfer - but not both, which effectively
> > doubles the bottom line. I don't understand is why MS Money.
> >
> > Is there a different report (or upgrade) that will give me this cash flow
> > analysis. I would think it would be a standard way of evaluating and
> > managing ones budget?
> >
> > I am using MS Money 2005 Delux. I am tempted to see how Quicken handles
> > this, but I have used MS Money religiously for 5 years and cringe at the
> > thought of getting all that data transfered accurately).
> >
> >
> >
> > "Dick Watson" wrote:
> >
> >> It includes them because the customization is set to include them. You
> >> can
> >> clear that setting on the Rows & Columns tab. (Assuming M04 or earlier,
> >> M05-M+ Advanced Reports and not Money Essentials (MEss) or M+Ess.)
> >>
> >> Note that the options on this are don't include / include transfers to or
> >> from asset or liability accounts / include transfers to or from accounts
> >> that aren't included in this report. If you just want to know your income
> >> less expenses, use the first, if you want different views of net cash
> >> flow,
> >> use the second (the default) or the third and play with which accounts
> >> are
> >> included.
> >>
> >> I agree you have to be very mindful of what this is actually showing to
> >> make
> >> sense of the bottom line.
> >>
> >> "mb" <mb@discussions.microsoft.com> wrote in message
> >> news:B1AC6718-9774-469F-945D-973F76F76518@microsoft.com...
> >> >I am confused by the Transfers at the end of the Income & Expenses
> >> >report.
> >> > It seems to double count on the bottom line.
> >> >
> >> > If I purchase $1000 in stock from my savings, the transfer shows
> >> > a -$1000
> >> > (negative because I have taken $1000 out of my cash and transfered it
> >> > to
> >> > an
> >> > investment).
> >> >
> >> > If I sell that stock for $1500. My report shows $500 capital gain in
> >> > income, and a positive tranfers of $1500 (positive because I have
> >> > transfered
> >> > the money back into my cash). However these are added and thus shows a
> >> > positive $2000 on the bottom line. It doubled the bottom line impact
> >> > of
> >> > the
> >> > capital gain.
> >> >
> >> > It does this with dividends to, A $100 dividend shows up as $100 of
> >> > income
> >> > and a positive $100 transfer - thus a $200 positive impact.
> >> >
> >> > Why does this report double these figures?
> >>
> >>
> >>
>
>
>