This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

Bank statement transaction manager, written in PySide

Project Description

A tool to view and check your bank statements.

About

A simple PyQt UI to manage bank statement records. Records are imported from files in CSV format and stored in a PostgreSQL database.

The main purpose is to rationalise receipts or direct debits against statement records, and each record row has a “checked” column to indicate if the record has been validated. There are numerous filters to use:

  • checked/unchecked status
  • account type
  • money in or out
  • date filter (last import, date range, particular month)
  • description field
  • amount (which also accepts numeric operators, eg “>” “<=”

Tags

You can also tag records to arrange your records into categories. These are arbitrary text names like “utility bills”, “salary”, “ebay”. You can then filter the records with one or more of these categories. To create a new tag press the “edit tags” button.

Accounts

Each bank has a different format for their CSV files. There are 5 pre-insalled formats (ones that I know):

  • Natwest current account
  • Natwest mastercard
  • paypal (use the “Completed Balance” option when downloading)
  • First Direct
  • Credit Agricole

To add a new account, select Settings from the toolbar and hit the + button. All you have to do is give it a name and enter the CSV column number that relates to:

  • date
  • description
  • credit amount
  • debit amount
  • currency sign, to indicate how debit values are represented (1 if amount is positive, -1 if negative)
  • date format, which can be built up using the following characters:
    • d - the day as number (1 to 31)
    • dd - the day as number (01 to 31)
    • ddd - day name (‘Mon’ to ‘Sun’)
    • M - the month as number (1-12)
    • MM - the month as number (01-12)
    • MMM - month name (‘Jan’ to ‘Dec’)
    • MMMM - month name (‘January’ to ‘December’)
    • yy - the year as two digit number (00-99)
    • yyyy - the year as four digit number

For example, if a CSV record looks like this:

17/10/2008,C/L,"'BARCLAYS BNK 17OCT",-100.00,1234.20,"'Mr Me","'100001-12345678",

  • date is 0
  • description is 2
  • credit is 3
  • debit is 3
  • currency sign is -1
  • date format is dd/MM/yyyy

Getting Started

You will need a new PostgreSQL database, eg: sudo -u postgres createdb pydosh sudo -u postgres createuser will

Tip: If you need password-less access, you will need to change pg_hba.conf and change the interface authentication from md5 to trust

createdb --host localhost --username bob pydosh

When you first open pydosh, login with a valid postgres account. If pydosh detects an empty database it will initialise all tables for you.

Release History

Release History

This version
History Node

2.1

History Node

2.0

History Node

1.9

History Node

1.7

History Node

1.6

History Node

1.5

History Node

1.4

History Node

1.3

History Node

1.2

History Node

1.1

History Node

1.0

Download Files

Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
pydosh-2.1.linux-x86_64.tar.gz (234.8 kB) Copy SHA256 Checksum SHA256 any Dumb Binary Feb 11, 2014
pydosh-2.1.tar.gz (99.9 kB) Copy SHA256 Checksum SHA256 Source Feb 11, 2014

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting