FR Liasse Fiscale Prep
Trial-balance to liasse fiscale (2050-series) mapping worksheet for the accountant — format-generation only, no EDI-TDFC filing.
Liasse Fiscale Prep Worksheet — France
Key Features
Trial-Balance Import
Pull the balance générale from posted journal items for the fiscal year, upload a CSV (code;name;debit;credit), or key lines in manually — then compute the liasse in one click.
Five Seeded 2050-Series Forms
Bilan actif (2050), bilan passif (2051), compte de résultat (2052 + 2053) and détermination du résultat fiscal (2058-A) ship pre-seeded with a condensed rubrique layout and a PCG account-prefix mapping. Every table, rubrique, subtotal formula and mapping is editable in Configuration.
Brut / Amortissements / Net Bilan
Bilan actif rubriques are computed in the three CERFA columns: gross amounts, amortissements & provisions, and the net (brut − amort) — carried through the subtotals, the on-screen list and the exports.
N / N-1 Comparison Columns
Link the prior-year worksheet and every liasse line shows the N-1 amount and the variation, both on screen and in the CSV exports; a coherence control flags year-over-year result swings above 50%.
Cohérence Controls
One-click pre-filing checks: bilan équilibré (actif = passif), balance equilibrium (débit = crédit), résultat CR = résultat bilan, produits (cl.7) − charges (cl.6) = résultat — each stored with an OK / warning / error status.
Unmapped-Account Warning
Accounts the mapping does not cover are never silently dropped: they are listed on the worksheet with their balances and raised as a warning in the cohérence controls so the mapping can be completed.
CSV & Per-Tableau Exports
Export the whole worksheet as CSV, or one CSV per tableau bundled in a ZIP — with the brut/amort/net breakdown and the N / N-1 columns — ready to hand off to your EDI partner.
Working Paper Only — No EDI-TDFC
Strictly a working paper / format-generation tool: there is NO EDI-TDFC transmission. The accountant transmits the liasse through their own EDI partner or impots.gouv.fr.
Use Cases
Screenshots
Import Trial Balance
Pcg Liasse Mapping
Liasse Tables
Liasse Worksheets
Why Choose This Module
This module replaces that spreadsheet: it imports the trial balance, applies a mapping table from PCG account prefixes to liasse line codes, computes each of the five seeded 2050-series tables (condensed rubrique layout, fully editable) with the brut / amortissements / net bilan columns and the N / N-1 comparison, and produces a working paper with the control checks (bilan équilibré, résultat cohérent, comptes non mappés). It is strictly a working paper / format-generation tool — there is NO EDI-TDFC transmission. The accountant transmits the liasse through their own EDI partner or impots.gouv.fr.
Specifications
- Compatible: Odoo 18.0 / 19.0
- License: OPL-1
- Languages: English
- Author: Pokutsoft
- Dependencies: account
- Support: support@pokutsoft.com
Update date: 2026-07-03
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 1985 |
| Technical Name |
fr_liasse_fiscaprep_worksheet |
| License | OPL-1 |
| Website | https://pokutsoft.com/ |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module