Skip to content

Small script to convert MT940 files to csv table

License

Notifications You must be signed in to change notification settings

qubrat/mt940_to_csv

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 

Repository files navigation

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.