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>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 PGA 112 Voucher Auth 0.00 + 0 Debtors/Sales 2023-11-08 PGC 113 Voucher success 0.00 + 0 Debtors/Sales 2023-11-08 PGD 114 Voucher decline 0.00 + 0 Debtors/Sales 2023-11-08 PGR 115 Voucher refund 0.00 + 0 Debtors/Sales 2023-11-08 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
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 PGA 112 Voucher Auth 0.00 + 0 Debtors/Sales
2023-11-08 PGC 113 Voucher success 0.00 + 0 Debtors/Sales
2023-11-08 PGD 114 Voucher decline 0.00 + 0 Debtors/Sales
2023-11-08 PGR 115 Voucher 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

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

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    PGA    112    Voucher Auth    0.00    +    0
2023-11-08    PGC    113    Voucher success    0.00    +    0
2023-11-08    PGD    114    Voucher decline    0.00    +    0
2023-11-08    PGR    115    Voucher 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.

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