Audit Report

The Audit report details the liability per line item and shows the relevant tax rates, shipping information and other transactional data provided by the Marketplace.

To access it, open the UI and click Audit Report. Choose your filters and click Schedule report.

Many of the fields listed above are also returned in the transaction response when the transaction is confirmed. These API response fields can be used by the Marketplace to provide liability data to their own reporting tools or ERP systems.

Filters

The report provides several useful filters so you can choose precisely what data you want to display in the report. The filters are shown below:

726

Audit Report

The filters are explained in the following table:

Filter FieldDescription
Report period lengthSpecify the length of the period covered in the report.
Report scopeSpecify the parties you want to be in the report such as the Platform, Seller or Buyer or for all three combined. You can also filter data for self-billed transactions
Product classesSpecify the product class, usually Physical. See Product Classes.
CurrencyChoose the currency that you want to apply to the report. Any transactions in other currencies will be converted and displayed in columns prefixed with FX converted in the column name.
FX sourceSpecify the source of the rate used in currency conversions. Currency conversions can use a number of different FX sources. For example, the ECB means the rate was supplied by the European Central Bank.
FX date typeChoose one of the following date types for currency conversions:
- Order date: The date of the transaction or the order date provided with the transaction.
- Day before order date: The rate that was available on the system on the day of the transaction.
- Last day from selected date rate: The rate is taken on the last day of the reporting period.

CSV Download

There is an option to schedule this report and a CSV file is created for download.

The reports show at line item level why each line item within a transaction was assigned to the marketplace, the underlying seller or the buyer, giving a clear text reason why each decision was made. Other information such as shipping country and parcel / carrier references will be included as provided in the transaction details sent to the API.

Fields

General

The following columns are output in the CSV file:

Column NameDescription
Transaction typeType of transaction, usually either a sale or a refund.
Product classThe product class indicates the type of product. See Product Classes.
Tax liability ownerThe party responsible for settling the tax owed to the Tax Authority (Platform, Seller, Buyer).
Invoice numberThe number of the invoice for the transaction.
Seller platform nameThe name of the platform that the Seller is selling from.
Seller platform codeThe unique identifier of the platform in the the service.
Seller customs IDCustoms identifier associated with the seller.
Order dateThe date of the transaction.
Currency codeThe currency of the transaction.
Target currency codeThe currency of the tax report.
Tax Country codeThe country code of the tax authority.
Tax country nameThe long name of the country of the tax authority.
Fx sourceThe source of the exchange rate used to calculate the tax due in the currency of the tax authority.
Tax rateThe tax rate that used for the transaction line item.
AmountThe base amount excluding tax (in the original currency of the sale).
Tax amountThe tax amount of the transaction (in the original currency of the sale).
FX converted amountThe base amount excluding tax in the tax reporting currency.
FX converted tax amountThe tax amount of the transaction in the tax reporting currency.
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.
Liability rule appliedThe rationale behind the assignment of the tax liability owner.
Carrier idThe unique identifier of the logistics company.
Parcel referenceIdentifier assigned to a parcel. Items that are packaged together.
Goods shipped from country codeThe country code where the goods have been shipped from.
Goods shipped from country nameThe long name of the country where the goods have been shipped from.
Ship to address country codeThe country code of the country where the goods have been shipped to.
Ship to addressThe address to where the goods have been shipped to.
Ship to address country nameThe long name of the country to where the goods have been shipped to.
Billing address country codeThe billing address country code of the customer who has purchased the goods.
Billing addressThe billing address of the customer who has purchased the goods.
Billing address country nameThe billing address long country name of the customer who has purchased the goods.
Exchange rateThe exchange rate used to calculate the tax due in the currency of the tax authority.
Exchange rate dateThe date that the exchange rate used to calculate the tax due in the currency of the tax authority was provided.
KeyThe transaction key is a unique and generated by the service.
Referenced keyIn the case of a self-billed invoice, this will be the transaction key of the sale to the customer.
Invoice URLA link to the appropriate invoice generated following the transaction completion.

US Fields

The following fields are relevant for the US:

FieldDescription
Tax component tax nameType of sales tax, for example State, County, City, Special
Tax component tax amountAmount of sales tax on the transaction
Tax component tax rateThe rate of sales tax
Tax component jurisdiction codeCode of the taxing jurisdiction
Tax component tax authority idTax authority ID
Tax component tax authority nameTax authority name
Tax component taxable percentPercentage of the value that is taxable