Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #2  
Old 01-17-2007, 12:12 PM
Mark Horn
Guest
 
Posts: n/a
Default Re: Importing qif file, is this something I am going to have to live with

On 2007-01-15, bdeditch <bdeditch[at]gmail.com> wrote:
- quote -

> Is there any way of not having to accept every transaction, when I
> download the qif file from Bank of the West. Why can't it just show the
> new ones?? Running Money 2007


What I hear you saying is that when you download transactions A,B&C
today, you have to accept them. Then tomorrow, when you download
A,B,C,D&E, you have accept A through E. Which means you had to
accept A,B&C twice.

If that's the case, then the reason is that you're using QIF.
If you have the option try downloading OFX instead of QIF.

QIF is a pretty old mechanism for downloading transactions.
It does not have any facility for uniquely identifying transactions.
However, OFX has a facility which allows the bank to assign unique
transaction IDs to every single transaction. Money recognizes
these IDs, so that when it see's transaction A,B&C again, it knows
that they're not new transactions but already accepted transactions,
and it doesn't prompt you to accept transactions that you've already
accepted. Unfortuately, because QIF doesn't uniquely identify all
transactions, Money doesn't know if A,B&C are the transactions from
yesterday or entirely brand new transactions that just happen to
have the same payee, date, and amount as the ones from yesterday.
It thinks that it probably is the same transaction so it attempts
to match them, but it can't be certain so it has to ask.
When Money uses OFX, this ambiguity disappears.

Bottom line: if you can use OFX instead of QIF, you'll avoid this
problem.
  #1  
Old 01-16-2007, 12:18 PM
bdeditch
Guest
 
Posts: n/a
Default Re: Importing qif file, is this something I am going to have to live with


Cal Learner-- MVP wrote:
- quote -

> Do you mean that there are identical transactions that are not being
> properly matched to existing transactions?


I had this problem as well for a while, it just stopped, don't know
what I did to get that problem solved

 
Old 01-16-2007, 02:50 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Importing qif file, is this something I am going to have to live with

In microsoft.public.money, bdeditch wrote:

- quote -

> Is there any way of not having to accept every transaction, when I
> download the qif file from Bank of the West.


ReconcileTransactions-> AcceptAllTransactions.

- quote -

> Why can't it just show the
> new ones?? Running Money 2007



Do you mean that there are identical transactions that are not being
properly matched to existing transactions? There is not a choice to
automatically accept only the matched transactions, tho there is the
opposite choice available.
  #-1  
Old 01-16-2007, 02:02 AM
bdeditch
Guest
 
Posts: n/a
Default Importing qif file, is this something I am going to have to live with

Is there any way of not having to accept every transaction, when I
download the qif file from Bank of the West. Why can't it just show the
new ones?? Running Money 2007

 

Tags
file, importing, live, qif
Similar Threads
Thread Forum Replies Last Post
Sharing Money file with Windows Live ID
David B: I'm working in a small office environment where we'd like to set up Money for sharing a single data file; BUT I am leary of using Windows Live ID...
Microsoft Money 1 09-01-2006 06:22 PM
Importing a QIF file - category is ignored
Gremlin: Trying to do a bulk import into MS Money, but although it successfully imports the data, it ignores the category information. QIF format is: ...
Microsoft Money 11 07-26-2006 03:28 AM
importing and ofx file into Excel
HSalim[MVP]: Hi all How can i import the statement file i download from my bank into excel? I don't use MSMoney or Quicken so I just want to convert the file...
Microsoft Money 1 12-19-2005 04:27 PM
Importing an Old Money File
Bill G.: I had a system crash yesterday and all I could recover was the "My Money.mny" file - created in Money 2003. Is this where my data resides? Can I...
Microsoft Money 6 10-17-2005 05: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 10:40 PM.