This is a simple tool to view your bank statements, store them in a database and to check transactions against your receipts.
and here's why
Every month I would receive my bank statement from Natwest confirming all my squandering habits. I would diligently collect all receipts with a view to ensuring that there were no spurious drains on my meagre resources. In the days of identify theft, I considered it prudent to try and account for every receipt, direct debit, standing orders etc etc. The prospect of having to match each receipt to a bank statement entry would fill me with dread as soon as the statement landed on my doorstep, so my diligence would often only be matched by periods of chronic boredom. This could result in periods of up to 6 months before getting down and "doing my accounts".
Then those nice chaps at Natwest made my bank statements available for download in a multitude of spurious formats, no doubt suitable for lavish and expensive accounting software that I have no interest in paying for, let alone using. Fortunately they also offer good old CSV format (comma separated values). Unfortunately, the formatting/layout that they use was clearly designed by an ape.
Still, it gave me an incentive to write some software that would take most of the pain away from the loathsome "doing my accounts" process and hopefully enable me to keep better tabs on my money. I hope you also find it useful. It's simple, and open-source "free".
how it works
Supported databases are Postgres, MySQL and SQLite. For the first two, you'll need to create an empty database and give yourself SELECT, INSERT, UPDATE, DELETE and EXECUTE permissions. doshlogger will initialise any empty database when you login. For SQLite, a file will be created with the default name doshlogger.db - no configuration is necessary.
When you start you'll be greeted with a login screen - enter the details and press Connect.
Next you'll need to add a bank account from the settings (or preferences) menu.
You'll need to tell doshlogger how to translate the csv fields - this screenshot shows how it's done
To import statements, select Import from the menu and select the appropriate account type
There are various filters in the main window that allow you to view selected transactions:
- date range
- single month
- last month only
- checked or unchecked transactions
- transaction type (direct debits etc)
- description (the spurious text in the statements)
These filter settings will display all unchecked point-of-sale transactions from my Natwest account, from June 07 to May 2010 for 1000 dollars/pounds/groats, with "chamonix" somewhere in the description.
The "Checked" column indicates that the transaction has been verified - presumably because you've found the receipt and it all seems ok. If you select Unchecked then this will just show you transactions that have yet to be verified.
You can add arbitrary tags to transactions which act as groups. Just select the transactions you want to tag and hit the icon
Then you can set search on the tags you've created using the filter box.
debian package (i386)
debian package (x86)
mac osx package (i386)
mac osx package (x86)
Comment, suggestions, bugs, gratitude always welcome.
dev at innerhippy dot com
v0.5.0   9 June 2012
- - better amount filtering
- - smart toggle
v0.4.1   29 May 2011
- - Missing account and record types
v0.4.0   24 Oct 2010
- - Fixed mysql initialisation
- - added md5 checksum - mysql can't handle long text indexes...
v0.3.0   19 Oct 2010
- - Fixed resizeColumnsToContents to display correct width on startup
- - renamed all source files
v0.2.0   18 Sep 2010
- - Removed Assistant - re-done help
v0.1.0   17 Jul 2010
- - Many improvements
v0.0.4   2 Jun 2010
- - Near total re-write
v0.0.3   13 Jun 2009
- - added support for Credit Agricole statements
- - problem after initialising new schema - infinite date loop!
- - better text internationalisation (even French!)
v0.0.2   22 Feb 2009
- - problem with multiple toggles when checked option is used
v0.0.1   31 Jan 2009
- - initial release