Shopify / Prestashop / Stripe reconciliation with Pennylane and Sqalie: the 2026 method

Short answer. On an e-commerce running 300 to 500+ orders per month, reconciling the order (Shopify or Prestashop), the PSP (Stripe, PayPal, Shop Pay) and the bank account cannot be done by hand. The three-way method we apply at Hayot Expertise relies on an analytical layer (Sqalie) on top of the accounting platform (Pennylane) with a written cycle handbook. Plan two to six weeks of scoping and target a monthly close within ten calendar days.

French online commerce in 2026 faces three constraints that make three-way reconciliation mandatory. First, the rise of alternative payment methods (Stripe, PayPal, Shop Pay, Apple Pay, Alma, Klarna) multiplies payout sources and blurs order-to-cash traceability. Second, OSS and IOSS VAT requires splitting by delivery country and flow (intra-EU B2C, imports under EUR 150), set by Article 259 D of the French tax code and clarified by BOFiP (the French tax doctrine database), with no tolerance for estimates. Third, ANC Regulation 2022-06, applicable to fiscal years opened from 1 January 2025, reinforces the doctrine on the French chart of accounts and demands an account-by-account, sub-ledger-by-sub-ledger discipline that does not forgive sloppy reconciliations.

On a file we took over in late 2025, EUR 47,000 of Stripe chargebacks had gone unnoticed for nine months for lack of this discipline. The loss was not hidden inside Stripe — it was perfectly listed in the Stripe Disputes dashboard — it had simply never been brought into the bookkeeping.

In a modern e-commerce, money transits through at least three actors before hitting the bank:

• the order (Shopify, Prestashop, Amazon, marketplaces)
• the PSP (Stripe, PayPal, Shop Pay, Alma, Klarna)
• the bank account (Qonto, BNP, Crédit Agricole)

Three-way reconciliation means matching every order to a PSP collection, then every PSP payout to a bank movement, leaving nothing orphaned. Without this discipline, you can neither rebuild net revenue (post-PSP fees), nor spot ongoing disputes, nor isolate partial refunds, nor produce a reliable OSS VAT return. E-commerce bookkeeping technically rests on this three-way matching, whatever the CMS.

For a standard multi-PSP e-commerce month, your Pennylane accounting hub must receive at minimum seven blocks of entries, compliant with the French chart of accounts in force since 1 January 2025 (ANC Regulation 2022-06).

1. Gross revenue by channel on account 707, split by market or marketplace.
2. Output VAT by country on account 4457, split France, OSS EU, IOSS.
3. PSP fees on account 627, deductible, split by PSP (Stripe, PayPal, Shop Pay, Alma).
4. Customer refunds on account 7097 or as revenue reversal, never as expense.
5. Chargebacks and disputes on account 658, then 791 on recovery.
6. Marketplace commissions on account 622, deductible, with EU VAT reverse charge if the marketplace is EU-established.
7. Ad spend on account 623, reverse-charged for Meta Ireland, Google Ireland, TikTok Ireland.

Each entry must be traceable to the source order via Sqalie. No monthly aggregate entry "Shopify sales" survives an audit.

Sqalie and Pennylane play complementary roles. Sqalie is the analytical layer that aggregates orders, payouts, marketplace commissions and PSP fees, then produces a line-by-line reconcilable dataset. Pennylane is the legal hub that receives consolidated entries, manages VAT, bank reconciliation and the French tax return package.

Sqalie is the piece that makes the method sustainable above 300 to 500 orders per month. Without Sqalie, three-way matching stays theoretical and degenerates into a monthly Excel that drifts by month two. For a broader view of the analytical-plus-accounting pair, see our article Sqalie + CPA: piloting real e-commerce margin per channel.

Our cycle handbook prescribes a 30 to 45-minute weekly check, structured around five short standing slots.

1. Monday — payout import: pull last week's Stripe and PayPal payouts into Sqalie, check each bank payout matches a PSP payout.
2. Tuesday — Sqalie / Pennylane match: reconcile the e-commerce 411 sub-ledger and the 707 revenue account, tolerance below 0.1% of weekly revenue.
3. Wednesday — dispute review: open the Stripe Disputes dashboard, review each open case, book a provision if loss is probable.
4. Thursday — partial refunds and shipping: isolate partial refunds and verify shipping treatment (retained or refunded).
5. Friday — OSS VAT consistency: check country split for the week, flag any drift above 5% versus the previous month.

This cadence prevents the drift that makes monthly close unbearable. On files where the weekly slot is skipped for three weeks running, we systematically observe two to three extra days on monthly close.

Stripe disputes#

Stripe deducts the provision automatically on the next payout. Bookkeeping-wise: charge to account 658, optional provision on account 491 if the dispute is open but not yet resolved, then settled when the case closes. If the merchant wins, the amount goes back to credit of account 791. The official Stripe Reports documentation lists exportable CSVs.

Partial refunds#

Distinguish retained shipping (booked as ancillary revenue or shipping reduction) from refunded shipping (pure reversal of accounts 7085 or 7088). The most frequent mistake on files we take over: full refund while shipping was billed without VAT, which creates an output-VAT shortfall to fix on the following return.

Multi-currency and FX#

Stripe converts each payment at a contractual rate on the payment day (Stripe rate + 1% by default for non-domestic currencies). The gap between the Stripe rate and the ECB rate of the day must be isolated on account 666 (FX loss) or 766 (FX gain). Sqalie surfaces the rate applied by Stripe and Pennylane books the gap per currency to prepare year-end.

Quarterly OSS and monthly IOSS#

Sqalie splits VAT by delivery country in line with Article 259 D of the French tax code. Pennylane consolidates the quarterly OSS return and the monthly IOSS. The firm controls the gap between the OSS total and the sum of country-by-country revenue, tolerance below 1% of declared EU revenue. For exact country-by-country figures, use our OSS/IOSS e-commerce VAT simulator and read our complete 2026 IOSS e-commerce VAT obligations guide.

Multi-stores and multi-PSP#

On a multi-store Shopify file (for instance FR / DE / ES), consolidation goes through one 411 sub-account per store and one 707 sub-account per market. On a multi-PSP file (Stripe + PayPal + Klarna), one 411 sub-account per PSP becomes mandatory to avoid impossible cross-matching. For international marketplace flows, see our dedicated method on international marketplace OSS/IOSS reconciliation.

• Parallel Excel next to Pennylane: double source of truth, guaranteed drift, ban it.
• Monthly aggregate entry "Shopify sales": impossible to audit, will be rejected on FEC review.
• Forgetting delayed chargebacks: some Visa chargebacks appear at D+90, always provision.
• Confusing PSP fees and marketplace commissions: the first on 627, the second on 622 with EU VAT reverse charge.
• Estimated OSS VAT: forbidden, Sqalie splits to the cent per order.
• Refunds with shipping: always check if shipping was refunded or retained, direct VAT impact.
• FX not isolated: on a multi-currency file, FX drift not isolated can reach 2% of annual revenue.

We recently onboarded a Paris-based fashion e-commerce (EUR 4M revenue, multi-store Shopify FR/DE/IT, Stripe + PayPal + Klarna) who had been keeping books in-house on Excel and Pennylane. Diagnostic in eight days: three recurring gaps, an EUR 6,200 OSS EU output-VAT shortfall, and EUR 18,000 of Stripe chargebacks unbooked over ten months. After deploying the three-way method with Sqalie as the analytical layer, monthly close moved from 22 to 9 calendar days and OSS VAT control dropped to 20 minutes per quarter.

The economics are unambiguous on this profile. Sqalie's monthly fee (a few hundred euros per month depending on volume) is below half a day of in-house bookkeeper time per week, which used to be the real cost of an incomplete manual reconciliation. On the e-commerce files we serve from the firm, the tipping point toward the outfitted three-way method sits between 300 and 500 orders per month, with variation tied to the number of PSPs, the number of markets and the quality of the initial chart of accounts. To prepare a migration to a better-connected accounting platform, see our experience on moving to Pennylane with your CPA and our Stripe vs Adyen vs Mollie 2026 comparison for primary PSP selection.

Hayot Expertise advice. Before buying an analytical tool, run a free 30-minute scoping diagnosis with an e-commerce specialised firm. You will know in half a day whether your volume justifies Sqalie or whether a monthly CSV protocol still suffices. We provide this scoping audit in our e-commerce CPA practice offer. The bad reflex is to buy the tool before the protocol: without a written cycle handbook, even the best analytical platform stays under-used.

On files where the method is applied, we close a month within ten calendar days max.

Without the method, expect 15 to 25 days, with undetected residual errors. For groups consolidating multiple national e-commerces, see our dedicated method on multi-country bookkeeping and coordinated close 2026.

• Three-way order / PSP / bank reconciliation becomes mandatory above 300 to 500 orders per month.
• Seven core entries structure an e-commerce month: sales 707, VAT 4457, fees 627, refunds 7097, disputes 658/791, marketplace 622, ads 623.
• Sqalie is the analytical layer, Pennylane the legal hub, the firm the controller. None of the three replaces the other two.
• The weekly 30 to 45-minute protocol prevents the drift that makes monthly close unbearable.
• A clean monthly close lands within 10 calendar days with the method, versus 15 to 25 without.
• Stripe FX, delayed chargebacks and OSS VAT are the three major pitfalls on which we recover broken files.

Official sources#

• BOFiP – VAT, online platforms and distance selling (BOI-TVA-CHAMP) — French tax doctrine on distance selling and marketplaces.
• impots.gouv.fr – OSS / IOSS one-stop shop — quarterly OSS and monthly IOSS filing rules.
• Légifrance – French tax code Article 259 D (intra-EU distance sales) — territoriality rule for intra-EU B2C.
• ANC – Regulation 2022-06 of the French chart of accounts — applicable to fiscal years opened from 1 January 2025.
• Stripe – pricing, fees and reports — commission schedule per currency, payment method and zone.
• Stripe – Reporting & Reconciliation documentation — CSV exports usable for three-way reconciliation.
• Pennylane – integrations and connectors — official catalogue of e-commerce and PSP connectors.
• Sqalie – Shopify, PrestaShop, Stripe, Pennylane connectors — French e-commerce analytical platform.

To deploy this method in your e-commerce, contact our e-commerce CPA practice, read our 2026 e-commerce CPA OSS/IOSS mega guide or explore the Sqalie, Pennylane and Prestashop tools.