Balances and cash flow analysis

Access in Iziago: Cash forecasting > Decisions and reports > Balances and cash flow analysis
 

This screen allows you to display your accounts' forecast balances and follow their evolution.

You can either display the balances as tables:



Click to enlarge
 

...or as graphs:



Click to enlarge
 

To do so:

  1. In the Accounts field, select one or several accounts to display. You can also select a group of accounts, if you have one:
    • Click the group of your choice, which automatically includes all its accounts. Note that you can unselect an account by clicking it if needed (this action doesn't remove the account from the group permanently). In the example below, the EXASOLAR SA group has been selected, and the HSBC_SARL_USD account has been removed from the selection:


      Click to enlarge
  2. In Period:
    • Select the type of period to display (Day, Week, Month or Quarter)
    • Select the corresponding period to display (from and to fields)
  3. Tick the date type of your choice:
    • Value date: Iziago processes the accounts' initial balances on their value dates, and adds the forecasts' amounts based on their value dates
    • or Booking date
  4. In the Display mode drop-down list, select Balances
    To learn about the Variance by transaction code and Variance by budgetary code display modes, click the following links: Variance by transaction code, Variance by budgetary code.
  5. Click the Display as tables button, or the Display as graphs button to display the results in the form of your choice
     

Display balances as tables

  • Dates in columns' headers are displayed in the short format defined in the Interface profile menu
  • Current day's column is highlighted
  • Rows are expandable
     

Clicking the Options button allows you to modify the display options of the tables:

Option Definition
Details by account If ticked, the tables display balances for all accounts included in each selected group.
Reverse totals If ticked, the tables display the totals first, followed by the amount details for each account.

Credit and debit balances separately

If ticked, the tables display credit and debit balances separately.

Lines with zero amount

If ticked, the tables display lines for which there is no amount.
Currency of amounts If ticked, the tables display currencies next to each amount.
Amounts in

Allows you to modify the display of amounts:

  • Units: amounts fully displayed (example 102,554.29)
  • Thousands: amounts displayed in thousands (example 102.55 K)
  • Millions: amounts displayed in millions (example 0.10 M)


Clicking an amount in the white rows of the table displays the details of transactions. From this page, you can add new forecast transactions by clicking the Add new forecast button.

You can export the tables in Excel format by clicking the XLS icon:



Click to enlarge
 

Note that the generated document respect the display options you have set:



Click to enlarge
 

Display balances as graphs

Clicking the Options button allows you to modify the display options of the graphs:

Option Definition
Accounts linked to a group If ticked, the graphs display balances for all accounts included in each selected group.
Lines with zero amount If ticked, the graphs display lines for which there is no amount.
Currency of amounts If ticked, currencies are displayed next to each amount when you move your mouse over the lines of the graphs.
Amounts in

Allows you to modify the display of amounts:

  • Units: amounts fully displayed (example 102,554.29)
  • Thousands: amounts displayed in thousands (example 102.55 K)
  • Millions: amounts displayed in millions (example 0.10 M)


To display the transactions details of an account on a given date, click its corresponding line in the graph:



Click to enlarge
 

You can disable the displaying of specific accounts by unselecting them under the graphs:



Click to enlarge
 

You can also zoom in the graphs. Select the area to zoom in by holding your mouse pointer over it, then release it:



Click to enlarge
 

Convert currencies

If you are dealing with bank accounts in different currencies, you can convert the amounts of the table into one currency.



Click to enlarge

To do so, use the settings in the Currencies conversion section:

  1. Select the currency into which to convert the amounts
  2. Select a rate type and a rate table (if you haven't set any rate type or rate table, leave Common rates and Default rate selected). Note that the Rate type field is not displayed if no specific rate per company has been set
  3. In Rate value:
    • 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)
  4. Click the Display button

Amounts are now displayed in the selected currency only.


DETAILS OF TRANSACTIONS

You can display the details of transactions on a specific day by clicking amounts in the tables or in the graphs:

Click to enlarge
 

On this screen, you can find a table listing every transaction's:

  • ID system
  • Confirmation status
  • Booking date and value date
  • Amount
  • Account
  • Transaction code and budgetary code
  • Description and references
     

You can export the table in Excel format by clicking the XLS icon.

To display another day, use the Day field:

Click to enlarge