CasesE-commerce platforms
Online store orders reconciled with what was received
Nuvemshop and Tray are e-commerce platforms. The integration with Openi reconciles the orders placed in the stores: each order enters Nexus by webhook and is matched to the payment the merchant actually received.
From source data to result
- 1Store order
- 2Webhook
- 3Rule set
- 4Reconciled order
The challenge. E-commerce platforms.
In an online store, the order is born on the platform, the payment goes through a payment method (card, Pix or boleto) and the money reaches the merchant days later, already net of fees and, for cards, split into installments. The merchant sells in one place and gets paid in another. Reconciling means answering, order by order: was it paid? How much arrived? What is still to be received? With hundreds of orders a day, that math does not close in a spreadsheet.
Order #48213 · Pix
R$ 89.00
ReconciledPix received
R$ 89.00
Order #48214 · Card 3x
R$ 349.90
Reconciled3 installments settled
R$ 349.90
Order #48215 · Card
R$ 199.90
MismatchSettlement
R$ 189.90
Order #48216 · Boleto
R$ 1,250.00
No payoutno pair
Sample data, to illustrate the flow.
How it works. In 3 steps.
- 01
Each order comes in by webhook
When an order is created, paid or cancelled in the store, the platform sends the event to a Nexus inbound webhook.
- 02
Payouts are the other source
What was settled to the merchant comes in as a second data source: by file, database or Open Finance transactions.
- 03
The rule set matches order and payout
The rule compares identifier, amount and date, and also reconciles an order paid in several installments. What does not match is set aside for whoever runs the operation.
How it runs through the API. In documented calls.
POST /hooks/{slug}
Events reach Nexus through an inbound webhook.
POST /v1/rule-sets/{ruleSetId}/run
The rule set runs and matches the two datasets.
GET /v1/matches
Each pair comes back with a decision and a score.
What stays visible. Set apart for the people who operate.
- Paid order with no matching payout
- Amount received different from the order amount
- Payout with no originating order
“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.