Skip to main content

XLS Format

The XLS (Excel) format provides a user-friendly way to prepare payment data using spreadsheet software. This format is ideal for manual data entry and small batches, as the Excel file is then converted to MOKESIS format for import.

Overview​

How XLS format works:

  1. 📊 Prepare payment data in Excel (.xls)
  2. 📋 Copy data to text format
  3. 💾 Save as .mokesis file
  4. ⬆️ Import into Paysera

The XLS format uses the same field structure as MOKESIS format, but provides a visual spreadsheet interface for easier data entry.

File Requirements​

Basic Specifications​

  • Source format: .xls (Excel)
  • Target format: .mokesis (after conversion)
  • Encoding: UTF-8
  • Field separator: TAB character (when copied)
  • Structure: Same as MOKESIS (31 fields)

Required Software​

  • Microsoft Excel
  • LibreOffice Calc
  • Google Sheets (export as .xls)
  • Any spreadsheet application

Step-by-Step Guide​

Step 1: Download Template​

Download the official Excel template:

📥 Download .xls template

The template includes:

  • Column headers (field names)
  • Example data
  • Proper formatting
  • All 31 MOKESIS fields

Step 2: Fill in Payment Data​

Open the template and enter your payment information:

ColumnFieldExample Value
ANumberPAY001
BDate20231215
CTransaction date20231215
DPayment type1
EPayer's accountLT123456789012345678
FPayer's nameJohn Doe
.........

Important rules:

✅ Enter data from row 2 onwards (row 1 contains headers)
✅ Keep all columns, even if empty
✅ Follow date format: YYYYMMDD
✅ Amounts in cents only
✅ Do NOT delete empty columns

Step 3: Select and Copy Data​

  1. Select payment rows (from first payment to last)
  2. Do NOT include header row (row 1)
  3. Copy the selection (Ctrl+C / Cmd+C)

Example selection:

From: Row 2 (first payment)
To: Row with last payment

Step 4: Convert to MOKESIS Format​

Option A: Direct method

  1. Open text editor (Notepad, TextEdit)
  2. Paste copied data (Ctrl+V / Cmd+V)
  3. Save as: transfers.mokesis
  4. Ensure UTF-8 encoding

Option B: Via .txt

  1. Paste data to text editor
  2. Save as: transfers.txt
  3. Rename file: transfers.txt → transfers.mokesis

Step 5: Import File​

Upload the .mokesis file to Paysera system.

Field Structure​

The XLS format uses the same 31 fields as MOKESIS format:

Mandatory Fields​

ColumnFieldFormatExample
ANumberC10PAY001
CTransaction dateYYYYMMDD20231215
DPayment type1 or 21
EPayer's accountIBANLT123456789012345678
MBeneficiary's accountIBANLT987654321098765432
NBeneficiary's nameTextJane Smith
UAmountCents10000
VCurrencyISO 4217EUR
XPayment detailsTextInvoice payment

Optional Fields​

All other fields (F, G, H, etc.) are optional but should not be deleted from the spreadsheet.

For complete field specification, see MOKESIS format documentation.

Important Requirements​

📅 Date Format​

Correct:

20231215  (December 15, 2023)
20240101  (January 1, 2024)

Incorrect:

2023-12-15
15/12/2023
12.15.2023
2023 12 15

💰 Amount Format​

Convert amount to cents (no decimals):

AmountCorrectIncorrect
€10.00100010.00
€50.25502550.25
€1,234.561234561,234.56

🏦 Account Format​

Use IBAN format for accounts:

LT123456789012345678  ✅
LT 12345678901234567  ❌ (spaces)
EVP1234567            ❌ (Paysera format - needs conversion)

📝 Transfer Dates​

  • Transfer date (column B): Date of file creation
  • Transaction date (column C): When payment should be executed
  • Transaction date can be up to 2 years in future
  • Both dates must be in YYYYMMDD format

Example: Creating Excel File​

Excel Spreadsheet View​

ABCDEFG...MN...UV...X
NumberDateTrans DateTypePayer AccPayer NamePayer Code...Benef AccBenef Name...AmountCurr...Details
PAY00120231215202312151LT123...Company A...LT987...Supplier 1...5000EUR...Invoice #001
PAY00220231215202312151LT123...Company A...LT888...Supplier 2...7500EUR...Invoice #002
PAY00320231215202312202LT123...Company A...LT777...Supplier 3...12000EUR...Urgent payment

After Conversion to .mokesis​

PAY001	20231215	20231215	1	LT123456789012345678	Company A			LT987654321098765432	Supplier 1			5000	EUR		Invoice #001	
PAY002	20231215	20231215	1	LT123456789012345678	Company A			LT888888888888888888	Supplier 2			7500	EUR		Invoice #002	
PAY003	20231215	20231220	2	LT123456789012345678	Company A			LT777777777777777777	Supplier 3			12000	EUR		Urgent payment

Note: Fields are separated by TAB characters (shown as extra spacing above).

Common Mistakes and Solutions​

❌ Mistake: Including header row​

Problem: Header row copied with data
Solution: Copy only from row 2 onwards

❌ Mistake: Deleting empty columns​

Problem: File structure doesn't match MOKESIS format
Solution: Keep all columns, even if empty

❌ Mistake: Wrong date format​

Problem: Using 2023-12-15 instead of 20231215
Solution: Use YYYYMMDD format without separators

❌ Mistake: Decimal in amount​

Problem: Entering 100.50 instead of 10050
Solution: Convert to cents (multiply by 100)

❌ Mistake: Wrong file extension​

Problem: Saving as .txt or .xls
Solution: Rename to .mokesis extension

❌ Mistake: Special characters in names​

Problem: Using unsupported characters
Solution: Use standard Latin characters only

Country-Specific Requirements​

When creating payments to certain countries, add additional data:

Poland (PLN Transfers)​

Fill columns for fields 26-28:

  • Column Z: City
  • Column AA: Address
  • Column AB: Country code (PL)

Czech Republic (CZK Transfers)​

Fill columns for fields 29-31:

  • Column AC: Client type (natural/legal)
  • Column AD: Postal code
  • Column AE: Purpose code

See MOKESIS format for details.

Advantages and Limitations​

✅ Advantages​

  • User-friendly - Familiar Excel interface
  • Visual editing - See all data in table format
  • Easy validation - Spot errors before conversion
  • Formulas support - Use Excel formulas for calculations
  • Template available - Official Excel template provided
  • No technical skills - Anyone can use Excel

⚠️ Limitations​

  • Manual conversion - Need to copy-paste to .mokesis
  • Small batches only - Best for up to ~100 payments
  • No automation - Each file needs manual processing
  • Excel required - Need spreadsheet software

When to Use XLS​

✅ Use XLS format for:

  • Manual payment preparation
  • Small number of payments (< 100)
  • One-time imports
  • When you have Excel available
  • Learning how payment import works

❌ Use other formats for:

  • Large batches (> 100 payments) → MOKESIS
  • Automated imports → XML
  • System integration → XML or MOKESIS
  • International transfers with routing → TARESIS

Tips and Best Practices​

💡 Tips​

  1. Keep template - Save original template for reuse
  2. Start small - Test with 2-3 payments first
  3. Double-check amounts - Remember to use cents!
  4. Verify IBANs - Use IBAN validator before import
  5. Save backup - Keep Excel file after conversion
  6. Use examples - Follow provided example data

✅ Best Practices​

  • Save Excel file with meaningful name (e.g., 2023-12-salaries.xls)
  • Keep a copy of both .xls and .mokesis files
  • Verify dates are not in the past
  • Check all mandatory fields are filled
  • Test import with small file first
  • Review imported payments before confirmation

Complete Field Specification​

The XLS format contains 31 fields matching the MOKESIS format. Below is the complete specification:

Field Reference Table​

RowFieldSizeRequiredDescription
1NumberC10✅Unique payment number
2DateC8Format: YYYYMMDD
3Transaction dateC8✅Format: YYYYMMDD
4Payment type (priority)N1✅1 – Standard, 2 – Urgent
5Payer's account numberC35✅IBAN format
6Payer's nameC200Name and surname / Company name
7Payer's personal code / Registration No.C11Personal (legal entity's) code
8Payer's credit institutionC11Bank code
9Customer's code in beneficiary's systemC16Custom identifier
10Originator's account numberC35Account number
11Originator's nameC140Name and surname / Company name
12Originator's personal codeC11Personal (legal entity) code
13Beneficiary's account numberC35✅IBAN format
14Beneficiary's nameC200✅Name and surname / Company name
15Beneficiary's personal codeC11Personal (legal entity) code
16Beneficiary's credit institutionC11Bank code
17Customer's code in payer's systemC16Custom identifier
18Beneficiary party account numberC35Account number
19Beneficiary party nameC140Name and surname / Company name
20Beneficiary party personal codeC11Personal (legal entity) code
21AmountN14✅In cents (no decimal separator)
22Currency codeC3✅ISO 4217 code (e.g., EUR, USD)
23Fee codeC28Fee code
24Payment detailsC300✅Payment purpose/description
25Archive codeC50Transaction code (export only)
26CityC255*Beneficiary city (required for PLN)
27AddressC200*Beneficiary address (required for PLN)
28CountryC2*ISO 3166 country code (required for PLN)
29Client typeC7*"natural" or "legal" (required for CZK)
30Postal codeC10*Postal code (required for CZK)
31Purpose codeC50*Purpose codes list (required for CZK)

Legend:

  • C = Character/text field
  • N = Numeric field
  • ✅ = Mandatory field
  • * = Required only for specific currencies (PLN, CZK)

Field Size Notation​

  • C10 = Text field, maximum 10 characters
  • N14 = Numeric field, maximum 14 digits
  • C35 = Text field, maximum 35 characters

Downloads​

Official Files​

📥 Download .xls template - Official Excel template with all 31 fields

📥 Download .mokesis example - Example of converted MOKESIS file

Quick Reference​

Troubleshooting​

File won't import​

  1. Check file extension is .mokesis
  2. Verify UTF-8 encoding
  3. Ensure TAB separation (not spaces)
  4. Check mandatory fields are filled

Data looks wrong after paste​

  1. Ensure you copied from Excel with Ctrl+C
  2. Paste into plain text editor (not Word)
  3. Check TAB characters are preserved
  4. Verify line breaks are correct

Amounts are incorrect​

  1. Remember to use cents (multiply by 100)
  2. No decimal points or commas
  3. Only numbers in amount field

Need Help?​

Support Contacts​

Additional Resources​

Next Steps​

  1. Download template → - Get Excel file
  2. Fill in your payments - Follow this guide
  3. Convert to .mokesis - Copy and save
  4. Import to Paysera - Upload file
  5. Verify and confirm - Check imported payments