Budget

This report allows you to select the budget version of your choice and extract it into an Excel file for a selected project. 

If you use the Cashflow feature, you can also extract the budget broken down by period (month, quarter or year). 

Since all budget information is extracted in an Excel spreadsheet, you can easily use this data to make various administrative and financial calculations, as required, and even attempt some budget simulations.

⚠️Note: The Cashflow section of the report is only available to customers subscribing to the Aidi platform’s Advanced and Enterprise plans.

How to Use This Report?

Information of the Budget Tab

Basic Budget Information

Financing Section

Financing Account Section

Taxes Section

Cashflow Tab Information

How to Use This Report?

1. Select the project.
2. Select the budget version you wish to see in the report. All budget versions are available for selection, regardless of status. A pop-up window will open.
3. If you use the Cashflow feature in Aidi, you can display the budget breakdown by period.
4. To display the cashflow, select the distribution period. 
5. Click Yes to generate the report (with or without cashflow). To return to parameter modification, click No. You will need to select the budget again to access the pop-up window that allows you to generate the report.
6. To display financing on the report, select On.
7. If financing accounts are associated with budget items, select the On radio button to view them in the report.
8. Similarly, if you have associated taxes with budget items, you can have them displayed on the report.

✏️Note: These 3 elements are automatically added to the report when selected. You don’t need to generate the report again.

9. It is possible to generate this report as a PDF.
10. Lock report to freeze selected parameters.
11. Access the Cashflow page.

Information of the Budget Tab

Basic Budget Information

The following columns are displayed at all times in the report.

1. If you have added a Contingency label to a budget item, it will be indicated Yes in this column.
2. If you had specified the unit between square brackets in the budget item description, then the unit value will be displayed in the Unit column.The unit can be added in the description of the budget item, between square brackets.
3. The Quantity, Unit price and Total amount for each budget item are displayed as shown on the budget page.
4. If notes are associated with budget items, they are also included in this report.

Financing Section

If you have selected the financing section to be displayed (# 6 above): 

1. Ref. + Fiscal year: Reference and fiscal year of each project financing associated with budget items. 
2. Percentage of budget item associated with this financing.
3. If no financing is associated with a budget item, the columns will be empty for that item.

✏️Note: The number of columns displayed in this section is determined by the number of financing associated with a given budget item.

Financing Account Section

If you have selected the financing account section to be displayed (# 7 in the How to use this report section): 

1. Code and description of the financing account associated with the budget item.
2. Percentage of budget item associated with this account.
3. If no account is associated with a budget item, the columns will be empty for that item.

The number of columns displayed in this section is determined by the number of financing accounts associated with a given budget item.

Taxes Section

If you have selected the Taxes section to be displayed (# 8 in the How to use this report section):

1. The Group column displays the tax group associated with the budget item.
2. The % column displays the tax percentage of the tax group.
3. If no tax group is associated with a budget item, these columns will be empty for this item.

4. To associate a tax group with budget items that don’t have one, select the group from the drop-down list. To disassociate the tax group, simply delete the selected group.

 ✏️Note: The tax group selected in this section applies to all budget items with which no tax group has been associated in the Aidi Budget page.

5. When taxes are displayed in the report, you will also notice that the columns Unit price with tax and Total with tax are added to show the amounts including the tax percentage associated with the budget item.

Cashflow Tab Information

This tab shows the total budget amount, as well as the percentage of the budget broken down by period.

1. You can choose to show cumulative data or not.
2. Total budget allocated by period.
3. Percentage of budget allocated to each period.
4. Cumulative amount and percentage for each period: sum of current and all previous periods.