Detailed settlement report fields

The following are the fields that can be found in the Detailed settlement report.

Field NameDescription
Transaction typeThis is the type of transaction a sale or a refund
Exchange rateThe exchange rate that was applied to sale currency
Exchange rate dateThe date on which the exchange rate is from
F/X sourceWhat is the source of the exchange rates
Currency codeThe currency of the transaction
Target currency codeThis is the currency of the tax report
KeyUnique Taxamo transaction key
Country codeCountry code of the determined country
Tax country nameFull name of the country determined by the service
Tax deductedWas the tax deducted from the sale
AmountBase amount less tax
FX converted amountBase amount less tax in the tax reporting currency
Tax amountTax amount of the transaction
FX converted tax amountTax amount of the transaction in the tax reporting currency
Tax rateTax rate that was used for the transaction
Total amountAmount plus the tax amount equals to the Total amount
FX converted total amountAmount plus the tax amount equals to the Total amount in the tax reporting currency
Product typeThe service's reference for the type of good that is being sold
Custom idThis is an unique id that you can include in the transaction line
Order dateThis is the date of the sale
Refund dateThis is date of the refund
Invoice numberNumber of the invoice for the sale
Postal codeThe postal or ZIP code of the customer
RegionThe region or state of the customer
Sub account idWhen using Assure, this is a unique Taxamo ID referring to your business
External unique idA unique ID reference to your business
Product classThis is the type of product that you are selling either digital or physcial
Line Invoice numberInvoice 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 nameTax 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:

FieldDescription
Tax component tax nameType 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 amountAmount of sales tax on the transaction
Tax component tax rateThe rate of sales taxv
Tax component jurisdiction codeCode of the taxing jurisdiction.
Tax component tax authority IDTax authority ID.
Tax component tax authority nameTax authority name.
Product codeFor US sales tax this will have a reference number of the type of product being sold.