ANB Statement Classification & Mapping - LMS Admin Portal

EOD MT940 File

Daily reconciled statement file

EOD

Upload MT940 Statement

Statement Date

Account Number

Intraday JSON Feed

Real-time transaction updates

Intraday

Endpoint

POST /api/anb/statement/intraday

Last Fetch: Every 5 minutes (configurable)

Status Connected

Last Intraday Batch

2024-02-20 10:35:21

Technical Notes

- EOD MT940 is used for final, daily reconciled transactions.

- Intraday JSON feed is used for real-time transaction updates.

- Access: Processed transactions will be visible to users through meta data fields on each payment record.

Master Mapping File

Defines classification logic based on transaction codes and descriptions

ANB Code	ANB Description	Internal Type	Example
LDISB	Loan Disbursement	Loan Disbursal	Funding new loan principal
FEECL	Fee Collection	Fee Collection	Upfront or recurring fees
PAYIN	Loan Installment Payment	Installment Payment	Customer repayment via SARIE
REVRS	Reversal	Reversal	Correction of prior posting

Dual-Feed Statement Processing

Monitor processing status of EOD MT940 and Intraday JSON feeds

EOD MT940 Processing

• Parse and validate MT940 file
• Classify statement entries based on mapping rules
• Match transactions to internal records
• Flag unmatched or duplicate entries

Last EOD Run:2024-02-19 23:59:02

Processed Transactions:1,245

Matched:1,210

Exceptions:35

Intraday JSON Processing

• Ingest JSON transactions every 5 minutes
• Perform entry de-duplication
• Real-time classification and ownership recognition
• Allocate payments to appropriate loan accounts

Last Intraday Poll:2024-02-20 10:35:21

Transactions This Hour:82

Matched:80

Exceptions:2

Latest Processed Transactions

Feed	ANB Ref	Internal Type	Loan ID	Amount	Matched
EOD MT940	ANB-REF-20240219-001	Installment Payment	LN-2024-001	SAR 809.02	Matched
Intraday JSON	ANB-REF-20240220-045	Fee Collection	LN-2024-045	SAR 150.00	Pending EOD

Transaction Matching & Exception Handling

Review transactions that could not be automatically matched

Open Exceptions

35

Awaiting Data

12

Resolved Today

18

Unmatched Transactions

ANB Ref	Date	Amount	Reason	Suggested Match	Actions
ANB-REF-20240219-099	2024-02-19	SAR 1,000.00	Amount mismatch	LN-2024-089 (Installment #3)
ANB-REF-20240220-012	2024-02-20	SAR 600.00	Missing reference	No clear candidate

Transactions that cannot be automatically matched (e.g., amount mismatch, missing reference, unmapped ANB code) are flagged here for manual review.\n

Notifications

ANB Statement Ingestion