Marketplace Fee Reconciliation

Marketplace Fee Reconciliation

Overview

Selling on marketplaces like Amazon, eBay, Walmart, and Etsy introduces a complex layer of fees that significantly impact net profitability. Amazon alone has over a dozen distinct fee types: referral fees, FBA fulfillment fees, storage fees, advertising fees, return processing fees, and more. These fees are deducted before disbursement, making it easy to lose track of how much of your gross revenue actually reaches your bank account.

Fee reconciliation is the practice of matching marketplace settlement data against your expected fee schedule, verifying that you have been charged correctly, and computing true net revenue by SKU and category.

This skill guides you through downloading settlement reports from each major marketplace, reconciling fees against expectations, and using dedicated tools to automate this process.

When to Use This Skill

• When selling on Amazon, eBay, Walmart, or Etsy and needing to understand true net revenue
• When suspecting FBA fulfillment fee overcharges due to incorrect product dimensions
• When reconciling marketplace payouts against your GL on a monthly basis
• When computing true contribution margin per SKU by channel including marketplace fees
• When evaluating whether to move products from FBA to FBM (fulfilled by merchant)
• When building a multi-channel profitability model with normalized fee data

Core Instructions

Step 1: Download settlement reports from each marketplace

Amazon (Seller Central): 1. Go to Seller Central → Reports → Payments → Transaction View 2. Click Download flat file (.txt) for each settlement period (bi-weekly) 3. Alternatively, access via the SP-API (Selling Partner API): use the /finances/v0/financialEventGroups endpoint for automated downloads 4. Key settlement fields: transaction type, fee type, amount, order ID, SKU

eBay: 1. Go to eBay Seller Hub → Payments → Payments report 2. Download as CSV (monthly or custom date range) 3. eBay Payments API is available for programmatic access

Walmart Marketplace: 1. Go to Walmart Seller Center → Payments → Transaction Report 2. Download monthly CSV 3. Walmart's Seller API provides programmatic access via the /payments/filepayments endpoint

Etsy: 1. Go to Etsy Shop Manager → Finances → Payment account 2. Download monthly statement CSV 3. Note: Etsy fees include listing fees, transaction fees (6.5%), payment processing fees, and offsite ads fees (if enrolled)

Step 2: Use a dedicated reconciliation tool (recommended)

Before building custom tooling, check if an existing tool handles your marketplace:

A2X setup (most comprehensive): 1. Connect A2X to your marketplace accounts (Amazon Seller Central, eBay, Etsy) 2. Connect A2X to QuickBooks Online or Xero 3. A2X automatically imports each settlement, categorizes fees (referral, fulfillment, storage, advertising, refund fees), and creates journal entries 4. Go to A2X → Settlements — view each settlement with fee breakdown; click any settlement to see the journal entry it will create 5. Review and post journal entries to your accounting system monthly

Step 3: Categorize and analyze marketplace fees

Amazon fee categories to track separately:

Build a fee summary by SKU (using a spreadsheet or A2X):

For each SKU and period, calculate:

Gross Revenue
  - Returns & Refunds
= Net Sales

  - Referral Fees
  - FBA Fulfillment Fees
  - Storage Fees
  - Long-term Storage Fees
  - Advertising Fees
  - Return Processing Fees
= Net Marketplace Proceeds

Total Fee Rate % = Total Fees / Net Sales × 100
Net Margin % = Net Proceeds / Net Sales × 100

Typical Amazon total take rate by category:

• Apparel: 25–35% (high referral + FBA for bulky items)
• Electronics: 15–20%
• Health & Beauty: 20–30%
• Home & Kitchen: 18–28%
• Books: 15–20%

If your actual fee rate is 5%+ above these ranges, investigate for potential overcharges.

Step 4: Identify FBA fee overcharges

Amazon FBA fees are based on product dimensions and weight stored in their system. If Amazon has incorrect measurements for your product, you may be paying systematically higher fees on every unit shipped.

How to check for FBA measurement errors: 1. Go to Seller Central → Reports → Fulfillment → Fee Preview — download the fee preview report 2. Compare the dimensions Amazon has on file against your actual product measurements 3. Go to Seller Central → Inventory → Manage Inventory → [Product] → FBA product review to see the dimensions Amazon is using

How to dispute an FBA measurement: 1. Go to Seller Central → Help → Contact Us → FBA issue → FBA fee dispute 2. Submit a dispute with photos showing your product's actual dimensions 3. Amazon has up to 90 days to investigate; if the dispute is upheld, fees are corrected going forward 4. For historical overcharges: file a reimbursement request via Seller Central → Help → Contact Us → Reimbursements

Using Getida for systematic reimbursement recovery: 1. Sign up at getida.com — Getida works on a contingency fee basis (takes ~25% of recovered amounts) 2. Grant Getida SP-API access to your Seller Central account 3. Getida audits 18 months of historical FBA fees and claims reimbursements automatically 4. You receive the net recovery with no upfront cost

Step 5: Monitor long-term storage fees proactively

Amazon charges long-term storage fees on inventory held more than 365 days, assessed on February 15 and August 15 each year. These fees can be significant — $6.90 per cubic foot.

Proactive monitoring: 1. 60 days before the assessment date (December 15 and June 15), go to Seller Central → Reports → Fulfillment → Inventory Age 2. Download the report and filter for items with more than 270 days in FBA 3. For items approaching 365 days, evaluate:

• Price reduction: Run a sale or promotion to accelerate sell-through
• Removal order: Request Amazon to return inventory to you (removal fee applies but is lower than long-term storage fee for most items)
• Liquidation: Amazon's liquidation program sells inventory to resellers at ~5–10% of the listed price

Step 6: Build a multi-channel fee comparison

Once you have fee data from multiple marketplaces, compare net margin per SKU across channels:

Example comparison for one SKU at $39.99 selling price:

This comparison shows which channel generates the most net proceeds per unit sold.

Best Practices

• Reconcile every settlement, not just month-end — Amazon produces bi-weekly settlements; reconcile each one within 3 business days of receipt to catch discrepancies early
• Use A2X or Link My Books to automate journal entries — manual entry of marketplace settlements is error-prone; these tools save 4–8 hours per month and create accurate GAAP entries
• Track fee rates as a percentage of revenue — absolute fee amounts grow with revenue; tracking fee rate % lets you monitor fee efficiency independent of volume changes
• Submit FBA reimbursement claims systematically — claims must typically be submitted within 90–180 days; automate detection with Getida or SELLERBOARD to avoid leaving money unclaimed
• Separate advertising spend from transaction fees — marketing spend (Sponsored Products) is a strategic investment decision; transaction fees (referral, fulfillment) are unavoidable cost of sales; keep them in separate GL accounts
• Monitor net payout timing for cash flow — marketplace disbursements have holds and reserves; build the expected payout schedule into your cash flow model (see @cash-flow-forecasting)

Common Pitfalls

Related Skills

• @profit-margin-analysis
• @cost-allocation-analysis
• @cash-flow-forecasting
• @financial-reporting-dashboard

Amazon Settlement Fee Analysis

Problem/Feature Description

Finley Home Goods sells kitchen products on Amazon and has just received their bi-weekly settlement file from Seller Central. The finance team wants to understand exactly how much they're paying in each type of fee per product SKU so they can identify which fees are hurting margins most. The settlement file contains a mix of order proceeds, FBA fulfillment charges, referral fees, storage fees, advertising spend, and refund-related fees — all in a single flat file.

The finance analyst has extracted the raw settlement data and needs a Python script that parses the file, classifies each transaction by fee type, and produces a clean per-SKU fee summary broken down by category. The analyst specifically wants advertising fees called out separately from the unavoidable transaction fees, since advertising is a discretionary spend they want to analyze on its own.

Output Specification

Write a Python script named parse_settlement.py that: 1. Reads the provided settlement file (settlement.tsv) 2. Parses and normalizes the data 3. Maps each transaction's fee type to a fee category 4. Produces a CSV output file named fee_summary_by_sku.csv with per-SKU fee totals broken out by category

The script should print a brief summary to stdout showing total fees collected per category across all SKUs.

Input Files

The following files are provided as inputs. Extract them before beginning.

=============== FILE: settlement.tsv =============== settlement-id settlement-start-date settlement-end-date transaction-type order-id merchant-order-id shipment-id marketplace-name amount-type amount-description amount quantity-purchased posted-date sku product-description 1234567890 2026-02-01 2026-02-14 Order 112-3456789-0000001 SHP001 Amazon.com ItemPrice Principal 29.99 1 2026-02-03 KIT-001 Bamboo Cutting Board 1234567890 2026-02-01 2026-02-14 Order 112-3456789-0000001 SHP001 Amazon.com ItemFees FBAPerUnitFulfillmentFee -3.22 1 2026-02-03 KIT-001 Bamboo Cutting Board 1234567890 2026-02-01 2026-02-14 Order 112-3456789-0000001 SHP001 Amazon.com ItemFees Commission -4.50 1 2026-02-03 KIT-001 Bamboo Cutting Board 1234567890 2026-02-01 2026-02-14 Order 112-3456789-0000002 SHP002 Amazon.com ItemPrice Principal 49.99 1 2026-02-04 KIT-002 Stainless Steel Pan Set 1234567890 2026-02-01 2026-02-14 Order 112-3456789-0000002 SHP002 Amazon.com ItemFees FBAPerUnitFulfillmentFee -5.80 1 2026-02-04 KIT-002 Stainless Steel Pan Set 1234567890 2026-02-01 2026-02-14 Order 112-3456789-0000002 SHP002 Amazon.com ItemFees Commission -7.50 1 2026-02-04 KIT-002 Stainless Steel Pan Set 1234567890 2026-02-01 2026-02-14 Order 112-3456789-0000003 SHP003 Amazon.com ItemPrice Principal 29.99 2 2026-02-05 KIT-001 Bamboo Cutting Board 1234567890 2026-02-01 2026-02-14 Order 112-3456789-0000003 SHP003 Amazon.com ItemFees FBAPerUnitFulfillmentFee -6.44 2 2026-02-05 KIT-001 Bamboo Cutting Board 1234567890 2026-02-01 2026-02-14 Order 112-3456789-0000003 SHP003 Amazon.com ItemFees Commission -9.00 2 2026-02-05 KIT-001 Bamboo Cutting Board 1234567890 2026-02-01 2026-02-14 Refund 112-3456789-0000002 SHP002 Amazon.com ItemFees RefundCommission 1.50 1 2026-02-07 KIT-002 Stainless Steel Pan Set 1234567890 2026-02-01 2026-02-14 other-transaction Amazon.com other-transaction FBAStorageFee -12.80 2026-02-14 KIT-001 Bamboo Cutting Board 1234567890 2026-02-01 2026-02-14 other-transaction Amazon.com other-transaction FBAStorageFee -8.40 2026-02-14 KIT-002 Stainless Steel Pan Set 1234567890 2026-02-01 2026-02-14 other-transaction Amazon.com other-transaction FBALongTermStorageFee -45.00 2026-02-14 KIT-001 Bamboo Cutting Board 1234567890 2026-02-01 2026-02-14 other-transaction Amazon.com Subscription Subscription -39.99 2026-02-14 1234567890 2026-02-01 2026-02-14 other-transaction Amazon.com Sponsored Products Sponsored Products -28.50 2026-02-14 KIT-001 Bamboo Cutting Board 1234567890 2026-02-01 2026-02-14 other-transaction Amazon.com Sponsored Brands Sponsored Brands -15.00 2026-02-14 KIT-002 Stainless Steel Pan Set 1234567890 2026-02-01 2026-02-14 other-transaction Amazon.com Lightning Deal fees Lightning Deal fees -5.00 2026-02-14 KIT-001 Bamboo Cutting Board 1234567890 2026-02-01 2026-02-14 other-transaction Amazon.com other-transaction other-transaction -2.10 2026-02-14 KIT-002 Stainless Steel Pan Set

FBA Fee Audit and Profitability Optimization

Problem/Feature Description

UrbanNest Home has been using Amazon FBA to fulfill their furniture accessory products for two years. Their operations manager has noticed that the fulfillment fees on their settlement reports seem higher than what the Amazon FBA fee calculator shows when she manually checks a few SKUs. She suspects that Amazon may have the wrong dimensions on file for some products — a common issue when products are measured by Amazon's receiving team rather than the manufacturer's spec sheet.

Additionally, the business development team wants to know which SKUs are candidates for operational changes: products eating up warehouse space in long-term storage, products where FBA costs are becoming a disproportionate share of their price, and products with razor-thin margins that may need to be repriced or discontinued. The team wants an automated script that takes their product dimension data and a settlement summary, identifies any potential overcharges, and generates a prioritized list of operational recommendations.

Output Specification

Write a Python script named fba_audit.py that: 1. Reads the product dimensions from product_dimensions.csv 2. Reads the FBA fee charges summary from fba_charges.csv 3. Reads the SKU financial summary from sku_financials.csv 4. Computes expected FBA fees using Amazon's size tier and dimensional weight logic 5. Identifies overcharges and writes them to fba_overcharges.csv 6. Generates optimization recommendations and writes them to recommendations.csv 7. Prints a brief summary to stdout

Input Files

The following files are provided as inputs. Extract them before beginning.

=============== FILE: product_dimensions.csv =============== sku,length,width,height,weight_oz SOFA-PAD-S,14.0,10.0,0.5,11.0 SOFA-PAD-L,17.5,13.5,1.2,18.0 CURTAIN-SET,22.0,8.0,4.0,24.0 LAMP-SHADE,16.0,16.0,12.0,38.0 DOOR-MAT,28.0,18.0,2.0,48.0

=============== FILE: fba_charges.csv =============== sku,units_shipped,total_fba_fee_charged SOFA-PAD-S,120,530.40 SOFA-PAD-L,85,892.50 CURTAIN-SET,60,480.00 LAMP-SHADE,40,520.00 DOOR-MAT,30,390.00

=============== FILE: fba_rate_table.json =============== { "small_standard": { "0.25": 3.06, "0.5": 3.15, "0.75": 3.28, "1.0": 3.48, "2.0": 4.05 }, "large_standard": { "1.0": 4.75, "2.0": 5.40, "3.0": 6.10, "4.0": 6.75, "5.0": 7.45, "10.0": 9.20, "20.0": 12.50 }, "large_bulky": { "30.0": 15.00, "50.0": 20.00, "70.0": 26.00 } }

=============== FILE: sku_financials.csv =============== sku,gross_revenue,fulfillment_fees,long_term_storage_fees,advertising_fees,refund_fees,net_margin_pct SOFA-PAD-S,1800.00,530.40,0,120.00,0,18.5 SOFA-PAD-L,4675.00,892.50,145.00,200.00,0,3.2 CURTAIN-SET,2400.00,480.00,0,80.00,25.00,21.3 LAMP-SHADE,3200.00,520.00,210.00,150.00,0,-2.1 DOOR-MAT,1200.00,390.00,0,60.00,0,8.7

Marketplace Profitability Dashboard

Problem/Feature Description

NovaCraft Supplies is a mid-size seller on Amazon and eBay. Their CFO has been frustrated that the accounting system only shows the net bank deposits from each marketplace, making it impossible to understand true product-level profitability. The CFO suspects that some SKUs look profitable on paper because the team has been treating the settlement payout as if it were gross revenue — masking the real impact of fulfillment costs, referral fees, and storage charges.

The CFO wants a proper profitability analysis that starts from gross selling prices and decomposes every fee component to arrive at true net proceeds per SKU per period. She also wants percentage-based fee metrics so that fee efficiency can be compared across SKUs regardless of volume, and wants the team to start tracking how much each fee type eats into revenue as a rate, not just in dollars.

Output Specification

Write a Python script named net_revenue_analysis.py that: 1. Reads the provided normalized transaction data from transactions.csv 2. Computes net revenue per SKU per month with a full fee breakdown 3. Writes results to net_revenue_by_sku.csv

The output CSV should include columns showing gross revenue, each fee category as a separate column, net marketplace proceeds, and fee rates as percentages of net sales. The script should also print a summary table to stdout.

Input Files

The following files are provided as inputs. Extract them before beginning.

=============== FILE: transactions.csv =============== marketplace,transaction_date,transaction_type,fee_category,sku,selling_price,marketplace_fee,net_proceeds amazon,2026-01-05,order,none,KIT-001,29.99,0,29.99 amazon,2026-01-05,order,fulfillment,KIT-001,0,-3.22,-3.22 amazon,2026-01-05,order,referral_fee,KIT-001,0,-4.50,-4.50 amazon,2026-01-08,order,none,KIT-001,29.99,0,29.99 amazon,2026-01-08,order,fulfillment,KIT-001,0,-3.22,-3.22 amazon,2026-01-08,order,referral_fee,KIT-001,0,-4.50,-4.50 amazon,2026-01-12,order,none,KIT-002,49.99,0,49.99 amazon,2026-01-12,order,fulfillment,KIT-002,0,-5.80,-5.80 amazon,2026-01-12,order,referral_fee,KIT-002,0,-7.50,-7.50 amazon,2026-01-15,refund,none,KIT-002,-49.99,0,-49.99 amazon,2026-01-15,refund,refund_fee,KIT-002,0,1.50,1.50 amazon,2026-01-31,fee,storage,KIT-001,0,-12.80,-12.80 amazon,2026-01-31,fee,storage_long_term,KIT-001,0,-45.00,-45.00 amazon,2026-01-31,fee,storage,KIT-002,0,-8.40,-8.40 amazon,2026-01-31,fee,advertising,KIT-001,0,-28.50,-28.50 amazon,2026-01-31,fee,advertising,KIT-002,0,-15.00,-15.00 amazon,2026-02-03,order,none,KIT-001,29.99,0,29.99 amazon,2026-02-03,order,fulfillment,KIT-001,0,-3.22,-3.22 amazon,2026-02-03,order,referral_fee,KIT-001,0,-4.50,-4.50 amazon,2026-02-07,order,none,KIT-002,49.99,0,49.99 amazon,2026-02-07,order,fulfillment,KIT-002,0,-5.80,-5.80 amazon,2026-02-07,order,referral_fee,KIT-002,0,-7.50,-7.50 amazon,2026-02-10,order,none,KIT-002,49.99,0,49.99 amazon,2026-02-10,order,fulfillment,KIT-002,0,-5.80,-5.80 amazon,2026-02-10,order,referral_fee,KIT-002,0,-7.50,-7.50 amazon,2026-02-28,fee,storage,KIT-001,0,-12.80,-12.80 amazon,2026-02-28,fee,storage,KIT-002,0,-8.40,-8.40 amazon,2026-02-28,fee,advertising,KIT-001,0,-22.00,-22.00 ebay,2026-01-06,order,none,KIT-001,32.00,0,32.00 ebay,2026-01-06,order,referral_fee,KIT-001,0,-4.16,-4.16 ebay,2026-01-20,order,none,KIT-002,52.00,0,52.00 ebay,2026-01-20,order,referral_fee,KIT-002,0,-6.76,-6.76 ebay,2026-01-20,order,fulfillment,KIT-002,0,-2.50,-2.50