Print VAT Audit Reports in the British Version

In the United Kingdom, all vendors must export the data required for auditing in a Content Separated Value (CSV) file format. The following reports in the British version of Business Central comply with this requirement:

• VAT Audit report – This report is used for VAT auditing.
• VAT Entry Exception report - This report details the differences between the calculated VAT and the changes that occur because of rounding, VAT tolerance percentage, and discounts. It also displays the difference in VAT amounts for the tax authorities.

To print the VAT audit report

1. Choose the icon, enter VAT Statements, and then choose the related link.

2. Choose the relevant VAT statement template, and then choose OK.

3. On the VAT Statement page, choose VAT Audit Report.

4. On the VAT Audit page, on the Options FastTab, fill in the fields as described in the following table.

   Field	Description
   Export Customers	Select to export the file to the Customer table.
   Export Open Payments	Select to export the open credit entries.
   Export Late Invoicing	Select to export customer entries that took longer to invoice than the number of days specified in the Late Invoice Delay (Days) field.
   Late Invoice Delay (Days)	Enter the number of days between the invoice issue date and the payment received date. If the Export Late Invoicing field is selected, entries exceeding this limit will be exported.
   Export Vendors	Select to export the file to the Vendor table.
   Export VAT Entries	Select to export the entries in the VAT Entry table.

   Note

   You must select at least one check box in this page.

5. To export the file, choose the OK button.

   The VAT audit information is exported. You can save the data to a file, or open the file in the appropriate program.

To print the VAT entry exception report

1. Choose the icon, enter VAT Statements, and then choose the related link.

2. Choose the relevant VAT statement template, and then choose OK.

3. On the VAT Statement page, choose VAT Entry Exception Report.

4. On the VAT Entry Exception Report page, on the Options FastTab, fll in the fields as described in the following table.

   Field	Description
   VAT Base Discount	Select if you want to enter a value in the VAT Base Discount % field.
   Manual VAT Difference	Select if you want to enter a value in the Manual VAT Difference field.
   VAT Calculation Types	Select to determine the VAT calculation type.
   VAT Rate	Select to determine the VAT rate for a particular journal line.
   VAT Base Discount %	Enter a value in this field if you have selected the VAT Base Discount field.
   Manual VAT Difference	Enter a value in this field if you have selected the Manual VAT Difference field.
   VAT Rate % Difference	Specify the maximum VAT rate difference.

   Note

   You must select at least one check box in this page.

5. Choose the Print button to print the report or choose the Preview button to view it on the screen.

See Also

Working with Reports, Batch Jobs, and XMLports
Report VAT to Tax Authorities
United Kingdom Local Functionality

Note

Can you tell us about your documentation language preferences? Take a short survey.

The survey will take about seven minutes. No personal data is collected (privacy statement).