Skip to main content

Parse Hang Seng eStatements to Beancount/CSV

Project description

Beancount/CSV parser for HK Bank Accounts

PyPI version fury.io

Few Hong Kong Banks provide structured formatted (CSVs, OFX, etc) electronic statements to users, usually only PDFs are available (unless you're a Business-tier user).

This package parses PDF eStatements from some of the HK Banks, and output results as beancount or CSV.

Currently supports:

  • Hang Seng Integrated Account (Only Savings transactions are extracted)
  • Hang Seng MPOWER Credit Card
  • DBS COMPASS VISA Credit Card

Installation

  1. Install external dependency pdftotext. This is normally packaged under poppler for most Linux distros. Windows users may try with this.

  2. Install package via pip:

     pip install beancount-hangseng
    

Usage

Beancount

  1. Add HangSengSavingsImporter/MPowerMasterImporter/DBSImporter to your import config (See config.py for example)
  2. Run bean-extract config.py /path/to/eStatement.pdf > output.beancount

CSV

beancount-hangseng-csv -o output.csv -f {hangseng,mpower,dbs} /path/to/statement.pdf

If statements are already downloaded in one folder, you may process and verify output in one go:

cd /path/to/output_dir
beancount-hangseng-csv -t {hangseng,mpower,dbs} -v /path/to/HangSeng_*.pdf -d /tmp/

Run beancount-hangseng-csv -h for more options and debug suggestions.

Credits

Inspired by @dictcp's Gist.


"Therefore I say unto you, Take no thought for your life, what ye shall eat, or what ye shall drink; nor yet for your body, what ye shall put on. Is not the life more than meat, and the body than raiment?" -- Matthew 6:25

Project details


Download files

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

Files for beancount-hangseng, version 0.4.0
Filename, size File type Python version Upload date Hashes
Filename, size beancount_hangseng-0.4.0-py3.7.egg (12.5 kB) File type Egg Python version 3.7 Upload date Hashes View
Filename, size beancount_hangseng-0.4.0-py3-none-any.whl (25.3 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size beancount-hangseng-0.4.0.tar.gz (9.3 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page