Bulk Instruction Import

Background: This screen serves as the central hub for importing switches, recurring instructions or once off withdrawals instructions, as well as updating existing recurring instructions in bulk. 

Available Functions:

1. Import Switch Instructions
2. Import Once-Off Withdrawal Instructions
3. Import Recurring Instructions
4. Import Recurring instructions BI

Once a file has been populated using the required column headers and accepted input values, it can be imported via the Bulk Instruction Import screen by selecting the .csv file and the relevant button (Import Switches, Once Off Withdrawals, Recurring Instructions or Recurring instructions BI).

If an import’s status indicates ‘failed’, please review the error message/s displayed on the screen for guidance on issues that require correction before the file can be imported successfully.

 Import Switch Instructions

Facilitates the bulk import of switch instructions via a structured file upload. 

Column headers: Account number, Transaction date, From instrument, To instrument, Amount/Percentage/Units, Amount, Purpose

Import Once-Off Withdrawal Instructions

Column headers: Account Number, Units of Withdrawal (the input value in this column is: Percentage or Units or Amount), Purpose, “Instrument Code” (each instrument should be noted in a separate column.), Bank Account Number (optional)

The fields can be in any order.

Example column headers: Account Number, Units of Withdrawal, Purpose, ZAR, AGBF 

Example values in fields: POL3, Percentage, Investor Withdrawal, 50, 20

Import Recurring Instructions

Import new recurring instructions in bulk via the Upload Instructions screen by importing a correctly populated .csv file via the ‘Recurring instructions’ button on the Bulk Instruction Import.

Column headers: Contract Number, Instrument Code, Instruction Type, Frequency, Work in, Amount/Percentage, Next Escalation Date, Escalation frequency in years, Escalation rate, Commencement date, Day of month, Bank account number, Purpose

Import Recurring instructions BI

The purpose of this import is to update the instrument buys on existing instructions on an active contract (i.e. the last existing new, rejected, submitted, or “ready to recur” recurring investment instruction on an active account). 

Column headers: Contract Number, Instrument Code, Percentage

Important note: This import is limited to only work in percentage splits.