Gross Margin Calculation (Project doc type)

1

image
image948×472 29.7 KB

in project doc type - how this gross margin calculated?

2

@Ankita1
Gross Margin = Total Billed Amount - (Total Costing Amount + Total Purchase Cost + Total Consumed Material Cost)

3

Hi @Ankita1

The Gross Margin in the Project Doctype is a calculated field that helps you understand the profitability of a project by comparing the revenue earned against the cost incurred.

Gross Margin = (Total Billing Amount - Total Costing Amount)
Gross Margin % = (Gross Margin / Total Billing Amount) * 100


### 📘 Key Fields in the Project Doctype:

1. **Total Billing Amount** – This is the sum of all **Sales Invoices**, or **Timesheets** (depending on settings) linked to the project.
2. **Total Costing Amount** – This is the total of all **Purchase Invoices**, **Expenses Claims**, or **Timesheet Costs** linked to the project.
3. **Gross Margin** – The difference between the total billed and the total cost.
4. **Gross Margin %** – Shows profitability as a percentage.