marketplace-fee-reconciliation

Reconcile marketplace settlement data to compute net proceeds by SKU and fee category.

14|3|Updated Mar 22, 2026
One-click install
npx skills add https://github.com/tomtoto757/ecomm-ai-skills-hub --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-skills-hub/tree/main/skills/analytics-reporting/finsilabs/data-analytics/marketplace-fee-reconciliation
Command: npx skills add https://github.com/tomtoto757/ecomm-ai-skills-hub --skill marketplace-fee-reconciliation-tomtoto757

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Sellers and finance teams struggle to understand true product-level profitability because marketplace disbursements are net of many fees; this Skill reconciles settlements and computes net proceeds by SKU so you can see which fees are reducing margin.

Core Features & Use Cases

  • Multi-marketplace reconciliation: Instructions and mappings for Amazon, eBay, Walmart, and Etsy settlements including SP-API and flat-file workflows.
  • Per-SKU fee decomposition: Breaks out referral, fulfillment, storage, long-term storage, advertising, and refund fees and computes net proceeds and fee-rate percentages.
  • FBA overcharge detection & recommendations: Dimensional weight checks, size-tier logic, and prioritized operational recommendations (FBM switch, removal, liquidation, pricing review).
  • Automation-ready outputs: Guidance to produce CSV/JSON summaries, journal-entry-ready outputs for accounting tools, and integration notes for A2X/Getida workflows.

Quick Start

Reconcile January settlements for Amazon and eBay, produce a per-SKU CSV showing gross revenue, each fee category, net marketplace proceeds, and fee-rate percentages.

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 settlement data to calculate per-SKU net revenue?

To reconcile Amazon settlement data, you parse flat-file or SP-API exports to map fee types to standardized categories, computing accurate net proceeds and fee-rate percentages for each SKU.

What is marketplace fee reconciliation and why do I need it for FBA?

Marketplace fee reconciliation breaks out referral, fulfillment, storage, and refund fees from disbursements to compute true product-level profitability, showing exactly which FBA fees are reducing your margins.

Can I use CSV settlement exports to detect FBA overcharges by size tier?

Yes, you can use CSV settlement exports to perform FBA overcharge detection by applying dimensional weight checks and size-tier logic to identify incorrect fulfillment fees.

Does marketplace fee reconciliation work with eBay, Walmart, and Etsy settlements?

Yes, marketplace fee reconciliation supports multi-marketplace workflows for eBay, Walmart, and Etsy, mapping their specific fee types into standardized categories for cross-channel fee comparison.

How do I generate journal-entry-ready accounting outputs from marketplace settlements?

You can generate journal-entry-ready outputs by reconciling settlement data into CSV or JSON summaries, which can then be integrated directly into accounting tools like A2X or Getida workflows.

What's the best way to compare multi-channel fee rates across different marketplaces?

The best way to compare multi-channel fee rates is to map fee types from Amazon, eBay, Walmart, and Etsy settlements into standardized categories, computing net proceeds and fee-rate percentages per SKU.