Detailed settlement report fields
The following are the fields that can be found in the Detailed settlement report.
Field Name | Description |
---|---|
Transaction type | This is the type of transaction a sale or a refund |
Exchange rate | The exchange rate that was applied to sale currency |
Exchange rate date | The date on which the exchange rate is from |
F/X source | What is the source of the exchange rates |
Currency code | The currency of the transaction |
Target currency code | This is the currency of the tax report |
Key | Unique Taxamo transaction key |
Country code | Country code of the determined country |
Tax country name | Full name of the country determined by the service |
Tax deducted | Was the tax deducted from the sale |
Amount | Base amount less tax |
FX converted amount | Base amount less tax in the tax reporting currency |
Tax amount | Tax amount of the transaction |
FX converted tax amount | Tax amount of the transaction in the tax reporting currency |
Tax rate | Tax rate that was used for the transaction |
Total amount | Amount plus the tax amount equals to the Total amount |
FX converted total amount | Amount plus the tax amount equals to the Total amount in the tax reporting currency |
Product type | The service's reference for the type of good that is being sold |
Custom id | This is an unique id that you can include in the transaction line |
Order date | This is the date of the sale |
Refund date | This is date of the refund |
Invoice number | Number of the invoice for the sale |
Postal code | The postal or ZIP code of the customer |
Region | The region or state of the customer |
Sub account id | When using Assure, this is a unique Taxamo ID referring to your business |
External unique id | A unique ID reference to your business |
Product class | This is the type of product that you are selling either digital or physcial |
Line Invoice number | Invoice line item, this is in the case where you could be selling 2 different products and they could have different tax rates/treatment and Vertex could issue multi-invoices |
Line Tax Country name | Tax country for the line item, this is in the case where you could be selling 2 different products and they could have different tax rates/treatment |
The following fields are provided for the USA:
Field | Description |
---|---|
Tax component tax name | Type of sales tax, it can be STATE SALES TAX, COUNTY SALES TAX, DISTRICT TAX, CITY SALES TAX ,SPECIAL LOCAL - CAPITAL PROJECTS or SPECIAL LOCAL - EDUCATION CAPITAL IMPROVEMENT. |
Tax component tax amount | Amount of sales tax on the transaction |
Tax component tax rate | The rate of sales taxv |
Tax component jurisdiction code | Code of the taxing jurisdiction. |
Tax component tax authority ID | Tax authority ID. |
Tax component tax authority name | Tax authority name. |
Product code | For US sales tax this will have a reference number of the type of product being sold. |
Updated 6 months ago