To track expenses and profibility for a project, you can use Cost Centers. You should create separate Cost Center for each Project. This will allow you to.
Let's check steps on how Project and Cost Center should be linked, and used in the sales and purchase transactions.
To create new Project, go to:
Projects > Project > New
Since budgeting and costing for each Project will be managed separately, you should create separate Cost Center for each Project.
To create new Cost Center, go to:
Accounts > Setup > Cost Center
Click here to learn how to manage Cost Centers.
Update Cost Center in the Project master.
In the sales and purchase transactions, if Project is selected, then Cost Center will fetched from the Project master.
Let's check how this setting will affect your sales and purchase entries.
In the sales transactions (which are Sales Order, Delivery Note and Sales Invoice), Project will be selected in the More Info section. On selection of a Project, respective Cost Center will be updated for all the items in that transaction. Cost Center will be updated on in the transactions which has Cost Center field.
In the purchase transactions, Project is define for each line item. This is because you can create a consolidated purchase entry for various projects. On selection of Project, its default cost center will auto-fetch.
As per perpetual inventory valuation system, expense for the purchased item will be booked when raw-materials are consumed. On consumption of goods, if you are creating Material Issue (stock) entry, then Expense Cost (says Cost of Goods Sold) and Project's Cost Center should be updated in that entry.
Since Project's Cost Center is updated in both sales and purchase entries, you can check Project Profitability based on report on Cost Center.
You can define budgets against the Cost Center associated with a Project. At any point of time, you can refer Budget Variance Report to analysis the expense vs budget against a cost center.
To check Budget Variance report, go to:
Accounts > Budget and Cost Center > Budget Variance Report