|
#3
| |||
| |||
| 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: - quote - > 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[at]discussions.microsoft.com> wrote in message > news:811F2228-4AB3-4B25-A9F1-87255608E836[at]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[at]discussions.microsoft.com> wrote in message > > > news:B1AC6718-9774-469F-945D-973F76F76518[at]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? > > > > > > |
|
#2
| |||
| |||
| 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[at]discussions.microsoft.com> wrote in message news:811F2228-4AB3-4B25-A9F1-87255608E836[at]microsoft.com... - quote - > 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[at]discussions.microsoft.com> wrote in message > > news:B1AC6718-9774-469F-945D-973F76F76518[at]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? > > > |
|
#1
| |||
| |||
| 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: - quote - > 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[at]discussions.microsoft.com> wrote in message > news:B1AC6718-9774-469F-945D-973F76F76518[at]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? |
| | |||
| |||
| 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[at]discussions.microsoft.com> wrote in message news:B1AC6718-9774-469F-945D-973F76F76518[at]microsoft.com... - quote - > 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? |
|
#-1
| |||
| |||
| 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? |
| Tags |
| expenses, income, report |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Error on Monthly Income & Expenses Report sharpe@interalpha.co.uk: I am using Money Ver 14.0120.1105 In Reports, Monthly Income & Expenses under the heading of Monthly Cash Flow, there is a warning sign that says... | Microsoft Money | 1 | 10-20-2005 12:12 AM | |
| Trade income and losses in Monthly Income and Expenses jerrydy: Is there any way I can get the "Monthly Income and Expenses" report show the income (and loss) I make trading stocks? | Microsoft Money | 5 | 05-17-2005 05:27 PM | |
| Money 2003 Monthly Income & Expenses Report Deluxe edition Plops_dad: Is wrong. At least mine is. Any help PLEASE. What im finding is my credit card payments are not showing up, not taken into account... | Microsoft Money | 2 | 10-06-2004 01:25 PM | |
| Thread Tools | |
| Display Modes | |
| |