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.
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
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;
- your customer uses the correct EFT payment reference
- 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.
- 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.
- 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.
- your customer uses the correct EFT payment reference
Suggested business rules for processing debit orders
- when it comes to debit order transactions;
- You may auto resubmit a failed payment (DRU) on the following conditions:
- You have a valid debit order mandate authorizing you to resubmit the transaction for payment
- The said transaction has not returned more than twice (2) on code [02]
- The transaction has not returned for any other code but [02]
- Should the transaction return (DRU)
- more than twice (2) on code [02] -or
- 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
- You may auto resubmit a failed payment (DRU) on the following conditions:
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
Version 2020.1
Copyright © 2021 Netcash (PTY) Ltd