Re: on-line banking & qif import

2000-05-17 Thread Gary Oberbrunner
As a lurker on this list, I just wanted to say this "fuzzy QIF import" with duplicate recognition would be the most *wonderful* feature. Better even than OFX (ok, about equal to it in importance for me). I enter all my checks manually, and anything large (so I have a general idea how I'm doing),

Re: on-line banking & qif import

2000-05-16 Thread Bill Gribble
Christopher Browne <[EMAIL PROTECTED]> writes: > Ouch. I'm starting to get a tad concerned about how "fuzzy" this matching > is starting to get. Well, as long as the user has to put a "stamp of approval" on the matches, I think it's OK. I'm currently working on an overhaul of the QIF code that

Re: on-line banking & qif import

2000-05-15 Thread Christopher Browne
On Mon, 15 May 2000 21:18:16 CDT, the world broke into rejoicing as Glen Ditchfield <[EMAIL PROTECTED]> said: > I'd like the looser rules for matching imported entries with existing >entries. Ouch. I'm starting to get a tad concerned about how "fuzzy" this matching is starting to get. > The .

Re: on-line banking & qif import

2000-05-15 Thread Glen Ditchfield
I'd like the looser rules for matching imported entries with existing entries. The .qif files I get from my bank contain descriptions like "CHQ#00452-0041093240" for a cheque. I suppose the digits after the dash are some sort of tracking number; at any rate, when I type the cheque into Gnucash

Re: on-line banking & qif import

2000-05-15 Thread Richard Wackerbarth
On Sun, 14 May 2000, Hendrik Boom wrote: My question was > > "With respect to reconciliation, when is the 'payee' field considered to > > be reconciled?" > > I guess I missed your point because I don't understand what it means > to reconcile a 'payee' field. One aspect of reconciliation is the im

Re: on-line banking & qif import

2000-05-14 Thread Hendrik Boom
> On Sat, 13 May 2000, Hendrik Boom wrote: > > > On Fri, 12 May 2000, Hendrik Boom wrote: > > > > > As for changing "reconciled" transactions, it is unclear to me what > > > > > relationship exists between the "transaction" and the "JEs". > > > > > > > > It is the JEs that get reconciled. > > > >

Re: on-line banking & qif import

2000-05-13 Thread Richard Wackerbarth
On Sat, 13 May 2000, Hendrik Boom wrote: > > On Fri, 12 May 2000, Hendrik Boom wrote: > > > > As for changing "reconciled" transactions, it is unclear to me what > > > > relationship exists between the "transaction" and the "JEs". > > > > > > It is the JEs that get reconciled. > > > > Right. But t

Re: on-line banking & qif import

2000-05-13 Thread Hendrik Boom
> On Fri, 12 May 2000, Hendrik Boom wrote: > > > As for changing "reconciled" transactions, it is unclear to me what > > > relationship exists between the "transaction" and the "JEs". > > > > It is the JEs that get reconciled. > > Right. But to what does the "Payee" belong? I presume whoever you

Re: on-line banking & qif import

2000-05-12 Thread Richard Wackerbarth
On Fri, 12 May 2000, Hendrik Boom wrote: > > As for changing "reconciled" transactions, it is unclear to me what > > relationship exists between the "transaction" and the "JEs". > > It is the JEs that get reconciled. Right. But to what does the "Payee" belong? > I occasionally do change the date

Re: on-line banking & qif import

2000-05-12 Thread Hendrik Boom
> > As for changing "reconciled" transactions, it is unclear to me what > relationship exists between the "transaction" and the "JEs". It is the JEs that get reconciled. > > Each JE would get reconciled separately. Therefore you could have a > transaction transferring funds from one account

Re: on-line banking & qif import

2000-05-12 Thread Richard Wackerbarth
On Fri, 12 May 2000, Hendrik Boom wrote: > > I'm not sure that I would allow you to alter the entry while it is > > "reconciled". However, I would assume that you are happy to do it in the > > "candidate" state. > > With Quicken, I often change reconciled entries. > What I never do is change the

Re: on-line banking & qif import

2000-05-12 Thread Hendrik Boom
> On Thu, 11 May 2000, Hendrik Boom wrote: > > > In general, I think that we must assume no correlation between importing > > > data and reconciliation. All that we know is that each entry imported > > > from the bank must appear in the ledger and that it has cleared the bank. > > > A JE must prog

Re: on-line banking & qif import

2000-05-11 Thread Richard Wackerbarth
On Thu, 11 May 2000, Hendrik Boom wrote: > > In general, I think that we must assume no correlation between importing > > data and reconciliation. All that we know is that each entry imported > > from the bank must appear in the ledger and that it has cleared the bank. > > A JE must progress throu

Re: on-line banking & qif import

2000-05-11 Thread Hendrik Boom
> In general, I think that we must assume no correlation between importing data > and reconciliation. All that we know is that each entry imported from the > bank must appear in the ledger and that it has cleared the bank. > A JE must progress through the following "reconciliation states" > 1) E

Re: on-line banking & qif import

2000-05-11 Thread Richard Wackerbarth
On Thu, 11 May 2000, Hendrik Boom wrote: > Last time I looked, my bank's qif imports give me all the transactions > since the last statement, not since the last qif import. You should also be able to get the bank to export other periods. In general, I think that we must assume no correlation betw

Re: on-line banking & qif import

2000-05-11 Thread Hendrik Boom
> On Tue, May 09, 2000 at 12:50:09AM -0500, Linas Vepstas wrote: > > > > I was talking to someone about on-line banking & gnucash. I hadn't > > thought about ti much, but a large part of on-line banking is > > reconciling statements against what the bank has. Now, many 'online > > banks' use QI

Re: on-line banking & qif import

2000-05-11 Thread Gerald Champagne
[EMAIL PROTECTED] wrote: > > Bill, see the note below. > > I take all of the points you made in an earlier message; you're right, > reconcileing with QIF files is a potentially ill-defined, dangerous > process. And yet, we still have the note below. > > It's been rumoured that Randolph Fritz

Re: on-line banking & qif import

2000-05-11 Thread Richard Wackerbarth
On Thu, 11 May 2000, Linas wrote: > If I understand this correctly, and we did qif-based reconciliation, > it would work as follows: > > -- randolph goes to bank web site, makes note of the banks current balance, >and downloads a qif. > -- he powers up gnucash, and picks 'reconcile-qif' from t

Re: on-line banking & qif import

2000-05-10 Thread linas
Bill, see the note below. I take all of the points you made in an earlier message; you're right, reconcileing with QIF files is a potentially ill-defined, dangerous process. And yet, we still have the note below. It's been rumoured that Randolph Fritz said: > > On Tue, May 09, 2000 at 12:50

Re: on-line banking & qif import

2000-05-09 Thread Randolph Fritz
On Tue, May 09, 2000 at 12:50:09AM -0500, Linas Vepstas wrote: > > I was talking to someone about on-line banking & gnucash. I hadn't > thought about ti much, but a large part of on-line banking is > reconciling statements against what the bank has. Now, many 'online > banks' use QIF export as

Re: on-line banking & qif import

2000-05-09 Thread Bill Gribble
[EMAIL PROTECTED] writes: > Its not just 'matching them up', its also marking them as 'tentatively > cleared' in the reconcile dialog. I think this should be a separate step from the import. It makes sense to store information with a transaction indicating "we've seen this in a bank download

Re: on-line banking & qif import

2000-05-09 Thread linas
It's been rumoured that Bill Gribble said: > > Linas Vepstas <[EMAIL PROTECTED]> writes: > > Sooo (sound of lightbulb turning on) isn't the right way to import > > QIF files is to run them through a reconcile-like dialogue? > > However, as you point out, downloading short snippets of QIF from th

Re: on-line banking & qif import

2000-05-09 Thread Bill Gribble
Linas Vepstas <[EMAIL PROTECTED]> writes: > Sooo (sound of lightbulb turning on) isn't the right way to import > QIF files is to run them through a reconcile-like dialogue? That's a great idea for the "last step" of *some* QIF imports. I think the most common usage of the QIF importer is still a

on-line banking & qif import

2000-05-08 Thread Linas Vepstas
Food for thought: I was talking to someone about on-line banking & gnucash. I hadn't thought about ti much, but a large part of on-line banking is reconciling statements against what the bank has. Now, many 'online banks' use QIF export as a way of sending statements to users. Sooo (sound of