Print VAT audit reports in the British version

In the United Kingdom, all vendors must export the data required for auditing in a comma-separated values (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.
  1. Select Search (Alt+Q) in the upper-right corner, 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.

    FieldDescription
    Export CustomersSelect to export customer numbers, names, and addresses from the Customer table.
    Export Open PaymentsSelect to export open customer credit entries.
    Export Late InvoicingSelect 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 maximum number of days between a customer's payment posting date and the related invoice posting date. If Export Late Invoicing is selected, entries exceeding this limit are exported. The value must be greater than zero.
    Export VendorsSelect to export vendor numbers, names, and addresses from the Vendor table.
    Export VAT EntriesSelect to export entries from the VAT Entry table. Use the VAT Reporting Date and Posting Date filters to limit the entries.

    Note


    You must select at least one checkbox 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.

Print the VAT entry exception report

  1. Select Search (Alt+Q) in the upper-right corner, 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, fill in the fields as described in the following table.

    FieldDescription
    VAT Base DiscountSelect to check for VAT base discounts that exceed VAT Base Discount %.
    Manual VAT Difference under CheckSelect to check for manual VAT differences that exceed the maximum Manual VAT Difference amount.
    VAT Calculation TypesSelect to compare the VAT calculation type on entries with VAT posting setup.
    VAT RateSelect to check for VAT rate differences that exceed VAT Rate % Difference.
    VAT Base Discount %Specify the maximum VAT base discount percentage. The initial value comes from VAT Tolerance % on General Ledger Setup.
    Manual VAT Difference under MaximumSpecify the maximum manual VAT difference. The initial value comes from Max. VAT Difference Allowed on General Ledger Setup.
    VAT Rate % DifferenceSpecify the maximum VAT rate difference. If no value is set, the report initially uses 0.1.

    Note


    You must select at least one checkbox in this page.

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

Find free e-learning modules for Business Central here