0.0.4 • Published 6 years ago
bank-csv-to-ynab v0.0.4
bank-csv-to-ynab
This is a simple tool to convert CSV files from banking transactions to the correct format to be imported into YNAB.
Notes
Currently only DKB CSVs are supported.
Usage
API
For usage see tests. Here is an example:
const dkbCSVToYNABCSV = require('bank-csv-to-ynab')
let DKBFileASString // This is the input string. Possibly read from file.
dkbCSVToYNABCSV(DKBFileAsString).then((ynabCSVString) =>
console.log(ynabCSVString)
)
CLI
Lets say you have an input dbk.csv
with the following content:
"Kontonummer:";"DE04120300002020202020 / Girokonto"
"Von:";"04.09.2018"
"Bis:";"04.10.2018"
"Kontostand vom 04.10.2018:";"42,42 EUR"
"Buchungstag";"Wertstellung";"Buchungstext";"Auftraggeber / Beg�nstigter";"Verwendungszweck";"Kontonummer";"BLZ";"Betrag (EUR)";"Glaeubiger-ID";"Mandatsreferenz";"Kundenreferenz"
"02.10.2018";"02.10.2018";"Dauerauftrag";"Hans Foo";"Semestergebuehren";"DE48733500000600600600";"BYLADEMAAAA";-50;;;"NOTPROVIDED"
"03.10.2018";"03.10.2018";"Auftrag";"Foo Hans";"Semestergebuehren";"DE48733500000600600600";"BYLADEMAAAA";10;;;"NOTPROVIDED"
You can then use the script like so:
$ npx -q bank-csv-to-ynab dkb_sample_line_DKB.csv
"Date","Payee","Memo","Outflow","Inflow"
"10/02/2018","Hans Foo","Semestergebuehren","50",""
"10/03/2018","Foo Hans","Semestergebuehren","","10"