Blog / Article
Blog home
Case Study

5 Stars United

From manual spreadsheets to precise landed-cost allocation and FIFO COGS across six regions

5 Stars United case study cover

5 Stars United is a global e-commerce brand operating across six regions (USA, UK, Canada, Mexico, Australia, EU) with approximately $30M in annual revenue and a catalog of 50+ SKUs. They sell primarily on Amazon and are expanding into TikTok. Their multi-vendor, multi-warehouse supply chain with cross-border operations creates complex challenges in cost allocation, inventory visibility, and financial reporting.

Industry
Global e-commerce
Revenue
≈$30M annually
Catalog
50+ SKUs
Channels
Amazon, TikTok Shop
Regions
USA, UK, Canada, Mexico, Australia, EU
Supply chain
Multi-vendor 3PL
−85% reduction in COGS errors vs. spreadsheet process
The Problem

Spreadsheets couldn't keep up with global growth

Growing across countries and marketplaces, 5 Stars United managed costs and inventory with spreadsheets. That meant:

  • Shared costs (freight, storage, customs) weren't allocated precisely per SKU/batch, leading to inconsistent cost-per-unit
  • Ballpark COGS led to unreliable P&L and muddled SKU profitability
  • Pricing and markdown decisions lacked confidence without clear landed costs by region
  • Accounting spent hours manually calculating COGS, asset values, and channel activity before pushing into QuickBooks Online — often from unreliable spreadsheets
The Solution

Automated cost allocation and real-time financial visibility

5 Stars United implemented NeonPanel to transform their financial operations:

  • Automated landed-cost allocation — freight, duties, and storage costs allocated to batches using clear rules based on weight, volume, and value
  • End-to-end visibility across fabrication, in-transit transfers, 3PLs, and Amazon FBA/AWD in one unified place
  • FIFO COGS at sale time — accurate, defensible cost of goods eliminating estimates
  • Direct QuickBooks Online sync — automatic journals and balance updates keeping daily operations in sync with the ledger
  • Decision-grade reporting for COGS, SKU profitability, and finance to support confident pricing and markdown decisions
Outcomes

Key results in the first 6 months

25+ Hours saved per month Via automation and QuickBooks Online sync
+15% Increased profitability On key SKUs through dynamic pricing updates
−85% Fewer COGS errors In cost allocation vs. the spreadsheet process
+20% Cash flow improvement From clear cost visibility in purchasing and markdown timing
+10% Amazon revenue growth Driven by better pricing and markdown decisions

NeonPanel has been a game-changer for us. We no longer have to rely on estimates for our COGS or pricing decisions. The integration with QuickBooks Online alone has saved us hours of manual work and made our financial reporting significantly more accurate. The system has transformed our cost tracking and allowed us to optimize pricing with confidence. It's a critical tool for our growth in multiple markets.

Anna Samsonova
Anna Samsonova Chief Operating Officer, 5 Stars United

Get your numbers right. Start today

14-day free trial. No credit card. Dedicated onboarding included on every plan.

Join 200+ ecommerce teams who trust NeonPanel for their financial close.