gnucash

Make Gnucash iCal from invoices

Something handy, make an iCal calendar file from your Gnucash datafile, I use this to create a calendar of invoiced day's so i can see if i missed any days for invoicing.

Gnucash datafile is a compressed XML file with a fairly straightforward schema, here we use xml2 command line xml swiss army knife to turn the XML into something we can grep, then use some simple formatting to output to the iCalendar output.

Accepts the gnucash datafile as argument 1, and the output as argument 2.

My gnucash recipe

heres my gnucash account recipe

Initial setup

- Set up your bank account as "Assets:BendigoBank passport account" or whatever your income lands into, set your opening balance as of the financial year

- set up a "Assets:AR" as type Accounts/R

- Setup any Expense sub-accounts, these need to be defined prior to importing the QIF as theres a bug in the QIF importer.

Importing your QIF

For savings/bank account type

Pre-processing your .QIF for GnuCash with python - use regex and a flat DB to add categories to transactions

GnuCash is an excellent linux based accounting package, it is modelled very closely to traditional two-column accounting methods but has lots of functionality like generating invoices, tracking clients and all the other things you'de expect from a package to run your finances.

Syndicate content