Configuration guidelines for ‘VAT Report Template. Connect Lines’ (TXS008)
For each report, transactions are selected and included in one section using a specific range of line IDs. The ranges of line IDs are fixed. These line IDs are used in the Financial Business Message. The records from M3 are inserted into the correct section with the requested information.
This table shows the sections in the report and, for each section, the ranges of line IDs that must be strictly defined:
| Section | Description | Line ID |
|---|---|---|
| A1 | Lines with IDs from 100 to 199 are used for section A1. These lines contain invoices and credit notes for local customers with reversed charges for special products, as provided for in §92a of the ZDPH act. One line must be created per invoice and credit note. The VAT code is translated to the supply code using settings from (TXS035). This section includes only records with the CVOP field set to 1 or with customer invoices. | 100-199 |
| A2 | Lines with IDs from 200 to 299 are used for section A2. These lines contain incoming supplier invoices and credit notes for goods and services delivered from the EU and other countries and separated by tax rate. The full rate is 21%, the primary reduced rate is 15% or 12%, and the secondary reduced rate is 10%. One line must be created per invoice and credit note. This section includes only records with the CVOP field set to 2 or with supplier invoices. | 200-299 |
| A3 | Lines with IDs from 300 to 399 are used for section A3. These lines contain local customer invoices and credit notes with special tax codes for gold. One line must be created per invoice and credit note. This section includes only records with the CVOP field set to 1 or with customer invoices. | 300-399 |
| A4 and A5 |
Lines with IDs from 500 to 599 are used for sections A4 and A5. These lines contain local customer invoices and credit notes. Invoices that are selected for this section, but without a VAT registration number or with a VAT registration number whose prefix differs from CZ, are always moved to section A5. Invoices as provided for in §44 or §46 of the ZDPH act are always listed in section A4, independently of the amount. These transactions have only a VAT amount and no base amount. If the VAT code is provided for in §44 of the ZDPH act and the total invoice amount including VAT, that is, the gross amount, is above CZK10.000,00, or another amount that has been specified in additional field 530 in ‘Tax Reporting. Open Report Fields’ (TXS035), then the record is always included in section A4. Standing payments or prepayments to be identified with specific VAT codes must be listed in sections A4 and B2, independently of the amount limit. Invoices are separated in the mapping, depending on their amount. Invoices and credit notes over CZK10.000,00 are listed per invoice in section A4. Invoices and credit notes of at most CZK10.000,00 are accumulated in one record in section A5. This section includes only records with the CVOP field set to 1 or with customer invoices. If the CVOP field is set to 0, then petty-cash transactions are not being connected to any customer and are accumulated in section A5. |
500-599 |
| B1 | Lines with IDs from 600 to 699 are used for section B1. These lines contain invoices and credit notes for local suppliers with reversed charges for special products, as provided for in §92a of the ZDPH act. One line must be created per invoice or credit note. The VAT code is translated to the supply code using settings from (TXS035). This section includes only records with the CVOP field set to 2 or with supplier invoices. | 600-699 |
| B2 and B3 |
Lines with IDs from 800 to 899 are used for sections B2 and B3. These lines contain local supplier invoices and credit notes. Invoices CZK10.000,00 are separated in the mapping, depending on the amount. Invoices and credit notes over CZK10.000,00 are listed per invoice in section B2. Invoices and credit notes of at most CZK10.000,00 are accumulated in one record in section B3. This section includes only records with the CVOP field set to 2 or with supplier invoices. Invoices as provided for in §44 or §74a of the ZDPH act are always listed in section B2, independently of the amount. These transactions have only a VAT amount and no base amount. If the VAT code is provided for in §44 of the ZDPH act and the total invoice amount including VAT, that is, the gross amount, is above CZK10.000,00, or another amount that has been specified in additional field 530 in ‘Tax Reporting. Open Report Fields’ (TXS035), then the record is always included in section B2. Standing payments and prepayments to be identified with specific VAT codes must be listed in sections A4 and B2, independently of the amount limit. If the CVOP field is set to 0, then petty-cash transactions are not being connected to any customer and are accumulated in section B3. |
800-899 |