If your sales data doesn’t come to us automatically through an integration, you send it with the Standard Template. Filling it in correctly means we can process your data and file on time without coming back to you with questions.
❓ Which guide should I follow?
During onboarding we’ll have told you which level of detail we need from you:
Order level: one row per order. This is the standard for most clients. Follow Guide 1.
Line level: one row per product in each order. We ask for this when your products are taxed differently from each other (for example, clothing and accessories), so each product gets the right tax treatment. Follow Guide 2.
Not sure which applies to you? Ask your Account Manager before you upload.
Rules for everyone
Upload once a month. Include all sales from the previous calendar month in one file, whatever your filing frequency.
Upload by the 10th of each month. Late uploads can delay your filings.
No sales this month? Don’t skip the upload. Select “I have no data to upload” in the portal.
Include every jurisdiction. Send sales from all states and countries, not just the ones where you’re registered.
Don’t change the template. Don’t rename, reorder, add or remove any columns.
Use positive numbers only. For refunds, set Transaction Type to
Refund. Don’t use minus signs.Leave empty cells empty. Don’t enter
0,N/A,Noneor-.Enter numbers only, no symbols. Write
150.00, not$150.00.
📖 Guide 1: Order level (one row per order)
Each order goes on a single row, and the amounts are totals for the whole order.
✏️ Order details
Column | Required? | What to enter |
A. Transaction ID | Optional | Your own reference for this specific transaction. A refund can have a different Transaction ID from the original order. |
B. Order Number | Required | Your order reference. Use the same Order Number on any refund for that order. |
C. Sales Channel | Required |
|
D. Transaction Date | Required | The date of the sale (normally the invoice date). For refunds, use the date the refund was processed, not the original order date. |
E. Product Tax Code | Leave blank | We fill this in. |
F. SKU | Leave blank | Not needed at order level. |
G. Item Description | Leave blank | Not needed at order level. |
H. Transaction Type | Required |
|
I. Exemption Type | If exempt | Only for tax-exempt sales. Enter one of: |
Missing exemptions are one of the most common causes of problems with manual uploads. If a sale was tax-exempt, always fill in column I.
✏️ Values (numbers only, no symbols)
Column | Required? | What to enter |
J. Currency | Required | The 3-letter code for the currency the customer paid in, e.g. |
K. Net Receipt (Pre-Tax) | Required | The total value of the order after discounts, excluding shipping and tax. |
L. Shipping Receipt (Pre-Tax) | If charged | The shipping amount charged to the customer, before tax. Keep it out of Net Receipt, because shipping isn’t always taxable. |
M. Tax Charged | If collected | The tax you collected at checkout. Leave blank if a marketplace collected the tax. |
N. Item Quantity | Leave blank |
|
O. Item Price | Leave blank |
|
P. Item Discount | Leave blank |
|
✏️ Ship To address: fill in all of these if the goods were physically shipped
Column | What to enter |
Q. Street | House number and street |
R. City | City or town |
S. Zip | US: |
T. State | US: the 2-letter state code, e.g. |
U. Country | The 2-letter country code, e.g. |
Ship From address (V to Z): optional for US sales, but required for all other regions. This is the address your goods were sent from, such as your warehouse or fulfilment centre. It can change how your sales are reported, especially if you ship from more than one location. Use the same formats as Ship To. Leave blank if you don’t know it.
Billing address (AA to AE): fill in if there’s no shipping address. Use these for digital products, services, subscriptions, or any sale with no shipping address. We use the billing address to work out where the sale should be taxed. Use the same formats as Ship To.
✏️ Data Source
Column | Required? | What to enter |
AF. Data Source | Optional | The system the data came from, e.g. |
📖 Guide 2: Line level (one row per product)
Everything in Guide 1 applies, with the following changes.
❓ How line level works
Split each order into one row per product. An order with three different products has three rows.
Use the same Order Number on every row for that order.
Put the order totals on the first row only. Net Receipt, Shipping and Tax Charged go on the first row of each order and cover the whole order, not just that product. Leave these columns blank on the order’s other rows.
Use the same address on every row of an order. Ship To (or Billing) details must match on every row.
Fill in the product details on every row:
SKU: required, so we can apply the right tax treatment to each product. Tell your Account Manager about any new SKUs so we can map them before you upload.
Item Description: a description of the product.
Item Quantity: the number of units of that product. Always positive.
Item Price: the price of one unit of that product.
Item Discount: the total discount for that row, not the discount per unit. Leave blank if there’s no discount.
✏️ Columns that work differently at line level
Column | Line-level rule |
F. SKU | Required on every row |
G. Item Description | Required on every row |
K. Net Receipt | First row of the order only. The total for the whole order after discounts, excluding shipping and tax. |
L. Shipping Receipt | First row of the order only. Blank on the other rows. |
M. Tax Charged | First row of the order only. Blank on the other rows. |
N. Item Quantity | Required on every row |
O. Item Price | Required on every row (unit price) |
P. Item Discount | Total discount for that row, if any |
Q to AE. Addresses | Identical on every row of the same order |
✏️ How Net Receipt should add up
Net Receipt on the first row should equal the total of all the order’s rows:
(Item Price × Item Quantity) minus Item Discount, added up across every row of the order.
Quick check before you upload
Everyone
Column headings are unchanged
All of last month’s sales are included, across all jurisdictions
No negative numbers, minus signs or currency symbols
Every row has a Transaction Type (
OrderorRefund) and a Sales Channel (WebshoporMarketplace)Exemption Type is filled in for every exempt sale
Ship To is complete for shipped orders, and Billing is complete where there’s no shipping address
Dates use the same format throughout
Empty cells are blank (no
0orN/A)
Line level only
Every row has a SKU, description, quantity and unit price
Net Receipt, Shipping and Tax Charged are on the first row of each order only
Order Number and address are the same on every row of an order
Net Receipt matches the total of the order’s rows
Questions? Message us here or contact your Account Manager.