muralisc/bank2ledger-cli

Bank2ledger

Convert bank csv files into ledger-cli format.

From ledger-cli.org,

Ledger is a powerful, double-entry accounting system that is accessed from the UNIX command-line.

However to use it we need out transactions to be encoded in ledger format. This tool lets us do that for any bank / finance handlers (Insurance, Stock Brokers) who can furnish a csv of transactions

How does it work

For a transaction snippet from Monzo csv:

tx_0000AZPPhBZWW3Pq4dXGYW,04/09/2023,02:02:01,Direct Debit,Hyperoptic,,Bills,-26.50,GBP,-26.50,GBP,HYP000000630597,,,HYP000000630597,,-26.50,

to

2023-09-04 * "Hyperoptic"
        Assets:Bank:Monzo        -26.50 GBP
        Expenses:Utilities

Charles Schwab

How to Get CSV file ?

Schwab > Accounts > History > Export

Command to run

RUST_BACKTRACE=1 cargo run -- \
  --config $PATH_TO_BANK2LEDGER_CLI/config/schwab.toml \
  --transactions-csv $PATH_TO_CSV/schwab_Transactions_20230409-103308.csv \
  > $PATH_TO_LEDGER_FILES/ledger/ledger_2023_03Mar_schwab.ledger

HSBC

How to get TrasactionHistory file for HSBC ?

From web portal

1. Click
2. Filter
3. Download

Command to run

RUST_BACKTRACE=1 cargo run -- \
    --config $PATH_TO_BANK2LEDGER_CLI/config/hsbc.toml \
    --transactions-csv $PATH_TO_CSV/hsbc_TrasactionHistory_09_April_2023.csv \
    > $PATH_TO_LEDGER_FILES/ledger/ledger_2023_03Mar_hsbc.ledger

Amex

How to get TrasactionHistory file for AMEX ?

• [Statements & Activity] > Previous Billing Periods > choose window (11 Jul to 10 Aug) > CSV (Check for all details)

Command to run

RUST_BACKTRACE=1 cargo run -- \
    --config $PATH_TO_BANK2LEDGER_CLI/config/amex.toml \
    --transactions-csv $PATH_TO_CSV/amex-dec.csv \
    > $PATH_TO_LEDGER_FILES/ledger/ledger_2023_03Mar_amex.ledger

Monzo

Command to run

RUST_BACKTRACE=1 cargo run -- \
    --config $PATH_TO_BANK2LEDGER_CLI/config/monzo.toml \
    --transactions-csv $PATH_TO_CSV/Monzo\ Data\ Export\ -\ July.csv \
    > $PATH_TO_LEDGER_FILES/ledger/ledger_2023_03Mar_monzo.ledger

Identify new Account mappings

grep for WARN in log file

grep "WARN" bank2ledger.debug.log

SBI

Export as XlS, no need to convert it as CSV, XLS == TSV

RUST_BACKTRACE=1 cargo run -- \
    --config ~/src/bank2ledger-cli/config/sbi.toml \
    --transactions-csv ~/shared_folders/transfer_work/sbi-12dec.xls > ledger_2023_12Dec_sbi.txt

Using target build bin

bank2ledger-cli \
    --config ~/src/bank2ledger-cli/config/sbi.toml \
    --transactions-csv ~/shared_folders/transfer_work/sbi-12dec.xls > ledger_2023_12Dec_sbi.txt