Standard Bank (Bank Statement Upload)

The upload of the Standard Bank bank statement file.

Global data

Create a Batch Parameter with a Transaction Code of STDBS and Description of the directory where the Standard Bank bank statement file Interface file must be placed.

Translation values

For the translation of the Statement Codes on the Standard Bank file to the Payment Type on IN.sight, translation values must be set up as per the details below:

Translation Purpose

Add STD STATEMENT to the UDPV object Translation Type.

Source / Target System ID’s and Attributes

The following Source System and Target system ID’s and Attributes must be set up:

Source System ID	Source System Attribute	Target System ID	Target System Attribute
STD STATEMENT	STATEMENT CODE	IN.PENSIONS	PAYMENT METHOD

Translation Values

The following Translation Values for the System ID’s and Attributes must be set up:

Source System	Target System	Description of Transaction
000062	CHEQUE	CHEQUE CASHED
000063	CHEQUE	CHEQUE
000452	CHEQUE	CHEQUE
000453	CHEQUE	CHEQUE
000454	CHEQUE	CHEQUE
000666	CHEQUE	CHEQUE
001003	CHEQUE	CHEQUE
001004	CHEQUE	CHEQUE
001005	CHEQUE	CHEQUE
000519	EFT	CATS THIRD PARTY UNPAID
000520	EFT	CATS THIRD PARTY PAYMENT
001001	EFT	MAGTAPE DEBIT
000055	EFT	TRANSFER
000263	EFT	UNPAID – ACCOUNT TRANSFERRED
000264	EFT	UNPAID – ACCOUNT HOLDER DECEASED
000265	EFT	UNPAID – A/C NOT STATED IN TRANSACTION
000266	EFT	UNPAID – EFFECTS NOT CLEARED
000267	EFT	UNPAID – AMOUNT NOT AUTHORISED
000268	EFT	UNPAID – NO SUCH ACCOUNT
000288	EFT	UNPAID ITEM
000289	EFT	UNPAID ITEM
001080	EFT	UNPAID – ACCOUNT TRANSFERRED
001081	EFT	UNPAID – ACCOUNT HOLDER DECEASED
001082	EFT	UNPAID – A/C NOT STATED IN TRANSACTION
001083	EFT	UNPAID – EFFECTS NOT CLEARED
001084	EFT	UNPAID – AMOUNT NOT AUTHORISED
001085	EFT	UNPAID – NO SUCH ACCOUNT
001000	OTHER	MAGTAPE CREDIT
000022	OTHER	DEPOSIT
000028	OTHER	PAYMENT RECEIVED
000034	OTHER	DEPOSIT
000035	OTHER	DEPOSIT
000036	OTHER	CREDIT TRANSFER
000126	OTHER	CATS TRANSFER
001271	OTHER	CHEQUE DEPOSIT
000134	OTHER	CATS THIRD PARTY PAYMENT
006088	OTHER	CREDIT TRANSFER
000021	OTHER	BANK ERROR
000029	OTHER	INTEREST
000030	OTHER	INTEREST CAPITALISED
000038	OTHER	INTEREST
000052	OTHER	SERVICE FEE
000253	OTHER	BANK CHARGES
000493	OTHER	STAMP DUTY
001006	OTHER	INTEREST
001007	OTHER	INTEREST CAPITALISED

Note:

This is not a complete list but only those that will potentially appear on the bank statement of an IN.sight client.

Bank Statement File Create

The JU2AV_BKUPLD batch job will run several times a day to extract the Bank Account details. When this batch job runs, the system will read the Bank Statement interface table and create a csv file as per the data in the table and move the file to the directory defined in the STDBS Batch Parameter.

File upload

When the JU2AV_BKUPLD Bank Statement Upload job runs, the system will check if there is a file in the directory defined by the STDBS Batch Parameter. If there is a file, the details will be extracted as per the table below and the field on the BANK STATEMENT table will be updated as per the IN.PENSIONS FILED column. Once the file has been processed, the file will be moved to a folder with the name COMPLETED.

The system will create a balance record i.e. a Bank Statement record with the values indicated in the IN.PENSIONS FIELD column in the File Header Record below and will create Bank Statement records for each of the Transaction Details Records with the value in the Transaction Details Records table.

All of the records will be created with a value for Statement No equal to the value for Statement Number in the File Statement Header Record.

File Header Record

DATA ELEMENT	POSITION	LENGTH	TYPE	DESCRIPTION	IN.SIGHT FIELD
Record Identifier	1	2	A	FH
File Type	3	4	A	STMT
User ID	7	5	A
Extraction Date	12	8	N	Date extracted in format CCYYMMDD
Creation Date	20	8	N	Date file is created in format CCYYMMDD
Creation Time	28	6	N	Time file created in format HHMMSS
Filler	34	119	A	Spaces

Statement Header Record

DATA ELEMENT	POSITION	LENGTH	TYPE	DESCRIPTION	IN.SIGHT FIELD
Record Identifier	1	2	A	SH
Statement Date	3	8	N	Statement Date in format CCYYMMDD
Branch Code	11	4	N	Standard Bank branch where account is kept
Bank Account Number	15	16	N	Bank Account Number	BANK ACCOUNT NUMBER
Bank Account Type	24	3	N	Type of Account
Filler	27	10	N	Spaces
Statement Number	37	3	N	Statement number	STATEMENT NO
Opening Balance	40	15	N	Opening balance	With leading zeroes and last 2 characters are decimals.
Credit or Debit Indicator	55	1	A	Opening balance sign: Negative = D Positive = C
Date of First Entry	56	8	N	Date of the first statement entry
Number of Statement Entries	64	5	N	Total number of statement entries in the statement
Filler	69	84		Spaces

Transaction Detail Record

DATA ELEMENT	POSITION	LENGTH	TYPE	DESCRIPTION	IN.SIGHT FIELD
Record Identifier	1	2	A	TD
Transaction Date	3	8	N	Transaction Date in format CCYYMMDD	BUSINESS EFFECTIVE DATE
Amount	11	15	N	Transaction amount	Leading zeroes. Last 2 characters are decimals.
Credit or Debit Indicator	1	26	A	Transaction debit or credit indicator	C = Credit D = Debit
Service Fee	27	5	N	Service fee for the processing of transaction
Rolling Balance	32	15	N	Balance immediately after the transaction	With leading zeroes and last 2 characters are decimals. ACCOUNT BALANCE Read the value for Credit or Debit Indicator field and if it is C update the Account Balance field with no sign. If it is D update the Account Balance field with a negative sign.
Rolling Balance Debit or Credit Indicator	47	1	A		See above
Cheque Number	48	8	N	Cheque Number	DOCUMENT NUMBER If the value for PAYMENT TYPE is CHEQUE update the DOCUMENT NUMBER field with this value.
Statement Code	56	6	N	Nature of the transaction	PAYMENT TYPE Find the Translation Value with a Purpose of STD STATEMENT and Source System Attribute of STATEMENT CODE and find the translation value for the value of this field. If no Translation Value is found leave blank. See Note below.
Afrikaans Description	62	30	A	Afrikaans description of transaction
English Description	92	30	A	English description of transaction
Customer Statement Reference	122	30	A	Customer Statement Reference as it was specified by the party that initiated the transaction	DOCUMENT NUMBER If the value for PAYMENT TYPE is EFT or OTHER update the Document Number field with the values from the 11^th character i.e. drop the first 10 characters that make up a value predefined by the Standard Bank back end systems e.g. if the vale is ALEXFORBES4LATE JP NEELS update the Document Number with 4LATE JP NEELS
Filler	152	1	A	Spaces

Statement Trailer Record

DATA ELEMENT	POSITION	LENGTH	TYPE	DESCRIPTION	IN.SIGHT FIELD
Record Identifier	1	2	A	ST
Total Number of Statements	3	5	N
Total Number of Debit Transactions	8	7	N
Total Amount of Debit Transactions	15	15	N
Total Number of Credit Transactions	30	7	N
Total Amount of Credit Transactions	37	15	N
Total Number of Transactions	52	7	N
Nett Amount	59	15	N
Credit or Debit Indicator	74	1	A
Filler	75	78	A	Spaces

Bank Reconciliation

When the bank statement file upload has completed the Bank Reconciliation batch job will automatically be started.

The system will read the value for Bank Interface on the DTI Account record for the Bank Account and if it is STD and the Payment Method is EFT, reconcile the transactions on the Bank Statement and the Business Transaction with the same values for Amount and for which the Transaction Date on the Business Transaction is equal to the Actual Transaction Date on the Bank Statement record.