Amazon Referral Fee Reconciliation

Amazon referral fee reconciliation helps finance teams verify whether marketplace commissions charged by Amazon match the expected fee structure for each order, category, and settlement period. For sellers with high order volumes, even small fee differences can add up quickly across sales, refunds, returns, and settlement adjustments.

Cointab helps teams compare internal sales or order records against Amazon settlement and fee data, identify discrepancies, and review matched, partially matched, unmatched, and skipped transactions in one structured workflow.

Why Amazon referral fee reconciliation matters

Amazon referral fees are typically charged based on product category and order value. Because fee rates can vary across categories and transaction types, teams often need to review each settlement carefully to confirm that the charged fee aligns with the expected amount.

Without a structured reconciliation process, finance teams may rely on spreadsheets, formulas, and manual sampling to validate fees. That creates common challenges:

• Fee calculations become difficult to audit when rate cards change across categories.
• Overcharged or undercharged amounts may be missed during monthly close.
• Refunds and reversals can make settlement review more complex.
• Large order volumes make manual checks slow and repetitive.
• Different team members may prepare fee summaries differently.

Cointab replaces repetitive spreadsheet checks with a reusable reconciliation setup that can be run for each period.

How the reconciliation works

Cointab uses a Side A and Side B model for Amazon referral fee review:

• Side A: your internal sales, order, ERP, or books data
• Side B: Amazon settlement, fee, or payout reports

The process is designed for finance users who want clear control over what was compared and what was found.

Typical workflow

1. Upload the required Amazon and internal reports.
2. Map fields such as date, amount, and order or transaction identifiers.
3. Optionally add supporting data for lookups or enrichment.
4. Run reconciliation manually or on a schedule.
5. Review matched, partially matched, unmatched, and skipped items.
6. Download the Excel report for internal review, follow-up, or audit support.

What gets compared

Amazon referral fee reconciliation usually focuses on comparing the fee charged by Amazon against the expected fee based on the business’s own records and fee rules.

Common fields used in the workflow include:

• Order ID
• Transaction ID
• Settlement ID
• SKU or product identifier
• Order date or settlement date
• Sales amount
• Referral fee amount
• Refund or return reference
• Category or product group

If a business needs to enrich the data before reconciliation, Cointab can also use supporting files such as product master data, category mappings, or fee rate references.

Understanding reconciliation results

After the run completes, Cointab organizes results into clear outcome groups so finance teams can focus on exceptions.

Fully matched

These are transactions where the fee charged by Amazon matches the expected fee according to the configured reconciliation logic.

Partially matched

These are transactions where identifiers match, but the fee amount differs. Partial matches are important because they show that the transaction is related, but still needs review.

Unmatched

These are records found on one side but not the other. For Amazon referral fee reconciliation, unmatched items may point to missing settlements, missing internal records, or differences in how transactions were reported.

Skipped

These are records that were excluded from reconciliation because they were incomplete, invalid, duplicated, or did not meet the configured format.

Common fee difference scenarios

Amazon referral fee review often involves more than one kind of exception. Cointab helps teams isolate the exact type of difference so they can follow up with the right context.

Typical scenarios include:

• Overcharged fee: the fee charged is higher than the expected amount.
• Undercharged fee: the fee charged is lower than expected.
• Fee not charged: a fee is missing from the settlement or fee report.
• Refund-related difference: the fee reversal or refund treatment does not match the expected amount.

These outcomes are easier to review when they are grouped in a reconciliation report rather than checked one order at a time in Excel.

Why finance teams use Cointab for marketplace fee review

Amazon referral fee reconciliation is often part of a broader marketplace reconciliation process. Finance teams use Cointab when they need a repeatable workflow for checking sales, settlements, deductions, returns, and fees across periods.

Cointab helps teams:

• reduce manual spreadsheet work
• reuse the same reconciliation setup for future periods
• review exceptions instead of scanning every transaction
• keep an audit-friendly report history
• collaborate in a shared workspace with roles and access control

For recurring fee checks, this matters because the same logic can be applied every month without rebuilding the workflow from scratch.

Handling recurring reconciliations

Many Amazon sellers review referral fees on a monthly or settlement-period basis. Cointab supports recurring reconciliation runs so teams can keep the process consistent over time.

Users can:

• run reconciliation for a selected period
• refresh the report if a missing file arrives later
• keep completed runs available on the dashboard
• use the same workflow again for the next period

This is especially useful for finance teams that handle marketplace reporting alongside bank, payout, or books reconciliation.

Using supporting data and derived columns

Sometimes the expected fee depends on more than the core settlement file. Cointab supports supporting data and derived columns so teams can prepare records before reconciliation.

Examples include:

• product category mapping files
• fee rate references
• SKU or order master files
• return and refund data
• internal sales or ERP exports

Users can also create derived columns when they need to normalize values, calculate expected fee amounts, or prepare identifiers for matching. AI can help generate Excel-style formulas from a plain-language description.

Manual review when exceptions need attention

Not every Amazon fee exception can be matched automatically. Cointab provides manual match capabilities for cases where the finance team knows the business context and wants to resolve a specific item carefully.

This is helpful when:

• the partner file is incomplete
• a refund or adjustment needs human review
• identifiers are inconsistent across reports
• the system cannot confidently resolve the exception

Manual matches remain visible in the workflow so the reconciliation history stays auditable.

Reporting for audit and follow-up

Once reconciliation is complete, users can download Excel reports with matched, partially matched, unmatched, and skipped records. These reports help teams with:

• month-end close
• partner follow-up
• internal review
• audit preparation
• discrepancy tracking

Because the results are organized by status and exception type, finance teams can quickly see where action is needed.

Amazon referral fee reconciliation in a broader finance workflow

For many businesses, Amazon referral fee review is only one part of a larger reconciliation process. The same Cointab workflow can also support marketplace settlement reconciliation, payment reconciliation, bank reconciliation, vendor reconciliation, and customer reconciliation.

That means teams can standardize how they upload data, map fields, investigate exceptions, and export results across multiple finance processes.

What finance teams gain from a structured workflow

A structured reconciliation process makes it easier to answer practical questions such as:

• Which orders were charged the expected referral fee?
• Which transactions show a fee difference?
• Which items need follow-up with Amazon or internal teams?
• Which exceptions were manually reviewed?
• Which items should be carried forward to the next period?

Cointab is designed to make those answers visible without relying on hard-to-review formulas or fragmented spreadsheet files.

Frequently asked questions

What is Amazon referral fee reconciliation?

It is the process of comparing Amazon’s charged referral fees with the expected fee amounts based on your sales, order, category, or settlement data.

What data can be used for Amazon referral fee reconciliation?

Typical inputs include internal sales or order reports, Amazon settlement reports, fee reports, refund data, and supporting files such as product or category mappings.

Can Cointab handle overcharged and undercharged fees?

Yes. The reconciliation report can separate fee differences into clear exception groups such as overcharged, undercharged, missing, and refund-related items.

Can the same setup be reused for future periods?

Yes. Once the reconciliation is configured, the same workflow can be reused for future runs instead of rebuilding the setup each time.

Can Amazon fee reconciliation be automated?

Yes. Cointab supports scheduled reconciliation runs and data automation through email, SFTP, or API-based workflows, depending on the plan and setup.

What happens if a file is missing?

Users can upload the missed file under the same reconciliation and refresh the report so the comparison can be completed with the correct data.