Language:


Banking File - New Zealand

This page contains some guidance about where to enter information in order for it to be included correctly in Banking File export files when they are produced using the various New Zealand bank Payment File Formats.

Configuration

  1. In the Company Info setting, ensure the Company Name is correct (not needed for National Bank).

  2. In the Banks setting:

    1. Enter a record in this setting for your own Bank (only needed for ANZ and BNZ).

    2. For your own Bank, enter your Subscriber ID in the Sort Key field (only needed for ANZ (16 characters) and BNZ (seven characters)).

    3. Enter the appropriate Payment File Format in this Bank record ('Banking File' card): you must set a Payment File Format both in each Bank record and in the Bank Transfer setting.

  3. In the Contact records for each Supplier:

    1. Enter the Supplier's bank account number in the Bank Account field. This should consist of a Bank ID, Branch Code, Account Number and a Suffix.

    2. Enter the branch code of the branch where the account is held in the BSB field (not needed for Westpac).

    3. If the Supplier has a Factoring Supplier, follow steps (a) and (b) above for that Factoring Supplier. Payments will be sent to the Factoring Supplier.

  4. In the Payment Modes setting:

    1. Enter your bank account number in the Bank A/C No. field in each Payment Mode. This should consist of a Bank ID, Branch Code, Account Number and a Suffix (not needed for ANZ or National Bank).

    2. Enter the branch code of the branch where the account is held in the BSB field (not needed for Westpac).

    3. If your bank is ANZ or BNZ, enter it on flip D using 'Paste Special'. This will allow the Subscriber ID to be included in the export file.
Purchase Invoices
  1. Specify a Supp. Inv. No. in each Purchase Invoice.
Payments
  1. If you enter a Reference in a Payment header, it will be exported if the BSB in the Payment header is empty (in the 'Reference' position) or if the BSB in a Payment row is empty (in the 'Other Party Reference' position).

    In the case of ASB and Westpac, the Reference will always be exported.

  2. Select "Per Supplier" as the Payment Format on the 'Bank' card if appropriate.
Exporting
  1. If you specify a Currency in the specification window, only Payment rows with that Currency as Bank Currency will be exported.

  2. If a Payment record contains more than one row with the same Supplier, you can select One Payment per Supplier if you want those rows to be grouped together in the export file. If selected, all Payments will be exported on a One Payment per Supplier basis. If not selected, only those Payments where the Payment Format is Per Supplier (step 7 above) will be exported on that basis.
---

Export functions in the Purchase Ledger and Integration modules:

Go back to: