Search and modify transactions

Access in Iziago: Cash Forecasting > Transactions > Search and modify transactions
 

This page allows you to search for forecast transactions and operations from your bank statements that you added to your Iziago environment. Once displayed, you can delete or modify transactions.



Click to enlarge


How to search transactions?

Here's what the search form looks like:



Click to enlarge


Display all your transactions

You don't need to enter any information in the form. Simply click the Search button.
 

Display specific transactions

  1. Fill the General section:
    • Accounts: accounts on which the entries are made. Note that you can select a group of accounts, and also unselect an account from this group by clicking it
    • Transaction code, Budgetary code: types of the transactions (list of transaction codes, list of budgetary codes)
    • Booking date: date on which the entry was posted to the bank account
    • Value date: date on which the asset becomes available (credit entry) or unavailable (debit entry)
    • Amounts: enter amounts to determine a range to search. You can search by amount or instructed amount (original amount before conversion)
    • Currencies: enter as many currencies as needed. You can search by amount or instructed amount (original amount before conversion)
    • Description: enter a key word, and select a filter in the drop-down list (Is - Is not - Contains - Does not contain)
    • References: enter any references about the transactions. Click the  icon to enter more references
    • Reconciled: realised or unrealised transactions
  2. Click the Search button

The results of the search are displayed in a table under the form. To modify a transaction, simply click it.

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

Click to enlarge
 

To change the display of the table's content, click the Content Manager button above the table (to learn how to use the content manager, click here).

And to display empty columns:

  1. Click the Options button
  2. Tick the box
  3. Click the Confirm button

Click to enlarge
 

VIEW FORECAST TRANSACTIONS

Access in Iziago: Cash forecasting > Transactions > Search and modify transactions > Forecast transaction information


Once you have run your search on forecast transactions, clicking a transaction allows you to display its details:

  • The account on which it is recorded
  • Its transaction code and budgetary code
  • Its booking date (date on which it was posted to the bank account)
  • Its value date (date on which the asset becomes available (credit entry) or unavailable (debit entry))
  • Its amount
  • Its Description
  • Its Iziago references (entered by the user who created the transaction to easily identify it)
  • Its Type
  • Whether it is integrated in Iziago or not
  • Whether it is realised or not

You can also consult the transaction's additional fields:

  • Whether the transaction is exonerated from bank charges or not
  • The number of individual transactions (if it's a batch)
  • Confirmation status (confirmed or not confirmed)
  • Background colour in tables
  • Text colour in tables

And finally, you can consult the transaction's system information:

  • Its ID assigned by Iziago
  • Its creation date in Iziago
  • Its creator
  • The date of its last update
  • Its editor
     

EDIT FORECAST TRANSACTIONS

Access in Iziago: Cash forecasting > Transactions > Search and modify transactions


Once you have run your search on forecast transactions, and if you have the appropriate rights, clicking a transaction in the results table allows you to modify its general information:

  • Account
  • Transaction code
  • Budgetary code
  • Booking date
  • Value date
  • Amount

You can also change the transaction's additional fields:

  • Whether the transaction is exonerated from bank charges or not
  • Number of transactions
  • Confirmation status (confirmed or not confirmed)
  • Background colour
  • Text colour

Once you have you are done editing the transaction, click the Save button.

From this page, and if you have the required rights, you can:

  • Split the transaction by clicking the Split button
  • Add a new forecast transaction by clicking the New forecast button
  • Delete the transaction by clicking the Delete button

Modify several transactions at once

Using the Modification of selected transactions section, you can apply the same set of modifications to several transactions at once.



Click to enlarge

To do so:

  1. In the Select column of the table, tick the transactions to modify
  2. In the Modification of selected transactions section, under the table, apply the modifications of your choice
  3. Click the Apply button
  4. In the pop-in window, click the Modify button to confirm the modification
     

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:

  1. Add the Currency column to the table (to learn how, consult the "Content manager" section of the Tables help page)
  2. In the Currency conversion section:
    1. Select the currency into which to convert the amounts
    2. Select a rate type and a rate table
    3. In Rate date, enter the current date
    4. In the table, leave the rate value or enter a new one in relation to the reference currency
  3. Click the Search button

The table now displays the amounts only in the currency you selected (in our example, the amount in USD has been converted into euros):


SPLIT FORECAST TRANSACTIONS

Access in Iziago: Cash forecasting > Transactions > Search and modify transactions


This function is useful when you have agreed with a creditor or debtor to spread payments over a specific period of time. You can split a transaction into several transactions:

  • Once you have created a transaction and clicked the Save and split button
  • Once you have displayed a transaction and clicked the Split button

You cannot split transactions that are linked to a recurring transaction.


Click to enlarge
 

The first line of the table displays your original transaction. Iziago automatically splits the transaction into two transactions, each of them displaying half of the original amount. Here's how to customise the payments:

  1. In the field above the table, enter the planned number of transactions and click the Compute button
    The original amount is evenly divided in the table in order to match the number of transactions you entered.
  2. If you are sure the payments will actually occur, select the Confirmed value in the Status column for every transaction
  3. Select the booking date and value date of every transaction
  4. If required, enter new amounts for the transactions of your choice
    You can check in the grey box under the table that there is no difference between the total amount before split and the total amount after split.
  5. Click the Save button
  6. In the pop-up window, click the Split button to confirm

This action cannot be reversed.

Here's what our example looks like:

Click to enlarge
 


DELETE FORECAST TRANSACTIONS

Using the Select column of the table, you can delete several transactions in just one action.

This action cannot be reversed. Note that you can only delete transactions that have not been realised yet.

  1. In the Select column, tick the transactions to delete
  2. Click the bin icon(above or below the table)
  3. In the pop-in window, click the Delete button to confirm the deletion