User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
how_does_the_file_upload_system_work [2017/09/11 07:23]
Schuzelle van Wyk [Reports]
how_does_the_file_upload_system_work [2019/07/17 11:27] (current)
Schuzelle van Wyk
Line 1: Line 1:
 ====== How does the File Upload system work? ====== ====== How does the File Upload system work? ======
-The File Upload system is a web-based ​debit order system ​where you load your debit order files to be processed. Direct Debit provides you with login (user code and password) where you can upload your debit order batch file to the system ​for processing ​(csv file formats). After processing, reconciliation is provided in report form which includes submitted report, rejection report, unpaid report and repayment reports for your convenience. The account verification service is as well as check digit verification is done using this debit order system.+The debit order file upload ​system ​allows ​you to upload ​a file or to create a file for manual ​processing.
-===== Dashboard =====+The File Upload system is a web-based debit order system where you load your debit order files to be processed. Direct Debit provides you with a login (user code and password) where you can upload your debit order batch file to the system for processing (formats accepted include .csv, .xlsx and .xls). ​ As part of this system, we also include on-screen capturing if you prefer not to submit an excel sheet for processing.
-==== Uploading a file ==== +The account verification (AVS) is also submitted through this system.
-When uploading a file, you will need to select the service type which is either a 2-day debit or same day debit and the action date for your file to be processed.+
-==== Validating ​a file ==== +After processing, reconciliation is provided in report form which includes processed report, unpaid report, dispute report, rejection report, financial summary, repayment report and bank report for your convenience.  
-When validating ​a file, you will ensure that the transaction does pass the CDV checks.+ 
 +**Uploading ​a file** 
 +  * Click on **Upload Batch** in menu. 
 +  * Choose ​a file to upload. The formats accepted are .csv.xlsx  or .xls.  
 +  * Click on the formats to see what it looks like in the file if you are unsure (system ​will generate a csv, xlsx or xls file with test data in file). 
 +  * Click on Upload. 
 +  * The system will first validate the transactions to ensure that the account number and branch code is valid through ​CDV checks. If the transaction is invalid the sytem will let you know with the reason for it being invalid. 
 +  * You will be able to change the details on screen and then click on Save once you are happy and then Submit. 
 +**Creating a File** 
 +  * Click on **Create Batch**. 
 +  * Complete the details of the transaction on screen (you can add multiple clients on screen). 
 +  * The system will validate transactions as you capture them on screen. 
 +  * Click on Save once you are happy and then Submit.  
 +**Submitting a file** 
 +  * Once transactions are all valid you can click on Submit. 
 +  * On the submit screen, we provide you with a summary of the batch you are about to submit. You will also need to select two day, same day or NAEDO and add the action date which the debits need to be processed for. 
 +  * Click on Submit. The file has successfully been submitted to the system for processing.
-==== Reports ==== 
-=== Processed Transaction Report === 
-The processed transaction report displays all of the transactions processed between specific action dates or per batch number. 
-=== Unpaid Transaction Report === 
-The unpaid transaction report displays all of the transactions that return an unpaid code between specific action dates/​unpaid dates with an option of sorting the transactions per unpaid reason. ​ 
-=== Rejected Transaction Report === 
-The rejected transaction report displays transactions rejected due to account details entered incorrectly which do not pass CDV, for example invalid account number or branch account. The rejected transaction report also displays critical/​non-critical unpaids as these transactions are rejected until they are reinstated. 
-=== Critical/​Non-critical Unpaid Report === 
-The critical/​non-critical unpaid report displays accounts that are critically unpaid for previously unpaid reasons like no authority to debit or stop payment. The report also displays accounts that are non-critically unpaid which will occur if the account has been unpaid twice in a three month period. ​ 
-=== Dispute Report === 
-The dispute report displays accounts that have the following reversal codes: 
--No Authority to debit 
--Debit in contravention of mandate 
--Authorisation cancelled 
--Stopped via stop payment 
how_does_the_file_upload_system_work.1505114602.txt.gz · Last modified: 2017/09/11 07:23 by Schuzelle van Wyk