zilverline-mt940's Introduction

MT940

Full parser for MT940 files, see MT940. This is based on the original gem of Frank Oxener - Agile Dovadi BV but completely redesigned and extended.

The following Dutch banks are implemented:

ABN Amro
ING
Rabobank
Triodos

Usage

With the file name as argument:

file_name = '~/Downloads/ing.940'

@parse_result = MT940::Base.parse_mt940(file_name)

or with the file itself:

file_name = '~/Downloads/ing.940'

file = File.open(file_name)

@parse_result = MT940::Base.parse_mt940(file)

after parsing:

@parse_result.each do |account_number, bank_statements|
  puts "Account number #{account_number} has #{bank_statements.size} bank statements"
  bank_statements.each do |bank_statement|
    puts "Bank statement has balance of #{bank_statement.previous_balance.amount} at date #{bank_statement.previous_balance.date}"
    bank_statement.transactions.each do |transaction|
      # do something with transaction
      # ...
    end
    puts "Bank statement has new balance of #{bank_statement.new_balance.amount} at date #{bank_statement.new_balance.date}"
  end
end

Independent of the bank
- a parse_result consists of:
  - a map with account numbers as key and a list of BankStatements (http://en.wikipedia.org/wiki/Bank_statement)
  - A BankStatement is a summary of financial transaction in a certain period of time.
    - It is a Struct
    - It contains a previous_balance (Balance) and a new_balance (Balance)
    - It has a list of Transactions
      - a transaction always consists of:
        
        accountnumber
        
        bank (for example Ing, Rabobank or Unknown)
        
        date
        
        amount (which is negative in case of a withdrawal)
        
        description
        
        contra account
With the Rabobank its owner is extracted as well.