KiwiBank Direct Debit Batch Rejected

The Direct Debit batch file for Kiwibank has a header row, one or more detail rows and a trailer row.

Sometimes, when a Direct Debit batch for Kiwibank is being created,  and it contains a Customers Kiwibank account in one or more of the detail rows, there is a problem with the export file.

The format for the Kiwibank Export has a checksum value on the last line of the batch.  This checksum adds up the bank accounts on the detail rows. It ignores the first two digits (the Bank identifier) and the last 2-3 suffix digits. i.e. it is adding up the branch and bank account numbers in positions 3 to 13 inclusive.

Where the customer bank account on the detail row is for a Kiwibank account, the branch numbers are numbers in the range 9000-9499 and the resulting checksum is larger than the available 11 digits.  The resulting checksum number then converts to an exponential number (E+)

A ticket has been created for this 13584

In the meantime, when doing a Direct Debit for Kiwibank accounts, we recommend adding a marker to customer accounts with a Kiwibank account;  the marker should be against one of the customer fields that displays in the Prepare/Export Direct Debit screen.  Then do an export for all non-Kiwibank customers. Run additional export(s) for the Kiwibank Customers.  The additional export file(s) may need to be repaired by exporting it to Excel; recalculating the checksum and editing the text file to provide to the bank.