Variance by budgetary code

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

This screen allows you to generate reports of your accounts balances by budgetary code, giving you detailed information to analyse your cash flows accurately.

Click to enlarge
 

Fill out the search form

  1. Select one or several accounts. You can also select a group of accounts, if you have one:
    • Click the group of your choice, which automatically selects 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 period to display:
    1. From the drop-down list, select a unit of time in which to display the balances (day, week, month or quarter)
    2. In the from and to fields, select values corresponding to the unit of time you selected
  3. In Date type, select whether to display the amounts on value date or booking date
  4. In the Display mode drop-down list, select Variance by budgetary code
  5. In the Currencies conversion section, if the selected accounts have different currencies, select the currency to use for conversion
    You can apply one unique rate value or the rate value at the end of each time unit selected in the Period field.
  6. Click the Display as tables button
     

Example

The table in the screenshot below must be read as follows:

  • Wednesday 14th January 2015 displays a beginning balance of 241,224.53 €
  • On that day, there was 67,340.07 € of operating incomes
  • The day displays an ending balance of 308,564.60 €, which is the beginning balance of the next day

Click to enlarge
 

The Total column of the table displays the total amounts by budgetary codes over the period you selected.

Click to enlarge
 

Options

Three icons are displayed in the top right corner of the table:

Icon Definition
Exports the report as a PDF file.
Exports the report as an XLS file.
Displays the report in full screen.


Click the Options button to modify the display of the table:

Option Definition
Lines with zero amount If ticked, the report displays lines for which there is no amount in the selected budgetary codes.
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)