Reconcile Status of imported QIF files (exported by CBB)
Joerg Schoeppe
joerg_schoeppe@mentorg.com
Tue, 28 Nov 2000 15:26:47 +0100
On 2000-08-05 08.43, Adrian Cox wrote:
[...]
> Something in the import process is taking files which are reconciled in
> Quicken, and not marking
> them as reconciled in Gnucash. I suspect the QIF file doesn't make the
> distinction between cleared
> and reconciled. The importer may need the option to promote cleared to
> reconciled.
>
> > Anyway, the solution is to perform a one-time-only reconciliation where
> > you enter the starting balance you expect as the ending balance, and then
> > check off all the transactions which should have been reconciled. I realize
> > this is going to be a pain :(
>
> I think I may try to edit out the last four tax years using Quicken
> before I give this a go.
I had the same problem. I try to import QIF files from CBB. I tried
to understand the scm files in ../gnucash/scm/qif-import. With trial
and error I found a way to get the reconciled entries into gnucash as
reconciled instead of cleared.
In ../gnucash/scm/qif-import/qif-to-gnc.scm (search for reconciled)
(if (or (eq? qif-cleared 'cleared)
(eq? qif-cleared 'reconciled))
(gnc:split-set-reconcile gnc-near-split #\c))
...
(let ((cleared (qif-split:matching-cleared qif-split)))
(if (or (eq? 'cleared cleared)
(eq? 'reconciled cleared))
(gnc:split-set-reconcile gnc-far-split #\c)))
I've modified this to:
(if (eq? qif-cleared 'cleared)
(gnc:split-set-reconcile gnc-near-split #\c))
(if (eq? qif-cleared 'reconciled)
(gnc:split-set-reconcile gnc-near-split #\y))
...
(let ((cleared (qif-split:matching-cleared qif-split)))
(if (eq? 'cleared cleared)
(gnc:split-set-reconcile gnc-far-split #\c))
(if (eq? 'reconciled cleared)
(gnc:split-set-reconcile gnc-far-split #\y)))
With this I got all reconciled entries from CBB to gnucash.
I found your problem during search for a solution. Maybe someone want
to consider if this a bug and if this a fix.
Hope that helps,
Joerg
--
Joerg_Schoeppe@mentor.com Tel: +49-89-575097
Customer Applications Engineer Mentor Graphics Deutschland GmbH