/mt940_to_csv

Small script to convert MT940 files to csv table

Primary LanguagePythonMIT LicenseMIT

Simple MT940 to CSV Converter

Description

This project contains the process.py script, which performs processing of transaction info provided by a bank. Files need to be located in ./data folder. The script will read the files, process the data and save the results in a CSV file.

Output fields:

  • Account
  • Transaction date
  • Transaction amount
  • Transaction currency
  • Currency rate (to PLN)
  • Transaction ID
  • Transaction title

Currency rate is obtained from the NBP API and references values according to PLN. Reference here.

Usage

To use the process.py script, follow these steps:

  1. Clone the repository to your local machine:
git clone https://github.com/qubrat/mt940.git
  1. Navigate to the project directory:
cd mt940_to_csv
  1. Install the required modules:
pip install -r requirements.txt
  1. Run the process.py script:
python process.py

Return Value

The process.py script returns results in a csv file results.csv located in the root folder.