Detailed settlement report fields

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

CountryField NameDescription
All CountriesTransaction typeThis is the type of transaction a sale or a refund
All CountriesExchange rateThe exchange rate that was applied to sale currency
All CountriesExchange rate dateThe date on which the exchange rate is from
All CountriesFx sourceWhat is the source of the exchange rates
All CountriesCurrency codeThe currency of the transaction
All CountriesTarget currency codeThis is the currency of the tax report
All CountriesKeyUnique Taxamo transaction key
All CountriesCountry codeCountry code of the determined country
All CountriesTax country nameFull name of the country determined by the service
All CountriesTax deductedWas the tax deducted from the sale
All CountriesAmountBase amount less tax
All CountriesFX converted amountBase amount less tax in the tax reporting currency
All CountriesTax amountTax amount of the transaction
All CountriesFX converted tax amountTax amount of the transaction in the tax reporting currency
All CountriesTax rateTax rate that was used for the transaction
All CountriesTotal amountAmount plus the tax amount equals to the Total amount
All CountriesFX converted total amountAmount plus the tax amount equals to the Total amount in the tax reporting currency
All CountriesProduct typeThe service's reference for the type of good that is being sold
All CountriesCustom idThis is an unique id that you can include in the transaction line
All CountriesOrder dateThis is the date of the sale
All CountriesRefund dateThis is date of the refund
All CountriesInvoice numberNumber of the invoice for the sale
All CountriesPostal codeThe postal or ZIP code of the customer
All CountriesRegionThe region or state of the customer
All CountriesSub account idWhen using Assure, this is a unique Taxamo ID referring to your business
All CountriesExternal unique idA unique ID reference to your business
All CountriesProduct classThis is the type of product that you are selling either digital or physcial
All CountriesLine 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
All CountriesLine 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
Extra fields for the US detailed settlement report
USATax component tax nameType of sales tax, it can be STATE SALES TAX, COUNTY SALES TAX, DISTRICT TAX, CITY SALES TAX ,SPECIAL LOCAL - CAPITAL PROJECTS
SPECIAL LOCAL - EDUCATION CAPITAL IMPROVEMENT
USATax component tax amountAmount of sales tax on the transaction
USATax component tax rateThe rate of sales tax
USATax component jurisdiction codeCode of the taxing jurisdiction
USATax component tax authority idTax authority ID
USATax component tax authority nameTax authority name
USAProduct codeFor US sales tax this will have a reference number of the type of product being sold