Norma43 is the standard format file to extract bank transactions from the SEPA (Single euro payments area), format details and content is described in the Norma43 format.
Include it in your Gemfile
gem 'norma43_parser', git: "git@github.com:sequra/norma43_parser.git"
require "norma43"
norma43_file_contents = File.open("path_to_file.n43", encoding: "iso-8859-1")
document = Norma43.parse norma43_file_contentsThe parser returns a Norma43 Document that may include multiple accounts.
accounts=[account1..accountN]
The account object has all the information described in the standard format and the transactions between start_date and end_date.
abbreviated_name="ACCOUNT NAME",
account_number=1234567,
balance_amount=504585,
balance_code=2,
bank_code=81,
branch_code=54,
credit_amount=254785,
credit_entries=45,
currency_code=978,
debit_amount=0,
debit_entries=0,
start_date=Tue, 04 Feb 2016,
end_date=Tue, 04 Feb 2016,
information_mode_code=3,
transactions=[transaction1..transactionN]
Also, accounts know their full IBAN. For the example above, #iban returns "ES5400810054180001234567".
The transaction object has all the information described in the standard format and may include a maximum of five additional items.
additional_currency=nil,
amount=3206,
amount_code=2,
document_number=0,
origin_branch_code=123,
own_item=16,
reference_1=0,
reference_2=nil,
shared_item=4,
transaction_date=Tue, 04 Feb 2016,
value_date=Tue, 04 Feb 2016,
additional_items=[additional_item1..aditional_item5]
The additional item object has an identifier and two free text fields that may include or not relevant information
data_code=1,
item_1="TRANSFERENC. ANTONIO JOSE GARCIA MARTI",
item_2="NEZ"
- Fork it ( https://github.com/sequra/norma43_parser.git )
- Create your feature branch (
git checkout -b my-new-feature) - Commit your changes (
git commit -am 'Add some feature') - Push to the branch (
git push origin my-new-feature) - Create new Pull Request