SWIFT940 Bank Statement Loading & Reconciliation Process in Oracle Cash Management, Part 6

Part 6 :-  Bank statement reconciliation process steps  in oracle cash management.

Part 7  release continued ...

SWIFT940 Bank Statement Loading & Reconciliation Process in Oracle Cash Management, Part 5.

Part 5:-  Bank statement import process from bank statement interface tables to base table, once bank statement loading process has been completed.

Part 6  release continued ...

SWIFT940 Bank Statement Loading & Reconciliation Process in Oracle Cash Management, Part 4

Part 4 :- 

Sample format for SWIFT940 format bank statement file and  Bank Statement Loader process

Sample data files 1

:20:9400124557581854

:25: 88502299

:28:134/3

:60F:C110715ZAR80562552,13

:61:1107150715DR1223,00NTRF19610ECDT5T//1196022090

/CTC/076/OUTGOING CLEARING TRANSFE

:86:/PT/FT/BN/SM NAIDOO/AB/632005 ABSA ELECTRONIC ,ABS/AB3/11 TRU

MP STREET SELBY/AB4/AC4060321464

:61:1107150715DR7019,65NTRF19610ECDT5V//1196022117

/CTC/076/OUTGOING CLEARING TRANSFE

:86:/PT/FT/PY/ATC SA/BN/NEIL SEARLS/AB/632005 ABSA ELECTRONIC ,AB

S/AB3/11 TRUMP STREET SELBY/AB4/AC4077758052

:61:1107150715DR1671402,03NTRF19210EAPBT7//1196022084

/CTC/076/OUTGOING CLEARING TRANSFE

:86:/PT/FT/PY/ATC ST03/2011/BN/FREEFALL TRADING/AB/250655 CUSTOME

R COMPUTE,FNB/AB3/2 ND FLOOR 26 TRUMP STREET SELBY/AB4/AC62045612

969

:62F:C110715BHD78882907,45

:64:C110715BHD78882907,45

-Sample data files 2

01,121345678,7777777,011031,1431,1431,80,1,2/

02,7777777,121345678,1,011022,0000,BHD,/

03, 88502299,BHD,400,1153083,4,/

16,100,76995,V,011020,,Bank Reference Text,26446,Office Supplies/

16,100,812213,V,011015,,323532,A39599,Travel expenses/

16,100,242500,V,011017,,5434634N,46400-333,Rent expense/

16,100,21375,V,011019,,264,83832,Team Building Event/

49,2306166,6/

98,2306166,1/

99,2306166,1,10/

save the sample as per given format with .dat format file .

Transfer the .dat Bank statement file to $CE/TOP/BIN for Transfer to Interface through pre defined Loader

 

 Bank Statement Loader process

1	Load Bank Statement Through Loader Pre Defined Loader Concurrent Program given By Oracle
2	Check Bank Statement Loader Execution Report Output For Exception if any
3	We can Check the data in Bank Interface Cash Management > Bank Statements > Bank statement Interface

 

Part 5  release continued ...

SWIFT940 Bank Statement Loading & Reconciliation Process in Oracle Cash Management, Part 3.

SWIFT940 Bank Statement Loading & Reconciliation Process in Oracle Cash Management, Part 3.

Part 3 :-
Bank statement mapping in oracle cash management

STATEMENT MAPPING LINES

 

Column Name	Rec Id	Position	Format	Concatenate Format	Include  Indicator?	Desc Flex
STATEMENT_NUMBER
BANK_ACCOUNT_NUM
LINE_NUMBER
TRX_DATE	61	1
TRX_CODE	61	6
EFFECTIVE_DATE
AMOUNT	61	5
CURRENCY_CODE	61A	1	/OCMT/(aaa)
USER_EXCHANGE_RATE_TYPE
EXCHANGE_RATE_DATE
EXCHANGE_RATE	61A	1	/EXCH/(aaa)
TRX_TEXT	61A	1
INVOICE_TEXT	61A	1	/INV/(~),/REMI/(~)
BANK_TRX_NUMBER	61	8
ORIGINAL_AMOUNT	61A	1	/OCMT/EUR(~),/OCMT/USD(~),/OCMT/SEK(~)
CHARGES_AMOUNT	61A	1	/CHG1/EUR(~),/CHG1/USD(~),/CHG1/SEK(~)
CUSTOMER_TEXT	61A	1	/BENM/NAME/(~)
BANK_ACCOUNT_TEXT	61	8
PRECISION

Part 4  release continued ...