Sqalie + French CPA: tracking real e-commerce margin by channel in 2026

Short answer. On a multi-channel e-commerce (Shopify, Amazon, Prestashop, marketplaces), the gross margin shown in back-offices almost never reflects real margin. PSP fees, marketplace commissions, returns, attributed ads, 3PL fees and OSS/IOSS VAT erode net margin by 5 to 15 points depending on the channel. Sqalie acts as an analytical layer on top of the accounting platform (Pennylane, Tiime), so the French CPA can deliver reliable reporting and the founder can actually decide.

Shopify or Amazon Seller Central dashboards show gross revenue. They do not deduct:

• PSP fees (Stripe ~1.4% + EUR0.25 in Europe, PayPal often higher, Shop Pay, Alma),
• marketplace commissions (Amazon 8-15% by category, plus FBA storage and fulfilment),
• returns and refunds (8 to 25% in fashion and beauty),
• ad spend attributed to the channel (Meta, Google, TikTok, reverse-charged for VAT),
• 3PL costs and IOSS customs fees,
• non-recoverable output VAT on B2C sales in the customer's country (OSS).

On one of our cases, the gap between Shopify-displayed margin and real net margin reached 9.3 points. The difference between a healthy channel and a cash-burning one.

Sqalie is not an accounting platform. It is an analytical layer plugged into your storefront (Shopify, Amazon, Prestashop), PSPs (Stripe, PayPal) and bank accounts. It returns a monthly P&L by channel. The legal accounting hub remains Pennylane (or equivalent), where the French CPA files VAT and the year-end accounts.

Reference stack:

The CPA keeps the analytical view (Sqalie) consistent with the legal view (Pennylane). Without that double read, the founder steers on a single indicator — usually the most flattering one.

To produce a reliable net margin by channel, Sqalie consolidates:

1. Orders from Shopify / Prestashop / Amazon (gross revenue, taxes, shipping, discounts)
2. PSP payouts (Stripe, PayPal, Shop Pay) with line-level fees
3. Marketplace commissions (Amazon referral fees, FBA fees, advertising fees)
4. Refunds and chargebacks matched to the original order
5. Ad spend by channel (Meta, Google, TikTok) split by attribution rule
6. Logistics costs (3PL, carriers, IOSS customs)

This consolidation removes the "manual Excel reconciliation" that breaks down beyond 500 orders/month.

Each euro received must be traceable on three axes: the order (Shopify/Amazon), the PSP (Stripe/PayPal), and the bank (Qonto). Sqalie automates the matching; the CPA validates:

• aggregated payouts (Stripe pays out in batches with 2 to 7 days delay) tied to the right orders,
• disputes / chargebacks booked as provisions then settled,
• partial refunds properly allocated (shipping kept vs refunded),
• marketplace commissions split between deductible expenses and VAT reversals.

Without this discipline, the revenue ledger and the customer ledger drift quickly.

Sqalie splits collected VAT by destination country, which lets the CPA:

• prepare the quarterly OSS return (CGI art. 259 D, see the European Commission's e-commerce VAT page),
• monitor the EUR10,000 threshold of intra-EU B2C sales triggering OSS,
• isolate IOSS flows (parcels ≤ EUR150 from outside the EU) often missed in year one.

For a deeper dive, see our 2026 e-commerce VAT guide and our international marketplace OSS/IOSS guide.

Anonymised case. 2025 revenue = EUR1.2m: 70% Shopify DTC, 30% Amazon FBA. Displayed gross margin = 52%. Sqalie-driven diagnosis after scoping:

A 11.7-point gap between channels. Decision: cut Meta spend on Amazon, reinvest on DTC, which freed EUR38,000 of working capital next quarter through faster stock rotation.

Does Sqalie replace an accounting platform? No. Sqalie is an analytical layer. The legal hub remains Pennylane, Tiime or equivalent, where the CPA produces VAT returns and year-end accounts.

At what volume does Sqalie make sense? Typically beyond 500 orders/month, or as soon as you run two distinct channels (Shopify + Amazon for instance). Below that, manual CSV exports are enough.

Does Sqalie handle OSS and IOSS? Yes. Sqalie splits VAT by destination country, helping the CPA prepare quarterly OSS returns and monitor the EUR10,000 threshold (CGI art. 259 D).

Sqalie vs Pennylane? Pennylane is an accounting platform and candidate PDP for 2026 e-invoicing. Sqalie is an analytical layer plugged on top. They are complementary.

How do we start? A 1-to-2-week scoping audit maps the flows, checks OSS/IOSS settings and installs Sqalie + PSP connectors. Our firm leads the scoping on the CPA side.

For a scoping of your e-commerce stack and channel-level reporting, contact our e-commerce CPA practice or explore the Sqalie and Pennylane tools we deploy.