Reports

Estimated reading: 12 minutes 1141 views

Index

Debit batch reports

Batches that have been authorised will appear in the batch report menu after the cut-off time for that service, to obtain your batch report:

Click on Services.
Click on Debit orders from the dropdown menu.
Click on Reports > Debit batch reports.
A list of processed batches will appear.
Click on the Printer to the left of the batch to obtain a report.
Choose the Format you require and Download.

The report also lists all of the transactions processed in the batch. If the client’s details are shown in black this means that up to the time of viewing the report, Netcash has had no notification from the banks that the transaction has been unsuccessful.

Transaction details are shown in red means that the collection of the debit order has not been successful. The reason for the failure is indicated by the code which appears after the client’s name.

For additional information please see below:

To view additional information on your batch, click on View batch detail report.
Export in the required format.

The above batch detail report provides the following information:

Date authorized
Who authorized the batch
Action Date
Settlement date – the date on which the retention amounts are due
No transactions submitted
Value of the batch
Number of unpaid transactions
Value of unpaid transactions
Percentage of unpaid transactions

Note: Just because a transaction is not showing as unpaid when checking the batch, this does not mean that it might not still be returned at a later stage. Although Netcash normally receives the notification of the majority of unpaid transactions within 4 days of the batch being processed, it is always possible that the client disputes a transaction well after this and it is returned by the bank. Netcash is not responsible for the transactions being unpaid. We are only a third-party payment provider and report the information supplied to us by the bank. Should, for example, a transaction be returned due to insufficient funds and the client is adamant that there was money in the account, it will be necessary for that client to contact their bank to resolve the matter.

To view the surety and unpaid retention with release dates per debit batch report click on the download button. Please note that retentions may differ at the date of release due to unpaids being returned to your Netcash account.

Deleted batches

Select Services > Debit orders > Reports > Deleted Debit batches.

This screen displays batches that have been deleted and that were never processed as well as any entries that have been deleted from a batch.

Tick the block in the Select column next to each batch that needs to be deleted then click on the Delete button. Please note that only batches that are not authorised may be deleted.

Audit reports

The Masterfile audit report allows viewing which clients have been created, edited or duplicated in your Masterfile.

Click on Services > Debit orders
Click on Reports > Audit report
Select the date range
Select the Result type and click on Submit
A list of clients will be displayed that conform to your request, click on the Pencil to the left of the client to view audit detail

Note: If you are uploading debit batches the system is unable to determine which user made the change and consequently File upload will be displayed in the Changed by column.

Unpaid reports

The Unpaid report allows you to monitor and manage unpaid clients on your Netcash account.

Total unpaids:

Click on Services
Click on Debit orders from the dropdown menu
Click on Reports > Unpaid reports, Total unpaids
Select the From date and insert the Unpaid count
Click on Show Report

Consecutive unpaids:

Click on Services
Click on Debit orders from the dropdown menu
Click on Reports > Consecutive unpaids
Select the Date range
Click on Submit

A report can be generated based on the number of unpaid transactions over a specific period. This provides useful information on which clients need to be monitored and the cost implications of their unpaid transactions.

Statistics

Batch statistics reflect the volume of transactions processed on your account and, using the percentage of unpaids, calculate the average unpaid percentage on your account. This will give you an idea of how successful your debit order collections are and will allow Netcash to calculate the percentages required for Unpaid retention.

Click on Services
Click on Debit orders from the dropdown menu
Click on Reports > Statistics

Blocked accounts

This report displays a list of account numbers blocked by Netcash based on the unpaid reason code.

These debit orders are not submitted to the bank for collection and attract avoidable processing fees. These transactions should be removed from your debit order batches together with future transactions returned for the same reasons.

A few of the unpaid codes that would be blocked:

Account Closed
Account Transferred
Account Holder Deceased
No Such Account
Unpaid Consecutively

To access your blocked accounts:

Click on Service
Click on Debit orders
Click on Report > Block Accounts

Blocked account search options:

Search all –Search account numbers within a date range, by Amount or Description
Search specific- Search accounts by bank account number.
Steps to remove a blocked account (Code 60)
1. Obtain a new signed mandate from your client with updated banking details.
2. Submit the new mandate to your Account Manager at Netcash.
3. Mandate submitted to remove the blocked account (Code 60).
4. Once the code 60 has been lifted you can resubmit the debit order for processing.

Processing dates

This report displays when a debit batch needs to be authorised for a particular action date. Same day batches are to be authorised by 11 am on the action date and 2-day debit batches must be authorised by midnight 2 full working days prior to action date.

Select Services
Click on Debit orders from the dropdown menu
Click on Reports > Processing dates
A list of processing dates will be displayed including action date and presentation date. This list is continually updated

Unpaid codes

Select Services > Debit orders > Reports >Unpaid codes

All debit order accounts are validated prior to sending them into the banking system. By using this process customers can be confident that the receiving banks will accept the transaction.

However, debit orders are not guaranteed methods of payment. Whilst the account details may be valid, the transaction can still be returned by the account holder’s bank. Transactions returned in this manner are known as unpaid items or unpaid. The most common reason for returning a debit order is insufficient funds or not being provided for – this means that there was not enough money in the bank account to honour the debit order. In addition, there are several reasons why the transaction might not be successful. Some examples are listed below.

	Code Name	Description
02	Not provided for	There were insufficient funds in this account. Please contact the customer to make arrangements for alternative payment or arrange to process a double payment on the next batch run.
03	Debits are not allowed on this account	The customer’s account is a special savings account and cannot be debited. Kindly request the customer to provide alternative banking details account details or change the account to a Transmission Account.
04	Payment Stopped (by a/c holder)	Your customer has requested that payment be stopped and the debit order be reversed. Please contact your customer to query the Stop Payment. No further debit order instruction will run against this account until Stop Payment has been lifted.
06	Account Frozen (as in divorce, etc)	Your customer’s account has been frozen due to legal proceedings Please contact your customer to obtain alternative banking details. No further debit orders will be run against this account until legal proceedings have been completed.
08	Account in sequestration (private individual)	Your customer’s account has been frozen due to legal proceedings Please contact your customer to obtain alternative banking details as no further debit orders will be run against this account.
10	Account in liquidation (company)	Your customer’s account has been frozen due to legal proceedings Please contact your customer to obtain alternative banking details as no further debit orders will be run against this account.
12	Account closed (with no forwarding details)	Your customer’s account has been closed. Kindly contact your customer to obtain alternative banking details as no further debit orders can be run against this account.
14	Account transferred (within banking group)	Account transferred (within banking group)
16	Account transferred (to other banking groups)	Account transferred (to another banking group)
18	Account holder deceased	Your customer’s account has been closed as the account holder is deceased. Please obtain alternative banking details if the debit is to continue or contact the customers’ attorneys for settlement
22	Account effects not cleared	Your customers’ account had funds but these were not cleared in time for the debit order to be processed. Please contact your the customer to arrange manual payment or confirm when your debit order can be resubmitted
26	No such account	Your customers’ account may be invalid or has been closed. Please contact your customer to obtain alternative banking details.
28	Recall/Withdrawal	Your customer has requested a withdrawal of the debit order entry. Please contact your customer to clear up the dispute and re-submit if necessary.
30	No authority to debit / credit	Your customer has stopped payment of the debit order, allegedly due to you not having the authority to debit the account. Please contact your customer to resolve the dispute as no further debit orders will be submitted on this account until the stop payment is lifted.
32	Debit in contravention of the payer’s authority	Your customer has stopped payment of the debit order which allegedly is in contravention of the agreement entered into. Please contact your customer to resolve the dispute. No further debit orders can be submitted on this account until the stop payment is lifted.
34	Authorisation cancelled	Your customer has stopped payment on the debit order, and cancelled the authorisation. Please contact your customer to resolve the dispute as no further debit orders will be submitted on this account until stop payment is lifted.
36	Previously stopped via stop payment advice	Your customer has previously stopped payment of the debit order due to a dispute. Please contact your customer to resolve the dispute as no further debit orders will be submitted on this account until the stop payment is lifted.
50	Account Number Invalid	Your customer’s account is invalid. Please contact your customer to obtain alternative banking details.
51	Bank Recall	The bank has requested a recall on this debit order transaction entry. Please contact your customer to arrange a settlement and resubmit if necessary.
56	Not FICA compliant	This account is not FICA compliant and the bank will not allow any further transactions to this account until your customer complies with the requirements. Please make alternative arrangements for payment with your client.
57	Duplicate Reversal
60	Consecutive unpaid rejection	There have been consecutive unpaid transactions against this account number. Remove the transaction from all future batches.
81	Credit Card Token Error	This transaction has been declined because there is a likely error in the token. Please get a new token for this card number and then rerun the transaction.
82	Credit Card Declined – Please Call	This transaction has been declined because the bank needs a call to authorise the transaction. Please contact the customer and ask them to contact the bank with regards to the transaction and then rerun the transaction.
83	Credit Card Timeout	This transaction has timed out on the bank credit card switch but has not been declined. It has thus not reached the intended customer account. Please run this again in a new batch.
84	Credit Card Declined – Reported As Stolen	This transaction has been declined because the card has been reported stolen. Please contact the customer to get new details to process any additional transactions
85	Credit Card Declined – Account Closed	This transaction has been declined because the account has been closed. Please contact the customer to get new details to process any additional transactions
86	Credit Card Declined – Disputed by the cardholder	This transaction has been declined because it has been disputed by cardholder. Please contact the customer to get a new expiry date and process the transaction again.
87	Credit Card Declined – Invalid number	This transaction has been declined because it is an invalid card number. Please contact the customer to verify the details and process the transaction again.
88	Credit Card Declined – Expired	This transaction has been declined because the card has expired. Please contact the customer to get a new expiry date and process the transaction again.
89	Credit Card Declined	This transaction has been declined by the credit card company. Please contact the customer to make arrangements for alternative payment or arrange to process a double payment on the next batch run.
90	Non Possession of card	Gateway return with a reason of Non-Possession of the card is usually related to a return that was done because the card was used fraudulently.
145	An account failed the final validation	This is a credit payment error when an account fails the final validation but still exists in the system with incorrect details.

Search by transaction ID

This search function helps you to easily find the client’s debit order details if they provide you with the transaction ID number, this is a unique number allocated to every debit order that is processed.

The transaction ID number is displayed on your client’s bank statement next to your chosen abbreviated name.

Select Services
Click on Debit orders from the dropdown menu
Click on Reports > Search by transaction ID

Expired credit cards

A list of Debit Orders against credit cards will be displayed with the cards expiry date.

A new Debit Order Mandate should be signed, and the tokenised card data uploaded to your master file to replace the expired card detail.

These can be filtered by All , expired credit cards, expiring credit cards (Next 30 days).

Reports

Index

Debit batch reports

For additional information please see below:

The above batch detail report provides the following information:

Deleted batches

Audit reports

Unpaid reports

Consecutive unpaids:

Statistics

Blocked accounts

A few of the unpaid codes that would be blocked:

To access your blocked accounts:

Blocked account search options:

Processing dates

Unpaid codes

Search by transaction ID

Expired credit cards

Reports

CONTENTS