401K Transfers don't show up in Income/Spending Report


P

Pete

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?
 
Ad

Advertisements

S

Steve

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.
 
P

Pete

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
 
S

Steve

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.
 
P

Pete

Steve said:
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.

Thanks
 
S

Steve

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.
 
Ad

Advertisements

P

Pete

Steve said:
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.

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
 
Ad

Advertisements

D

Dick Watson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top