Return to Training page | Print
NetBank Business: Importing batch payments in CSV format
 
This function allows you to import a template for batch payments in one of the following file formats: NetBank Business (secure format), NetBank Business (secure format using beneficiary reference number), CSV (comma-separated values), CSV template (using beneficiary reference number), Fixed width (specified field lengths) format including NedInform, ACB (accounting packages), Send-iMali format or Send-iMali (secure format).

Note: These menu options will be available only if your access rights allow you to import templates for batch payments.

Accessing the Import batch payments screen
1 Follow this path through the main menu to access the Import batch payments screen:
Transactions > Payments > Import Batch Payments

The Import batch payments screen
2 The Import batch payments screen is displayed.

3 The CSV template option is the default format on the system. Use the radio buttons to select the format you want to use. If your profile uses NetBank Business (secure format), you will not be able to select any of the other formats from the list. You must then use the secure format.
4 Use the Browse button to find and select the file you want to import. The file needs to be in the format you have selected.

5 If you tick the checkbox and enter a description in this field it will replace the beneficiary statement description for all entries imported from the CSV file.

6 Note the header and footer exclusion row fields in the Exclude rows from the beginning and end of the file section. These parameters will allow you to exclude the specified number of rows from the beginning and end of the file being imported. These rows would typically contain header information and/or footer information that you do not want to import.

7 The template layout for a CSV file is also displayed on the screen. This indicates the required sequence of the columns in the CSV file you have selected to import.

8 Once you have selected the file to be imported, click on the Import batch button to continue with the importing. Up to 10 000 entries can be captured in a batch.

The Batch payments – imported screen
9 The Batch payments – imported screen is displayed.

10 The batch description in the Batch description field can be edited.

11 Imported batch payments can be future-dated. Enter the date or select it from the calendar provided. Your payment limit will be taken into account on the day that the payment is processed.
12 Specify if the payment will be made from a single-debit-account or from multiple-debit-accounts by selecting either the Single debit account radio button or the Multiple debit accounts radio button from Debit account/s.

13 If the Single debit account radio button is selected, you will be able to select the account from which the payment will be made in the From account dropdown list in the Batch information section of the screen.

Note: You will only be able to select an account for which you have capture rights.

If the Multiple debit account radio button is selected, you will have to select the accounts from which the payments will be made in the From account dropdown list, which will be visible in the Capture payments section and not in the Batch information section.

14 Select the account from which the payments must be made in the From account dropdown list.

15 The Batch status field will indicate that the batch is an imported batch.

16 You can select the Yes or No radio buttons from the Single Debit item to indicate whether or not you would like to have a single debit description and total on your statement, ie a consolidated amount and total for the entire batch.

Note: If you select the Yes radio button, all the My statement description (Dr) fields for all transactions in the batch will become inactive and the Description field next to the radio buttons will become active. Enter the description you would like to see on your statement for the single debit or consolidated total. If you select the No radio button, your statement will reflect each and every transaction in the batch with the transaction amount. It is possible to edit all the My statement description (Dr) fields for all the transactions in the batch. This is available only if the batch contains a single 'from' account.
17 Specify the Payment type by selecting the relevant radio button.
Note: If you choose Same-day the payment is processed and value is given on the day it is submitted to Bankserv, ie on the action date.

A one day-dated payment type is a service that requires the data to reach Bankserv in one working day before the action date.

A two-day dated payment type is a service that requires the data to reach Bankserv in two working days before the action date.

A Real time payment is a single payment which is settled in real time.

18 If you decide to process the batch with 1-day dated, 2-day dated or Real-time payment (1 hour) payments, you will be presented with a warning message. You will have to read and acknowledge the rules and cutoff times regarding these payment types.
19 Once you have scrolled down and ticked in the Capture payments checkbox, the screen will expand and this section is displayed.
20 If you have completed the import and need to add more batch entries, you can do so. This process is the same as Creating a batch of payments.

Searching for payments
21  Once you have ticked the Search for payments checkbox, the screen will expand and this section is displayed. The Search for payments option allows you to search for a payment within the imported batch using the beneficiary's name, account number or the amount.

22 The search can be done by entering the beneficiary name or any letter of the alphabet and an asterisk. This will return all beneficiaries corresponding to this criteria. The search can be narrowed by providing a beneficiary account number or part thereof. The search can be further narrowed by entering an amount. The relevant entry can then be located by clicking on the Search button. The entire batch can once again be accessed by clicking on the Display entire batch button.

23 You may sort the table in the List of payments section by any of the column headers: Beneficiary statement description (Cr), My statement description (Dr), Proof of payment flag and Amount. These may all be edited directly in the table.
24 Payments may be selected or deselected by ticking the checkbox in the Select column.  Those payments that are selected will directly affect the Entries total at the bottom left and Total amount at the bottom right as well as the Entries and Batch total in the Batch information area of the screen.
25 Click on the Enable hyperlink in the Notification details column heading to enable the notifications.

26 The screen will be refreshed and now shows two hyperlinks in the Notification details column heading. The Default hyperlink will automatically insert the default notification details for all the beneficiaries as entered when each beneficiary was created. The Clear hyperlink will remove the default details for all the beneficiaries from this column, so that you can enter new details if required.

Please note: Each notification will incur a charge. The Clear hyperlink will default all your notification details to None.
27 When items are added to the list, the system completes a routine check on the banking details submitted. Any invalid items will be displayed on the screen to correct before proceeding.
28 Before submitting the batch, the batch details may be printed by clicking on the Print button, exported by clicking on the Export button, deleted, if selected, by clicking on the Delete selected button and saved for future use by clicking on the Save button.

29 Click on the Submit batch button to submit all selected payments in the List of payments section of the screen.
The rest of the process is the same as when creating a batch of payments. Click here to view the Creating a batch of payments for a single-debit-account flow (start from item 44).