Bulk Transaction Uploads

Read about how to add transactions using a CSV file.

You can upload a group of transactions in bulk using the file upload feature. The file must use the CSV format and UTF-8 encoding.

Restrictions

The following restrictions apply:

  • Taxamo Assure by Vertex merchants cannot use this feature. See Taxamo Assure by Vertex
  • Vertex Advantage merchants cannot use this feature to upload USA-based transactions.
  • The feature is not intended to be used by standalone Invoice IQ merchants. See Standalone Invoice IQ Deployments.

Preparing the CSV File

The file must include the following columns:

  • Transaction ID
  • Order Date
  • Transaction Value
  • Currency Code
  • Transaction Type

Evidence is prioritized as follows:

  1. Billing country
  2. IP address
  3. Credit Card BIN
  4. Payment method country
  5. Other commercially relevant information

The following table list all the possible columns or fields. Mandatory fields are denoted by an asterisk:

FieldTypeComments
Transaction IDAlphanumericThis ID must be unique except when a transaction is refunded. In this case, you must list the sale before the refund.
Order DateDate DD/MM/YYYYThis is the transaction date. The quarter that the transaction is settled in is based on this date.
Ensure that the date and time are specified in the merchant's time zone.
For refunds , this date is used as the refund timestamp.
Transaction Value*Numeric MMM.nnThe total transaction value. To create a placeholder transaction for a subscription, enter 0.00.
Currency Code*ISO 4217The three letter code that represents the transaction currency.
Credit Card Bank Identification Number (BIN)6-9 NumericThe first 6 digits of the credit card number that identifies the issuer of the card.
Evidence priority: 3.
Payment Method CountryISO 3166 - 2 AlphaIf this is provided, it is used instead of the BIN. For example, you can derive this value from the PayPal sender country.
Evidence priority: 3.
IP AddressIPv4 dotted or IPv6 colonThe consumer's IP address when they made the purchase.
Evidence priority: 2.
Billing CountryISO 3166 - 2 AlphaThe customer's billing country.
Evidence priority: 1.
Other Commercially Relevant InformationISO 3166 - 2 AlphaAny other information about customer's country that was provided.
Evidence priority: 4.
Product Typedefault or e-book or /e-newspaperThe product type as defined by Taxamo. This is set to default if not provided.
Transaction Type*Sale or RefundIndicates whether the transaction was a sale or refund.
For refunds, the Transaction ID field must use an ID for a transaction that is already confirmed within Taxamo, or reference a Transaction ID used for a sale from earlier in the same file.
Buyer's NameAlphanumericThe name of the buyer. This value can be wrapped in double quotation marks. For example "John R. Smith".
Street NameAlphanumericThe name of the street where the buyer lives. This value can be wrapped in double quotes. For example "17th Avenue".
Building NumberAlphanumericThe number of the building where the buyer lives. This value can be wrapped in double quotes. For example "1 / 3".
Address DetailAlphanumericFurther details for the buyer's address. This value can be wrapped in double quotes. For example "Apartment no. 90".
CityAlphanumericThe buyer's city. This value can be wrapped in double quotes. For example "Colorado Springs".
Postal CodeAlphanumericThe buyer's postal code. This value can be wrapped in double quotes. For example "V3M 3B5".
Region CodeAlphanumericTwo-letter code representing the region, where applicable.
For example, the code for Quebec in Canada is QC. This information is required for tax calculation in Canada, if the region is enabled
DescriptionAlphanumericThe description of the product.
Buyer's Tax NumberAlphanumericThis is the buyer's tax number and is used for Business-to-Business validation.
The service only checks the syntax of this number.
Transactions that fail this check, are treated as Business-to-Consumer (B2C) and taxed accordingly.
Buyer's EmailAlphanumericThe buyer's email address.
Automatic email delivery is disabled for bulk uploads by default.
If you want to enable automatic mail delivery, contact customer support.

📘

Tip

To download an example file, open the dashboard and go to Transactions > Upload. Click Download example file.

Uploading the File

To upload the file, complete the following steps:

  1. Log on to the dashboard and go to Transactions > Upload.
  2. The Block file processing if transactions with non-matching evidence are found. checkbox is selected by default. We recommend that you do not change this.
    If you want to accept all transactions even where conflicting evidence exists, choose the Accept all transactions, even those with non-matching evidence. Evidence with the highest priority will be used. checkbox.
    If you want to flag transactions with conflicting evidence without accepting them, choose the Flag transactions with non-matching evidence, but create transactions where the collected evidence matches. checkbox.
  3. Click Choose File and select your CSV file.
  4. Click Submit for processing.

The report is available under the Recent uploads section.