Skip to content

Parse PDF e-Statements of (some) HK Banks to Beancount/CSV

License

Notifications You must be signed in to change notification settings

yiufung/beancount-hangseng

Repository files navigation

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

About

Parse PDF e-Statements of (some) HK Banks to Beancount/CSV

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages