Netcash Bulk Statement - Netcash

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:

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

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