Create XML file for Polish Tax Authorities

Follow these steps

  1. Open the program 'Standard Audit File for Tax. Generate' (AAS380) to specify selections for the invoices to be included in the report.

  2. Select 'Output file rep'.

  3. Select the check box 'Correction' to determine the type of file (correction or not).

  4. Specify 'VAT Run' (this is only available for VAT files and FA files).

  5. Specify Accounting date range from and to (only available for EWP, KR, MAG, and WB files).

    See more information about the file structure of the different files below.

  6. Specify 'Base country'. Set to PL (Poland) as recommended (only available for EWP, KR, MAG, and WB files).

  7. Specify 'Warehouse' (this is only available for MAG files).

  8. Specify 'Bank Account ID' (this is only available for WB files).

  9. Specify 'File name' (must end with .XML).

  10. Specify 'Folder 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.

  11. Click Next or press Enter to start the creation of the XML file.

    If a file with the same file name already exists in the folder, a message stating that the specified file already exists is displayed. The check box 'Replace doc' will also be displayed. Select the check box to replace the existing file, or change the file name and press 'Next' to create the file.

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

EWP file structure

XML element name XML element description Comments
  Message header

XML declaration for character encoding and namespace.

<?xml version="1.0" encoding="UTF-8"?>

<JPK xmlns="http://jpk.mf.gov.pl/wzor/2016/03/09/03091/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/">

Naglowek    
KodFormularza Attributes: kodSystemowy="JPK_EWP (1)" wersjaSchemy="1-0" Fix value JPK_EWP
WariantFormularza   Value will be retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 930 where base country is the same as (AAS380) base country. Should be set to '2'
CelZlozenia   Fix value 1
DataWytworzeniaJPK Creation date Date created format YYYYMMDDTHH:MM:SS
DataOd Date From Value will be retrieved from (AAS380) from date
DataDo Date To Value will be retrieved from (AAS380) to date
DomyslnyKodWaluty ISO Country PLN
KodUrzedu Office code Value will be retrieved from (TXS035) TTYP = 4, ESAF = 931 where base country is the same as base country in (AAS380)
Podmiot1    
IdentyfikatorPodmiotu    
etd:NIP VAT Identity Code Value will be retrieved from internal supplier of fiscal representative VAT registration number, or company VAT registration number
etd:PelnaNazwa Full name Value will be retrieved from internal supplier name of fiscal representative, or company name
etd:REGON Region Value will be retrieved from (TXS035) TTYP = 4, ESAF = 932 where base country is the same as (AAS380) base country.
AdresPodmiotu    
etd:KodKraju Base country Value will be retrieved from (AAS380) base country
etd:Wojewodztwo State Value will be retrieved from internal supplier of fiscal representative, or company state
etd:Powiat Country Value will be retrieved from the country name of internal supplier if a fiscal representative is defined. Otherwise set in (TXS035) TTYP = 4, ESAF = 933 where base country is the same as (AAS380) base country.
etd:Gmina Community Value will be retrieved from (TXS035) TTYP = 4, ESAF = 934 where base country is the same as (AAS380) base country.
etd:Ulica Street Value will be retrieved from (TXS035) TTYP = 4, ESAF = 935 where base country is the same as (AAS380) base country.
etd:NrDomu Building number Value will be retrieved from (TXS035) TTYP = 4, ESAF = 936 where base country is the same as (AAS380) base country.
etd:NrLokalu Apartment number Value will be retrieved from (TXS035) TTYP = 4, ESAF = 937 where base country is the same as (AAS380) base country.
etd:Miejscowosc Town Value will be retrieved from internal supplier of fiscal representative town, or company town
etd:KodPocztowy Post code Value will be retrieved from internal supplier of fiscal representative post code, or company post code
etd:Poczta Post office Value will be retrieved from (TXS035) TTYP = 4, ESAF = 938 where base country is the same as (AAS380) base country.
EWPWiersz Attribute: typ G
K1 Column 1 Ordinal number
K2 Column 2 Accounting date
K3 Column 3 Invoice date
K4 Column 4 Voucher number
K5 Column 5 Value will be retrieved from recorded amount with VAT Rate1 = 20
K6 Column 6 Value will be retrieved from recorded amount with VAT Rate1 = 17
K7 Column 7 Value will be retrieved from recorded amount with VAT Rate1 = 8.5
K8 Column 8 Value will be retrieved from recorded amount with VAT Rate1 = 5.5
K9 Column 9 Value will be retrieved from recorded amount with VAT Rate1 = 3.0
K10 Column 10 Sum of K5 + K6 + K7 + K8 + K9
K11 Column 11 Value will be retrieved from recorded amount with VAT Rate1 = 10.0
K12 Column 12 Voucher text
EWPCtrl    
LiczbaWierszy Number of rows Number of records in details
SumaPrzychodow Total revenue Sum of column 10

KR file structure

XML element name XML element description Comments
  Message header

XML declaration for character encoding and namespace.

<?xml version="1.0" encoding="UTF-8"?>

<JPK xmlns="http://jpk.mf.gov.pl/wzor/2016/03/09/03091/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/">

Naglowek    
KodFormularza Attributes: kodSystemowy="JPK_EWP (1)" wersjaSchemy="1-0" Fix value JPK_EWP
WariantFormularza   Value will be retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 930 where base country is the same as (AAS380) base country. Should be set to '1'
CelZlozenia   1
DataWytworzeniaJPK Creation date Date created format YYYYMMDDTHH:MM:SS
DataOd Date From Value will be retrieved from (AAS380) from date
DataDo Date To Value will be retrieved from (AAS380) to date
DomyslnyKodWaluty ISO Country PLN
KodUrzedu Office code Value will be retrieved from (TXS035) TTYP = 4, ESAF = 931 where base country is the same as (AAS380) base country.
Podmiot1    
IdentyfikatorPodmiotu    
etd:NIP VAT Identity Code Value will be retrieved from internal supplier of fiscal representative VAT registration number, or company VAT registration number
etd:PelnaNazwa Full name Value will be retrieved from internal supplier name of fiscal representative, or company name
etd:REGON Region Value will be retrieved from (TXS035) TTYP = 4, ESAF = 932 where base country is the same as (AAS380) base country.
AdresPodmiotu    
etd:KodKraju Base country Value will be retrieved from (AAS380) base country
etd:Wojewodztwo State Value will be retrieved from internal supplier of fiscal representative, or company state
etd:Powiat Country Value will be retrieved from the country name of internal supplier if a fiscal representative is defined. Otherwise set in (TXS035) TTYP = 4, ESAF = 933 where base country is the same as (AAS380) base country.
etd:Gmina Community Value will be retrieved from (TXS035) TTYP = 4, ESAF = 934 where base country is the same as (AAS380) base country.
etd:Ulica Street Value will be retrieved from (TXS035) TTYP = 4, ESAF = 935 where base country is the same as (AAS380) base country.
etd:NrDomu Building number Value will be retrieved from (TXS035) TTYP = 4, ESAF = 936 where base country is the same as (AAS380) base country.
etd:NrLokalu Apartment number Value will be retrieved from (TXS035) TTYP = 4, ESAF = 937 where base country is the same as (AAS380) base country.
etd:Miejscowosc Town Value will be retrieved from internal supplier of fiscal representative town, or company town
etd:KodPocztowy Post code Value will be retrieved from internal supplier of fiscal representative post code, or company post code
etd:Poczta Post office Value will be retrieved from (TXS035) TTYP = 4, ESAF = 938 where base country is the same as (AAS380) base country.
ZOiS Attribute: typ G
KodKonta Account ID Value will be retrieved from account ID in chart of accounts
OpisKonta Account description Value will be retrieved from account description
TypKonta Account type Value will be retrieved from account type
KodZespolu Group code Value will be retrieved from account group, level 5 is used.
OpisZespolu Group account description Account group description level 5 in 'Account Group. Open' (CRS633). If not defined, the value is set to 'Nie dotyczy'.
KodKategorii Category code Account group description level 5 in (CRS633). Set to group code (AICL) level 1, default value 'Nie dotyczy'
OpisKategorii Category description Account group description level 5 in (CRS633). Set to group code description (TX40) level 1, default value 'Nie dotyczy'
KodPodkategorii Sub Account Code Account group description level 5 in (CRS633). Set to group code (AICL) level 2, default value 'Nie dotyczy'
OpisPodkategorii Sub Account Description Account group description level 5 in (CRS633). Set to group code description (TX40) level 2, default value 'Nie dotyczy'
BilansOtwarciaWinien Opening Balance Debit Debit opening balance of the year (Period 00 of current year), external transactions only.
BilansOtwarciaMa Opening Balance Credit Credit opening balance of the year (Period 00 of current year), external transactions only.
ObrotyWinien Debit Transactions Debit external transaction within the current periods
ObrotyMa Credit Transactions Credit external transactions within the current periods
ObrotyWinienNarast Accumulated Debits Debit external transactions Period 1 of the current year up to 'to date' selection (year to date).
ObrotyMaNarast Accumulated Credits Credit external transactions period 1 of the current year up to 'to date' selection (year to date).
SaldoWinien Debit Balance Opening debit balance + sum of debit in table FGLEDG.ACAM for external transactions only. If Debit, this will be shown in this field.
SaldoMa Credit Balance Opening credit balance + sum of credit in table FGLEDG.ACAM for external transactions only. If Credit, this will be shown in this field.
Dziennik Attribute: typ G
LpZapisuDziennika Record log sequential number Journal number
NrZapisuDziennika Record number in the log Journal sequence number
OpisDziennika Description of the record Voucher name
NrDowoduKsiegowego Accounting Transaction Reference Voucher number
RodzajDowodu Voucher type FAM Function ID
DataOperacji Transaction Date Transaction date
DataDowodu Voucher date Accounting date
DataKsiegowania Posting Date Accounting date
KodOperatora Operator Code User ID
OpisOperacji Description of the operation log Voucher text
DziennikKwotaOperacji Value of the operation log Running balance of recorded amount
DziennikCtrl    
LiczbaWierszyDziennika Number of record rows Number of records in the record log
SumaKwotOperacji Sum of the amounts Sum of amounts from the record log
KontoZapis Attribute: typ G
LpZapisu Sequential Record Number  
NrZapisu Record Number Journal number
KodKontaWinien Debit Account Code Voucher name
KwotaWinien Debit Amount If debit amount, recorded as a positive decimal value
KwotaWinienWaluta Debit Amount in foreign currency If debit amount, recorded as a positive decimal value in foreign currency
KodWalutyWinien Currency Code for Debit Currency
OpisZapisuWinien Debit Record Description Voucher text
KodKontaMa Credit Account Code Voucher name
KwotaMa Credit Amount If credit amount, recorded as a positive decimal value
KwotaMaWaluta Credit Amount in foreign currency If credit amount, recorded as a positive decimal value in foreign currency
KodWalutyMa Currency Code for Credit Currency
OpisZapisuMa Credit Record Description Voucher text
KontoZapisCtrl    
LiczbaWierszyKontoZapisj Number of rows of Account Records Number of records
SumaWinien Total Debits Sum of debit account records
SumaMa Total Credits Sum of credit account records

MAG file structure

XML element name XML element description Comments
  Message header

XML declaration for character encoding and namespace.

<?xml version="1.0" encoding="UTF-8"?>

<JPK xmlns="http://jpk.mf.gov.pl/wzor/2016/03/09/03091/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/">

Naglowek    
KodFormularza Attributes: kodSystemowy="JPK_EWP (1)" wersjaSchemy="1-0" Fix value JPK_EWP
WariantFormularza   Value will be retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 930 where base country is the same as (AAS380) base country. Should be set to '1'
CelZlozenia   1
DataWytworzeniaJPK Creation date Date created format YYYYMMDDTHH:MM:SS
DataOd Date From Value will be retrieved from (AAS380) from date
DataDo Date To Value will be retrieved from (AAS380) to date
DomyslnyKodWaluty ISO Country PLN
KodUrzedu Office Code Value will be retrieved from (TXS035) TTYP = 4, ESAF = 931 where base country is the same as (AAS380) base country.
Podmiot1    
IdentyfikatorPodmiotu    
etd:NIP VAT Identity Code Value will be retrieved from internal supplier of fiscal representative VAT registration number, or company VAT registration number
etd:PelnaNazwa Full Name Value will be retrieved from internal supplier name of fiscal representative, or company name
etd:REGON Region Value will be retrieved from (TXS035) TTYP = 4, ESAF = 932 where base country is the same as (AAS380) base country.
AdresPodmiotu    
etd:KodKraju Base Country Value will be retrieved from (AAS380) base country
etd:Wojewodztwo State Value will be retrieved from internal supplier of fiscal representative, or company state
etd:Powiat Country Value will be retrieved from the country name of internal supplier if a fiscal representative is defined. Otherwise set in (TXS035) TTYP = 4, ESAF = 933 where base country is the same as (AAS380) base country.
etd:Gmina Community Value will be retrieved from (TXS035) TTYP = 4, ESAF = 934 where base country is the same as (AAS380) base country.
etd:Ulica Street Value will be retrieved from (TXS035) TTYP = 4, ESAF = 935 where base country is the same as (AAS380) base country.
etd:NrDomu Building number Value will be retrieved from (TXS035) TTYP = 4, ESAF = 936 where base country is the same as (AAS380) base country.
etd:NrLokalu Apartment number Value will be retrieved from (TXS035) TTYP = 4, ESAF = 937 where base country is the same as (AAS380) base country.
etd:Miejscowosc Town Value will be retrieved from internal supplier of fiscal representative town, or company town
etd:KodPocztowy Post code Value will be retrieved from internal supplier of fiscal representative post code, or company post code
etd:Poczta Post office Value will be retrieved from (TXS035) TTYP = 4, ESAF = 938 where base country is the same as (AAS380) base country.
Magazyn Warehouse Value will be retrieved from (AAS380) warehouse selection
PZ   The content of this section is based on the TTYP sets in (CRS881)
PZWartosc Summary of evidence for external receipt  
NumerPZ External receipt document number Reference number retrieved from table (MITTRA.REPN)
DataPZ Date of the external receipt document Transaction date
WartoscPZ Value of the overall external receipt document Unit price * Quantity
DataOtrzymaniaPZ Date of receipt of the goods/materials Transaction date
Dostawca Supplier of the goods/materials Supplier name and supplier code in table FGRECL.SUNO or table CIDMAS.SUNM
NumerFaPZ Invoice number of specifications received concerning goods/materials Optional field, retrieved from program APS370.SINO
DataFaPZ Date of invoice of specifications received concerning goods/materials Optional field, retrieved from program APS370.IVDT
PZWiersz    
Numer2PZ External receipt document number Reference number retrieved from table (MITTRA.REPN)
KodTowaruPZ Code of the goods/material/packaging Item number
NazwaTowaruPZ Name of the goods/material/packaging Item description
IloscPrzyjetaPZ Quantity taken Quantity
JednostkaMiaryPZ Unit of measure Unit of measure
CenaJednPZ Unit price of the goods/material/packaging Unit price
WartoscPozycjiPZ Value of the goods/material/packaging Unit price * Quantity
PZCtrl    
LiczbaPZ Number of external receipt documents Total count of external receipt transactions
SumaPZ Value of external receipt documents Sum of Unit price * Quantity
WZ   The content of this section is based on the TTYP sets in (CRS881)
WZWartosc    
NumerWZ External issue document number Reference number retrieved from table (MITTRA.RIDI)
DataWZ Date of the external issue document Transaction date
WartoscWZ Value of the external issue document Calculated value of Unit price * Quantity
DataWydaniaWZ Date of issue of the goods/materials Transaction date
OdbiorcaWZ Recipient of the goods/materials Not used/updated
NumerFaWZ Invoice number of specifications for goods/materials issued Not used/updated
DataFaWZ Date of the invoice of specifications for goods/materials issued Not used/updated
WZWiersz    
Numer2WZ External issue document number Reference number retrieved from table (MITTRA.RIDI)
KodTowaruWZ Code of the goods/material/packaging Item number
NazwaTowaruWZ Name of the goods/material/packaging Item description
IloscWydanaWZ Quantity issued Quantity
JednostkaMiaryWZ Unit of measure Unit of measure
CenaJednWZ Unit price of the goods/material/packaging Unit price
WartoscPozycjiWZ Value of the goods/material/packaging Calculated value of Unit price * Quantity
WZCtrl    
LiczbaWZ Number of external issue documents Total count of external issue transactions
SumaWZ Value of External issue documents Sum of Unit price * Quantity
RW   The content of this section is based on the TTYP sets in (CRS881)
RWWartosc    
NumerRW Internal issue document number Reference number retrieved from table (MITTRA.RIDN)
DataRW Date of the internal issue document Transaction date
WartoscRW Value of the internal issue document Unit price * Quantity
DataWydaniaRW Date of issue of the goods/material Date of issue
SkadRW Place of delivery of the goods/material Not used/updated
DokadRW Place of the goods/material Not used/updated
RWWiersz    
Numer2RW Internal issue document number Reference number retrieved from table (MITTRA.RIDN)
KodTowaruRW Code of the goods/material/packaging Item number
NazwaTowaruRW Name of the goods/material/packaging Item description
IloscWydanaRW Quantity issued Quantity
JednostkaMiaryRW Unit of measure Unit of measure
CenaJednRW Unit price of the goods/material/packaging Unit price
WartoscPozycjiRW Value of the goods/material/packaging Unit price * Quantity
RWCtrl    
LiczbaRW Number of internal issue documents Total count of the internal issue transactions
SumaRW Value of internal issue documents Sum of Unit price * Quantity
MM    
MMWartosc   The content of this section is based on the TTYP sets in (CRS881)
NumerMM Movement between warehouses number Reference number retrieved from table (MITTRA.RIDI)
DataMM Movement between warehouses date Transaction date
WartoscMM Movement between warehouses value Unit price
DataWydaniaMM Issue date of movement between warehouses document Issue date
SkadMM Movement between warehouses from Not used/updated
DokadMM Movement between warehouses to Not used/updated
MMWiersz    
Numer2MM Movement between warehouses number (2) Reference number retrieved from table (MITTRA.RIDI)
KodTowaruMM Movement between warehouses goods code Item number
NazwaTowaruMM Movement between warehouses goods name Item description
IloscWydanaMM Movement between warehouses quantity issued Quantity issued
JednostkaMiaryMM Movement between warehouses unit of measure Unit of measure
CenaJednMM Movement between warehouses unit price Unit price
WartoscPozycjiMM Movement between warehouses value Quantity issued * Unit price
MMCtrl    
LiczbaMM Number of movements between warehouses Total count of movement transactions
SumaMM Value of movements between warehouses Sum of Quantity issued * Unit price

VAT file Structure

XML element name XML element description Comments
  Message header

XML declaration for character encoding and namespace.

<?xml version="1.0" encoding="UTF-8"?> '

<JPK xmlns="http://jpk.mf.gov.pl/wzor/2016/03/09/03091/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/">

Naglowek    
KodFormularza Attributes: kodSystemowy="JPK_EWP (1)" wersjaSchemy="1-0" Fix value JPK_EWP
WariantFormularza   Value will be retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 930 where base country is the same as (AAS380) base country. Should be set to '1'.
CelZlozenia   1
DataWytworzeniaJPK Creation date Date created format YYYYMMDDTHH:MM:SS
DataOd Date From Value will be retrieved from (AAS380) from date
DataDo Date To Value will be retrieved from (AAS380) to date
DomyslnyKodWaluty ISO Country PLN
KodUrzedu Office Code Value will be retrieved from (TXS035) TTYP = 4, ESAF = 931 where base country is the same as (AAS380) base country.
Podmiot1    
IdentyfikatorPodmiotu    
etd:NIP VAT Identity Code Value will be retrieved from internal supplier of fiscal representative VAT registration number, or company VAT registration number
etd:PelnaNazwa Full name Value will be retrieved from internal supplier name of fiscal representative, or company name
etd:REGON Region Value will be retrieved from (TXS035) TTYP = 4, ESAF = 932 where base country is the same as (AAS380) base country.
AdresPodmiotu    
etd:KodKraju Base Country Value will be retrieved from (AAS380) base country
etd:Wojewodztwo State Value will be retrieved from internal supplier of fiscal representative, or company state
etd:Powiat Country Value will be retrieved from the country name of internal supplier if a fiscal representative is defined, otherwise set in (TXS035) TTYP = 4, ESAF = 933 where base country is the same as (AAS380) base country.
etd:Gmina Community Value will be retrieved from (TXS035) TTYP = 4, ESAF = 934, where base country is the same as (AAS380) base country.
etd:Ulica Street Value will be retrieved from (TXS035) TTYP = 4, ESAF = 935, where base country is the same as (AAS380) base country.
etd:NrDomu Building number Value will be retrieved from (TXS035) TTYP = 4, ESAF = 936, where base country is the same as (AAS380) base country.
etd:NrLokalu Apartment number Value will be retrieved from (TXS035) TTYP = 4, ESAF = 937, where base country is the same as (AAS380) base country.
etd:Miejscowosc Town Value will be retrieved from internal supplier of fiscal representative town, or company town
etd:KodPocztowy Post code Value will be retrieved from internal supplier of fiscal representative post code, or company post code
etd:Poczta Post office Value will be retrieved from (TXS035) TTYP = 4, ESAF = 938 where base country is the same as (AAS380) base country.
SprzedazWiersz Attribute typ G
LpSprzedazy Sales sequential number Number - sequence number
DataSprzedazy Date of sale VAT date
DataWystawienia Date of issue Invoice date
NrDokumentu Document number Supplier invoice number
NazwaNabywcy Buyer's name Value is retrieved from table FVATIN.CUSP or from the program Customer Master (CRS610.CUNM)
AdresNabywcy Address of the buyer Address 1 + Address 2 + Address 3 + Address 4
K_10 Column 10 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_11 Column 11

Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value

The net amount for VAT exempted invoices for the supply of goods and provision of services outside the national territory.

K_12 Column 12

Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value

The net amount for VAT exempted invoices to EU for supply of goods and provision of services referred to in Article . 100 sec. 1 point 4 of the Act. Note that these sales are also included in line K_11.

K_13 Column 13 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_14 Column 14 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_15 Column 15 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_16 Column 16 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_17 Column 17 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_18 Column 18 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_19 Column 19 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_20 Column 20 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_21 Column 21 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_22 Column 22 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_23 Column 23 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_24 Column 24 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_25 Column 25 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_26 Column 26 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_27 Column 27 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_28 Column 28 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_29 Column 29 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_30 Column 30 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_31 Column 31 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_32 Column 32 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_33 Column 33 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_34 Column 34 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_35 Column 35 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_36 Column 36 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_37 Column 37 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_38 Column 38 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
SprzedazCtrl    
LiczbaWierszySprzedazy Number of Rows Total number of lines
PodatekNalezny Tax payable Sum of FVATIN.ACA2 + ACA3 * -1
ZakupWiersz Attribute typ G
LpZakupu Purchase sequential number Running number
NazwaWystawcy Issuer name Value is retrieved from table FVATIN.CUSP or table CIDMAS.SUNM
AdresWystawcy Issuer address Supplier connect Address 1 + Address 2 + Address 3 + Address 4 with Address type 1
NrIdWystawcy ID of the issuer of the invoice VAT registration number. If blank set to 'brak'.
NrFaktury Invoice Number Supplier invoice number
DataWplywuFaktury Date of receipt of the invoice Accounting date
K_42 Column 42 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_43 Column 43 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_44 Column 44 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_45 Column 45 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_46 Column 46 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_47 Column 47 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
K_48 Column 48 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3), always a positive value
ZakupCtrl    
LiczbaWierszyZakupow Number of rows Number of lines
PodatekNaliczony Total (input) Tax Charged Sum of value in table FVATIN.ACA2 + ACA3

FA file structure

XML element name XML element description Comments
  Message header

XML declaration for character encoding and namespace.

<?xml version="1.0" encoding="UTF-8"?>

<JPK xmlns="http://jpk.mf.gov.pl/wzor/2019/09/27/09271/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2018/08/24/eD/DefinicjeTypy/">
Naglowek    
KodFormularza Attributes: kodSystemowy="JPK_FA (3)" wersjaSchemy="1-0" Fix value JPK_FA
WariantFormularza   Value will be retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 930 where base country is the same as (AAS380) base country. Should be set to '1'
CelZlozenia   1
DataWytworzeniaJPK Creation date Date created format YYYYMMDDTHH:MM:SS
DataOd Date From Value will be retrieved from (AAS380) from date
DataDo Date To Value will be retrieved from (AAS380) to date
KodUrzedu Office Code Value will be retrieved from (TXS035) TTYP = 4, ESAF = 931, where base country is the same as (AAS380) base country.
Podmiot1    
IdentyfikatorPodmiotu    
etd:NIP etd:NIP Value will be retrieved from internal supplier of fiscal representative VAT registration number, or company VAT registration number
etd:PelnaNazwa Full name Value will be retrieved from internal supplier name of fiscal representative, or company name
AdresPodmiotu    
etd:KodKraju Base Country Value will be retrieved from (AAS380) base country
etd:Wojewodztwo State Value will be retrieved from internal supplier of fiscal representative, or company state
etd:Powiat Country Value will be retrieved from the country name of internal supplier if a fiscal representative is defined. Otherwise set in (TXS035) TTYP = 4, ESAF = 933 where base country is the same as (AAS380) base country.
etd:Gmina Community Value will be retrieved from (TXS035) TTYP = 4, ESAF = 934, where base country is the same as (AAS380) base country.
etd:NrDomu Building number Value will be retrieved from (TXS035) TTYP = 4, ESAF = 936, where base country is the same as (AAS380) base country.
etd:Miejscowosc Town Value will be retrieved from internal supplier of fiscal representative town, or company town
etd:KodPocztowy Post code Value will be retrieved from internal supplier of fiscal representative post code, or company post code
Faktura    
KodWaluty ISO(4217) Currency Three letter currency code.
P_1 Date of issue Invoice date
P_2A Invoice number Customer invoice number
P_3A Customer name Customer name
P_3B Customer address Customer Address 1 + Address 2 + Address 3 + Address 4
P_3C Internal supplier/ Company name Supplier name will be retrieved from fiscal representative internal supplier, or company name will be used.
P_3D Company address Internal supplier or Company Address 1 + Address 2 + Address 3 + Address 4
P_4A Country of the VAT registration number Value is retrieved from country in supplier VAT registration number. If it is not included, country will be used or company country.
P_4B VAT Registration number without country Value is retrieved from supplier VAT registration number without country. If it is not included, company VAT registration number will be used.
P_5A Country of the VAT registration number VAT registration number (where the first 2 characters are country code) or blank
P_5B VAT registration number without country VAT registration number (without the leading country code)
P_6 VAT date VAT date
P_13_1   VAT report template Line ID report '19'. Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3) in whole number, always a positive value
P_14_1   VAT report template Line ID report '20'. Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3) in whole number, always a positive value
P_14_1W   Foreign Currency, VAT report template Line ID report '20'. Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3) in whole number, always a positive value
P_13_2   VAT report template Line ID report '17'. Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3) in whole number, always a positive value
P_14_2   VAT report template Line ID report '18'. Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3) in whole number, always a positive value
P_14_2W   Foreign Currency, VAT report template Line ID report '18'. Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3) in whole number, always a positive value
P_13_3   VAT report template Line ID report '15'. Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3) in whole number, always a positive value
P_14_3   VAT report template Line ID report '16'. Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3) in whole number, always a positive value
P_14_3W   Foreign Currency, VAT report template Line ID report '16'. Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3) in whole number, always a positive value
P_13_4   VAT report template Line ID report '11'. Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3) in whole number, always a positive value
P_14_4   Not used/updated
P_14_4W   Reserved field
P_13_5   VAT report template Line ID report '21'. Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3) in whole number, always a positive value
P_13_6   VAT report template Line ID report '13'. Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3) in whole number, always a positive value
P_13_7   VAT report template Line ID report '10'. Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3) in whole number, always a positive value
P_15   Sum of invoice gross amount. The amount of total receivables
P_16 TRUE or FALSE If the VAT code used is 'VAT on payment'= TRUE otherwise FALSE
P_17 TRUE or FALSE Check for VAT code list in (CRS881). If VAT code exists in the list set to TRUE, otherwise FALSE
P_18 TRUE or FALSE Check for VAT code list in (CRS881). If VAT code exists in the list set to TRUE, otherwise FALSE
P_19 TRUE or FALSE Check for VAT code list in (CRS881). If VAT code exists in the list set to TRUE, otherwise FALSE
P_19A   Check if element P19 = TRUE: If language field (LNCD) = blank use "PL". Find the exemption text for the VAT code
P_19B   Check if element P19 = TRUE: If language field (LNCD) = blank use "PL". Find the exemption text for the VAT code
P_19C   Check if element P19 = TRUE: If language field (LNCD) = blank use "PL". Find the exemption text for the VAT code
P_20 TRUE or FALSE Check for VAT code list in (CRS881): If VAT Code exists in the list set to TRUE, otherwise FALSE
P_20A Name of the enforcement Authority Check if element P20 = TRUE: (TXS035) TTYP = 4, ESAF = 939, where base country is the same as (AAS380) base country.
P_20B Address of the enforcement Authority Check if element P20 = TRUE: (TXS035) TTYP = 4, ESAF = 940, where base country is the same as (AAS380) base country.
P_21 TRUE or FALSE Set to TRUE if fiscal representative is found for the header
P_21A TRUE or FALSE Check if element P21 = TRUE: Supplier name (internal supplier based on fiscal representative)
P_21B TRUE or FALSE Check if element P21 = TRUE: Value is retrieved from table CIDMAS.ADR1/ADR2/ADR3/ADR4/
P_21C TRUE or FALSE Check if element P21 = TRUE: Value is retrieved from program CRS620.VRNO (remove leading country code if it exists)
P_22A Not Defined Not used/updated
P_22B Not Defined Not used/updated
P_22C Not Defined Not used/updated
P_23 TRUE or FALSE Check the VAT code. If VAT Method is 7- 'Triangular trade', set to TRUE, otherwise FALSE
P_106E_2 TRUE or FALSE Check for VAT code list in (CRS881). If the VAT code exists in the list set to TRUE, otherwise FALSE.
P_106E_3 TRUE or FALSE Check for VAT code list in (CRS881). If the VAT code exists in the list set to TRUE otherwise FALSE.
P_106E_3A TRUE or FALSE Check if P19 = TRUE: If language field (LNCD) = blank use "PL". Find the exemption text for the VAT code
RodzajFaktury

Type of invoice

- regular VAT invoice - value = "VAT"

- corrective invoice - value = "KOREKTA"

- advance invoice - value = "ZAL"

- other invoice - value = "POZ"

Transaction Code 10 and Check for Invoice Type.

Set value to "VAT" if blank, "KOREKTA" if invoice type is 'CN', "ZAL" if invoice type is 'PP', and "POZ" for other invoice types.

PrzyczynaKorekty For corrective invoice, reason code If Invoice is corrective invoice set the value from additional info 257
NrFaKorygowanej For corrective invoice, Invoice number If Invoice is corrective invoice, set the value from additional info 235
OkresFaKorygowanej For corrective invoice, invoice date Same customer and payer. Use original invoice's date then get period (using invoice number and year).
FakturaCtrl    
LiczbaFaktur Number of invoices Number of invoices
WartoscFaktur   Sum of P14_1 + P14_2 + P_14_3 + P13_1 + P13_2 + P_13_3 + P_13_6 + P_13_7
FakturaWiersz    
P_2B Invoice number Value is retrieved from table FSLEDG.CINO
P_7 Item

1. For Invoice Type (31) Item Description

2. For Invoice Type (60) External Charge Description

3. For Invoice Type (65) Service Charge Description

4. For Invoice Type (50) Advance Invoice (OOPINV.TX30) + Description (OOPINV.TX60)

5. For Invoice Type (51) Invoice reference (OINVOL.IVRF + OINVOL.ORNO)

6. For Invoice Type (67) OLICHL.CRD0 (CRS276/E) (PL) or OOLICH.CRD0 (OIS107/E) Internal Invoices Item Description

7. Other invoices (grouped by VAT code) voucher text.

P_8A Unit of measure

For customer invoices (IVTP31) and internal invoices. The value is retrieved from tables CSYUNL.UNI2 (PL) or MITMAS.UNMS

Otherwise set to "szt" - Polish for "pcs"

P_8B  

Customer invoices - Sum of ODLINE.IVQT

Internal Invoices - CMUFTR.DLQT

Other invoices - Sum of table FGLEDG.ACQT for the invoice per VAT code

No value for IVTP (60, 65, 67, 50, 51)

P_9A  

Value retrieved from table OOLINE.NEPR or OOLINE.NLAM/OLINE.IVQT

No value for IVTP (60, 65, 67, 50, 51)

P_9B  

(OINVOL.IVAM + OINVOL.VTAM) / OOLINE.IVQT

No value for IVTP (60, 65, 67, 50, 51)

P_10  

Value of table OINACC.ACAM with IVTP = 32 or 34

No value for IVTP (60, 65, 67, 50, 51)

P_11  

1. For invoice type (31) the value will be foreign currency amount minus the value in element P_10

2. For Invoice type (60, 65, 67, 50, 51) the value will be the foreign currency amount

3. For Internal invoices: the value will be the Quantity multiplied by price

4. Other invoices: The sum of foreign currency amount invoice per VAT code. Only valid for VAT account type 3-9 net value

P_11A  

1. For invoice type (31): Sum of foreign currency amount and VAT amount minus the value in element P_10

2. For invoice types (60, 65, 67): the value will be the sum of invoice amount + VAT amount

3. For invoice type (50): the value will be the sum of foreign currency amount of invoice types 50 and 41.

4. For invoice type (51): the value will be the sum of foreign currency amount of invoice types 50 and 42.

5. For internal invoices: The value will be the sum of element P_11 and calculated VAT amount based on either voucher VAT rate 1 or table CMUFTR.VTP1 (controlled by (CRS881))

6. Other invoices: Sum of voucher currency amount for the invoice per VAT code. Valid for VAT account type 3 - 9 gross value

P_12   Acceptable values 23, 22, 8, 7, 5, 4, 3, 0, zw, oo, np.
FakturaWierszCtrl    
LiczbaWierszyFaktur   Number of records
WartoscWierszyFaktur   Sum of P11A
Zamowienie   Advance invoice
P_2AZ Invoice number Value is retrieved from table FSLEDG.CINO
WartoscZamowienia   Total Amount of invoice
ZamowienieWiersz    
P_7Z Item Invoice Type (50) Advance Invoice (OOPINV.TX30) + Description (OOPINV.TX60)
P_8AZ Unit of measure set to "szt" - Polish for "pcs"
P_11NettoZ   The value of Advance Invoice without VAT
P_11VatZ   Advance Invoice VAT amount
P_12Z   VAT rate
ZamowienieCtrl    
LiczbaZamowien   Total number of Advance invoice
WartoscZamowien   Sum of ‘WartoscZamowienia’

Invoice type tag "Rodzaj faktury" (RodzajFaktury)

This tag is controlled by the M3 BE invoice type (IVTP) of the invoice record in Sales Ledger (FSLEDG) and gets set in the "FA xml" as follows:

In case of a corrective invoice (IVTP="CN") we put "KOREKTA" in the tag "PrzyczynaKorekty", the original invoice number in tag "NrFaKorygowanej" (from AR extra info 235 or 255) and invoice period in tag "OkresFaKorygowanej".

Supplier invoice receipt date tag "DataWplywuFaktury" (ZakupWiersze)

The Polish market modifications provide an option to enter the invoice receipt date during supplier invoice entry resulting in extra info AP 420 with the receipt date in format YYYYMMDD. (AAS380) routines for the VAT file check if this information exists for a supplier invoice. If it exists, this date will be taken for tag "DataWplywuFaktury" in section "ZakupWiersze".

WB file structure

XML Element name XML Element description Comments
  Message header

XML declaration for character encoding and namespace.

<?xml version="1.0" encoding="UTF-8"?>

<JPK xmlns="http://jpk.mf.gov.pl/wzor/2016/03/09/03091/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/">

Naglowek    
KodFormularza Attributes: kodSystemowy="JPK_EWP (1)" wersjaSchemy="1-0" Fix value JPK_EWP
WariantFormularza   Value will be retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 930 where base country is the same with (AAS380) base country. Should be set to '1'.
CelZlozenia   1
DataWytworzeniaJPK Creation date Date created format YYYYMMDDTHH:MM:SS
DataOd Date From Value will be retrieved from (AAS380) from date
DataDo Date To Value will be retrieved from (AAS380) to date
DomyslnyKodWaluty ISO Country PLN
KodUrzedu Office Code Value will be retrieved from (TXS035) TTYP = 4, ESAF = 931, where base country is same as (AAS380) base country
Podmiot1    
IdentyfikatorPodmiotu    
etd:NIP VAT Identity Code Value will be retrieved from internal supplier of fiscal representative VAT registration number, or company VAT registration number
etd:PelnaNazwa Full Name Value will be retrieved from internal supplier name of fiscal representative, or company name
etd:REGON Region Value will be retrieved from (TXS035) TTYP = 4, ESAF = 932, where base country is the same as (AAS380) base country
AdresPodmiotu    
etd:KodKraju Base Country Value will be retrieved from (AAS380) base country
etd:Wojewodztwo State Value will be retrieved from internal supplier of fiscal representative, or company state
etd:Powiat Country Value will be retrieved from the country name of internal supplier if a fiscal representative is defined. Otherwise set in (TXS035) TTYP = 4, ESAF = 933 where base country is the same as (AAS380) base country.
etd:Gmina Community Value will be retrieved from (TXS035) TTYP = 4, ESAF = 934 where base country is the same as (AAS380) base country
etd:Ulica Street Value will be retrieved from (TXS035) TTYP = 4, ESAF = 935, where base country is the same as (AAS380) base country
etd:NrDomu Building number Value will be retrieved from (TXS035) TTYP = 4, ESAF = 936 where base country is the same as (AAS380) base country
etd:NrLokalu Apartment number Value will be retrieved from (TXS035) TTYP = 4, ESAF = 937 where base country is the same as (AAS380) base country
etd:Miejscowosc Town Value will be retrieved from internal supplier of fiscal representative town, or company town
etd:KodPocztowy Post code Value will be retrieved from internal supplier of fiscal representative post code, or company post code
etd:Poczta Post office Value will be retrieved from (TXS035) TTYP = 4, ESAF = 938 where base country is the same as (AAS380) base country
NumerRachunku Bank account ID Bank account IBAN number
Salda    
SaldoPoczatkowe Opening balance of the statement Transaction amount using from date as ending date to receive all transactions
SaldoKoncowe Closing balance of the statement Opening balance + all transactions in the accounting date range
WyciagWiersz    
NumerWiersza Journal number Journal number
DataOperacji Accounting date Accounting date
NazwaPodmiotu Customer name / Supplier name Customer ID and name, or supplier ID and name
OpisOperacji Voucher text and voucher number Voucher text with customer invoice number, or supplier invoice number with voucher number
KwotaOperacji Recorded amount Recorded amount in local currency
SaldoOperacji Total amount Running balance (starting with the opening balance) + transaction amount
WyciagCtrl    
LiczbaWierszy Number of lines Total number of statement detail lines
SumaObciazen Total debit amount Total debit amount from the statement detail lines
SumaUznan Total credit amount Total credit amount from the statement detail lines

VDEK file structure

XML Element name XML Element description Comments
  Message header

XML declaration for character encoding and namespace.

<?xml version="1.0" encoding="UTF-8"?>

<JPK xmlns="http://jpk.mf.gov.pl/wzor/2016/03/09/03091/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/">

Naglowek    
KodFormularzaJPK Attributes: kodSystemowy=" JPK_VDEK (1)" wersjaSchemy="2-0" Fix value JPK_VDEK
WariantFormularzaJPK   Value will be retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 930 where base country is the same as (AAS380) base country. Should be set to '1'.
DataWytworzeniaJPK Creation date Date created format YYYYMMDDTHH:MM:SS
NazwaSystemu   Value will be retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 950 where base country is the same as (AAS380) base country.
CelZlozenia   Constant value '1'
poz Attribute Constant value 'P_7'
KodUrzedu Office Code Value will be retrieved from (TXS035) TTYP = 4, ESAF = 931 where base country is the same as (AAS380) base country.
Rok   Year
Miesiac Period Month
KodFormularza JPK_VDEK Text 'VAT-7'
kodSystemowy Attribute Constant value 'VAT-7 (20)'
KodPodatku Attribute Constant value 'VAT'
RodzajZobowiazania Attribute Constant value 'Z'
wersjaSchemy Attribute Constant value '1-0E'
WariantFormularza   Constant value '20'
Podmiot1    
rola Attribute Constant value 'Podatnik
OsobaNiefizyczna   ISO code of base country used
NIP   Date when the file is created
PelnaNazwa   Constant value '1'
Email   Value will be retrieved from (TXS035) TTYP = 4, ESAF = '491' & '492' where base country is the same as (AAS380) base country.
Deklaracja    
PozycjeSzczegolowe Attribute Constatnt 'Podatnik
P_10 Column 10 Sum of amount in ACA1, ACA2, ACA3 where LNID = 10
P_11 Column 11 Sum of amount in ACA1, ACA2, ACA3 where LNID = 11
P_12 Column 12 Sum of amount in ACA1, ACA2, ACA3 where LNID = 12
P_13 Column 13 Sum of amount in ACA1, ACA2, ACA3 where LNID = 13
P_14 Column 14 Sum of amount in ACA1, ACA2, ACA3 where LNID = 14
P_15 Column 15 Sum of amount in ACA1, ACA2, ACA3 where LNID = 15
P_16 Column 16 Sum of amount in ACA1, ACA2, ACA3 where LNID = 16
P_17 Column 17 Sum of amount in ACA1, ACA2, ACA3 where LNID = 17
P_18 Column 18 Sum of amount in ACA1, ACA2, ACA3 where LNID = 18
P_19 Column 19 Sum of amount in ACA1, ACA2, ACA3 where LNID = 19
P_20 Column 20 Sum of amount in ACA1, ACA2, ACA3 where LNID = 20
P_21 Column 21 Sum of amount in ACA1, ACA2, ACA3 where LNID = 21
P_22 Column 22 Sum of amount in ACA1, ACA2, ACA3 where LNID = 22
P_23 Column 23 Sum of amount in ACA1, ACA2, ACA3 where LNID = 23
P_24 Column 24 Sum of amount in ACA1, ACA2, ACA3 where LNID = 24
P_25 Column 25 Sum of amount in ACA1, ACA2, ACA3 where LNID = 25
P_26 Column 26 Sum of amount in ACA1, ACA2, ACA3 where LNID = 26
P_27 Column 27 Sum of amount in ACA1, ACA2, ACA3 where LNID = 27
P_28 Column 28 Sum of amount in ACA1, ACA2, ACA3 where LNID = 28
P_29 Column 29 Sum of amount in ACA1, ACA2, ACA3 where LNID = 29
P_30 Column 30 Sum of amount in ACA1, ACA2, ACA3 where LNID = 30
P_31 Column 31 Sum of amount in ACA1, ACA2, ACA3 where LNID = 31
P_32 Column 32 Sum of amount in ACA1, ACA2, ACA3 where LNID = 32
P_33 Column 33 Sum of amount in ACA1, ACA2, ACA3 where LNID = 33
P_34 Column 34 Sum of amount in ACA1, ACA2, ACA3 where LNID = 34
P_35 Column 35 Sum of amount in ACA1, ACA2, ACA3 where LNID = 35
P_36 Column 36 Sum of amount in ACA1, ACA2, ACA3 where LNID = 36
P_37 Column 37 Sum of amount in ACA1, ACA2, ACA3 where LNID = 37
P_38 Column 38 Sum of amount in ACA1, ACA2, ACA3 where LNID = 38
P_39 Column 10 Sum of amount in ACA1, ACA2, ACA3 where LNID = 39
P_40 Column 11 Sum of amount in ACA1, ACA2, ACA3 where LNID = 40
P_41 Column 12 Sum of amount in ACA1, ACA2, ACA3 where LNID = 41
P_42 Column 13 Sum of amount in ACA1, ACA2, ACA3 where LNID = 42
P_43 Column 14 Sum of amount in ACA1, ACA2, ACA3 where LNID = 43
P_44 Column 15 Sum of amount in ACA1, ACA2, ACA3 where LNID = 44
P_45 Column 16 Sum of amount in ACA1, ACA2, ACA3 where LNID = 45
P_46 Column 46 Sum of amount in ACA1, ACA2, ACA3 where LNID = 46
P_47 Column 47 Sum of amount in ACA1, ACA2, ACA3 where LNID = 47
P_48 Column 48 Sum of amount in ACA1, ACA2, ACA3 where LNID = 48
P_49 Column 49 Sum of amount in ACA1, ACA2, ACA3 where LNID = 49
P_50 Column 50 Sum of amount in ACA1, ACA2, ACA3 where LNID = 50
P_51 Column 51 Sum of amount in ACA1, ACA2, ACA3 where LNID = 51
P_52 Column 52 Sum of amount in ACA1, ACA2, ACA3 where LNID = 52
P_53 Column 53 Sum of amount in ACA1, ACA2, ACA3 where LNID = 53
P_54 Column 54 Sum of amount in ACA1, ACA2, ACA3 where LNID = 54
P_55 Column 55 Sum of amount in ACA1, ACA2, ACA3 where LNID = 55
P_56 Column 56 Sum of amount in ACA1, ACA2, ACA3 where LNID = 56
P_57 Column 57 Sum of amount in ACA1, ACA2, ACA3 where LNID = 57
P_58 Column 58 Sum of amount in ACA1, ACA2, ACA3 where LNID = 58
P_59 Column 59 Sum of amount in ACA1, ACA2, ACA3 where LNID = 59
P_60 Column 60 Sum of amount in ACA1, ACA2, ACA3 where LNID = 60
P_61 Column 61 Sum of amount in ACA1, ACA2, ACA3 where LNID = 61
P_62 Column 62 Sum of amount in ACA1, ACA2, ACA3 where LNID = 62
P_63 Column 63 Sum of amount in ACA1, ACA2, ACA3 where LNID = 63
P_64 Column 64 Sum of amount in ACA1, ACA2, ACA3 where LNID = 64
P_65 Column 65 Sum of amount in ACA1, ACA2, ACA3 where LNID = 65
P_66 Column 66 Sum of amount in ACA1, ACA2, ACA3 where LNID = 66
P_67 Column 67 Sum of amount in ACA1, ACA2, ACA3 where LNID = 67
P_70 Column 70 Sum of amount in ACA1, ACA2, ACA3 where LNID = 70
P_72 Column 72 Sum of amount in ACA1, ACA2, ACA3 where LNID = 72
P_73 Column 73 Sum of amount in ACA1, ACA2, ACA3 where LNID = 73
Pouczenia   Constant value '1.0'
SprzedazWiersz    
LpSprzedazy    
NrKontrahenta VAT registration number Retrieved from table OCUSMA, VAT registration number
KodKrajuNadaniaTIN Country on VAT registration number Retrieved from table OCUSMA, Country on VAT registration number
NazwaKontrahenta Customer name Retrieved from table OCUSMA, Customer name
KodKrajuSiedziby Country code Retrieved from table OCUSMA, Country code
AdresKontrahenta Address Retrieved from table OCUSMA, Address1, Address2, Address3, Address4
DowodSprzedazy Invoice number Retrieved from table FSLEDG
DataWystawienia Invoice Date Retrieved from table FSLEDG, Invoice Date
DataSprzedazy VAT Date Retrieved from table FSLEDG, VAT Date
TerminPlatnosci Optional not included Not included
Formaplatnosci Payment method Set value to G – if cash, P if transfer, I – others
KodTypuDOkumentu Value retrieved from setup in (CRS881) define per VAT code. Accepted value FISK, WEW, MK, AU, MR, FP, TT
KodGrupyTowarowej Default value setup in (CRS881) Accepted value (01-19)
KorektaPodstawyOpodt Optional not included Not included
K_10 Column 10 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_11 Column 11 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_12 Column 12 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_13 Column 13 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_14 Column 14 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_15 Column 15 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_16 Column 16 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_17 Column 17 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_18 Column 18 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_19 Column 19 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_20 Column 20 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_21 Column 21 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_22 Column 22 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_23 Column 23 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_24 Column 24 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_25 Column 25 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_26 Column 26 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_27 Column 27 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_28 Column 28 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_29 Column 29 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_30 Column 30 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_31 Column 31 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_32 Column 32 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_33 Column 33 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_34 Column 34 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_35 Column 35 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_36 Column 36 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_37 Column 37 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_38 Column 38 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_39 Column 39 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
SprzedazCtrl    
LiczbaWierszySprzedazy Number of Rows Total number of lines
PodatekNalezny Tax payable Sum of all amounts from K_10 to K_39
ZakupWiersz Attribute type G
LpZakupu Purchase sequential number Running number
NrDostawcy VAT registration number Retrieved from IDMAS, VAT registration number
KodKrajuNadaniaTIN Country on VAT registration number Retrieved from IDMAS, Country on VAT registration number
KodKrajuSiedziby Customer name Retrieved from IDMAS, Customer name
KodTypuDokumentu Country code Retrieved from IDMAS, Country code
NazwaDostawcy   SINO + VSER
AdresDostawcy Address Address1, Address2, Address3, Address4
DowodZakupu Invoice number Retrieved from FVATIN and FGLEDG (SINO + VSER)
DataZakupu Invoice Date Invoice Date
DataWplywu VAT Date VAT Date
TerminPlatnosci Optional not included Not included
K_43 Column 43 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_44 Column 44 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_45 Column 45 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_46 Column 46 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_47 Column 47 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_48 Column 48 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_49 Column 49 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_49_1 Not defined Not defined
K_50 Column 50 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_50_1 Not defined Not defined
ZakupCtrl    
LiczbaWierszyZakupow Number of rows Number of lines
PodatekNaliczony Total (input) Tax Charged Sum of value in table FVATIN.ACA2 + ACA3

Settings

Several settings should be defined for the SAF-T, including 'Taxation Reporting. Open Report Fields' (TXS035), 'Business Message Data Translation. Displ' (CRS881) and 'VAT report template. Connect lines' (TXS008).

Report fields for taxation reporting in (TXS035)

  1. All the additional field numbers 939-950 should be defined for base country PL and Transaction Type 4.

Set up MAG JPK file

  1. MAG JPK files are composed of 4 sections (PZ, WZ, RW, MM). Each section should define the transaction types that will be included in each section by setting up transaction types in 'Business Message Data Translation. Displ' (CRS881/CRS882).

  2. Run (AAS380) once to automatically create the header record for translation in (CRS881). After the first (AAS380) run, select the the record in (CRS881) and specify these values:

    MSTD

    Message standard , set it to M3BE

    MVRS

    Version, set it to 1

    BMSG

    Message, set it to PL-MAG_JPK

    IBOB

    I/O , set it to O

    ELMP

    (leave blank)

    ELMD

    Data element , set it to PZ, WZ, RW, MM

  3. Use related option 'Translate' (CTRL+11) on (CRS881/B) to start (CRS882).

  4. In (CRS882), specify the translation by using these values:

    EXTP

    External partner (leave blank)

    MVXD

    M3 data, enter TTYP that will be included in each section (PZ, WZ, RW, MM)

    MBMD

    Message data (leave blank)

Set up VAT JPK file

  1. In the VAT JPK file, identify which Customer/Payer and Supplier/Payee should be used for element NazwaNabywcy (either Customer or Payer) and for element NazwaWystawcy (either Supplier or Payee) by setting the value 1 on these elements in 'Business Message Data Translation. Displ' (CRS881/CRS882).

  2. Run (AAS380) once to automatically create the header record for translation in CRS881.

    After the first (AAS380) run, select the record in (CRS881) and specify these values:

    MSTD

    Message standard, set it to M3BE

    MVRS

    Version, set it to 1

    BMSG

    Message, set it to PL-VAT_JPK

    IBOB

    I/O, set it to O

    ELMP

    Parent elements, set it to SprzedazWiersz

    ELMD

    Data element, set it to NazwaNabyw

  3. Use related option 'Translate' (CTRL+11) on (CRS881/B) to start (CRS882).

  4. In (CRS882), specify the translation by using these values:

    EXTP

    External partner (leave blank)

    MVXD

    M3BE data, Set to 1 if Payer will be used, otherwise leave it blank or set it to 0 if a Customer will be used.

    MBMD

    Message data (leave blank)

  5. Run (AAS380) once to automatically create the header record for translation in (CRS881).

  6. Select the record in (CRS881) and specify these values:

    MSTD

    Message standard, set it to M3BE

    MVRS

    Version, set it to 1

    BMSG

    Message, set it to PL-VAT_JPK

    IBOB

    I/O, set it to O

    ELMP

    Parent elements, set it to SprzedazWiersz

    ELMD

    Data element, set it to NazwaWystawcy

  7. Use related option 'Translate' (CTRL+11) on (CRS881/B) to start (CRS882).

  8. In (CRS882), specify the translation by entering these values:

    EXTP

    External partner (leave blank)

    MVXD

    M3 data, set to 1 if Payee will be used, otherwise leave blank or set it to 0 if Supplier will be used.

    MBMD

    Message data (leave blank)

  9. Run (AAS380) once to automatically create the header record for translation in (CRS881).

  10. Select the record in (CRS881) and specify these values:

    MSTD

    Message standard, set it to M3BE

    MVRS

    Version, set it to 1

    BMSG

    Message, set it to PL-VAT_JPK

    IBOB

    I/O, set it to O

    ELMP

    Parent elements, set it to ZakupWiersz

    ELMD

    Data element, set it to NazwaWystawcy

  11. Use related option 'Translate' (CTRL+11) on (CRS881/B) to start (CRS882).

  12. In (CRS882), specify the translation by entering these values:

    EXTP

    External partner (leave blank)

    MVXD

    M3 data, set to 1 if Payee will be used, otherwise leave blank or set it to 0 if Supplier will be used.

    MBMD

    Message data (leave blank)

Set up FA JPK file

  1. Identify which VAT codes will be used in checking for element P_17, P_18, P_19, P_20, P_3A, P_106E_2, P_106E3 by setting up VAT codes in 'Business Message Data Translation. Displ' (CRS881/CRS882).

    Run (AAS380) once to automatically create the header record for translation in (CRS881).

  2. Select the record in (CRS881) and specify these values:

    MSTD

    Message standard, set it to M3BE

    MVRS

    Version, set it to 1

    BMSG

    Message, set it to PL-VAT_JPK

    IBOB

    I/O, set it to O

    ELMP

    Parent elements, set it to Faktura

    ELMD

    Data element, set it to P_17, P_18, P_19, P_20, P_3A, P_106E_2, P_106E3

  3. Use related option 'Translate' (CTRL+11) on (CRS881/B) to start (CRS882).

  4. In (CRS882), specify the translation by using these values:

    EXTP

    External partner (leave blank)

    MVXD

    M3 data, set to VAT Code

    MBMD

    Message data (leave blank)

VAT report template

Field elements in the VAT JPK File will be based on VAT reporting in 'VAT Report Template. Open' (TXS008).

It is important that electronic VAT report is created based on the report template created. The report template will determine what transactions will be included for each element in the XML file.

  1. Open 'VAT Report Template. Connect Lines' (TXS008).

  2. The Line ID rep (LNID) pertains to each element of the XML.

  3. An example here is Line ID rep 10 refers to K_10 element. Set this for K_10 to K_38 and K_42 to K_48.

Related topics