|
#6
| |||
| |||
| I think I agree with you that, given the settings available, it should show up. If I use Customize | Details | Rows | Accounts, it--and other transfers do. I don't see ANY transfers to ANY accounts besides my Loan Account showing up if I use Customize | Details | Rows | Categories -- despite having all of the exact same settings elsewhere and the exact same accounts selected on the Accounts tab. Now, what to do about it? Well, my bet is that this got defined by some Money coder back in about Mv4 or M95 (the last time much of anything was done to improve Money reports even if that late). There may even have been some reason for this that, in their minds at the time, was "reasonable." (For instance, I can imagine some scenario like "well, if I report it as spending by category AND I report the transfer (as in, say, Transfer : Credit Card) won't I be showing more Spending + Transfer than there was Income? So, let's just show the Transfers to Loan Accounts in the By Category view." This could even have been before Investment Accounts ever existed. Who knows?) This is probably now viewed by the Money team as "as-designed" behavior. This is how they view most everything the rest of us would view, not unreasonably, as broken. One way to find out would be to open a support case and point out EXACTLY what customizations (start from Reset) get Investment Account transfers (and all others) to Show and then what ONE SETTING CHANGE (Customize | Details | Rows | Accounts --> Categories) leaves transfers to only the selected LOAN ACCOUNTS, BUT ELIMINATES TRANSFERS TO ALL OTHER **SELECTED** ACCOUNTS from the report. I'll bet you a cold brew of your choice the answer will come back "as designed". But I love to be pleasantly surprised and would gladly pay off on the brew--somehow. My suspicion is the best (non-)answer is to get your data out of Money into some better tool like Excel to do this kind of reporting. Sad it is this way, but... "Pete" <Pete[at]discussions.microsoft.com> wrote in message news:86530929-8D78-4886-924B-855EAB1129D0[at]microsoft.com... - quote - > Let me clarify again, I am trying for it to show up in the Income Vs. > Spending report. But not necessarily as an Expense. I am aware that it is > not > classified as an expense and as such it does not make sense to expect it > to > show up under expenses. > I have said before I am fine if it shows up as a Transfer (which is what > it > is), just like the mortgage principal transfer automatically shows up in > the > Income Vs. Spending report. |
|
#5
| |||
| |||
| "Steve" wrote: - quote - > =?Utf-8?B?UGV0ZQ==?= <Pete[at]discussions.microsoft.com> wrote on 10 Apr > 2008 in group microsoft.public.money: > > > > "Steve" wrote: > > > > =?Utf-8?B?UGV0ZQ==?= <Pete[at]discussions.microsoft.com> wrote on 03 > > > Apr 2008 in group microsoft.public.money: > > > > > > "Steve" wrote: > > > > > > > > =?Utf-8?B?UGV0ZQ==?= <Pete[at]discussions.microsoft.com> wrote on 02 > > > > > Apr 2008 in group microsoft.public.money: > > > > > > > > > > I enter all the details from my paycheck including the taxes > > > > > > and all pre-tax deductions including the 401K deduction, but > > > > > > when I look at the Income/spending report the transfer to the > > > > > > 401K account is no where to be found. In fact it does not show > > > > > > up on ANY reports in Money as it is considered a cash > > > > > > transaction. > > > > > > > > > > > I am finding that this anomaly is screwing up the > > > > > > income/spending report as it does not take in to account this > > > > > > money that is going to the 401K account as an expense and gives > > > > > > a wrong remainining balance amount which at times is really > > > > > > misleading. > > > > > > > > > > > One way I have explored I can fix this is by creating a new > > > > > > category for "Retirement" or "Investment" expenses and then log > > > > > > this under that category. But that way I cannot designate it to > > > > > > the 401K account which keeps track of the transfers. I do not > > > > > > track the ups and downs of the portfolio, just the raw dollar > > > > > > amount that is being transferred every paycheck. > > > > > > > > > > > Has anyone else ran in to this issue, and if so, how did you > > > > > > get around it? > > > > > > > > > You have to think like an accountant. Putting money in your > > > > > 401(k) is not an expense. You're just moving money that you > > > > > already have from one account to another. You're not any richer > > > > > or poorer after the transfer, so it's neither income nor expense. > > > > > It's just a transfer. > > > > > > > > > If you want to estimate the amount of money available for you to > > > > > spend, investigate the budgeting feature. > > > > I understand your point, but then shouldn't the transaction at > > > > least show up as a "Transfer"? Currently it is completely AWOL. > > > > > > > For example, I see that the mortgage principal show up as a > > > > transfer and I see that even though it is not an expense, it is > > > > deducted from the income (which is after deducting expenses from > > > > the total income minus the transfers = the net leftover balance) > > > > and is deducted from the balance. I could live with that if 401K > > > > transfers would show up alongwith the mortgage transfer, it just > > > > gives me a good idea on the true outlay. > > > > > > > Btw, I do use the budget feature but I prefer to see summary of > > > > inflow/outflow on a regular basis to keep me in check, it actually > > > > works even better for me. > > > > > Check the custom configuration on individual reports. Most of them > > > have an option to include or exclude transfers. Perhaps the report > > > you're using defaults to not showing transfers. There seems to be no > > > pattern to the defaults. > > > > > Once you have the settings the way you want them, you can save them > > > to the custom reports list. > > > I checked the report settings and each and every category that is > > available is checked. Basically "Check All" is what I did and > > rechecked all the boxes manually as well but it still does not show > > up in the report. > > > As I said earlier, the Mortgage principal transfer does show up in > > the income/spending report but not the 401K transfer. > > > Not sure what else to try. > My only remaining suggestion is to investigate a customized transaction > report. Perhaps you can configure it to show things the way you want > them. Your fundamental problem will continue, however, because you're > trying to get something which is not an expense to show up as an > expense. > -- > Steve B. > New Life Home Improvement Let me clarify again, I am trying for it to show up in the Income Vs. Spending report. But not necessarily as an Expense. I am aware that it is not classified as an expense and as such it does not make sense to expect it to show up under expenses. I have said before I am fine if it shows up as a Transfer (which is what it is), just like the mortgage principal transfer automatically shows up in the Income Vs. Spending report. Thanks |
|
#4
| |||
| |||
| =?Utf-8?B?UGV0ZQ==?= <Pete[at]discussions.microsoft.com> wrote on 10 Apr 2008 in group microsoft.public.money: - quote - > "Steve" wrote:
My only remaining suggestion is to investigate a customized transaction> > =?Utf-8?B?UGV0ZQ==?= <Pete[at]discussions.microsoft.com> wrote on 03 > > Apr 2008 in group microsoft.public.money: > > > > "Steve" wrote: > > > > > > =?Utf-8?B?UGV0ZQ==?= <Pete[at]discussions.microsoft.com> wrote on 02 > > > > Apr 2008 in group microsoft.public.money: > > > > > > > > I enter all the details from my paycheck including the taxes > > > > > and all pre-tax deductions including the 401K deduction, but > > > > > when I look at the Income/spending report the transfer to the > > > > > 401K account is no where to be found. In fact it does not show > > > > > up on ANY reports in Money as it is considered a cash > > > > > transaction. > > > > > > > > > I am finding that this anomaly is screwing up the > > > > > income/spending report as it does not take in to account this > > > > > money that is going to the 401K account as an expense and gives > > > > > a wrong remainining balance amount which at times is really > > > > > misleading. > > > > > > > > > One way I have explored I can fix this is by creating a new > > > > > category for "Retirement" or "Investment" expenses and then log > > > > > this under that category. But that way I cannot designate it to > > > > > the 401K account which keeps track of the transfers. I do not > > > > > track the ups and downs of the portfolio, just the raw dollar > > > > > amount that is being transferred every paycheck. > > > > > > > > > Has anyone else ran in to this issue, and if so, how did you > > > > > get around it? > > > > > > > You have to think like an accountant. Putting money in your > > > > 401(k) is not an expense. You're just moving money that you > > > > already have from one account to another. You're not any richer > > > > or poorer after the transfer, so it's neither income nor expense. > > > > It's just a transfer. > > > > > > > If you want to estimate the amount of money available for you to > > > > spend, investigate the budgeting feature. > > > I understand your point, but then shouldn't the transaction at > > > least show up as a "Transfer"? Currently it is completely AWOL. > > > > > For example, I see that the mortgage principal show up as a > > > transfer and I see that even though it is not an expense, it is > > > deducted from the income (which is after deducting expenses from > > > the total income minus the transfers = the net leftover balance) > > > and is deducted from the balance. I could live with that if 401K > > > transfers would show up alongwith the mortgage transfer, it just > > > gives me a good idea on the true outlay. > > > > > Btw, I do use the budget feature but I prefer to see summary of > > > inflow/outflow on a regular basis to keep me in check, it actually > > > works even better for me. > > > Check the custom configuration on individual reports. Most of them > > have an option to include or exclude transfers. Perhaps the report > > you're using defaults to not showing transfers. There seems to be no > > pattern to the defaults. > > > Once you have the settings the way you want them, you can save them > > to the custom reports list. > I checked the report settings and each and every category that is > available is checked. Basically "Check All" is what I did and > rechecked all the boxes manually as well but it still does not show > up in the report. > As I said earlier, the Mortgage principal transfer does show up in > the income/spending report but not the 401K transfer. > Not sure what else to try. report. Perhaps you can configure it to show things the way you want them. Your fundamental problem will continue, however, because you're trying to get something which is not an expense to show up as an expense. -- Steve B. New Life Home Improvement |
|
#3
| |||
| |||
| "Steve" wrote: - quote - > =?Utf-8?B?UGV0ZQ==?= <Pete[at]discussions.microsoft.com> wrote on 03 Apr > 2008 in group microsoft.public.money: > > "Steve" wrote: > > > > =?Utf-8?B?UGV0ZQ==?= <Pete[at]discussions.microsoft.com> wrote on 02 > > > Apr 2008 in group microsoft.public.money: > > > > > > I enter all the details from my paycheck including the taxes and > > > > all pre-tax deductions including the 401K deduction, but when I > > > > look at the Income/spending report the transfer to the 401K > > > > account is no where to be found. In fact it does not show up on > > > > ANY reports in Money as it is considered a cash transaction. > > > > > > > I am finding that this anomaly is screwing up the income/spending > > > > report as it does not take in to account this money that is going > > > > to the 401K account as an expense and gives a wrong remainining > > > > balance amount which at times is really misleading. > > > > > > > One way I have explored I can fix this is by creating a new > > > > category for "Retirement" or "Investment" expenses and then log > > > > this under that category. But that way I cannot designate it to > > > > the 401K account which keeps track of the transfers. I do not > > > > track the ups and downs of the portfolio, just the raw dollar > > > > amount that is being transferred every paycheck. > > > > > > > Has anyone else ran in to this issue, and if so, how did you get > > > > around it? > > > > > You have to think like an accountant. Putting money in your 401(k) > > > is not an expense. You're just moving money that you already have > > > from one account to another. You're not any richer or poorer after > > > the transfer, so it's neither income nor expense. It's just a > > > transfer. > > > > > If you want to estimate the amount of money available for you to > > > spend, investigate the budgeting feature. > > I understand your point, but then shouldn't the transaction at least > > show up as a "Transfer"? Currently it is completely AWOL. > > > For example, I see that the mortgage principal show up as a transfer > > and I see that even though it is not an expense, it is deducted from > > the income (which is after deducting expenses from the total income > > minus the transfers = the net leftover balance) and is deducted from > > the balance. I could live with that if 401K transfers would show up > > alongwith the mortgage transfer, it just gives me a good idea on the > > true outlay. > > > Btw, I do use the budget feature but I prefer to see summary of > > inflow/outflow on a regular basis to keep me in check, it actually > > works even better for me. > Check the custom configuration on individual reports. Most of them have > an option to include or exclude transfers. Perhaps the report you're > using defaults to not showing transfers. There seems to be no pattern to > the defaults. > Once you have the settings the way you want them, you can save them to > the custom reports list. > -- > Steve B. > New Life Home Improvement I checked the report settings and each and every category that is available is checked. Basically "Check All" is what I did and rechecked all the boxes manually as well but it still does not show up in the report. As I said earlier, the Mortgage principal transfer does show up in the income/spending report but not the 401K transfer. Not sure what else to try. Thanks |
|
#2
| |||
| |||
| =?Utf-8?B?UGV0ZQ==?= <Pete[at]discussions.microsoft.com> wrote on 03 Apr 2008 in group microsoft.public.money: - quote - > "Steve" wrote:
Check the custom configuration on individual reports. Most of them have> > =?Utf-8?B?UGV0ZQ==?= <Pete[at]discussions.microsoft.com> wrote on 02 > > Apr 2008 in group microsoft.public.money: > > > > I enter all the details from my paycheck including the taxes and > > > all pre-tax deductions including the 401K deduction, but when I > > > look at the Income/spending report the transfer to the 401K > > > account is no where to be found. In fact it does not show up on > > > ANY reports in Money as it is considered a cash transaction. > > > > > I am finding that this anomaly is screwing up the income/spending > > > report as it does not take in to account this money that is going > > > to the 401K account as an expense and gives a wrong remainining > > > balance amount which at times is really misleading. > > > > > One way I have explored I can fix this is by creating a new > > > category for "Retirement" or "Investment" expenses and then log > > > this under that category. But that way I cannot designate it to > > > the 401K account which keeps track of the transfers. I do not > > > track the ups and downs of the portfolio, just the raw dollar > > > amount that is being transferred every paycheck. > > > > > Has anyone else ran in to this issue, and if so, how did you get > > > around it? > > > You have to think like an accountant. Putting money in your 401(k) > > is not an expense. You're just moving money that you already have > > from one account to another. You're not any richer or poorer after > > the transfer, so it's neither income nor expense. It's just a > > transfer. > > > If you want to estimate the amount of money available for you to > > spend, investigate the budgeting feature. > I understand your point, but then shouldn't the transaction at least > show up as a "Transfer"? Currently it is completely AWOL. > For example, I see that the mortgage principal show up as a transfer > and I see that even though it is not an expense, it is deducted from > the income (which is after deducting expenses from the total income > minus the transfers = the net leftover balance) and is deducted from > the balance. I could live with that if 401K transfers would show up > alongwith the mortgage transfer, it just gives me a good idea on the > true outlay. > Btw, I do use the budget feature but I prefer to see summary of > inflow/outflow on a regular basis to keep me in check, it actually > works even better for me. an option to include or exclude transfers. Perhaps the report you're using defaults to not showing transfers. There seems to be no pattern to the defaults. Once you have the settings the way you want them, you can save them to the custom reports list. -- Steve B. New Life Home Improvement |
|
#1
| |||
| |||
| I understand your point, but then shouldn't the transaction at least show up as a "Transfer"? Currently it is completely AWOL. For example, I see that the mortgage principal show up as a transfer and I see that even though it is not an expense, it is deducted from the income (which is after deducting expenses from the total income minus the transfers = the net leftover balance) and is deducted from the balance. I could live with that if 401K transfers would show up alongwith the mortgage transfer, it just gives me a good idea on the true outlay. Btw, I do use the budget feature but I prefer to see summary of inflow/outflow on a regular basis to keep me in check, it actually works even better for me. Thanks "Steve" wrote: - quote - > =?Utf-8?B?UGV0ZQ==?= <Pete[at]discussions.microsoft.com> wrote on 02 Apr > 2008 in group microsoft.public.money: > > I enter all the details from my paycheck including the taxes and all > > pre-tax deductions including the 401K deduction, but when I look at > > the Income/spending report the transfer to the 401K account is no > > where to be found. In fact it does not show up on ANY reports in > > Money as it is considered a cash transaction. > > > I am finding that this anomaly is screwing up the income/spending > > report as it does not take in to account this money that is going to > > the 401K account as an expense and gives a wrong remainining balance > > amount which at times is really misleading. > > > One way I have explored I can fix this is by creating a new category > > for "Retirement" or "Investment" expenses and then log this under > > that category. But that way I cannot designate it to the 401K account > > which keeps track of the transfers. I do not track the ups and downs > > of the portfolio, just the raw dollar amount that is being > > transferred every paycheck. > > > Has anyone else ran in to this issue, and if so, how did you get > > around it? > You have to think like an accountant. Putting money in your 401(k) is > not an expense. You're just moving money that you already have from one > account to another. You're not any richer or poorer after the transfer, > so it's neither income nor expense. It's just a transfer. > If you want to estimate the amount of money available for you to spend, > investigate the budgeting feature. > -- > Steve B. > New Life Home Improvement |
| | |||
| |||
| =?Utf-8?B?UGV0ZQ==?= <Pete[at]discussions.microsoft.com> wrote on 02 Apr 2008 in group microsoft.public.money: - quote - > I enter all the details from my paycheck including the taxes and all
You have to think like an accountant. Putting money in your 401(k) is> pre-tax deductions including the 401K deduction, but when I look at > the Income/spending report the transfer to the 401K account is no > where to be found. In fact it does not show up on ANY reports in > Money as it is considered a cash transaction. > I am finding that this anomaly is screwing up the income/spending > report as it does not take in to account this money that is going to > the 401K account as an expense and gives a wrong remainining balance > amount which at times is really misleading. > One way I have explored I can fix this is by creating a new category > for "Retirement" or "Investment" expenses and then log this under > that category. But that way I cannot designate it to the 401K account > which keeps track of the transfers. I do not track the ups and downs > of the portfolio, just the raw dollar amount that is being > transferred every paycheck. > Has anyone else ran in to this issue, and if so, how did you get > around it? not an expense. You're just moving money that you already have from one account to another. You're not any richer or poorer after the transfer, so it's neither income nor expense. It's just a transfer. If you want to estimate the amount of money available for you to spend, investigate the budgeting feature. -- Steve B. New Life Home Improvement |
|
#-1
| |||
| |||
| I enter all the details from my paycheck including the taxes and all pre-tax deductions including the 401K deduction, but when I look at the Income/spending report the transfer to the 401K account is no where to be found. In fact it does not show up on ANY reports in Money as it is considered a cash transaction. I am finding that this anomaly is screwing up the income/spending report as it does not take in to account this money that is going to the 401K account as an expense and gives a wrong remainining balance amount which at times is really misleading. One way I have explored I can fix this is by creating a new category for "Retirement" or "Investment" expenses and then log this under that category. But that way I cannot designate it to the 401K account which keeps track of the transfers. I do not track the ups and downs of the portfolio, just the raw dollar amount that is being transferred every paycheck. Has anyone else ran in to this issue, and if so, how did you get around it? |
| Tags |
| 401k, income or spending, report, show, transfers |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Transfers appear in Spending by Category? stephanie: How do I prevent account to account transfers from appearing in the Spending by Category in Money Plus Premium. I have put the transfers in the... | Microsoft Money | 1 | 01-01-2008 11:26 AM | |
| Services Income does not show up on Profit & Loss Report Jazflux: Problem: Service Income I have received and classified as 'Payment for Invoice' in my Business Checking register does not show up as Service Income... | Microsoft Money | 1 | 02-03-2007 10:07 PM | |
| "Transfers" in Income & Spending Reports (How to reclassify?) Dennis: Money 2005 Small Business The principal amount of my car loan payments for 2005 equals $3,844.01 In the Reports it under the Transfers report... | Microsoft Money | 1 | 12-31-2005 05:41 PM | |
| How do I get 401k transfers from my paycheck to show in the budget T-Shirt: If anyone can help here, I'd greatly appreciate it. I use the Money 2006 advanced budget, and in each of my paychecks, I contribute to a 401k. My... | Microsoft Money | 1 | 12-18-2005 10:35 PM | |
| Thread Tools | |
| Display Modes | |
| |