Payee Matching using Memo Field?


P

pete

Note sure if this is specific to BofA, or if I'm just
missing something.I am using MS Money Deluxe 2004, but
also had same prob with 2000

When I download ofx (problems with qif also) statements
the Payee or <name> is truncated to 32 char which
normally I wouldnt care since money only allows 32 char
in the payee feild. Problem is my transactions in the OFX
are like this:

<NAME>INTERLINK NETWORK TRANS ****** O
<MEMO>INTERLINK NETWORK TRANS ****** ON 07-03
CUSTOMER ******** PAYMENT TO ACME

Is it possible to auto match Payees using the info from
the memo feild? Right now any debit purchase shows up as
INTERLINK NETWORK TRANS and I have to modify the payee
every friggen time.

Thanks in advance from any help.
 
Ad

Advertisements

C

Cal Learner-- MVP

Note sure if this is specific to BofA, or if I'm just
missing something.I am using MS Money Deluxe 2004, but
also had same prob with 2000

When I download ofx (problems with qif also) statements
the Payee or <name> is truncated to 32 char which
normally I wouldnt care since money only allows 32 char
in the payee feild. Problem is my transactions in the OFX
are like this:

<NAME>INTERLINK NETWORK TRANS ****** O
<MEMO>INTERLINK NETWORK TRANS ****** ON 07-03
CUSTOMER ******** PAYMENT TO ACME

Is it possible to auto match Payees using the info from
the memo feild?
No. You can make INTERLINK NETWORK TRANS and O excluded Names with
Accounts&Bills->Categories&Payees->Payees->PreferredPayeeNames->GoToPayeeRulesManager.
That 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. Unfortunately there are no wildcards, so check
334, check 335, and check 336 will each be treated as potential new
payee names. Tools->Options->OnlineServices->ReplacePayeeNames
should be the solution to that.

Right now any debit purchase shows up as
INTERLINK NETWORK TRANS and I have to modify the payee
every friggen time.
You may want to set
Tools->Options->OnlineServices->AddADesctriptionToTheMemoField
That won't match as a Payee, but it will let you see the Memo for
manually selecting the proper payee.
 

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