Popular reconciliation template
Amazon MTR vs Disbursement Reconciliation
Reconcile Amazon MTR with Amazon disbursement reports to match sales, returns, fees, deductions, taxes, settlements, and payout amounts in one structured workflow.
View demo reportReconcile Amazon transaction data with actual disbursements
Amazon reports can include sales, returns, refunds, fees, taxes, commissions, adjustments, and final disbursement amounts. Cointab helps bring these into a clear reconciliation report.
The Amazon MTR vs Disbursement reconciliation helps sellers compare transaction-level Amazon data with the amounts actually disbursed by Amazon.
This helps finance teams answer questions such as:
- Which Amazon orders were settled?
- Which sales are not yet disbursed?
- Which returns or refunds reduced the payout?
- Which deductions, fees, or taxes explain the difference?
- Which transactions are present in MTR but not in disbursement?
- Which disbursement entries do not have a matching transaction?
- Which items need follow-up or internal review?
This template is useful for Amazon sellers, eCommerce brands, marketplace finance teams, and accounting teams that need a repeatable Amazon reconciliation process.
Required files for this template
Cointab's ready-made workflow is designed around standard Amazon reports used for transaction and disbursement reconciliation.
| Data source | Example records |
|---|---|
| Amazon MTR | Used as the transaction-level report containing sales, returns, tax, fee, or order-level marketplace details. |
| Amazon Disbursement Report | Used to compare transaction-level records with Amazon settlement or payout-level data. |
| Return / Refund Report | Used where returns, refunds, or reverse adjustments need to be reconciled separately or enriched into the workflow. |
| Internal Order / ERP Report | Optional, but useful if the finance team also wants to compare Amazon data with internal sales, books, or ERP records. |
| Supporting Data | Optional supporting files for SKU mapping, tax mapping, product information, internal order references, fee logic, or other enrichment. |
What Cointab matches in Amazon reconciliation
Cointab compares transaction, settlement, return, deduction, and payout information across Amazon reports.
Sales and order records
Match Amazon sales transactions with corresponding settlement or disbursement entries.
Returns and refunds
Identify whether returned or refunded orders are correctly reflected in the disbursement.
Fees and deductions
Track Amazon fees, commissions, shipping charges, taxes, adjustments, penalties, or other deductions where available.
Settlement and payout amounts
Compare expected settlement amounts with actual disbursement or payout records.
Tax and adjustment records
Review tax-related differences, adjustments, and marketplace-side changes where relevant.
Internal records, if added
If internal ERP or order reports are included, Cointab can also compare Amazon records against the company's internal sales or books data.
Common Amazon reconciliation exceptions
Cointab helps finance teams focus on differences instead of manually reviewing every Amazon transaction.
Sale not disbursed
A sale appears in Amazon MTR but is not found in the disbursement report for the selected period.
Disbursement without matching sale
A disbursement or settlement entry appears without a clear matching transaction in MTR.
Amount mismatch
The transaction reference matches, but the expected amount and disbursed amount are different.
Return or refund difference
A refund, return, or reverse adjustment does not match expected records.
Fee or commission difference
Marketplace fees, commissions, taxes, shipping charges, or other deductions explain part of the settlement difference.
Settlement timing difference
A transaction belongs to one period but is settled in a later disbursement cycle.
Duplicate or repeated entry
The same transaction appears more than once or is included in multiple files.
Missing or unclear reference
Order ID, 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, or unusable.
How this ready-made reconciliation works
Cointab pre-configures the workflow so your team does not need to rebuild the Amazon reconciliation setup every period.
Select the template
Choose Amazon MTR vs Disbursement from popular reconciliations.
Select the period
Choose the month, quarter, year, lifetime period, or custom period you want to reconcile.
Upload Amazon reports
Upload Amazon MTR, disbursement report, and any required return, refund, 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 Amazon MTR and disbursement 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 Amazon transaction matches one disbursement entry.
One-to-many
One sale or order maps to multiple fee, tax, refund, or settlement records.
Many-to-one
Multiple transactions are grouped into one disbursement or payout.
Many-to-many
Multiple Amazon records and multiple disbursement records are grouped and compared.
Partial matching
Identifiers match, but amounts differ.
Net and contra matching
Sales, returns, refunds, fees, and adjustments 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
- Settlement details contain embedded references
- Return or refund entries do not directly map to sales
- Amounts require contextual understanding
- Partner-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 Amazon reconciliation reports
Cointab gives your team a clear report showing which Amazon transactions matched, partially matched, remained unmatched, or were skipped.
Report categories
Fully matched
Amazon MTR and disbursement records where identifiers and amounts match.
Partially matched
Records where identifiers match but amounts differ.
Unmatched in MTR
Transactions present in Amazon MTR but not found in the disbursement report.
Unmatched in disbursement
Disbursement records that do not clearly match MTR transactions.
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 Amazon 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 Amazon records
- Unmatched MTR records
- Unmatched disbursement records
- Return/refund differences
- Fee/deduction differences
- Open items
- Suggested actions
- Excel reconciliation report
- Structured API output
View an Amazon reconciliation demo report
See how Cointab presents Amazon MTR vs Disbursement output with matched, partially matched, unmatched, and skipped transactions.
Amazon MTR vs Disbursement Demo
Explore a sample report showing Amazon sales, returns, deductions, disbursement records, and open items.
View demo reportExplore related marketplace reconciliations
Cointab supports other marketplace and settlement reconciliation workflows.
Flipkart Sales vs Settlement
Reconcile Flipkart sales, returns, deductions, settlements, and payout reports.
View templateMarketplace Sales vs Settlement
Use a general marketplace reconciliation workflow for sales, returns, deductions, and payouts.
View templateSales vs Payment Gateway
Reconcile website or app sales with PSP payments, refunds, and settlements.
View templateBuilt for Amazon sellers and marketplace finance teams
This template is useful for teams that regularly reconcile Amazon transactions, deductions, returns, and disbursements.
eCommerce brands
For brands selling on Amazon and reconciling marketplace payouts with sales and returns.
Online sellers
For sellers who need a repeatable process to check whether Amazon disbursements match expected amounts.
Marketplace finance teams
For teams handling high-volume order, return, deduction, and settlement data.
Accounting teams
For teams preparing reconciliation reports for month-end close, books, and audit.
Outsourced finance teams
For accounting firms or finance operations teams handling Amazon 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.
“From last one year we are using this software from Cointab for reconciliation of Amazon's charges. really their software is very much perfect and we are fully satisfied with this.”
Amazon MTR vs Disbursement FAQs
Start Amazon MTR vs Disbursement reconciliation
Use Cointab's ready-made Amazon reconciliation workflow to match transactions, identify differences, review exceptions, and export audit-ready reports.
View demo reportReady-made workflow · Reusable every period · Manual upload and automation supported