Two ways to close the books on provider settlements
One way to reconcile provider settlements is for finance to export transactions from the panel and settlement statements from each provider, then match them line by line in spreadsheets kept beside the panel. The other way is to have that matching, and the records it depends on, live inside the platform itself.
What drifts in a spreadsheet
Spreadsheets kept beside the panel drift away from the transactions within a week, and month-end turns into an investigation. A platform-native accounting and reconciliation module imports provider statements and matches them against platform transactions on amounts, references and timing windows, rather than requiring every line to match exactly.
- A treasury view of everything the operator owns per currency: balances on its own accounts plus its share held at each provider, split into reserved, frozen and free
- A provider funds view showing whose money sits on each MID, and flagging anything that is not covered or not attributed
A day that closes instead of staying open
The reconciliation module produces a daily profit and loss: gross, commission and FX profit, fees and net result per currency, for every day. A day is finalised, reviewed and then frozen. If a mistake is found later, it is corrected with a reversal dated the day it is made — never by editing history. That is a structural difference from a spreadsheet, where a cell can simply be overwritten.
Money that moves outside the transaction flow
Not everything a payment business tracks is a transaction. Expenses, deposits, withdrawals, OTC deals, transfers and dividends are posted in a financial register with a category and a supporting document. Settlements cover both directions: provider sweeps into the operator's own accounts, and payouts to merchants against a named MID. Agent terms, earnings and payouts are tracked in the same place.
Where the two approaches part
Spreadsheet matching happens after the fact, against two separate exports that can disagree by the time anyone opens them. The platform's conversion and provider analytics already rank activity by merchant, provider and MID; a reconciliation module built on the same transaction and MID records ties settlement matching to that same underlying data, instead of reproducing it in a second file next to the panel.
