The Bank File Layout option in New Zealand database allows you to set the format for the Bank File. MicrOpay contains several templates, or you can create a customised version of the layout.
File Layout templates for the following banks are available:
ANZ Bank
ASB Bank Ltd
Bank of New Zealand Ltd
CitiBank
HSBC
National Australia Bank
Westpac Banking Corporation
To access File Layout, go to Payroll, Maintenance, General, Company Banks, File Layout.
The File Detail tab within each layout contains the output file location and format details. It cannot be removed from the File Layout. If you would like a consultant to set up a bank file for your company, raise a case online and request Consulting Services (billable service).
Add a File Layout
The Bank File needs to meet your Bank's Specifications, which you can request from your Bank. To add a new Bank File Layout, follow the steps below:
Go to Payroll, Maintenance, General, Company Banks, File Layout.
Select Add.
To use a template, select Load from Template. To create your own file layout, leave this blank. When the template is loaded, the rows and fields are automatically populated.
Enter a File Layout Code and a File Layout Description
Use the New Header Row, New Detail Row and New Footer Row buttons to add additional rows to the layout, if required.
To remove a row from the layout, click on the corresponding tab and then Delete Selected Row. The File Detail tab cannot be deleted.
To add fields to a row, click on the corresponding tab, e.g. Detail 1
Use the Navigation buttons to move the fields from the Source List (what you can include) on the left to the Destination List (what will be in the file) on the right.
Use the green single right arrow to add selected fields to the Destination list or use the green double right arrows to add all fields to the Destination List.
Use the green single left arrow to remove selected fields from the Destination List or use the green double left arrows to remove all fields from the Destination List.
Use the blue up arrow and blue down arrow to order the fields in the Destination list.
Repeat Step 8 for each row, as required.
Click on the File Detail tab.
Enter the:
Name of Output File - this is what the file will be named when generated
Extension of Output File
Path of Output File. This is the default location that the file is saved to. It should contain the full file path, e.g. drive letter and directory path. You can also Browse to navigate to the file location.
Select the Action if file exists. This determines what happens when the file is generated, but it already exists. You can choose from:
Choose action
Overwrite file
Append to file
Append date & time to file name
Append count to file name
Always Append Date & Time to file name
Always append count to file name.
Select the File Format. Dependent on the format you choose, the following fields may need to be selected:
Field Width - used when each field starts at a certain position
Filed Delimiter - characters that are placed around text values e.g. quote marks (")
Field Separator - used when a character is used to separate fields, e.g. comma (,)
End of Line Character - used to define where one record ends and the next one begins.
Click OK to save the File Layout.