Review transactions

Access in Iziago: Cash forecasting > Reconciliation > Review transactions


This page allows you to review the transactions you have forecasted, and to indicate whether they were realised or not. You will be then able to make your forecast balances equal your bank balances on the following page: Adjust balances.



Click to enlarge


1. Display transactions

Fill the form to display transactions:



Click to enlarge

  1. Select one or several accounts to review. You can also select a group of accounts, if you have one:
    • Click the group of your choice, which will automatically select 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_CORP_USD account has been removed from the selection:



      Click to enlarge
  2. In Display transactions, define the time span to display:
    1. In From, select the date of the last adjustment
      If forecasts before this date are still left, Iziago automatically displays them.
    2. In To, we recommend you to select the date of the current adjustment + 1 day
  3. In Pivot date:
    1. Indicate whether to display transactions according to their value date or booking date
      Leave Booking date selected unless your account statement is provided with value dates.
    2. Select the date of the adjustment. You do not have to make this operation for each day, but make sure you select a date for which you have the bank balances
      Due to the nature of this operation, the date can only be in the past.
  4. Select whether to display:
    • All transactions
    • Forecast transactions only (use this option for better visibility)
    • Realised transactions only
  5. You can refine your search by using the fields of the Add filters on transactions section (click the Show button on the right to expand the section)
    We recommend you to leave this section blank at first, and use it only if your original search has displayed too many transactions.
  6. Click the Display button
     

2. Review the displayed transactions

The transactions are displayed in a table. You need to review every transaction and to confirm whether they are realised or not:

  1. Check the accounts and codes
  2. Check amounts, and rectify them if needed
  3. Postpone the unrealised transactions by changing their dates
  4. If needed, delete unrealised transactions by ticking the appropriate boxes in the left of the table, then click the delete icon above or below the table
  5. Flag the realised transactions by clicking the required flag icons. Upon clicking, the icon turns green: , meaning that the transaction is flagged as realised
    If you want the transactions to be still displayed in the table after you have flagged them as realised, tick All forecast transactions in the Display field of the search form.

The forecast balances do not change upon confirmation of the transaction, since forecast balances gather all forecasts, whether realised or not. However, changing their date or their account can modify the forecast balances.

Under the table, the Modification of selected transactions section allows you to apply the same modifications to several transactions at once:



Click to enlarge

  1. In the table, select the transactions to modify
  2. In the form, select the elements to apply (accounts, codes, booking and value dates, etc.)
  3. Click the Apply button
     

If a difference between the forecast balance and the bank balance still remains, it is due to missing transactions. To cover this difference, you can either:

  • Create new forecast transactions one by one by clicking the Add new transaction button
  • Or create an overall adjustment transaction by clicking the Generate adjustment transaction(s) button. This transaction is automatically flagged as realised, making the deviation null, and your reconciliation up-to-date