Important Notes:

  • Once SEPA is enabled in The Raiser's Edge, it cannot be disabled.
  • SEPA files are processed using SEPA compliant software.  Contact your bank for further information and assistance.
  • SEPA does not affect United Kingdom at this time. Being GBP based only, UK means of payment are not impacted by SEPA.
  • See SEPA key terms for more information on acronyms used in SEPA documentation.



The migration of constituent bank information is typically run only once to update all banks that are currently present in Raiser’s Edge, to populate banks with SEPA IBAN and BIC information.
After existing bank information has been updated with the IBAN and BIC information, users should populate these fields when adding new bank information in Raiser’s Edge.

  1. Export all (old) Financial Institution Account Numbers (also known as Basic Bank Account Number or BBAN) so that they can be changed into IBANs.
    Note that the BBANs are not deleted from The Raiser’s Edge through this process.
    Go to Admin > Import.
    Select Constituent > Constituent Bank
    Click New and on the General tab -
    What do you want to do: Create Import File
    Options: Include All records
    Include selected fields
    What file do you wish to create: Click the browse button to choose the location and specify the name of the file to be created (note the location and name).

    On the Fields tab include Account Number and sort code from the available field list on the left
    Create Import File
    Click Create Now
     
  2. To check the file exported, Open Excel and select File, Open and browse to the location that was used to create the file, change Files of Type to All files and open the file.
    If the Excel Text Wizard is invoked
    Page 1 of 3 select Delimited
    Page 2 of 3 select Comma Separated and the preview at the bottom should show fields correctly aligned.
    Page 3 of 3 the 1st field in the preview shows as black / selected - use the horizontal scroll bar at the bottom of the preview until you see the last field then hold down the shift key and click into the last field in the preview - all fields should now show black and change the format from General to Text and click Finish

    When the file opens in Excel check to ensure the sort code and account number are populated for all records.
    If either field is blank then you would need to either remove the row from the file or update the record in Raiser’s Edge and repeat the above steps until all sort codes and account numbers are populated.
     
  3. To find records where the sort code or account number are blank in Raiser’s Edge

    Blank sort code -
    Create a constituent query with the criteria
    Relationships > Banks, Account Number equals {the account number from the exported file}
    AND Sort code blank.
    Include the constituent name and bank name in the output tab and run the query
    Correct the bank record via the constituent relationship tab and repeat these steps for any other record with a blank sort code.

    Blank account number -
    Create a constituent query with the criteria
    Relationships > Banks, Sort Code equals {the sort code from the exported file}
    AND Account Number blank.
    Include the constituent name and bank name in the output tab and run the query
    Correct the bank record via the constituent relationship tab and repeat these steps for any other record with a blank account number.

    When complete repeat the step 1 to export the updated information.
     
  4. Depending on how you are adding IBAN (i.e. what third party software is being used), the exported file may have to be edited to a specific format.
    For instance, in Ireland the www.ipso.ie site allows only Account Number (with eight characters) and Sort Code (with no dashes).
    Once any required changes are made to the file in Excel,select File, Save As and save as an Excel spread sheet as this will be required when the information is returned.

    Then select File, Save as once again and this time save in CSV (Comma Separated Value) format, or whichever format is requested by third party software provider.
    This saved file is the uploaded to the 3rd party site - eg to www.ipso.ie for the bulk SEPA service.
    Contact the third party for further assistance.
    Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist with implementing resolutions from these websites.
     
  5. Once the file has been processed by the SEPA third party service, where the file sent contained the Account Number and Sort Code, the returned file will include Account Number, Sort Code, IBAN and BIC.
    As the return file does not include the Raiser’s Edge Bank Import ID or Financial Institution Import ID, open the spread sheet that was saved in step 4 and paste the IBAN and BIC columns into this spread sheet
    The file should look like this:
    SEPA return file example 
    Select File, Save as and save as CSV(Comma Separated Values) file then close the file in Excel.
     
  6. Back in Raiser’s Edge, Admin, Import, create a new Constituent Bank import.
    On the General tab -
    What do you want to do: Update Existing Records
    Options:  Validate Data Only
    Import File: Browse to pick up CSV file saved from Excel

    On the Fields tab ensure the fields in the import file are mapped to the correct Raiser’s Edge fields
    SEPA Import  - Fields tab
    On the Summary tab you can tick the option to create Output query of records updated, which may be of assistance spot checking the records updated by this import.
     
  7. Click Validate Now.
    Ensure there are no exceptions before proceeding.

    Also ensure you have a current backup of Raiser’s Edge. If Blackbaud hosts your data then backups are taken every 15 minutes, so note the time before you proceed.
     
  8. When no exceptions remove the tick from validate data only on the General tab and click Update Now.
     
  9. When complete, spot check the bank information on the constituents via the bank option on the relationship tab.