---
title: "How to Import Partial Refunds via CSV"
description: "Please note that when you are doing returns via CSV, the TIC used in the return must match the TIC used in the original order."
canonical_url: "https://support.taxcloud.com/articles/how-to-import-partial-refunds-via-csv-d3ZwxT1Efj"
md_url: "https://support.taxcloud.com/articles/how-to-import-partial-refunds-via-csv-d3ZwxT1Efj.md"
---
# How to Import Partial Refunds via CSV

:::info
Please note that when you are doing returns via CSV, the TIC used in the return must match the TIC used in the original order.

:::


[https://www.loom.com/share/221d470892364ce89566318031928161?sid=a1657f09-2578-4c45-b3c7-c031d7abff4b](https://www.loom.com/share/221d470892364ce89566318031928161?sid=a1657f09-2578-4c45-b3c7-c031d7abff4b)


---

## Below are some examples of changes for a partial return:

Assume you upload a CSV file with 2 transactions (DVD + Shipping for each)

 ![](https://support.taxcloud.com/api/attachments.redirect?id=0da5e92d-891a-42f4-aca4-5cf4dd6d6dbe)

You can later upload a CSV to do a partial return and a full return

 ![](https://support.taxcloud.com/api/attachments.redirect?id=69fea957-ec2e-41ed-8bbf-e8a439c6249d)

Or you can do a partial return and a new transaction

 ![](https://support.taxcloud.com/api/attachments.redirect?id=cbd038cc-faeb-4fba-9b35-fa22149d5ea9)

The example below shows how to return the shipping

 ![](https://support.taxcloud.com/api/attachments.redirect?id=f8d69609-b110-430e-b675-4fab710cc7f4)

Below’s example shows a line item representing 3 DVDs and a return of 2 of the 3 DVDs

 ![](https://support.taxcloud.com/api/attachments.redirect?id=0342aa23-06a3-454e-96cf-af7baac5d129)

Here is a partial amount or discounted example. The first line shows the original upload and the second line shows the partial refund. Please note that dates on the partial refund were changed to reflect the return date.

In order to return part of a line item, find the CartItemQty value by dividing the CartItemPrice amount you'd like to return by the initial CartItemPrice, and adding a negative sign to that value. For example, for this DVD return, if $18.71 was returned to the customer, you’d divide 18.71 by 24.95. This gives you a CartItemQty of -0.75. 

Leave the CartItemTaxAmount line blank *on the return row*. TaxCloud will automatically calculate a prorated return tax amount.

 ![](https://support.taxcloud.com/api/attachments.redirect?id=604de025-9214-4c0f-85fb-d439342b3276 " =976x33")