Natwest automatic debit order upload and confirmation download

You can now automatically upload created Debit Order Collection files to Natwest and once the Confirmation files are available this can automatically be retrieved from Natwest and processed on Finworks.

Setup

There are two new jobs available on System -> Jobs called:

  1. Natwest ISO 20022 Debit Order Upload Job (to upload the debit order collection files to Natwest)
  2. Natwest ISO 20022 Debit Order Download Job (to download confirmation files from Natwest).

Both these jobs must be scheduled. We recommend that they are scheduled to run hourly, so that if a new debit order batch is created, within the next hour it will then be sent to Natwest.

The following also needs to be in place for this to work:

  1. The Company on Finworks that owns the bank account where money will go to when the debit order is collected (the deposit account for the relevant product) must have the following data populated:
    1. Postal Address must have a City and two lines of the address must be populated.
    2. SEPA Creditor Identifier
  2. The same bank account must also have the following information captured on Finworks:
    1. International Bank Account Number
    2. SWIFT Code
  3. The investor whose bank account is debited, must have two Residential address lines populated.
  4. On System -> Configuration -> more actions -> External Systems the following fields in the Banking Integration – ISO20022 section must be populated:
    1. Customer id
    2. Organisation id

 

Creating Debit Order batches and sending to Natwest

You will create Debit Order batches as per normal, by navigating to Banking -> Debit Order Batches. Click on Create Debit Orders File. Select the instructions you want to include and under more actions select Create Batch. If you now return to the previous screen (Banking -> Debit Order Batches) you can search for the creation date of the debit order batch and the relevant batch will show with Status Created.

Now the scheduled Job will pickup any newly created Debit Order batches, and send it to Natwest automatically.

Once the Debit Order Collection File has been sent to Natwest, the batch status will change to Upload in Progress.

Once Natwest provides confirmation that the file is received, we will change the status to Upload Received.

 

Processing File Status Notification from Natwest

Natwest does an initial validation of the debit order batch submitted, and then responds with a File Status Notification. We receive this confirmation using the Natwest ISO 20022 Debit Order Download Job. The Job will show a confirmation file, name ending with .FS.xml:

 

And the Debit order batch status will update to Upload Received:

 

Processing Confirmations file from Natwest

Natwest will generate a Confirmations file once it knows the outcome of the debit order collections in the batch, and the scheduled Natwest ISO 20022 Debit Order Download Job will check for confirmation files as per the Job Schedule. This file received from Natwest, will have a file name ending with PS.xml (Payment Status Notification).

 

 

Whether it’s the Payment Status Notification or the File Status Notification, these results can be viewed by navigating to the Natwest ISO 20022 Debit Order Download Job (System -> Jobs) and under more actions click on Job Runs. The Job runs will show each attempt of Finworks to fetch a confirmation file from Natwest, and since there won’t always be a new confirmation file to fetch, the results will sometimes show status Completed Successfully, with nothing showing under “Number of Confirmation Files”.  When we did fetch a new Confirmation File from Natwest, “Number of Confirmation Files” will have a number with a hyperlink to the file received.

 

As soon as a confirmation file is available for an automatically uploaded Debit Order Collection file, we will automatically fetch the Confirmations file and update the Debit Orders in that batch. Note at this stage we can’t confirm that the money will successfully be received from the investor, we can just confirm that Natwest has successfully initiated a debit order collection (at which stage the status of the Debit Order will be Upload Confirmed) or Natwest has already rejected the debit order collection (at which stage the status of the Debit Order will be Declined). If the Debit Order collection fails at a later stage because the investor doesn’t have enough money in their bank account for example, this won’t be reflected yet at this stage.

You can view these results by navigating to Banking -> Debit Order History.

Possible statuses and their meanings are as follows:

  1. Created (which means the file has been sent to Natwest but we don’t have confirmation from Natwest that it’s been received yet)
  2. Upload Confirmed (which means we’ve successfully received a Confirmations file from Natwest)
  3. Declined (which means the Confirmations file has indicated a specific debit order has been declined)
Importing Bank Statement

Only when a Bank Statement is imported into Finworks and the debit order matched, can we truly say that a Debit Order was successful. At this stage, the debit order status will change to Collected.

 

 

Also see NatWest debit order reversal download file

 

 

Last Updated on 2 days ago by Antoinette Van Meyeren