eCommerce reconciliation
eCommerce reconciliation software for finance teams
Cointab helps eCommerce and D2C finance teams reconcile website sales, payment gateways, marketplaces, COD partners, returns, refunds, settlements, and bank credits in one structured workflow.
View demo reportTrusted by teams reconciling high-volume eCommerce data
Cointab is used by finance and operations teams handling recurring reconciliation across sales, payments, marketplaces, COD partners, banks, and internal systems.
eCommerce reconciliation breaks when data is spread across too many systems
An eCommerce order can touch your website, payment gateway, marketplace, delivery partner, bank account, return workflow, refund process, and accounting system.
One order creates many records
A single order may appear in the store report, payment gateway report, shipment report, COD report, return report, refund report, settlement report, and bank statement.
Payments and orders do not always match
Orders may be paid, failed, refunded, partially paid, settled late, or credited to the bank after deductions.
Marketplace settlements are complicated
Marketplace payouts may include sales, returns, deductions, commissions, reverse shipping, tax deductions, and previous-period adjustments.
COD collections need separate tracking
Delivered COD orders may be collected by delivery partners but remitted later, short-paid, deducted, or adjusted against returns and RTOs.
Returns and refunds create timing differences
An order may be sold in one period, returned later, refunded separately, and adjusted in a future payout or bank credit.
Excel becomes fragile
Finance teams often use multiple VLOOKUPs, pivots, filters, and manual checks across files. This becomes hard to maintain as order volume grows.
Open items are hard to explain
Teams need to know whether an item is unpaid, refunded, returned, deducted, delayed, duplicated, missing from a file, or settled in another period.
What is eCommerce reconciliation?
eCommerce reconciliation is the process of matching sales, payments, settlements, COD collections, returns, refunds, marketplace payouts, and bank credits across internal and external reports.
For example, your website may show that an order was placed. Your payment gateway may show whether the payment was successful. A marketplace may show the settlement. A delivery partner may show COD collection and remittance. A refund report may show returned or cancelled orders. Your bank statement may show the final credited amount.
Cointab helps bring these reports together so your finance team can answer:
- Which orders were paid?
- Which orders were delivered but not remitted?
- Which payments were refunded?
- Which marketplace sales were settled?
- Which COD amounts are pending or short?
- Which gateway settlements reached the bank?
- Which returns or deductions explain amount differences?
- Which records are still open for review?
Bring together website, payment, marketplace, COD, return, refund, and bank data
Cointab can reconcile eCommerce workflows using multiple reports across sales channels, payment systems, delivery partners, and internal records.
| Data source | Example records |
|---|---|
| Website / store sales report | Order ID, order date, customer, SKU, amount, order status |
| Shopify / WooCommerce / custom store data | Online orders, payment status, fulfillment status, refunds |
| Payment gateway report | Payment ID, order reference, paid amount, status, fees |
| Marketplace report | Marketplace order ID, sale amount, settlement, deductions |
| COD partner report | AWB, delivered orders, COD collected, COD remitted |
| Return report | Return ID, order reference, return date, return amount |
| Refund report | Refund ID, payment reference, refund amount, refund status |
| Settlement / payout report | Settlement ID, payout date, net amount, deductions |
| Bank statement | Final credits, UTR/reference, bank credit date |
| ERP / books report | Internal accounting entries, sales register, receipts |
| Supporting data | SKU mapping, tax data, product master, order metadata |
Users can start with a simple sales vs payment gateway workflow and later add marketplace, COD, return, refund, bank, or ERP reports as the reconciliation becomes more complete.
Find eCommerce reconciliation differences faster
Cointab helps finance teams separate clean matches from exceptions that need review.
Order paid but not fulfilled
The order is paid, but fulfillment or delivery status does not match expected records.
Delivered order not paid
An order appears delivered, but payment or COD remittance is missing.
Payment gateway settlement difference
The order payment is captured, but settlement or bank credit amount is different.
Refund mismatch
Refund amount, refund status, or refund timing does not match internal records.
Return not adjusted
A returned order is not properly adjusted against payment, settlement, or marketplace payout.
Marketplace deduction
Marketplace commissions, shipping charges, reverse shipping, penalties, or tax deductions reduce the payout.
COD remittance delay
COD amount is collected by the delivery partner but not yet remitted.
Short COD remittance
COD amount remitted by the delivery partner is lower than expected.
Bank receipt mismatch
The final amount credited in the bank does not match expected payment gateway, marketplace, or COD settlement.
Duplicate transaction
The same order, payment, refund, or settlement appears more than once.
Missing or unclear reference
Order ID, payment ID, AWB, settlement ID, UTR, or refund reference is missing or embedded in a description field.
How Cointab automates eCommerce reconciliation
Cointab gives finance teams a reusable workflow for preparing eCommerce data, matching records, reviewing exceptions, and exporting reports.
Select or create the workflow
Start with a popular reconciliation template or build a custom workflow for your store, marketplace, payment gateway, COD partner, ERP, or accounting data.
Upload or automate data
Upload CSV, XLS, or XLSX files manually, or automate recurring data input through email, SFTP, or APIs.
Map required fields
Select date, amount, and identifier columns such as order ID, transaction ID, payment reference, AWB, settlement ID, refund ID, invoice number, or bank UTR.
Add supporting data
Use supporting files for SKU mapping, return enrichment, fee logic, tax mapping, order metadata, COD mapping, or internal reference matching.
Create derived columns
Use AI to create calculated fields such as net amount, refund-adjusted amount, delivered amount, clean order ID, normalized AWB, marketplace fee amount, or settlement-adjusted amount.
Run reconciliation
Cointab applies structured matching across sales, payments, marketplace settlements, COD remittances, returns, refunds, and bank records.
Review exceptions
See fully matched, partially matched, unmatched, and skipped records, then drill into transaction-level details.
Download or automate output
Download Excel reports or push matched, unmatched, exception, or summary data back to ERP, accounting, BI, analytics, or internal systems.
Match structured records with rules and difficult exceptions with AI
Cointab applies structured matching first, then uses AI to help with difficult open transactions where references are missing, messy, or spread across multiple reports.
Structured matching
Cointab can match eCommerce records using:
Matching scenarios
One-to-one
One order matches one payment, settlement, refund, or bank entry.
One-to-many
One order maps to multiple payment, fee, tax, refund, COD, or settlement records.
Many-to-one
Multiple orders are grouped into one payout, COD remittance, or bank credit.
Many-to-many
Multiple sales, refunds, deductions, and settlements need to be grouped and compared together.
Partial matching
Identifiers match, but the amount differs because of refund, deduction, fee, shipping charge, or timing difference.
Contra / return matching
Returns, refunds, reversals, negative entries, and adjustments are netted against original sales.
AI-assisted transaction matching
After structured rules run, AI helps match difficult open transactions where:
- Order IDs are missing or partial
- References are embedded inside payment or settlement descriptions
- Marketplace remarks contain messy text
- COD partner reports use different reference formats
- Refund entries do not directly map to original sales
- AWB numbers or tracking references are inconsistent
- Multiple possible matches exist across reports
- Partner-side descriptions are unstructured
AI exception analysis
For transactions that remain open, AI can help identify possible reasons such as:
AI assists reconciliation, but Cointab keeps the output transparent, reviewable, and audit-friendly.
Clear eCommerce reconciliation reports your team can use
Cointab gives finance teams a complete report showing what matched, what partially matched, what remains unmatched, and what was skipped.
Report categories
Fully matched
Orders, payments, settlements, COD remittances, refunds, or bank credits where identifiers and amounts match.
Partially matched
Records where identifiers match but amounts differ.
Unmatched in sales / internal records
Orders or internal records present in your website, ERP, or sales report but not found in external payment, marketplace, COD, or bank data.
Unmatched in external records
Payment gateway, marketplace, COD, refund, settlement, or bank records present externally but not found in internal sales or books.
Skipped
Rows excluded because of missing, invalid, duplicate, incomplete, or unusable data.
Report capabilities
- Summary cards
- Transaction-level tables
- Matched transaction detail view
- Filters for review
- Difference amounts
- Excel export
- Manual match
- Undo manual match
- Audit-ready output
- Open-item reason and action analysis
Automate recurring eCommerce reconciliation
Once your eCommerce reconciliation workflow is configured, Cointab can automate data input, reconciliation runs, and output delivery.
Bring data into Cointab
Receive or pull data through:
- Website sales report pushed from Shopify, WooCommerce, ERP, or internal system
- Payment gateway report received daily by email
- Marketplace settlement pulled from SFTP
- COD partner remittance report uploaded automatically
- Refund report loaded on schedule
- Bank credit data added through API or file upload
Run reconciliation automatically
Schedule reconciliation:
Push output back
Send reconciliation output to:
- Fully matched orders
- Partially matched records
- Unmatched sales records
- Unmatched payment gateway records
- Unmatched marketplace records
- Unmatched COD records
- Refund differences
- Return differences
- Settlement differences
- Bank credit differences
- Exception reasons
- Suggested actions
- Excel reports
- Structured API output
Start faster with eCommerce reconciliation templates
Use a ready-made template where available, or create a custom eCommerce reconciliation workflow for your specific reports.
Website Sales vs Payment Gateway
Best for matching website or app orders with payment gateway transactions, refunds, and settlements.
View templateSales vs PG vs Bank
Best for matching sales with payment gateway records and final bank credits.
View templateSales vs Returns vs Refunds
Best for reconciling sales, return records, refund transactions, and payment adjustments.
View templateMarketplace Sales vs Settlement + Returns
Best for reconciling marketplace sales, returns, deductions, and settlement payments together.
View templateSales vs COD Partner
Best for matching internal orders with COD partner remittance reports.
View templateAmazon MTR vs Disbursement
Best for reconciling Amazon transaction data with disbursement, settlement, return, fee, deduction, and payout records.
View templateFlipkart Sales vs Settlement
Best for reconciling Flipkart sales, returns, deductions, commissions, settlements, and payouts.
View templateMyntra Sales vs Payment
Best for matching Myntra sales, payments, returns, reverse shipping, deductions, and settlement records.
View templateIf a specific eCommerce workflow is not available as a ready-made template, users can still create a custom reconciliation using their own sales, payment, marketplace, COD, refund, return, bank, and ERP reports.
See eCommerce reconciliation output before signing up
Explore demo reports and see how Cointab presents matched, partially matched, unmatched, and skipped transactions.
Sales vs Payment Gateway Demo
See how internal orders are matched with payment gateway records and how missing or partially paid transactions are highlighted.
View demo reportMarketplace Sales vs Settlement Demo
Review marketplace settlement differences, deductions, returns, and unmatched marketplace records.
View demo reportCOD Partner Reconciliation Demo
Match internal orders with delivery partner COD remittance reports and identify delayed or short remittances.
View demo reportBank Statement vs Books Demo
Compare bank entries with accounting records and identify missing, delayed, or unmatched records.
View demo reportBuilt for eCommerce and D2C finance teams
Cointab is useful for teams that regularly reconcile online sales, payments, marketplace settlements, COD remittances, refunds, returns, and bank credits.
D2C brands
For brands selling through their own website, app, payment gateways, COD partners, and marketplaces.
eCommerce finance teams
For teams reconciling sales, payments, refunds, settlements, returns, and bank receipts every period.
Marketplace sellers
For sellers reconciling Amazon, Flipkart, Myntra, and other marketplace payouts with internal sales and returns.
Operations teams
For teams reviewing order fulfillment, COD collection, return, refund, and partner-side exceptions.
Accounting teams
For teams preparing reconciliation reports for month-end close, books, and audit.
Accounting firms
For firms handling eCommerce reconciliation for multiple brands or online sellers.
Omnichannel retail businesses
For businesses reconciling website sales, store sales, payment processors, marketplaces, COD, and bank collections.
Trusted by teams handling eCommerce and marketplace reconciliation
Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across eCommerce, payments, marketplaces, COD partners, banks, 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.”
eCommerce reconciliation FAQs
Start reconciling eCommerce transactions faster
Use a ready-made eCommerce reconciliation template, build a custom workflow, or schedule a guided setup with the Cointab team.
View demo reportNo credit card required · Manual uploads and automated data flows supported