about

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".

screenshot

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.

adding accounts

Next you'll need to add a bank account from the settings (or preferences) menu.

screenshot

You'll need to tell doshlogger how to translate the csv fields - this screenshot shows how it's done

importing statements

To import statements, select Import from the menu and select the appropriate account type

filters

There are various filters in the main window that allow you to view selected transactions:

screenshot

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.

Tags

You can add arbitrary tags to transactions which act as groups. Just select the transactions you want to tag and hit the tag icon

Then you can set search on the tags you've created using the filter box.

 

download the software


debian package (i386)
debian package (x86)
mac osx package (i386)
mac osx package (x86)
source

Comment, suggestions, bugs, gratitude always welcome.

Will

dev at innerhippy dot com

 

release history