Proposed Updates to Project Costing and Billing Section

Hi,

The Costing and Billing section of the Project DocType needs an overhaul as it is currently not very useful. The Margin section also needs some changes. Here’s what we propose

Costing and Billing

Estimated Value (via Sales Order): This field should show the sum of Grand Total value in all linked Sales Orders

Actual Value (via Sales Invoice): This field should show the sum of Grand Total value in all linked Sales Invoices

Estimated Cost: This is fine as it is. The Project Manager should manually enter their estimated project cost here

Total Costing Amount (via Time Logs): This is fine as it is

Total Expense Claim (via Expense Claims): This is fine as it is

Total Cost of Goods Sold: This field should show the sum of all General Ledger entries against the Cost of Goods Sold account (where the Project is specified)

Cost of Goods Sold Account: This should be a link field where the Cost of Goods Sold account can be selected. By default, it should show the Default Cost of Goods Sold account specified in the Company master. It must also accept selection of Parent Accounts (Groups)

Margin

Estimated Gross Margin: Estimated Value (via Sales Order) - Estimated Cost

Estimated Gross Margin %: (Estimated Gross Margin / Estimated Value (via Sales Order)) * 100

Actual Gross Margin: Actual Value (via Sales Invoice) - Total Costing Amount (via Time Logs) - Total Expense Claim (via Expense Claims) - Total Cost of Goods Sold

Actual Gross Margin %: (Gross Margin / Actual Value (via Sales Invoice)) * 100

Other Considerations

Should taxes be excluded in Estimated Value (via Sales Order) and Actual Value (via Sales Invoice) so that Margin figures are more realistic?

Any Inputs or Suggestions would be appreciated

Kind regards,

2 Likes

Looks good :+1: If you have a mockup screen, that will be also great to get feedback.