Switch to mobile version. Top

Business

Structure of the imported file of a bank account statement in LITAS-ESIS text format

Important

  1. Usually, an account statement consists of three parts: the header, body and footer.
  2. If no transactions were carried out, the statement consists of the header, body with row type 020 (Balance) and footer.
  3. The field Transaction / Balance Type is not required as every bank uses its own identifier.
  4. The maximum length of fields is specified (each field is separated by TAB  (#9).
  5. No TAB  (#9) characters can be used in field values.
  6. Currency: character currency code according to ISO standards (for instance, LTL — litas).
  7. The file extension must be acc (any name can be used).
  8. The text uses the Windows 1257 code table.

Header

No Name Amount Comments Explanation of format
1. Row type C3* 000
(header tag, triple zero)
* — required field
C — character field
2. Date N8* Date of request
YYYYMMDD
* — required field
C — character field
YYYY — year in four digits
MM — month in two digits
DD — day in two digits
3. Time N6 Time of request
HHMMSS
N — number field
HH — hours
MM — minutes
SS — seconds
Credit institution information
4. BIC C11* According to LITAS-BIC * — required field
C — character field
5. Name C100* Name of credit institution of account statement * — required field
C — character field
6. Registration No C11* Registration number of credit institution of account statement * — required field
C — character field
7. Address C100 Address of credit institution of account statement C — character field
8. Town C100 Town of credit institution of account statement C — character field
9. Other information C100 Any information C — character field
Customer information
10. CIF N10 Customer's identification number N — number field
11. Name C200* Account holder's name * — required field
C — character field
12. Personal identity number / Registration No C11* Account holder’s registration or personal identity number * — required field
C — character field
13. Address C100 Account holder's address C — character field
14. Town C100 Account holder's address C — character field
15. Other information C100 Account holder's town C — character field
Account information
16. Unit of credit institution C50 Name of unit of credit institution C — character field
17. Account (IBAN) C35* IBAN number of statement's account or card number * — required field
C — character field
18. Currency C3* Currency of transactions included in statement * — required field
C — character field

Body

No Name Amount Comments Explanation of format
1. Row type C3* 010 (Transaction)
020 (Balance)
* — required field
C — character field
2. Transaction / Balance type C20* Payment order, Int. order, ATM, cash desk, closing / opening balance * — required field
C — character field
3. Date C8* Date of transaction
YYYYMMDD
* — required field
C — character field
YYYY — year in four digits
MM — month in two digits
DD — day in two digits
4. Time N6 Time of transaction
HHMMSS
N — number field
HH — hours
MM — minutes
SS — seconds
5. Amount N14* No point or comma separator for cents.
50.25 is represented as 5025.
* — required field
N — number field
6. Equivalent N14 No point or comma separator for cents. 50.25 is represented as 5025. N — number field
7. C/D C2* C — credit (into account)
D — debit (out of account)
* — required field
C — character field
8. Orig. amount N14 Orig. trx. Amount. No point or comma separator for cents. 50.25 is represented as 5025. N — number field
9. Orig. currency C3 Orig. trx. currency C — character field
10. Transaction doc. No C10 Document number C — character field
11. Transaction row (identifier) C50* Unique transaction archive number * — required field
C — character field
12. Customer's code in information system C16 Code agreed by the payer and beneficiary which helps the beneficiary identify the payer C — character field
13. Payment code C28 Payment code specified by customer C — character field
14. Purpose of payment C300* Purpose of payment specified by customer * — required field
C — character field
Counterparty Group
15. BIC C11 BIC of counterparty's credit institution C — character field
16. Name of credit institution C100 Name of counterparty's credit institution C — character field
17. Account No C35 Counterparty's account No C — character field
18. Name C200 Name of counterparty C — character field
19. Personal identity number / Registration No C11 Registration or personal identity number of counterparty C — character field
20. Customer's code in payer's information system C16 Code agreed by the payer and beneficiary which helps the payer identify the beneficiary C — character field
Original Payer Group
21. Account No C35 Original payer's account number C — character field
22. Name and surname / Name C140 Original payer's name and surname / Name C — character field
23. Personal identity number / Registration No C11 Registration or personal number of original payer C — character field
Final Beneficiary Group
24. Account No C35 Final beneficiary's account number C — character field
25. Name and surname / Name C140 Final beneficiary's name and surname / Name C — character field
26. Personal identity number / Registration No C11 Registration or personal identity number of final beneficiary C — character field

Note. If the row is type 020 (Balance), only fields No 3 and 5 are required.

Footer

No Name Amount Comments Explanation of format
1. Row type C3* 999
(footer tag, triple nine)
* — required field
C — character field
2. Reference amount N12* The sum total of each amount in the fifth field (Amount) of content row (last 12 positions) * — required field
N — number field

Abbreviations

If the value of the Row Type field is 020 (Balance), the values of the Transaction / Balance Type field entered by the bank can be:

Opening Balance: opening balance of the account until the day specified in the Date field Last trx date: date of the last transaction
Opening Balance: opening balance of the account until the day specified in the Date field  

OVD: information on the use of the account overdraft on the day specified in the Date field. The value of entries of this type in the Amount field is always zero (0) and all information is provided in the Purpose of Payment field.

If the value of the Row Type field is 010 (Transaction), possible values of the Transaction / Balance Type field entered by the bank can be found in the following document:

LITAS-ESIS tekstinio formato sąskaitų išrašų failo operacijų pavadinimų (failo turinio laukas Nr.2) sąrašas (PDF, 95KB)

S|E|B

Attention! Your web browser does not correspond to the requirements needed to visit SEB website. Please change web browser or device that you use for browsing the site.

Attention! Your web browser does not correspond to the requirements needed to visit SEB website. Please change web browser or device that you use for browsing the site.