UAE · ENBook a demo
BankingFinanceInvestigator

Collections Reconciliation Agent

Reconciles third-party collection files to receivables.

Collections Reconciliation AgentRebate Collections Reconciliation Agent · Accounting Operations
Industry
Banking
Department
Finance
Team
Accounting Operations
Kind
Investigator
Approver
Financial Controller
Code
FIN-19

It reconciles the collection files third parties send the bank (direct-debit collections of loan and card repayments, bill-payment agents, merchant acquirers' remittances, debt collection agencies working written-off loans) against the loan and card accounts they collected for. It allocates each receipt to an account, separates commissions, short payments, duplicates and returned debits, and posts the allocations and approved exceptions. **The problem it solves:** Why a collector's remittance does not match the loan and card repayments it collected: which receipts cannot be allocated and why, what was deducted against the agreement, which accounts were short paid or had debits returned, and how long each exception has been open.

How it works

6 steps, and a person signs off before step 6.

  1. 01Looks it up

    Finds the record the request is about in the loan origination system: the loan and card accounts, arrears, collector agreements and the remittances received..

  2. 02Reads the request

    Works out what is being asked and what a complete answer needs.

  3. 03Checks the facts

    Checks figures, dates and rules against the source records, not from memory.

  4. 04Works it through

    Weighs competing explanations against the evidence and shows which one holds up.

  5. 05Asks a person

    Hands the work to Financial Controller with its reasoning before anything goes out.

  6. 06Acts

    Once approved, it acts in the core banking system: it posts the allocations and the approved exceptions to the loan and card accounts. and records what was done.

What it works with

Your knowledge, your systems, your people.

Knows

The collections reconciliation manual: collector agreements and commission rates, allocation rules (arrears oldest first, then fees, interest and principal under the product terms), returned direct-debit codes, written-off recovery accounting, and escalation times.

Reads from

the loan origination system: the loan and card accounts, arrears, collector agreements and the remittances received.

Acts in

the core banking system: it posts the allocations and the approved exceptions to the loan and card accounts.

Hands back

A list with one entry per collector and file, each with collector, file_reference, gross_collected_usd, deductions_claimed_usd, deductions_agreed_usd, net_remitted_usd, cash_received_usd, difference, reconciled (true or false), allocations (a list with account_reference, amount_usd and basis) and exceptions (a list with amount_usd, class, evidence and days_open).

Asks a person when

A commission variance is outside 0.5 percent, a receipt is classed as a duplicate or not ours, unallocated cash is older than 5 days, or an allocation would change an account's arrears status.

ApproverFinancial Controller

Settings

Your limits, set by your managers.

SettingDefaultWhat it controls
Allocation tolerance (USD)1Receipts within this of the due amount match.
Date window (days)5Receipts within this of the due date match.
Commission variance tolerance (%)0.5Commission above the agreed rate by more than this is an exception.
Escalate unallocated cash after (days)5Older unallocated cash is escalated.
Allocate to the oldest arrears firstOnWhen on, receipts clear the oldest arrears first.

Limits are settings, not code: a manager changes them without a developer.

Rules it always follows

  • Allocate within 1 USD and 5 days; when on is true, clear the oldest arrears first.
  • Commission above the agreed rate by more than 0.5 percent is an exception.
  • Recoveries on written-off loans post to the recoveries account, not back to the loan.
  • A returned direct debit reverses its allocation and the account's arrears status.
  • Escalate cash unallocated for more than 5 days.

See the Collections Reconciliation Agent agent on your own work.

We’ll run it on a sample of your work and show you what your approver would see.

Collections Reconciliation Agent · Banking | Basinwright Industries