To use this module, you must:
Account: grouping by account
Account - Product sold: grouping by account + product sold
Account - Product sold - Customer: grouping by account + product sold + customer
If the box is checked:
SIA = If (Recognized revenue >= Invoiced) then Recognized revenue - Invoiced otherwise 0
Prepaid income = If (Recognized revenue < Invoiced) then Invoiced - Recognized revenue otherwise 0
Recognized revenue = deliveries not invoiced ≤ closing date
If the box is not checked:
SIA = Deliveries not invoiced ≤ Closing date + billing table lines validated and not invoiced ≤ Closing date
Prepaid income = Invoices > closing date
Recognized revenue = Invoiced + SIA - Prepaid income
The validated orders are taken into account to calculate the budget.
Budget = Validated, not delivered orders without billing table ≤ closing date + deliveries not invoiced ≤ closing date + Not invoiced lines of the validated billing table ≤ closing date + Invoices ≤ closing date.
Budget calculated with the signed estimates
Budget = initial budget = signed estimates.
Column | Description |
---|---|
Initial budget | Signed estimates ≤ closing date |
Invoiced | Invoices ≤ closing date |
Amount to be billed | Validated, not delivered orders without billing table ≤ closing date + deliveries not invoiced ≤ closing date + Not invoiced lines of the validated billing table ≤ closing date |
% Invoicing | Invoiced / Budget |
Maint. free % | Free maintenance defined on the lines |
Revenue to recognize | Budget - recognized revenue |
Revenue M-1 | Stored revenue recovery according to the history date defined in the first screen |
Monthly production | Recognized revenue - revenue (M-1) |
The revenue calculation is done by applying a percentage of progress on the ordered amount.
The ordered amount is calculated by adding not delivered orders, not invoiced deliveries and sales invoices.
The progress percentage is calculated by comparing time spent and the number of days sold matching order line's quantities.
Account: grouping by account
Account - Product sold: grouping by account + product sold
Account - Product sold - Customer: grouping by account + product sold + customer
The validated orders are taken into account to calculate the budget.
Validated, not delivered orders without billing table ≤ closing date + deliveries not invoiced ≤ closing date + Not invoiced lines of the validated billing table ≤ closing date + Invoices ≤ closing date.
Budget = initial budget = signed estimates.
Column | Description |
---|---|
Initial budget | None |
Time Spent | Time spent in days based on the time spent code ≤ closing date |
Invoiced | Invoices ≤ closing date |
Amount to be billed | Budget - Invoiced |
Actual remaining tasks | Schedule in days ≤ the closing date |
SIA | Recognized revenue - Invoiced |
Prepaid income | Invoiced - Recognized revenue |
Recognized revenue | Budget x forced progress |
Revenue to recognize | Budget - recognized revenue |
Revenue M-1 | Stored revenue according to the previous closing date defined in the starting screen |
Monthly production | If theoretical remaining tasks = 0 then budget - Revenue M-1. Otherwise (budget/updated forecast) * days done. |
Days sold | Budget (in days) |
Days done | Time Spent |
Theoretical remaining tasks | Days sold - Days done |
Difference | Theoretical remaining tasks - Actual remaining tasks |
Updated forecast | Days done + Actual remaining tasks |
% calculated progress | Days done / updated forecast |
% theoretical progress | Days done / Days sold |
% forced progress | Default theoretical remaining tasks (manual entry possible if DMF) |
The revenue calculation is done by applying a percentage of progress on the ordered amount. This percentage of progress can be forced.
Account: grouping by account
Account - Product sold: grouping by account + product sold
Account - Product sold - Customer: grouping by account + product sold + customer
If the box is checked:
Real cost = time spent valuated ≤ closing date + purchase invoices ≤ closing date + not invoiced reception ≤ closing date
Updated forecast = real cost + actual remaining tasks
% calculated progress = real cost / updated forecast
The result is calculated from the cost history table lines.
If the box is not checked:
Time Spent = Time spent valuated ≤ closing date
Updated forecast = Time spent + actual remaining tasks
% calculated progress = Time spent / updated forecast
The validated orders are taken into account to calculate the budget.
Budget = Validated, not delivered orders without billing table ≤ closing date + deliveries not invoiced ≤ closing date + Not invoiced lines of the validated billing table ≤ closing date + Invoices ≤ closing date.
Budget = initial budget = signed estimates.
The result is calculated from the accounting vouchers of the Purchases module.
If the Calculation of expenses with valuated times and purchases box is checked:
The result is calculated from the cost history table lines.
The Remaining Task is calculated from the valuated schedule > closing date.
Actual remaining tasks = Valuated time spent > closing date + valuated schedule > closing date
If the Calculation of expenses with valuated times and purchases box is checked:
Actual remaining tasks = Valuated time spent > closing date + valuated schedule > closing date + validated supplier orders not received ≤ closing date
If the Inclusion of validated quotes box is checked:
Actual remaining tasks = Valuated time spent > closing date + valuated schedule > closing date + validated supplier orders not received ≤ closing date + validated quotes ≤ closing date
The Actual remaining tasks is calculated from the project task's Actual remaining tasks AND the valuation of the employee associated to this task.
Actual remaining tasks = Valuated time spent > closing date + project's tasks Actual remaining tasks valuated with the employee associated with this task
If the Calculation of expenses with valuated times and purchases box is checked:
Actual remaining tasks = Valuated time spent > closing date + project's tasks Actual remaining tasks valuated with the employee associated with this task + supplier orders validated but not received ≤ closing date
If the Inclusion of validated quotes box is checked:
Actual remaining tasks = Valuated time spent > closing date + project's tasks Actual remaining tasks valuated with the employee associated with this task + supplier orders validated but not received ≤ closing date + validated quotes ≤ closing date
If checked, the validated quotes are taken into account to calculate the cost result.
Box | Rule |
---|---|
Initial budget | Signed estimates ≤ closing date |
% forced progress | % actual remaining tasks (manual entry possible if DMF) |
Recognized revenue | Budget x forced progress |
Invoiced | Invoices ≤ closing date |
SIA | If (Recognized revenue ≥ Invoiced) then Recognized revenue - Invoiced |
Prepaid income | If (Recognized revenue < Invoiced) then Invoiced - Recognized revenue |
Revenue M-1 | Stored revenue recovery according to the history date defined in the first screen |
It is a revenue recognition method based on the period of accounting voucher lines ('Period from' and 'to').
Account: grouping by account
Account - Product sold: grouping by account + product sold
Account - Product sold - Customer: grouping by account + product sold + customer
If the box is checked:
Proposed SIA = If (Recognized revenue >= Invoiced) then Recognized revenue - Invoiced
Proposed prepaid income = If (Recognized revenue < Invoiced) then Invoiced - Recognized revenue
Recognized revenue = Deliveries not invoiced (Date 'Delivered on' ≤ Closing date)
If the box is not checked:
Proposed SIA = Deliveries not invoiced ≤ Closing date + billing table lines validated and not invoiced ≤ Closing date
Proposed prepaid income = Invoice lines for the portion of the period related to the closing date
Recognized revenue = Invoiced + selected SIA - selected prepaid income
The validated orders are taken into account to calculate the budget.
Budget = Validated, not delivered orders without billing table ≤ closing date + deliveries not invoiced ≤ closing date + Not invoiced lines of the validated billing table ≤ closing date + Invoices ≤ closing date.
Budget = initial budget = signed estimates.
Column | Description |
---|---|
Initial budget | Signed estimates ≤ closing date |
Invoiced | Invoices ≤ closing date |
Selected SIA SIA | proposed by default (manual entry possible if DMF) |
Selected prepaid income | proposed prepaid income by default (manual entry possible if DMF) |
Revenue M-1 | Stored revenue recovery according to the history date defined in the first screen |
Monthly production | Recognized revenue - revenue (M-1) |
When you validate the accounting entries, the detail of the entry creation is stored in database.