Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
 
Old 09-19-2003, 01:49 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: American Express QIF format changed (Canada)?

In microsoft.public.money, Peter wrote:

- quote -

> Something has recently changed that is not allowing me to import
> American Express QIF statements anymore (from Canada). I know that
> there are problems with date formats in QIF files and that it must
> match your regional settings, but I am also having a problem where
> items that should be "charges" are showing up as "credits". My money
> account is set to account type "credit", and an example QIF file looks
> like this:
> !Type:CCard
> D04/09/03
> N320032500380202050
> T50.0
> POUTBACK STEAKHOUSE #OAKVILLE ON
> M09046776
> ^
> This item shows up as a credit. Playing more with it and placing a
> -ve sign in front of the 50 turned it into a charge.


The charge should certainly be a negative number.

- quote -

> Not to mention I
> want to operate with a MM/DD/YYYY date format and this is using
> DD/MM/YYYY.


One possibility is to run a little utility to modify the .qif file
before you import it. Another workaround is to switch your computer
to mm/dd import and process your .qif, and then switch it back. You
might want to experiment using a copy of your Money file.

The good thing would be to find that AMEX Canada supports OFX, but I
don't know about that.


- quote -

> This was all working 3 weeks ago. Any idea what may have changed (I
> think I re-connected to passport, could this have done something?)


I don't see that passport is remotely involved in this case.

  #-1  
Old 09-18-2003, 05:14 PM
Peter
Guest
 
Posts: n/a
Default American Express QIF format changed (Canada)?

Something has recently changed that is not allowing me to import
American Express QIF statements anymore (from Canada). I know that
there are problems with date formats in QIF files and that it must
match your regional settings, but I am also having a problem where
items that should be "charges" are showing up as "credits". My money
account is set to account type "credit", and an example QIF file looks
like this:

!Type:CCard
D04/09/03
N320032500380202050
T50.0
POUTBACK STEAKHOUSE #OAKVILLE ON
M09046776
^

This item shows up as a credit. Playing more with it and placing a
-ve sign in front of the 50 turned it into a charge. Not to mention I
want to operate with a MM/DD/YYYY date format and this is using
DD/MM/YYYY.

This was all working 3 weeks ago. Any idea what may have changed (I
think I re-connected to passport, could this have done something?)

Thanks

Peter
 

Tags
american, canada, changed, express, format, qif
Similar Threads
Thread Forum Replies Last Post
Money 2004 for Canada
Ray St-Sauveur: Money 2004 has just come out in Canada. As other years only the Standard version is brought out here. I am a Quicken user but anxious to get away...
Microsoft Money 2 07-29-2003 02:41 PM
money express question
Megabyte: How can I get money express to update my accounts online? I'm running Money2002. TIA -Megabyte
Microsoft Money 1 07-07-2003 12:26 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 11:45 PM.