This document explains how you print a VAT report using one of the six predefined types of reports in VAT Run. Open (TXS100).
One or several of the following reports are created:
A report listing VAT transactions in the General Ledger. A VAT control report can be summarized or detailed. The summarized report presents totals per VAT code and VAT account type as well as the total difference between calculated VAT and recorded VAT. The detailed report presents account and VAT account type, VAT code and VAT date, transaction code, base country and from/to country, a flag indicating whether a VAT registration number is registered for the customer, calculation base amount, VAT amounts, recorded VAT, voucher number, customer/supplier number, invoice number, invoice year and invoice date, FAM function used, and a comment on any difference between calculated and recorded amount entered on the coding panel (GLS120), and any difference for the voucher.
The detailed report can be sorted on VAT code and voucher number (layout 1), voucher number and VAT code (layout 2), or on each combination of invoice number, VAT code, and VAT rate per customer or supplier, ending with a report summary based on the VAT code and VAT rate (layouts 3 and 4).
A report with VAT transactions in the General Ledger based on a user-defined template. A summarized VAT template report lists totals presented per line and column according to the selections in the template. A detailed VAT template report lists all General Ledger transactions tagged with the current VAT template report number per line and column according to the template selections. The detailed report presents voucher number, accounting date, VAT date, VAT code, account and VAT account type, base country and from/to country, and VAT rates in percent.
A report for internal reconciliation of the VAT run based on a VAT template report and the General Ledger. The report contains the following layouts:
A report for internal reconciliation of the VAT run based on a VAT template report and the sales report created in EU Quarterly Sales Report. Open (CRS345). Note that the reporting of EU sales is done in EU Sales/Purchase. Open Proposal (TXS130). Since the report created there is based on a VAT report template and consequently will always agree with the VAT report, the TX/QR report serves no purpose as of that fix pack onwards.
The numbers of the VAT reports are saved in the table for detailed General Ledger information (FGLEDX).
Select the Print option for a VAT run in 'VAT Run. Open' (TXS100/B).
On the E panel, select type of report, whether the report should be summarized or detailed and whether voucher texts should be printed.
For VAT template reports and TX/QR reconciliation reports, select a VAT report template as well (mandatory).
On the next panel (the H panel for control reports, the I panel for the other reports), enter the VAT date up to which transactions are selected (mandatory).
To narrow the selection, specify a range of VAT codes and voucher numbers (optional).
For control reports, enter ranges of any of the following values on the H panel if you use report layout 3 or 4: customer or supplier, invoice number and invoice year.
For all types of reports, carry out a deviation test (if applicable) by entering a difference (deviation) between calculated VAT and recorded VAT either as a percentage or an amount (optional).
Select which type of VAT transactions to include in the Include reported transactions field:
Neither of the alternatives includes transactions with VAT reported status 1=VAT on payment day. Normally only non-declared VAT transactions would be included in a VAT run. However, for analysis purposes it may be relevant to include also declared VAT transactions, for example, when printing a report of the VAT for the entire year.
Select one of these alternatives:
For all types of reports, enter a report text (optional). Press Enter to print the report.