Skip to content

Excluding Shipping and Taxes from Net Sales

How to configure Putler to separate or exclude shipping costs and taxes from gross and net sales calculations.

If you need to exclude shipping and taxes from your Net Sales in Putler, here are two ways:

Export Sales as CSV

To manually calculate the values, follow these steps:
* Export your sales data as a CSV file.
* Check out the documentation on how to export: [Export Sales Reports](/docs/putler/export-reports/#exporting-salestransaction-report).
* In the exported file, sum the **Shipping, Tax,** and **Fees** columns separately to get the respective values.

Use the Transactions Dashboard (For Tax and Fees)

If you only need to filter out **Tax** and **Fees**, follow these steps:
* Go to the **Transactions Dashboard** in Putler.
* Set the date range.
* Apply the following filters:
    * **Status:** Select `Completed` and `Refunded`.
    * **Type:** Select `Sale` and `Sale Refund`. (If these are the only options under Type, no need to select them manually.)

This will display the Total Amount at the top, which aligns with Net Sales in the Sales Dashboard. Additionally, you can view Tax and Fees separately.