Request assistance for importing invoice/bill payments

Geert Janssens geert.gnucash at kobaltwit.be
Sat Sep 27 04:22:29 EDT 2014


Hi Nelson,

That's an interesting approach you are trying there.

The qif importer unfortunately does not know anything about invoices or 
payments. It only understands transactions.

To get to your final goal of linking payments with invoices/bills I see 
two options

- either you forget about the qif importer altogether and instead 
experiment with the csv invoice importer. I have no experience with it 
myself though, so perhaps this is not a reasonable approach.

- or you can effectively use the "Assign as payment" option. You say it 
doesn't do anything which is not my experience.
What did you try, what happened and what were you expecting ?

Geert

On Saturday 27 September 2014 08:56:46 Nelson Handcock wrote:
> Bump
> 
> Thanks & Regards,
> 
> Nelson Handcock
> 0409 149919
> 
> http://www.linkedin.com/in/nelsonhandcockaustralia
> 
> On Sat, Sep 20, 2014 at 10:12 AM, Nelson Handcock
> <nelson.handcock at gmail.com
> > wrote:
> > 
> > Hi,
> > 
> > Could someone please advise on how best to import transactions into
> > Gnucash, so that invoices are paid?
> > 
> > I'm running Version 2.6.3, Windows 8.1, Asus Laptop
> > 
> > 
> > I have documented the procedure that I followed to import the QIF
> > file that was generated from the bank transactions - they are
> > imported successfully into the nominated accounts, but they are not
> > associated as payments to the invoices and I can't see how to get
> > this to occur.
> > 
> > When I run a customer report, the transactions do not appear - I
> > assume this is because they are not considered as payments, and I'm
> > trying to get this to occur.
> > 
> > 
> > A copy of the QIF file I used as a test is here...
> > https://www.dropbox.com/sh/rr5nlo3qleaqnps/AAA7brNX4loV-B5nX_LgYIYKa
> > ?dl=0
> > 
> > A copy of screenshots of the import and the results is here...(Word
> > 2007)
> > https://www.dropbox.com/sh/rr5nlo3qleaqnps/AAA7brNX4loV-B5nX_LgYIYK
> > a?dl=0
> > 
> > When I look at the imported transactions, there does not appear to
> > be any way to change the "Ref" or the "Action" columns. (The
> > transactions in the screenshot that do have these columns set were
> > processed manually)
> > 
> > There seems to be a menu option "Assign as Payment..." but this does
> > not appear to do anything. I think this may be listed as a problem
> > already.
> > 
> > 
> > Any advice would be appreciated!
> > 
> > 
> > Thanks & Regards,
> > 
> > Nelson Handcock
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



More information about the gnucash-user mailing list