Import transactions

Instead of manual data entry, import your transactional data directly into IRIS Elements Cashbook.

You have two options:

1. Open Banking: Import directly from your account provider with the account holder's explicit consent.

2. CSV file: Import transactional data from a CSV file from your account provider. Most institutions all users to export transactional data in this format.

Regardless of the feed type, importing and matching process is largely the same. Easily match transactions to purchase sales invoices to maintain a real-time, accurate flow of financial data in IRIS Elements Cashbook.

You can switch between feed methods at any time.

Open Banking import

1. Go to Banking > Bank. For the appropriate account, select Import.
   

2. Set a date range to import using Start date and End date then select Retrieve Transactions.
   

3. Transactions that fall within the dates range are retrieved from the linked bank account and loaded into IRIS Elements Cashbook.

4. Matching rules are applied. Transactions are matched based on system rules first then custom rules in the order they are listed.
   

5. Work through the list to Match or Ignore all transactions.

   Learn more about matching transactional data.

6. Once all the transactional data has been matched, select Import now.
   

You should carefully review the transactions before you select Import now.

When you reconcile, your target bank balance is automatically populated from your bank data.

CSV file

1. Go to Banking > Bank. For the appropriate account, select Import.
   

2. Select Upload new CSV.
   

3. Matching rules are applied. Transactions are matched based on system rules first then custom rules in the order they are listed.
   

4. Work through the list to Match or Ignore all transactions.

   Learn more about matching transactional data.

5. Once all the transactional data has been matched, select Import.
   

You should carefully review the transactions before you select Import now.

When you reconcile, your target bank balance is automatically populated from your bank data.

Change import feed source

You can change the feed source between Open Banking and CSV at any time.

1. Go to Banking > Bank. For the appropriate account, select Import.
   

2. From the Actions (3 dots, ) menu select Change source.

3. Select Proceed on the displayed confirmation.

4. Select the new method for the bank feed.