Invoicing & Payments
Payment Gateway Reconciliation in Sri Lanka: Cards, QR, and Bank Transfers
A practical reconciliation model for Sri Lankan businesses collecting through cards, QR, bank transfers, and payment links across branches and entities.
Reconciling LankaQR, JustPay, or group collections without spreadsheet settlement matching?
Payment collection is easy to decentralise and difficult to reconcile. A card payment may settle two days later, a QR payment may arrive under a shortened reference, and a bank transfer may be confirmed in WhatsApp. Finance needs one ledger that preserves those differences without losing the invoice relationship.
The minimum reconciliation fields
- Invoice or customer account reference.
- Payment method and originating gateway or bank.
- Gross amount, fee, net settlement, and settlement date.
- Branch, department, entity, or cost centre.
- Refund, chargeback, reversal, and exception status.
- A matching result with an owner and next action when it does not match.
Do not reconcile only by daily totals
Daily totals hide the exceptions that matter: one customer paid twice, a refund was not posted, a gateway deducted a fee, or a transfer was assigned to the wrong branch. Match at transaction level first, then use daily totals as a control check.
Continue with centralised payment portal software, LankaQR and JustPay ERP integration, and ERP bank reconciliation.
Frequently asked questions
Why do payment gateway totals differ from invoices?
Timing, fees, refunds, partial settlements, chargebacks, duplicate references, and payments received outside the gateway can all create differences. Reconciliation needs transaction-level references, not only daily totals.
Can one portal reconcile multiple payment methods?
Yes, if it normalises references and settlement data across gateways, QR, bank transfers, and manual receipts while preserving the original source and fee details.
Who benefits from a centralised payment portal?
Groups with multiple branches, departments, subsidiaries, brands, or payment accounts benefit most because finance can see collections and exceptions in one place.
Related Capricon solutions
Explore tools and services for invoicing & payments
Related guides on this topic
- Sri Lanka RAMIS VAT E-Invoicing Checklist for ERP Teams (2026)
- Tax Invoice Format Sri Lanka 2026 | VAT Compliance PDF (2481/22)
- Sri Lanka VAT Invoice Checklist 2026: TIN & Serial Validation
- Sri Lanka 2026 VAT E-Invoicing: How ERP Systems Should Prepare for RAMIS Integration
Related Capricon product & services
- Capricon Core ERP
VAT-ready invoicing, inventory, and finance for Sri Lankan businesses.
- ERP software Sri Lanka
Buyer guide: modules, LKR TCO bands, cloud vs on-premise, and accounting-vs-ERP signals.
- Capricon Pay payment portal
Centralize collections and reconcile LankaQR / JustPay settlements with ERP.
- RAMIS VAT e-invoicing Sri Lanka
Gazette 2481/22 fields, schedules, and ERP-to-RAMIS readiness overview.
- Tax invoice checklist (PDF)
One-page Gazette 2481/22 field checklist for ERP / POS workshops.
- Cash & VAT readiness audit
Book a structured review of cash matching, payment rails, and VAT invoice readiness.
Ready to take your business to the next level?
Your next big move starts here - take charge, scale up, and lead your business to success.
