JA Bank JAネットバンク¶
How to download transactions¶
TODO
CSV file¶
Header row:
"番号","明細区分","取扱日付","起算日","お支払金額","お預り金額","取引区分","残高","摘要"
In English:
column_names = {
"番号": "Number",
"明細区分": "Detail Classification",
"取扱日付": "Handling Date",
"起算日": "Starting Date",
"お支払金額": "Debit",
"お預り金額": "Credit",
"取引区分": "Transaction Classification",
"残高": "Balance",
"摘要": "Description",
}
Note on dates. On inspection of the CSV file, there are no year in dates, e.g. 4月30日. Thus, the tool uses the current year during conversion. So if you are converting data from last year, edit the generate bean file after conversion.
Regular expressions¶
The following two columns are concatentated then passed to regular expressions for matching: Transaction Classification
and Description
.
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/ja_bank/config.toml
wget https://raw.githubusercontent.com/rlan/beancount-multitool/main/tests/data/ja_bank/credit_mapping.toml
wget https://raw.githubusercontent.com/rlan/beancount-multitool/main/tests/data/ja_bank/debit_mapping.toml
wget https://raw.githubusercontent.com/rlan/beancount-multitool/main/tests/data/ja_bank/test.bean
wget https://raw.githubusercontent.com/rlan/beancount-multitool/main/tests/data/ja_bank/test.csv
bean-mt ja_bank config.toml test.csv --output out.bean
Example: simple account labeling using regular expressions¶
This automated test does exactly this. Let's download and run it locally.
wget https://raw.githubusercontent.com/rlan/beancount-multitool/main/tests/data2/ja_bank/config.toml
wget https://raw.githubusercontent.com/rlan/beancount-multitool/main/tests/data2/ja_bank/credit_mapping.toml
wget https://raw.githubusercontent.com/rlan/beancount-multitool/main/tests/data2/ja_bank/debit_mapping.toml
wget https://raw.githubusercontent.com/rlan/beancount-multitool/main/tests/data2/ja_bank/test.bean
wget https://raw.githubusercontent.com/rlan/beancount-multitool/main/tests/data2/ja_bank/test.csv
bean-mt ja_bank config.toml test.csv --output out.bean