This screen allows you to track your expense and revenue targets entered in the Budget management screen and compare your cumulative treasury flow (realized and forecast) to your budget.
To make your budget follow-up easier, a visual alert is displayed to let you know if forecasts or bank transactions prior to the current date have not been handled.
Prerequisite: You must have the Display right on the Budget function for the Cash forecasting module. This right can be defined in the Users and Rights > User administration > Users menu.
at the top right corner of the budget follow-up table. Default display of the table :
The table is composed of three sections. The explanations below concerning these sections are based on a monthly periodicity.
The "Realized" section is composed of columns for past months and rows for budgetary codes. Each cell displays, for a given month and a given budgetary code, the sum of the transactions by booking date made for all the company's bank accounts (Cash forecasting Module).
The "Initial balance" row displays the balance by booking date for the first day of the month.
The "Ending balance" row displays the balance by booking date for the day following the last day of the month.
The "Budget projection" section is composed of columns for the current month and future months, as well as rows for budgetary codes. Each cell displays the amount budgeted for a given month and a given budgetary code; the amounts entered in the Budget management screen and the forecasts registered in the Cash forecasting Module are taken into account.
The "Initial balance" row displays the ending balance of the previous period.
The "Ending balance" of a period is the opening balance of that period plus the budgeted amounts for the budgetary codes of that period.
Three "TOTAL" columns are displayed on the right side of the table:
You can modify the display of the table if you wish. To do so, click on Options, select the desired options and click on Save.
| Option | Definition |
|---|---|
| Periodicity - display by |
Modify the periodicity if you wish:
|
|
Number of columns - past {periods} including X with progress bar |
Select the number of columns and progress bars to display in the "Realized" section. Example:
Here, Iziago will display in the "Realized" section 3 columns corresponding to the 3 months preceding the current month: January, February and March. A progress bar will be displayed for the 2 months preceding the current month: February and March. |
|
Number of columns - future {periods} including X with progress bar |
Select the number of columns and progress bars to display in the "Budget projection" section. Example:
Here, Iziago will display in the "Budget projection" section 4 columns corresponding to the 4 months starting from the current month: April, May, June and July. A progress bar will be displayed for 2 months starting from the current month: April and May. |
| Include non confirmed transactions | Uncheck the box if you wish to exclude non confirmed transactions from the budget. |
| Hide zero value rows | Uncheck the box if you wish to display the lines when the amount is equal to 0. |
| Check if there are non-handled past transactions | Uncheck the box if you do not want a visual alert to show you non-handled past transactions. |
Progress bars allow you to view the progress of your budget. Use the table display options to set the number of bars you want to view for past and future periods.
The total length of the bar corresponds to the budgeted amount. The transactions (realized, forecast, etc.) are represented by colored segments:
You can hover over a progress bar to view detailed information.
Examples:
| The cell indicates €15,000.00 | The cell indicates €1,000.00 | The cell indicates €-1,000.00 |
 |
 |
 |
|
You have budgeted a credit of €15,000. You have already received a credit of €6,000 (light green segment) and recorded €4,000 in forecasts (pink segment). You still need to receive €5,000 (gray segment) to reach your target of €15,000. |
You have budgeted a credit of €800. You have already received a credit of €500 (light green segment) and recorded €500 in forecasts (pink segment). You therefore have a €200 credit overrun (dark green segment). |
You have budgeted a debit of €800. You have already had a debit of €500 (light pink segment) and recorded €-500 of forecasts (pink segment). You therefore have a €200 debit overrun (red segment) on your target of -800 €. |
To view the list of forecast transactions included in a budget, click on the corresponding cell. Iziago displays this list in the Search and modify transactions screen.
