Popular reconciliation template
Marketplace Sales vs Settlement Reconciliation
Reconcile marketplace sales with settlement reports to match orders, returns, refunds, commissions, deductions, taxes, payout amounts, and open items in one structured workflow.
View demo reportReconcile marketplace sales with settlement payouts
Marketplace reports can include sales, returns, refunds, commissions, shipping fees, penalties, taxes, deductions, adjustments, and final payout amounts. Cointab helps bring these into a clear reconciliation report.
The Marketplace Sales vs Settlement reconciliation helps finance teams compare transaction-level marketplace sales data with settlement, payout, return, refund, fee, and deduction records received from marketplaces.
This helps finance teams answer questions such as:
- Which marketplace orders were settled?
- Which sales are not yet included in settlement?
- Which returns or refunds reduced the payout?
- Which commissions, fees, penalties, or deductions explain the difference?
- Which settlement entries do not have a matching marketplace sale?
- Which payout amounts should be received in the bank?
- Which transactions belong to another settlement cycle or period?
- Which items need marketplace follow-up or internal review?
This template is useful for eCommerce brands, D2C companies, online sellers, marketplace finance teams, and accounting teams that need a repeatable marketplace reconciliation process.
Required files for this template
Cointab's ready-made workflow is designed around common marketplace sales, settlement, payout, return, refund, fee, and deduction reports used for marketplace reconciliation.
| Data source | Example records |
|---|---|
| Marketplace Sales Report | Used as the transaction-level report containing marketplace orders, sales amounts, order dates, product details, customer references, and marketplace order IDs. |
| Marketplace Settlement / Payout Report | Used to compare marketplace sales records with settlement, payout, and payment data provided by the marketplace. |
| Return / Refund Report | Used where returns, refunds, reverse logistics, cancellations, or customer adjustments need to be reconciled separately or enriched into the workflow. |
| Fee / Commission / Deduction Report | Used where marketplace commissions, shipping fees, penalties, marketing charges, tax deductions, or other marketplace deductions need to be reviewed. |
| Bank Statement | Optional, but useful if the finance team also wants to compare marketplace payouts with actual bank credits. |
| Internal Order / ERP Report | Optional, but useful if the finance team wants to compare marketplace data with internal sales, books, ERP, or order management records. |
| Supporting Data | Optional supporting files for SKU mapping, tax mapping, product information, marketplace order mapping, fee logic, store mapping, internal order references, or other enrichment. |
What Cointab matches in marketplace reconciliation
Cointab compares marketplace sales, settlement entries, return records, refund data, deductions, commissions, taxes, payout amounts, and optional bank or ERP data across reports.
Sales and order records
Match marketplace sales transactions with corresponding settlement or payout entries.
Returns and refunds
Identify whether returned, cancelled, or refunded orders are correctly reflected in the settlement report.
Marketplace fees and commissions
Track marketplace commissions, service fees, shipping charges, penalties, marketing charges, taxes, and other deductions where available.
Settlement and payout amounts
Compare expected settlement amounts with actual payout or disbursement records from the marketplace.
Tax and adjustment records
Review tax-related differences, withholding, marketplace adjustments, and settlement-side changes where relevant.
Bank credits, if added
If bank statements are included, Cointab can also compare marketplace payouts with actual bank credits.
Internal records, if added
If internal ERP, order, or books reports are included, Cointab can compare marketplace sales and settlement records against the company's internal data.
Common marketplace reconciliation exceptions
Cointab helps finance teams focus on marketplace differences instead of manually reviewing every order, return, deduction, and payout line.
Sale not settled
A marketplace sale appears in the sales report but is not found in the settlement report for the selected period.
Settlement without matching sale
A settlement or payout entry appears without a clear matching marketplace sale or order record.
Amount mismatch
The order or transaction reference matches, but the expected amount and settled amount are different.
Return or refund difference
A return, refund, cancellation, or reverse adjustment does not match expected records.
Commission or fee difference
Marketplace commissions, service fees, shipping charges, penalties, taxes, or other deductions explain part of the settlement difference.
Settlement timing difference
A sale belongs to one period but is settled in a later payout or settlement cycle.
Payout not received in bank
A marketplace payout is expected, but the matching bank credit is missing or delayed.
Duplicate or repeated entry
The same order, return, deduction, or settlement record appears more than once or is included in multiple files.
Missing or unclear reference
Marketplace order ID, settlement ID, transaction reference, SKU, or bank 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 marketplace reconciliation setup every period.
Select the template
Choose Marketplace Sales vs Settlement from popular reconciliations.
Select the period
Choose the month, quarter, year, lifetime period, or custom period you want to reconcile.
Upload marketplace reports
Upload marketplace sales, settlement, payout, return, refund, fee, deduction, bank, or supporting files as required for the workflow.
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 marketplace sales and settlement 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 marketplace sale matches one settlement entry.
One-to-many
One marketplace order maps to multiple fee, tax, refund, return, or settlement records.
Many-to-one
Multiple marketplace orders are grouped into one settlement or payout.
Many-to-many
Multiple marketplace sales and multiple settlement records are grouped and compared.
Partial matching
Identifiers match, but amounts differ.
Net and contra matching
Sales, returns, refunds, fees, commissions, taxes, and adjustments are netted where required.
AI-assisted transaction matching
After structured rules run, AI helps match difficult open transactions where:
- References are incomplete
- Marketplace descriptions are messy
- Settlement details contain embedded references
- Return or refund entries do not directly map to sales
- Fees or deductions are grouped differently
- Amounts require contextual understanding
- Marketplace-side descriptions are inconsistent
- 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 marketplace reconciliation reports
Cointab gives your team a clear report showing which marketplace sales and settlement records matched, partially matched, remained unmatched, or were skipped.
Report categories
Fully matched
Marketplace sales and settlement records where identifiers and amounts match.
Partially matched
Records where identifiers match but amounts differ.
Unmatched in marketplace sales
Sales records present in the marketplace sales report but not found in the settlement report.
Unmatched in settlement
Settlement or payout records that do not clearly match marketplace sales records.
Unmatched in bank, if added
Bank credit records or expected payouts that do not clearly match marketplace settlement data.
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 marketplace 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 marketplace sales
- Unmatched marketplace sales
- Unmatched settlement records
- Return and refund differences
- Commission differences
- Fee and deduction differences
- Tax differences
- Payout differences
- Bank credit differences, if bank data is included
- Open items
- Suggested actions
- Excel reconciliation report
- Structured API output
View a marketplace reconciliation demo report
See how Cointab presents Marketplace Sales vs Settlement output with matched, partially matched, unmatched, and skipped transactions.
Marketplace Sales vs Settlement Demo
Explore a sample report showing marketplace sales, returns, deductions, settlement records, payout differences, and open items.
View demo reportExplore related marketplace reconciliations
Cointab supports other marketplace, settlement, payment, bank, and eCommerce reconciliation workflows.
Amazon MTR vs Disbursement
Match Amazon order and transaction data with Amazon disbursement reports.
View templateFlipkart Sales vs Settlement
Reconcile Flipkart sales, settlements, returns, deductions, and payouts.
View templateSales vs Payment Gateway
Reconcile website or app sales with PSP payments, refunds, settlements, and payouts.
View templateBuilt for marketplace sellers and finance teams
This template is useful for teams that regularly reconcile marketplace sales, returns, deductions, settlements, payouts, and open items.
eCommerce brands
For brands selling across marketplaces and reconciling marketplace payouts with sales, returns, deductions, and refunds.
D2C companies
For D2C teams that sell through marketplace channels and need to compare expected sales with marketplace settlement amounts.
Online sellers
For sellers who need a repeatable process to check whether marketplace settlements match expected amounts.
Marketplace finance teams
For teams handling high-volume order, return, deduction, commission, and settlement data.
Accounting teams
For teams preparing marketplace reconciliation reports for month-end close, books, and audit.
Operations teams
For teams reviewing return statuses, SKU-level differences, marketplace deductions, and unresolved partner-side issues.
Outsourced finance teams
For accounting firms or finance operations teams handling marketplace reconciliation for multiple clients.
Trusted by teams handling marketplace 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.
“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.”
Marketplace Sales vs Settlement FAQs
Start Marketplace Sales vs Settlement reconciliation
Use Cointab's ready-made marketplace reconciliation workflow to match sales, identify settlement differences, review exceptions, and export audit-ready reports.
View demo reportReady-made workflow · Reusable every period · Manual upload and automation supported