Budget history
The terms used in the article below correspond to iSYBUY. To find iBAT equivalents, click on this link.
In order to improve your budget management and control, you can monitor the progress of each item over time, giving you a more detailed analysis of project progress.
Users with ADMIN or BUDGET privileges within the Group or Company can track the progress of their budgets and make snapshots.
If you need further information, you can find the article explaining how budgets work in general here.
In this article:
- Setting up snapshots
- Details of the columns in the budget monitoring screen
Setting up snapshots
A snapshot is a photograph taken of progress and actual data at a chosen date. It is used to freeze and store progress values for a given date.
Once all the data has been entered, all you have to do is select the desired period and then click on Validate progress.
The first step is to select the context you are in (1) and then the time period of your choice (2).
Then click on "Confirm progress".
In the pop-up window that opens, we invite you to confirm the desired period and click on "Confirm progress".
Note :
- Once this action has been confirmed, it will be impossible to modify the progress or budget for the dates in the selected period.
- Snapshots must be saved in chronological order: it is therefore impossible to create a snapshot for a date prior to the last snapshot taken.
- You can enter progress to a maximum of D+3 from today's date
Details of the columns in the budget monitoring screen
Here are the details of the columns on the detailed project budget.
| Name | Column | Calculate | Function | |
| (a) | Amount Budget (name) |
Existing column | manual input | Entered at the start of the project - can be modified in the event of additional work or budget transfer and saved using the "Save budget" button. In the case of snapshots, the budget displayed is that at the time of the snapshot. |
| (b) | Advancement (h) |
Existing column | = snapshot selected period | Enables you to enter the overall progress of work at the end of the selected period. |
| (c) | Amount Advanced budget (h) |
Existing column | = (b)period - (b previous period)*(a) | This is the progress in hours over the period compared with the initial budget estimates. Note : the calculation is therefore modified for the period preceding the start of the project (0% progress). |
| (d) | Amount realised (€) |
Renamed column | = snapshot of the period (or scores up to the chosen end date) - snapshot before the period (or 0) | Hours worked are taken from clock-ins and correspond to the total number of hours worked at the end of the selected period. |
| (e) | Period variance (€) |
Renamed column | =(c)-(d) | This is the difference between the budgeted hours for the end-of-period snapshot progress level. |
| (f) | Total advanced budget (h) |
Added column | =(a)*(b) | This column expresses in hours the current progress applied to the estimated project budget. Note: this also corresponds to the sum of the "Advanced Budget Hours" since the start of the project. |
| (g) | Total realised (€) |
Added column | =sum(d) | This column corresponds to the sum of hours clocked in from the start of the project to the end of the selected current period. |
| (h) | Cumulative gap (€) |
Renamed column | =(f)-(g) | This column corresponds to the difference between the Cumulative Advanced Budget (f) and the Cumulative Actual (g). |
| (i) | Total remaining budget (€) |
Added column | =(a)-(f) | This column shows the number of hours assumed to remain to be completed in relation to the initial budget and current progress. |
| (j) | Additional budget Estimated (€) |
Added column | saisie manuelle | Column giving an estimate of the extra cost compared with the initial estimate |
| (k) | Estimated total (€) |
Added column | =(g)+(i)+(j) | This column shows a projection of the final cost based on the actual cost plus the forecast and re-evaluated work remaining to be done. |
Note :
To help you manage your budgets, the formulas applied in the columns are displayed when you hover over the column with the mouse.
Do you have any other questions we haven't thought of? Send us your request at this address. We look forward to hearing from you!
Related keywords :
Budget - management - progress - photo - snapshot - cost - hours - labour - time