01
Every order comes in by webhook
When an order is created, paid or canceled in the store, the platform sends the event to a Nexus inbound webhook.
Nuvemshop e Tray · E-commerce platforms
Online store orders reconciled with what was received
Nuvemshop and Tray are e-commerce platforms. Their integration with Openi reconciles the orders placed in their stores: each order enters Nexus by webhook and is matched with the payment the merchant actually received.
How the data moves
- 01Store order
- 02Webhook
- 03Rule set
- 04Order reconciled
The challenge
Why it's hard.E-commerce platforms.
In an online store, the order is created on the platform, the payment goes through a payment method (card, Pix or boleto, Brazil's bank slip) and the money reaches the merchant days later, 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's still to come? With hundreds of orders a day, a spreadsheet can't keep up.
Store orders and receipts
- Order #48213 · PixR$89.00Pix receivedR$89.00
- Order #48214 · Card, 3 installmentsR$349.903 installments settledR$349.90
- Order #48215 · CardR$199.90SettlementR$189.90
- Order #48216 · BoletoR$1,250.00No match
Sample data.
How it works
How Openi solved it.In 3 steps.
- 02
Receipts 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 receipt
The rule compares identifier, amount and date, and also reconciles an order paid in several installments. Anything that doesn't match is set aside for the operator.
For the team
What's in plain sight.No digging.
- Paid order with no matching receipt
- Amount received different from the order amount
- Receipt with no originating order
Demo
See Openiin your operation.
Leave your details. An Openi specialist will get back to you by email.
You leave your details
It takes less than a minute.A specialist gets in touch
To understand your banks, your ERP and what takes up the most time today.You see Openi at work
Reconciliation, categorization and reporting in cases like yours.
