Platform capability
Reconciliation across every provider
Match orders, payments, refunds and settlements across providers in one place, and see exactly which items need a person to look at them.
- Orders ↔ payments ↔ settlements, matched
- Fees and GST shown per settlement line
- An exceptions list instead of a spreadsheet
Four orders are matched to their payments and to the providers' settlement files. Three match. One payment, processed by Provider B, is missing from Provider B's settlement file and is flagged as an exception.
The problem
Every provider you add multiplies reconciliation
Each provider settles on its own cycle, in its own file format, with its own reference numbers. Fees and GST are deducted differently, refunds are netted in some files and listed separately in others, and chargebacks appear whenever they happen.
Finance ends up matching three settlement files and a bank statement against an order export. The work is slow, and a missing settlement can go unnoticed for weeks.
What usually slips
- A payment that was captured but never settled
- Fees higher than the agreed rate, a few paise at a time
- Refunds processed but never deducted, or deducted twice
- A late UPI success after a retry, which left one order paid twice
How it works
A three-way match
- 01
Orders to payments
Each payment carries your reference_id, so it's matched to your order automatically, including every retry attempt and refund against it.
- 02
Payments to settlement lines
Each provider's settlement report is read and every line is matched to a payment on provider reference, amount and date. Fees and taxes are split out per line.
- 03
Settlement batches to your bank
When you add your bank statement, settlement batches are matched against the credits in your account by UTR and batch total.
- 04
Exceptions to a person
Anything that doesn't match lands in an exceptions list with the likely cause. Everything that did match needs no attention.
Exceptions
What gets flagged, and what to do about it
| Exception | Typical cause | Next step |
|---|---|---|
| Captured, not settled | The provider delayed or missed it | Raise it with the provider, quoting the payment reference |
| Settled, with no matching payment | A payment made outside Peneu, or a late success after a timeout | Check for a duplicate order and refund if needed |
| Fee mismatch | Deduction differs from your agreed rate | Check the provider's fee line against your agreement |
| Refund not deducted | Refund processed but not netted in settlement | Confirm with the provider before the next cycle |
| Chargeback debit | A customer dispute | Respond with order and delivery evidence |
| Settled twice | Duplicate line in a settlement file | Raise it with the provider |
For finance
What the finance team gets
- 01
One view across providers
Every provider's settlements in one place, per day and per batch.
- 02
Fees and GST per line
As reported by the provider, next to the rate you agreed.
- 03
Refunds and chargebacks in context
Linked to the original payment and order, not listed on their own.
- 04
CSV exports
For your accounting system, with your references kept intact.
Worth knowing
Reconciliation follows settlement timing
Matching can only be as current as the provider's settlement reports. Many methods settle on T+1 or T+2 banking days, and weekends and bank holidays shift that. A payment that looks unsettled today may simply be in tomorrow's file.
Evaluating it
Questions to ask about this, of any provider
Use these with any platform, including Peneu. For Peneu, what's available for your business is confirmed during onboarding.
- Is matching done per transaction, on my references?
- Totals that agree can hide two errors that cancel out.
- Are settlements matched to bank credits too?
- The chain isn't complete until money is confirmed in your account.
- How are exceptions assigned and closed?
- Reconciliation is only useful if unmatched items get an owner and a resolution.
- Can the output feed my accounting system?
- Export formats and timing decide how much manual work is left.
FAQ
Questions about reconciliation & reporting
Does reconciliation work if I only use one provider?
Yes. The three-way match is useful with one provider. It becomes necessary with two or more.
Where does the settlement data come from?
From each provider's settlement reports, in whatever format that provider publishes. The format differences are handled on Peneu's side.
Can it post entries to our accounting system?
Reconciled data is available as CSV exports. If you need a direct connection to a specific accounting system, tell us which one during onboarding.
Works together with
Show us your month-end
Walk us through how your team reconciles today, including which files and which spreadsheets. We'll show you what the same month looks like with a three-way match.
Last reviewed . Samples on this page are illustrative.