Collections Reconciliation Agent
Reconciles third-party collection files to receivables.
- 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.
- 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..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Works it through
Weighs competing explanations against the evidence and shows which one holds up.
- 05Asks a person
Hands the work to Financial Controller with its reasoning before anything goes out.
- 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.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Allocation tolerance (USD) | 1 | Receipts within this of the due amount match. |
| Date window (days) | 5 | Receipts within this of the due date match. |
| Commission variance tolerance (%) | 0.5 | Commission above the agreed rate by more than this is an exception. |
| Escalate unallocated cash after (days) | 5 | Older unallocated cash is escalated. |
| Allocate to the oldest arrears first | On | When 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.