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 of the invoice list VAT report (kv_dph_2017) and, for each section, the ranges of line IDs that must be strictly defined. This table shows the settings that are only applicable for this report:
| Section | Description | Line ID |
|---|---|---|
| A1 | Lines with IDs from 100 to 199 are used for section A1. These lines contain normal
customer invoices in the VAT report. Records that match these criteria are selected by
the mapping function: The customer or supplier code in the CVOP field is set to 1-AR invoice. No original invoice number on extra information 255 is provided. |
100-199 |
| A2 | Lines with IDs from 200 to 299 are used for section A2. These lines contain local
customer invoices with reversed charges. Records that match these criteria are
selected by the mapping function: The customer or supplier code in the CVOP field is set to 1-AR invoice. No original invoice number on extra information 255 is provided. |
200-299 |
| B1 | Lines with IDs from 300 to 399 are used for section B1. These lines contain EU
supplier invoices. Records that match these criteria are selected by the mapping
function: The customer or supplier code in the CVOP field is set to 2-AP invoice. No original invoice number on extra information 455 is provided. |
300-399 |
| B2 | Lines with IDs from 400 to 499 are used for section B2. These lines contain local
supplier invoices. Records that match these criteria are selected by the mapping
function: The customer or supplier code in the CVOP field is set to 2-AP invoice. No original invoice number on extra information 455 is provided. |
400-499 |
| B3 | Lines with IDs from 500 to 599 are used for section B3. These lines contain simplified total amounts of supplier invoices. This information is retrieved only from voucher lines in the general ledger. The customer or supplier code in the CVOP field is set to 0, that is, only invoices that are entered using the petty cash function in (GLS100) with layout 90 are included. Vouchers whose gross amount is of at least €3000,00 are inserted in section B3.2 and sorted per VAT registration number. Vouchers below €3000,00 are accumulated in section B3.1, in one record. | 500-599 |
| C1 | Lines with IDs from 600 to 699 are used for section C1. These lines contain
corrections on customer invoices in sections A1 and A2. Records that match these
criteria are selected by the mapping function: The customer or supplier code in the CVOP field is set to 1-AR invoice. The original invoice number on extra information 255 is provided. |
600-699 |
| C2 | Lines with IDs from 700 to 799 are used for section C2. These
lines contain corrections on supplier invoices in sections B1 and B2. Records that
match these criteria are selected by the mapping function: The customer or supplier code in the CVOP field is set to 2-AP invoice. The original invoice number on extra information 455 is provided. |
700-799 |
| D1 | Lines with IDs from 800 to 899 are used for section D1. These lines contain the total amount of cash received through cash sales. This information is retrieved only from voucher lines in the general ledger. | 800-899 |
| D2 | Lines with IDs from 900 to 999 are used for section D2. These lines contain the total amount of cash received through other sales. This information is retrieved only from voucher lines in the general ledger. | 900-999 |
This table shows the settings that are only applicable for the monthly VAT report DPH2021:
| Report line | Description | Line ID |
|---|---|---|
| 1 | 01 Dodanie tovaru a služby podľa §8 a 9 | 1 |
| 2 | 02 Dodanie tovaru a služby podľa §8 a 9 | 2 |
| 3 | 03 Dodanie tovaru a služby podľa §8 a 9 | 3 |
| 4 | 04 Dodanie tovaru a služby podľa §8 a 9 | 4 |
| 5 | 05 Nadobudnutie tovaru v tuzemsku podľa | 5 |
| 6 | 06 Nadobudnutie tovaru v tuzemsku podľa | 6 |
| 7 | 07 Nadobudnutie tovaru v tuzemsku podľa | 7 |
| 8 | 08 Nadobudnutie tovaru v tuzemsku podľa | 8 |
| 9 | 09 Tovary a služby, pri ktorých príjemca | 9 |
| 10 | 10 Tovary a služby, pri ktorých príjemca | 10 |
| 11 | Tovary, pri ktorých druhý odberateľ plat | 11 |
| 12 | Tovary, pri ktorých druhý odberateľ plat | 12 |
| 13 | Dodanie tovarov a služieb s oslobodením | 13 |
| 14 | Dodanie tovarov a služieb s oslobodením | 14 |
| 15 | Dodanie tovarov a služieb s oslobodením | 15 |
| 18 | Odpočítanie dane celkom podľa § 49 až 54 | 18 |
| 19 | Odpočítanie dane celkom podľa § 49 až 54 | 19 |
| 20 | Odpočítanie dane celkom podľa § 49 až 54 | 20 |
| 21 | Odpočítanie dane celkom podľa § 49 až 54 | 21 |
| 22 | Odpočítanie dane celkom podľa § 49 až 54 | 22 |
| 23 | Odpočítanie dane celkom podľa § 49 až 54 | 23 |
| 24 | Rozdiel v základe dane po oprave podľa § | 24 |
| 25 | Rozdiel v dani po oprave podľa § 25 ods. | 25 |
| 26 | Rozdiel v základe dane a v dani podľa § | 26 |
| 27 | Rozdiel v základe dane a v dani podľa § | 27 |
| 28 | Oprava odpočítanej dane podľa § 53 zákon | 28 |
| 29 | Oprava odpočítanej dane podľa § 53b záko | 29 |