An MT940 bank statement parser for PHP 5.3
You can install Jejik/MT940 using Composer. You can read more about Composer and its main repository at
http://packagist.org. First install Composer for your project using the instructions on the
Packagist home page, then define your dependency on Jejik/MT940 in your composer.json
file.
{
"require": {
"jejik/mt940": ">=0.1"
}
}
This library follows the PSR-0 standard. You will need
a PSR-0 compliant autoloader to load the Jejik/MT940 classes. Composer provides one for you in your
vendor/.composer/autoload.php
.
<?php
use Jejik\MT940\Reader;
$reader = new Reader();
$statements = $reader->getStatements(file_get_contents('mt940.txt'));
foreach ($statements as $statement) {
echo $statement->getOpeningBalance()->getAmount() . "\n";
foreach ($statement->getTransactions() as $transaction) {
echo $transaction->getAmount() . "\n";
}
echo $statement->getClosingBalance()->getAmount() . "\n";
}
The returned statements have the following properties. Not all banks supply
all properties (e.g. only few provide a transaction book date separately).
Properties that are not supplied will be null
.
Jejik\MT940\Statement
getNumber()
Statement sequence numbergetAccount()
Account numbergetOpeningBalance()
AJejik\MT940\Balance
instancegetClosingBalance()
AJejik\MT940\Balance
instancegetTransactions()
An array ofJejik\MT940\Transaction
instances
Jejik\MT940\Balance
getCurrency()
3-letter ISO 4217 currency codegetAmount()
Balance amountgetDate()
Balance date as a\DateTime
object
Jejik\MT940\Transaction
getContraAccount()
Contra account numbergetAmount()
Transaction amountgetDescription()
Description textgetValueDate()
Date of the transaction as a\DateTime
getBookDate()
Date the transaction was booked as a\DateTime
Currencly there are statement parsers for the following banks:
- ABN-AMRO
- ING
- Rabobank
- SNS
- Triodos bank
You can easily add your own parser to the statement reader.
<?php
use Jejik\MT940\Reader;
$reader = new Reader();
$reader->addParser('My bank', 'My\Bank');
When you add your own parser, the default list of parsers is cleared. You must add them back if you want the reader to support them as well.
<?php
$reader->addParsers($reader->getDefaultParsers());
You can also add your parser at a specific place in the parser chain. For example, this is how you add your parser before the ING parser.
<?php
$reader->addParsers($reader->getDefaultParsers());
$reader->addParser('My bank', 'My\Bank', 'ING');
Custom parsers should extend the Jejik\MT940\Parser\AbstractParser
class.
Have a look at the parsers already implemented to see how to support your
bank. At the very minimum, you should define the statementDelimiter
property
and implement the accept()
method.
<?php
namespace My;
use Jejik\MT940\Parser\AbstractParser;
class Bank extends AbstractParser
{
protected $statementDelimiter = '-';
public function accept($text)
{
return strpos($text, 'MYBANK') !== false);
}
}
If you have written a parser for your bank, I'd be happy to add it to the list of default parsers. Just send me a Pull Request with your parsers. Make sure that you also add a unit test for it that parses a test document. You can redact personal information from the test document (e.g. use '123456789' for the account number, etcetera.
I am also happy to implement a parser for you, if you prefer that. Just open an issue and I will contact you privately. I will need an unredacted MT940 file from your bank. It needs to be unredacted because the MT940 isn't well defined and can be fickle. If you redact it, it is possible that the parser I write will work on the file you supplied but not on the real thing. Of course, I will redact the file for you when I add it to my unit tests.
Do not add unredacted MT940 files in the issue tracker please. Send them to me privately. My e-mail address is listed in the source code files.
Jejik\MT940 is licensed under the MIT license. See the LICENSE.txt file for the full details. The test files for the ABN-AMRO, ING, Rabobank and Triodos bank come from the dovadi/mt940 ruby parser. Their license can be found in the LICENSE.fixtures.txt file.