Posting example 7 - fixed-price project
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
The following tables provide an example for posting a fixed-price project.
Ledger posting examples
Project group parameters |
Revenue recognition accounting rule |
Matching principle |
On-account invoicing |
|---|---|---|---|
Completed percentage |
Production + profit |
Profit and loss |
Tip
These project group parameters are set up on the Estimate FastTab in the Project groups form. Click Project management and accounting > Setup > Posting > Project groups.
Statistics - before estimate posting
Statement P&L |
Positive amount |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
Total |
|---|---|---|---|---|---|---|---|---|
Invoiced revenue - on account |
Credit |
80,000 |
0 |
50,000 |
0 |
80,000 |
0 |
200,000 |
Accrued revenue - on account |
Credit |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Accrued revenue - production |
Credit |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Accrued revenue – profit |
Credit |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Revenue |
80,000 |
0 |
50,000 |
0 |
80,000 |
0 |
200,000 |
|
Cost |
Debit |
12,000 |
30,000 |
24,000 |
36,000 |
18,000 |
0 |
120,000 |
Gross margin |
68,000 |
-30,000 |
26,000 |
-36,000 |
52,000 |
0 |
80,000 |
Statement WIP (balance) |
Positive amount |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
Total |
|---|---|---|---|---|---|---|---|---|
WIP – production |
Debit |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
WIP - profit |
Debit |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Gross WIP |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
WIP - invoiced - on account |
Credit |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Net WIP |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Posting of estimate
Statement P&L |
Positive amount |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
Total |
|---|---|---|---|---|---|---|---|---|
Invoiced revenue - on account |
Credit |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Accrued revenue - on account |
Credit |
-80,000 |
0 |
-50,000 |
0 |
-70,000 |
-200,000 |
|
Accrued revenue - production |
Credit |
12,000 |
30,000 |
24,000 |
36,000 |
18,000 |
0 |
120,00 |
Accrued revenue – profit |
Credit |
8,000 |
20,000 |
16,000 |
24,000 |
12,000 |
0 |
80,000 |
Cost |
Debit |
12,000 |
30,000 |
24,000 |
36,000 |
18,000 |
0 |
120,00 |
Statement WIP (balance) |
Positive amount |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
Total |
|---|---|---|---|---|---|---|---|---|
WIP - production |
Debit |
12,000 |
30,000 |
24,000 |
36,000 |
18,000 |
-120,000 |
0 |
WIP – profit |
8,000 |
20,000 |
16,000 |
24,000 |
12,000 |
-80,000 |
0 |
|
WIP - invoiced - on account |
Credit |
80,000 |
0 |
50,000 |
0 |
70,000 |
-200,000 |
0 |
Statistics - after estimate posting
Statement P&L |
Positive amount |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
Total |
|---|---|---|---|---|---|---|---|---|
Invoiced revenue - on account |
Credit |
80,000 |
0 |
50,000 |
0 |
70,000 |
0 |
200,00 |
Accrued revenue - on account |
Credit |
-80,000 |
0 |
-50,000 |
0 |
-70,000 |
0 |
-200,000 |
Accrued revenue - production |
Credit |
12,000 |
30,000 |
24,000 |
36,000 |
18,000 |
0 |
120,000 |
Accrued revenue – profit |
Credit |
8,000 |
20,000 |
16,000 |
24,000 |
12,000 |
0 |
80,000 |
Revenue |
200,000 |
50,000 |
40,000 |
60,000 |
30,000 |
0 |
200,000 |
|
Cost |
Debit |
12,000 |
30,000 |
24,000 |
36,000 |
18,000 |
0 |
120,000 |
Gross margin |
8,000 |
20,000 |
16,000 |
24,000 |
12,000 |
0 |
80,000 |
Statement WIP (balance) |
Positive amount |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
Total |
|---|---|---|---|---|---|---|---|---|
WIP - production |
Debit |
12,000 |
30,000 |
24,000 |
36,000 |
18,000 |
-120,00 |
0 |
WIP – profit |
8,000 |
20,000 |
16,000 |
24,000 |
12,000 |
-80,000 |
||
Gross WIP |
20,000 |
50,000 |
40,000 |
60,000 |
30,000 |
-200,000 |
0 |
|
WIP - invoiced - on account |
Credit |
80,000 |
0 |
50,000 |
0 |
70,000 |
-200,000 |
0 |
Net WIP |
-60,000 |
50,000 |
-10,000 |
60,000 |
-40,000 |
0 |
0 |
See also
About the fixed-price project posting examples
About invoicing fixed-price projects