Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
 
Old 10-18-2004, 06:00 PM
dordale
Guest
 
Posts: n/a
Default Re: unique problem importing qif statements


"Tim" <Tim[at]discussions.microsoft.com> wrote in message
news:24ED8CE1-1131-4C0D-BFE2-4FB90FD4AF61[at]microsoft.com...
- quote -

> I'm having a problem that no one else seems to have addressed in this
> forum.
> I use my CheckCard as a debit card when I can, but many stores only
> support
> credit card transactions. For all the credit card transactions, Money
> truncates the text for the transaction in the qif file, so that for each
> entry it only gets through the first 15 characters or so. In my bank's
> system, that only contains the date and "EFT TRANS"-- nothing about the
> vendor. So when I import I get a statement that looks like this:
> EFT TRANS 10102004
> EFT TRANS 10102004
> EFT TRANS 10102004
> EFT TRANS 10102004
> The vendor names all come after the date but Money never sees this.
> Debit card transactions work fine because the vendor name is listed first.
> Is there a way to fix this so I don't have to go through and change the
> vendor name for each credit card transaction?
> Thanks to whomever replies.

Tim--

This is based on the way your bank writes the information to the qif file.
Contact your bank and let them know you are having a problem.

You can also download your file before importing it into Money and open it
with a text editor. You could then use search and replace to delete the
"EFT TRANS" from the beginning of the transaction before importing it into
Money.

Hope this helps!
dordale


  #-1  
Old 10-15-2004, 11:57 PM
Tim
Guest
 
Posts: n/a
Default unique problem importing qif statements

I'm having a problem that no one else seems to have addressed in this forum.

I use my CheckCard as a debit card when I can, but many stores only support
credit card transactions. For all the credit card transactions, Money
truncates the text for the transaction in the qif file, so that for each
entry it only gets through the first 15 characters or so. In my bank's
system, that only contains the date and "EFT TRANS"-- nothing about the
vendor. So when I import I get a statement that looks like this:

EFT TRANS 10102004
EFT TRANS 10102004
EFT TRANS 10102004
EFT TRANS 10102004

The vendor names all come after the date but Money never sees this.

Debit card transactions work fine because the vendor name is listed first.
Is there a way to fix this so I don't have to go through and change the
vendor name for each credit card transaction?

Thanks to whomever replies.


 

Tags
importing, problem, qif, statements, unique
Similar Threads
Thread Forum Replies Last Post
importing statements
teresa: I'm getting an error when trying to import my bank statement. It reads "A transaction in the QIF file has a date that could not be resolved and...
Microsoft Money 3 08-06-2004 12:01 AM
Importing statements from my bank doubles up
Fuji: Hi there, When I use my bank's online banking I have the option to download the statement in Money format, then the next time I start Money it...
Microsoft Money 2 08-03-2003 03:45 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 12:33 AM.