How are the numbers on the dashboard calculated?

Net Profit

- Taxes
- Shipping Cost
- Other Expenses (including Transaction Fees)
- Handling Fee
- Cost Of Goods
- Adspend
- App Expense
---------------------
= Net Profit```

###### Revenue

As standard the revenue includes all orders appart from _VOIDED_ and _PENDING_ orders.
The Revenue is reduced by the amount that has been refunded. You can select if you want to reduce ther evenue on the order date or on the refund date.

Both settings can be changed here. [Click here to adjust settings.](https://app.profitario.com/settings/dashboard)

|| Taxes do not reduce the revenue!
###### Expenses
``` Shipping Cost + Handling Fee + Cost Of Goods + Adspend + App Expense + Other Expenses (including Transaction Fees)```

###### Taxes
We are calculating the Value Added Tax from the Gross Revenue thus the formula we are using is as follows:
```TaxFactor = 1 + Tax
VAT = (Gross Revenue * TaxFactor) * TaxRate ```
For a Tax of 19% and a revenue of 1000 the result is as follows
```(1000/1,19)*0,19 = 159,66```

###### Disputed Revenue
Disputes reduce the revenue just like refunds do.

Disputes from Shopify Payments get imported automatically

To import Disputes from PayPal and Stripe you need to connect the Integrations:

[Connect Stripe](/en/article/how-to-connect-stripe-with-profitario-1ynfm79/)

[Connect PayPal](https://app.profitario.com/integrations/paypal/auth)

###### Adspend
```Facebook AdSpend + Google AdSpend + Other Expenses (category Advertising & Marketing)```

|| If the Adspend does not match the adspend you expect from the integration take a look at our [troubleshooting guide](/en/article/why-is-my-adspend-not-showing-1dl538s/)

###### Cost Of Goods (COGS)
This includes the Cost of Goods you have setup in the Cost of Goods Menu and Cost from AliExpress

||| We will only show the cost from AliExpress when the order has been connected through the tracking number
More details on how we handle the cost from AliExpresss can be found here. [Link](/en/article/cost-from-aliexpress-is-missing-in-shopify-order-jenhqs/)

###### Shipping

The Shipping Cost can he setup here: [Link](https://app.profitario.com/settings/shipping)

###### Handling
The Handling Fee allows you to add a cost (packing, processing fee from fulfillmentcenter) to an order that is not directly attached to Cost of Goods.

The Handling Fee can be setup here: [Link](https://app.profitario.com/settings/cogs)

###### Apps

Apps play a major part in the Shopify ecosystem.
Recurring App Fees can be setup here: [Link](https://app.profitario.com/settings/apps)

###### Other Expenses
 ```Transaction Fees + Other Expenses```

###### Avg. Order Value
```Revenue / Order Count```

###### Avg Order Profit
```(Revenue
- Taxes 
- Shipping Cost 
- HandlingCost 
- COGS 
- AdSpend 
- App Spend 
- Other Expenses) 
/ Order Count```

###### LTV ( Lifetime Value)
The Lifetime Value includes the complete revenue a customer has spend in your store.
If a customer had two orders the LTV will be the sum of both orders.

```Sum of all orders per customer / Order Count```

###### CAC (Customer Acquisition Cost)
```AdSpend / Customer Count```
###### Net Margin
```(Revenue
- Taxes
- Shipping Cost
- Other Expenses
- Handling Fee
- COGS
- Adspend
- App expense
) / Net Revenue) * -100```

###### Gross Margin
```Revenue
- Taxes
- Shipping Cost
- Transaction Fee
- Handling Fee
- COGS
) / Net Revenue) * -100```

###### Gross Profit
```Revenue
- Taxes
- Shipping Cost
- Transaction Fee
- Handling Fee
- COGS```

Updated on: 09/09/2022