01
Billing is not settlement
An approved sale enters commercial reporting before it becomes available cash. Card, Pix, and other methods have different schedules.
Reports must clarify which date and status are being used.
02
Fees break gross comparisons
Platform fees, acquirer costs, anticipation, and other charges may be deducted at different times.
Compare gross, fees, and net in separate columns.
03
Refunds and chargebacks arrive later
Yesterday's sale may be adjusted weeks later. That changes net revenue without erasing the original order.
Keep an event history instead of overwriting the past.
04
Split multiplies entries
In co-production and affiliate models, a single sale can generate payouts to different participants.
Reconciliation must show the split base and destination of each amount.
05
Automation depends on identifiers
Order, transaction, customer, and payout must share keys that allow matching. APIs and webhooks help when events are idempotent and monitored.
The biggest savings come when exceptions become a small queue, not the closing rule.
06
How to bring this into operations
Document the full transaction flow from checkout start through approval, settlement, possible refund, and reconciliation. Mark which systems receive events and who owns exceptions. This simple map surfaces dependencies that usually appear only when volume grows or a campaign scales suddenly.
Read by cohort and source whenever possible. Ticket, payment method, installments, product, campaign, and affiliate can produce different economics. A healthy average approval or chargeback rate can hide a segment that destroys margin and pushes CPA up.
07
Metrics worth tracking with the decision
Track attempts, approval, checkout conversion, AOV, refunds, chargebacks, net value, and payout timing. Connect those numbers to media CPA and ROAS. The goal is not the highest isolated metric but turning purchase intent into net revenue with controlled risk and cash flow.
08
The takeaway
Good reconciliation turns multiple reports into one financial story. It explains differences by status, fee, timing, and event.
When finance can trace each sale to receipt, cash and scaling decisions become far more reliable.
09
Why doesn't my dashboard match the bank?
Because sale, approval, settlement, fees, and reversals can occur on different dates and bases.
10
Does Pix make reconciliation easier?
It may settle faster, but correct transaction and order identification is still required.
11
What to automate first?
Matching by identifier, event import, and handling recurring exceptions.