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.
