About this skill

Problem Statement

Financial reconciliation for Amazon cross-border e-commerce is highly fragmented. Sellers frequently struggle with intersecting cost variables, including FBA fulfillment fees, referral fees, ad ACOS, return penalties, and FX volatility. This skill transforms scattered operational data into structured financial views, addressing core pain points such as opaque SKU-level full-chain costs, lack of breakeven benchmarks for ad ROI, and insufficient operational insights from monthly P&L statements.

Core Capabilities & Workflow

The skill simulates the workflow of a senior CFO, delivering standardized analysis through the following modules:
- SKU Cost Accounting & Pricing: Based on the standard FBA cost structure (procurement, freight, tariffs, FBA fees, referral fees, ads, returns, FX), it sequentially decomposes gross profit, operating profit, net ad profit, and net profit, outputting aligned tables ready for Excel.
- Ad ROI & P&L Analysis: Calculates ACOS, TACOS, ROAS, and breakeven ACOS. It interprets monthly P&L across revenue, cost, profit, and expense ratio dimensions, benchmarking against mature product health metrics (e.g., gross margin >40%).
- Budget Redlines & Cash Flow: Embeds cost-control warning thresholds (e.g., TACOS > 20%, inventory turnover > 90 days) and provides seasonal cash gap alerts based on Amazon's 14-21 day settlement cycle, forward stocking capital, and FX deviation monitoring.
When data is incomplete, the skill generates an initial table using known data, marks missing items as TBD, and applies default assumptions (e.g., 15% referral fee, 3% return rate) to close the analytical loop.

Boundaries & Considerations

Data Completeness Dependency: While default assumptions (e.g., 8-12% freight) are supported, actual tariffs, VAT/GST, and brand fees must be manually adjusted for specific categories and destinations to prevent net profit deviations.
Dynamic Rate Adaptation: FBA fulfillment and storage fees fluctuate by dimensional weight and peak seasons; embedded reference values must be calibrated against Amazon's latest official fee schedule.
Decision Granularity: Outputs focus on macro financial health and SKU-level profit decomposition. For drilling down into single-campaign bidding strategies, specific advertising backend data must be provided.

Screenshots

Use Cases

Estimate FBA procurement, freight, tariff, referral, and ad costs before launch to produce profit tiers and pricing options.
Review monthly P&L to check gross margin, TACOS, logistics costs, and return losses, then trace the cause of profit decline.
Set cost alert thresholds for TACOS above 20%, returns above 5%, and inventory turnover above 90 days.
Measure 14-21 day settlement, inbound stocking, and inventory funding to judge peak-season cash gaps.

Best For

Amazon operations leaders who need to convert SKU costs, referral fees, ads, and returns into actionable pricing plans.
cross-border e-commerce finance managers who need to break down monthly P&L into revenue, cost, profit, and expense ratios with exception reasons.
procurement and supply-chain managers who need to assess how inbound freight, inventory, and settlement cycles affect cash occupation.
brand operators who need to set cost redlines for TACOS, return rate, and inventory turnover.

Related Skills

Cold Shower Gate

@user_2da54b45/cold-shower

Switch AI from a polite executor into a skeptical thinking partner, using assumption checks, pre-mortems, and evidence gates to expose weak ideas early.

Professional 2026.08.29 ↓ 280