Currently set to No Index
Currently set to No Follow
  1. Home
  2. /
  3. Value added services
  4. /
  5. Netcash Bulk Statement

Overview

The Netcash Bulk Statement is a consolidated file of daily client statements.

The client elects to have the Netcash statement downloaded to a central point for integration into a software product. This service only applies to Netcash ISV‘s.

The Netcash system determines all the client accounts to be included in the bulk statement, extracts the daily statement, concatenates all the statements into a single file that is zipped, and transferred to a pre-defined ISV location.

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

Statement format

The file is a tab-delimited text file which is zipped and sent via sFTP to the relevant external location.

The file contains a daily statement for each client configured for the download. This is set up on the Netcash web front-end under the NetConnector client profile.

Each client statement in the file is defined by a “client statement header and footer”. The file is bound by a “bulk statement file header and footer”.

File layout

File header

Occurs once at the start of the file

Field Name Type Value
1 Record identifier A FH
2 File date N CCYYMMDD (same date as the transactions in the file)
3 Software Vendor Key AN The key issued by Netcash to identify the software origin of transactions. (only used by Netcash ISV‘s)

Statement header

Occurs multiple times at the start of each client statement

Field Name Type Value
1 Record identifier A SH
2 Statement date N CCYYMMDD (same date as the transactions in the file)
3 Account number N The Netcash account number for the client
4 Account service key AN The client’s Netcash account service key

Statement detail

Field Name Type Value
1 Transaction date AN CCYYMMDD
2 Transaction type A See table below
3 Transaction id N Unique Netcash reference
4 Description AN Short description of the transaction
5 Amount N Transaction amount in cents
6 Symbol AN Positive/Negative
7 VAT N VAT amount
8 Extra 1 AN User-defined data received in upload file
9 Extra 2 AN User-defined data received in upload file
10 Extra 3 AN User-defined data received in upload file

Statement footer

Occurs multiple times at the end of each client statement

Field Name Type Value
1 Record identifier A SF
2 End of statement indicator AN 9999

File footer

Occurs once at the end of the file

Field Name Type Value
1 Record identifier A FF
2 End of file indicator AN #END#

Example

FH	2020-06-07	6224sxa-6068-4c29-85vcc-657xy111624a
SH	2020-06-07	51200000679	58c0000e-00a00-4243-a49d-998ec94dxxxx
2020-06-07	OBL	0	Opening Balance	1578685.24	+	0			
2020-06-07	CBL	0	Closing Balance	1578685.24	+	0			
SF	9999
SH	2020-06-07	51400000431	950b0000-re33-4d31-948f-0a0d4093xxxx
2020-06-07	OBL	0	Opening Balance	.00	+	0			
2020-06-07	CBL	0	Closing Balance	.00	+	0			
SF	9999
SH	2020-06-07	51400000632	d31abce8-d7fb-4xxw-8a9e-f1a755fexxxx
2020-06-07	OBL	0	Opening Balance	2971.40	+	0			
2020-06-07	PNA	102345887	THERESA MOTHER  181810	.00	+	0	0	https://www.somewebsite.com/weborder1
2020-06-07	PNA	102345889	JOE BLACK  181810	.00	+	0	0	https://www.somewebsite.com/weborder2
2020-06-07	PNU	102345625	JACK SLYME  181810	.00	+	0	0	https://www.somewebsite.com/weborder3
2020-06-07	PNU	102345626	THE POPE  181810	.00	+	0	0	https://www.somewebsite.com/weborder4
2020-06-07	CBL	0	Closing Balance	2971.40	+	0			
SF	9999
SH	2020-06-07	51400000623	7d544057-2xcb-4x96-9467-5651ca71xxxx
2020-06-07	OBL	0	Opening Balance	.00	+	0			
2020-06-07	CBL	0	Closing Balance	.00	+	0			
SF	9999
SH	2020-06-07	51487000002	944ss068-b18e-4w32-bd94-cd39f181xxxx
2020-06-07	OBL	0	Opening Balance	3958.12	+	0			
2020-06-07	DRU	102345226	20190502 - Maluleke C - Code: 2	761.00	-	0			
2020-06-07	CBL	0	Closing Balance	3197.12	+	0			
SF	9999
SH	2020-06-07	52290000033	8f42d4674-24ab-43xx-980b-bd9da017xxxx
2020-06-07	OBL	0	Opening Balance	501114.77	+	0			
2020-06-07	PNA	104177304	OAMI Credit	.00	+	0	5343	348762	OAMI
2020-06-07	PNA	104177305	OAMI Credit	.00	+	0	5343	348763	OAMI
2020-06-07	PNA	104177306	OAMI Credit	.00	+	0	5343	348764	OAMI
2020-06-07	PIA	104177324	OAMI Credit	.00	+	0	5792008	348766	OAMI
2020-06-07	PNA	104177681	OAMI Credit	.00	+	0	5794429	348767	OAMI
2020-06-07	PIA	104178490	OAMI Credit	.00	+	0	5792008	348770	OAMI
2020-06-07	PIA	104178492	OAMI Credit	.00	+	0	5798305	348771	OAMI
2020-06-07	PNA	104178499	OAMI Credit	.00	+	0	5794299	348772	OAMI
2020-06-07	PIA	104178501	OAMI Credit	.00	+	0	19095	348773	OAMI
2020-06-07	PNA	104178504	OAMI Credit	.00	+	0	5343	348774	OAMI
2020-06-07	PNA	102345865	OAMI Credit	.00	+	0	5785752	349044	OAMI
2020-06-07	PNA	102345881	Prepaid Electricity	.00	+	0	07062222216	24526102	0845222250
2020-06-07	PNA	102345909	Prepaid Electricity	.00	+	0	07142222250	24526168	0822222207
2020-06-07	PIA	102345911	OAMI Credit	.00	+	0	5791487	349046	OAMI
2020-06-07	PNA	102345918	Prepaid Electricity	.00	+	0	07122222250	24526190	0828522227
2020-06-07	PNA	102345921	OAMI Credit	.00	+	0	20243	349047	OAMI
2020-06-07	PNA	102345924	OAMI Credit	.00	+	0	5789491	349048	OAMI
2020-06-07	CBL	0	Closing Balance	544396.77	+	0			
SF	9999
SH	2020-06-07	52600000336	der5t30a-bd2d-4b5a-ba12-2f3bwwbdxxxx
2020-06-07	OBL	0	Opening Balance	592040.39	+	0			
2020-06-07	DRU	102345731	21MED1000029 - MEDICALL - Code: 30	1434.00	-	0			
2020-06-07	DRU	102345580	21MED1000056 - MEDICALL - Code: 2	1033.00	-	0			
2020-06-07	DRU	102345594	15MED0224450 - MEDICALL - Code: 2	2294.00	-	0			
2020-06-07	DRU	102345509	20MED1000566 - MEDICALL - Code: 2	1233.00	-	0			
2020-06-07	CBL	0	Closing Balance	586046.39	+	0			
SF	9999
SH	2020-06-07	53100000812	2208usr0a4-8894-4dda-acc7-a76sr25bxxxx
2020-06-07	OBL	0	Opening Balance	2985682.74	+	0			
2020-06-07	DRU	102345768	WHMCS_53092 - PIET POMPIES - Code: 2	719.10	-	0	975869	719.10	THE_DEBIT_20200605_09.DEBITBATCH
2020-06-07	CBL	0	Closing Balance	2984963.64	+	0			
SF	9999
SH	2020-06-07	510011111412	fd8i29af-9e4c-4259-8dw6-e24cbac9xxxx
2020-06-07	OBL	0	Opening Balance	325195.63	+	0			
2020-06-07	DRU	102345754	OLAB04 - Z Olivier - Code: 2	1044.00	-	0			
2020-06-07	DRU	102345756	ANCD01 - P Rodrigues - Code: 2	1699.00	-	0			
2020-06-07	DRU	102345678	SEFG07 - SD Shange - Code: 2	3131.00	-	0			
2020-06-07	DRU	102345582	NHIJ02 - W Mathebula - Code: 2	544.00	-	0			
2020-06-07	DRU	102345589	MAKL09 - XX Harmse - Code: 2	544.00	-	0			
2020-06-07	DRU	102345617	NICMN1 - B De Beer - Code: 2	399.00	-	0			
2020-06-07	DRU	102345627	DAROP4 - DHJ Snyman - Code: 2	1257.00	-	0			
2020-06-07	DRU	102345628	BLQQ02 - A Ngwerume - Code: 2	734.00	-	0			
2020-06-07	DRU	102345649	SWS002 - U Swanepoel - Code: 2	2088.00	-	0			
2020-06-07	DRU	102345341	BOTU07 - LL Botes - Code: 2	499.00	-	0			
2020-06-07	DRU	102345355	ZUVW01 - K Jeffries - Code: 2	944.00	-	0			
2020-06-07	DRU	102345372	AXY015 - W Maartens - Code: 2	1798.00	-	0			
2020-06-07	DRU	102345407	RZZ006 - A Morrison - Code: 2	632.00	-	0			
2020-06-07	DRU	102345518	SQA015 - Export and Transport - Code: 2	1244.00	-	0			
2020-06-07	CBL	0	Closing Balance	308638.63	+	0			
SF	9999
SH	2020-06-07	51003981319	2e80bcb9-e17d-44b0-a65d-154715d71618
2020-06-07	OBL	0	Opening Balance	.00	+	0			
2020-06-07	CBL	0	Closing Balance	.00	+	0			
SF	9999
SH	2020-06-07	51215120128	94c7e9d8-d208-4b4d-ae89-355155204a9c
2020-06-07	OBL	0	Opening Balance	11600.20	+	0			
2020-06-07	PNA	102345380	Goods Purchased - Pieter	.00	+	0	A71XXED2	951abcba-d5b0-47ss-b791-aa2f09c0xxxx	
2020-06-07	PNA	102345460	Goods Purchased - Phuti 	.00	+	0	A76FBF6C	979sdfge-9c46-4a14-bdea-05f0f788xxxx	
2020-06-07	PIA	102345780	Goods Purchased -  Rex	.00	+	0	9664FE11	26dese68-32ee-4c58-976e-q2310bb84xxxx	
2020-06-07	PIS	102345458	Goods Purchased -  Rex	1080.00	+	0	9664FE11	26dese68-32ee-4c58-976e-x2310bb8xxxx	
2020-06-07	PNC	102345380	Goods Purchased - Pieter	495.00	+	0	A71XXED2	951abcba-d5ss-47c6-b791-aa2f09c0xxxx	
2020-06-07	PNC	102345406	Goods Purchased - Phuti 	720.00	+	0	A76FBF6C	979sdfge-9c46-4a14-bdea-05f0f788x	
2020-06-07	CBL	0	Closing Balance	13895.20	+	0			
SF	9999
SH	2020-06-07	5270xxx4545	e57xx066-cfcd-4ab3-bxx3-abf128dxxxxx
2020-06-07	OBL	0	Opening Balance	10.52	+	0			
2020-06-07	CBL	0	Closing Balance	10.52	+	0			
SF	9999
FF	#END#

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 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 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 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
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 Pay Now Retail payment Debtors/Sales
PNQ Pay Now Retail payment return Debtors/Sales
PNM Pay Now MasterPass™ payment Debtors/Sales
PNW Pay Now MasterPass™ unpaid Debtors/Sales
PNE Pay Now EFT payment Debtors/Sales
PNZ Pay Now EFT return Debtors/Sales
PNA Pay Now Credit Card authorize Debtors/Sales
PNC Pay Now Credit Card payment Debtors/Sales
PNU Pay Now Credit Card declined Debtors/Sales
PND Pay Now Credit Card dispute Debtors/Sales
PNR Pay Now Credit Card refund Debtors/Sales
PIA iPay Auth Debtors/Sales
PIS iPay Success Debtors/Sales
PIF iPay Failure 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
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 © 2021 Netcash (PTY) Ltd