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.
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 . 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 . 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. |
Parent Topic: Learn More About...