Skip to main content

Legal

Featured

Questions? We are here to help
Contact us

Tax & Accounting

Featured

Questions? We are here to help
Contact us

Trade & Supply

Featured

Questions? We are here to help
Contact us

Risk & Fraud

News & Media

Books

Developers

Reports & Analytics

VAT Document Details report

Purpose

This report summarizes document data for all countries with VAT (value added tax) transactions by document, document line, and tax line. This report assists you in understanding what was taxed and why by allowing focused analysis by tax amount.
For transactions taxed outside the U.S. (including Canada), this report gives document-by-document reconciliation between Determination and your ERP (enterprise resource planning). It provides all the underlying detail records that make up data in the summary reports. You can use detail reports in audit defenses or in the reconciliation process. You can also use detail reports to bring data into other business systems or into Excel for further data manipulation and summarization as required by your business needs.
When transactions are a mix of both U.S. and non-U.S. taxable countries, all the results can't appear in the report, because the U.S. transaction tax lines aren't included. For multiple ERP systems (host systems and calling systems), the Calling System Number and Host System columns are indicators of the source system where the document originated.
The document gross amount and tax amount filters are designed specifically for documents that haven't been recalculated or reversed. Therefore, if you're filtering on amounts that have been recalculated, you will only see documents with a positive gross amount. This affects document totals being summarized, since the negative gross amount won't be included in the summation.

Audience

Tax preparation professionals who are reconciling the general ledger and preparing VAT returns.

Parameters

Parameter
Required
Default
Description
Company Name(s)
Yes
None
Lists all companies in the database that are available to the current user. Select one or more company names.
Start Date
Yes
None
Enter the date or use the calendar to select the date. The date must be in YYYY-MM-DD format.
End Date
Yes
None
Enter the date or use the calendar to select the date. The date must be in YYYY-MM-DD format.
Date Type
Yes
Transaction
Identifies 1 of the following date types for transactions in the database:
  • Transaction - The date range is based on the date the tax calculation occurred for the document.
  • Document - The date range is based on document dates.
  • Fiscal - The date range is based on fiscal dates indicated by each transaction.
Company Role(s)
No
None
Select Buyer, Middleman, or Seller. If nothing is selected, all roles are reported.
Taxable Country(s)
No
None
List the country or countries where the selected company(s) have tax obligations.


When filtering on this value, the report shows only the amounts associated with the select value(s). For example, if you filter to show only a particular country, the report shows only the amounts and details for that country - the reported amounts will not reflect the full document amount.

Tax Type(s)
No
None
Lists tax types defined in Determination that are available for the selected companies. .


When filtering on this value, the report shows only the amounts associated with the select value(s). For example, if you filter to show only a particular country, the report shows only the amounts and details for that country - the reported amounts will not reflect the full document amount.

Currency Code(s)
No
None
Lists currencies according to the selected company or companies. Select individual currencies or all.
Document Number
No
None
Enter document numbers to include in the report. Use wildcards to retrieve multiple numbers.
Gross Amount
No
None
This value will be shown on the Document level of the report. Use wildcards to retrieve multiple amounts.


Select an operator to filter results on the document gross amount you enter in the field. For example, select > then enter 100 to retrieve all document gross amounts greater than 100.

Wildcards aren't available for the Line level of the report.
Tax Amount
No
None
This value will be shown on the Document level of the report. Use wildcards to retrieve multiple amounts.


Select an operator to filter results on the document tax amount you enter in the field. For example, select >= and enter 200 to retrieve all document tax amounts greater than or equal to 200.

Attributes & Operators
No
None
Select one or more attributes to include as report filters or columns.

This article applies to:

  • PRODUCT: ONESOURCE Determination, ONESOURCE Indirect Tax
  • Subject: Reports

Related Content