Payee & Memo Reversed on Downloaded QIF

Hello,

My credit union allows me to download my statements as QIF files. However,
when I import these into Microsoft Money they are a total mess. The Payee
line is always generic, such as "Deposit/Payment" or "ATM/CK Card Withdraw".
When I begin to correct these entries, Money tries to fix it for all of the
similar supposed payees, which is highly annoying as I can end up with
dozens of transactions that it automatically guesses to be the wrong payee.

The thing that really upsets me though is that the Credit Union also
provides true payee information such as "Wal-Mart Super Center" or "Home
Depot", etc. Or, they'll place the street address of the ATM machine that I
used for cash withdraws. However, this information is not where it belongs.
The credit union is filling in payee names in the Memo field. What good is
it in the memo field? I want it in the Payee field so that Microsoft Money
will stop treating all of my deposits as though they were the same payee and
all the debits as the same payee and all the checks as the same payee and so
on.

Surely there must be some way to reverse the Memo and Payee fields from a
downloaded QIF before Money fills it into the register. Does anybody know
how to do this?!


Thanks in advance,

Jeff Phillips

via_newsgroup
Mon Nov 10 23:26:02 CST 2003

In microsoft.public.money, Jeff wrote:

>
>My credit union allows me to download my statements as QIF files. However,
>when I import these into Microsoft Money they are a total mess. The Payee
>line is always generic, such as "Deposit/Payment" or "ATM/CK Card Withdraw".
>When I begin to correct these entries, Money tries to fix it for all of the
>similar supposed payees, which is highly annoying as I can end up with
>dozens of transactions that it automatically guesses to be the wrong payee.
>
>The thing that really upsets me though is that the Credit Union also
>provides true payee information such as "Wal-Mart Super Center" or "Home
>Depot", etc. Or, they'll place the street address of the ATM machine that I
>used for cash withdraws. However, this information is not where it belongs.
>The credit union is filling in payee names in the Memo field. What good is
>it in the memo field? I want it in the Payee field so that Microsoft Money
>will stop treating all of my deposits as though they were the same payee and
>all the debits as the same payee and all the checks as the same payee and so
>on.

Go to
Accounts&Bills->Categories&Payees->Payees->GotoPayeeRulesManager

Excluded Payee Names identifies words and phrases that should be
ignored from the payee field (e.g., check, deposit). Add words
that are generically added by your bank.


>
>Surely there must be some way to reverse the Memo and Payee fields from a
>downloaded QIF before Money fills it into the register. Does anybody know
>how to do this?!

That is a complex operation that you would need some programming and
continuing effort to handle. It is too bad your bank does not put
the payee into the Payee field, but they are not unique in that.

Jeff
Tue Nov 11 06:10:44 CST 2003

Thanks for the tip! Getting Money to stop trying to automatically screw me
up is a big help!

Actually, if someone hasn't already done so maybe I'll consider writeing a
program to reverse the payee & memo fields in the QIFs. I just simply don't
understand why the stupid bank insists on having it in such a rediculus
order. I also highly hate their way of using the "check number" field for
whatever crap they feel like throwing at me when I didn't actually write a
check. For example, I get a lot of "POS00012345" entries in my check number
field. You and me both know what "P.O.S." stands for, and I'm not going to
believe them when they say it's Point of Sale.

-Jeff


"Cal Learner-- MVP" <via_newsgroup@please.tnx> wrote in message
news:j3s0rvobf8lvpbupp9732dd5lhb2s4mvuo@4ax.com...
>
> Go to
> Accounts&Bills->Categories&Payees->Payees->GotoPayeeRulesManager
>
> Excluded Payee Names identifies words and phrases that should be
> ignored from the payee field (e.g., check, deposit). Add words
> that are generically added by your bank.
>
> >
> >Surely there must be some way to reverse the Memo and Payee fields from a
> >downloaded QIF before Money fills it into the register. Does anybody know
> >how to do this?!
>
> That is a complex operation that you would need some programming and
> continuing effort to handle. It is too bad your bank does not put
> the payee into the Payee field, but they are not unique in that.
>
>
>

via_newsgroup
Tue Nov 11 11:01:21 CST 2003

In microsoft.public.money, Jeff wrote:

>
>
>Actually, if someone hasn't already done so maybe I'll consider writeing a
>program to reverse the payee & memo fields in the QIFs. I just simply don't
>understand why the stupid bank insists on having it in such a rediculus
>order.

What I can envision, but do not know how to implement, would be an
application that would be set up as the QIF type manager. It would
massage the data and -- here is the part that seems trickiest-- send
the massaged data on to mnyimprt.exe.