All case studies Case Study

ZenART Supplies

Reliable FBA reconciliation, true FIFO COGS, and faster month-close across US, UK, and EU

3 markets on real-time reconciliation
ZenART Supplies case study cover

ZenART Supplies sells art materials via Amazon FBA across the US, UK, and EU on Xero, with multi-currency freight. They needed consistent FBA reconciliation and batch-level COGS that earlier tools could not deliver.

Channels
Amazon FBA (US, UK, EU)
Accounting
Xero
Complexity
Multi-currency, cross-border freight
Challenge
Fragmented FBA data, error-prone FIFO/COGS, delayed month-close
3 markets unified with real-time reconciliation
The Problem

Basic FBA data extraction wasn't cutting it

Across the US, UK, and EU, the FBA extracts ZenART relied on were unreliable. Earlier inventory platforms could not even pull basic FBA data consistently, so the team fell back on spreadsheet workarounds, approximate FIFO and COGS, and a slower month-end.

Multi-currency freight and service invoices made it harder still — landed cost and the P&L were difficult to defend when costs spanned USD, GBP, and EUR.

The Solution

Co-developed Xero integration built for FBA complexity

  • FBA & AWD ingestion — US, UK, and EU shipments, SKUs, and ledger alignment
  • FIFO + landed cost — batch allocation, corrections, and COGS recognized at sale
  • Xero sync — invoices, bills, inventory journals, and COGS posted directly
  • Multi-currency landed cost — USD, GBP, and EUR with allocation rules
  • Inventory positions — FBA, AWD, in-transit, and reimbursements in one view
  • Reporting — SKU margin, audit trails, reconciliation, and diligence-ready P&L views
Partnership

Built together, from scratch

ZenART co-developed NeonPanel's Xero integration. Weekly sessions with their finance lead worked through chart mapping, inventory and COGS journals, and FIFO across cross-border batches.

Multi-currency freight, retroactive corrections, and Amazon ledger reconciliation were productized into the same stack ZenART runs today — direct Xero sync and batch-level landed cost.

Outcomes

What changed

Reliable FBA reconciliation FBA numbers, invoices, and ledgers pulled directly where prior tools failed
True FIFO COGS Batch-level cost recognition instead of approximate, spreadsheet-driven figures
Multi-currency landed cost USD, GBP, and EUR freight and duties allocated to the right batches
Faster month-close Less manual cleanup before the books are ready in Xero
Diligence-ready P&L Audit trails and reconciliation views finance can defend

Previous attempts with inventory management platforms failed to extract even basic FBA data. NeonPanel finally delivered a reliable solution — pulling FBA numbers, invoices, and ledgers directly for accurate reconciliation.

Roberto Auriemma
Roberto Auriemma CEO, ZenART Supplies

Bring NeonPanel into your stack

14-day free trial. No credit card. Dedicated onboarding on every plan — we set up your batches, your ledger, and your channels with you.

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