Popular reconciliation template
Sales vs Razorpay Reconciliation
Reconcile internal sales with Razorpay payment, refund, fee, settlement, and payout reports in one structured workflow.
View demo reportReconcile internal sales with Razorpay payments and payouts
Razorpay reports can include payments, refunds, fees, taxes, adjustments, settlements, and payout amounts. Cointab helps bring these into a clear reconciliation report.
The Sales vs Razorpay reconciliation helps finance teams compare internal sales or order records with payment and payout data received from Razorpay.
This helps finance teams answer questions such as:
- Which sales were successfully paid through Razorpay?
- Which internal orders are missing in Razorpay?
- Which Razorpay payments do not have a matching internal sale?
- Which refunds or reversals reduced the payout?
- Which fees, taxes, or adjustments explain the difference between gross sales and net payout?
- Which transactions were paid in one period but settled in another?
- Which items need follow-up or internal review?
This template is useful for eCommerce brands, D2C companies, SaaS businesses, online platforms, and finance teams that need a repeatable Razorpay reconciliation process.
Required files for this template
Cointab's ready-made workflow is designed around internal sales records and standard Razorpay reports used for payment, refund, fee, settlement, and payout reconciliation.
| Data source | Example records |
|---|---|
| Sales / Order Report | Used as the internal source-of-truth report containing orders, invoices, customers, amounts, dates, payment status, and internal references. |
| Razorpay Payment Report | Used to compare internal sales records with Razorpay payment transactions, payment IDs, customer references, amounts, and transaction status. |
| Razorpay Settlement / Payout Report | Used to compare Razorpay payment activity with settlement-level or payout-level data and final amounts received. |
| Razorpay Refund Report | Used where customer refunds need to be reconciled against internal return, cancellation, or refund records. |
| Razorpay Fee / Adjustment Report | Used where Razorpay fees, GST, adjustments, processing charges, or balance movements need to explain payout differences. |
| Internal ERP / Books Report | Optional, but useful if the finance team also wants to compare sales and Razorpay data with accounting, ERP, revenue, or receivable records. |
| Supporting Data | Optional supporting files for customer mapping, invoice mapping, subscription mapping, product mapping, tax logic, payment status enrichment, or other enrichment. |
What Cointab matches in Razorpay reconciliation
Cointab compares sales, payment, refund, fee, tax, settlement, and payout information across internal and Razorpay reports.
Sales and payment records
Match internal sales, orders, or invoices with corresponding Razorpay payment transactions.
Refunds and cancellations
Identify whether refunds, cancellations, and customer credits are correctly reflected in Razorpay and internal records.
Fees and deductions
Track Razorpay processing fees, GST, adjustment charges, settlement deductions, and other charges where available.
Settlement and payout amounts
Compare expected payment collections with actual Razorpay settlements or payouts.
Tax and adjustment records
Review GST, tax-related differences, settlement adjustments, and amount breakups where relevant.
Bank and books records, if added
If bank statements, ERP, or books data are included, Cointab can also compare Razorpay payout records against bank credits and accounting entries.
Common Razorpay reconciliation exceptions
Cointab helps finance teams focus on differences instead of manually reviewing every Razorpay transaction.
Sale not found in Razorpay
A sale appears in the internal sales or order report but is not found in the Razorpay payment report for the selected period.
Razorpay payment without matching sale
A Razorpay payment appears without a clear matching order, invoice, or internal sales record.
Amount mismatch
The transaction reference matches, but the internal sale amount and Razorpay payment amount are different.
Refund difference
A refund appears in Razorpay but does not match the internal refund, return, cancellation, or credit record.
Fee or deduction difference
Razorpay fees, GST, processing charges, taxes, or adjustments explain part of the difference between gross sales and net payout.
Settlement timing difference
A payment belongs to one period but is settled or paid out in a later Razorpay settlement cycle.
Failed or reversed payment difference
A failed, reversed, or cancelled payment appears differently across internal and Razorpay records.
Duplicate or repeated entry
The same order, payment, refund, or settlement entry appears more than once or is included in multiple files.
Missing or unclear reference
Order ID, invoice number, payment ID, customer reference, settlement ID, or transaction reference is missing, incomplete, or appears inside a description field.
Skipped record
A row cannot be reconciled because required data is missing, invalid, duplicate, incomplete, or unusable.
How this ready-made reconciliation works
Cointab pre-configures the workflow so your team does not need to rebuild the Razorpay reconciliation setup every period.
Select the template
Choose Sales vs Razorpay from popular reconciliations.
Select the period
Choose the month, quarter, year, lifetime period, or custom period you want to reconcile.
Upload sales and Razorpay reports
Upload your sales or order report, Razorpay payment report, and any required settlement, payout, refund, fee, adjustment, or supporting files.
Validate file format
Cointab checks whether the uploaded files match the expected structure and highlights missing or incorrect columns.
Run reconciliation
Cointab applies predefined data preparation and matching logic for sales and Razorpay data.
Review output
View fully matched, partially matched, unmatched, and skipped records.
Download or automate
Download the Excel report, or automate future data input and output through email, SFTP, or APIs.
Structured matching first, AI assistance for difficult cases
Cointab applies structured reconciliation logic first, then uses AI to help with difficult open transactions where fixed rules are not enough.
Structured matching
Structured matching can use:
Matching scenarios
One-to-one
One internal sale or invoice matches one Razorpay payment.
One-to-many
One sale maps to multiple Razorpay records such as payment, fee, refund, adjustment, or settlement entries.
Many-to-one
Multiple sales or payments are grouped into one Razorpay settlement or payout.
Many-to-many
Multiple internal records and multiple Razorpay records are grouped and compared.
Partial matching
Identifiers match, but amounts differ.
Net and contra matching
Sales, refunds, fees, taxes, adjustments, reversals, and payouts are netted where required.
AI-assisted transaction matching
After structured rules run, AI helps match difficult open transactions where:
- References are incomplete
- Descriptions are messy
- Razorpay descriptions contain embedded order or invoice references
- Refund entries do not directly map to sales
- Amounts require contextual understanding
- Payment and settlement dates fall in different periods
- Multiple possible matches exist
AI exception analysis
For transactions that remain open, AI can help identify possible reasons such as:
AI assists matching and exception review, but Cointab keeps reconciliation transparent, reviewable, and audit-friendly.
Audit-ready Razorpay reconciliation reports
Cointab gives your team a clear report showing which sales and Razorpay transactions matched, partially matched, remained unmatched, or were skipped.
Report categories
Fully matched
Sales and Razorpay records where identifiers and amounts match.
Partially matched
Records where identifiers match but amounts differ.
Unmatched in sales report
Transactions present in the internal sales report but not found in Razorpay.
Unmatched in Razorpay
Razorpay payments, refunds, fees, adjustments, or settlement records that do not clearly match internal sales records.
Skipped
Records excluded due to missing, invalid, duplicate, incomplete, or unusable data.
Report capabilities
- Summary cards
- Transaction-level details
- Filters for review
- Difference amounts
- Matched transaction drill-down
- Manual match
- Undo manual match
- Excel export
- Audit-friendly output
Automate recurring Razorpay reconciliation
Once this workflow is stable, Cointab can automate file input, reconciliation runs, and output delivery.
Bring data into Cointab
Data can be received or pulled through:
Run automatically
Schedule reconciliation:
Push output back
Send reconciliation output to:
- Matched Razorpay payments
- Unmatched sales records
- Unmatched Razorpay records
- Refund differences
- Fee or deduction differences
- GST or tax differences
- Settlement differences
- Open items
- Suggested actions
- Excel reconciliation report
- Structured API output
View a Razorpay reconciliation demo report
See how Cointab presents Sales vs Razorpay output with matched, partially matched, unmatched, and skipped transactions.
Sales vs Razorpay Demo
Explore a sample report showing sales, Razorpay payments, refunds, fees, settlements, payout differences, and open items.
View demo reportExplore related payment gateway reconciliations
Cointab supports other payment gateway, settlement, and payout reconciliation workflows.
Sales vs Payment Gateway
Use a general payment gateway reconciliation workflow for sales, payments, refunds, fees, and settlements.
View templateSales vs Stripe
Reconcile internal sales with Stripe payments, refunds, settlements, fees, disputes, and payouts.
View templateSales vs PayPal
Match internal sales or order records with PayPal payments, refunds, fees, disputes, and payouts.
View templateSales vs PayU
Compare order records with PayU transaction, refund, fee, and settlement reports.
View templateBuilt for teams reconciling Razorpay payments and payouts
This template is useful for teams that regularly reconcile sales, refunds, fees, settlements, and Razorpay payouts.
eCommerce brands
For brands using Razorpay to collect website or app payments and reconciling payments with orders, refunds, and payouts.
D2C companies
For D2C teams managing high-volume orders, payment gateway transactions, refunds, and settlement differences.
SaaS companies
For subscription or invoice-based businesses that need to match Razorpay payments with billing, revenue, and customer records.
Finance teams
For teams handling high-volume payment, refund, fee, tax, and payout data across Razorpay and internal systems.
Accounting teams
For teams preparing reconciliation reports for month-end close, books, revenue review, and audit.
Outsourced finance teams
For accounting firms or finance operations teams handling Razorpay reconciliation for multiple clients.
Trusted by teams handling payment gateway reconciliation
Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across payment gateways, marketplaces, banks, partners, and internal systems.
“We have worked on many softwares but we love the ease of using cointab. The staff and support is very instant. They are approachable, proficient and patient. Team is very cooperative with the customisations. The experience of using cointab was nice.”
Sales vs Razorpay FAQs
Start Sales vs Razorpay reconciliation
Use Cointab's ready-made Razorpay reconciliation workflow to match sales, identify payment and payout differences, review exceptions, and export audit-ready reports.
View demo reportReady-made workflow · Reusable every period · Manual upload and automation supported