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,