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
- In the Company Info setting, ensure the Company Name is correct (not needed for National Bank).
- In the Banks setting:
- Enter a record in this setting for your own Bank (only needed for ANZ and BNZ).
- For your own Bank, enter your Subscriber ID in the Sort Key field (only needed for ANZ (16 characters) and BNZ (seven characters)).
- 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.
- In the Contact records for each Supplier:
- 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.
- Enter the branch code of the branch where the account is held in the BSB field (not needed for Westpac).
- 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.
- In the Payment Modes setting:
- 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).
- Enter the branch code of the branch where the account is held in the BSB field (not needed for Westpac).
- If your bank is ANZ or BNZ, enter it on flip A using 'Paste Special'. This will allow the Subscriber ID to be included in the export file.
If your bank is not ANZ or BNZ, you can optionally still enter it on flip A. If you do, you must enter the appropriate Payment File Format in the relevant Bank record (step 2c above).
Purchase Invoices
- Specify a Supp. Inv. No. in each Purchase Invoice.
Payments
- 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.
- Select "Per Supplier" as the Payment Format on the 'Bank' card if appropriate. Do not select this option if your bank is ASB.
Exporting
- The Payment File Format will be determined by the first Payment in the range. If the Payment Mode in that Payment has been connected to a record in the Banks setting (step 4c above), the Payment File Format will be taken from that Bank record (step 2c above). If the Payment Mode in that Payment has not been connected to a record in the Banks setting, the Payment File Format will be taken from the Bank Transfer setting. The Payment File Formats of the other Payments in the range will then be checked in the same way (by checking the Payment Mode for a connected Bank record and if not the Bank Transfer setting). Any Payment that uses a different Payment File Format will not be exported.
- If you specify a Currency in the 'Specify Banking File' window, only Payment rows with that Currency as Bank Currency will be exported.
- If a Payment record contains more than one row with the same Supplier, you can select One Payment per Supplier in the 'Specify Banking File' window 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.
- If you select the Unexported Only option in the 'Specify Banking File' window, Payments in the range that have not been marked as Ordered and those that have been marked as Ordered will be exported. Payments that have been marked as OK will not be exported. After the export process, any unordered Payments in the range will be marked as Ordered automatically. If you need to export a Payment that has been marked as OK, select the All option in the 'Specify Banking File' window but be careful when specifying the range of Payments to be exported as any Payments in the range that have previously been exported will be exported again. Payments and individual Payment rows that have been invalidated will never be exported.
---
Export functions in the Purchase Ledger and Integration modules:
- Introduction
- Banking File, including:
- Australia - ABA
- Croatia (Croatia - SEPA)
- Czech banking file formats (includes Czech - ABO and Czech - CITI bank)
- Danish banking file formats (includes BGBank, Den Denske Bank, Jyske Bank, Midtbank, SYDBANK and Unibank)
- Estonian banking file formats (includes Riigikassa and Swedbank Gateway)
- Finland - SEPA
- Germany - SEPA
- Hungary - HVB
- Italy - SEPA
- Latvian banking file formats (includes FidaVista and SEPA)
- Lithuanian banking file formats (includes LITAS-ESIS 1.1 and SEPA)
- Namibia
- New Zealand banking file formats (includes ANZ, ASB, BNZ, KiwiBank, National Bank and Westpac)
- Norwegian banking file formats (includes DnB Telepay, K-Link, SparNett, Postbanken, Telepay 2 and SEPA)
- Polish banking file formats (includes Elixir, ING Bank and Reiffaisen Bank)
- South Africa - First National Bank
- Spain - SEPA
- Swedish banking file formats (includes Handelsbanken, Nordea, PostGirot, SE-Banken, Swedbank and SEPA)
- UK - BACS
- Intrastat Purchase Invoices UK
- Open Purchase Invoices
- P/L Liquidity List
Go back to:
|
