Marketplace reconciliation
Marketplace reconciliation software for finance teams
Cointab helps finance teams reconcile marketplace sales, settlements, returns, commissions, deductions, reverse shipping, taxes, and payouts across marketplace reports and internal systems.
View demo reportTrusted by teams reconciling marketplace and settlement data
Cointab is used by finance and operations teams handling recurring reconciliation across marketplaces, payments, banks, partners, and internal systems.
Marketplace reconciliation is more than sales vs payout
Marketplace finance teams need to compare sales, settlements, returns, deductions, commissions, taxes, reverse shipping, and payout data across multiple reports.
Marketplace payouts are not simple
Marketplace settlements often include sales, returns, fees, commissions, taxes, shipping charges, adjustments, and previous-period transactions in one payout cycle.
Sales and settlements may fall in different periods
An order may be sold in one period, returned in another, and settled in a later payout. This makes simple month-wise Excel matching difficult.
Deductions are hard to explain
Commissions, shipping charges, reverse shipping fees, penalties, TDS/tax deductions, promotions, and marketplace adjustments can reduce the final payout.
Returns and refunds complicate reconciliation
Returns, cancellations, RTO, refunds, reverse logistics, and claim adjustments often need to be mapped back to original sales.
Excel becomes fragile at scale
Marketplace reconciliation usually involves multiple files, many columns, high transaction volumes, and repeated logic every period.
Open items need clear action
Finance teams need to know whether an item is unpaid, delayed, deducted, returned, adjusted, duplicated, or missing from a report.
What is marketplace reconciliation?
Marketplace reconciliation is the process of matching marketplace sales and operational records with settlement, payment, return, deduction, and payout reports.
For example, your internal system may show that an order was sold on a marketplace. The marketplace may later provide settlement reports showing whether that order was paid, returned, deducted, adjusted, or included in a payout.
Cointab helps bring these records together so your finance team can answer:
- Which marketplace sales were settled?
- Which sales are still unpaid or missing from settlement?
- Which returns or refunds reduced the payout?
- Which commissions, shipping charges, or deductions explain the difference?
- Which transactions belong to a different settlement period?
- Which marketplace records do not exist in internal data?
- Which open items need follow-up with the marketplace or internal team?
Bring together sales, settlement, return, deduction, and payout data
Cointab can reconcile marketplace workflows using multiple primary reports and supporting data.
| Data source | Example records |
|---|---|
| Marketplace sales report | Order ID, SKU, sale date, item amount, tax, quantity, status |
| Settlement / payout report | Settlement ID, payout date, net amount, paid amount, adjustments |
| Return report | Return ID, order reference, return date, refund amount, return status |
| Payment report | Payment date, settlement amount, payout reference, UTR/reference |
| Commission / fee report | Marketplace commission, platform fee, payment fee, taxes |
| Reverse shipping report | Reverse logistics charges, RTO charges, shipping deductions |
| Internal order / ERP report | Internal order ID, SKU, invoice, expected amount, book entry |
| Supporting data | SKU mapping, product master, tax mapping, order metadata, fee logic |
Users can start with sales and settlement reports, then add return, commission, reverse shipping, bank, or supporting reports as the workflow becomes more advanced.
Find marketplace settlement differences faster
Cointab helps finance teams focus on exceptions instead of manually reviewing every marketplace transaction.
Sale not settled
A sale appears in the marketplace sales report but is not found in the settlement or payout report.
Settlement amount mismatch
The order or reference matches, but the settled amount is different from the expected amount.
Return not adjusted correctly
A returned order is not adjusted correctly in the settlement or refund report.
Commission difference
Marketplace commission or platform fee does not match the expected calculation.
Shipping or reverse shipping deduction
Shipping charges, reverse shipping, RTO, or logistics deductions reduce the payout.
Tax deduction mismatch
TDS, TCS, GST, VAT, or other tax-related deductions do not match expected records.
Missing payout
A settlement or payout expected for the period is missing.
Marketplace-side adjustment
The marketplace applies an adjustment, penalty, promotion, claim, or correction that needs review.
Duplicate or repeated transaction
The same order, return, or settlement entry appears more than once.
Missing or unclear reference
Order ID, settlement ID, return ID, SKU, or payout reference is missing or embedded inside another field.
How Cointab automates marketplace reconciliation
Cointab gives finance teams a reusable workflow for preparing marketplace data, matching records, reviewing exceptions, and exporting reports.
Select or create the workflow
Start with a popular marketplace reconciliation template or build a custom workflow for your marketplace, ERP, or internal reports.
Upload or automate data
Upload CSV, XLS, or XLSX files manually, or automate data input through email, SFTP, or APIs.
Map required fields
Select date, amount, and identifier columns such as order ID, transaction ID, settlement ID, payout reference, SKU, invoice number, return ID, or UTR.
Add supporting data
Use supporting files for lookups, SKU mapping, fee calculation, tax mapping, return enrichment, or internal order matching.
Create derived columns
Use AI to create calculated fields such as net settlement amount, clean order ID, fee-adjusted amount, return-adjusted amount, tax amount, or normalized SKU/reference.
Run reconciliation
Cointab applies structured matching logic across sales, settlements, returns, deductions, fees, taxes, and payout data.
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 data back to ERP, accounting, BI, analytics, or internal systems.
Match structured marketplace data 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 marketplace records using:
Matching scenarios
One-to-one
One marketplace sale matches one settlement entry.
One-to-many
One order maps to multiple settlement, fee, tax, return, or adjustment rows.
Many-to-one
Multiple orders are grouped into one payout or settlement record.
Many-to-many
Multiple marketplace transactions and multiple settlement records need to be grouped and compared.
Partial matching
Identifiers match, but the amount differs because of deductions, returns, fees, or timing.
Contra / return matching
Returns, refunds, negative entries, and reverse adjustments are netted against original sales.
AI-assisted transaction matching
After structured rules run, AI helps match difficult open transactions where:
- Order references are incomplete
- Settlement descriptions are messy
- Return or refund references do not directly map to sales
- Marketplace remarks contain embedded references
- SKU or product descriptions differ across reports
- Deduction descriptions are unstructured
- Multiple possible matches exist across sales, returns, and settlements
- Partner-side formatting is inconsistent
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 marketplace reconciliation reports your team can use
Cointab gives finance teams a clear report showing what matched, what partially matched, what remains unmatched, and what was skipped.
Report categories
Fully matched
Marketplace sales, settlements, returns, fees, or payout records where identifiers and amounts match.
Partially matched
Records where identifiers match but amounts differ.
Unmatched in sales / internal records
Marketplace orders or internal records present in your sales or ERP report but not found in settlement data.
Unmatched in marketplace / settlement records
Settlement, return, deduction, or payout records present externally but not found internally.
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 marketplace reconciliation
Once your marketplace reconciliation workflow is configured, Cointab can automate data input, reconciliation runs, and output delivery.
Bring data into Cointab
Receive or pull data through:
- Marketplace sales report received by email
- Settlement file pulled from SFTP
- Return report loaded automatically
- Reverse shipping report uploaded on schedule
- Internal ERP sales report pushed into Cointab
- Bank payout data added through API or file upload
Run reconciliation automatically
Schedule reconciliation:
Push output back
Send reconciliation output to:
- Fully matched marketplace records
- Partially matched records
- Unmatched sales records
- Unmatched settlement records
- Return/refund differences
- Fee/deduction differences
- Tax differences
- Open items
- Exception reasons
- Suggested actions
- Excel reports
- Structured API output
Start faster with marketplace reconciliation templates
Use a ready-made marketplace template where available, or create a custom marketplace reconciliation workflow for your specific reports.
Amazon 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 payout records.
View templateMyntra Sales vs Payment
Best for matching Myntra sales, payments, returns, reverse shipping, deductions, and settlement records.
View templateMarketplace Sales vs Settlement
Best for teams that want a general marketplace reconciliation workflow across sales, returns, deductions, and payouts.
View templateMarketplace Sales vs Settlement + Returns
Best for marketplace workflows where returns, refunds, and settlement adjustments need to be reconciled together.
View templateSee a marketplace reconciliation report before signing up
Open a sample Marketplace Sales vs Settlement report and see how Cointab presents matched, partially matched, unmatched, and skipped transactions.
Marketplace Sales vs Settlement Demo
See how marketplace orders are matched with settlement, return, deduction, and payout records, and how missing payouts or amount differences are highlighted.
View demo reportBuilt for marketplace finance and eCommerce teams
Cointab is useful for teams that regularly reconcile marketplace sales, returns, deductions, settlements, and payouts.
eCommerce and D2C brands
For brands selling on marketplaces and reconciling sales, returns, deductions, and payouts.
Marketplace sellers
For sellers who need a repeatable way to check whether marketplace settlements match expected amounts.
Marketplace finance teams
For teams handling high-volume order, return, fee, deduction, and settlement data.
Accounting teams
For preparing marketplace reconciliation reports for month-end close, accounting, and audit.
Outsourced finance teams
For accounting firms or finance operations teams handling marketplace reconciliation for multiple clients.
Operations teams
For teams that need visibility into returns, deductions, reverse shipping, and marketplace-side adjustments.
Trusted by teams handling marketplace and eCommerce reconciliation
Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across marketplaces, payments, banks, partners, and internal systems.
“Reconciling transactions across different marketplaces can be a daunting task, but Cointab has made it incredibly easy for us. Cointab's marketplace reconciliation and pricing management features have been invaluable for our business. The software saves us countless hours of manual work by automatically reconciling transactions from multiple marketplaces. Overall, we highly recommend Cointab to any business needing a reliable and efficient tool for financial record reconciliation across multiple marketplaces.”
Marketplace reconciliation FAQs
Start reconciling marketplace settlements faster
Use a ready-made marketplace 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