UK VAT Detail Report

As part of generating an XML file for UK VAT declarations, you can generate a detailed report that shows the transactions used. Use the report to verify that the correct transactions were used for each box number.

The report is generated in preview mode, letting you print, email, or download the report.

It includes a total line for each box number and tax code.

If 999 was used as a box number, the report translates it as zero.

Contents

Field Description
Transaction Type This column displays the two-letter abbreviation for the type of transaction.
Invoice/Reference This column displays the invoice number or transaction reference number associated with the transaction.
Diary Code This column displays if the company is configured as one that uses diaries, on the Diary Auto Numbering Options section of Settings > Accounting > Transactions. This column displays the Diary Code associated with the transaction. The diaries are used to generate diary reports that contain a set of sequentially numbered transactions that have been posted to the general ledger during the fiscal year, or specific fiscal periods.
Diary Number This column displays if the company is configured as one that uses diaries, on the Diary Auto Numbering Options section of Settings > Accounting > Transactions. This column displays the automatically generated Diary Number associated with the transaction.
Period This column displays the accounting period in which the transaction was posted.
Post Sequence This column displays the posting sequence number for the transaction. Sequence numbers are assigned during the posting process: 1 to the first group of transactions posted during an accounting period, 2 to the second group, and so on.
Tax Point Date This column displays the date that the transaction took place for tax purposes.
Transaction Date This column displays the date recorded for the transaction.
Vendor/Client/Employee Name This column displays the vendor, client, or employee name associated with the transaction.
Project/Phase/Task This column displays the WBS element associated with the transaction.
Tax Account This column displays the account number where the tax amount was posted.
Base Account This column displays the account number where the base amount was posted.
Net Amount/Tax Basis This column displays the net amount of the transaction.
Tax Amount This column displays the amount of tax on the transaction.
Gross Amount This column displays the total amount of the transaction: Net Amount + Tax Amount.