Import transactions

Access in Iziago: Cash forecasting > Transactions > Import transactions
 

This screen allows you to import into Iziago forecast transactions exported from Excel or your ERP in the CSV format. You can therefore avoid to manually enter these transactions in the software.

Click to enlarge
 

What is the CSV format?

CSV stands for "comma-separated values". It's a format allowing you to move spreadsheet data from a program (Excel, ERP) to another (in this case, Iziago). When you save a file in the CSV format, data is automatically structured using a comma (or a tab) to separate fields. This separation system allows programs to identify the end of a cell and the beginning of the following one.
 

Example

You need to import the following transactions:

Booking date Value date Amount Transaction code
10/16/2017 10/16/2017 -8547 TAXES
10/17/2017 10/17/2017 12055.46 RDTR
10/19/2017 10/19/2017 549645.21 RDTR
10/24/2017 10/24/2017 523.69 RDTR


Your file will look like the following:

  • The booking date of the transaction (column A) is in the first position
  • The value date of the transaction (column B) is in the second position
  • The amount of transaction (column C) is in the third position
  • The transaction code (column D) is in the fourth position
     

If you are using an Excel file (like in this example), you must convert it into a .txt or .csv file to make it compatible with Iziago:

  1. Click Save As in your Excel file
  2. In the Save as type drop-down list, select Text (Tab delimited) (*.txt) or CSV (Comma delimited) (*.csv)
  3. Click the Save button
     

Now your file is ready to be imported into Iziago.
 

Importing transactions

In the import screen:

  1. Click the Browse... button and select the file to import
  2. In Field delimiter:
    1. If your file is comma delimited (.csv), tick the Other box, and enter a comma in the field beside the box
    2. If your file is tab delimited (.txt), tick the Tab box
  3. If the cells of your file contain tabs or commas, you need to select a text qualifier to help Iziago display the data correctly. Otherwise, tick the None box
  4. If your file contains a header, tick the Options box
  5. In the Field mapping section:
    1. Select the fields of Iziago that correspond to the columns of your file
    2. Select the importation format of each field (when required)
    3. Arrange the lines so that they match the order of the columns of your file:
      • Click the  icon to delete a line
      • Click the  icon to add a line
      • Drag and drop the  icon to arrange the lines in the order of your choice

        Once set, the table in our example looks like this:



        Click to enlarge
         
  6. In the Account drop-down list, select the bank account related to the transactions
    This is mandatory if the Account value is not selected in the mapped data. If the transactions involve several bank accounts, add an "Accounts" column to your file.
  7. In the Realised status drop-down list, select whether the transactions are realised or still forecast (not mandatory)
  8. Click the Import button
  9. If you want to use the same settings for further imports:
    1. Tick the Import and save settings as box
    2. Enter the name of the import format in the field
  10. If you do not want to use the same settings for further imports, tick the Import without saving settings box
  11. Click the Import button
     

Once the importation completed, Iziago diplays a report detailing the number of successful, failed and ignored transactions. You can export the report in PDF by clicking the  icon.

You can find the imported transactions in the Search and modify transactions screen. Here's what our transactions look like once imported:

Click to enlarge