UK VAT Detail Report

As part of generating an electronic report to HMRC for a UK VAT Return in Tax File Generation, you can also 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.

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. When you generate the UK VAT Detail report, on the General tab of the Tax File Generation form, in the AP Vouchers Use section, you select whether to use the voucher date or the invoice date as the Tax Point Date in the report.
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.
Recoverable Amount This column displays the Tax Amount minus the Non-Recoverable Tax Amount if the Tax Amount is not completely non-recoverable. If a tax code has a non-recoverable rate that is different than the tax rate, then only some of the tax amount is recoverable.
Gross Amount This column displays the total amount of the transaction: Net Amount + Tax Amount.