Manage converter templates

Estimated reading: 4 minutes 1074 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.

 

  • Login to Netcash.
  • Click on Account Profile.
  • Issue the service keys required in the Netconnector menu.
  • Select Integration tools > Manage converter templates.
  • Click the New Template button.
  • Choose your service and instruction, and click Next.
  • Please take note of all the mandatory data which is required in your Excel spreadsheet > click Next.
  • Choose your Excel file, give your template a name and select Upload file.

Note:

  • Additional tips for editing your Excel sheet:
  • Your Excel file must not contain any formulas.
  • Ensure your columns have been formatted correctly.
  • Delete blank rows and columns around your data.
  • Do not use a comma as a decimal separator in the amount field.
  • Match the mandatory fields to your spreadsheet columns.
  • When done > click on Save.

Note: The drop-down list contains the headers you have in your Excel spreadsheet.

  • Click on Save once all the matching is complete.

Creating converter templates and submitting files for processing

  1. Login to Netcash.
  2. Click on Account Profile.
  3. Issue the service keys required in the Netconnector menu.
  4. Select Integration tools > Manage converter templates.
  5. Click the New Template button.
  6. Choose your service and instruction, and click Next.
  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.

Note:

  • Additional tips for editing your Excel sheet:
  • Your Excel file must not contain any formulas.
  • Ensure your columns have been formatted correctly.
  • Delete blank rows and columns around your data.
  • Do not use a comma as a decimal separator in the amount field.
  1. Match the mandatory fields to your spreadsheet columns.
  2. When done > click on Save.

Note: The drop-down list contains the headers you have in your Excel spreadsheet.

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

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”.

MNTH_01Monthly 1
MNTH_02Monthly 2
MNTH_03Monthly 3
MNTH_04Monthly 4
MNTH_05Monthly 5
MNTH_06Monthly 6
MNTH_07Monthly 7
MNTH_08Monthly 8
MNTH_09Monthly 9
MNTH_10Monthly 10
MNTH_11Monthly 11
MNTH_12Monthly 12
MNTH_13Monthly 13
MNTH_14Monthly 14
MNTH_15Monthly 15
MNTH_16Monthly 16
MNTH_17Monthly 17
MNTH_18Monthly 18
MNTH_19Monthly 19
MNTH_20Monthly 20
MNTH_21Monthly 21
MNTH_22Monthly 22
MNTH_23Monthly 23
MNTH_24Monthly 24
MNTH_25Monthly 25
MNTH_26Monthly 26
MNTH_27Monthly 27
MNTH_28Monthly 28
MNTH_29Monthly 29
MNTH_30Monthly 30
MNTH_31Monthly 31
Need more assistance?
Contact your Relationship Consultant on 0861 338 338 or email us on support@netcash.co.za