/ing-parser

Extrage valori structurate din rapoarte tranzacții ING Bank

Primary LanguagePython

Extrage valori structurate din ING Bank Home'Bank Raport tranzacții (xls)

Exportă tranzacții

ing-parser.py

python ing-parser.py <path/to/input/xls/x> -o <output_file> -f <xlsx|csv|json>

optional arguments

  • -f format [xlsx, csv, json] default/implicit: xlsx
  • -o output filename

ing-parser.html

js / browser based (buggy, WIP)

→ DEMO (descarcă și folosește offline)

js/html version

Features / Roadmap

  • extract fields
  • save as xlsx / json / csv
  • add params
  • enhance xlsx, freeze 1st row, add filters – use openpyxl
  • clean-up original ING xls
  • extract currency
  • extract businesses names from Terminal (before RO?)
    • business list francizes (with ID in name). Regex? – Ex: OMV, KAUFLAND, LIDL, Glovo, LUCA etc
  • categorize events / expenses
  • custom, personal categorization rules
  • extract adress info (country, county, internet)
  • handle exceptions
    • check input file type
    • check input file structure before processing?
  • batch convert
  • add sample transactions xlsx
  • save - detect account number?
  • consolidate to db / csv?
    • stats / dashboard
  • browser / client-side (buggy)
    • FIXME: detect all properties
    • minimal stats
    • github.io demo (with inline vendor js) / PWA
    • build process for standalone / offline version
      • Github Actions to update github.io
    • local csv repository
    • overall stats / dashboard
  • sync external data
    • trezorerie, known accounts db?
    • link to registrul comertului, termene by CUI?
    • interbank exchange rate
  • remove empty columns?
  • extend to other banks?
    • ING
    • Raiffeisen
  • desktop app?
  • convert to HomeBank – custom csv.
available_fields = ["Tip tranzactie", "Autorizare", "Banca", "Beneficiar", "Data", "Data valutei", "Detalii", "Din contul", "In contul", "Nr. card", "Ordonator", "Rata", "Rata ING", "Referinta", "Suma", "Suma transmisa spre decontare", "Terminal", "Cod Fiscal Platitor", "Impozit pe dobanda"]

tip_tranzactie = ["Cumparare POS", "Incasare", "Retragere numerar", "Taxe si comisioane", "Transfer", "Transfer Home'Bank", "Depunere numerar", "Comision pe operatiune", "Schimb valutar", "Acoperire sold", "Plata poprire", "Actualizare dobanda"]

Câmpuri

  • Data
  • Detalii tranzactie
    • Tip tranzactie
      • Cumparare POS
      • Incasare
      • Retragere numerar
      • Taxe si comisioane
      • Transfer Homebank
    • Autorizare
    • Banca
    • Beneficiar
    • Data
    • Data valutei
    • Detalii
    • Din contul
    • In contul
    • Nr. card
    • Ordonator
    • Rata
    • Rata ING
    • Referinta
    • Suma
    • Suma transmisa spre decontare
    • Terminal
  • Debit
  • Credit
  • Balanta

See also

GPT threads: 1, 2; Similar work / inspiration: topics/homebank, cwverhey/HomeBankCSV, Binnette/homebank-converter, sercxanto/go-homebank-csv