Importing transactions as a CSV file

Mike Evans mikee at saxicola.idps.co.uk
Sat Jan 21 06:19:32 EST 2012


On Sat, 21 Jan 2012 00:18 +0000 (GMT Standard Time)
"Colin Scott" <gnucash at double-bars.net> wrote:

> 
> I understand it is possible to create txns offline (in Excel) and
> then import them into Gnucash as a CSV file.  What I have been able
> to find, though, is any description of the layout of the CSV file.
> Any suggestions where I should look?
> 
> Is it possible to work this way for things like creating new
> invoices?  (And if so, where can I find the CSV file layouts ...?  :-)
> 
> Colin
> _______________________________________________
For transaction import the csv justs needs:
date, description, debit, credit, columns as a minimum, but all
the register columns can be present. The file can use any column
delimiter, not just commas. The importer can select any column in any
order. 

There is an invoice importer/creator and the instructions for use can
be found at:
http://svn.gnucash.org/docs/guide/python-import-invoices.html
It's not as flexible as the csv importer I'm afraid.

Mike


More information about the gnucash-user mailing list