Problems importing .OXF files - A £27.00 transaction is lost, so balance is shown £27.00 higher in GnuCash than the true balance.

Dr. David Kirkby (Kirkby Microwave Ltd) drkirkby at kirkbymicrowave.co.uk
Sun Nov 27 09:52:14 EST 2016


I've downloaded some .OXF files from my bank. I've named them something
half-sensible, so it should be clear the first,

KIRKBYMICROWAVELTD-20161126-01-02-2014-to-31-12-2014.ofx

is for the period 01-02-2014 to 31-12-2014. When I imported that, the
balance shown in GnuCash is £1175.18 - see screenshot below.

http://www.kirkbymicrowave.co.uk/tmp/Screenshot-33.png

That looks sensible. A check of a .csv file for the same period from the
bank, has at the last line.

31/12/2014,POS,"'9035 30DEC14 , WWW.UK.RS-ONLINE.C, 08457 201201
GB",-44.76,1175.18,"'KIRKBY MICROWAVE LTD","'830425-11186193",

So GnuCash and my bank seem to be in agreement there.

Next I imported all the 2015 transactions, from the file

KIRKBYMICROWAVELTD-20161126-01-01-2015-to-31-12-2015.ofx

Looking back now to the end of 2014

http://www.kirkbymicrowave.co.uk/tmp/Screenshot-36.png

I see something odd.  Notice that the balance is higher at the end of 2014
than it was before I imported the 2015 transactions.

The last transaction of 2014 has been lost. A £27.00 debit to Interparcel
is no longer shown. Hence the balance at the end of 2014 is now shown as
1175.18+27.00=£1202.18, which I believe is incorrect.

I then imported the 2016 transactions. As of yesterday, there was a couple
of hundred pounds difference between what my bank shows, and what GnuCash
shows. I've not bothered looking at what causes that, but first I'd like to
sort out why importing the 2015 transactions caused a problem.

Does anyone have any ideas what could cause this £27.00 transaction to be
lost?


Dr. David Kirkby Ph.D CEng MIET
Kirkby Microwave Ltd
Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT,
UK.
Registered in England and Wales, company number 08914892.
http://www.kirkbymicrowave.co.uk/
Tel: 07910 441670 / +44 7910 441670 (0900 to 2100 GMT only please)


More information about the gnucash-user mailing list