Skip to content

4 Final Transaction Information (FTI)

Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 63-75 PDF pages: 63-75

Q: What delivery methods are available for PTI on NetBank Business? A: Provisional transaction information is available via email on NetBank Business and can be sent in real time and/or near real time.

Q: Is pricing Volume Based? A: Yes, pricing can be tiered but pricing needs to be discussed with your transactional banker.

4.1 What is the FTI solution?

The Final Transaction Information (FTI) service offers you a statement in a machine -readable format of confirmed financial transactions that have been processed through your current or savings accounts. These confirmed transactions are extracted from your accounts, formatted and delivered to you as per your selected preferences. This file can be integrated directly into your line of business system allowing you the ability to automate the reconciliation of your bank statement.

Example: you will receive a file between 3am and 8am (client preference) of all confirmed financial transactions for the previous day, allowing your system to complete the ba nk recon and create an exception file of un-reconcilable items before your next business day starts.

4.2 Key features of FTI

A. Push of transactions

Daily confirmed transactions are pushed directly into your LOB systems using a secure delivery method (protocol).

B. Ease of reconciliation

Your LOB system extracts any relevant data for automated reconciliation process. Exception items can then be dealt with separately (eg where a reference used is not aligned with the formatting in your LOB system).

C. Multiple accounts

You can choose to receive one FTI file containing confirmed transactions for multiple accounts.

D. Delivery methods

You can choose between the following delivery methods:

  • Email
  • Web Services
  • IBM MQ
  • SWIFT
  • SFTP
  • Connect: Direct
  • SWIFT FileAct

E. Frequency of file delivery

You can choose to receive a file:

  • Daily
  • Weekly
  • Monthly

F. FTI file runs

In addition you can choose to receive files:

  • In the morning, containing all confirmed transactions for the previous day including the transactions processed overnight, ie 'normal run'
  • In the afternoon, containing all confirmed transactions for the previous day including transactions processed late, ie 'final run'
  • Or both, one file sent in the morning, containing all confirmed transactions for the previous day including the transactions processed overnight, ie 'normal run' one file sent in the afternoon, containing all confirmed transactions processed late and back dated. This file will only contain the transactions that were not included in the morning file , i.e. 'final run'.

G. File format

Multiple file formats are available eg SWIFT MT940, MT950 Please contact your Transactional Banker for available formats.

H. File resend

FTI has the ability to resend a file, once a day, to either the same delivery settings or to the alternate email address which was set up on the FTI instance.

I. Time preference

You can define the timeframe during which you want to receive FTI Transaction Information:

  • Normal Run - between 02:00 and 08:00
  • Final Run - between 14:00 and 20:00

J. Empty file

You can choose to receive and empty file, which means, should there be no activity on your account from the time of your last file, you will receive an empty file.

K. FTI Instances

An instance is a grouping of accounts and preferences. You have the option of setting up multiple instances to receive FTI. These Instances can be customised to receive data on specific accounts sent to specific delivery protocols.

Example: You can setup an instance and name it 'Host FTI'. This instance can then be customised to deliver Final Transaction Information via one of the Host delivery methods. A second instance can be setup and name it 'Email FTI'. This instance can be setup to receive Final Transaction Information via Email.

L. Adding new or maintaining FTI Instances

An Administrator who has self-maintenance on NetBank Business (NBB) can setup Final Transaction Information Instances. Should you choose to set up an instance on NBB, you can only select Email as your Delivery method. For all Host delivery methods, you may contact your Transactional Banker for assistance. If you don't have NBB, you may contact your Transactional Banker for assistance in adding or maintaining your instances.

4.3 Statement number

A. Single statement number

Each FTI file you receive will contain a single statement number per account. The statement numbers will start at 000001 and increment by 1 for every file sent. The statement number will reset every year ie, the first FTI file you receive in the New Year will start at 000001.

B. Nedbank CASA statement number

A new statement number is generated on the statement cycle date and / or for every 20 transactions processed on your account. The FTI file you receive will contain the statement number as per your official bank statement ie, the statement numbers will correspond with the final statements you view on NetBank Business or your estatements.

4.4 Benefits of FTI to your business

A. Improved reconciliation

Improved and timely reconciliation can be done.

B. Secure data transfer

Data is sent securely via a host connectivity protocol or encrypted email.

C. Direct FTI file

The FTI files are sent directly to your LOB system to minimise human intervention.

4.5 Benefits of Notifications to your business

This solution creates great value for your business by offering you the following benefits:

  • Enabling you to make informed decisions about your day-to-day operations
  • Reconciling your bank statements
  • Transaction tracking
  • Working capital management / forecasting
  • Inventory control / Goods dispatching
  • Fraud prevention / management
  • FTI sent directly to your line-of-business system
  • Greater customer satisfaction with the service rendered by you

4.6 Delivery protocol

Final transactions can be delivered by using a near real time delivery protocol. The following near real time delivery protocols are available for FTI:

  • Email (only delivery protocol available on NetBank Business)
  • SFTP (Host to host solution)
  • Connect: Direct (Host to host solution)
  • Swift FileAct (Host to host solution) See section 1.8 for more detail.

Note: Nedbank will only be able to connect to a public IP addresses.

4.7 FTI Template groups

A template groups contain a selection of templates that make a logical fit into a specific group eg any SWIFT proprietary template will be available under the SWIFT group. Currently the following groups are available:

  • Nedbank
  • SWIFT
  • SAP
  • Other
  • Client Specific

a) Available templates

  • Near real time
  • TI FTI XML
  • TI FTI CSV
  • TI FTI TXT
  • NedAcad 4 digit statement - 29 character statement narrative
  • NedAcad 6 digit statement - 27 character statement narrative
  • NedAcad 6 digit statement - 30 character statement narrative
  • NedAcad 4 digit single statement - 29 character statement narrative
  • NedAcad 6 digit single statement - 27 character statement narrative
  • NedAcad 6 digit single statement - 30 character statement narrative
  • TI SWIFT MT940
  • TI SWIFT MT950
  • NED SWIFT MT940
  • NED SWIFT MT950
  • TI SWIFT MX940 - camt.053 (Bank to customer statement)

  • TI SWIFT MX950 - camt.053 (Bank to customer statement)

  • Multicash AUSZUG

  • Multicash UMSATZ

Refer to 1.12 and Appendix B, D and E for detailed information on F TI templates

Note: If SWIFT has been selected as a delivery protocol only the SWIFT templates can be selected, however SWIFT templates can be sent on all delivery protocols.

4.8 Transaction codes Transaction Codes.xlsx

Transaction code NedAcad Transaction code C / D / RC / RD Indicator Vat Applicable ENC Applicable (Uncleared funds) Description 1301 101 C N Y Cheque or Mixed Deposit

Note: Non cash amount will accrue to effects not cleared 1302 102 C N N Cheque payment reversed 1303 103 C N N Interest Paid 1306 106 C / RC N N Reversal of a Debit transaction (Stop orders, auto transfers and cheque recall)

Note: Insufficient funds may attract an unpaid fee 1308 108 C N N Dividends or Stock or Share payments made by Nedbank 1309 109 C N Y Auto Transfer into your account from another Nedbank account subject to ENCs 1310 110 C N N Your cheque has been unpaid due to various reasons or Cheque deposits greater than industry regulated amounts authorised by the bank

Note: Need to check your narrative for additional information Can be accompanied by an unpaid fee 1311 111 C N N Cleared funds for cheque deposits 1313 113 C N N Interest paid on investments held at Nedbank 1316 116 C / RC N N Reversal of POS transaction or credit for prepaid vouchers 1317 117 C / RC N N Reversal of a Teller Debit Transaction

Note: Need to check your narrative for further information 1318 118 C N N Payment of Investment at maturity held with Nedbank 1319 119 C N N Electronic deposit 1321 121 C N N Cash Management transfers 1322 122 C N N Interest on investment 1323 123 C N N Stop order credit into your account 1324 124 C N N Electronic deposit into your account from another bank ie interbank EFT 1325 125 C N Y Additional cash or cheque deposit that was not on the

original deposit slip 1326 126 C N N Cleared Cheque deposit ie is not included in ENCs. Usually used for Salary and Pension Payments 1327 127 C / RC Y N Reversal of Bank Charges

Note: It will also reverse the VAT impact ie reduce your VAT declaration 1329 129 C N N Unpaid debit order.

Note: Insufficient funds may attract an unpaid fee 1330 130 C / RC N N Reversal of SASWITCH cash withdrawal or send iMali transactions if the cash is not redeemed within 7 days 1336 136 C N N Merchant settlement for POS devices or movement of funds from a card account to your transactional account 1340 140 C N N Used when net service fee is set of against credit interest paid (1923 = 2 on ACMC) 1342 142 C N N Auto Transfer into your account from another Nedbank account not subject to ENCs 1344,1345 144, 145 C / RC N N Reversal of a card purchase 1351 151 C N N Cash Deposit 1352 152 C N N Electronic deposit processed into your account by Nedbank 1353 153 C N N Interest paid on Cash Management 1359 159 C / RC N N ATM Reversal 1361 161 C Y Y Manual credit by bank check narritive 1364 164 C N N Electronic deposit 1365 165 C N N Electronic deposit for Salary 1366 166 C N N Cash Management sweeps 1390 190 C N N Cash Deposit (Using a Nedmatic Card at Teller) 1392 192 C N Y Uncleared deposit 1394 194 C N EFT Credit transferred from or into a closed account 1395 195 C N N EFT Credit into your account eg SWIFT and RTGS 1398 198 C N Y (zero amount so no impact) Non-financial information line on your statement

1335 ,1337 ,1338, 1341, 1355, 1367, 1369 - 1380, 1385 - 1389, 1391, 1396, 1399

135,137,138, 141,155, 167, 185 to 189, 191, 196, 199 C N Y Manual Credit into your account processed by the bank

Note: Need to check your narrative for further information 1304, 1305, 1307, 1312, 1314, 1315, 1320,1328, 1331 to 1334,

104,105,107, 112,114,115,1 20 C N N Manual Credit into your account processed by the bank

Note: Need to check your narrative for further

1339, 1343, 1346 to 1350, 1354, 1356 to 1358, 1360, 1362, 1363, 1368, 1381 to 1384, 1393, 1397 128,131 to 134, 139, 143, 146 to 150, 154, 156 to 158, 160, 162, 163, 168, 181 to 184, 193, 197 information 1401 201 D N N Electronic Debit (SWIFT payment eg RTGS) 1402 202 D N N Cheque Drawn or Encashed 1403 203 D N N EFT Payment or Transfer 1404 204 D N N Account Debit Interest on authorised overdrafts or excess balances 1405 205 D Y N Bank generated Service fee 1406 206 D Y N Manual debit processed by the bank.

Note: Need to check your narrative for further information 1407 207 D Y N Bank generated Service fee 1408 208 D N N Stop order 1409 209 D N N Unpaid cheques and returned debit orders 1410 210 D / RD N N Reversal 1411 211 D N N Authorised item ie, forced debit to your account if initially rejected due to an account status 1413 213 D Y N Bank fee for cheque book 1415 215 D Y N Bank fee for Safe Custody 1416 216 D N N POS purchase and/or POS cash withdrawal 1419 219 D N N Electronic Transfer ie payment from a Nedbank account to another Nedbank account on the same profile 1420 220 D N N ATM card withdrawal 1421 221 D N N Debit order (Internal) 1422 222 D Y N Bank Fee for deposit book 1423 223 D N N Stop order 1424 , 1425 224, 225 D Y N Debit order (External) 1426 226 D N N Shortfall cash or cheque deposit that was not on the original deposit slip 1427 227 D Y N Bank fee 1428 228 D N N Bank fee to recover legal costs 1429 229 D / RD N N Reversal of a debit order collection 1430 230 D N N Cheque payment greater than industry regulated amounts authorised by the bank 1431 231 D N N Purchase of Forex. Outward telegraphic transfers (Electronic Payment from South Africa to another monetary area)

1433 233 D N N EFT Debit transferred from or into a closed account 1435 235 D Y N Bank fee for Cash deposits 1436 236 D N N POS purchase 1437 237 D N N Electronic debit processed by the bank 1438 238 D N N Stop order reversal 1439 239 D N N Unpaid cheque due to technical reasons 1440 240 D Y N Bank Charge for setoff against interest if applicable 1441 241 D N N Debit order (internal) 1442 242 D N N Automatic Transfer of funds between accounts Debit order for Nedfleet 1443 243 D Y N Bank charge for overdraft facilities 1444 244 D N N Unpaid cheque due to technical reason (Nontransferable) 1445 245 D Y N Manual debit processed by the bank.

Note: Need to check your narrative for further information 1446 246 D N N Internal debit order processed by Nedbank Vehicle Asset Finance(VAF) or fleet management

Note: This trancode is only posted in final run 1447 247 D N N Correction of overstated cheque deposit

Note: Compare the credit trancode for a understated cheque deposit 1450 250 D / RD N N Reversal of Teller Cash Deposit Reversal of CPS debit order collections 1451 251 D N N Cash Withdrawals and Banks own cheque Teller Transfer (From any Nedbank account to any Nedbank account irrespective of product eg CASA to credit card) 1452 252 D N N Electronic payment or transfer into a Nedbank home loan, Vehicle Asset Finance (VAF) or investment account 1454 254 D Y N Manual debit processed by the bank.

Note: Need to check your narrative for further information 1455 255 D / RD N N Reversal of a cheque deposit due to physical cheque not being present or if the code line of cheque failing validation 1456 256 D N N Debit interest posted by current accounts when account moves into

Cashman 1457, 1476, 1492, 1497 257, 276, 292, 297 D Y N Bank Fees 1460 260 D N N Debit order (Internal) 1461 261 D Y N Manual debit processed by the bank.

Note: Need to check your narrative for further information 1463 263 D N N Transfer to a Justsave account 1464,1465 264, 265 D N N Electronic payment 1466 266 D N N Cash management auto transfer 1468 268 D N N Debit order (External) 1469 269 D N N Unpaid Cheque (Technical reason - post-dated) 1473 273 D Y N Manual debit processed by the bank.

Note: Need to check your narrative for further information 1476 276 D Y N Manual debit processed by the bank.

Note: Need to check your narrative for further information 1479 279 D N N Bank Fee (VAT exempt currency conversion fee) 1481 281 D Y N Manual debit processed by the bank.

Note: Need to check your narrative for further information 1485 285 D Y N Manual debit processed by the bank.

Note: Need to check your narrative for further information 1486 286 D Y N Bank Fee for unpaids 1487 287 D Y N Manual debit processed by the bank.

Note: Need to check your narrative for further information 1490 290 D N N Cash withdrawal with Nedmatic card 1491 291 D Y N Manual debit processed by the bank.

Note: Need to check your narrative for further information 1492 292 D Y N Manual debit processed by the bank.

Note: Need to check your narrative for further information 1493 293 D N N Debit order (External AEDOS) 1495 295 D N N Prepaid Purchase (cellphone top-ups at ATM) 1496 296 D Y N Manual debit processed by the bank.

Note: Need to check your

narrative for further information 1497 297 D Y N Manual debit processed by the bank.

Note: Need to check your narrative for further information 1498 298 D N N Interest paid (Debited from Cash Management) 1412, 1414, 1417, 1418, 1432, 1434, 1445, 1448, 1449, 1453, 1454, 1458,1459,14 61 1462, 1470 to 1475, 1477, 1478, 1480 to 1485, 1487 to 1489, 1491, 1494, 1496, 1499 212, 214, 217, 218, 232, 234, 245, 248, 249, 253, 254, 258,259, 261,262, 270 to 275, 277, 278, 280 to 285, 287 to 289, 291, 294, 296, 299 D N N Manual Debit processed on your account by the bank

Note: Need to check your narrative for further information C = Credit; RC = Reversal of Credit; D = Debit; RD = Reversal of Debit

4.9 Adding or maintaining FTI instances

FTI instances can be added or maintained electronically (for the email delivery protocol only) or via maintenance request forms submitted to the bank. a) An administrator who has self-maintenance on NetBank Business that can set up and maintain FTI instances electronically for email delivery protocol, available on NBB under the Admin > Transaction Information Settings > Final Transaction Information menu items.

b) Clients who do not have NetBank Business can add or maintain instances by

completing and submitting a new application or maintenance form. The following maintenance forms are available on NetBank Business or via the helpdesk:

  • MR5D: Profile settings

To add the FTI product to an existing profile.

  • MRTIFTI1: Add Nedbank account same legal entity

Add a same legal entity account on to your existing FTI instances. Please note, an account has to be on your profile before it can be added to an instance. If the requested accounts are currently not on your profile it will be added to your profile.

  • MRTIFTI2: Add Nedbank account other legal entity

Add another legal entity account on to your existing FTI instances. Please note, an account has to be on your profile before it can be added to an instance. If the requested accounts are currently not on your profile, a participant resolution or power of attorney will be required.

  • MRTIPTI5A: Add Final Transaction Information instance

Add a new FTI instance to an existing profile for email or SWIFT protocols only. This form can only be used, if the FTI product is already activated on the profile. To activate the product please complete the MR5D. For all other protocols please speak to your transactional banker.

  • MRTIFTI5B: Amend /Delete Final Transaction Information instance

To amend the settings or delete an existing FTI instance. Please note you cannot amend / delete accounts, delivery protocol or templates on existing instances using this maintenance request. You will need to complete the MRTIFTI8 to delete an account. To update protocols or templates, please speak to your transactional banker.

  • MRTIFTI6: Charge detail amendment

To amend your nominated charge accounts for the FTI product.

  • MRTIFTI8: Delete accounts from Final Transaction Information instances

To delete accounts from existing instances. Please note it will not be deleted off your profile. If it is the only account linked to the existing instance, the instance will be systematically deleted.

c) Maintenance Forms can be submitted to Nitro in the following ways:

  • Fax: 0860 110 782

Only Tiff, Tif or PDF files will be processed

  • E-Mail:

Transactionalbankingmaintenance@nedbank.co.za

  • Only Tiff, Tif or PDF files will be processed
  • There must be an attachment
  • If no valid attachments are found in the email then the email is rejected and a mail is sent to the sender to notify them that no valid attachments were found

4.10 Pricing Refer to section 1.10 in the manual.