Sample journal entries for work in progress
Below you see sample journal entries illustrating the steps to be performed when journalising the work in progress. The accounts mentioned do not have to be one account per type in Profit Projects: you can use multiple accounts for every account type. You can for instance create multiple ledger accounts for the cost price of work in progress and then specify how these accounts should be determined by Profit Projects.
Journalise an actual costing entry
To journalise an actual costing entry:
|
2 - Project WIP cost price (if WIP is not split, this is 2 - Project WIP) |
To |
3 - Project cost price coverage |
Example:
Work in progress cost journal
Entry type |
Account |
Account |
Description |
Amount D |
Amount C |
2 |
3100 |
|
WIP costs |
300,00 |
|
3 |
|
6100 |
Coverage (hours/material) |
|
300,00 |
Journalise a project revenue entry
The amounts on the Provisional project revenue and Revenue coverage accounts are always the same. This means that the Debtors to provisional project revenue (+ VAT) entry replaces the Debtors to revenue (+ VAT) entry that is created if work in progress entries are not used.
To journalise a (project) revenue entry:
|
1 - Debtors |
To |
4 - Project revenue coverage (If you have indicated that the WIP coverage has to be split, this is account 5 - Provisional project revenue) |
and
|
4 - Project revenue coverage |
To |
8 - Project WIP revenue (if WIP is not split, this is 2 - Project WIP) |
Example:
Work in progress revenue journal
Entry type |
Account |
Account |
Description |
Amount D |
Amount C |
1 |
10000 |
|
Debtor |
476.00 |
|
4 |
|
6300 |
Provisional project revenue suspense account |
|
|
|
|
1500 |
VAT to be paid |
|
|
AND |
|
|
|
|
|
4 |
6310 |
|
Revenue coverage |
400.00 |
|
8 |
|
3110 |
WIP revenues |
|
|
Journalise WIP completion
If, for example, you carry revenues forward from sales invoices to the project administration, this results in one journal entry for the work in progress:
- Revenue coverage
to Work in progress revenue
No invoice entry is created at this point because the invoice for the revenue has already been processed in the accounts directly. The ledger accounts for the work in progress are usually created as balance sheet accounts. The coverage accounts and the account for the provisional revenue are usually profit and loss accounts. However, this depends on how the accounting has been configured.
To journalise WIP completion:
|
6 - Project costs |
To |
2 - Project WIP cost price (if WIP is not split, this is 2 - Project WIP) |
and
|
8 - Project WIP revenue (if WIP is not split, this is 2 - Project WIP) |
To |
7 - Project revenues |
Example:
Work in progress completion journal
Entry type |
Account |
Account |
Description |
Amount D |
Amount C |
6 |
7000 |
|
Project costs |
300.00 |
|
2 |
|
3100 |
WIP costs |
|
|
8 |
3110 |
|
WIP revenues |
400.00 |
|
7 |
|
8100 |
Project revenues |
|
|
Journal entries from Financial
Journal entry directly from Profit Financieel:
|
1 - Debtors |
To |
4 - Project revenue coverage (If you have indicated that the WIP coverage has to be split, this is account 5 - Provisional project revenue) |
Example:
Revenue entry directly from the financial administration
Entry type |
Account |
Account |
Description |
Amount D |
Amount C |
|
10000 |
|
Debtor |
121.00 |
|
4 |
|
6300 |
Provisional project revenue suspense account |
|
100.00 |
|
|
1500 |
VAT to be paid |
|
21.00 |