Accounting Export — Complete Guide

Overview

DataFirefly Accounting Export (dfaccountingexport) generates your PrestaShop accounting entries in eight formats: FEC (French legal requirement, article A-47 A-1 of the French Tax Procedures Code), Sage 100, EBP Compta, Ciel XIMPORT, Quadratus ASCFIC, Pennylane, Tiime and Indy. The module reads paid orders and credit notes within the chosen period, builds journal entries (sales journal VE and credit-note journal AV), automatically splits by VAT rate and produces a file ready to send to your accountant or import into your accounting software.

Installation

1. In the PrestaShop back office, go to Modules → Module Manager → Upload a module.
2. Upload the dfaccountingexport.zip file.
3. The module automatically creates the ps_dfae_export_log table (export history) and an Accounting export tab under the Orders menu.

Compatibility: PrestaShop 8.0 to 9.x, PHP 7.4 minimum (8.1+ recommended), multistore supported.

Configuration

Open Modules → dfaccountingexport → Configure. The configuration is organised in three panels.

Journals

• Sales journal code (default VE) and its label.
• Credit-note journal code (default AV) and its label.

Chart of accounts

Default values follow the French General Chart of Accounts. Every number can be changed:

• 411 — Customers (general account root)
• 707 — Sales of goods
• 4457 — Collected VAT
• 708 — Invoiced shipping
• 709 — Discounts and rebates
• 512 — Bank · 530 — Cash · 5115 — Card payments

Breakdown mode: by VAT rate (default), by product category, or none. In rate mode, each rate encountered generates a sub-account: 707000 (20%), 707010 (10%), 707055 (5.5%), 707021 (2.1%). Collected VAT follows the same logic on 4457.

Customer auxiliary account: when enabled, every customer entry carries an auxiliary number in the form C000123 (customer 123) in addition to the general account. Recommended for FEC compliance and payment reconciliation by your accountant.

Options

• SIREN: required for the FEC. The regulatory file name is SIREN + FEC + closing date (e.g. 123456789FEC20261231.txt). Without a configured SIREN, the file literally contains the word “SIREN” and is not acceptable for a tax filing.
• Included order statuses: by default “Payment accepted” and “Delivered”. Tick the statuses your workflow considers bookable.
• Output encoding: UTF-8 or ISO-8859-15. Sage, Ciel and Quadratus often prefer ISO; Pennylane, Tiime and the FEC stay UTF-8.

Generating an export

1. Go to Orders → Accounting export.
2. Choose the period (start date / end date). The filter applies to the invoice date for orders and the creation date for credit notes.
3. Select the format among the eight available.
4. Click Preview: the module computes, without generating a file, the order count, journal line count, total debit and total credit. A green banner confirms a perfect balance; a red banner highlights a gap.
5. Click Export: the file is generated and downloaded immediately, and the operation is logged in the history.

Entry logic — sales journal

For each paid order: debit 411 (customer, tax incl.), credit 707xxx per rate (net sales), credit 4457xxx per rate (VAT), credit 708 (net shipping) and debit 709 (discounts) where applicable. An automatic rounding adjustment (gap < €0.10) is injected on the VAT account to guarantee the balance — residual VAT cents are a classic of e-commerce exports.

Entry logic — credit-note journal

OrderSlip records within the period generate mirror entries in the AV journal: credit 411, debit 707xxx, debit 4457xxx. Credit notes are included in the global balance check.

The eight formats in detail

• FEC — 18 pipe-separated columns, YYYYMMDD dates, positive amounts with debit/credit direction, UTF-8 without BOM. Compliant with article A-47 A-1 of the French LPF.
• Sage 100 — Semicolon CSV: Journal;Date;PieceNumber;GeneralAccount;AuxiliaryAccount;Label;Direction;Amount;Currency.
• EBP Compta — Tab-separated with debit/credit in separate columns and reconciliation code.
• Ciel XIMPORT — 81-character fixed width, 13-character zero-padded amounts.
• Quadratus ASCFIC — Fixed width, amounts in whole cents.
• Pennylane — Modern CSV, forced UTF-8, decimal point, ISO dates.
• Tiime — Semicolon CSV with DD/MM/YYYY dates.
• Indy — Simplified CSV for freelancers.

Export history

Every export is logged in the database (ps_dfae_export_log): format, period, order and line counts, debit/credit totals, file name, operator, timestamp. The last 20 exports are displayed at the bottom of the export screen.

FAQ & troubleshooting

The preview shows a debit/credit gap — what should I do?

A gap above €0.10 usually indicates an order with atypical taxation (custom tax, ecotax, currency rounding). Narrow the period to isolate the faulty order, check its tax configuration, then run the preview again.

The FEC file is rejected by the DGFiP validation tool

First check that the SIREN is filled in the configuration, then that the exported period matches the fiscal year, and that the encoding stayed UTF-8. The DGFiP “Test Compta Demat” tool lets you validate the file locally.

Can I export several formats for the same period?

Yes, without reconfiguring: simply select another format and run the export again. Each generation is logged separately.

Does the module modify my order data?

No. The module is strictly read-only on orders, invoices and credit notes. Its only database write is the history logging.