If you are a business owner or an accountant, you may be familiar with the MT940 file format used by banks to export transaction data. For me personally this format got interesting because I am using Firefly III for my finances and the CSV file my bank provided me needed a lot of tweaking to be able to be imported in Firefly III.
MT940 files are widely used, but they are not very user-friendly. Converting MT940 files to more accessible formats like CSV can help you analyze and manage your financial data more efficiently.
If you are looking for a solution to convert your MT940 files to CSV, you are in luck! In this blog post, I will introduce you to a PHP script that can help you do just that. I will also guide you through the process of using this script to convert your MT940 files to CSV.
The PHP script is called "mt940-to-csv.php." It is an open-source script that allows you to convert MT940 files to CSV with just a few lines of PHP code. The script is easy to use and can be customized to suit your specific needs.
You can get access to the MT940 to CSV conversion script on Github: https://github.com/terencejackson8000/mt940-to-csv
Once you have downloaded the script, or forked it, you can run it with the following command:
php mt940-to-csv.php -i=<path to input> -o=<path to output>
At the moment this is still in a development phase and there are plans to enhance it like adding additional data gatherings for the SEPA mandate and to provide more options for the CSV output.