ABSA (Bank Statement Upload)

The upload of an electronic file of bank account transactions from ABSA’s ReconFocus, for the purposes of performing automated bank reconciliations.

Note:

When a Bank Statement is electronically uploaded, each transaction loaded will be matched against the transactions in the bank account on the system.

If the transaction date, document number and amount on the bank statement match a transaction with the same date, amount and document number on the system, the transactions will be automatically reconciled.

Translation Values

For the translation of the category codes on the ReconFocus file to the payment type on the system, the following source system and target system ID’s and attributes apply:

Source System ID	Source System Attribute	Target System ID	Target System Attribute
RECONFOCUS	CATEGORY	IN.PENSIONS	PAYMENT METHOD

The following are the translation values for the system ID’s/attributes above:

Source System	Target System
ACC	EFT
ACCK	EFT
ACCR	EFT
ACD	EFT
ACDK	EFT
ACRD	EFT
CHE	CHEQUE
CHQ	CHEQUE

ReconFocus file layout

Recon Transmission Header Record

FIELD NAME	START	LENGTH	DEC	TYPE	DESCRIPTION
REC-TYPE	1	1		A	Record ID for transmission header record. Value 0
Filler	2	19		A	Internal ABSA use
TRANSM-STATUS	21	1		A	Transmission File Status. T = test, P = production
TRANSM-DATE	22	8		D	Transmission Date as CCYYMMDD
CLIENT-CODE	30	5		N	Client Code
CLIENT-NAME	35	30		A	Client Name
DESTINATION-CODE	65	5		N	Destination Code. Default to Client Code
Filler	70	446		A	Internal ABSA use
GENNO	516	9		N	Transmission Generation Number
Filler	525	25		A	Internal ABSA use
Record length	550

Recon Account Header Record

FIELD NAME	START	LENGTH	DEC	TYPE	DESCRIPTION
REC-TYPE	1	1		A	Record ID for Account header record. Value 1
ACNO	2	19		N	Account number. Every account will have a Recon acc. Header record
STMNO	21	5		N	Cheque statement number of first statement for account
Filler	26	5		A	Internal ABSA use
PRDT	31	8		D	Processing date of first transaction on first statement as CCYYMMDD
ACC-BR-CODE	39	8		N	Account’s ACB branch code. Not available yet.
Filler	47	18		A	Internal ABSA use
HD-OP-BALS	65	1		A	Opening Balance Sign + or -
HD-OP-BAL	66	17	2	N	Opening Balance of first statement
Filler	83	100		A	Internal ABSA use
FUNC	183	4		A	Function code. Default AA0A
Filler	187	345			Internal ABSA use
GENNO	532	9		A	Transmission Generation Number
Filler	541	9			Internal ABSA use
Record length	550

Recon Account Detail Record

FIELD NAME	START	LENGTH	DEC.	TYPE	DESCRIPTION
REC-TYPE	1	1		A	Record ID for Recon Account detail. Value 2.
ACNO	2	19		N	Account Number
STMNO	21	5		N	Cheque statement number
PAGENO	26	5		N	Cheque statement page number
PRDT	31	8		D	Transaction Processing date as CCYYMMDD
EFDT	39	8		D	Transaction Effective date as CCYYMMDD
CHEQNO	47	9		N	Cheque number when applicable, else zeroes
TREFNO	56	9		N	Transaction Reference number
TAMTS	65	1		A	Transaction amount sign, + if amount not negative else ‘-‘
TAMT	66	15	2	N	Transaction amount
HDBALS	81	1		A	Account Balance Sign + or -
HDOPBAL	82	17	2	N	Account Balance after transaction
TDESCR	99	50		A	Transaction description (as received from cheque system)
DEPID	149	30		A	Document Number (for EFT’s). Update the field with the characters 11-17 of this field. Note: The value returned in this field is the value for the User Reference field in the EFT file and therefore the first 17 characters are the abbreviated user name (first 10 characters) and the system generated number (next 7 characters). The Document Number on the BT is contained in positions 11-17. For the method used by the system to determine the value for the Document Number field, refer to Document Number below.
TRAN	179	4		A	Transaction code (as received from Cheques) E.g. FN71, CF71, etc.
FUNC	183	4		A	Cheques Function code (as received from Cheques). Contains function code AA9A if no transaction, e.g. ACD, ACDK, CDM, CDMK, etc.
CRGS	187	1		A	Charge levied amount sign + or -
CRGAMT	188	9	2	N	Charge levied amount
CRG-TYPE	197	1		A	Charge type. T=tran, S=service, A=admin
SDAMTS	198	1		A	Stamp duty amount sign + or -
SDAMT	199	9	2	N	Stamp duty levied amount
CDFEES	208	1		A	Cash deposit fee sign + or -
CDFEE	209	9		N	Cash deposit fee
ACRU	218	1		A	Charges accrued. 1=management charges accrued for stat, ‘2’=charges accrued for cap
EVENTNO	219	9		N	Event number
STMSEQ	228	9		N	Statement line sequence number. Is reset at start of page. Increments with no. lines used for transaction on statement.
VATAMT	237	9	2	N	Vat amount included in Transaction amount
CASHPORT	246	15	2	N	Cash portion of deposit. The transaction amt sign also applies for this amount
DEPOSITNO	261	9		N	Deposit number. If deposit number exists. Numeric value only.
TRANTIME	270	6		N	Transaction time
Filler	276	10		A	Internal ABSA use (previous TDESCREF)
Filler	286	4		A	Internal ABSA use (previous SPLITFUNC)
SITENAME	290	15		A	Sitename where transaction originated
CATEGORY	305	4		A	Category Code (Old CashFocus Category Code) E.g. CIC, CMT, DID,etc.
TRANTYPE	309	2		A	Transaction type. E.g. JD=Journal debit, QD=Cheque debit, CD=Charge debit, DT=Other debit, CT=All credits
DEPIDDESC	311	10		A	Deposit identifier description
POD-ADJAMT	321	15		A	POD (Proof of Deposit) adjustment amount
POD-ADJRSN	336	35		A	POD adjustment reason description
POD-RQPRTRC	371	4		N	POD returned cheque reason code
POD-PQPDRWE	375	30		A	POD returned cheque drawee
FEDIPAYOR	405	30		A	FEDI Payor
FEDINO	435	16		N	FEDI number
REDDESC	451	16		A	Redirect description
REDIR-ACNO	467	19		N	Account number redirected to or from
UNP-CHQRSN	486	20		A	Reason description for unpaid cheques for both Innofin & normal Cheque accounts
Filler	506	10		A	Internal ABSA use.
GENNO	516	9		A	Transmission Generation number
OLD CAT1	525	2		N	Old ReconFocus Category1
OLDCAT2	527	2		N	Old ReconFocus Category2
Filler	529	21		A	Internal ABSA use.
Record length	550

Recon File Trailer Record

FIELD NAME	START	LENGTH	DEC.	TYPE	DESCRIPTION
REC-TYPE	1	1		A	Record ID Recon File trailer record. Value 8
ACNO	2	19		N	Controlling field. Value all 9’s
Filler	21	44		A	Internal ABSA use.
AMT-HASHS	65	1		A	Sign + or - for Hash Amount
AMT-HASH	66	17	2	N	All transaction amounts (TAMT in Recon Account Detail record) added, signs adhered to
Filler	83	107		A	Internal ABSA use.
REC-COUNT	190	10		N	Recon File Record count. All records excluding Transmission hdr/trl records
Filler	200	316		A	Internal ABSA use.
GENNO	516	9		A	Transmission Generation Number
Filler	525	25		A	Internal ABSA use.
Record length	550

Recon Transmission Trailer Record

FIELD NAME	START	LENGTH	DEC.	TYPE	DESCRIPTION
REC-TYPE	1	1		A	Record ID for Recon Transmission Trailer. Value 9.
ACNO	2	19		N	Controlling field. Value all 9’s
TRANSM-STATUS	21	1		A	Transmission Status. T=Test P=Prod
TRANSN-DATE	22	8		D	Transmission date. CCYYMMDD
Filler	30	160		A	Internal ABSA use.
REC-COUNT	190	10		N	Transmission Record Count. All records in Transmission file
Filler	200	316		A	Internal ABSA use.
GENNO	516	9		N	Transmission Generation Number
Filler	525	25		A	Internal ABSA use.
Record length	550

Bank statement file upload

The following batch job will run several times a day to extract the bank account details:

Batch Job 95

Bank Statement Upload

JU2AV_BKUPLD\Bju2avo0.bat

When this batch job runs, a check will be performed to see if there is a file in the directory defined in the batch parameter RECONFOCUS FILE. 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 System field column.

Document Number

The system will determine the value for the Document Number field on the Bank Statement table as follows:

- If a transaction has a Function Type of ACC, the value in the DEPID Field (position 149 with a field length of 30 characters), is loaded in the Document Number field.

- If the function type of the transaction is not ACC and there is a value in the CHEQNO field (position 47 with a field length of 9 characters), this is loaded in the Document Number field.

- If neither 1 nor 2 are applicable and there is a value in the TREFNO field (position 56 with a field length of 9 characters), this is loaded in the Document Number field.

- If 1, 2 and 3 are not applicable then the value in the DEPID field (position 149 with a field length of 30 characters), this is loaded in the Document Number field.

Once the file has been processed, it will be moved to a folder with the name COMPLETED.