Netcash converter

Estimated reading: 5 minutes 684 views

The Manage converter templates, allow you to create your own template that matches your Excel file and allows for the converter file to upload via the Netcash system.

Our easy to use guide will get you up and running in no time!

Index

Creating converter templates 

A converter template must be created prior to uploading an Excel file. Multiple converter templates may be created for various excel files.

 

Note: Each converter template is matched to a specific Excel file for upload such as either a payments batch or a Debit order batch.

  1. Login to Netcash.

  2. Click on Account Profile.

  3. Issue the service keys required in the Netconnector menu. (Service keys are service specific. Depending on the service required for the converter upload that service key must be generated.)

  4. Select Integration tools > Manage converter templates.

Read more about Service keys
  1. Click the New Template button.
  2. Choose your service and instruction, and click Next. 

 

Example:
Account Service: Salary payments
Instruction: Load dated batch

 

You may have additional Excel files for another service if so a new converter template must be created for that particular service and instruction.

  1. Please take note of all the mandatory data which is required in your Excel spreadsheet > click Next.

  2. Choose your Excel file, give your template a name and select Upload file.

 

Guidelines for compiling Excel spreadsheets:

    • All data in the spreadsheet must be formatted as “text” except amount fields which should be a number with two decimal points.
    • Point only (no comma) to be used as a decimal separator in the amount field.
    • Alpha /numeric characters only-no special characters.
    • Only the data on Sheet 1 of your workbook will be imported.
    • Ensure that there are no formulas in your spreadsheet.
    • Delete blank rows and columns around your data.

  1. Match the mandatory fields to your spreadsheet columns.

 

Mandatory fields are specific to each Netcash service.

Match the Mandatory fields to the relevant field in the drop down menu. The fields in the drop down menus are the headers being utilized in the Excel spreadsheet you are converting. It is important that mandatory fields match your heading fields in the Excel spreadsheet

  1. Click on Save once all the matching is complete.

Submitting files using the converter

  1. Click on Account Profile > Integration Tools > Convert file.

  2. Choose your service, instruction, template and action date.

3. Browse for your file and click on Submit.

4. Click on Upload file.

5. Click on View load report.

6. The upload report is shown.

7. Authorise your Batch

Read more about payments
Read more about Debit Orders

Notes:

  • If no upload report is shown, click on Integration Tools > Batch file upload report to refresh the page.

  • If it still does not appear, please ensure a service key has been generated in Netconnector for the service you are using.

  • If the upload report is unsuccessful, you will be required to fix the errors in the upload report and re-submit the batch using Convert File.

DebiCheck Authentication Converter Codes

Please insert the correct codes in your Excel spreadsheet for the Collection Day column from the table below.

For example: Debit date is the 15th of the month, select the code “MNTH_15”.

Need more assistance?
Contact your Relationship Consultant on 0861 338 338 or email us on support@netcash.co.za
Share this Doc

Netcash converter

Or copy link

CONTENTS