Amazon Referral Fee Verification for Marketplace Teams

Amazon referral fee verification helps marketplace finance teams compare the fees charged by Amazon against the fees they expect based on product category, price, and refund logic. Instead of checking every order in Excel, teams can upload their sales and marketplace reports, map key fields once, and review fee differences in a structured reconciliation report.

Cointab supports this workflow as a Side A and Side B reconciliation. Side A typically contains the seller's internal sales or expected fee calculation data. Side B contains Amazon reports such as referral fee previews, settlement files, or refund-related reports. The platform matches transactions, calculates differences, and separates fully matched, partially matched, unmatched, and skipped records for review.

What Amazon referral fee verification checks

Amazon referral fee verification is used to confirm whether the referral fee charged for each order is consistent with the expected fee rule. Finance teams usually want to check:

• Whether the fee charged matches the correct category-based rate
• Whether the fee amount aligns with the order value used for calculation
• Whether refund-related fee reversals or reimbursements were handled correctly
• Whether any order was overcharged, undercharged, or not charged at all
• Whether open items need follow-up before month-end close

This type of review is especially useful when product categories, selling prices, and refund scenarios change frequently.

Why referral fee reconciliation matters

Manual referral fee checks are slow and hard to audit. A finance team may need to review thousands of orders across multiple categories, each with a different fee rule. That creates a few common problems:

• Fee calculations are repeated in spreadsheets and become difficult to track
• Formula errors or copy-paste mistakes can affect the result
• Refund fee differences can be missed during a busy close cycle
• Different team members may apply different review methods
• Exceptions can stay open for too long without a clear follow-up list

A structured reconciliation process gives teams a single view of matched items, discrepancies, and unresolved items.

How Cointab handles Amazon referral fee verification

1. Upload the required reports

Users upload the reports needed for the verification workflow. Common inputs include Amazon sales or settlement data, referral fee preview data, and any internal order or sales records used to calculate the expected fee.

2. Map the key fields

Users map fields such as date, amount, order reference, SKU, ASIN, and any other identifier used to connect records across files. Once mapped, the setup can be reused for later periods.

3. Add supporting data where needed

Supporting data can be used to enrich or prepare the fee calculation before reconciliation. For Amazon referral fee verification, this may include:

• Fee rate or category mapping files
• Product master data
• SKU or ASIN mapping files
• Order metadata
• Refund or return reports

Supporting data is not reconciled directly. It is used to help calculate or normalize the primary records first.

4. Create derived columns

If the expected referral fee needs a formula, Cointab can create derived columns from the uploaded data. For example, users can calculate an expected fee based on the category rate and order value, or normalize identifiers before matching.

5. Run reconciliation

After the data is prepared, users run the reconciliation manually or on a schedule. Cointab applies structured matching logic, then uses AI to analyze any remaining open items where simple rules are not enough.

6. Review the exception report

Once processing is complete, the dashboard shows the results in a clear format. Users can filter and review:

• Fully matched transactions
• Partially matched transactions
• Unmatched transactions
• Skipped records

This helps finance teams focus on exceptions instead of checking every order line by line.

What the report shows

The reconciliation output helps teams understand both the total fee impact and the underlying transaction detail. Typical outputs include:

• Total referral fee charged by Amazon
• Expected referral fee based on the configured logic
• Overcharged fee amount
• Undercharged fee amount
• Referral fee differences linked to refunds
• Referral fee not charged on eligible orders
• Count and value of records in each exception group

Users can drill into transaction-level detail and export the report for internal review, partner follow-up, or audit support.

Common Amazon fee verification scenarios

Referral fees on sales orders

This is the most common use case. The team compares the fee charged on each sold item with the expected fee calculated from the category or product rule.

Refund-related fee checks

When an order is returned or refunded, the referral fee may need to be reversed or reimbursed according to the marketplace logic. Cointab helps teams compare the expected refund fee with the amount actually received or adjusted.

Missing or incorrect fee charges

Some orders may show a fee difference because the fee was not charged, the wrong rate was applied, or the settlement file contains incomplete information.

Category and product mapping issues

If the wrong product category is used, the expected referral fee can be off. Supporting data and derived columns help teams normalize these references before reconciliation.

Why finance teams use a reconciliation platform for this workflow

Amazon referral fee verification is not just a calculation exercise. It is a recurring finance process that affects settlement review, dispute tracking, and month-end reporting. A reconciliation platform helps teams:

• Reuse the same setup for future periods
• Reduce manual spreadsheet work
• Keep an auditable record of matched and unmatched items
• Focus on exceptions instead of full-file review
• Standardize how fee differences are reported across the team

For recurring marketplace operations, this makes the verification process faster and easier to control.

When the same setup is reused

Once configured, the same Amazon referral fee verification workflow can be used again for the next month, quarter, or custom period. Teams can upload new files, refresh the report if a file arrives late, and keep the reconciliation available on the dashboard for future reference.

FAQ

How does Cointab verify Amazon referral fees?

Cointab compares the expected referral fee calculated from your configured business rules and supporting data with the fee reported by Amazon. It then highlights matched records, differences, and exceptions.

Can refund-related fee differences be reviewed separately?

Yes. Refund-related fee amounts can be checked as part of the same reconciliation so finance teams can review both sales-side and refund-side differences in one workflow.

Can this workflow be reused for future periods?

Yes. Once the reconciliation setup is configured, it can be reused for later months or custom periods without rebuilding the workflow from scratch.

What if a report arrives late or was missed?

The missed file can be uploaded under the same reconciliation, and the report can be refreshed so the results reflect the complete data set.

Does the report show unresolved items clearly?

Yes. Cointab separates fully matched, partially matched, unmatched, and skipped records so finance teams can review open items and exceptions with clarity.