Skip to main content

Convert Nigerian bank PDF statements into structured CSV.

Project description

bankstract

Convert Nigerian bank PDF statements into structured CSV. Plugin architecture — one parser per bank.

pip install bankstract

bankstract palmpay statement.pdf -o out.csv
bankstract auto unknown.pdf -o out.csv
bankstract list

Status

Bank Status
PalmPay v0.6 — alpha
First Bank v0.6 — alpha
Zenith v0.6 — alpha

Install

pip install bankstract

Optional extras:

pip install "bankstract[ocr]"      # pytesseract for scanned PDFs
pip install "bankstract[camelot]"  # camelot lattice fallback

Develop

Project uses uv for dependency + venv management.

uv sync --all-extras       # create .venv, install deps + extras from uv.lock
uv run pre-commit install  # one-time: enable the pre-commit hook
uv run pytest              # run tests
uv run ruff check src tests
uv run pyright src tests   # strict type check (see CLAUDE.md directive 8)
uv run bankstract list     # invoke CLI

Add a dependency with uv add <pkg> (dev: uv add --dev <pkg>). Commit uv.lock.

The pre-commit hook runs ruff check, ruff format --check, pyright (strict), and pytest before every commit. Bypass only in genuine emergencies with git commit --no-verify; the same checks run again in CI.

Releasing

CI publishes to PyPI automatically on push to main via .github/workflows/publish.yml. The workflow runs the full gate (ruff + pyright + pytest), and if the current pyproject.toml version already exists on PyPI it auto-bumps the minor component and commits the bump before publishing. PyPI auth uses OIDC trusted publishing — no token in repo or CI secrets.

To prepare a release locally:

scripts/bump-version.sh                 # patch bump
scripts/bump-version.sh minor           # 0.2.x -> 0.3.0
scripts/bump-version.sh major           # 0.x.x -> 1.0.0
scripts/bump-version.sh 0.3.0           # exact set
uv build                                # dist/*.whl + dist/*.tar.gz
uv publish dist/*                       # only if not using the GH workflow; needs --token or UV_PUBLISH_TOKEN

Trusted-publisher setup (one-time, owner only): create a publisher at https://pypi.org/manage/account/publishing/ with workflow publish.yml, repo logickoder/bankstract.

Usage

bankstract <bank> <pdf> -o <out>               # explicit parser
bankstract auto <pdf> -o <out>                 # auto-detect via Parser.detect_confidence()
bankstract list                                # show registered parsers
bankstract <bank> <pdf> -o out.json -f json    # JSON instead of CSV
cat statement.pdf | bankstract auto - -o -     # stdin / stdout pipeline

Pass - as the PDF arg to read from stdin, or - to -o to write to stdout. When stdout is the data sink, informational messages go to stderr so the data stream stays clean.

Unparseable blocks are written to a .log sidecar next to the output file.

Python API

import bankstract

bankstract.list_parsers()           # ['fbn', 'palmpay', 'zenith']
bankstract.detect("statement.pdf")  # 'palmpay' | None

result = bankstract.parse("statement.pdf")            # auto-detect
result = bankstract.parse(fp, bank="fbn")             # explicit; fp is BytesIO

result.metadata.account_holder
result.metadata.statement_period_start
result.transactions[0].balance
result.format_version

bankstract.parse(source, *, bank=None) accepts a pathlib.Path, a string path, or a seekable binary stream. Auto-detection picks the parser with the highest detect_confidence score. Every name re-exported from bankstract is part of the semver-stable surface; bankstract._* modules are internal.

Reconciliation invariant

Two complementary checks; the CLI picks whichever applies per bank.

  • Row-wise (banks that print a running balance): prev.balance ± debit/credit == curr.balance. Mismatch raises ReconciliationError with the row index.
  • Totals-based (banks like PalmPay that omit a balance column): the parser reads Total Money In / Total Money Out from the statement header and the CLI asserts that the sum of parsed credits/debits equals those totals.

Both modes exist to catch silently-dropped rows — the failure mode of naive PDF parsers.

Contributing a bank parser

  1. Copy src/bankstract/parsers/palmpay.py to src/bankstract/parsers/<bank>.py.
  2. Implement detect() and parse() -> ParseResult from parsers/base.py. Populate total_credit / total_debit if the statement only ships header totals.
  3. Add a Redactor subclass under src/bankstract/redactors/<bank>.py for the fixture pipeline.
  4. Drop the raw statement at tests/<bank>/fixtures/_local/ (gitignored), then uv run bankstract redact <bank> <raw> tests/<bank>/fixtures/sample.pdf to produce the committable fixture.
  5. Add tests under tests/<bank>/test_parser.py and tests/<bank>/test_redactor.py.

CI runs ruff + pyright (strict) + pytest. All three must pass clean. Reconciliation invariant must hold on every fixture.

Fixture PDFs must be redacted: account numbers, names, addresses, transaction IDs scrubbed. Never commit unredacted statements.

License

MIT. Author: logickoder.

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

bankstract-0.6.0.tar.gz (99.8 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

bankstract-0.6.0-py3-none-any.whl (36.6 kB view details)

Uploaded Python 3

File details

Details for the file bankstract-0.6.0.tar.gz.

File metadata

  • Download URL: bankstract-0.6.0.tar.gz
  • Upload date:
  • Size: 99.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.12

File hashes

Hashes for bankstract-0.6.0.tar.gz
Algorithm Hash digest
SHA256 d663c0d4e364fb68e52983e1c9176046ceef6aebfe2b3045ac4f52ac26a7294d
MD5 9f460dcfc290c051ce6a30d11485a76b
BLAKE2b-256 6dce55f79bef00664194287c6fdfa47f66243366f03e775548c99d49d5d941eb

See more details on using hashes here.

Provenance

The following attestation bundles were made for bankstract-0.6.0.tar.gz:

Publisher: publish.yml on logickoder/bankstract

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file bankstract-0.6.0-py3-none-any.whl.

File metadata

  • Download URL: bankstract-0.6.0-py3-none-any.whl
  • Upload date:
  • Size: 36.6 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.12

File hashes

Hashes for bankstract-0.6.0-py3-none-any.whl
Algorithm Hash digest
SHA256 dca74df407df006b6081d877d19bb95c56efa9b42256c150f8f249f8ad51bd42
MD5 5be36d5d6c59093c61cef936a8455e57
BLAKE2b-256 0fd298d3430a5be390713321a0d13adaf02f55feffdf2b9e980390d59a5b9872

See more details on using hashes here.

Provenance

The following attestation bundles were made for bankstract-0.6.0-py3-none-any.whl:

Publisher: publish.yml on logickoder/bankstract

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

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