17 Print Value Added Tax (VAT) Reports

This chapter contains the topic:

17.1 Printing VAT Reports

Navigation

From General Systems (G00), choose Tax Processing and Reporting

From Tax Processing and Reporting (G0021), choose VAT Journals

It is a common business practice in Germany and throughout Europe to track and reconcile VAT by revenue and expense account.

You can use J.D. Edwards software to track and reconcile VAT by revenue and expense account by classifying each transaction as taxable or non-taxable. You can also give various reasons for the classification of each transaction. The system stores the tax information for transactions in the Sales/Use/VAT Tax file (F0018).

Run the VAT Journal program to print a VAT report. The VAT report includes all records in the Sales/Use/VAT Tax file that meet your data selections and processing option criteria.

You can customize the tax information that prints on VAT reports by defining up to five columns of tax information from the Sales/Use/VAT Tax file. Each column can represent up to twelve different Tax Rate and Areas. You can also specify whether a column contains taxable or tax amounts.

17.1.1 What You Should Know About

Option Explanation
Tax on sales or purchases You can print VAT reports to review the taxes on sales or the taxes on purchases.

To specify taxes on sales or purchases, include Document Type in the data selection. For example, to print a VAT report for purchases, specify Document Type PV.

Multiple currencies If you print a VAT report that includes multiple currencies, the system does not print a grand total. To see grand total amounts, print separate VAT reports for companies that have different currencies.
Report sequence You can sequence VAT reports by any field in the Sales/Use/VAT Tax file (F0018). The most common report sequence is as follows:
  • Company

  • Document Type

  • Document Number


17.1.2 Processing Options

See Section 31.4, "VAT Journals (P00320)."