Overview
We require the information listed below to format your sales data accurately for sales tax reporting and filing purposes.
If you have any questions, please get in touch with your onboarding specialist or [email protected]. We’ll be happy to help!
Please see the article here for guidance on exporting your sales data.
Zamp CSV Template (open link in new tab)
You can use the table below and the attached example file as a reference to create a CSV file, which we can then import into Zamp.
Please note that refund transactions should have negative amounts for the following fields: transactionShippingHandling, transactionSubtotal, transactionDiscount, transactionTax, and transactionTotal.
Column Name | Is it required? | What is the column used for? | Notes |
transactionId | Yes | The ID for the transaction. | This might be referred to as an invoice ID, Order ID, or something similar. |
transactionParentId | No | For refund Transactions only. The ID for the original order transaction. | This ID would be helpful if it were available. |
marketplace | No | The marketplace where the sale took place. Here’s what we support:
AMAZON, META, TIKTOK, WALMART, TARGET_PLUS, ETSY, EBAY, MIRAKL, MACYS, and ALIBABA | We share more details about why this is important in this story.
If the sale didn't take place through a marketplace, this can be FALSE. |
wholesale | No | True, false, or blank to note if the order (or refund) was sold to a wholesaler/resaler. | If this column is blank, we’ll default to ‘false.’ |
transactionDiscount |
| The total discount for the order or refund. | We’ll default to 0 if this is left blank.
This number should always be positive, such as 5 or 5.25; it cannot be a percentage. |
transactionSubtotal | Yes | The combined total of the order or refund after the discount. | Shipping, handling, or tax should not be included in this total. |
transactionShippingHandling | No | The combined shipping and handling cost for an order or a refund. | If this column is blank, we’ll default to 0.
The number entered here should be formatted like 5 or 5.25. |
transactionTax | Yes | The total tax collected for an order or the total tax refunded for a refund. | If this is blank, we’ll default to 0. |
transactionTotal | Yes | The total amount charged for an order or refunded for a refund. | This number should equal the subtotal, plus shipping and handling, plus tax. |
transactionDate | Yes | The date the order or refund occurred. | Example: 10/21/2024 |
shipToAddress1 | No | The first line of the shipping address. | If available, we recommend including this detail for the most accurate sales tax reporting.
Example:
1234 Example Dr |
shipToAddress2 | No | The 2nd line of the shipping address. | Examples:
Suite 23 Building 5 Apt 16 |
shipToCity | No | The shipping city. Required if a shipToZip is not provided or available. | Example:
Cincinnati |
shipToState | Yes | The shipping state.
Required if a shipToZip is not provided or available. | Zamp currently supports states within the United States of America, Puerto Rico (PR), and provinces within Canada.
This is required for Canada and preferred for the US. |
shipToZip | Yes | The shipping zip code. | US zip code example: 12345 12345-6789
Canada postal code example: H1A 0A0 |
shipToCountry | Yes | The shipping country. | We support ‘US’ and 'CA'. |
currency | Yes | The transaction's currency. | If left blank, this defaults to 'USD'. |
productTaxCode | No | If you want to assign a specific Zamp Tax Code to the transaction. | If left blank we assume the product is fully taxable. (Exemptions could still apply) |
Order and Refund Transaction Ship To Address Requirements
For transactions involving customers within the US, the minimum information required is:
The zip code, or the city and state.
For transactions involving customers outside of the US, the minimum information required is:
The city and country.
The country should be a 2 or 3-character ISO code.
Please note that for physical products, use the shipping address. For digital, service, or non-physical products, the billing address should be used.
Automated Data Checks
When uploading your CSV in Zamp, there are automatic checks Zamp will run to ensure the provided data will result in accurate tax calculations for your filings.
Once a CSV is uploaded, click Analyze CSV to initiate the Zamp data check. This will allow Zamp to run through the 4 validation categories below:
Validation Categories
Shipping Address
Why: To account for state-by-state differences and to bucket your transactions into the correct state. A minimum of a city or state is required.
Transaction Amounts
Why: To ensure all amounts reconcile properly when completing returns.
Exemption Reasons
Why: Exemptions should be tagged appropriately to avoid unexplained zero tax transactions.
Date Formats
Why: Confirming all transactions are flowing into the correct filing periods.
If the data check returns transactions with errors, you will be able to click into each category to review each transaction. Once changes are resolved, you will be able to re-attempt the upload.
If you are unsure how to resolve any errors flagged by Zamp's automated checks, click the Get help from our team button and our team will assist. Please provide as much information as you can.