This is a pre-production deployment of Warehouse, however changes made here WILL affect the production instance of PyPI.
Latest Version Dependencies status unknown Test status unknown Test coverage unknown
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

2.1

This version

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

2.0

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

1.9

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

1.7

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

1.6

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

1.5

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

1.4

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

1.3

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

1.2

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

1.1

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

1.0

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

Download Files

Download Files

TODO: Brief introduction on what you do with files - including link to relevant help section.

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 HPE HPE Development 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