View forecast balances

This screen enables you to display your accounts' forecast balances as a table or a chart.


Forecast balances displayed in a table. Click to enlarge


Forecast balances displayed in a table. Click to enlarge

  1. Select Cash forecasting > Decisions and reports > Balances and cash flow analysis.
  2. In the Accounts field, select the account you wish to display. If you wish to add more accounts, click on + to reopen the list and add an account. You can also select a group of accounts, if you have any. To do so, select the group of your choice, which automatically includes all its accounts. You can unselect an account by clicking on it. This action doesn't remove the account from the group permanently.
  3. In the Period field, select the type of period to display (Day, Week, Month or Quarter) then the period to display (in days, weeks, months or quarter).
  4. In the Date type field, indicate if you wish to display your balances based on their value date or booking date.
  5. In the Transaction status field, indicate whether you wish to take into account your confirmed and/or non confirmed forecasts.
  6. Click on Display as tables or on Display as charts to display the results in the form of your choice.

Displaying balances as tables

  • Click on Options to modify the display options of the tables:
Option Definition
Details by account Displays balances of all accounts included in the selected groups.
Reverse totals Displays the totals first, followed by the detailed amounts per account.
Credit and debit balances separately Displays credit and debit balances separately.
Lines with zero amount Displays the lines containing the amounts set to zero.
Currency of amounts Displays, in all cells, the currency in which the amount is expressed.
Amounts in

Displays the amount in the selected format:

  • Units
  • Thousands (K)
  • Millions (M)
  • You can export the table in Excel format by clicking on . The generated document respects the defined display options.

Displaying balances as charts

  • Click on Options to modify the display options of the charts:
Option Definition
Accounts linked to a group Displays balances of all accounts included in the selected groups..
Lines with zero amount Displays the lines containing the amounts set to zero.
Currency of amounts Displays, when you hover over the curve with your mouse, the currency in which the amount is expressed.
Histogram bars Displays histogram bars in the balance chart: a red bar for the debits and a green bar for the credits. When you hover over a bar with your mouse, the number of transactions and the total balance are displayed.
Amounts in

Displays the amount in the selected format:

  • Units
  • Thousands (K)
  • Millions (M)
  • To hide the desired account balances' curve, click on the account below the chart.
  • To zoom in the charts, select the area to zoom in by holding your mouse pointer over it, then release it.

Converting currencies

If you manage bank accounts in different currencies, you can convert the amounts into the currency of your choice. To do so:

  1. Click on Currency conversion above the table or the chart.
  2. In the Convert amounts into field, select the currency into which you wish to display the amounts.
  3. Select a rate table. Note that this field is not displayed if no specific rate per company has been set.
  4. In Rate value field:
    • If you tick Unique rate value, Iziago will use the same rate on the whole period you entered earlier. In Rate date, enter the current date, and in the table, leave the rate value or enter a new one in relation to the reference currency.
    • If you tick Rate value at the end of each time unit, Iziago will use a different rate corresponding to each unit of time you selected (day, week, month or quarter).
  5. Click on Display. The amounts are now displayed in the selected currency.

Click to enlarge

Displaying the details of the transactions

To display the details of the forecasts taken into account, click on the desired balance in the table (if the balances are displayed in table form) or click on the curve on the desired date in the graphic (if the balances are displayed in graphic form).


Click to enlarge

In the displayed screen, you can:

  • Add new forecasts by clicking on + New forecast.
  • Export the table in Excel format by clicking on .
  • Modify the displayed date by using the drop-down list at the top of the screen.