CasesIntegrations and reconciliations
Integrations and reconciliations with Santander
With Santander, Openi integrates 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 checks out and what needs review.
From source data to result
- 1Systems
- 2Webhooks
- 3Reconciliation
- 4Mismatches
The challenge. Integrations and reconciliations.
In a bank, the same fact goes through several systems: the one that originates the operation, the one that settles it and the one that records it. Each has its own format, its own identifier and its own closing time. Reconciling means proving that what one system issued reached the other, with the same amount, and quickly pointing out what got lost along the way.
evt_9f2a01
R$ 25,000.00
MATCHRecord 550193
R$ 25,000.00
evt_9f2a02
R$ 1,730.55
MATCHRecord 550194
R$ 1,730.55
evt_9f2a03
R$ 8,412.00
POSSIBLERecord 550201
R$ 8,421.00
evt_9f2a04
R$ 640.00
NO_MATCHno pair
Sample data, to illustrate the flow.
How it works. In 3 steps.
- 01
Events arrive by webhook
Each system sends its events to a Nexus inbound webhook, in JSON, as they happen.
- 02
The databases come in as data sources
The records on the other side are registered as a data source and sit in the same dataset model as the events.
- 03
The rule set returns the mismatches
The rule matches event and record. What checks out moves on; what has no pair or differs in amount is set aside for review.
How it runs through the API. In documented calls.
POST /hooks/{slug}
Events reach Nexus through an inbound webhook.
POST /v1/data-sources
Nexus receives the data source that goes into the reconciliation.
POST /v1/rule-sets/{ruleSetId}/run
The rule set runs and matches the two datasets.
What stays visible. Set apart for the people who operate.
- Event received with no record in the database
- Record with no matching event
- Amount difference between the two sides
“We integrated Open Finance in one sprint. The documentation answers before we need to ask.”
“The reconciliation that took the team two days now runs on its own.”
Teams from fintechs, retail and accounting already integrate with Openi.
Request accessBuild your reconciliation. With the same calls.
The cases use documented endpoints only. Request access and run the flow with your own operation's data.