django-account-keeping 0.4.4

A reusable Django app for keeping track of transactions in your bank accounts.

A reusable Django app for keeping track of transactions in your bank accounts.

Installation

To get the latest stable release from PyPi

pip install django-account-keeping

To get the latest commit from GitHub

pip install -e git+git://github.com/bitmazk/django-account-keeping.git#egg=account_keeping

Add all relevant apps to your INSTALLED_APPS

INSTALLED_APPS = (
    ...,
    'account_keeping',
    'currency_history',
    'import_export',
)

Add the account_keeping URLs to your urls.py

urlpatterns = patterns('',
    ...
    url(r'^accounting/', include('account_keeping.urls')),
)

Don’t forget to migrate your database

./manage.py migrate

Usage

Configure currency history app

Follow the instructions at: https://github.com/bitmazk/django-currency-history

Make sure you add all needed currencies first. Second, define the wanted rates. Then make sure to get the latest rate history and add it by yourself.

Add Account objects

Next you need to create your accounts. Note that the field total_amount is currently not used. It might eventually be used in the future for performance optimisations but at the moment it seems that computing the totals on the fly is fast enough.

Import data from Money Manager Ex

If you were using Money Manage Ex, you can export your data into a .csv file and then import it into this app:

./manage.py importer_mmex -f filename.csv -c EUR -t 19 -a account-slug

The parameter -t (VAT) is optional. If omitted, it is assumed that there is no VAT for the transactions in this account.

IMPORTANT: Money Manager Ex has a transaction type Transfer but unfortunately in the .csv format the information of the source and destination accounts is lost. Here is a workaround: First you go through all your transactions in Money Manager Ex and those that have an incoming transfer (a deposit), you mark by adding some unique text to the description. Then you export the .csv and edit it in an editor. You search for your unique string and for those rows you change the transaction type from Transfer to TransferDeposit.

Money Manager Ex does not have the notion of invoices, it only has transactions. When importing the data, this app will simply generate a dummy invoice for each transaction. Unfortunately, you have to go through all transactions manually and change the incoive date.

Creating transactions with sub-transactions

Sometimes a customer will pay several invoices within one transaction. For this case you should do the following:

1. Create the transaction that has appeared on your bank account as usual

2. For each invoice that has been paid, create a transaction that has the first transaction as a parent and of course create an invoice that is tied to it’s transaction.

Settings

BASE_CURRENCY

Default: ‘EUR’

Define a default currency. All time statistics and summaries are displayed using this setting.

Currently available views

Alltime overview

URL: ../all/

Shows all transactions for all accounts, all time totals and outstanding invoices.

Year overview

URL: ../YYYY/

Shows a table with total expenses, income, profit for each month of the year. Also shows how many new invoices have been sent to customers each month and how many invoices have been outstanding for each month.

Shows the total bank balance for each month (at the end of each month) and total equity (bank balance + outstanding invoices).

Month overview

URL: ../YYYY/MM/

Shows all transactions for all accounts for the given month.

Contribute

If you want to contribute to this project, please perform the following steps

# Fork this repository
# Clone your fork
mkvirtualenv -p python2.7 django-account-keeping
make develop

git co -b feature_branch master
# Implement your feature and tests
git add . && git commit
git push -u origin feature_branch
# Send us a pull request for your feature branch