Electronic SAF-T Report Version for country version Lithuania

The program 'Standard Audit File. Create' (AAS300) is used for the creation of audit files required in different countries. The sections to be included can be selected. When the user confirms the selection, a batch job will create the requested file and save it in the MVXFILETRANSFER folder.

Background

Lithuanian Standard Audit File - Tax (SAF-T) Financial is a standard format for the exchange of accounting data. The Government of the Republic of Lithuania by Resolution No. 699 approved the Procedure for the submission of accounting data in the standard accounting data file, which established the procedures and cases for reporting accounting data in the standard accounting data file.

The Lithuanian tax administration will use the standard for tax audit. The standard specifies the accounting data to be exchanged and the data structure that contributes to a common understanding between the provider and the recipient of the information to be exchanged. The Lithuanian version of the standard is developed in collaboration with the Lithuania Tax Administration, the business community, and the accounting industry.

The report is in XML format and is validated against the Lithuania_SAF-T_Financial_Schema_v_1.00.xsd schema published by the Lithuanian Tax Administration.

Other country-specific SAF-T version 2 schemas are not implemented in M3 BE (see Limitations).

Follow these steps to create XML file for SAF-T version 2

  1. Open (AAS300) to select the sections to be included.

  2. Select the following and click Next or press Enter to confirm the panel:

    Field Field description
    Output file rep Select 8-'SAF-T version 2'.
    Accounting period From - To Enter the From/To period to be included.
  3. Select the following for the sections to be included:

    Field Field description
    Base country Select the country for which the report must be created.
    General Ledger Select the check box to include voucher information for General Ledger.
    Accounts Receivable Select the check box to include sales invoice information from General Ledger.
    Accounts Payable Select the check box to include sales invoice information from General Ledger
    Payment Select the check box to include supplier and customer payments except payment variances coming from write-offs or rounding off transactions.
    Chart of accounts Set to 1-'All' or 2-'Current year' to include details and opening/closing balance for the chart of accounts.
    Customer master table Set to 1-'All' or 2-'Current year' to include details and opening/closing balance for the customers.
    Supplier master table Set to 1-'All' or 2-'Current year' to include details and opening/closing balance for the suppliers.
    Language Specify the language code in which the description should be retrieved from (CRS632). (optional)
    File name

    Must end with .XML.

    See 'Limitations' for file name required by the Lithuanian tax administration.

    Folder name Specify a name or leave this field blank. The folder must be located in the folder used for MVXFILETRANSFER and set up before the report is submitted.
    Header information – status Must be set to 1-'Select'.
    Master tables – status Must be set to 1-'Select' if master tables (that is, 'Chart of accounts', 'Customer', 'Supplier', and 'VAT code percentages') are included.
    Chart of accounts – status Set to 1-'Select' if chart of accounts should be included.
    Customer master table – status Set to 1-'Select' if customers should be included.
    Supplier master table – status Set to 1-'Select' if suppliers should be included.
    VAT code percentages – status Set to 1-'Select' if VAT code percentages should be included.
    General Ledger – status Set to 1-'Select' if general ledger should be included.
    Accounts Receivable – status Set to 1-'Select' if accounts receivable should be included.
    Accounts Payable – status Set to 1-'Select' if accounts receivable should be included.
    Payment – status Set to 1-'Select' if accounts receivable should be included.
    Assets transaction – status Set to 1-'Select' if fixed assets transaction should be included.
    Movement of good – status Set to 1-'Select' if stock transactions should be included.
  4. Click Next or press Enter to start the creation of the XML file.

The XML file will automatically be placed in the folder used for MVXFILETRANSFER or in the specified subfolder.

Limitations

Overview of the structure and content of the report

Structure XML element Content
AuditFile   Created once per audit file with SAF-T report file details.
Header   Created once per audit file with report details. Details from 'Tax Reporting. Open Report Fields' (TXS035).
  Company Details of the issuer of the report. Details from 'Company. Connect Division' (MNS100) and (TXS035).
  SelectionCriteria Details about the report selection. Details from 'Standard Audit File. Create' (AAS300) and (TXS035).
MasterFiles   Created once per audit file if master tables (that is, 'Chart of accounts', 'Customer', 'Supplier', and 'VAT code percentages') are included.
  GeneralLedgerAccounts Created once per audit file with details of the chart of accounts defined at central (blank division) or local level.
  GeneralLedgerAccounts/Account

Details of each account ID (that is, accounting dimension 1) including opening/closing balance. Details from 'Accounting Identity. Open' (CRS630), if selected from 'Accounting ID. Enter Names/Language' (CRS632) with balances from the FBAVAL table.

See 'Account translation scenario in (GLS030)' under 'Configuration' for information about 'StandardAccountID'.

  Customers Created once per audit file with details about customers.
  Customers/Customer Details of each customer including opening/closing balance. Details from 'Customer. Open' (CRS610) with balances from the FSLBAL table.
  Suppliers Created once per audit file with details about suppliers.
  Suppliers/Supplier Details of each supplier including opening/closing balance. Details from 'Supplier. Open' (CRS620) with balances from the FPLBAL table.
  TaxTable Created once per audit file with details about VAT codes.
  TaxTable/TaxTableEntry Created once per tax table with details about VAT codes.
  TaxTable/TaxTableEntry/TaxCodeDetails Details of each VAT code and From date defined with VAT percentage for the division of the report. Details from 'VAT Rate. Open' (CRS031).
  UOMTable Created once per audit file with details about Units of Measure.
  UOMTable/UOMTableEntry Details of each unit of measure included in movement of goods transactions. Details from ‘Unit of Measure. Open’ (CRS050).
  MovementTypeTable Created once per audit file with details about Movement type.
  MovementTypeTable/ MovementTypeTableEntry Details of each movement type record for each transaction ID. Details from 'Business Message Mapping. Open' (CMS880).
  PhysicalStock Created once per audit file with details about Physical stock.
  PhysicalStock/PhysicalStockEntry Details of each physical stock entry. Details from ‘Inventory Valuation. Open’ (CAS180).
GeneralLedgerEntries   Created once per audit file with details about vouchers in the general ledger.
  Journal Details of each journal in the FGLEDG table.
  Journal/Transaction Details of each voucher in the FGLEDG table.
  Journal/Transaction/Line Details of each voucher line in the FGELDG table.
SourceDocuments   Created once per audit file with details about vouchers in the General Ledger.
  SalesInvoices Created once per audit file with details about sales invoices in the General Ledger.
  SalesInvoices/Invoice Details of each sales invoice number in the FSLEDG table.
  SalesInvoices/Invoice/Line Details of each sales invoice line in the FSLEDG table.
  PurchaseInvoices Created once per audit file with details about purchase invoices in the General Ledger.
  PurchaseInvoices/Invoice Details of each purchase invoice number in the FPLEDG table.
  PurchaseInvoices /Invoice/Line Details of each purchase invoice line in the FPLEDG table.
  Payments Created once per audit file with details about payments in the General Ledger.
  MovementOfGoods Created once per audit file with details about movement of goods in the stock transaction table.
  MovementOfGoods/StockMovement Created once per movement of goods file with details about stock transaction table.
  MovementOfGoods/StockMovement/Line Details of each stock movement from ‘Stock transaction history’ (MITTRA) and ‘Internal account’ table (CINACC).
  AssetTransactions Created once per audit file with details about fixed asset transactions.
  AssetTransactions/AssetTransactionsTableEntry Details from fixed assets depreciation rule table (FFASDM) together with its corresponding information from the fixed asset master file (FFASMA) and value per period (FFAHIS).

Opening and closing balances

This table shows information about opening and closing balances:

Section Details
MasterFiles/GeneralLedgerAccounts

OpeningDebit/CreditBalance and ClosingDebit/CreditBalance per account are included and retrieved from the FBAVAL table using balance key 1 and the fields 'Recorded amount – Debit' (ACAD) and 'Recorded amount – Credit' (ACAC).

With 8-'SAF-T version 2' for output format and 'Chart of accounts' for master table, the system checks in (AAS300) that the annual run in 'GL Balance File. Start Annual Run' (GLS905) for the previous year exists.

MasterFiles/Customers

OpeningDebit/CreditBalance and ClosingDebit/CreditBalance per customer are included and retrieved from table FSLBAL and field 'Outstanding amount in local currency' (OUAM).

With 8-'SAF-T version 2' for output format and 'Customer' for master table, the system checks in (AAS300) that the annual run in 'AR Balance File. Start Annual Run' (ARS910) for the previous year exists.

MasterFiles/Suppliers

OpeningDebit/CreditBalance and ClosingDebit/CreditBalance per supplier are included and retrieved from the FPLBAL table and the field 'Outstanding amount in local currency' (OUAM).

With 8-'SAF-T version 2' for output format and 'Supplier' for master table, the system checks in (AAS300) that the annual run in 'AP Balance File. Start Annual Run' (ARS910) for the previous year exists.

File name and size

This table shows country specific requirements or recommendations for the file name and file size that must be handled manually when the XML file has been created:

Country File name File size
Lithuania

It is strongly recommended to use the following naming convention to ensure all necessary information is included in the file name. The purpose is to identify what data are in the file, to identify who the recipient of the data is, and to create a unique file name for each export. Note that the naming must be handled manually by the user outside of M3 BE when the XML file has been created.

<SAF-T export type>_<organization number of the vendor who the data represent>_<date and time(yyyymmddhh24hmise>.xml

For example: _SAF-T Financial 999999999 _20160401235911.xml

Where "SAF-T Financial" states the SAF-T type of file, "999999999" represents the organization number belonging to the owner of the data, and "20180401235911" represents the date and time when the file was created using a 24-hour clock.

The general ledger entries are expected to constitute the larger part of the file, with a rough estimate of 1 GB per million records in FGLEDG (worst case scenario with regards to currency codes and description lengths, etc.). In case there is a large number of records in FGLEDG, it is possible to run (AAS300) in several steps where General Ledger may first be excluded by setting its corresponding dropdown value to 0-'Exclude'.

Header

This section contains basic data for the XML file and is created once per file. Only tags/elements populated for standard and/or country-specific information are included in the description below. See 'Configuration' for details about the information defined in (TXS035).

XML element

-

Description

(country-specific when applicable)

Required

-

Details - standard

-

Details - country specific

(exceptions to standard)

AuditFileVersion Version of standard audit file being used. Mandatory From additional field 009 in (TXS035). Set to "1.0" if missing.  
AuditFileCountry Two-letter country code according to the ISO 3166-1 alpha 2 standard. Mandatory From 'Country code ISO' (IISO) in (CRS045) for the base country (BSCD) selected in (AAS300).  
AuditFileDateCreated Date when the file was created. Mandatory From 'Registration date' (RGDT) created in (AAS300).  
SoftwareCompanyName Name of the software company whose product created the audit file. Mandatory From additional field 010 in (TXS035). Set to "NotDefined" if missing.  
SoftwareID Name of the software that generated the audit file. Mandatory From additional field 004 in (TXS035). Set to "NotDefined" if missing.  
SoftwareVersion Version of the software that generated the audit file. Mandatory From additional field 005 in (TXS035). Set to "NotDefined" if missing.  
Company - Mandatory -  
/RegistrationNumber Unique number to identify the company in the accounting records, issued by a government body or created by the company for internal purposes to identify different entities within their corporate group. Mandatory From additional field 011 in (TXS035). Set to "NotDefined" if missing.  
/Name Name of the company Mandatory From 'Company name' (CONM) in (MNS100).  
/Address - Mandatory -  
/StreetName Address line 1 of the company. Optional From 'Company address – line 1' (COA1) in (MNS100).  
/AdditionalAddressDetail Address line 2 of the company. Optional From 'Company address – line 2' (COA2) in (MNS100).  
/City Name of the city/post district. Mandatory From 'City' (TOWN) in (MNS100). Set to "NotDefined" if missing.  
/PostalCode Postal code for the relevant city/post district. Mandatory From 'Postal code' (PONO) in (MNS100). Set to "NotDefined" if missing.  
/Region Country-specific code to indicate regions or provinces within the tax authority. Optional From 'Description' (TX40) in (CRS046) for the state in (MNS100).  
/Country Two-letter country code according to ISO 3166-1 alpha 2 standard. Optional From 'Country' (CSCD) in (MNS100).  
/AddressType Type of address included. Optional Set to "PostalAddress".  
/FullAddress Address written in free text. Optional From 'Company address – line 1' (COA1) + 'Company address – line 2' (COA2) + 'Company address – line 3' (COA3) + 'Company address – line 4' (COA4) in (MNS100)  
/Contact - Mandatory -  
/Contact/ContactPerson - Mandatory -  
/ContactPerson/FirstName First name of the person. Mandatory Set to "NotUsed".  
/ContactPerson/LastName Last name of the person. If the FirstName element has the text "NotUsed" then this element should contain the full unstructured name of the person. Mandatory From additional field 024 in (TXS035) and if not defined, from 'Our reference' (OREF) in (MNS100). Set to "NotDefined" if both are missing.  
/Telephone Telephone number. Mandatory From additional field 014 in (TXS035) and if not defined, from 'Telephone number 1' (PHNO) in (MNS100). Set to "NotDefined" if both are missing.  
/Fax Fax number. Optional From additional field 015 in (TXS035) and if not defined, from 'Facsimile number' (TFNO) in (MNS100).  
/Email Email address. Optional From additional field 007 in (TXS035).  
/Website Website address. Optional From additional field 008 in (TXS035).  
/TaxRegistration - Optional -  
/TaxRegistrationNumber The company's tax registration number. Unique number issued by a revenue body for use by the company. Mandatory From additional field 012 in (TXS035) and if not defined, from 'VAT registration number' (VRNO) in (MNS100). Must be entered in the requested format.  
/TaxType Tax type of the company. For use where information reported in the SAF-T covers more than one type of tax regime: to identify the type of tax regime to which this entry relates. Optional From additional field 016 in (TXS035). ISO code = 'LT'. Tag not created since it is not used.
DefaultCurrencyCode Three-letter currency code (ISO 4217) of the local currency that is the default for the audit file. Mandatory From 'Local currency' (LOCD) in (MNS100).  
SelectionCriteria - Optional - -***
/TaxReportingJurisdiction Identifies the tax jurisdiction for whose purpose the audit file has been created. Principally for use where a single revenue body covers more than one territory. Optional From additional field 021 in (TXS035).  
/CompanyEntity For use where data have been extracted from the full data set by reference to a specific corporate entity. Optional From additional field 022 in (TXS035).  
/PeriodStart The first accounting period covered by the audit file. Mandatory From period entered in (AAS300).  
/PeriodStartYear The accounting year within which the 'PeriodStart' falls. Mandatory From year in period entered in (AAS300).  
/PeriodEnd The last accounting period covered by the audit file. Mandatory To period entered in (AAS300).  
/PeriodEndYear The accounting year within which the 'PeriodEnd' falls. Mandatory To year in period entered in (AAS300).  
HeaderComment Space for any further generic comments on the audit file. This space can also be used to include the purpose of the accounting file. Optional From additional field 006 in (TXS035).  
TaxAccountingBasis Type of data in the audit file. Invoice accounting, cash accounting, delivery, other. Mandatory From additional field 001 defined in (TXS035). Set to ' NotDefined' if missing. ISO code = 'LT': From additional field 001 in (TXS035). Set to 'A' if missing.

MasterFiles/GeneralLedgerAccounts/Account

This section is created once per account ID. Only tags/elements populated for standard and/or country-specific information are included in the description below. See 'Configuration' for details about StandardAccountID defined in 'Account Translation Scenario. Open' (GLS030).

XML element

-

Description

(country-specific when applicable)

Required

-

Details - standard

-

Details - country-specific

(exceptions to standard)

AccountID General Ledger account code/number. Mandatory From 'Accounting identity' (AITM) in (CRS630).  
AccountDescription Name of individual general ledger account. Mandatory From 'Description' (TX40) in (CRS632) for the language selected in (AAS300). If missing, from 'Description' (TX40) in (CRS630).  
AccountType Type of account. Mandatory Description set depending on account table ID setup (GLS030). Valid Options are "Fixed assets", "Current assets", "Equity capital", "Liabilities", "Income", "Expense". ISO code = 'LT': Set to 'GL'.
AccountCreationDate Date when the general ledger account was created. Optional From 'Registration date' (RGDT) in (CRS630).  

OpeningDebitBalance

or

OpeningCreditBalance

Debit or credit balance at the start date of the selection period in the default currency of the header. Mandatory Sum of debit amount (ACAD) and credit amount (ACAC) from the FBAVAL table using balance key 1. See 'Opening and closing balances above' for more information.  

ClosingDebitBalance

or

ClosingCreditBalance

Debit or credit balance at the start date of the selection period in the default currency of the header. Mandatory Sum of debit amount (ACAD) and credit amount (ACAC) from the FBAVAL table using balance key 1. See 'Opening and closing balances' above for more information.  

MasterFiles/Customers/Customer

This section is created once per customer. Only tags/elements populated for standard and/or country-specific information are included in the description below.

XML element

-

Description

(country-specific when applicable)

Required

-

Details - standard

-

Details - country-specific

(exceptions to standard)

Name The name of the customer. Mandatory From 'Name' (CUNM) in (CRS610).  
Address - Mandatory -  
/StreetName Address line 1 of the customer. Optional From 'Address – line 1' (CUA1) in (CRS610).  
/AdditionalAddressDetail Address line 2 of the customer. Optional From 'Address – line 2' (CUA2) in (CRS610).  
/City Name of the city/post district. Mandatory From 'City' (TOWN) in (CRS610). Set to 'NotUsed' if missing.  
/PostalCode Postal code for the relevant city/post district. Mandatory From 'Postal code' (PONO) in (CRS610). Set to 'NotUsed' if missing.  
/Region Country-specific code to indicate regions / provinces within the tax authority. Optional From 'Description' (TX40) in (CRS046) for the state in (CRS610).  
/Country Two-letter country code according to the ISO 3166-1 alpha 2 standard. Optional From 'Country' (CSCD) in (CRS610).  
/AddressType Type of address. Optional Set to "Billing Address".  
/FullAddress Address written in free text Optional From 'Company address – line 1' (COA1) + 'Company address – line 2' (COA2) + 'Company address – line 3' (COA3) + 'Company address – line 4' (COA4) in (CRS610)  
Contact - Optional -  
/ContactPerson - Mandatory -  
/ContactPerson/FirstName First name of the person. Mandatory Set to 'NotUsed'.  
/ContactPerson/LastName Last name of the person. If the 'FirstName' element includes the text 'NotUsed', this element should contain the full unstructured name of the person. Mandatory From 'Your reference 1' (YREF) in (CRS610). Set to 'NotUsed' if missing.  
/Telephone Telephone number. Mandatory From 'Telephone number 1' (PHNO) in (CRS610). Set to 'NotUsed' if missing.  
/Fax Fax number. Optional From 'Facsimile number' (TFNO) in (CRS610).  
/Email Email address. Optional From 'Email address' (EMAL) in (CRS111) for type 01.  
TaxRegistration - Optional -  
/TaxRegistrationNumber The tax registration number of the company. Unique number issued by a revenue body for use by the company. Mandatory From 'VAT registration number' (VRNO) in (CRS610). Must be entered in requested format. The section is not created if the VAT registration number is missing. ISO code = 'LT': For domestic customers (country code = NO in CRS610), the number must be entered with the 'MVX' suffix, but any country prefix is automatically removed if included.
/TaxType The tax registration number type of the company. Mandatory Additional info. 016, type 4 in TXS035.  
CustomerID Unique account code/number for the customer. Optional From 'Customer' (CUNO) in (CRS610). ISO code = 'LT': The information is mandatory.
AccountID The account code/number into where this sub account/accounts receivable is consolidated in the balance sheet. Mandatory From ‘Accounting Rule’ (AIT1) in (CRS395).  

OpeningDebitBalance

or

ClosingCreditBalance

Debit or credit balance at the start date of the selection period in the default currency of the header. Mandatory Outstanding amount in the local currency. See 'Opening and closing balances' above for more information.  

ClosingDebitBalance

or

ClosingCreditBalance

Debit or credit balance at the end date of the selection period in the default currency of the header. Mandatory Outstanding amount in the local currency. See 'Opening and closing balances' above for more information.  

MasterFiles/Suppliers/Supplier

This section is created once per supplier. Only tags/elements populated for standard and/or country-specific information are included in the description below.

XML element

-

Description

(country-specific when applicable)

Required

-

Details - standard

-

Details - country-specific

(exceptions to standard)

Name The name of the supplier. Mandatory From 'Name' (CUNM) in (CRS620).  
Address - Mandatory -  
/StreetName Address line 1 of the supplier. Optional From 'Address – line 1' (ADR1) in (CRS622) using type 01 and if not found, type 02.  
/AdditionalAddressDetail Address line 2 of the supplier. Optional From 'Address – line 2' (ADR2) in (CRS622) using type 01 and if not found, type 02.  
/City Name of the city/post district. Mandatory From 'City' (TOWN) in (CRS622) using type 01 and if not found, type 02. Set to 'NotUsed' if missing.  
/PostalCode Postal code for the relevant city/post district. Mandatory From 'Postal code' (PONO) in (CRS622) using type 01 and if not found, type 02. Set to 'NotUsed' if missing.  
/Region Country-specific code to indicate regions/provinces within the tax authority. Optional From 'Description' (TX40) in (CRS046) for the state in (CRS622) using type 01 and if not found, type 02.  
/Country Two-letter country code according to the ISO 3166-1 alpha 2 standard. Optional From 'Country' (CSCD) in (CRS610) using type 01 and if not found, type 02.  
/AddressType Type of address. Optional Set to "PostalAddress".  
/FullAddress Address written in free text. Optional From 'Company address – line 1' (COA1) + 'Company address – line 2' (COA2) + 'Company address – line 3' (COA3) + 'Company address – line 4' (COA4) in (MNS100)  
Contact - Optional -  
/ContactPerson - Mandatory -  
/ContactPerson/FirstName First name of the person. Mandatory Set to 'NotUsed'.  
/ContactPerson/LastName Last name of the person. If the 'FirstName' element includes the text 'NotUsed', this element should contain the full unstructured name of the person. Mandatory From 'Your reference 1' (YREF) in (CRS623) using type 30. Set to 'NotUsed' if missing.  
/Telephone Telephone number. Mandatory From 'Telephone number 1' (PHNO) in (CRS623) using type 30 and if not found, from (CRS620). Set to 'NotUsed' if both are missing.  
/Fax Fax number. Optional From 'Facsimile number' (TFNO) in (CRS623) using type 30 and if not found, from (CRS620).  
/Email Email address. Optional From 'Email address' (EMAL) in (CRS623) for type 01.  
TaxRegistration - Optional -  
/TaxRegistrationNumber The tax registration number of the company. Unique number issued by a revenue body for use by the company. Mandatory From VAT registration number (VRNO) in (CRS620). Must be entered in the requested format. The section is not created if the VAT registration number is missing. ISO code = 'LT': For domestic suppliers (country code = LT in CRS620), the number must be entered with the 'MVX' suffix, but any country prefix is automatically removed if included.
/TaxType The tax registration number type of the company. Mandatory Additional info. 016, type 4 in (TXS035).  
SupplierID Unique account code/number for the customer. Optional From 'Supplier' (SUNO) in (CRS620). ISO code = 'LT': The information is mandatory.
AccountID The account code/number into where this sub account/accounts payable is consolidated in the balance sheet. Mandatory From ‘Accounting Rule’ (AIT1) in (CRS395).  

OpeningDebitBalance

or

ClosingCreditBalance

Debit or credit balance at the start date of the selection period in the default currency of the header. Mandatory Outstanding amount in the local currency. See 'Opening and closing balances' above for more information.  

ClosingDebitBalance

or

ClosingCreditBalance

Debit or credit balance at the end date of the selection period in the default currency of the header. Mandatory Outstanding amount in the local currency. See 'Opening and closing balances' above for more information.  

MasterFiles/TaxTable

This section is created once per audit file with a 'TaxTableEntry' section created once per 'TaxTable' and a 'TaxCodeDetails' section created once per VAT code defined with a VAT percentage for the division of the report. Only tags/elements populated for standard and/or country-specific information are included in the description below. Additional information from the VAT table and data translation according to set up in (CMS880/881)

VAT code translation to TaxCode

This is a specific and mandatory translation for Lithuania (triggered if Base country in AAS300=LT) to translate the M3BE VAT codes to the TaxCode required.

XML element

-

Description

(country-specific when applicable)

Required

-

Details - standard

-

Details - country-specific

(exceptions to standard)

TaxTableEntry - Optional -  
TaxType Tax type for lookup in tables. Mandatory From additional field 016 in (TXS035). Set to 'NotDefined' if missing. ISO code = 'LT': From additional field 016 in (TXS035). Set to 'NotDefined' if missing.
Description Description of the tax type. Mandatory From additional field 017 in (TXS035). Set to 'NotDefined' if missing. ISO code = 'LT': From additional field 017 in (TXS035). Set to 'NotDefined' if missing.
/TaxCodeDetails - Mandatory -  
/TaxCode Tax code for lookup in tables. Mandatory From 'VAT code' (VTCD) in (CRS031).  
/EffectiveDate The start date for this entry. Optional From 'From date' (FRDT) in (CRS031) using the format YYYY-MM-DD.  
/Description Description of the tax code. Optional From 'Description' (TX40) in (CRS031).  
/TaxPercentage Tax percentage. Mandatory From 'VAT rate 1' (VTP1) in (CRS031).  
/Country Two-letter country code according to the ISO 3166-1 alpha 2 standard. Mandatory From 'Country' (CSCD) in (CRS610). Set to ISO code (IISO) of base country if missing.  

GeneralLedgerEntries

This section is created once per audit file with a 'Journal' section created once per journal, a 'Transaction' section created once per voucher within the journal, and a 'Line' section created once per voucher line. Only tags/elements populated for standard and/or country-specific information are included in the description below.

XML element

-

Description

(country-specific when applicable)

Required

-

Details - standard

-

Details - country-specific

(exceptions to standard)

NumberOfEntries Number of entries. This is the total number of transaction entries (accounting documents/vouchers) from all journals included in the audit file. Mandatory Total number of vouchers included; the information is calculated when the audit file is prepared.  
TotalDebit The total of all debit amounts in the default currency of the header. Mandatory Total debit of recorded amount for the vouchers included; the information is calculated when the audit file is prepared.  
TotalCredit The total of all credit amounts in the default currency of the header. Mandatory Total credit of recorded amount for the vouchers included; the information is calculated when the audit file is prepared.  
Journal - Optional -  
/JournalID Identifier of source GL journal, or invoices and payments in single ledger systems. Mandatory

The information is created as 'Company number' (CONO) + 'Division' (DIVI) + 'Year' (YEA4) + 'Journal number' (JRNO).

Example: 136AAA20171234

ISO code = 'LT': Set to 'A'.
/Description Description of the journal. Mandatory From 'Journal heading' (JRTX) for the FAM entry ID of the journal.  
/Type Type of journal. Grouping mechanism for journals. Mandatory Description of the module for the FAM entry ID of the journal.  
/Transaction - Optional -  
/TransactionID The number/ID of the accounting document/voucher. Mandatory

The information is created as 'Company number' (CONO) + 'Division' (DIVI) + 'Year' (YEA4) - 'Voucher series' (VSER) - 'Voucher number' (VONO).

Example: 136AAA2017-123-12345678

 
/Description Description of journal transaction. Mandatory From 'Voucher text' (VTXT) of the voucher. Set to 'NotUsed' if missing.  
/BatchID System-generated ID of the batch. Optional From 'Journal number' (JRNO) of the voucher.  
/SystemEntryDate Date captured by the system, that is, the date when the transaction was entered into the system. Mandatory From 'Entry date' (RGDT) of the voucher.  
/GLPostingDate Date of posting to the general ledger account, that is, the date when the transaction was updated to the database. Mandatory From 'Accounting date' (ACDT) of the voucher.  
/SystemID Unique ID/number created by the system for the accounting document/voucher. Optional

The information is created as 'Year' (YEA4) - 'Voucher series' (VSER) - 'Voucher number' (VONO).

Example: 2017-123-12345678

 
/Transaction/Line - Mandatory -  
/RecordID Identifier to trace entry to journal line or posting reference. Mandatory

The information is created as 'Year' (YEA4) + 'Journal number' (JRNO) + 'Journal sequence number' (JSNO) of the voucher line.

Example: 201712312345678

 
/AccountID General ledger account code/number. Mandatory From 'Accounting dimension 1' (AIT1) of the voucher line.  
/Description Description of the journal line. Mandatory From 'Voucher text' (VTXT) of the voucher line. Set to 'NotUsed' if missing.  
/Transaction/Line/DebitAmount - Mandatory -  
/Amount Amount in the default currency of the header. Mandatory From 'Recorded amount' (ACAM) of the voucher line if positive amount.  
/CurrencyCode Three-letter currency code according to the ISO 4217 standard. Optional From 'Currency code' (CUCD) of the voucher line if positive amount. Only included if currency of transaction not equal to local currency.  
/CurrencyAmount Amount in foreign currency. Optional From 'Foreign currency amount' (CUAM) of the voucher line if positive amount. Only included if currency of transaction not equal to local currency.  
/ExchangeRate The exchange rate used. Optional From 'Exchange rate' (ARAT) of the voucher line if positive amount. Only included if currency of transaction not equal to local currency.  
/Transaction/Line/CreditAmount - Mandatory -  
/Amount Amount in the default currency of the header. Mandatory From 'Recorded amount' (ACAM) of the voucher line if negative amount.  
/CurrencyCode Three-letter currency code according to the ISO 4217 standard. Optional From 'Currency code' (CUCD) of the voucher line if negative amount. Only included if currency of transaction not equal to local currency.  
/CurrencyAmount Amount in foreign currency. Optional From 'Foreign currency amount' (CUAM) of the voucher line if negative amount. Only included if currency of transaction not equal to local currency.  
/ExchangeRate The exchange rate used. Optional From 'Exchange rate' (ARAT) of the voucher line if negative amount. Only included if currency of transaction not equal to local currency.  
/Transaction/Line/TaxInformation - Optional    
/TaxType Tax type for lookup in tables. Optional From additional field 016 in (TXS035). From additional field 016 in (TXS035). Set to 'MVA' if missing.
/TaxCode Tax code for lookup in tables. Optional From 'VAT code' (VTCD) of the voucher line.  
/TaxPercentage Tax percentage. Optional From 'VAT rate 1' (VTP1) of the voucher line.  
/Transaction/Line/TaxInformation/TaxAmount - Mandatory -  
/Amount Amount in the default currency of the header. Mandatory Recorded amount calculated from 'Calculated VAT 1' (CVT1) of the voucher line.  
/CurrencyCode Three-letter currency code according to the ISO 4217 standard. Optional From 'Currency code' (CUCD) of the voucher line. Only included if currency of transaction is not equal to local currency.  
/CurrencyAmount Amount in foreign currency. Optional From 'Foreign currency amount' (CUAM) of the voucher line. Only included if currency of transaction is not equal to local currency.  

/ExchangeRate

***SHOULD THIS BE INCLUDED? Present in document for Norway.

The exchange rate used. Optional From 'Exchange rate' (ARAT) of the voucher line. Only included if currency of transaction is not equal to local currency.  

Configuration

Below is a list of the most important settings and considerations with specific information to use when creating the SAF-T XML file.

Comment about mandatory information:

Country settings in (CRS045)

The country code for the base country must be defined in 'Country. Open' (CRS045) with the two-letter country code according to the ISO 3166-1 alpha 2 standard. For Lithuania this is 'LT'.

This is also applicable for the country codes of the company/division in (MNS100), the customers in (CRS610), the suppliers in (CRS622), and the VAT codes in (CRS031).

Currency settings in (CRS055)

The currency codes, local and foreign, defined in 'Currency. Open' (CRS055) must follow the three-letter currency code according to the ISO 4217 standard. For Lithuania this is 'EUR'.

Report fields for taxation in (TXS035)

The additional information required in the header section as well as in other sections must be defined in 'Tax Reporting. Open Report Fields' (TXS035) using type 4 for the base country and division used.

This table shows the details for each field:

Field

-

Details

(Length indicates maximum value)

Comment

-

Used in XML section/element

-

001

Tax accounting basics

Length: 18

Numeric: Cleared

Mandatory, set to 'NotDefined' if missing.

ISO code = 'LT': Set to 'A' if missing.

Header/TaxAccountingBasis
002

Tax entity

Length: 40

Numeric: Cleared

Optional. Header/TaxEntity
003

Taxonomy

Length: 40

Numeric: Cleared

Not used by SAF-T version 2 for the moment. -
004

Product/software ID

Length: 40

Numeric: Cleared

Mandatory, set to 'NotDefined' if missing. Header/SoftwareID
005

Product/software version

Length: 18

Numeric: Cleared

Mandatory, set to 'NotDefined' if missing. Header/SoftwareVersion
006

Header description

Length: 40

Numeric: Cleared

Optional. Header/HeaderComment
007

Email address

Length: 40

Numeric: Cleared

Optional. Header/Contact/Email
008

Web site

Length: 40

Numeric: Cleared

Optional. Header/Contact/Website
009

Audit file version

Length: 9

Numeric: Cleared

Mandatory, set to '1.0' if missing. Header/AuditFileVersion
010

Software company name

Length: 40

Numeric: Cleared

Mandatory, set to 'NotDefined' if missing. Header/SoftwareCompanyName
011

Registration number

Length: 18

Numeric: Cleared

Mandatory, set to 'NotDefined' if missing. Header/Company/RegistrationNumber
012

Tax registration number

Length: 35

Numeric: Cleared

Only required if the 'VAT registration number' (VRNO) in (MNS100) cannot be used, in that case mandatory. Must be entered in the format required. Header/Company/TaxRegistration/TaxRegistrationNumber
013

Our reference

Length: 40

Numeric: Cleared

Only required if the 'Our reference' (OREF) in (MNS100) cannot be used, in that case mandatory. Set to 'NotDefined' if both are missing. Header/Company/Contact/ContactPerson/LastName
014

Telephone number 1

Length: 18

Numeric: Cleared

Only required if the 'Telephone number 1' (PHNO) in (MNS100) cannot be used. Set to 'NotDefined' if both are missing. Header/Company/Contact/Telephone
015

Fax number

Length: 18

Numeric: Cleared

Only required if the 'Telephone number 1' (PHNO) in (MNS100) cannot be used; optional information. Header/Company/Contact/Fax
016

Tax type

Length: 9

Numeric: Cleared

Optional.

ISO code = 'LT': Not used (element not created).

Header/Company/TaxRegistration/TaxType

Mandatory, set to 'NotDefined' is missing.

ISO code = 'LT': Set to 'MVA' if missing.

MasterFiles/TaxTable/TaxTableEntry/TaxType

Optional.

ISO code = 'LT': Set to 'MVA' if missing.

GeneralLedgerEntries/Journal/Transaction/Line/TaxInformationTaxType
017

Tax description

Length: 40

Numeric: Cleared

Mandatory, set to 'NotDefined' is missing.

ISO code = 'LT': Set to 'NotDefined' if missing.

MasterFiles/TaxTable/TaxTableEntry/Description
018

Tax number

Length: 35

Numeric: Cleared

Optional.

ISO code = 'LT': Not used (element not created).

Header/Company/TaxRegistration/TaxNumber
019

Tax authority

Length: 35

Numeric: Cleared

Optional. Header/Company/TaxRegistration/TaxAuthority
020

Tax verification date

Length: 40

Numeric: Cleared

Optional. If entered, the date format YYYY-MM-DD must be used. Header/Company/TaxRegistration/TaxVerificationDate
021

Tax reporting jurisdiction

Length: 35

Numeric: Cleared

Optional. Header/SelectionCriteria/TaxReportingJurisdiction
022

Company entity

Length: 35

Numeric: Cleared

Optional. Header/SelectionCriteria/CompanyEntity
031 See 'Account translation scenario in (GLS030)'.

Connect division for company in (MNS100)

This table indicates included fields in 'Company. Connect Division' (MNS100):

Program ID Field Field Heading Comment Used in XML section/element
(MNS100/E) CONM Company name Mandatory. Header/Company/Name
(MNS100/E) COA1 Address line 1 Optional. Header/Company/Address/StreetName
(MNS100/E) COA2 Address line 2 Optional. Header/Company/Address/AdditionalAddressDetail
(MNS100/E) TOWN City Mandatory. Set to 'NotDefined' if missing. Header/Company/Address/City
(MNS100/E) PONO Postal code Mandatory. Set to 'NotDefined' if missing. Header/Company/Address/PostalCode
(MNS100/E) ECAR State Optional. Description of state in (CRS046) included in XML file. Header/Company/Address/Region
(MNS100/E) CSCD Country Optional. Header/Company/Address/Country
(MNS100/E) PHNO Telephone number 1 Mandatory. Used if field 014 in (TXS035) is not defined. Set to 'NotDefined' if both are missing. Header/Company/Contact/Telephone
(MNS100/E) TFNO Fax number Optional. Used if field 015 in (TXS035) is not defined. Header/Company/Contact/Fax
(MNS100/G) VRNO VAT registration number Mandatory. Used if field 012 in (TXS035) is not defined. Must be entered in the format required. Header/Company/TaxRegistration/TaxRegistrationNumber
(MNS100/G) OREF Our reference Mandatory. Used if field 013 in (TXS035) is not defined. Set to 'NotDefined' if both are missing. Header/Company/Contact/ContactPerson/LastName

Accounting identity in (CRS630)

This table indicates included fields in 'Accounting Identity. Open' (CRS630) for accounting dimension 1:

Program ID Field Field Heading Comment Used in XML section/element
(CRS630/B) AITM Accounting identity Mandatory. MasterFiles/GeneralLedgerAccounts/Account/AccountID

(CRS632/E)

(CRS630/E)

TX40 Description Mandatory. The 'Description' in (CRS632) for the language selected in (AAS300) is used and, if missing, from (CRS630). MasterFiles/GeneralLedgerAccounts/Account/AccountDescription

Account translation scenario in (GLS030)

The Lithuanian SAF-T requires that the Account IDs used in M3BE in (CRS630) are translated to a standard account ID (2- and 4-character code) according to the Lithuanian tax administration for the 'MasterFiles/GeneralLedgerAccounts' section (that is, 'Chart of accounts' in (AAS300)). As this information is mandatory in the Lithuanian SAF-T format, the element 'MasterFiles/GeneralLedgerAccounts/Account/StandardAccountID' is set to 'NotDefined' if the translation is missing.

The element for 'StandardAccountID' also exists in the standard format and can be used if requested. As this information is optional in the standard SAF-T format, the element 'MasterFiles/GeneralLedgerAccounts/Account/StandardAccountID' is not created if the translation is missing.

This table shows the fields in 'Account Translation Scenario. Open' (GLS030) that are required for the header of the translation:

Program ID Field Field heading Description Value
(GLS030/B) SCEN Scenario Mandatory.

Set to any ID (for example 'SAFT-NO' for SAF-T Lithuania – standard account ID).

See (TXS035) below for the field required to activate the translation.

(GLS030/B) AITP Accounting dimension Mandatory. Set to '1' for accounting dimension 1.

In 'Acc Translation Scenario. Open Details ' (GLS031), all standard account IDs with an account ID or a range of account IDs must be defined.

Program ID Field Field heading Description Value
(GLS031/B) X128 Category Mandatory. Set to the standard account ID.
(GLS031/B) FAIT From account identity Mandatory. Set to the first account ID from (CRS630) in the range applicable for the standard account ID.
(GLS031/E) TAIT To account identity Mandatory. Set to the last account ID from (CRS630) in the range applicable for the standard account ID.

Example:

Category From account identity To account identity
19 1910 1919
19 1930 1930

To activate the translation as well as to indicate the scenario to use, the below field must be defined in (TXS035):

Field Description Length Numeric Comment
031 Chart of account – scenario 20 Cleared

Reference to 'Scenario' (SCEN) in (GLS030) for translation of chart of account for accounting dimension 1.

Set to for example 'SAFT-NO' (see above).

Managing customers in (CRS610)

This table indicates included fields in 'Customer. Open' (CRS610):

Program ID Field Field heading Comment Used in XML section/element
(CRS610/B) CUNO Customer Mandatory. MasterFiles/Customers/Customer/CustomerID
(CRS610/E) CUNM Name Mandatory. MasterFiles/Customers/Customer/Name
(CRS610/E) CUA2 Address line 1 Optional. MasterFiles/Customers/Customer/Address/StreetName
(CRS610/E) TOWN Address line 2 Optional. MasterFiles/Customers/Customer/Address/AdditionalAddressDetail
(CRS610/E) PONO City Mandatory. Set to 'NotUsed' if missing. MasterFiles/Customers/Customer/Address/City
(CRS610/E) CUA1 Postal code Mandatory. Set to 'NotUsed' if missing. MasterFiles/Customers/Customer/Address/PostalCode
(CRS610/E) ECAR State Optional. Description of state in (CRS046) included in XML file. MasterFiles/Customers/Customer/Address/Region
(CRS610/E) CSCD Country Optional. MasterFiles/Customers/Customer/Address/Country
(CRS610/E) PHNO Telephone number 1 Mandatory. Set to 'NotUsed' if missing. MasterFiles/Customers/Customer/Contact/Telephone
(CRS610/E) TFNO Fax number Optional. MasterFiles/Customers/Customer/Contact/Fax
(CRS610/E) YREF Your reference 1 Mandatory. Set to 'NotUsed' if missing. MasterFiles/Customers/Customer/Contact/ContactPerson
(CRS610/J) VRNO VAT registration number

Optional.

ISO code = 'LT': For domestic customers (country code = NO in CRS610), the number must be entered with the 'MVX' suffix but any country prefix is automatically removed if included.

MasterFiles/Customers/Customer/TaxRegistration/TaxRegistrationNumber

If requested, an email address can be defined in 'Email Address. Open' (CRS111) using type 01.

Program ID Field Field heading Comment Used in XML section/element
(CRS111/E) EMAL Email address Optional. MasterFiles/Customers/Customer/Contact/Email

Managing suppliers in (CRS620)

This table indicates included fields in 'Supplier. Open' (CRS620):

Program ID Field Field heading Comment Used in XML section/element
(CRS620/B) SUNO Supplier Mandatory. MasterFiles/Suppliers/Supplier/SupplierID
(CRS620/E) SUNM Name Mandatory. MasterFiles/Suppliers/Supplier/Name
(CRS620/E) VRNO VAT registration number

Optional.

ISO code = 'LT': For domestic suppliers (country code = LT in CRS620), the number must be entered with the 'MVX' suffix, but any country prefix is automatically removed if included.

MasterFiles/Suppliers/Supplier/TaxRegistration/TaxRegistrationNumber

This table shows included supplier address information in 'Supplier. Connect Address' (CRS622). The address type 03–'Billing address' will be used if this exists, otherwise type 02 'Street address' is used.

Program ID Field Field heading Comment Used in XML section/element
(CRS622/E) ADR1 Address line 1 Optional. MasterFiles/Suppliers/Supplier/Address/StreetName
(CRS622/E) ADR2 Address line 2 Optional. MasterFiles/Suppliers/Supplier/Address/AdditionalAddressDetail
(CRS622/E) TOWN City

Mandatory.

Set to 'NotUsed' if missing.

MasterFiles/Suppliers/Supplier/Address/City
(CRS622/E) PONO Postal code

Mandatory.

Set to 'NotUsed' if missing.

MasterFiles/Suppliers/Supplier/Address/City
(CRS622/E) ECAR State Optional. Description of state in (CRS046) included in XML file. MasterFiles/Suppliers/Supplier/Address/Region
(CRS622/E) CSCD Country Optional. MasterFiles/Suppliers/Supplier/Address/Country

This table indicates included supplier reference information in 'Supplier. Connect Reference' (CRS623):

Program ID Field Field heading Comment Used in XML section/element
(CRS623/E) YREF Your reference 1 Mandatory. Set to 'NotUsed' if missing. MasterFiles/Suppliers/Supplier/Contact/ContactPerson
(CRS623/E) PHNO Telephone number 1 Mandatory. Set to 'NotUsed' if missing. MasterFiles/Suppliers/Supplier/Contact/Telephone
(CRS623/E) TFNO Fax number Optional. MasterFiles/Suppliers/Supplier/Contact/Fax
(CRS623/E) EMAL Email address Optional. MasterFiles/Suppliers/Supplier/Contact/Email

If requested, an email address can also be defined in 'Email Address. Open' (CRS111) using type 02 and is used if supplier reference is missing in (CRS623).

Program ID Field Field heading Comment Used in XML section/element
(CRS111/E) EMAL Email address Optional. MasterFiles/Suppliers/Supplier/Contact/Email

VAT code in (CRS030)

This table indicates included fields in 'VAT Rate. Open' (CRS031):

Program ID Field Field heading Comment Used in XML section/element
(CRS031/B) VTCD VAT code Mandatory. MasterFiles/TaxTable/TaxTableEntry/TaxCodeDetail/TaxCode
(CRS031/B) CSCD Country Optional to enter but mandatory in XML file (set to the ISO code (IISO) of the base country if missing). MasterFiles/TaxTable/TaxTableEntry/TaxCodeDetail/Country
(CRS031/B) ECAR State

Optional.

ISO code = 'NO': Not used (element not created).

MasterFiles/TaxTable/TaxTableEntry/TaxCodeDetail/Region
(CRS031/B) FRDT From date Mandatory to enter but optional in XML file (always included). MasterFiles/TaxTable/TaxTableEntry/TaxCodeDetail/EffectiveDate
(CRS031/E) TX40 Description Mandatory to enter but optional in XML file (always included). MasterFiles/TaxTable/TaxTableEntry/TaxCodeDetail/Description
(CRS031/E) VTP1 VAT rate 1 Mandatory (value 0 valid). MasterFiles/TaxTable/TaxTableEntry/TaxCodeDetail/TaxPercentage
(CRS031/E) VTD1 Deductible VAT 1 Only for the ISO code = 'NO' and then mandatory (value 0 valid). MasterFiles/TaxTable/TaxTableEntry/TaxCodeDetail/BaseRate

Lithuanian SAF-T - standard VAT/tax code

The Lithuanian SAF-T requires that the VAT codes used in M3 BE in (CRS030) are translated to a standard VAT/tax code according to the Lithuanian tax administration for the 'MasterFiles/TaxTable' section (that is, 'VAT code percentage' in (AAS300)). The translation must be defined in 'Business Message Data Translation. Display' (CRS881) with the details in 'Business Message Data. Translate' (CRS882). Since this information is mandatory in the Lithuanian SAF-T format, the element 'MasterFiles/TaxTable/TaxTableEntry/TaxCodeDetails/StandardTaxCode' is set to 'NotDefined' if the translation is missing.

The header record in (CRS880) is created the first time (AAS300) is run. Run (AAS300) with the VAT code percentage status set to 1-'Selected' (other sections can be excluded) once to automatically create the header record for translation in (CRS881). After the first (AAS300) run, select the record in (CRS881) with the following values:

Description Field Value
Company CONO Company
Division DIVI Division
Business Message BMSG SAF-T version 2
Parent element ELMP TaxTable
Data element ELMD TaxCode
Base Country BSCD LT
M3 Field VTCD VTCD
M3 element value from MVFL 01
M3 element value to MVFT 01
Data element value DELV PVM1

To define the translation for the VAT codes, use the related option 11='Translate' on the (CRS881/B) panel to open (CRS882). In (CRS882), enter the translation for each VAT code by using the following values:

Description Field Value
External partner EXTP Blank.
M3 data MVXD Set to the VAT code used in M3 BE in (CRS030).
Message data MBMD Set to the standard tax code required by the authority.

Example:

M3 data Message data
01 3
Related topics