Qif import from bank creates multiple duplicates

[David Reiser]

The only solution I've found is where the 'sending' organization/application allows you to either specify "only send transactions that have never been sent before" or manually setting a start date for an export set (after looking at the last matched transaction in my gnucash data).

Not a whole lot of help...

You could ask the bank to provide Quicken/Money/QFX/OFX files. If they get enough requests, they might add the format.

Dave
On Apr 12, 2010, at 4:45 PM, Maripat Voellmecke wrote:

> Thanks so much, Dave. Is there anything I can do for this annoying problem? Does everyone else experience this too? 
> Maripat
> 
> > Date: Mon, 12 Apr 2010 15:39:30 -0400
> > From: dbreiser at earthlink.net
> > To: maripatv at hotmail.com
> > CC: gnucash-user at gnucash.org
> > Subject: Re: Qif import from bank creates multiple duplicates
> > 
> > On 4/12/2010 9:33 AM, maripat wrote:
> > >
> > > I am getting 30+ duplicates that I have to check off at every qif download.
> > > If I miss even one, my checkbook balance is off and it takes forever to
> > > track it down. I am not a programmer. I had similar issues with MoneyDance,
> > > so I switched to GnuCash. My primary bank does not offer OFX importing, but
> > > when I use OFX with a bank where I have a second checking account, this
> > > doesn't happen. Is it me? Is it the bank? Can anyone help? I am a former
> > > MsMoney user, but have started with a fresh GnuCash account on Jan 1.
> > 
> > OFX transactions include a unique transaction ID, so software can 
> > automatically eliminate duplicate imported transactions. QIF does not 
> > have any provision for a transaction identifier. Many banks send the 
> > last 30 days of transactions every time you click the button to download 
> > transactions, including any duplicates within the moving 30 day window.
> > 
> > So really it isn't you or the bank, it's QIF.
> > 
> > Dave
> > -- 
> > David Reiser
> > dbreiser at earthlink.net
> 
> The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail. Get busy.

--
David Reiser
dbreiser at earthlink.net