Statement – Netcash Developers Documentation

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:

Full Daily Statement – to be used by all integrators.
Bulk Statement – to be used by multi-tenant systems where a central system updates and reconciles all the subtenant systems.
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;
}

Interim Statement

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 Now, Creditor -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

RetrieveMerchantStatement

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 ^{*This is only an example}

<string>2025-04-24 OBL 0 Opening Balance 0.00 + 0 2025-04-24 TDD 1 Two day debit order 0.00 - 0 Debtors/Sales 2025-04-24 TDC 2 Two day credit card debit order 0.00 - 0 Debtors/Sales 2025-04-24 DRU 4 Debit order unpaid 0.00 - 0 Debtors/Sales 2025-04-24 SDD 5 Same day debit order 0.00 - 0 Debtors/Sales 2025-04-24 SDC 6 Same day credit card debit order 0.00 - 0 Debtors/Sales 2025-04-24 DCS 7 DebiCheck successful 0.00 + 0 Debtors/Sales 2025-04-24 DCX 8 DebiCheck unsuccessful 0.00 + 0 Debtors/Sales 2025-04-24 DCT 9 DebiCheck tracking 0.00 + 0 Debtors/Sales 2025-04-24 DCD 10 DebiCheck disputed 0.00 + 0 Debtors/Sales 2025-04-24 CRP 11 Same day creditor payment 0.00 - 0 Creditors 2025-04-24 CRU 12 Creditor payment return 0.00 - 0 Creditors 2025-04-24 DTT 13 Deposit received 0.00 - 0 Business Bank Account 2025-04-24 CDR 14 Risk reports 0.00 + 0 NO GL EFFECT 2025-04-24 SAL 15 Same day salary payment 0.00 - 0 Salaries 2025-04-24 NSF 18 Service fee 0.00 - 0 Netcash Service Fees 2025-04-24 BTR 19 Bank transfer to client 0.00 - 0 Business Bank Account 2025-04-24 INP 20 Interest paid to Netcash 0.00 - 0 Interest Paid 2025-04-24 IAT 21 Netcash inter-account transfer 0.00 + 0 Netcash Bank Account 2025-04-24 AVS 22 AVS 0.00 + 0 NO GL EFFECT 2025-04-24 SRU 23 Salary payment return 0.00 - 0 Salaries 2025-04-24 SAD 24 Dated salary payment 0.00 - 0 Salaries 2025-04-24 DCP 25 Dated creditor payment 0.00 - 0 Creditors 2025-04-24 IST 26 Inter-system transfer 0.00 + 0 Account (Cash Book) 2025-04-24 BTU 27 Bank transfer return 0.00 - 0 Business Bank Account 2025-04-24 ABR 28 Account balance recovery 0.00 - 0 Business Bank Account 2025-04-24 ABU 30 Account balance recovery return 0.00 - 0 Business Bank Account 2025-04-24 INR 31 Interest paid to merchant 0.00 - 0 Interest Received 2025-04-24 VAT 32 Output value added tax 0.00 + 0 Input VAT 2025-04-24 PNC 33 Credit card payment 0.00 - 0 Debtors/Sales 2025-04-24 PNU 34 Credit card declined 0.00 - 0 Debtors/Sales 2025-04-24 PND 35 Credit card dispute 0.00 - 0 Debtors/Sales 2025-04-24 PNR 36 Credit card refund 0.00 - 0 Debtors/Sales 2025-04-24 DTR 42 Deposit return 0.00 - 0 Business Bank Account 2025-04-24 PNP 43 Retail payment 0.00 - 0 Debtors/Sales 2025-04-24 PNM 44 Scan to Pay payment 0.00 - 0 Debtors/Sales 2025-04-24 PNE 45 EFT payment 0.00 - 0 Debtors/Sales 2025-04-24 PNQ 46 Retail payment return 0.00 - 0 Debtors/Sales 2025-04-24 PNW 47 Scan to Pay declined 0.00 - 0 Debtors/Sales 2025-04-24 PNZ 48 EFT payment return 0.00 - 0 Debtors/Sales 2025-04-24 IPR 50 Interest paid to Netcash reversal 0.00 - 0 Interest Paid 2025-04-24 IRR 51 Interest paid to merchants reversal 0.00 - 0 Interest Received 2025-04-24 PNA 52 Card authorisation 0.00 - 0 Debtors/Sales 2025-04-24 REB 53 Rebate 0.00 + 0 Debtors/Sales 2025-04-24 PIA 54 Ozow Auth 0.00 - 0 Debtors/Sales 2025-04-24 PIS 55 Ozow Success 0.00 + 0 Debtors/Sales 2025-04-24 PIF 56 Ozow Failure 0.00 + 0 Debtors/Sales 2025-04-24 DCU 57 Debit Order Credit Card Unpaid 0.00 - 0 Debtors/Sales 2025-04-24 DCM 58 Debicheck mandate request 0.00 + 0 Debtors/Sales 2025-04-24 BAR 61 Bank Account Redirect 0.00 + 0 NO GL EFFECT 2025-04-24 AVB 62 Account Verification Bulk 0.00 + 0 NO GL EFFECT 2025-04-24 PVC 63 Visa Click to Pay payment 0.00 - 0 Debtors/Sales 2025-04-24 PVU 64 Visa Click to Pay decline 0.00 - 0 Debtors/Sales 2025-04-24 PVR 65 Visa Click to Pay refund 0.00 - 0 Debtors/Sales 2025-04-24 PVD 66 Visa Click to Pay dispute 0.00 - 0 Debtors/Sales 2025-04-24 PIR 67 Ozow Recall 0.00 - 0 Debtors/Sales 2025-04-24 PQR 68 MasterPass QR 0.00 - 0 Debtors/Sales 2025-04-24 ELM 69 Electronic Mandate 0.00 - 0 NO GL EFFECT 2025-04-24 PCD 70 Client Deposit 0.00 - 0 Business Bank Account 2025-04-24 PNX 78 Scan to Pay refund 0.00 - 0 Debtors/Sales 2025-04-24 DCM 85 DebiCheck Mandate 0.00 - 0 Debtors/Sales 2025-04-24 DPS 86 Debicheck pre submission 0.00 + 0 Debtors/Sales 2025-04-24 DPS 87 Debicheck invalid pre submission 0.00 + 0 Debtors/Sales 2025-04-24 DCX 88 Debicheck rejected submission 0.00 + 0 Debtors/Sales 2025-04-24 ALT 89 Fund transfer 0.00 + 0 Fund transfer to the account 2025-04-24 ART 94 Retail Capital Transfer 0.00 + 0 Fund transfer from the account 2025-04-24 ARF 95 Retail Capital Transfer Failed 0.00 + 0 Fund transfer from the account failed 2025-04-24 DRC 96 Debit order card refund 0.00 - 0 Debtors/Sales 2025-04-24 NCA 97 Adjustment 0.00 + 0 Debtors/Sales 2025-04-24 CRT 98 Real time creditor payment 0.00 - 0 Creditors 2025-04-24 SRT 99 Real time salary payment 0.00 - 0 Salaries 2025-04-24 BRT 100 Real time transfer to client 0.00 - 0 Business Bank Account 2025-04-24 PFA 101 Payflex auth 0.00 - 0 Debtors/Sales 2025-04-24 PFC 102 Payflex success 0.00 - 0 Debtors/Sales 2025-04-24 PFD 103 Payflex decline 0.00 - 0 Debtors/Sales 2025-04-24 PFR 104 Payflex refund 0.00 - 0 Debtors/Sales 2025-04-24 CRR 105 Real time creditor return 0.00 + 0 Creditors 2025-04-24 SRR 106 Real time salary return 0.00 + 0 Salaries 2025-04-24 ADS 108 Advance settlement 0.00 + 0 Advance settlement 2025-04-24 CRJ 109 Real time payment rejection 0.00 + 0 Creditors 2025-04-24 PIY 110 Ozow Refund 0.00 + 0 Debtors/Sales 2025-04-24 PIZ 111 Ozow Failed Refund 0.00 - 0 Debtors/Sales 2025-04-24 PGA 112 Voucher auth 0.00 - 0 Debtors/Sales 2025-04-24 PGC 113 Voucher success 0.00 - 0 Debtors/Sales 2025-04-24 PGD 114 Voucher decline 0.00 - 0 Debtors/Sales 2025-04-24 PGR 115 Voucher refund 0.00 - 0 Debtors/Sales 2025-04-24 CRP 116 Invalid same day creditor payment 0.00 + 0 Creditors 2025-04-24 DCP 117 Invalid dated day creditor payment 0.00 + 0 Creditors 2025-04-24 CRU 118 Rejected creditor payment 0.00 - 0 Creditors 2025-04-24 SAL 119 Invalid same day salary payment 0.00 + 0 Salaries 2025-04-24 SAD 120 Invalid dated day salary payment 0.00 + 0 Salaries 2025-04-24 SRU 121 Rejected salary payment 0.00 - 0 Salaries 2025-04-24 RTR 122 Real time transfer resubmit 0.00 - 0 Business Bank Account 2025-04-24 RRR 123 Real time transfer resubmit return 0.00 + 0 Business Bank Account 2025-04-24 PMB 124 paymyway auth 0.00 - 0 Debtors/Sales 2025-04-24 PMW 125 paymyway success 0.00 - 0 Debtors/Sales 2025-04-24 PME 126 paymyway decline 0.00 - 0 Debtors/Sales 2025-04-24 PSC 127 PayShap creditor payment 0.00 - 0 Creditors 2025-04-24 PSS 128 PayShap salary payment 0.00 - 0 Salaries 2025-04-24 PCR 129 PayShap creditor return 0.00 + 0 Creditors 2025-04-24 PSR 130 PayShap salary return 0.00 + 0 Salaries 2025-04-24 PCI 131 Invalid PayShap creditor payment 0.00 + 0 Creditors 2025-04-24 PCU 132 Rejected PayShap creditor payment 0.00 - 0 Creditors 2025-04-24 PSI 133 Invalid PayShap salary payment 0.00 + 0 Salaries 2025-04-24 PSU 134 Rejected PayShap salary payment 0.00 - 0 Salaries 2025-04-24 CBL 0 Closing Balance 0.00 + 0</string>

The data should be interpreted as follows:^{*This is only an example}

Date|Transaction Code|Internal DB ID|Description|Amount|Effect|Internal Indicator|Ledger Account Affected
2025-04-24 OBL 0 Opening Balance 0.00 + 0
2025-04-24 TDD 1 Two day debit order 0.00 - 0 Debtors/Sales
2025-04-24 TDC 2 Two day credit card debit order 0.00 - 0 Debtors/Sales
2025-04-24 DRU 4 Debit order unpaid 0.00 - 0 Debtors/Sales
2025-04-24 SDD 5 Same day debit order 0.00 - 0 Debtors/Sales
2025-04-24 SDC 6 Same day credit card debit order 0.00 - 0 Debtors/Sales
2025-04-24 DCS 7 DebiCheck successful 0.00 + 0 Debtors/Sales
2025-04-24 DCX 8 DebiCheck unsuccessful 0.00 + 0 Debtors/Sales
2025-04-24 DCT 9 DebiCheck tracking 0.00 + 0 Debtors/Sales
2025-04-24 DCD 10 DebiCheck disputed 0.00 + 0 Debtors/Sales
2025-04-24 CRP 11 Same day creditor payment 0.00 - 0 Creditors
2025-04-24 CRU 12 Creditor payment return 0.00 - 0 Creditors
2025-04-24 DTT 13 Deposit received 0.00 - 0 Business Bank Account
2025-04-24 CDR 14 Risk reports 0.00 + 0 NO GL EFFECT
2025-04-24 SAL 15 Same day salary payment 0.00 - 0 Salaries
2025-04-24 NSF 18 Service fee 0.00 - 0 Netcash Service Fees
2025-04-24 BTR 19 Bank transfer to client 0.00 - 0 Business Bank Account
2025-04-24 INP 20 Interest paid to Netcash 0.00 - 0 Interest Paid
2025-04-24 IAT 21 Netcash inter-account transfer 0.00 + 0 Netcash Bank Account
2025-04-24 AVS 22 AVS 0.00 + 0 NO GL EFFECT
2025-04-24 SRU 23 Salary payment return 0.00 - 0 Salaries
2025-04-24 SAD 24 Dated salary payment 0.00 - 0 Salaries
2025-04-24 DCP 25 Dated creditor payment 0.00 - 0 Creditors
2025-04-24 IST 26 Inter-system transfer 0.00 + 0 Account (Cash Book)
2025-04-24 BTU 27 Bank transfer return 0.00 - 0 Business Bank Account
2025-04-24 ABR 28 Account balance recovery 0.00 - 0 Business Bank Account
2025-04-24 ABU 30 Account balance recovery return 0.00 - 0 Business Bank Account
2025-04-24 INR 31 Interest paid to merchant 0.00 - 0 Interest Received
2025-04-24 VAT 32 Output value added tax 0.00 + 0 Input VAT
2025-04-24 PNC 33 Credit card payment 0.00 - 0 Debtors/Sales
2025-04-24 PNU 34 Credit card declined 0.00 - 0 Debtors/Sales
2025-04-24 PND 35 Credit card dispute 0.00 - 0 Debtors/Sales
2025-04-24 PNR 36 Credit card refund 0.00 - 0 Debtors/Sales
2025-04-24 DTR 42 Deposit return 0.00 - 0 Business Bank Account
2025-04-24 PNP 43 Retail payment 0.00 - 0 Debtors/Sales
2025-04-24 PNM 44 Scan to Pay payment 0.00 - 0 Debtors/Sales
2025-04-24 PNE 45 EFT payment 0.00 - 0 Debtors/Sales
2025-04-24 PNQ 46 Retail payment return 0.00 - 0 Debtors/Sales
2025-04-24 PNW 47 Scan to Pay declined 0.00 - 0 Debtors/Sales
2025-04-24 PNZ 48 EFT payment return 0.00 - 0 Debtors/Sales
2025-04-24 IPR 50 Interest paid to Netcash reversal 0.00 - 0 Interest Paid
2025-04-24 IRR 51 Interest paid to merchants reversal 0.00 - 0 Interest Received
2025-04-24 PNA 52 Card authorisation 0.00 - 0 Debtors/Sales
2025-04-24 REB 53 Rebate 0.00 + 0 Debtors/Sales
2025-04-24 PIA 54 Ozow Auth 0.00 - 0 Debtors/Sales
2025-04-24 PIS 55 Ozow Success 0.00 + 0 Debtors/Sales
2025-04-24 PIF 56 Ozow Failure 0.00 + 0 Debtors/Sales
2025-04-24 DCU 57 Debit Order Credit Card Unpaid 0.00 - 0 Debtors/Sales
2025-04-24 DCM 58 Debicheck mandate request 0.00 + 0 Debtors/Sales
2025-04-24 BAR 61 Bank Account Redirect 0.00 + 0 NO GL EFFECT
2025-04-24 AVB 62 Account Verification Bulk 0.00 + 0 NO GL EFFECT
2025-04-24 PVC 63 Visa Click to Pay payment 0.00 - 0 Debtors/Sales
2025-04-24 PVU 64 Visa Click to Pay decline 0.00 - 0 Debtors/Sales
2025-04-24 PVR 65 Visa Click to Pay refund 0.00 - 0 Debtors/Sales
2025-04-24 PVD 66 Visa Click to Pay dispute 0.00 - 0 Debtors/Sales
2025-04-24 PIR 67 Ozow Recall 0.00 - 0 Debtors/Sales
2025-04-24 PQR 68 MasterPass QR 0.00 - 0 Debtors/Sales
2025-04-24 ELM 69 Electronic Mandate 0.00 - 0 NO GL EFFECT
2025-04-24 PCD 70 Client Deposit 0.00 - 0 Business Bank Account
2025-04-24 PNX 78 Scan to Pay refund 0.00 - 0 Debtors/Sales
2025-04-24 DCM 85 DebiCheck Mandate 0.00 - 0 Debtors/Sales
2025-04-24 DPS 86 Debicheck pre submission 0.00 + 0 Debtors/Sales
2025-04-24 DPS 87 Debicheck invalid pre submission 0.00 + 0 Debtors/Sales
2025-04-24 DCX 88 Debicheck rejected submission 0.00 + 0 Debtors/Sales
2025-04-24 ALT 89 Fund transfer 0.00 + 0 Fund transfer to the account
2025-04-24 ART 94 Retail Capital Transfer 0.00 + 0 Fund transfer from the account
2025-04-24 ARF 95 Retail Capital Transfer Failed 0.00 + 0 Fund transfer from the account failed
2025-04-24 DRC 96 Debit order card refund 0.00 - 0 Debtors/Sales
2025-04-24 NCA 97 Adjustment 0.00 + 0 Debtors/Sales
2025-04-24 CRT 98 Real time creditor payment 0.00 - 0 Creditors
2025-04-24 SRT 99 Real time salary payment 0.00 - 0 Salaries
2025-04-24 BRT 100 Real time transfer to client 0.00 - 0 Business Bank Account
2025-04-24 PFA 101 Payflex auth 0.00 - 0 Debtors/Sales
2025-04-24 PFC 102 Payflex success 0.00 - 0 Debtors/Sales
2025-04-24 PFD 103 Payflex decline 0.00 - 0 Debtors/Sales
2025-04-24 PFR 104 Payflex refund 0.00 - 0 Debtors/Sales
2025-04-24 CRR 105 Real time creditor return 0.00 + 0 Creditors
2025-04-24 SRR 106 Real time salary return 0.00 + 0 Salaries
2025-04-24 ADS 108 Advance settlement 0.00 + 0 Advance settlement
2025-04-24 CRJ 109 Real time payment rejection 0.00 + 0 Creditors
2025-04-24 PIY 110 Ozow Refund 0.00 + 0 Debtors/Sales
2025-04-24 PIZ 111 Ozow Failed Refund 0.00 - 0 Debtors/Sales
2025-04-24 PGA 112 Voucher auth 0.00 - 0 Debtors/Sales
2025-04-24 PGC 113 Voucher success 0.00 - 0 Debtors/Sales
2025-04-24 PGD 114 Voucher decline 0.00 - 0 Debtors/Sales
2025-04-24 PGR 115 Voucher refund 0.00 - 0 Debtors/Sales
2025-04-24 CRP 116 Invalid same day creditor payment 0.00 + 0 Creditors
2025-04-24 DCP 117 Invalid dated day creditor payment 0.00 + 0 Creditors
2025-04-24 CRU 118 Rejected creditor payment 0.00 - 0 Creditors
2025-04-24 SAL 119 Invalid same day salary payment 0.00 + 0 Salaries
2025-04-24 SAD 120 Invalid dated day salary payment 0.00 + 0 Salaries
2025-04-24 SRU 121 Rejected salary payment 0.00 - 0 Salaries
2025-04-24 RTR 122 Real time transfer resubmit 0.00 - 0 Business Bank Account
2025-04-24 RRR 123 Real time transfer resubmit return 0.00 + 0 Business Bank Account
2025-04-24 PMB 124 paymyway auth 0.00 - 0 Debtors/Sales
2025-04-24 PMW 125 paymyway success 0.00 - 0 Debtors/Sales
2025-04-24 PME 126 paymyway decline 0.00 - 0 Debtors/Sales
2025-04-24 PSC 127 PayShap creditor payment 0.00 - 0 Creditors
2025-04-24 PSS 128 PayShap salary payment 0.00 - 0 Salaries
2025-04-24 PCR 129 PayShap creditor return 0.00 + 0 Creditors
2025-04-24 PSR 130 PayShap salary return 0.00 + 0 Salaries
2025-04-24 PCI 131 Invalid PayShap creditor payment 0.00 + 0 Creditors
2025-04-24 PCU 132 Rejected PayShap creditor payment 0.00 - 0 Creditors
2025-04-24 PSI 133 Invalid PayShap salary payment 0.00 + 0 Salaries
2025-04-24 PSU 134 Rejected PayShap salary payment 0.00 - 0 Salaries
2025-04-24 CBL 0 Closing Balance 0.00 + 0

Example

Output indicating an unpaid transaction

<RetrieveMerchantStatement>
    <MethodParameters>
        <String>
           2025-04-24 OBL 0 Opening Balance -115.8000 + 0
           2025-04-24 CRU 1706180 Creditor Payment Return -Code:26 1.0000 - 0
           2025-04-24 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

Accounting ledger description

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

2025-04-24 OBL 0 Opening Balance 0.00 + 0
2025-04-24 TDD 1 Two day debit order 0.00 - 0 Debtors/Sales
2025-04-24 TDC 2 Two day credit card debit order 0.00 - 0 Debtors/Sales
2025-04-24 DRU 4 Debit order unpaid 0.00 - 0 Debtors/Sales
2025-04-24 SDD 5 Same day debit order 0.00 - 0 Debtors/Sales
2025-04-24 SDC 6 Same day credit card debit order 0.00 - 0 Debtors/Sales
2025-04-24 DCS 7 DebiCheck successful 0.00 + 0 Debtors/Sales
2025-04-24 DCX 8 DebiCheck unsuccessful 0.00 + 0 Debtors/Sales
2025-04-24 DCT 9 DebiCheck tracking 0.00 + 0 Debtors/Sales
2025-04-24 DCD 10 DebiCheck disputed 0.00 + 0 Debtors/Sales
2025-04-24 CRP 11 Same day creditor payment 0.00 - 0 Creditors
2025-04-24 CRU 12 Creditor payment return 0.00 - 0 Creditors
2025-04-24 DTT 13 Deposit received 0.00 - 0 Business Bank Account
2025-04-24 CDR 14 Risk reports 0.00 + 0 NO GL EFFECT
2025-04-24 SAL 15 Same day salary payment 0.00 - 0 Salaries
2025-04-24 NSF 18 Service fee 0.00 - 0 Netcash Service Fees
2025-04-24 BTR 19 Bank transfer to client 0.00 - 0 Business Bank Account
2025-04-24 INP 20 Interest paid to Netcash 0.00 - 0 Interest Paid
2025-04-24 IAT 21 Netcash inter-account transfer 0.00 + 0 Netcash Bank Account
2025-04-24 AVS 22 AVS 0.00 + 0 NO GL EFFECT
2025-04-24 SRU 23 Salary payment return 0.00 - 0 Salaries
2025-04-24 SAD 24 Dated salary payment 0.00 - 0 Salaries
2025-04-24 DCP 25 Dated creditor payment 0.00 - 0 Creditors
2025-04-24 IST 26 Inter-system transfer 0.00 + 0 Account (Cash Book)
2025-04-24 BTU 27 Bank transfer return 0.00 - 0 Business Bank Account
2025-04-24 ABR 28 Account balance recovery 0.00 - 0 Business Bank Account
2025-04-24 ABU 30 Account balance recovery return 0.00 - 0 Business Bank Account
2025-04-24 INR 31 Interest paid to merchant 0.00 - 0 Interest Received
2025-04-24 VAT 32 Output value added tax 0.00 + 0 Input VAT
2025-04-24 PNC 33 Credit card payment 0.00 - 0 Debtors/Sales
2025-04-24 PNU 34 Credit card declined 0.00 - 0 Debtors/Sales
2025-04-24 PND 35 Credit card dispute 0.00 - 0 Debtors/Sales
2025-04-24 PNR 36 Credit card refund 0.00 - 0 Debtors/Sales
2025-04-24 DTR 42 Deposit return 0.00 - 0 Business Bank Account
2025-04-24 PNP 43 Retail payment 0.00 - 0 Debtors/Sales
2025-04-24 PNM 44 Scan to Pay payment 0.00 - 0 Debtors/Sales
2025-04-24 PNE 45 EFT payment 0.00 - 0 Debtors/Sales
2025-04-24 PNQ 46 Retail payment return 0.00 - 0 Debtors/Sales
2025-04-24 PNW 47 Scan to Pay declined 0.00 - 0 Debtors/Sales
2025-04-24 PNZ 48 EFT payment return 0.00 - 0 Debtors/Sales
2025-04-24 IPR 50 Interest paid to Netcash reversal 0.00 - 0 Interest Paid
2025-04-24 IRR 51 Interest paid to merchants reversal 0.00 - 0 Interest Received
2025-04-24 PNA 52 Card authorisation 0.00 - 0 Debtors/Sales
2025-04-24 REB 53 Rebate 0.00 + 0 Debtors/Sales
2025-04-24 PIA 54 Ozow Auth 0.00 - 0 Debtors/Sales
2025-04-24 PIS 55 Ozow Success 0.00 + 0 Debtors/Sales
2025-04-24 PIF 56 Ozow Failure 0.00 + 0 Debtors/Sales
2025-04-24 DCU 57 Debit Order Credit Card Unpaid 0.00 - 0 Debtors/Sales
2025-04-24 DCM 58 Debicheck mandate request 0.00 + 0 Debtors/Sales
2025-04-24 BAR 61 Bank Account Redirect 0.00 + 0 NO GL EFFECT
2025-04-24 AVB 62 Account Verification Bulk 0.00 + 0 NO GL EFFECT
2025-04-24 PVC 63 Visa Click to Pay payment 0.00 - 0 Debtors/Sales
2025-04-24 PVU 64 Visa Click to Pay decline 0.00 - 0 Debtors/Sales
2025-04-24 PVR 65 Visa Click to Pay refund 0.00 - 0 Debtors/Sales
2025-04-24 PVD 66 Visa Click to Pay dispute 0.00 - 0 Debtors/Sales
2025-04-24 PIR 67 Ozow Recall 0.00 - 0 Debtors/Sales
2025-04-24 PQR 68 MasterPass QR 0.00 - 0 Debtors/Sales
2025-04-24 ELM 69 Electronic Mandate 0.00 - 0 NO GL EFFECT
2025-04-24 PCD 70 Client Deposit 0.00 - 0 Business Bank Account
2025-04-24 PNX 78 Scan to Pay refund 0.00 - 0 Debtors/Sales
2025-04-24 DCM 85 DebiCheck Mandate 0.00 - 0 Debtors/Sales
2025-04-24 DPS 86 Debicheck pre submission 0.00 + 0 Debtors/Sales
2025-04-24 DPS 87 Debicheck invalid pre submission 0.00 + 0 Debtors/Sales
2025-04-24 DCX 88 Debicheck rejected submission 0.00 + 0 Debtors/Sales
2025-04-24 ALT 89 Fund transfer 0.00 + 0 Fund transfer to the account
2025-04-24 ART 94 Retail Capital Transfer 0.00 + 0 Fund transfer from the account
2025-04-24 ARF 95 Retail Capital Transfer Failed 0.00 + 0 Fund transfer from the account failed
2025-04-24 DRC 96 Debit order card refund 0.00 - 0 Debtors/Sales
2025-04-24 NCA 97 Adjustment 0.00 + 0 Debtors/Sales
2025-04-24 CRT 98 Real time creditor payment 0.00 - 0 Creditors
2025-04-24 SRT 99 Real time salary payment 0.00 - 0 Salaries
2025-04-24 BRT 100 Real time transfer to client 0.00 - 0 Business Bank Account
2025-04-24 PFA 101 Payflex auth 0.00 - 0 Debtors/Sales
2025-04-24 PFC 102 Payflex success 0.00 - 0 Debtors/Sales
2025-04-24 PFD 103 Payflex decline 0.00 - 0 Debtors/Sales
2025-04-24 PFR 104 Payflex refund 0.00 - 0 Debtors/Sales
2025-04-24 CRR 105 Real time creditor return 0.00 + 0 Creditors
2025-04-24 SRR 106 Real time salary return 0.00 + 0 Salaries
2025-04-24 ADS 108 Advance settlement 0.00 + 0 Advance settlement
2025-04-24 CRJ 109 Real time payment rejection 0.00 + 0 Creditors
2025-04-24 PIY 110 Ozow Refund 0.00 + 0 Debtors/Sales
2025-04-24 PIZ 111 Ozow Failed Refund 0.00 - 0 Debtors/Sales
2025-04-24 PGA 112 Voucher auth 0.00 - 0 Debtors/Sales
2025-04-24 PGC 113 Voucher success 0.00 - 0 Debtors/Sales
2025-04-24 PGD 114 Voucher decline 0.00 - 0 Debtors/Sales
2025-04-24 PGR 115 Voucher refund 0.00 - 0 Debtors/Sales
2025-04-24 CRP 116 Invalid same day creditor payment 0.00 + 0 Creditors
2025-04-24 DCP 117 Invalid dated day creditor payment 0.00 + 0 Creditors
2025-04-24 CRU 118 Rejected creditor payment 0.00 - 0 Creditors
2025-04-24 SAL 119 Invalid same day salary payment 0.00 + 0 Salaries
2025-04-24 SAD 120 Invalid dated day salary payment 0.00 + 0 Salaries
2025-04-24 SRU 121 Rejected salary payment 0.00 - 0 Salaries
2025-04-24 RTR 122 Real time transfer resubmit 0.00 - 0 Business Bank Account
2025-04-24 RRR 123 Real time transfer resubmit return 0.00 + 0 Business Bank Account
2025-04-24 PMB 124 paymyway auth 0.00 - 0 Debtors/Sales
2025-04-24 PMW 125 paymyway success 0.00 - 0 Debtors/Sales
2025-04-24 PME 126 paymyway decline 0.00 - 0 Debtors/Sales
2025-04-24 PSC 127 PayShap creditor payment 0.00 - 0 Creditors
2025-04-24 PSS 128 PayShap salary payment 0.00 - 0 Salaries
2025-04-24 PCR 129 PayShap creditor return 0.00 + 0 Creditors
2025-04-24 PSR 130 PayShap salary return 0.00 + 0 Salaries
2025-04-24 PCI 131 Invalid PayShap creditor payment 0.00 + 0 Creditors
2025-04-24 PCU 132 Rejected PayShap creditor payment 0.00 - 0 Creditors
2025-04-24 PSI 133 Invalid PayShap salary payment 0.00 + 0 Salaries
2025-04-24 PSU 134 Rejected PayShap salary payment 0.00 - 0 Salaries
2025-04-24 CBL 0 Closing Balance 0.00 + 0

Unpaid Code Descriptions

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

Statement Mapping

Below is a table of transaction types that can appear on the Netcash Statement.

Account Service

Transaction code	Transaction description	Ledger Affected
OBL	Opening balance	No GL Affect
CBL	Closing balance	No GL Affect
DTT	Deposit Received	Business Bank Account
DTR	Deposit Return	Business Bank Account
NSF	Service fee	Bank Charges
BTR	Bank transfer to client	Business Bank Account
BTU	Bank transfer return	Business Bank Account
INP	Interest paid to Netcash	Interest Paid
INR	Interest received	Interest Received
ABR	Account balance recovery	Business Bank Account
ABU	Account balance recovery return	Business Bank Account
VAT	Value added tax	VAT
IAT	Inter-account transfer	No GL Affect
IST	Inter-system transfer	No GL Affect
BDW	Bad Debt Write-Off	No GL Affect
IPR	Interest paid to Netcash reversal	Interest
IRR	Interest paid to Merchants reversal	Interest
REB	Rebate	Income
BAR	Bank Account Redirect	No GL Affect
ELM	Electronic Mandate	No GL Affect
USI	Unallocated Statement Transaction In	No GL Affect
USO	Unallocated Statement Transaction Out	No GL Affect
INS	Interest Swept	No GL Affect
BRT	Real Time Transfer to Client	Business Bank Account
BRR	Real Time Transfer Returned	Business Bank Account
NCA	Adjustment	Depending on Type
ADS	Advance Settlement	Netcash Advance (Balance Sheet Account)
	TOP

Debit Order Service

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

Salary Payment Service

Transaction code	Transaction description	Ledger Account
SAL	Same day salary payment	Salaries
SRU	Salary payment return	Salaries
SAD	Dated salary payment	Salaries
SRT	Real time salary payment	Salaries
SRR	Real time salary return	Salaries
		TOP

Creditor Payment Service

Transaction code	Transaction description	Ledger Affected
CRP	Same day creditor payment	Creditor Payments
CRU	Creditor payment return	Creditor Payments
DCP	Dated creditor payment	Creditor Payments
CRT	Real time creditor payment	Creditor Payments
CRR	Dated creditor payment return	Creditor Payments
	TOP

Risk Service

Transaction code	Transaction description	Ledger Account
CDR	Risk Reports report	No GL effect
AVS	Account Verification Single	No GL effect
AVB	Account Verification Bulk	No GL effect
	TOP

Pay Now Service

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
PFA	Payflex Auth	Debtors/Sales
PFC	Payflex success	Debtors/Sales
PFD	Payflex Decline	Debtors/Sales
PFR	Payflex Refund	Debtors/Sales
PMB	PayMyWay Auth	Debtors/Sales
PMW	PayMyWay Success	Debtors/Sales
PME	PayMyWay Decline	Debtors/Sales
PSC	PayShap creditor payment	Creditors
PSS	PayShap salary payment	Salaries
PCR	PayShap creditor return	Creditors
PSR	PayShap salary return	Salaries
PCI	Invalid PayShap creditor payment	Creditors
PCU	Rejected PayShap creditor payment	Creditors
PSI	Invalid PayShap salary payment	Salaries
PSU	Rejected PayShap salary payment	Salaries
PGR	Voucher refund	Debtors/Sales
PGD	Voucher decline	Debtors/Sales
PGC	Voucher success	Debtors/Sales
PGA	Voucher auth	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:

Schedule a download -and reconcile your Netcash statement daily at 08h30 as settlements to Netcash accounts will be processed by this time.
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

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.

See unpaid code descriptions

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.