skills.rest
tomtoto757
tomtoto757COMMUNITY
Explore all skills by this author →
GitHub

marketplace-fee-reconciliation

Reconcile seller fees from Amazon, eBay, Walmart, and Etsy settlement reports into net revenue analysis.

3|1|Updated Mar 21, 2026
Search Tags:#reconciliation#ebay#marketplace fees#net revenue#amazon fba#fee analysis#settlement reports
One-click install
npx skills add https://github.com/tomtoto757/ecomm-ai-team --skill marketplace-fee-reconciliation-tomtoto757
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: marketplace-fee-reconciliation
Source: https://github.com/tomtoto757/ecomm-ai-team/tree/main/skills/analytics-reporting/finsilabs/data-analytics/marketplace-fee-reconciliation
Command: npx skills add https://github.com/tomtoto757/ecomm-ai-team --skill marketplace-fee-reconciliation-tomtoto757

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Marketplace sellers only see net bank deposits after fees are deducted, making it impossible to know true per-SKU profitability or detect fee overcharges. This Skill reconciles settlement data against expected fee schedules, categorizes every fee type, and computes true net revenue by SKU and channel. ## Core Features & Use Cases - Settlement Report Parsing: Download and parse settlement files from Amazon Seller Central, eBay, Walmart, and Etsy, including SP-API automation options. - Fee Categorization & Net Revenue Calculation: Break down referral, FBA fulfillment, storage, long-term storage, advertising, and refund fees to compute net marketplace proceeds and fee rate percentages per SKU. - FBA Overcharge Detection: Identify dimensional weight and size tier mismeasurements, dispute incorrect FBA fees, and recover reimbursements via tools like Getida. - Use Case: A seller suspects Amazon is charging FBA fees based on wrong product dimensions. Use this Skill to compare Amazon's recorded dimensions against actual measurements, flag overcharges above $10, and file reimbursement claims. ## Quick Start Reconcile my Amazon settlement file and show net revenue and fee rates per SKU for last month.

Frequently Asked Questions about marketplace-fee-reconciliation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I reconcile Amazon seller fees against my settlement report?▼

Download the flat-file settlement from Seller Central under Reports > Payments > Transaction View, then categorize each fee type (referral, FBA fulfillment, storage, advertising) and subtract them from net sales to compute net marketplace proceeds per SKU.

What tools automate marketplace fee reconciliation for Amazon and eBay?▼

A2X supports Amazon, eBay, Etsy, Walmart, and Shopify with automatic journal entries to QuickBooks or Xero. Link My Books and Seller Ledger offer similar settlement mapping, while Getida specializes in Amazon FBA reimbursement auditing on a contingency basis.

How do I detect Amazon FBA fee overcharges from wrong product dimensions?▼

Download the Fee Preview report from Seller Central and compare Amazon's recorded dimensions against actual product measurements. If they differ, submit an FBA fee dispute with photos, and file reimbursement requests for historical overcharges within the claim window.

Can I reconcile fees across multiple marketplaces like Walmart and Etsy?▼

Yes, each marketplace provides downloadable settlement reports: Walmart via Seller Center transaction reports, Etsy via monthly payment account statements, and eBay via Seller Hub payments reports. Normalize the fee categories to compare net margin per SKU across channels.

Why should I not use the marketplace payout amount as revenue?▼

The deposited payout is net of all fees, so recording it as revenue hides true costs. Record gross sales as revenue and fees as cost of revenue separately to get accurate contribution margins and GAAP-compliant books.

When are Amazon long-term storage fees charged and how do I avoid them?▼

Long-term storage fees of $6.90 per cubic foot are assessed on February 15 and August 15 for inventory older than 365 days. Pull the FBA Inventory Age report 60 days prior and run promotions, removal orders, or liquidation before the assessment date.

Related Skills

Explore More Finance & Accounting Skills→
finsilabsfinsilabs
44

marketplace-fee-reconciliation

Automates Amazon, eBay, Walmart, Etsy settlement-fee reconciliation and net revenue calculation using Python scripts.

Official
Intermediate
finsilabsfinsilabs
44

financial-reporting-dashboard

Design financial reporting dashboards with drill-downs for e-commerce businesses.

Official
Advanced
liangdabiaoliangdabiao
42

amazon-fba-calculator

Calculate Amazon FBA fees and profit margins from product dimensions, weight, and price.

Community
Intermediate
finsilabsfinsilabs
44

payment-reconciliation-automation

Match payment processor transactions against bank deposits and accounting records.

Official
Advanced