Skip to content

Santander · Integrations and reconciliation

Integrations and reconciliations with Santander

With Santander, Openi connects systems and reconciles the data that flows between them. Events arrive by webhook, the databases come in as data sources and the rule set returns what matches and what needs review.

Santander

How the data moves

  1. 01Systems
  2. 02Webhooks
  3. 03Reconciliation
  4. 04Mismatches

The challenge

Why it's hard.Integrations and reconciliation.

At a bank, the same event goes through several systems: the one that originates the transaction, the one that settles it and the one that records it. Each has its own format, its own identifier and its own cut-off time. Reconciling means proving that what one system sent reached the other, with the same amount, and quickly flagging what got lost along the way.

Events from one system, records from the other

  • evt_9f2a01R$25,000.00Record 550193R$25,000.00
  • evt_9f2a02R$1,730.55Record 550194R$1,730.55
  • evt_9f2a03R$8,412.00Record 550201R$8,421.00
  • evt_9f2a04R$640.00No match

Sample data.

How it works

How Openi solved it.In 3 steps.

  1. 01

    Events arrive by webhook

    Each system sends its events to a Nexus inbound webhook, in JSON, as they happen.

  2. 02

    Databases come in as data sources

    Records on the other side are registered as a data source and sit in the same dataset model as the events.

  3. 03

    The rule set returns the mismatches

    The rule matches event and record. What matches moves on; anything with no pair or a different amount is set aside for review.

For the team

What's in plain sight.No digging.

  • Event received with no record in the database
  • Record with no matching event
  • Amount difference between the two sides

More customers

Who else works this way.

Demo

See Openiin your operation.

Leave your details. An Openi specialist will get back to you by email.

  1. You leave your details

    It takes less than a minute.
  2. A specialist gets in touch

    To understand your banks, your ERP and what takes up the most time today.
  3. You see Openi at work

    Reconciliation, categorization and reporting in cases like yours.

Demo environment: details are not stored or sent.