Table of Contents

Sales/Purchase VAT Register

The Sales/Purchase VAT Register report is a basic report used for calculating amounts of sales and purchase VAT amounts for a selected period. The report shows the VAT base amount, VAT amount and detailed vendor and customer information for each document and unapplied VAT amount.

The VAT base amount and VAT amount are displayed separately for specific VAT rates. The application also displays the total VAT amount and the total of VAT amounts for each combination of groups specified in the VAT Bus. Post. Group and VAT Prod. Post. Group fields. In the Sales/Purchase VAT Register report, you can filter and view VAT entries based on VAT posting groups or VAT IDs, depending on the option selected while defining the setup for report printing.

Printing the Sales/Purchase VAT Register report

To prepare and print the Sales/Purchase VAT Register report:

  1. Choose Lightbulb that opens the Tell Me feature icon, enter Sales/Purchase VAT Register, and then select a related link.

  2. In the initial report window that opens, fill in the fields on the Options FastTab:

  • VAT Register Type - Select the transaction type. The following options are available:

    • Sales - Only sales transactions are displayed;
    • Purchase - Only purchase transactions are displayed;
    • Sales and Purchase - Sales and purchase transactions are displayed.

  • VAT Entries Grouping– Select the method for assigning multiple VAT entries to one document in the report. The following options are available:

    • Document No. – All VAT entries which contain the same character string in the Document No. field are displayed as lines within one document, regardless of the value in the External Document No. field.
    • External Document No. – All VAT entries which contain the same character string in the External Document No. field are displayed as lines within one document, regardless of the value in the Document No. field.

  • VAT Entries by - Select an option to define how the data is presented. The following options are available:

    • VAT Posting Groups,
    • VAT Identifier.

  • Include Reversed Entries - Select this field if you want to display reversed VAT entries (both the original and reversed entries are displayed).

  • Show Only Totals - Select this field if you want to display only the totals of VAT amounts in the selected period (the details of the register entries are not displayed).

  • Show Only Entries Skipped in VAT Register - Select this field if you want to display only entries marked as Skip in VAT Register.

  • Show Only Entries with FP VAT Attribute - Select this field if you want to display only records with the FP VAT attribute.

  1. In the same window, on the VAT Entries FastTab, in the **VAT Date field, enter the period filter for the VAT due date.
Note

Additionally, you can set up filters in other fields in order to limit the range of data to be included in the report:

  1. Select Print or Preview to receive the report.
Note

The report, either printed or viewed, displays all required document details: The first page contains column names and the last one shows summaries including general summaries and summaries for individual combinations of VAT posting groups.