Popular reconciliation template
Marketplace Sales vs Settlement + Returns Reconciliation
Reconcile marketplace sales, settlement reports, and return records to match orders, refunds, deductions, commissions, taxes, payout amounts, and open items in one structured workflow.
View demo reportReconcile marketplace sales, settlements, and returns together
Marketplace reports can include sales, returns, refunds, commissions, shipping fees, penalties, taxes, deductions, adjustments, and payout amounts. Cointab helps bring these into a clear reconciliation report.
The Marketplace Sales vs Settlement + Returns reconciliation helps finance teams compare marketplace sales records with settlement reports and return or refund data.
This helps finance teams answer questions such as:
- Which marketplace orders were sold and settled?
- Which sales are not yet included in settlement?
- Which returned orders reduced the payout?
- Which refunds or reverse adjustments were applied by the marketplace?
- Which commissions, fees, penalties, or deductions explain the settlement difference?
- Which settlement entries do not have a matching sale or return record?
- Which payout amounts should be received in the bank?
- 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 sales, settlement, and returns reconciliation process.
Required files for this template
Cointab's ready-made workflow is designed around common marketplace sales, settlement, payout, return, refund, fee, deduction, and bank 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, SKUs, and marketplace order IDs. |
| Marketplace Settlement / Payout Report | Used to compare marketplace sales and return records with settlement, payout, and payment data provided by the marketplace. |
| Return / Refund Report | Used to compare sold orders with returned items, refund transactions, reverse logistics adjustments, cancellations, and customer refunds. |
| Fee / Commission / Deduction Report | Used where marketplace commissions, shipping fees, penalties, marketing charges, tax deductions, return deductions, or other marketplace adjustments 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 can be used for SKU mapping, tax mapping, product information, marketplace order mapping, fee logic, return reason mapping, internal order references, or other enrichment. |
What Cointab matches in marketplace sales, settlement, and returns 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 marketplace settlement and refund reports.
Marketplace fees and commissions
Track marketplace commissions, service fees, shipping charges, return 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.
Return adjustments
Review how returns, refunds, reverse logistics charges, and customer adjustments affect the final settlement amount.
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, return, and settlement records against the company's internal data.
Common marketplace sales, settlement, and returns 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.
Return not adjusted
A return appears in the return report but is not reflected correctly in the settlement report.
Refund mismatch
A refund or reverse adjustment does not match the expected sale, return, or settlement record.
Amount mismatch
The order, return, or settlement reference matches, but the expected amount and settled amount are different.
Commission or fee difference
Marketplace commissions, service fees, shipping charges, return charges, penalties, taxes, or other deductions explain part of the settlement difference.
Settlement timing difference
A sale or return belongs to one period but is settled or adjusted in a later payout 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, refund, or settlement record appears more than once or is included in multiple files.
Missing or unclear reference
Marketplace order ID, return 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 sales, settlement, and returns reconciliation setup every period.
Select the template
Choose Marketplace Sales vs Settlement + Returns 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, settlement, and return 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 or one return adjustment.
One-to-many
One marketplace order maps to multiple fee, tax, refund, return, deduction, or settlement records.
Many-to-one
Multiple marketplace orders, returns, or adjustments are grouped into one settlement or payout.
Many-to-many
Multiple marketplace sales, return records, and settlement records are grouped and compared.
Partial matching
Identifiers match, but amounts differ.
Net and contra matching
Sales, returns, refunds, fees, commissions, taxes, deductions, 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
- Marketplace return data is grouped differently
- Fees or deductions are grouped across multiple orders
- 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 sales, settlement, and returns reconciliation reports
Cointab gives your team a clear report showing which marketplace sales, settlement, and return records matched, partially matched, remained unmatched, or were skipped.
Report categories
Fully matched
Marketplace sales, settlement, and return records where identifiers and amounts match.
Partially matched
Records where identifiers match but sales, return, refund, deduction, or settlement amounts differ.
Unmatched in marketplace sales
Sales records present in the marketplace sales report but not found in settlement or return data.
Unmatched in settlement
Settlement or payout records that do not clearly match marketplace sales or return records.
Unmatched in returns
Return or refund records that do not clearly match original 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 sales, settlement, and returns 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
- Matched return and settlement records
- Unmatched marketplace sales
- Unmatched settlement records
- Unmatched return 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 sales, settlement, and returns demo report
See how Cointab presents Marketplace Sales vs Settlement + Returns output with matched, partially matched, unmatched, and skipped transactions.
Marketplace Sales vs Settlement + Returns Demo
Explore a sample report showing marketplace sales, returns, refunds, deductions, settlement records, payout differences, and open items.
View demo reportExplore related marketplace reconciliations
Cointab supports other marketplace, settlement, return, 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 templateMarketplace Sales vs Settlement
Use a general marketplace reconciliation workflow for sales, deductions, settlements, 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 handling returns
This template is useful for teams that regularly reconcile marketplace sales, returns, refunds, 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, returns, and settlement amounts.
Online sellers
For sellers who need a repeatable process to check whether marketplace settlements and return adjustments match expected amounts.
Marketplace finance teams
For teams handling high-volume order, return, deduction, commission, refund, 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 sales, settlement, and returns reconciliation
Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across marketplaces, payments, returns, 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 + Returns FAQs
Start Marketplace Sales vs Settlement + Returns reconciliation
Use Cointab's ready-made marketplace reconciliation workflow to match sales, returns, settlements, identify differences, review exceptions, and export audit-ready reports.
View demo reportReady-made workflow · Reusable every period · Manual upload and automation supported