Bank Files for all finalised pays can be found under Payroll > Reports > Bank Files
These files contain employees’ salary direct credit information and should be uploaded to your (i.e. the employer’s) bank account to pay your employees. The file format is determined based on the Bank Account number entered on the Company Setup screen.
Supported banks are ANZ, BNZ, Westpac, ASB, KiwiBank, Nelson Building Society*, Heartland Bank* and Rabobank. If no Bank Account number is entered on the Company Setup screen the file will default to the ANZ file format. If your company requires a different bank, please contact the FlexiTime team. Also contact us if you're using NBS as they have special requirements.
Please note that most banks require you to register to use their online business banking service in order to be able to import files. Please contact your business banking adviser for assistance.
There are three versions of the Banking Batch report:
- Banking Payments Batch. This creates a bank file of all payments from a pay date, including employee and tax payments.
- Banking Tax Batch. This creates a file for paying Inland Revenue payments, which are usually due on the 20th of the month following the tax period. If you're filing twice monthly, then you can't use this file to pay IRD, as it includes the full month's payment.
- Banking Employee Batch. This creates a file of employee net pays and any other non-IRD payments for a specified pay date.
In most cases you should use the Banking Employee Batch to pay the employee and any other non-IRD payments on the pay date, and the Banking Tax Batch on the 20th of the month to pay the previous month's tax.
You can choose to download the Payments Batch file or to view details onscreen. If you download the file, you can then open that file using a text or spreadsheet program to view the contents.
The details for the Payments Batch file are derived from information entered on the Employee Details screen (Setup > Employees > edit > Employment Details) and from the Pay Code screen (Setup > Pay Codes > edit). Both screens include bank account details as follows:
Bank Account No – Enter in the format BB-BBBB-AAAAAAA-SSS
The following three fields are used for bank statement details:
Bank Particulars – Other Party Particulars (12 Characters Max)
Bank Code – Other Party / Subscriber Analysis Code (12 Characters Max)
Bank Reference – Other Party / Subscriber Reference (12 Characters Max)
* To load Nelson Building Society and Heartland Bank files you need to do the following:
1) Rename the file extension from .dbk to .csv.
2) The Code, Reference and Particulars are mandatory for these banks. The easiest way to ensure these are included in the bank file is to set them on the Direct Credit pay code in FlexiTime.