Loading…
Chartered accountant Sqalie
The PrestaShop-native module that turns your back-office into a profitability cockpit — net margin by product and channel, traffic attribution, AI alerts — live in 30 minutes.
Visit the official websiteSqalie with a French CPA: read the true margin of your PrestaShop store#
"Revenue is vanity, profit is reality." — Sqalie's signature line frames the angle of our engagement.
Selling more does not mean earning more. Sqalie is the French profitability platform built for PrestaShop merchants: it turns your back-office into a cockpit where margins, traffic and marketplaces are read in real time. Hayot Expertise drives the deployment, the analytics setup and the handover to Pennylane so that Sqalie becomes a true financial source of truth.
1. Sqalie's positioning: what your store really earns#
Sqalie's premise is shared by every French e-commerce founder: PrestaShop, GA4, Looker Studio and Excel each speak a different language. True margin — after cost of goods, shipping, marketplace commissions and ad spend — never appears on a single screen.
Sqalie consolidates these flows in a module installed directly from the PrestaShop back-office, no developer required. The vendor's standard rollout is three steps:
- Module install from the back-office (≈ 2 min, no dev).
- Automatic data import: orders, products, cost prices, shipping, fees, returns.
- Operational dashboard within 30 minutes, margins visible from day one.
Sqalie reports replacing 3 tools on average per merchant (Looker Studio, GA4, Excel exports) and freeing 5 hours of weekly reporting.
2. The four functional pillars#
a) Product profitability with dynamic scoring#
Catalogue view through the lens of true margin by product, category, brand and cost price. A dynamic scoring spots top performers and flags risk products that drag the global margin. Sqalie's headline example for a serum sold at €34.90: cost −€12.00, shipping −€3.20, fee −€3.30, net margin €16.40 (47%).
b) Traffic attribution without GA4 or Looker Studio#
Centralised acquisition performance (Google Ads, SEO, AI Search, Meta Ads, marketplaces) with no GA4 setup and no external script. Each euro of revenue is tied to its source so you can measure real ROI per channel and reallocate spend. Typical view: Skin care — Google Ads revenue €8,720 margin +12.3% vs AI Search revenue €12,430 margin +24.1%.
c) AI & predictive alerts#
Sqalie monitors data continuously and emits actionable alerts:
- Margin alert: "Bio Serum — margin dropped below 12%, declining for 2 weeks."
- Budget opportunity: "Reallocate 30% of Facebook Ads budget to AI Search — ROI x2.4."
- Inventory recommendation: "Increase Hydra Intense Cream stock — stockout estimated D+5."
A weekly report summarises priority actions: margin drops, returns spikes, imminent stockouts, levers to activate.
d) Sales & marketplaces#
Unified tracking of the PrestaShop store and connected marketplaces: Amazon, Cdiscount, Rakuten, Zalando. Profitability comparison net of commissions, fees and shipping, so you focus efforts where the store actually earns.
3. Why combine Sqalie with a French e-commerce CPA#
Sqalie answers the operational question: what does my store earn?. Hayot Expertise's role is to make it the accounting and tax source of truth:
- Defining analytics axes (channel, brand, EU country, VAT regime).
- Reprocessing Amazon facilitator commissions to neutralise VAT double-counting.
- Registration and filing for OSS / IOSS (article 259 D French Tax Code, EU directives 2017/2455 and 2019/1995).
- Monthly cut-off: order / Stripe-PSP payment / Qonto bank reconciliation, then handover to Pennylane.
- Readiness for the 2026 French e-invoicing reform (B2C e-reporting, B2B PDP routing).
4. Real-world case: DTC + Amazon FBA, EUR 1.2M revenue#
Situation. PrestaShop store selling across France and 6 EU countries with an active Amazon FBA arm. Gross revenue: PrestaShop €720k + Amazon €480k. No net margin by channel, PSP payouts booked gross, OSS not registered.
Actions.
- Sqalie installed from the PrestaShop back-office, analytics axes set per channel and brand.
- Amazon Seller Central connected: commissions, FBA fees and refunds isolated.
- OSS registration via the French one-stop-shop, automatic per-country EU revenue split.
- Monthly consolidated entries pushed to Pennylane.
Outcome. Amazon channel identified at −8 points net margin vs DTC, Meta budget reallocated, €14,200 of OSS penalties avoided for the fiscal year, and 5 hours of weekly reporting freed up for the founder.
5. Sqalie pricing and engagement#
Sqalie applies bespoke pricing rather than rigid plans: volume, catalogue, integrations and support needs are scoped case by case (24-business-hour reply, complimentary personalised demo). On the Hayot Expertise side, the engagement is packaged as initial setup + monthly close: data audit, analytics configuration, 6-month historical reprocessing, first monthly report and quarterly reviews with Samuel Hayot.
6. Quick comparison#
| Topic | Standard stack (PrestaShop + GA4 + Excel) | With Sqalie |
|---|---|---|
| Net margin per product | Manual recompute | Default view |
| Traffic / channel attribution | GA4 + Looker setup | Inside Sqalie, no GA4 |
| Marketplace profitability | Fragmented data | Unified, net of commissions |
| Margin / stockout alerts | Detected too late | Real-time AI |
| Weekly reporting | 5 h/week | 30 min, automated |
| Accounting handover | Manual CSV | Pennylane / Sage / Cegid |
Frequently asked questions
Does Sqalie replace an accounting platform like Pennylane?+
No. Sqalie is an e-commerce analytics layer focused on operational profitability. It feeds your accounting platform — for us, Pennylane — which remains the legal and tax record.
Do I need PrestaShop to use Sqalie?+
Sqalie is currently designed as a PrestaShop-native module (2-minute install from the back-office). That's the strength: no scripts, no GA4 plumbing. If you run on Shopify, let's talk: we'll assess a tooled migration or an alternative stack.
How long does deployment take on the firm side?+
The Sqalie module is live within 30 minutes. The accounting work around it — analytics axes, OSS/IOSS reset, Pennylane mapping, Amazon facilitator reprocessing — takes 4 to 6 weeks for the first publishable monthly report.
Is my data secure?+
Yes. Sqalie is published in France, hosts data in the EU and applies ISO security standards. We sign a GDPR data-processing addendum at contracting.
Can I use Sqalie without a CPA?+
Technically yes. In practice the value lies less in the tool than in the accounting and tax reading of the data: facilitator commission reprocessing, VAT regime selection, French GAAP inventory valuation, monthly cut-off and 2026 e-invoicing readiness. That is what we add.
Go further#
- Sector: E-commerce accountant — VAT OSS, PrestaShop and Amazon
- Companion tool: Pennylane by Hayot Expertise
- Foundational article: Sqalie + French CPA — reading e-commerce margin by channel in 2026
- Reconciliation method: Shopify, PrestaShop, Stripe, Pennylane and Sqalie reconciliation
- E-commerce comparison: PrestaShop vs Shopify — French CPA, OSS VAT and 2026 e-invoicing
- Amazon sellers: Selling on Amazon from France — VAT, margin and FBA pitfalls
To scope your Sqalie project, book a call with Samuel Hayot.
Related accounting services
Beyond Sqalie, Hayot Expertise can support you on the underlying accounting and compliance work:
Article written by Samuel Hayot
Chartered Accountant, registered with the Institute of Chartered Accountants. Certified Pennylane trainer.
Regulated French firmUpdated 07 May 2026
Regulated French accounting and audit firm based in Paris 8, built to support companies across France with a digital and decision-oriented approach.
Key features
- Native PrestaShop module installed from the back-office in 2 minutes, operational dashboard in 30 minutes
- Net margin per product, category, brand and cost price with dynamic scoring of risk products
- Multi-channel traffic attribution without GA4 or Looker Studio (Google Ads, SEO, AI Search, Meta, marketplaces)
- Real-time AI & predictive alerts: margin drops, stockouts, budget reallocation opportunities
- Unified PrestaShop + Amazon, Cdiscount, Rakuten, Zalando view with profitability net of commissions and fees
- Accounting handover to Pennylane, Sage or Cegid with per-country OSS / IOSS VAT split
Your direct benefits
- True margin reading where PrestaShop and marketplaces only show a commercial view
- Replaces 3 tools on average (Looker Studio, GA4, Excel) and frees 5 hours of weekly reporting
- Numbers-driven decisions on product mix, ad spend and marketplaces — no more gut-feel steering
- OSS / IOSS VAT secured and marketplace-facilitator sales neutralised for tax audits
- Ready for the 2026 French e-invoicing reform (B2C e-reporting, B2B PDP routing) with Pennylane as PDP
- Deployment led by a French CPA registered with the Ordre des Experts-Comptables, with quarterly reviews