The below table outlines each column in the CSV and the column descriptions. Use this table to assist with completing your CSV to ensure your import is successful. If entries in the columns do not match the formatting below, or there are missing fields for required columns, the CSV upload will error and fail to load.

The below table outlines each column in the CSV and the column descriptions. Use this table to assist with completing your CSV to ensure your import is successful. If entries in the columns do not match the formatting below, or there are missing fields for **required** columns, the CSV upload will error and fail to load.


---


:::info
Transactions uploaded with **ExcludeFromFiling = TRUE** will **not** be included in tax reporting or filing. These transactions will **not** count toward your order billing totals. 

:::

| **Column** | Column Name | Column Description | Example |
|----|----|----|----|
| 0 | OrderID\* | **Required**  \n  \nAlphanumeric  \n  \n50 character limit  \n  \nUnique ID to identify each order, credit memo, or return. Can come from the business application. Multiple items within an order will have the same OrderID. See CartItemIndex to differentiate line items.  \n  \nReturned transactions use the original OrderID with a negative CartIndex | 54b-9737-v981 |
| 1 | CustomerID\* | **Required**  \n  \nAlphanumeric  \n  \n50 character limit  \n  \nIdentifies the order customer. Can come from the business application | A-123-253b |
| 2 | TransactionDate\* | **Required**  \n  \nNumerical Date YYYYMMDD  \n  \nDate the transaction or quote was initialized. | 20230914 |
| 3 | AuthorizedDate\* | **Required**  \n  \nNumerical Date YYYYMMDD  \n  \nDate the transaction was authorized. | 20230914 |
| 4 | CapturedDate\* | **Required**  \n  \nNumerical Date YYYYMMDD  \n  \nDate the transaction has been finalized or completed. | 20230914 |
| 5 | DeliveredBySeller\* | **Required**  \n  \n0 = delivered outside of the seller  \n1 = delivered by seller  \n  \nIdentifies if the seller delivered the items. | 1 |
| 6 | ShipFromAddr1 | *Optional.* *Suggested for accurate calculations & returns.*  \n  \nAlphanumeric  \n  \n50 character limit  \n  \nOrigin address line 1 | 400 Broad St |
| 7 | ShipFromAddr2 | *Optional*  \n  \nAlphanumeric  \n  \n50 character limit  \n  \nOrigin address line 2 | Unit 4 |
| 8 | ShipFromCity | *Optional. Suggested for accurate calculations & returns.*  \n  \nText  \n  \n50 character limit  \n  \nOrigin city | Seattle |
| 9 | ShipFromState | **Required**  \n  \nText  \n2 character limit  \n  \nOrigin state abbreviated | WA |
| 10 | ShipFromZip5\* | **Required**  \n  \nNumerical  \n  \n5 character limit  \n  \nOrigin 5-digit zip code  \n\*Make sure your file doesn’t remove leading zeros | 98109 |
| 11 | ShipFromZip4 | *Optional. Suggested for accurate calculations & returns.*  \n  \nNumerical  \n  \n4 character limit  \n  \nOrigin +4 zip code  \n\*Make sure your file doesn’t remove leading zeros | 4607 |
| 12 | ShipToAddr1 | *Optional. Suggested for accurate calculations & returns.*  \n  \nAlphanumeric  \n  \n50 character limit  \n  \nDestination address line 1 | 20 W 34th St |
| 13 | ShipToAddr2 | *Optional. Suggested for accurate calculations & returns.*  \n  \nAlphanumeric  \n  \n50 character limit  \n  \nDestination address line 2 | Apt. 123 |
| 14 | ShipToCity | *Optional. Suggested for accurate calculations & returns.*  \n  \nText  \n  \n50 character limit  \n  \nDestination city | New York |
| 15 | ShipToState | **Required**  \n  \nText  \n  \n2 character limit  \n  \nDestination state abbreviated | NY |
| 16 | ShipToZip5\* | **Required**  \n  \nNumerical  \n  \n5 character limit  \n  \nDestination 5-digit zip code  \n\*Make sure your file doesn’t remove leading zeros | 10118 |
| 17 | ShipToZip4 | *Optional. Suggested for accurate calculations & returns.*  \n  \nNumerical  \n  \n4 character limit  \n  \nOrigin +4 zip code  \n\*Make sure your file doesn’t remove leading zeros | 0114 |
| 18 | CartItemIndex\* | **Required**  \n  \nNumerical  \n  \nStarting from 0 to 100  \n0 = line item 1  \n1 = line item 2  \n2 = line item 3  \nEach line item must have a unique value per OrderID.  \nIf an order has more than 100 line items, reach out to TaxCloud  \n  \nSupport to expand.  \nReturning transactions needs the associated cart item index | 0 |
| 19 | CartItem\* | **Required**  \n  \nAlphanumerical  \n50 character limit  \nIdentifies the product. Ex: SKU, item code from the business application, or description. | Product_A |
| 20 | CartItemTIC\* | **Required**  \n  \nNumerical  \nTaxCloud Taxability Information Code for items with special taxability.  \nEx – clothing, food, shipping.  \n99999 will accept previously calculated tax.  \n[TaxCloud TIC Guide](https://support.taxcloud.com/article/109-taxability-information-codes) | 99999 |
| 21 | CartItemPrice\* | **Required**  \n  \nNumerical  \nPrice of the line item. Always a positive value. | 19.21 |
| 22 | CartItemQty\* | **Required**  \n  \nNumerical  \nQuantity of items.  \nReturn a transaction within TaxCloud by using a negative quantity amount. Do not use a negative price amount. | 2 or -2 |
| 23 | CartItemTaxRate | *Optional*  \n  \nNumerical  \n0\.99 (99%) rate limit  \nTax rate used to calculate | .09125 |
| 24 | CartItemTaxAmount | *Optional. (Required for previously calculated transactions using TIC 99999.)*  \n  \nTax amount due for the line item. | 3.51 |
| 25 | ExcludeFromFiling | **Required**  \n  \nText  \n5 character limit  \nIndicate TRUE or FALSE. TRUE indicates that a transaction should not be included in filing. FALSE indicates that a transaction should be included in filing. | FALSE |
| 26 | ExemptionCertificateID | *Optional*  \n  \nAlphanumerical  \n50 character limit \nUniquely identifies an exemption certificate. The ExemptionCertificateID must exactly match the ExemptionCertificateID created for the merchant. | 1d35b070-1078-ea11-8208-a27b761741c1 |




CSV Template Required Fields and Column Descriptions

Navigating Your Tax Dashboard

How to View and Share Transaction Details

How to Locate a Transaction URL in TaxCloud

Setting the Transaction Shipping Destination

How to Manually Add a Transaction

Transaction Timestamp Policy

How to Filter Transactions with Advanced Search

Managing your transactions

How to manually return a transaction in TaxCloud?

Can I edit a transaction?

Transactions: Overview

Using the Download Center for Reports

When does TaxCloud pull my tax funding?

Does Washington B&O (excise) Tax Appear in Your TaxCloud Reporting?

Understanding Tax Reports and Drilling Into Transaction Details

Understanding the differences between TaxCloud Tax Reporting and Your Platform's Tax Reporting

Reporting

How to Troubleshoot CSV Upload Errors

How to Format Your CSV File for Transaction Uploads

Uploading Transactions via CSV

Uploading Historical and Marketplace Transactions via CSV

How to Import Partial Refunds via CSV

When is the deadline to upload my transactions to TaxCloud?

Why are exempt sales taxing in my import?

What is TaxCloud's policy regarding Transaction import timing?

Upload Standalone Returns via CSV

How to Upload Transactions via CSV

Transactions: Import and Export

Transactions and Reporting

**How to Download Debug Logs in TaxCloud for WooCommerce**

TaxCloud Onboarding Webinars

What is TaxCloud's Premium Trial?

How to Set Up and Manage Locations

How to Take Your Integration Live

Preparing For Onboarding

Getting Started

How to create a TaxCloud account?

Account Setup

How can I get a copy of my TaxCloud invoice receipt?

How Payment Methods Are Used For Billing and Tax Funding

How do I change my default payment method?

How to Add a Payment Method in TaxCloud

Billing and Payments

I have a new EIN. How does that impact my TaxCloud account?

TaxCloud Account Lockout Policy

How to Update My New Business Address With The States?

How to add/remove a contact from your TaxCloud account.

Best Practices for your TaxCloud Account

Verify Your TaxCloud Account is Complete for Calculations

How to Enable & Disable Tax Collection in a State

How do I reset my Password?

Video: How to complete your TaxCloud Business Profile

How to Use Multi-Account Login

How to Close Your TaxCloud Account and Cancel Subscription

Account Management

Account and Billing

Fee Schedule: Understanding TaxCloud Fees

Understanding the difference between TaxCloud Starter and Premium Plans

Changing your TaxCloud Subscription Plan

Plans and Pricing

TaxCloud System Status

What are API calls and what do they do?

Where to Find Your API Credentials

TaxCloud's APIs

What are Home Rule States?

Understanding Nexus Threshold Calculations

What happens if I go over my allotment of orders?

What is an order in TaxCloud?

Understanding the Minnesota Delivery Fee

How to Speak to a member of each state's DOR

Does TaxCloud collect the Colorado Retail Delivery Fee (CO RDF)?

How do I find my Merchant Number?

What Services Does TaxCloud Provide?

Is TaxCloud collecting Illinois Retailer's Occupation Tax (ROT)?

What is a multi-state id or sstid?

How do I confirm a rate with TaxCloud?

What is a voluntary seller?

How to Speak to a Member of Each State's Tax Authority or Department of Revenue

Can TaxCloud help with my State Income Taxes?

General

What is an Exemption Certificate?

How to Upload Exemption Certificates in Bulk

How to Add an Exemption Certificate to TaxCloud

Exemptions and Certificates

TaxCloud Audit Support Overview

How to contact TaxCloud?

Support and Resources

North Carolina - Certificate of Registration

California - CDTFA Statement of Account

Texas - Notice of Tax/Fee Due

Florida - Credit Memo

Wyoming - License Certificate

Arkansas - Excise, Waste Tire or Withholding Wage Tax

Rhode Island - Failure to Renew

New Jersey - Certificate of Registration

Texas - Sales & Use Tax Return Paper Form

Indiana - Notice of Proposed Assessment

Connecticut - Delinquency Notice

Michigan - Business Taxes Registration Summary of Changes

Tennessee - Notice of Overpayment

Colorado SUTS Filing Reminder Notices

Does TaxCloud Handle Sales Tax License Renewals?

Nebraska - Enforcement of Lien Notice

How to register in a new state and obtain my Sales Tax License

Louisiana State Sales Tax Rate Update

Florida Hunting, Fishing, and Camping Sales Tax Holiday (Sept 8 – Dec 31, 2025)

When To Forward a State Notice to Taxcloud

State Notices and Licenses

South Dakota - Sales & Use Tax Return Paper Form

Does TaxCloud File in Louisiana?

Filing: State-Specific Workflows

Understanding TaxCloud's Filing Costs & Filing Subscription

How to Request TaxCloud to Begin Filing Sales Tax Returns

How do I confirm my filings have been submitted in SST / Streamline member states?

How to Stop Filings with TaxCloud

How can TaxCloud assist with Filing?

Enabling Filing in TaxCloud (via Thresholds Page)

I just got a filing frequency change notice, what should I do?

How do I know if TaxCloud is filing for me in a state?

Why might my Direct Filing ACH be less than what TaxCloud is saying I collected.

Filing: Managing Filing in TaxCloud

What are TaxCloud Filing Fees?

Understanding Your Tax Reporting Page

What does it cost for TaxCloud to file for me in non-SST states?

Does TaxCloud file Withholding Tax?

Filing: General

Managing Your Tax Thresholds

Filing and Compliance

TaxCloud Taxability Information Codes (TIC)

Is shipping taxable?

Managing Product TIC Mapping with Product Catalog

Sales Tax Holidays & Product Codes (TICs)

Taxability and TICs

Is the plus 4 zip code extension (9 digit zip) required to calculate sales tax?

What is Streamlined Sales Tax (SST) and do they cover TaxCloud services?

What is Sales Tax Sourcing?

Guidelines on When TaxCloud May Cover Penalties and Interest (P&I) for Sales Tax Fiilings

Understanding the difference between sales tax and use tax

How does New York handle sales tax on apparel under \$110?

What is Nexus?

What is Washington B&O Tax?

How do I know if I've reached Economic Nexus in a state?

Calculating sales tax on Digital Goods

Calculating sales tax on P.O. Boxes

Does TaxCloud Calculate Sales Tax for International Orders?

How does TaxCloud round sales tax?

Tax Concepts

Connecting TaxCloud to Adobe Commerce or Magento

Marking Customers Exempt in Adobe Commerce

Adobe Commerce & Magento

Connecting TaxCloud to Stripe (Private Preview)

How to Mark Customers Tax Exempt in Stripe

Stripe

CSV Upload

Connecting TaxCloud to Chargebee

Chargebee

Connecting TaxCloud to Miva

Miva

Reviewing and Submitting an Exemption Certificate

Building a custom API connection with TaxCloud

Building a direct API integration with TaxCloud

Video: How to add or disable an integration

How to Add and Manage Integrations in TaxCloud

General Integrations

How to Mark Customers Tax Exempt in Shopify

Connecting TaxCloud to Shopify

Shopify Reporting FAQ

Updating to TaxCloud's new Shopify App (June 2024)

Shopify

Upgrading from the Legacy BigCommerce Integration

Marking a Customer Exempt in BigCommerce

Connecting TaxCloud to BigCommerce

Why do my TaxCloud orders have Fallback rates in BigCommerce?

BigCommerce

Upgrading TaxCloud Modules in Odoo

How to connect my Odoo store to TaxCloud

How to Connect my TaxCloud Account to Odoo Sale (Loyalty)

How To Connect my TaxCloud Account to Odoo Sale (Loyalty) - Delivery

How to Connect my TaxCloud Account to Odoo eCommerce

How to Connect my TaxCloud Account to Odoo Sale

How to Connect my TaxCloud Account to Odoo Amazon/TaxCloud Bridge

How to Connect my TaxCloud Account to Odoo TaxCloud & Subscriptions

Odoo

How to Download Debug Logs in TaxCloud for WooCommerce

Enabling Exemptions In TaxCloud for WooCommerce

Connecting TaxCloud to WooCommerce

How to Configure WooCommerce Order Capture Behavior with TaxCloud

How to Enable Rate Limiting in TaxCloud for WooCommerce

Understanding WooCommerce Integration Modes

WooCommerce

Managing Exempt Customers in TaxCloud for QuickBooks Online

Preparing Your Invoice for Accurate Tax Calculation

Calculating Sales Tax on QuickBooks Online Invoices

How the QuickBooks Online Integration Works

Connecting TaxCloud to QuickBooks Online

Changing the Sales Tax Display Mode for QuickBooks Online

Calculating Sales Tax on Estimates

Calculating Sales Tax on QuickBooks Online Sales Receipts

QuickBooks Online

Integrations