Recocile checking account with OFX file

Michael Hendry hendry.michael at gmail.com
Mon Mar 16 11:07:46 EDT 2015


> On 16 Mar 2015, at 13:38, dave boland <dboland9 at fastmail.fm> wrote:
> 
> All,
>  
> We seem to have gotten off my topic - how to import and reconcile bank transactions into gnuCash using an OFX file.  I backed up my gnuCash file, started the import process, and got the window listing the results (red, yellow, green).  I clicked on Help, but found it to be of little use.  I Googled gnuCash OFX import, but found very little and no official documentation.  A lot of the transactions the importer wanted to load were duplicates that varied by date only (date of actual transaction in gnuCash, date vendor got paid in the OFX file), and it was very confusing.  I decided to just download a CSV file, load it into LibreOffice Calc, and do every thing by hand.
>  
> Call me disappointed.  Hope that new releases of gnuCash improve the importer.

Sorry you’ve been disappointed, but perhaps you could explain clearly what you are looking for?

If I understand your original post correctly, you’ve been recording bank transactions, but you haven’t reconciled the accounts for a long time - you want the OFX import to bring in any transactions you’ve failed to record, correct any that you’ve misrecorded, and flag up any transactions that are in GnuCash but not in the bank’s version. While this is being done, the “Reconciled” flags will be set on the matching transactions, and at the end of it all the Balance in your bank statement will match the reconciled balance in GnuCash.

If this is what you want, I’m afraid you’re doomed to further disappointment - unless you can specify to the developers in great detail how this magic would be achieved.

Michael

> Dave,
> -- 
> dave boland
> dboland9 at fastmail.fm <mailto:dboland9 at fastmail.fm>
> -- 
> http://www.fastmail.com <http://www.fastmail.com/> - Email service worth paying for. Try it for free



More information about the gnucash-user mailing list