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

Direct answer. On a multi-channel e-commerce business, the margin displayed in back-offices (Shopify, Amazon Seller Central) systematically overstates the real net margin. PSP fees, marketplace commissions, returns, attributed ad spend, 3PL costs, chargebacks and OSS/IOSS VAT together erode net margin by 5 to 15 points depending on the channel. Sqalie, connected to Pennylane and operated alongside a French chartered accountant, reconstructs the real net margin by channel and enables reliable management decisions — within 4 to 12 weeks of implementation.

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

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

In the files we handle at our firm, the gap between displayed and real net margin frequently reaches 8 to 11 points — the difference between a profitable channel and one quietly destroying cash.

Sqalie is not an accounting platform. It is an analytical layer connected to storefronts (Shopify, Amazon, PrestaShop), PSPs (Stripe, PayPal) and bank accounts, returning a monthly P&L by channel. The legal accounting hub remains Pennylane (or equivalent), where the French chartered accountant produces the balance sheet, tax filing and VAT returns.

The chartered accountant keeps the analytical view (Sqalie) consistent with the legal view (Pennylane). Without this double read, the founder steers on a single, often flattering indicator.

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 operators, carriers, IOSS customs duty)

This consolidation replaces the manual Excel reconciliation that becomes unmanageable beyond 400 to 500 orders per month.

The core rule: every euro received must be traceable on three simultaneous axes — the order (Shopify/Amazon), the PSP (Stripe/PayPal) and the bank (Qonto). Sqalie automates this matching; the chartered accountant then validates the sensitive checkpoints:

Without this discipline, the revenue ledger (account 707) and the customer ledger (account 411) drift quickly, and the year-end reconciliation work becomes a major time sink.

Chargebacks are a frequent blind spot in e-commerce accounting. Some Visa disputes appear at D+90, sometimes D+120 for service-related disputes. The accounting consequence is direct: an unprovisioned chargeback creates a margin distortion at quarterly close.

Our standard method: provision 0.5 to 1% of Stripe revenue at account 491 (customer impairment provision), then adjust the provision based on the actual historical rate after six months of data. For merchants selling digital products or subscriptions, the chargeback rate is often higher; some files require a 1.5% provision.

Sqalie isolates chargebacks by channel and by PSP, making it possible to identify whether the problem is structural (a specific channel or product line) or exceptional (a specific batch of disputed orders).

Sqalie splits collected VAT by destination country, allowing the chartered accountant to produce OSS/IOSS declarations in compliance with Article 259 D of the French Tax Code (CGI) — the legal foundation for the distance-selling VAT regime on intra-EU B2C transactions.

Key compliance checkpoints for 2026:

• OSS threshold: EUR10,000 in annual intra-EU B2C sales across all countries. Once exceeded, the VAT rate of the destination country applies. The quarterly OSS return is filed via the single window at impots.gouv.fr.
• IOSS regime: for parcels valued at EUR150 or less shipped from outside the EU directly to the end consumer, declarations are monthly. IOSS flows are frequently missed in the first year, particularly for merchants combining French stock with dropshipping from outside the EU.
• Reverse charge on ad spend: Meta Ads and Google Ads invoice from Ireland with VAT reverse charge. These flows must be captured correctly (via Dext or equivalent) so that deductible input VAT is not lost.

Sqalie's country-by-country VAT split is the operational output that feeds the OSS return directly — reducing the risk of error on multi-country volume that would be unmanageable in a spreadsheet.

Pennylane handles legal accounting: bank reconciliation, matching, VAT returns, year-end tax filing, balance sheet. Sqalie handles analytical management: margin by channel, cost attribution, working capital monitoring, OSS/IOSS allocation. The two tools do not substitute for each other — they complement each other.

The common misunderstanding: some founders assume Pennylane alone is sufficient to manage margin. It is sufficient for legal compliance; it is not designed to model net margin by channel with attributed PSP fees and ad spend. That is precisely Sqalie's role upstream.

Anonymised file, 2025 financial year. Revenue: EUR1m — 60% Shopify DTC, 25% Amazon FBA, 15% specialist marketplace. Back-office gross margin displayed: 54%. Sqalie diagnosis post-scoping audit (6-week implementation):

Finding: the Shopify DTC channel, despite similar gross margins, delivers 5 to 6 points higher net margin once Meta ads are correctly attributed and PSP fees deducted. Founder decision: redirect EUR15,000 in ad budget to DTC, reduce Amazon stock to cut FBA storage fees, close the specialist marketplace contract (insufficient net margin vs. administration costs). Working capital freed the following quarter: approximately EUR32,000.

Implementation timeline: 6 weeks total. Flow mapping and scoping (2 weeks), PSP and platform connector installation (2 weeks), first-month data validation and reporting sign-off with the chartered accountant (2 weeks).

The question founders most often ask: how long to recoup the cost of the Sqalie + CPA stack?

Our analysis across client files shows the return-on-investment rests on three levers:

1. Budget reallocation decision: identifying a channel with 5 net margin points less and redirecting ad spend typically generates EUR20,000 to EUR80,000 in additional annual margin on a EUR500k to EUR2m revenue base.
2. OSS/IOSS VAT compliance: an undeclared intra-EU B2C VAT adjustment can reach several tens of thousands of euros. Early compliance removes this risk entirely.
3. Founder and accountant time: replacing 3 to 6 hours of monthly manual reconciliation with automated reporting is a direct operational gain.

Indicative stack cost: EUR600 to EUR2,500 per month including the firm's mission (production only or production plus outsourced CFO). This cost is justified as soon as the margin tracking prevents one misallocation decision or avoids a VAT compliance risk.

On e-commerce files subject to a tax review, the most common checkpoints relate to:

• consistency between PSP export data (Stripe, PayPal) and the revenue account (707);
• OSS VAT allocation by country and consistency with the returns filed through the single window;
• chargebacks and credit notes: their absence from the accounts is an audit flag;
• marketplace commissions: correctly deducted from net revenue or buried in gross revenue?

The three-way reconciliation tooled by Sqalie and validated by the chartered accountant is the strongest supporting evidence available if the file is reviewed.

For multi-currency accounting specific to e-commerce businesses exporting outside the euro zone, see our multi-currency accounting guide.

This article provides general information only. It does not replace a personalised analysis of your situation, flows and the applicable rules at the date of your decision. Updated: 25 May 2026. Reviewed by Samuel Hayot, registered chartered accountant (Ordre des Experts-Comptables).