A supplier sends a CSV or XLSX price list with only price_with_tax, where the price already includes sales tax. The example uses the California statewide base rate 7.25% and needs two output columns: price_before_tax and sales_tax_amount.
For a 7.25% sales tax rate, create two output columns from price_with_tax: divide price_before_tax by 1.0725; for sales_tax_amount, multiply the price by 7.25 and divide by 107.25.
How to do it in Eofferix
Upload the CSV or XLSX price list and open the table export template. In this example the source column is
price_with_tax.Add the output column
price_before_taxand useprice_with_taxas its source.Open
price_before_taxsettings. InTransformations, addDividewith value1.0725.
For a 7.25%rate, the price before tax uses division by1.0725.Add the second output column
sales_tax_amountfrom the same source columnprice_with_tax.
The animation shows the calculated table and the opening of sales_tax_amountsettings.In
sales_tax_amountsettings, addMultiplywith value7.25, thenDividewith value107.25.
For a 7.25%rate, the sales tax amount is calculated as tax-included price ×7.25÷107.25.Save the template and check the final export step: the table should contain
price_before_taxandsales_tax_amount.
Before / after
Before
source data| sku | name | price_with_tax |
|---|---|---|
| SKU-100 | Desk lamp | 1072.50 |
| SKU-200 | Office chair | 2145.00 |
After
result| sku | name | price_with_tax | price_before_tax | sales_tax_amount |
|---|---|---|---|---|
| SKU-100 | Desk lamp | 1072.50 | 1000 | 72.5 |
| SKU-200 | Office chair | 2145.00 | 2000 | 145 |
What to keep in mind
- The United States does not have a single national VAT rate. This example uses the California statewide base sales and use tax rate
7.25%; district taxes can make the actual rate higher. - For another local rate, use the same formula: price before tax = tax-included price ÷
(1 + rate / 100), tax amount = tax-included price ×rate÷(100 + rate). - If the price contains a currency sign, spaces, or text, clean the price column first and apply division after that.
- If your export requires whole dollars, add
Round; if it needs cents, keep the calculated decimal value.