Currently set to Index
Currently set to Follow

Overview

The Netcash Statement is the most critical integration point of the entire integration. It is available in three (3) formats

  1. Full Daily Statement – to be used by any/all ISV‘s.
  2. Bulk Statementonly to be used by multi-tenant systems where a central system updates and reconciles all the subtenant systems programmatically.
  3. Interim Statement – only to be used where near real-time transaction notification for Bank EFT and CASH payments via the Pay Now service is monitored.

The Netcash Statement is a tab-delimited text file that must be used for the reconciliation of transactional data already processed through the Netcash merchant 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. The accounting guide provided for correct transaction posting at the end of this document.

Click here for the quick start guides for:

See Netcash Statement Reconciliation parameters and Sage Accounting reconciliation methodology for Sage Bank Manager.

Web Service Methods

The list of Netcash web service methods can be found here

QuickStart Guides

We have developed some Quick Start Guides to help you understand this service and to help you get started.

Programmers Guide

To start, refer our Programmers guide for more detail on how to apply the required methodology in this document.
Please ensure that the settings for Developers are correctly set before you proceed with the implementation below specification.

Technical Information

Introduction

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 daily or interim statement files from the Netcash system.

A Netcash Account service key is required for authentication and access to this endpoint. Service keys are issued to merchants by Netcash on request.

All Netcash transactions processed will appear on the Netcash Statement as itemized items.

Usage

The file specified in this document is produced when the web service receives a valid request for a statement file. 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.
  • It is 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.
  • It is recommended that the remote system requests a full daily statement every day and stores the data locally.
  • All Netcash transaction types are included in the statement which will allow for a full reconciliation of cash books, debtors and creditors account within accounting or management system. Accounting guide provided for correct transaction posting at the end of this document.
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 statements should only be used by ISV’s who 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 rely on the Pay Now postback URL’s for live/real-time transaction notification – settlement values are available on the statement for these transactions the day after the transaction was processed.

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

The Interim Statement method should only be used if explicitly recommended by Netcash.

RequestInterimMerchantStatement

  • This method should only be used if explicitly recommended by Netcash.
  • Interim statements should only be used by ISV’s who need to monitor non-real-time transactions during the day.
  • 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.
  • The remote system may only request an interim statement for the current date.
  • The Netcash system will return any transactions which have been committed to the data warehouse as complete at the time of the request.
  • If a second request is received before the 15-minute timer has elapsed, the Netcash web service will return “NO CHANGE” as a response.
  • If no new transactions are available since the previous request, the Netcash web service will return “NO CHANGE” as a response.
  • All Netcash transaction types are included in the statement which will allow for a full reconciliation of cash books, debtors and creditors account within accounting or management system. Accounting guide provided for correct transaction posting at the end of this document.
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

Example

public string RequestInterimMerchantStatement(string ServiceKey)
        {
            //initialise client 
            NIWS_NIF.NIWS_NIFClient client = new NIWS_NIF.NIWS_NIFClient();

            //call the RequestInterimMerchantStatement method equal to a string variable
            //account service key should be used 
            string Request = client.RequestInterimMerchantStatement(ServiceKey);

            //close client
            client.Close();

            //check request
            switch (Request)
            {
                case "100"://Authentication failure
                    break;
                case "200"://General code exception
                    break;
                default://Success, use file token to call RetrieveMerchantStatement
                    break;
            }

            return Request;
        }

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

In the event that the request was 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
Polling id 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;
        }

 

Successful

  • The Netcash system 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 file will be terminated with the Closing balance (CBL) as the final record in the file.

Example

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

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

<String>2020-11-10	OBL	0	Opening Balance	0.0000	+	0				2020-11-10	TDD	1	Two day debit order 	0.0000	+	0				Debtors/Sales2020-11-10	TDC	2	Two day credit card debit order	0.0000	+	0				Debtors/Sales2020-11-10	DRU	4	Debit order unpaid	0.0000	+	0				Debtors/Sales2020-11-10	SDD	5	Same day debit order	0.0000	+	0				Debtors/Sales2020-11-10	SDC	6	Same day credit card debit order	0.0000	+	0				Debtors/Sales2020-11-10	DCS	7	Debicheck successful transaction	0.0000	+	0				Debtors/Sales2020-11-10	DCX	8	Debicheck unsuccessful transaction	0.0000	+	0				Debtors/Sales2020-11-10	DCT	9	Debicheck tracking transaction	0.0000	+	0				Debtors/Sales2020-11-10	DCD	10	Debicheck disputed transaction	0.0000	+	0				Debtors/Sales2020-11-10	CRP	11	Same day creditor payment	0.0000	+	0				Creditors2020-11-10	CRU	12	Creditor payment return	0.0000	+	0				Creditors2020-11-10	DTT	13	Deposit received	0.0000	+	0				Business Bank Account2020-11-10	CDR	14	Risk reports	0.0000	+	0				NO GL EFFECT2020-11-10	SAL	15	Same day salary payment	0.0000	+	0				Salaries2020-11-10	NSF	18	Service fee	0.0000	+	0				Netcash Service Fees2020-11-10	BTR	19	Bank transfer to client	0.0000	+	0				Business Bank Account2020-11-10	INP	20	Interest paid to Netcash	0.0000	+	0				Interest Paid2020-11-10	IAT	21	Inter-account transfer	0.0000	+	0				Netcash Bank Account2020-11-10	AVS	22	AVS	0.0000	+	0				NO GL EFFECT2020-11-10	SRU	23	Salary payment return	0.0000	+	0				Salaries2020-11-10	SAD	24	Dated salary payment	0.0000	+	0				Salaries2020-11-10	DCP	25	Dated creditor payment	0.0000	+	0				Creditors2020-11-10	IST	26	Inter-system transfer	0.0000	+	0				Account (Cash Book)2020-11-10	BTU	27	Bank transfer return	0.0000	+	0				Business Bank Account2020-11-10	ABR	28	Account balance recovery	0.0000	+	0				Business Bank Account2020-11-10	CSP	29	Cashnet cash payment	0.0000	+	0				Creditors2020-11-10	ABU	30	Account balance recovery return	0.0000	+	0				Business Bank Account2020-11-10	INR	31	Interest paid to merchant	0.0000	+	0				Interest Received2020-11-10	VAT	32	Output value added tax	0.0000	+	0				Input VAT2020-11-10	PNC	33	Credit card payment	0.0000	+	0				Debtors/Sales2020-11-10	PNU	34	Credit card declined	0.0000	+	0				Debtors/Sales2020-11-10	PND	35	Credit card dispute	0.0000	+	0				Debtors/Sales2020-11-10	PNR	36	Credit card refund	0.0000	+	0				Debtors/Sales2020-11-10	DTR	42	Deposit return	0.0000	+	0				Business Bank Account2020-11-10	PNP	43	Retail payment	0.0000	+	0				Debtors/Sales2020-11-10	PNM	44	Scan to Pay payment	0.0000	+	0				Debtors/Sales2020-11-10	PNE	45	EFT payment	0.0000	+	0				Debtors/Sales2020-11-10	PNQ	46	Retail payment return	0.0000	+	0				Debtors/Sales2020-11-10	PNW	47	Scan to Pay declined	0.0000	+	0				Debtors/Sales2020-11-10	PNZ	48	EFT payment return	0.0000	+	0				Debtors/Sales2020-11-10	IPR	50	Interest paid to Netcash reversal	0.0000	+	0				Interest Paid2020-11-10	IRR	51	Interest paid to merchants reversal	0.0000	+	0				Interest Received2020-11-10	PNA	52	Card authorisation	0.0000	+	0				Debtors/Sales2020-11-10	REB	53	Rebate	0.0000	+	0				Debtors/Sales2020-11-10	PIA	54	iPay Auth	0.0000	+	0				Debtors/Sales2020-11-10	PIS	55	iPay Success	0.0000	+	0				Debtors/Sales2020-11-10	PIF	56	iPay Failure	0.0000	+	0				Debtors/Sales2020-11-10	DCU	57	Debit Order Credit Card Unpaid	0.0000	+	0				Debtors/Sales2020-11-10	DCM	58	Debicheck mandate request	0.0000	+	0				Debtors/Sales2020-11-10	BAR	61	Bank Account Redirect	0.0000	+	0				NO GL EFFECT2020-11-10	AVB	62	Account Verification Bulk	0.0000	+	0				NO GL EFFECT2020-11-10	PVC	63	Visa Click to Pay payment	0.0000	+	0				Debtors/Sales2020-11-10	PVU	64	Visa CheckOut decline	0.0000	+	0				Debtors/Sales2020-11-10	PVR	65	Visa Click to Pay refund	0.0000	+	0				Debtors/Sales2020-11-10	PVD	66	Visa Click to Pay dispute	0.0000	+	0				Debtors/Sales2020-11-10	PIR	67	iPay Recall	0.0000	+	0				Debtors/Sales2020-11-10	PQR	68	MasterPass QR	0.0000	+	0				Debtors/Sales2020-11-10	ELM	69	Electronic Mandate	0.0000	+	0				NO GL EFFECT2020-11-10	PCD	70	Client Deposit	0.0000	+	0				Business Bank Account2020-11-10	TDD	74	Two day invalid debit order 	0.0000	+	0				Debtors/Sales2020-11-10	SDD	75	Same day invalid debit order	0.0000	+	0				Debtors/Sales2020-11-10	DRU	76	Rejected debit order	0.0000	+	0				Debtors/Sales2020-11-10	CNC	77	Cashnet Control	0.0000	+	0				Debtors/Sales2020-11-10	CBL	0	Closing Balance	0.0000	+	0</String>

The data should be interpreted as follows:

Date|Transaction Code|Internal DB ID|Description|Amount|Effect|Internal Indicator|Ledger Account Affected
2020-11-10 OBL 0 Opening Balance 0.0000 + 0 
2020-11-10 TDD 1 Two day debit order 0.0000 + 0 Debtors/Sales
2020-11-10 TDC 2 Two day credit card debit order 0.0000 + 0 Debtors/Sales
2020-11-10 DRU 4 Debit order unpaid 0.0000 + 0 Debtors/Sales
2020-11-10 SDD 5 Same day debit order 0.0000 + 0 Debtors/Sales
2020-11-10 SDC 6 Same day credit card debit order 0.0000 + 0 Debtors/Sales
2020-11-10 DCS 7 Debicheck successful transaction 0.0000 + 0 Debtors/Sales
2020-11-10 DCX 8 Debicheck unsuccessful transaction 0.0000 + 0 Debtors/Sales
2020-11-10 DCT 9 Debicheck tracking transaction 0.0000 + 0 Debtors/Sales
2020-11-10 DCD 10 Debicheck disputed transaction 0.0000 + 0 Debtors/Sales
2020-11-10 CRP 11 Same day creditor payment 0.0000 + 0 Creditors
2020-11-10 CRU 12 Creditor payment return 0.0000 + 0 Creditors
2020-11-10 DTT 13 Deposit received 0.0000 + 0 Business Bank Account
2020-11-10 CDR 14 Risk reports 0.0000 + 0 NO GL EFFECT
2020-11-10 SAL 15 Same day salary payment 0.0000 + 0 Salaries
2020-11-10 NSF 18 Service fee 0.0000 + 0 Netcash Service Fees
2020-11-10 BTR 19 Bank transfer to client 0.0000 + 0 Business Bank Account
2020-11-10 INP 20 Interest paid to Netcash 0.0000 + 0 Interest Paid
2020-11-10 IAT 21 Inter-account transfer 0.0000 + 0 Netcash Bank Account
2020-11-10 AVS 22 AVS 0.0000 + 0 NO GL EFFECT
2020-11-10 SRU 23 Salary payment return 0.0000 + 0 Salaries
2020-11-10 SAD 24 Dated salary payment 0.0000 + 0 Salaries
2020-11-10 DCP 25 Dated creditor payment 0.0000 + 0 Creditors
2020-11-10 IST 26 Inter-system transfer 0.0000 + 0 Account (Cash Book)
2020-11-10 BTU 27 Bank transfer return 0.0000 + 0 Business Bank Account
2020-11-10 ABR 28 Account balance recovery 0.0000 + 0 Business Bank Account
2020-11-10 CSP 29 Cashnet cash payment 0.0000 + 0 Creditors
2020-11-10 ABU 30 Account balance recovery return 0.0000 + 0 Business Bank Account
2020-11-10 INR 31 Interest paid to merchant 0.0000 + 0 Interest Received
2020-11-10 VAT 32 Output value added tax 0.0000 + 0 Input VAT
2020-11-10 PNC 33 Credit card payment 0.0000 + 0 Debtors/Sales
2020-11-10 PNU 34 Credit card declined 0.0000 + 0 Debtors/Sales
2020-11-10 PND 35 Credit card dispute 0.0000 + 0 Debtors/Sales
2020-11-10 PNR 36 Credit card refund 0.0000 + 0 Debtors/Sales
2020-11-10 DTR 42 Deposit return 0.0000 + 0 Business Bank Account
2020-11-10 PNP 43 Retail payment 0.0000 + 0 Debtors/Sales
2020-11-10 PNM 44 Scan to Pay payment 0.0000 + 0 Debtors/Sales
2020-11-10 PNE 45 EFT payment 0.0000 + 0 Debtors/Sales
2020-11-10 PNQ 46 Retail payment return 0.0000 + 0 Debtors/Sales
2020-11-10 PNW 47 Scan to Pay declined 0.0000 + 0 Debtors/Sales
2020-11-10 PNZ 48 EFT payment return 0.0000 + 0 Debtors/Sales
2020-11-10 IPR 50 Interest paid to Netcash reversal 0.0000 + 0 Interest Paid
2020-11-10 IRR 51 Interest paid to merchants reversal 0.0000 + 0 Interest Received
2020-11-10 PNA 52 Card authorisation 0.0000 + 0 Debtors/Sales
2020-11-10 REB 53 Rebate 0.0000 + 0 Debtors/Sales
2020-11-10 PIA 54 iPay Auth 0.0000 + 0 Debtors/Sales
2020-11-10 PIS 55 iPay Success 0.0000 + 0 Debtors/Sales
2020-11-10 PIF 56 iPay Failure 0.0000 + 0 Debtors/Sales
2020-11-10 DCU 57 Debit Order Credit Card Unpaid 0.0000 + 0 Debtors/Sales
2020-11-10 DCM 58 Debicheck mandate request 0.0000 + 0 Debtors/Sales
2020-11-10 BAR 61 Bank Account Redirect 0.0000 + 0 NO GL EFFECT
2020-11-10 AVB 62 Account Verification Bulk 0.0000 + 0 NO GL EFFECT
2020-11-10 PVC 63 Visa Click to Pay payment 0.0000 + 0 Debtors/Sales
2020-11-10 PVU 64 Visa CheckOut decline 0.0000 + 0 Debtors/Sales
2020-11-10 PVR 65 Visa Click to Pay refund 0.0000 + 0 Debtors/Sales
2020-11-10 PVD 66 Visa Click to Pay dispute 0.0000 + 0 Debtors/Sales
2020-11-10 PIR 67 iPay Recall 0.0000 + 0 Debtors/Sales
2020-11-10 PQR 68 MasterPass QR 0.0000 + 0 Debtors/Sales
2020-11-10 ELM 69 Electronic Mandate 0.0000 + 0 NO GL EFFECT
2020-11-10 PCD 70 Client Deposit 0.0000 + 0 Business Bank Account
2020-11-10 TDD 74 Two day invalid debit order 0.0000 + 0 Debtors/Sales
2020-11-10 SDD 75 Same day invalid debit order 0.0000 + 0 Debtors/Sales
2020-11-10 DRU 76 Rejected debit order 0.0000 + 0 Debtors/Sales
2020-11-10 CNC 77 Cashnet Control 0.0000 + 0 Debtors/Sales
2020-11-10 CBL 0 Closing Balance 0.0000 + 0

example of output indicating an unpaid transaction

<RetrieveMerchantStatement>
  <MethodParameters>
     <String>
             2020-11-10    OBL    0    Opening Balance    -115.8000    +    0    
             2020-11-10    CRU    1706180    Creditor Payment Return    -Code:26    1.0000    -    0    Creditors
             2020-11-10    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 below
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
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 below
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 any
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 like i.e. an invoice or customer number etc in these fields
Accounting ledger description General Ledger description for mapping and import into external accounting system

Netcash statement integration

Suggested Reconciliation

The mapping below is aimed at mapping the Sage Bank Manager product but the same methodology can be applied to any accounting system

Initial Mapping setup

Netcash will provide a blank statement template for initial mapping setup of the Sage Bank Manager product in Sage Accounting
This template will have R0.00 values in the amount field.
For the purpose of the mapping import, the following fields will display in the Sage Bank Manager for mapping:

  • Sage Bank Manager “Statement reference” = Netcash “Ledger Account” column
  • Sage Bank Manager “GL Description” = Netcash “Description” column
  • The Netcash “Ledger Account” field is a naming convention used in Sage Products, 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. This field contains acronyms for Netcash transactions.

Actual Statement importing

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

  • Sage Bank Manager date field = Netcash date field
  • Sage Bank Manager Statement Description = Netcash “Description”.
  • Mapping Type Field = Determine whether there is an entry in the Extra 1 field.
  • No entry = then entry type is “G”
  • Entry = Determine whether it is a supplier or customer transaction and allocate “S” or “C”, 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 Sage Bank Manager 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 Sage Bank Manager 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 (see tips for reconciliation below)

Table 1

Account service
Debit order service
Salary payment service
Creditor payment service
Pay Now service
Risk Report service

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

Account service

Transaction code Transaction description Ledger Account
OBL Opening balance No GL effect
CBL Closing balance No GL effect
DTT Deposit Received Business Bank account
DTR Deposit Return Business Bank account
NSF Service fee Netcash fees (service fees)
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 by Merchant 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 Netcash Bank Account
IST Inter-system transfer Netcash Bank Account
BDW Bad Debt Write-Off No GL effect
IPR Interest paid to Netcash reversal Interest Paid
IRR Interest paid to Merchants reversal Interest received
REB Rebate Debtors
BAR Bank Account Redirect No GL effect
ELM Electronic Mandate No GL effect
USI Unallocated Statement Transaction In No GL effect
USO Unallocated Statement Transaction Out No GL effect
INS Interest swept No GL effect
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
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
TOP

 

 

 

Creditor payment service

Transaction code Transaction description Ledger Account
CRP Same day creditor payment Creditors
CRU Creditor payment return Creditors
DCP Dated creditor payment Creditors
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 CheckOut Payment Debtors/Sales
PVU Visa CheckOut Decline Debtors/Sales
PVR Visa CheckOut Refund Debtors/Sales
PVD Visa CheckOut 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

 

 

 

Risk Report 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

Accounting entry guidelines

This document is a guideline to use when determining how you as a merchant could generate accounting entries, when importing the Statement download from your Netcash account. Please note that it is only a guide and is used at your own discretion.

Reconciliation tips

It is highly advisable to:

  1. auto / schedule a download -and reconcile your Netcash statement on a daily basis at 08h30 every day as manual processing of entries received by Netcash during the previous 24 hours, which Netcash could not automatically reconcile from the banking system; will only be available at 08h30 daily.
  2. When receiving electronic funds transfer (EFT) / internet bank payments to your Netcash statement from your customer/s ensure that;
    1. your customer uses the correct EFT payment reference
      1. EFT payments that does not have the correct payment reference as supplied by Netcash, will still appear on your Netcash statement but will not be auto allocated to the debtor based on the statement allocation parameters. You will have to manually allocate the transaction.
    2. each Netcash merchant account has a dedicated Merchantile bank account linked to it, thus payments with the incorrect reference will still appear in the account.
    3. your client does not pay cash -or cheques into the Netcash account/s as such may levy an additional charge on your Netcash statement for cash deposit -or special clearance fees.

Suggested business rules for processing debit orders

  1. when it comes to debit order transactions;
    1. You may auto resubmit a failed payment (DRU) on the following conditions:
      1. You have a valid debit order mandate authorizing you to resubmit the transaction for payment
      2. The said transaction has not returned more than twice (2) on code [02]
      3. The transaction has not returned for any other code but [02]
    2. Should the transaction return (DRU)
      1. more than twice (2) on code [02] -or
      2. returns on any other unpaid code except [02] –
        a new mandate from your customer is required as Netcash will block the transaction line since the current mandate has then expired.
        See unpaid code descriptions

Transaction Types and Associated General Ledger Transactions

There are five types of transactions which can occur 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.

Accounting entries

The possible accounting entries that you may want to generate from these transactions types, together with a recommended GL Account will be illustrated in this document. In our suggested accounting setup it is imperative that you set up your Netcash account as a “Bank Account” and as such reconcile it as you would any other 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 the Netcash related transaction would be as follows:

  • Netcash Bank Account. We suggest that you 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 you to transact 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 relevant income for which you are debiting.
  • 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 each one of your creditors.
  • Salaries account for when you pay salaries via Netcash.

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.

Version 2020.1

Copyright © 2020 Netcash (PTY) Ltd