Skip to content
Berke Tok
Back to work

Payments & settlement

Stratum

A daily close that finishes at four

A daily close that finishes at four
Sector
Payments & settlement
Location
Manama, Bahrain
Year
2025
Kickoff to production
21 weeks
01Overview

Clearing, settlement and exception handling for a regional processor that closed its books at midnight and guessed until then.

02The problem

The processor settled 180,000 transactions a day across four schemes, and the day's true position only existed after an overnight batch. Breaks were found by a clerk the next morning, and one scheme file arriving late pushed the entire close into the evening.

The settlement console at midday: 182,140 transactions settled, a position that moves as files land, and the close forecast at 16:10
03What we built
  1. 01

    Position, continuously

    Presentments, refunds and chargebacks post to a running position through the day, so the number on the wall at three o'clock is the number the books close on.

  2. 02

    Exceptions with a next action

    Every break is classified (timing, amount, missing leg) and routed with the matching evidence attached, so a clerk decides instead of investigating.

  3. 03

    Late files don't move the close

    Each scheme file is ingested with its own state, so a delayed partner delays one reconciliation rather than the whole cycle.

An amount mismatch on one scheme, already classified and carrying the scheme file, authorisation and merchant advice a clerk needs to decide
The daily close on a tablet on the floor: scheme files reconciled one by one, exceptions counted down before the position is published
04The result

The close moved from midnight to mid-afternoon and reconciliation headcount shrank, without a single settled position being restated.

What changed

Daily close
Afternoon
Transactions settled daily
182k
Reconciliation
Exception-first
The signed settlement statement it closes on: position final, no restatement, every scheme file accounted for

Stack

  • Java
  • Postgres
  • Kafka
  • Airflow
  • Grafana

Disciplines applied

  • Financial technology
  • Automation & operations
  • Data & analytics

Closing

Do you have an idea, or a problem?

Either works. In my experience the second one goes faster.

I usually reply the same day.