Before you start

Please download the suggested API integration process flow document and use it as a reference when developing.
Kindly adhere to the Netcash brand guidelines when developing.

Programmers Guide

Refer to our Programmers guide for more detail on how to apply the required methodology in this document.
Ensure that the settings for developers are adhered to before you proceed with your implementation.

Web Service Methods

The list of Netcash web service methods can be found here.

Quick Start Guides

Quick Start Guides will help you understand this service and get you started.

Overview

The Netcash Statement is the single point of comprehensive reconciliation for all Netcash transactions. It is available in three (3) formats:

  1. Full Daily Statement – to be used by all integrators.
  2. Bulk Statement – to be used by multi-tenant systems where a central system updates and reconciles all the subtenant systems.
  3. Interim Statement – to be used when non-real-time transaction notification for Bank EFT and CASH payments via the Pay Now service is required.

The Netcash Statement is a tab-delimited text file that must be used for the reconciliation of transactional data processed through the Netcash account.
The Full Daily Statement is available at 08h30 daily for any previous calendar day.

All Netcash transaction types are included in the statement which will allow for a full reconciliation of cash books, debtors and creditors account within the accounting or management system. Access the accounting guide provided for correct transaction posting.

See Netcash Statement Reconciliation parameters and Sage Accounting reconciliation methodology.

Information

The Netcash Integration Web Service is a generic web service that facilitates the automation of uploads and downloads. The web service exposes multiple entry points and methods which are accessed by remote systems to perform specific functions. This specification relates to the downloading of full daily or interim statement files from the Netcash system.

A Netcash Account service key is required for authentication and access to this endpoint.

All transactions processed  will appear itemised on the Netcash Statement.

Technical Information

The Netcash statement file is produced when the web service receives a valid request. The remote system accesses the entry point https://ws.netcash.co.za/NIWS/niws_nif.svc and calls the method ‘RequestMerchantStatement’ or ‘RequestInterimMerchantStatement‘.

The input parameters required are the Account Service Key and the statement date.

Full Daily Statement

RequestMerchantStatement

  • Full daily statements are available on the day following the business day requested.
  • Available daily from 08h30 for the previous calendar day.
  • The remote system may request a statement for any date in the past.
  • The requested date may not be current date or any future date.
  • We recommend that the remote system requests a full daily statement every day and stores the data locally
Object Name Description
Method RequestMerchantStatement

Parameter:

  • ServiceKey (Account service key)
  • FromActionDate
Method RetrieveMerchantStatement

Parameter:

  • ServiceKey (Account service key)
  • PollingId (response received from request)

INPUT

Name Alpha/Numeric Value
ServiceKey AN Netcash Account service key
FromActionDate N CCYYMMDD

Example

 

public string RequestMerchantStatement(string ServiceKey, string FromActionDate)

{
  // initialise client

  NIWS_NIF.NIWS_NIFClient client = new NIWS_NIF.NIWS_NIFClient();

  // call the RequestMerchantStatement method equal to a string variable

  // account service key should be used and date in the past (business day)

  string Request = client.RequestMerchantStatement(ServiceKey, FromActionDate);

  // close client

  client.Close();

  // check request

  switch (Request)

  {
    case "100":  // Authentication failure

      break;

    case "101":  // Date format error.CCYYMMDD

      break;

    case "102":  // Invalid date

      break;

    case "200":  // General code exception

      break;

    default:  // Success, use file token to call RetrieveMerchantStatement

      break;
  }

  return Request;
}

To be used where real-time monitoring of payments is required

Interim Statement

Interim statements should only be used where there is a  need to monitor non-real-time transactions during the day. For example; electricity, airtime -or other services that require a credit being added to the end-user account for non-real-time (ie. cash / bank EFT) transactions. We recommend that you use the Pay Now postback URL’s for live/real-time transaction notification – as settlement values are available on the statement for these transactions the day after the transaction was processed.

Debit Order, non real-tme Pay NowCreditor -and Salary Payments should not be reconciled off the Interim Statement but rather of the Full Daily Statement (RequestMerchantStatement).

RequestInterimMerchantStatement features:

  • This method can be used where there is a need to monitor transactions at regular intervals for operational purposes.
  • The Full Daily Statement should be used for reconciliation and open item allocation.
  • Interim statements are made available every 15 minutes on the current business day.
  • It can only be requested for the current date.
  • Netcash will return any transactions which have been committed to the data warehouse as complete at the time of the request.
  • Additional requests received before the 15-minute timer has elapsed will receive “NO CHANGE” as a response.
  • If no new transactions are available since the previous request, Netcash will return “NO CHANGE” as a response.
  • All Netcash transaction types are included in the statement which will allow for a full reconciliation.
  • See the Accounting guide for suggested transaction posting.
Object Name Description
Method RequestInterimMerchantStatement

Parameter:

  • ServiceKey (Account service key)
Method RetrieveInterimMerchantStatement

Parameter:

  • ServiceKey (Account service key)
  • PollingId (response received from request)

INPUT

 

Name Alpha/Numeric Value
ServiceKey AN Netcash Account service key

Response

 

Successful

The Netcash system will respond to successful requests with a polling id which is used to poll the response queue for the statement file.
Example:  636682464000000000

 

Unsuccessful

Should the request be unsuccessful one of the following codes will be returned

Code Description
100 Authentication failure. Ensure that the service key in the method call is correct
101 Date format error. If the string contains a date it should be in the format CCYYMMDD
102 Invalid date. Full daily statement not available for the requested date.
200 General code exception. Please contact Netcash Technical Support.

Retrieve statement

Postback

If the postback option has been selected and a postback URL has been configured in the Netcash Connected service module, no polling is required. The statement will be posted to the URL as a tab delimited file. No additional web service call is required.

Note: The polling id will still be returned to the remote system even if the postback option is configured. The remote system can still call the RetrieveMerchantStatement method as a Fallback option.

Polling

  • Where no postback option has been configured, the remote system will need to call the RetrieveMerchantStatement method to fetch the statement:
  • The remote system collects the statement file using the polling id issued by the system.
  • The remote system accesses the entry point https://ws.netcash.co.za/NIWS/niws_nif.svc and calls the method RetrieveMerchantStatement for both interim and full daily statements.
  • The parameters required are the Account service key and the polling id which was returned by the Netcash system.
Name Alpha/Numeric Value
ServiceKey AN Netcash Account service key
PollingId AN The ID returned by the Netcash system

Example

 

public string RetrieveMerchantStatement(string ServiceKey, string PollingId)

{
  // initialise client

  NIWS_NIF.NIWS_NIFClient client = new NIWS_NIF.NIWS_NIFClient();

  // call the RetrieveMerchantStatement method equal to a string variable

  // use the same service key

  string Request = client.RetrieveMerchantStatement(ServiceKey, PollingId);

  // close client after response is received

  client.Close();

  // check request

  switch (Request)

  {
    case "100":  // Authentication failure

      break;

    case "200":  // General code exception

      break;

    case "FILE NOT READY":  // The requested statement has not yet been created.
                            // Retry later

      break;

    case "NO CHANGE":  // No new transactions are available for download

      break;

    default:  // Success

      break;
  }

  // use response to output to UI

  // service will respond with the result of the file upload

  return Request;
}

 

Output

  • Netcash will respond with the requested statement data as a tab delimited string with newline constant at the end of each line.
  • Both Daily and Interim statement files will be terminated with the closing balance (CBL) as the final record in the file.

Transaction Types

NOTE:RetrieveTransactionTypes” method will display the transaction types/codes with the suggested associated ledger accounts. These ledger account details are NOT included in the Full Daily or Interim statement downloads from the web service.

Call “RequestTransactionTypes” and “RetrieveTransactionTypes” methods for a full statement with all transaction types as indicated below

Object Name Description
Method RequestTransactionTypes

Parameter:

  • ServiceKey (Account service key)
Method RetrieveTransactionTypes

Parameter:

  • ServiceKey (Account service key)
  • PollingId (response received from request)

INPUT

Name Alpha/Numeric Value
ServiceKey AN Netcash Account service key

The web service extract returns a single string without any line breaks

<string>2023-11-08 OBL 0 Opening Balance 0.00 + 0 2023-11-08 TDD 1 Two day debit order 0.00 + 0 Debtors/Sales 2023-11-08 TDC 2 Two day credit card debit order 0.00 + 0 Debtors/Sales 2023-11-08 DRU 4 Debit order unpaid 0.00 + 0 Debtors/Sales 2023-11-08 SDD 5 Same day debit order 0.00 + 0 Debtors/Sales 2023-11-08 SDC 6 Same day credit card debit order 0.00 + 0 Debtors/Sales 2023-11-08 DCS 7 DebiCheck successful 0.00 + 0 Debtors/Sales 2023-11-08 DCX 8 DebiCheck unsuccessful 0.00 + 0 Debtors/Sales 2023-11-08 DCT 9 DebiCheck tracking 0.00 + 0 Debtors/Sales 2023-11-08 DCD 10 DebiCheck disputed 0.00 + 0 Debtors/Sales 2023-11-08 CRP 11 Same day creditor payment 0.00 + 0 Creditors 2023-11-08 CRU 12 Creditor payment return 0.00 + 0 Creditors 2023-11-08 DTT 13 Deposit received 0.00 + 0 Business Bank Account 2023-11-08 CDR 14 Risk reports 0.00 + 0 NO GL EFFECT 2023-11-08 SAL 15 Same day salary payment 0.00 + 0 Salaries 2023-11-08 NSF 18 Service fee 0.00 + 0 Netcash Service Fees 2023-11-08 BTR 19 Bank transfer to client 0.00 + 0 Business Bank Account 2023-11-08 INP 20 Interest paid to Netcash 0.00 + 0 Interest Paid 2023-11-08 IAT 21 Netcash inter-account transfer 0.00 + 0 Netcash Bank Account 2023-11-08 AVS 22 AVS 0.00 + 0 NO GL EFFECT 2023-11-08 SRU 23 Salary payment return 0.00 + 0 Salaries 2023-11-08 SAD 24 Dated salary payment 0.00 + 0 Salaries 2023-11-08 DCP 25 Dated creditor payment 0.00 + 0 Creditors 2023-11-08 IST 26 Inter-system transfer 0.00 + 0 Account (Cash Book) 2023-11-08 BTU 27 Bank transfer return 0.00 + 0 Business Bank Account 2023-11-08 ABR 28 Account balance recovery 0.00 + 0 Business Bank Account 2023-11-08 CSP 29 Cashnet cash payment 0.00 + 0 Creditors 2023-11-08 ABU 30 Account balance recovery return 0.00 + 0 Business Bank Account 2023-11-08 INR 31 Interest paid to merchant 0.00 + 0 Interest Received 2023-11-08 VAT 32 Output value added tax 0.00 + 0 Input VAT 2023-11-08 PNC 33 Credit card payment 0.00 + 0 Debtors/Sales 2023-11-08 PNU 34 Credit card declined 0.00 + 0 Debtors/Sales 2023-11-08 PND 35 Credit card dispute 0.00 + 0 Debtors/Sales 2023-11-08 PNR 36 Credit card refund 0.00 + 0 Debtors/Sales 2023-11-08 DTR 42 Deposit return 0.00 + 0 Business Bank Account 2023-11-08 PNP 43 Retail payment 0.00 + 0 Debtors/Sales 2023-11-08 PNM 44 Scan to Pay payment 0.00 + 0 Debtors/Sales 2023-11-08 PNE 45 EFT payment 0.00 + 0 Debtors/Sales 2023-11-08 PNQ 46 Retail payment return 0.00 + 0 Debtors/Sales 2023-11-08 PNW 47 Scan to Pay declined 0.00 + 0 Debtors/Sales 2023-11-08 PNZ 48 EFT payment return 0.00 + 0 Debtors/Sales 2023-11-08 IPR 50 Interest paid to Netcash reversal 0.00 + 0 Interest Paid 2023-11-08 IRR 51 Interest paid to merchants reversal 0.00 + 0 Interest Received 2023-11-08 PNA 52 Card authorisation 0.00 + 0 Debtors/Sales 2023-11-08 REB 53 Rebate 0.00 + 0 Debtors/Sales 2023-11-08 PIA 54 Ozow Auth 0.00 + 0 Debtors/Sales 2023-11-08 PIS 55 Ozow Success 0.00 + 0 Debtors/Sales 2023-11-08 PIF 56 Ozow Failure 0.00 + 0 Debtors/Sales 2023-11-08 DCU 57 Debit Order Credit Card Unpaid 0.00 + 0 Debtors/Sales 2023-11-08 DCM 58 Debicheck mandate request 0.00 + 0 Debtors/Sales 2023-11-08 BAR 61 Bank Account Redirect 0.00 + 0 NO GL EFFECT 2023-11-08 AVB 62 Account Verification Bulk 0.00 + 0 NO GL EFFECT 2023-11-08 PVC 63 Visa Click to Pay payment 0.00 + 0 Debtors/Sales 2023-11-08 PVU 64 Visa Click to Pay decline 0.00 + 0 Debtors/Sales 2023-11-08 PVR 65 Visa Click to Pay refund 0.00 + 0 Debtors/Sales 2023-11-08 PVD 66 Visa Click to Pay dispute 0.00 + 0 Debtors/Sales 2023-11-08 PIR 67 Ozow Recall 0.00 + 0 Debtors/Sales 2023-11-08 PQR 68 MasterPass QR 0.00 + 0 Debtors/Sales 2023-11-08 ELM 69 Electronic Mandate 0.00 + 0 NO GL EFFECT 2023-11-08 PCD 70 Client Deposit 0.00 + 0 Business Bank Account 2023-11-08 TDD 74 Two day invalid debit order 0.00 + 0 Debtors/Sales 2023-11-08 SDD 75 Same day invalid debit order 0.00 + 0 Debtors/Sales 2023-11-08 DRU 76 Rejected debit order 0.00 + 0 Debtors/Sales 2023-11-08 CNC 77 Cashnet Control 0.00 + 0 Debtors/Sales 2023-11-08 PNX 78 Scan to Pay refund 0.00 + 0 Debtors/Sales 2023-11-08 DCM 85 DebiCheck Mandate 0.00 + 0 Debtors/Sales 2023-11-08 DPS 86 Debicheck pre submission 0.00 + 0 Debtors/Sales 2023-11-08 DPS 87 Debicheck invalid pre submission 0.00 + 0 Debtors/Sales 2023-11-08 DCX 88 Debicheck rejected submission 0.00 + 0 Debtors/Sales 2023-11-08 ALT 89 Fund transfer 0.00 + 0 Fund transfer to the account 2023-11-08 PMA 90 Mobicred Auth 0.00 + 0 Debtors/Sales 2023-11-08 PMC 91 Mobicred success 0.00 + 0 Debtors/Sales 2023-11-08 PMD 92 Mobicred decline 0.00 + 0 Debtors/Sales 2023-11-08 PMR 93 Mobicred refund 0.00 + 0 Debtors/Sales 2023-11-08 ART 94 Retail Capital Transfer 0.00 + 0 Fund transfer from the account 2023-11-08 ARF 95 Retail Capital Transfer Failed 0.00 + 0 Fund transfer from the account failed 2023-11-08 DRC 96 Debit order card refund 0.00 + 0 Debtors/Sales 2023-11-08 NCA 97 Adjustment 0.00 + 0 Debtors/Sales 2023-11-08 CRT 98 Real time creditor payment 0.00 + 0 Creditors 2023-11-08 SRT 99 Real time salary payment 0.00 + 0 Salaries 2023-11-08 BRT 100 Real time transfer to client 0.00 + 0 Business Bank Account 2023-11-08 PFA 101 Payflex Auth 0.00 + 0 Debtors/Sales 2023-11-08 PFC 102 Payflex success 0.00 + 0 Debtors/Sales 2023-11-08 PFD 103 Payflex decline 0.00 + 0 Debtors/Sales 2023-11-08 PFR 104 Payflex refund 0.00 + 0 Debtors/Sales 2023-11-08 CBL 0 Closing Balance 0.00 + 0</String>

The data should be interpreted as follows:

Date|Transaction Code|Internal DB ID|Description|Amount|Effect|Internal Indicator|Ledger Account Affected
2023-11-08 OBL 0 Opening Balance 0.00 + 0 
2023-11-08 TDD 1 Two day debit order 0.00 + 0 Debtors/Sales
2023-11-08 TDC 2 Two day credit card debit order 0.00 + 0 Debtors/Sales
2023-11-08 DRU 4 Debit order unpaid 0.00 + 0 Debtors/Sales
2023-11-08 SDD 5 Same day debit order 0.00 + 0 Debtors/Sales
2023-11-08 SDC 6 Same day credit card debit order 0.00 + 0 Debtors/Sales
2023-11-08 DCS 7 DebiCheck successful 0.00 + 0 Debtors/Sales
2023-11-08 DCX 8 DebiCheck unsuccessful 0.00 + 0 Debtors/Sales
2023-11-08 DCT 9 DebiCheck tracking 0.00 + 0 Debtors/Sales
2023-11-08 DCD 10 DebiCheck disputed 0.00 + 0 Debtors/Sales
2023-11-08 CRP 11 Same day creditor payment 0.00 + 0 Creditors
2023-11-08 CRU 12 Creditor payment return 0.00 + 0 Creditors
2023-11-08 DTT 13 Deposit received 0.00 + 0 Business Bank Account
2023-11-08 CDR 14 Risk reports 0.00 + 0 NO GL EFFECT
2023-11-08 SAL 15 Same day salary payment 0.00 + 0 Salaries
2023-11-08 NSF 18 Service fee 0.00 + 0 Netcash Service Fees
2023-11-08 BTR 19 Bank transfer to client 0.00 + 0 Business Bank Account
2023-11-08 INP 20 Interest paid to Netcash 0.00 + 0 Interest Paid
2023-11-08 IAT 21 Netcash inter-account transfer 0.00 + 0 Netcash Bank Account
2023-11-08 AVS 22 AVS 0.00 + 0 NO GL EFFECT
2023-11-08 SRU 23 Salary payment return 0.00 + 0 Salaries
2023-11-08 SAD 24 Dated salary payment 0.00 + 0 Salaries
2023-11-08 DCP 25 Dated creditor payment 0.00 + 0 Creditors
2023-11-08 IST 26 Inter-system transfer 0.00 + 0 Account (Cash Book)
2023-11-08 BTU 27 Bank transfer return 0.00 + 0 Business Bank Account
2023-11-08 ABR 28 Account balance recovery 0.00 + 0 Business Bank Account
2023-11-08 CSP 29 Cashnet cash payment 0.00 + 0 Creditors
2023-11-08 ABU 30 Account balance recovery return 0.00 + 0 Business Bank Account
2023-11-08 INR 31 Interest paid to merchant 0.00 + 0 Interest Received
2023-11-08 VAT 32 Output value added tax 0.00 + 0 Input VAT
2023-11-08 PNC 33 Credit card payment 0.00 + 0 Debtors/Sales
2023-11-08 PNU 34 Credit card declined 0.00 + 0 Debtors/Sales
2023-11-08 PND 35 Credit card dispute 0.00 + 0 Debtors/Sales
2023-11-08 PNR 36 Credit card refund 0.00 + 0 Debtors/Sales
2023-11-08 DTR 42 Deposit return 0.00 + 0 Business Bank Account
2023-11-08 PNP 43 Retail payment 0.00 + 0 Debtors/Sales
2023-11-08 PNM 44 Scan to Pay payment 0.00 + 0 Debtors/Sales
2023-11-08 PNE 45 EFT payment 0.00 + 0 Debtors/Sales
2023-11-08 PNQ 46 Retail payment return 0.00 + 0 Debtors/Sales
2023-11-08 PNW 47 Scan to Pay declined 0.00 + 0 Debtors/Sales
2023-11-08 PNZ 48 EFT payment return 0.00 + 0 Debtors/Sales
2023-11-08 IPR 50 Interest paid to Netcash reversal 0.00 + 0 Interest Paid
2023-11-08 IRR 51 Interest paid to merchants reversal 0.00 + 0 Interest Received
2023-11-08 PNA 52 Card authorisation 0.00 + 0 Debtors/Sales
2023-11-08 REB 53 Rebate 0.00 + 0 Debtors/Sales
2023-11-08 PIA 54 Ozow Auth 0.00 + 0 Debtors/Sales
2023-11-08 PIS 55 Ozow Success 0.00 + 0 Debtors/Sales
2023-11-08 PIF 56 Ozow Failure 0.00 + 0 Debtors/Sales
2023-11-08 DCU 57 Debit Order Credit Card Unpaid 0.00 + 0 Debtors/Sales
2023-11-08 DCM 58 Debicheck mandate request 0.00 + 0 Debtors/Sales
2023-11-08 BAR 61 Bank Account Redirect 0.00 + 0 NO GL EFFECT
2023-11-08 AVB 62 Account Verification Bulk 0.00 + 0 NO GL EFFECT
2023-11-08 PVC 63 Visa Click to Pay payment 0.00 + 0 Debtors/Sales
2023-11-08 PVU 64 Visa Click to Pay decline 0.00 + 0 Debtors/Sales
2023-11-08 PVR 65 Visa Click to Pay refund 0.00 + 0 Debtors/Sales
2023-11-08 PVD 66 Visa Click to Pay dispute 0.00 + 0 Debtors/Sales
2023-11-08 PIR 67 Ozow Recall 0.00 + 0 Debtors/Sales
2023-11-08 PQR 68 MasterPass QR 0.00 + 0 Debtors/Sales
2023-11-08 ELM 69 Electronic Mandate 0.00 + 0 NO GL EFFECT
2023-11-08 PCD 70 Client Deposit 0.00 + 0 Business Bank Account
2023-11-08 TDD 74 Two day invalid debit order 0.00 + 0 Debtors/Sales
2023-11-08 SDD 75 Same day invalid debit order 0.00 + 0 Debtors/Sales
2023-11-08 DRU 76 Rejected debit order 0.00 + 0 Debtors/Sales
2023-11-08 CNC 77 Cashnet Control 0.00 + 0 Debtors/Sales
2023-11-08 PNX 78 Scan to Pay refund 0.00 + 0 Debtors/Sales
2023-11-08 DCM 85 DebiCheck Mandate 0.00 + 0 Debtors/Sales
2023-11-08 DPS 86 Debicheck pre submission 0.00 + 0 Debtors/Sales
2023-11-08 DPS 87 Debicheck invalid pre submission 0.00 + 0 Debtors/Sales
2023-11-08 DCX 88 Debicheck rejected submission 0.00 + 0 Debtors/Sales
2023-11-08 ALT 89 Fund transfer 0.00 + 0 Fund transfer to the account
2023-11-08 PMA 90 Mobicred Auth 0.00 + 0 Debtors/Sales
2023-11-08 PMC 91 Mobicred success 0.00 + 0 Debtors/Sales
2023-11-08 PMD 92 Mobicred decline 0.00 + 0 Debtors/Sales
2023-11-08 PMR 93 Mobicred refund 0.00 + 0 Debtors/Sales
2023-11-08 ART 94 Retail Capital Transfer 0.00 + 0 Fund transfer from the account
2023-11-08 ARF 95 Retail Capital Transfer Failed 0.00 + 0 Fund transfer from the account failed
2023-11-08 DRC 96 Debit order card refund 0.00 + 0 Debtors/Sales
2023-11-08 NCA 97 Adjustment 0.00 + 0 Debtors/Sales
2023-11-08 CRT 98 Real time creditor payment 0.00 + 0 Creditors
2023-11-08 SRT 99 Real time salary payment 0.00 + 0 Salaries
2023-11-08 BRT 100 Real time transfer to client 0.00 + 0 Business Bank Account
2023-11-08 PFA 101 Payflex Auth 0.00 + 0 Debtors/Sales
2023-11-08 PFC 102 Payflex success 0.00 + 0 Debtors/Sales
2023-11-08 PFD 103 Payflex decline 0.00 + 0 Debtors/Sales
2023-11-08 PFR 104 Payflex refund 0.00 + 0 Debtors/Sales
2023-11-08 CBL 0 Closing Balance 0.00 + 0

Example

Output indicating an unpaid transaction

<RetrieveMerchantStatement>
    <MethodParameters>
        <String>
           2023-11-08 OBL 0 Opening Balance -115.8000 + 0
           2023-11-08 CRU 1706180 Creditor Payment Return -Code:26 1.0000 - 0
           2023-11-08 CBL 0 Closing Balance -114.8000 + 0
        </String>
    </MethodParameters>
</RetrieveMerchantStatement>

Unsuccessful

In the event that the request was unsuccessful one of the following codes will be returned

Code Description
100 Authentication failure. Service key incorrect
200 General code exception. Please contact Netcash Technical Support.
“FILE NOT READY” The requested statement has not yet been created. Retry later.
“NO CHANGE” No new transactions are available for download

Statement file format

The data is returned in a tab-delimited text file

Structure

 

Field Name Type Value
1 Transaction date AN CCYYMMDD
2 Transaction type A See Table 1
3 Transaction ID N Unique Netcash reference
4 Description AN Short description of the transaction
5 Amount N Transaction amount in rands
6 Symbol AN Positive/Negative
7 VAT N VAT amount
8 Extra 1 AN User-defined data received in upload file – i.e. invoice number
9 Extra 2 AN User-defined data received in upload file – i.e. order number
10 Extra 3 AN User-defined data received in upload file – i.e. client code

The following field is only returned when calling the RetrieveTransactionTypes method

11 Accounting ledger description AN General Ledger description for mapping and import into external accounting system

Field explanations

 

Field Explanation
Transaction date For daily statements the date must be in the past.
For interim statements the date must be the current date.
Transaction type The 3 character transaction type. See Table 1
Transaction ID The unique transaction ID assigned by Netcash
Description Transaction description
Amount The amount is returned as a numeric value with 4 decimal places and no sign
Symbol Indicates whether this has a positive or negative effect on the account balance
VAT The VAT on the transaction if applicable
Extra 1 2 & 3 The input file allows a user to include up to three additional free text fields. These fields are returned in the statement download.
The Extra fields can be used to identify or post transactions in the remote system.
You may use any identifying details for example an invoice or customer number

The following field is only returned when calling the RetrieveTransactionTypes method

Accounting ledger description General Ledger description for mapping and import into external accounting system

Netcash statement integration

Suggested Reconciliation

Initial Mapping setup

Netcash will provide a blank statement template for initial mapping setup of the host system.
This template will have R0.00 values in the amount field.
For the mapping import, the following fields should be displayed in the host system:

  • Host system “Statement reference” = Netcash “Ledger Account” column
  • by accounting systems, as far as possible, and is used for ease of reference for the end user to apply mapping per their ‘Chart of Accounts’.

When the mapping is applied to the Netcash template, the mapping should be linked to the “Transaction Type” field, which will always appear on every statement import from Netcash. This mapping will be in the background, and probably not display to the User.

Actual Statement importing

When a Netcash statement imports (after the mapping was concluded), the following rules should be considered

  • Host system date field = Netcash date field
  • Host system Statement Description = Netcash “Description”.
  • Mapping Type Field = Determine whether there is an entry in the Extra 1 field.
  • No entry = then entry type is “General”
  • Entry = Determine whether it is a supplier or customer transaction and allocate as applicable
  • Mapping Account field = If the Extra 1 field is blank, apply the default mapping used when doing the initial mapping using the mapping template. If there is data in Extra 1, Apply data in Extra 1 to the Mapping Field in the host system eg. GSO001 appears in the Extra 1 field, input GSO001 into the mapping field.
  • Amount field = Consolidate the symbol field and amount field and apply the value to the host system amount field (if the symbol is a + then the amount will be positive; if the symbol is – then the amount is negative).
  • The GL Description field = Netcash “Transaction Description”.

The tables below will indicate which suggested ledger account should be affected. The contra account will always be the Netcash ‘bank account’.

Statement transaction types

Table 1


NOTE:
Ledger account details are NOT included in the Full Daily or Interim statement downloads from the merchant account via web service. See suggested ledger account mapping

Example Statement

2023-11-08    OBL    0    Opening Balance    0.00    +    0
2023-11-08    TDD    1    Two day debit order    0.00    +    0
2023-11-08    TDC    2    Two day credit card debit order    0.00    +    0
2023-11-08    DRU    4    Debit order unpaid    0.00    +    0
2023-11-08    SDD    5    Same day debit order    0.00    +    0
2023-11-08    SDC    6    Same day credit card debit order    0.00    +    0
2023-11-08    DCS    7    DebiCheck successful    0.00    +    0
2023-11-08    DCX    8    DebiCheck unsuccessful    0.00    +    0
2023-11-08    DCT    9    DebiCheck tracking    0.00    +    0
2023-11-08    DCD    10    DebiCheck disputed    0.00    +    0
2023-11-08    CRP    11    Same day creditor payment    0.00    +    0
2023-11-08    CRU    12    Creditor payment return    0.00    +    0
2023-11-08    DTT    13    Deposit received    0.00    +    0
2023-11-08    CDR    14    Risk reports    0.00    +    0
2023-11-08    SAL    15    Same day salary payment    0.00    +    0
2023-11-08    NSF    18    Service fee    0.00    +    0
2023-11-08    BTR    19    Bank transfer to client    0.00    +    0
2023-11-08    INP    20    Interest paid to Netcash    0.00    +    0
2023-11-08    IAT    21    Netcash inter-account transfer    0.00    +    0
2023-11-08    AVS    22    AVS    0.00    +    0
2023-11-08    SRU    23    Salary payment return    0.00    +    0
2023-11-08    SAD    24    Dated salary payment    0.00    +    0
2023-11-08    DCP    25    Dated creditor payment    0.00    +    0
2023-11-08    IST    26    Inter-system transfer    0.00    +    0
2023-11-08    BTU    27    Bank transfer return    0.00    +    0
2023-11-08    ABR    28    Account balance recovery    0.00    +    0
2023-11-08    CSP    29    Cashnet cash payment    0.00    +    0
2023-11-08    ABU    30    Account balance recovery return    0.00    +    0
2023-11-08    INR    31    Interest paid to merchant    0.00    +    0
2023-11-08    VAT    32    Output value added tax    0.00    +    0
2023-11-08    PNC    33    Credit card payment    0.00    +    0
2023-11-08    PNU    34    Credit card declined    0.00    +    0
2023-11-08    PND    35    Credit card dispute    0.00    +    0
2023-11-08    PNR    36    Credit card refund    0.00    +    0
2023-11-08    DTR    42    Deposit return    0.00    +    0
2023-11-08    PNP    43    Retail payment    0.00    +    0
2023-11-08    PNM    44    Scan to Pay payment    0.00    +    0
2023-11-08    PNE    45    EFT payment    0.00    +    0
2023-11-08    PNQ    46    Retail payment return    0.00    +    0
2023-11-08    PNW    47    Scan to Pay declined    0.00    +    0
2023-11-08    PNZ    48    EFT payment return    0.00    +    0
2023-11-08    IPR    50    Interest paid to Netcash reversal    0.00    +    0
2023-11-08    IRR    51    Interest paid to merchants reversal    0.00    +    0
2023-11-08    PNA    52    Card authorisation    0.00    +    0
2023-11-08    REB    53    Rebate    0.00    +    0
2023-11-08    PIA    54    Ozow Auth    0.00    +    0
2023-11-08    PIS    55    Ozow Success    0.00    +    0
2023-11-08    PIF    56    Ozow Failure    0.00    +    0
2023-11-08    DCU    57    Debit Order Credit Card Unpaid    0.00    +    0
2023-11-08    DCM    58    Debicheck mandate request    0.00    +    0
2023-11-08    BAR    61    Bank Account Redirect    0.00    +    0
2023-11-08    AVB    62    Account Verification Bulk    0.00    +    0
2023-11-08    PVC    63    Visa Click to Pay payment    0.00    +    0
2023-11-08    PVU    64    Visa Click to Pay decline    0.00    +    0
2023-11-08    PVR    65    Visa Click to Pay refund    0.00    +    0
2023-11-08    PVD    66    Visa Click to Pay dispute    0.00    +    0
2023-11-08    PIR    67    Ozow Recall    0.00    +    0
2023-11-08    PQR    68    MasterPass QR    0.00    +    0
2023-11-08    ELM    69    Electronic Mandate    0.00    +    0
2023-11-08    PCD    70    Client Deposit    0.00    +    0
2023-11-08    TDD    74    Two day invalid debit order    0.00    +    0
2023-11-08    SDD    75    Same day invalid debit order    0.00    +    0
2023-11-08    DRU    76    Rejected debit order    0.00    +    0
2023-11-08    CNC    77    Cashnet Control    0.00    +    0
2023-11-08    PNX    78    Scan to Pay refund    0.00    +    0
2023-11-08    DCM    85    DebiCheck Mandate    0.00    +    0
2023-11-08    DPS    86    Debicheck pre submission    0.00    +    0
2023-11-08    DPS    87    Debicheck invalid pre submission    0.00    +    0
2023-11-08    DCX    88    Debicheck rejected submission    0.00    +    0
2023-11-08    ALT    89    Fund transfer    0.00    +    0
2023-11-08    PMA    90    Mobicred Auth    0.00    +    0
2023-11-08    PMC    91    Mobicred success    0.00    +    0
2023-11-08    PMD    92    Mobicred decline    0.00    +    0
2023-11-08    PMR    93    Mobicred refund    0.00    +    0
2023-11-08    ART    94    Retail Capital Transfer    0.00    +    0
2023-11-08    ARF    95    Retail Capital Transfer Failed    0.00    +    0
2023-11-08    DRC    96    Debit order card refund    0.00    +    0
2023-11-08    NCA    97    Adjustment    0.00    +    0
2023-11-08    CRT    98    Real time creditor payment    0.00    +    0
2023-11-08    SRT    99    Real time salary payment    0.00    +    0
2023-11-08    BRT    100    Real time transfer to client    0.00    +    0
2023-11-08    PFA    101    Payflex Auth    0.00    +    0
2023-11-08    PFC    102    Payflex success    0.00    +    0
2023-11-08    PFD    103    Payflex decline    0.00    +    0
2023-11-08    PFR    104    Payflex refund    0.00    +    0
2023-11-08    CBL    0      Closing Balance    0.00    +    0


Click here for a list -and explanation of unpaid transaction codes.

Transaction code Transaction description
OBL Opening balance
CBL Closing balance
DTT Deposit Received
DTR Deposit Return
NSF Service fee
BTR Bank transfer to client
BTU Bank transfer return
INP Interest paid to Netcash
INR Interest received
ABR Account balance recovery
ABU Account balance recovery return
VAT Value added tax
IAT Inter-account transfer
IST Inter-system transfer
BDW Bad Debt Write-Off
IPR Interest paid to Netcash reversal
IRR Interest paid to Merchants reversal
REB Rebate
BAR Bank Account Redirect
ELM Electronic Mandate
USI Unallocated Statement Transaction In
USO Unallocated Statement Transaction Out
INS Interest swept
Transaction code Transaction description Ledger Account
TDD 2 Day debit order Debtors
TDC 2 Day credit card Debtors
DRU Debit unpaid Debtors
SDD Same day debit order Debtors
SDC Same day credit card Debtors
DCU Debit order credit card unpaid Debtors
DRC Debit order credit card refund Debtors
DCM Debicheck mandate request Debtors
DCS Debicheck successful transaction Debtors
DCX Debicheck unsuccessful transaction Debtors
DCT Debicheck tracking transaction Debtors
DCD Debicheck disputed transaction Debtors
DPS Debicheck pre-submission No effect
TOP

Click here for a complete list of unpaid transaction codes

Transaction code Transaction description Ledger Account
SAL Same day salary payment Salaries
SRU Salary payment return Salaries
SAD Dated salary payment Salaries
TOP
Transaction code Transaction description
CRP Same day creditor payment
CRU Creditor payment return
DCP Dated creditor payment
Transaction code Transaction description
CDR Risk Reports report
AVS Account Verification Single
AVB Account Verification Bulk
Transaction code Transaction description Ledger Account
PNP Retail payment Debtors/Sales
PNQ Retail payment return Debtors/Sales
PNM Scan to Pay payment Debtors/Sales
PNW Scan to Pay declined Debtors/Sales
PNE EFT payment Debtors/Sales
PNZ EFT return Debtors/Sales
PNA Credit Card authorize Debtors/Sales
PNC Credit Card payment Debtors/Sales
PNU Credit Card declined Debtors/Sales
PND Credit Card dispute Debtors/Sales
PNR Credit Card refund Debtors/Sales
PIA Ozow Auth Debtors/Sales
PIS Ozow Success Debtors/Sales
PIF Ozow Failure Debtors/Sales
PIR Ozow Recall Debtors/Sales
PVC Visa Click to Pay Payment Debtors/Sales
PVU Visa Click to Pay Decline Debtors/Sales
PVR Visa Click to Pay Refund Debtors/Sales
PVD Visa Click to Pay Dispute Debtors/Sales
PQR Masterpass QR Debtors/Sales
PCD Client Deposit Debtors/Sales
TOP

Click here for a complete list of Credit Card unpaid transaction codes

Accounting entry guidelines

The following are guidelines to use when determining how to generate accounting entries when importing the Statement from your Netcash account.

Reconciliation tips

It is highly advisable to:

  1. Schedule a download -and reconcile your Netcash statement daily at 08h30 as settlements to Netcash accounts will be processed by this time.
  2. When receiving electronic funds transfer (EFT) to your Netcash account from your customer ensure that;
    1. The correct EFT payment reference is used
      1. Incorrectly referenced payments will still appear on your Netcash statement but will not be auto-allocated to the debtor
      2. You will have to manually allocate the transaction.
    2. Each Netcash account has a dedicated Mercantile bank account linked thus payments with the incorrect reference will still appear in the account.
    3. Avoid cash deposits as additional fees will be levied.

 

Suggested business rules for processing debit orders

  1. For debit order transactions;
    1. You may  resubmit a failed payment (DRU)  with the following provisors :
      1. The debit order mandate allows you to resubmit the transaction for payment.
      2. The  transaction has not returned more than twice consecutively on code 02

 

Where a transaction is continually unpaid it is best practice to obtain a new mandate irrespective of the reason.

Transaction Types and Associated General Ledger Transactions

There are six services for which transactions can appear on your Netcash account. These transactions are listed above, with a brief description to each, and the general ledger ‘double entry’ associated with each transaction.
NOTE: The ledger field description is only returned when calling the  RetrieveTransactionTypes method

Accounting entries

The possible accounting entries that can be generated from these transaction types, together with a recommended GL Account is detailed below.  It is key to set up your Netcash account as a “Bank Account” to be reconciled as you would any bank account.

A detailed Netcash Statement is also available on the Netcash web account for reconciliation purposes.

General Ledger Account list

A recommended chart of accounts to use for Netcash transaction is as follows:

  • Netcash Bank Account. Set up this Netcash Account in the cashbook and treat it as a ‘bank account’ as it is in effect a ‘Cash’ account. This will enable transacting against your Accounts Receivable and Accounts Payable sub-ledgers.
  • Accounts receivable. Setup a sub-ledger for each of your client/s.
  • Income account to reflect the income for which you receive.
  • Bank account which is your bank account registered on your Netcash profile.
  • Fees account for service fees charged by Netcash.
  • Accounts payable sub-ledger for your creditors.
  • Salaries account for when you pay salaries via Netcash.

Netcash brand guidelines

Please refer to the Netcash brand guidelines here when using any logos, images, icons, labels, descriptions, and references to Netcash in your software.

Testing

See Testing section for more details. If you require any integration assistance contact our technical support team

Netcash may provide example/sample/demo ‘code snippets’ and/or external links in this Technical Document. Such are for guidance purposes only and may not function on every developer’s system/s. Netcash disclaims any and all liability for the usage of guidance resources provided -and you as the Developer; must accept full responsibility for the usage of such. While every possible effort has been taken to ensure compatibility across multiple system configurations, the contents of this document cannot be guaranteed to work on all systems, with all operating systems -and/or with all system configuration/s.