This screen allows you to manually create and modify forecast budgets for a company. A budget represents all the expense and revenue targets of a company over the long term. It is defined by fiscal year (usually a calendar year), and with a given periodicity (weekly, monthly, quarterly, as desired).

The Budget follow-up screen allows you to follow the differences between your budget and your transactions (realized and forecast).

Create and modify a treasury budget

Prerequisite:

• You must have the Display and Create, modify & delete rights on the Budget function for the Cash forecasting module. This right can be defined in the Users and Rights > User administration > Users menu. 

1. Select Cash forecasting > Treasury Budget > Budget management.
2. Select the company for which you wish to manage your treasury budget.
3. Click on Display. The management table for the current calendar year is displayed.  
4. By default, the table periodicity is monthly. You can modify the display of the table; 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: Week Month Quarter
   Number of columns - past {periods}	Select the number of columns to display in the "Realized" section. This section, which cannot be entered, contains the amounts corresponding to the realized transactions in past periods. Example: Periodicity - display by: Month Number of columns - past {periods}: 3 Current month: April Here, Iziago will display in the "Realized" section 3 columns corresponding to the 3 months preceding the current month: January, February and March.
   Number of columns - future {periods}	Select the number of columns to display in the "Budget projection" section. This section allow you to enter, for the company, your expense and revenue targets for the current and future periods.  Example: Periodicity - display by: Month Number of columns - future {periods}: 4 Current month: April 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.

5. In the "Budget projection" section of the table, enter (or modify) the company's revenue and expense targets by budgetary code. Enter the revenues as positive amounts and the expenses as negative amounts. The currency is the one configured for the company. The entry is saved automatically.
   Tip: To quickly carry over an amount to subsequent periods, click on .
   Example: The periodicity of your budget is monthly. To add a rent to be paid of €5,000 in May, enter "-5000" in the cell of the corresponding budgetary code, in the May column. To enter the same amount from June to December, click on .

Import a treasury budget 

You can import into Iziago budgets exported from Excel or from your ERP in CSV format.

What is the CSV format ?

The CSV format allows you to transfer table data from a program (Excel, ERP) to another program (in this case Iziago). When you save a CSV format file, the data is automatically structured using a separator character (usually a semicolon or tab) that marks the end of a cell and the beginning of the cell that follows.

If you are using an Excel file, you must convert it to a .csv file to make it compatible with Iziago:

1. In your Excel file, click on Save As.
2. In the Save as type drop-down list, select CSV (Comma delimited) (*.csv).
3. Click on Save.

Your file is now ready to be imported into Iziago.

How do I import a CSV file into Iziago? 

Prerequisite :

• You must have the Display and Create, modify & delete rights on the Budget function for the Cash forecasting module. These rights can be configured in the Users and rights > Users administration > Users menu.
• You must have created budgetary codes.
• You must have selected the required periodicity in the table display options.

1. Select Cash forecasting > Treasury budget > Budget Management, then select the company for which you want to manage your treasury budget.
2. Click on Display. Your budget displays in a table.
3. Click on Import from CSV.
4. Click in the File to import field and select the file to import. New fields are displayed.
5. In the File format parameters section, specify:
   • If your file contains a header.
   • The used field delimiter.
   • If your file contains a text qualifier. Otherwise, check none.
6. In the File structure section:
   • Select the imported budget Initial period.
   • If you want to exclude the first column of the imported file, select the checkbox.
   • In the table first column, select the budgetary codes that are relevant to the imported budget.
7. Click on Import. The imported budget displays in a table in the Cash forecasting > Treasury budget > Budget Management screen.
8. If you wish, you can change the amounts in your budget. To do it, follow the Create and modify a treasury budget procedure.