Project Management – Fixed Price Project Posting
There are different scenarios for revenue recognition postings No WIP, Completed percentage and completed contract. In this article, we go through the postings of fixed price project which is based on completed percentage.
Project postings method (revenue recognition) are defined on project groups and that project group selected on project creation.
So below are the configurations on project group:
Ledger:
Post costs (hour, Expense, item): profit and loss
On account invoicing: Balance
Estimate:
Revenue recognition: Completion of percentage
Calculation method: None
Cost template: Based on cost
Matching principle: sales value
Let’s take an example:
Company has the project for ERP implementation from a customer. Company has deal for flat amount 200000 and invoice based on milestone completed.
Forecast work to be done
For above scenario you need to first forecast your all cost in project forecast tab and then by day by day enter your actual cost and then RUN estimate process for knowing percentage of completion.
Enter actual hours and expense journals and post.
Posting will be as below.
| Project – Cost A/c | 16000 | |
| To Project – Payroll allocation account | 16000 | |
| Project – Cost A/c | 6000 | |
| To Project – Payroll allocation account | 6000 |
Estimate
Now create Estimate it will show work completed against forecast
Estimate date: 5/31/2018
Percentage completed: 14.97
Total Cost: 22000 (16000+6000)
Margin: 7931.97
Posting this estimate will not affect anything as accounts till this involved are P&L as setup earlier. So let’s generate invoice.
Post estimate and posting are as below:
| WIP – Invoiced On Account | 29931.97 | |
| TO Accrued Revenue | 29931.97 |
- For invoicing go for on- account transaction.
Invoice on account transaction
| Customer balance | 20000 | |
| To WIP invoiced – on account | 20000 |