Step 1

To create a batch file, start by opening an Excel file with the following column names.

Column NameRequirementsColumn Description
first_name*requiredTransaction partner: first name
middle_nameoptionalTransaction partner: middle name
last_name*requiredTransaction partner: last name
business_nameoptionalTransaction partner: business name
institution_number*requiredTransaction partner: institution number
branch_number*requiredTransaction partner: branch number
account_number*requiredTransaction partner: account number
transaction_type*requiredAction required, either direct_debit or direct_credit
amount_in_cents*requiredAmounts of funds to be transferred in cents
transaction_referenceoptionalNote for your internal reference
memooptionalIf populated, this information will show on the recipient’s bank statement as the description for the transaction

Step 2

Once the information has been entered into the spreadsheet, save the file as a .CSV (also known as Comma delimited).

Common Batch File Questions

Optional Columns:
These columns can be left blank if needed because they are not required fields, however the column name does need to be present otherwise the file will not process. Do not delete any of the column headers; the format of the file must remain as is.

Leading Zeros:
If there are numbers with leading zeros, e.g. for any of the banking information, you may notice that the zeros disappear causing problems with the file. You can format the field, starting the leading zeros with an apostrophe (‘) which will allow the cell to retain the leading zeros. For example, 001 is entered as ‘001 to retain the leading zeros.

Multiple Transaction Types:
Each batch file can only contain 1 transaction_type. Please create separate batch files for direct_debit and direct_credit transactions.