Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 10-02-2006, 02:34 PM
William R Wood
Guest
 
Posts: n/a
Default Re: MsM2003 payee/memo confusion

As Cal said this is a real problem but the fault lies with your bank.

If my bank/credit card company put the payee name in the memo field on
downloads instead of in the payee field, I would complain to the bank. If
they did not fix that in a reasonabIe time, would cancel the acct/card and
get a better one. I have had fair success getting banks to change their
ways by closing accounts. Putting up with poor service will get you more
poor service.

Regards

Bill Wood



"msxl1" <msxl1[at]discussions.microsoft.com> wrote in message
news:1EEB40E6-B0DF-4346-B3E6-7B269A2AC7DE[at]microsoft.com...
- quote -

> I'm a new user of MsM2003 . My bank supports download of statements in
> .qif,
> .ofx, and .csv format. I've downloaded the .ofx statement and imported to
> MsM2003 . The problem is the that the bank puts some 'real useful' info
> like
> "DDA PUR 0002S052" in the payee field and the actual payee info (or closer
> to
> it) in the memo field. A .qif export of the account shows that a typical
> debit transaction looks like this :
> Date Amount Cleared Status Payee Memo
> 8/28/2006 -3.56 * DDA PUR 0002S052 CIRCLE K #06319 DALLAS TX
> 624000961150
> So, I'm thinking that I'll have to manually associate each transaction
> (based on the memo field) with a category because MsM wants to use the
> payee
> field which doesn't have useful payee info.
> Am I correct in my understanding about this being a problem or is there
> some
> clever way that MsM can use the memo field to match real payees for future
> statement imports ?
> Thanks








 
Old 10-02-2006, 04:27 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: MsM2003 payee/memo confusion

In microsoft.public.money, msxl1 wrote:

- quote -

> I'm a new user of MsM2003 . My bank supports download of statements in .qif,
> .ofx, and .csv format. I've downloaded the .ofx statement and imported to
> MsM2003 . The problem is the that the bank puts some 'real useful' info like
> "DDA PUR 0002S052" in the payee field and the actual payee info (or closer to
> it) in the memo field. A .qif export of the account shows that a typical
> debit transaction looks like this :
> Date Amount Cleared Status Payee Memo
> 8/28/2006 -3.56 * DDA PUR 0002S052 CIRCLE K #06319 DALLAS TX
> 624000961150
> So, I'm thinking that I'll have to manually associate each transaction
> (based on the memo field) with a category because MsM wants to use the payee
> field which doesn't have useful payee info.


You should change the Payee to "Circle K", or whatever you want to
use before accepting the transaction. Money will key off of that
payee, but you will have to select the Payee.


- quote -

> Am I correct in my understanding about this being a problem or is there some
> clever way that MsM can use the memo field to match real payees for future
> statement imports ?


The former.
  #-1  
Old 10-02-2006, 03:40 AM
msxl1
Guest
 
Posts: n/a
Default MsM2003 payee/memo confusion

I'm a new user of MsM2003 . My bank supports download of statements in .qif,
..ofx, and .csv format. I've downloaded the .ofx statement and imported to
MsM2003 . The problem is the that the bank puts some 'real useful' info like
"DDA PUR 0002S052" in the payee field and the actual payee info (or closer to
it) in the memo field. A .qif export of the account shows that a typical
debit transaction looks like this :

Date Amount Cleared Status Payee Memo
8/28/2006 -3.56 * DDA PUR 0002S052 CIRCLE K #06319 DALLAS TX
624000961150

So, I'm thinking that I'll have to manually associate each transaction
(based on the memo field) with a category because MsM wants to use the payee
field which doesn't have useful payee info.

Am I correct in my understanding about this being a problem or is there some
clever way that MsM can use the memo field to match real payees for future
statement imports ?

Thanks


 

Tags
confusion, msm2003, payee or memo
Similar Threads
Thread Forum Replies Last Post
Payee and Memo
Joe: When I download my bank statement, it places important information I need to ditinguish payees into the memo filed. Is there any way to prevent...
Microsoft Money 3 01-21-2005 12:12 AM
assign payee by memo
jmoeller18: My gas and electric are from different companies. when i import via the us bank ofx file, both the gas and electric auto-pay charges from my...
Microsoft Money 4 12-28-2004 11:32 AM
Payee Matching using Memo Field?
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...
Microsoft Money 1 07-08-2004 08:16 AM
memo/payee fields
russ: Even though my wife's employer's name is listed in the 'memo' field for a downloaded transaction, money insists on auto-filling the 'from' field...
Microsoft Money 1 06-04-2004 03:05 AM
Payee & Memo Reversed on Downloaded QIF
Jeff: 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....
Microsoft Money 3 11-11-2003 04:01 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 07:05 PM.