Edit Transactions via Spreadsheet

How to update and edit transactions via Spreadsheet

You can update and correct those transactions in TaxJar by creating a CSV with those sales and their proper location. 

Once you've corrected the data, you can overwrite the current data for the sales you corrected by uploading the CSV to TaxJar so the system will attribute the sales properly.  

Important: We offer two templates to import your data which differ in formatting guidance. Most transactions can be easily updated using our Orders template; however, if your products have product tax codes associated with them, we recommend using our Line Item template to edit your existing transactions. 

  1. To do this, we recommend that you first export (here’s how) the dates/transactions you need to change from TaxJar.
  2. Then you can edit the exported file and import it (here’s how with Line Items Template or Orders Template) with the correct data.
    To ensure you're properly overwriting the transaction, the 'provider' and 'order_id' values remain the same. 
    (In the V1 template, the order_id column is equivalent to the transaction_id column in the V2 template.)
  3. You will need to double check to be certain that the file you import has the column header names in the proper order (which you'll see in the Sample CSV template you can download here).
  4. Please sure you remove any extra columns from the file you receive when you export.