Skip to main content
Back to our tools
Logo Sqalie

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 website

Sqalie 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:

  1. Module install from the back-office (≈ 2 min, no dev).
  2. Automatic data import: orders, products, cost prices, shipping, fees, returns.
  3. 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.

  1. Sqalie installed from the PrestaShop back-office, analytics axes set per channel and brand.
  2. Amazon Seller Central connected: commissions, FBA fees and refunds isolated.
  3. OSS registration via the French one-stop-shop, automatic per-country EU revenue split.
  4. 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#

TopicStandard stack (PrestaShop + GA4 + Excel)With Sqalie
Net margin per productManual recomputeDefault view
Traffic / channel attributionGA4 + Looker setupInside Sqalie, no GA4
Marketplace profitabilityFragmented dataUnified, net of commissions
Margin / stockout alertsDetected too lateReal-time AI
Weekly reporting5 h/week30 min, automated
Accounting handoverManual CSVPennylane / Sage / Cegid

Questions frequentes

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#

To scope your Sqalie project, book a call with Samuel Hayot.

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