Skip to content

SBI Shinsei Bank SBI 新生銀行

https://www.sbishinseibank.co.jp/

How to download transactions

TODO

CSV file

The header row can be in English or in Japanese. Japanese header row:

"取引日","摘要","出金金額","入金金額","残高"

English header row:

"Value Date","Description","Debit","Credit","Balance"

Regular expressions

Regular expressions uses 摘要 (or Description) for matching.

On sender memo

The raw CSV file does not contain the sender memo that one enters during outgoing money transfers. This info is recorded in the bank's PDF files, instead. My current workaround is manually copying that text from the PDF to the 摘要 (or Description) column in the CSV.

Example: label all transactions as default

One of the automated tests does exactly this. Let's download and run it locally.

wget https://raw.githubusercontent.com/rlan/beancount-multitool/main/tests/data/shinsei_bank/config.toml
wget https://raw.githubusercontent.com/rlan/beancount-multitool/main/tests/data/shinsei_bank/credit_mapping.toml
wget https://raw.githubusercontent.com/rlan/beancount-multitool/main/tests/data/shinsei_bank/debit_mapping.toml
wget https://raw.githubusercontent.com/rlan/beancount-multitool/main/tests/data/shinsei_bank/test.bean
wget https://raw.githubusercontent.com/rlan/beancount-multitool/main/tests/data/shinsei_bank/test.csv
bean-mt shinsei_bank config.toml test.csv --output out.bean