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.

Source Distribution

beancount-hangseng-0.4.0.tar.gz (9.3 kB view hashes)

Uploaded Source

Built Distributions

beancount_hangseng-0.4.0-py3.7.egg (12.5 kB view hashes)

Uploaded Source

beancount_hangseng-0.4.0-py3-none-any.whl (25.3 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page