French VAT CERFA 3310-CA3 - VAT Return for Dolibarr

French VAT CERFA 3310-CA3 - VAT Return for Dolibarr

Professional French VAT return module (standard real tax regime) for Dolibarr. Automatically calculates your CERFA 3310-CA3 form from your customer and supplier invoices, with fiscal safeguards that block any inconsistent return before filing and alerts that flag doubtful deductions.

What's new in v5.1.28

• Taxes module: link or unlink an existing VAT record: a record created outside the module (API, manual entry, data import) can be linked to its return from the return card, through a ranked list (same direction, same amount, "Match" column), a review and a confirmation; a mismatch (direction, amount) is linked only with an acknowledgement box and a reason. Every link is traced; the record, the bank and the accounting are never modified. A return can carry several records.
• Warning before a duplicate: before recording the VAT to pay or the expected refund, the summary flags an unlinked record with the same direction and amount (link to attach it instead of creating a new one).
• Greyed-out buttons with their reason: the "Record VAT payable" and "Record expected refund" buttons no longer disappear (linked record, missing right): they are greyed out, with the reason in a tooltip.
• Update: disable then re-enable the module (new table for the link log); without it, Link and Unlink stay greyed out. Tested on Dolibarr 18.0.10, 23.0.4 and 24.0.2; versions 19 to 22 declared compatible without testing.

What's new in v5.1.27

• No write checkbox is ticked by default on the OD page any more: the six write checkboxes (net 19/20, forced line, collected-VAT remainder, rate pair, non-deductible, foreign VAT) are unchecked on load, like the time-barred excess one, and a note says so. Nothing is written without your action.
• Correct "Total of proposals": the box now adds up every OD to post (collected-VAT remainder, rate pair, non-deductible, foreign VAT, excess), not just the net 19/20; an "ODs to reverse: N" line appears when entries are to be reversed.
• Excess and collected VAT recognised in the ledger are cited: a return's header cites the manually posted entries the module recognises; the "replayed OD" block says where the out-of-scope sum goes.
• Fiscal year without an end date: no more "01/01/1970" or fatal error (blank page) under PHP 8 in the statistics and in the annual regime; a missing end is shown as "no end date". The module never creates or modifies a fiscal year.
• Entry labels in the company language: labels written to the ledger no longer depend on the logged-in user's language, and periods are written as dd/mm/yyyy. To check before updating: the company default language (Setup > Company); missing or empty means French. Existing entries are not rewritten.
• Other fixes: an expired security token on a return card shows Dolibarr's native warning instead of an HTTP 500; screen texts no longer show doubly encoded characters; reversals on the entries screen are serialised with their entry family; on Dolibarr 18, a second Taxes-module record is no longer created for the same return.
• Update without migration: no database change: copy the new version over the old one, without disabling or re-enabling the module. Tested on Dolibarr 18.0.10, 23.0.4 and 24.0.2; versions 19 to 22 declared compatible without testing.

What's new in v5.1.26

• Ledger piece numbering made safe: no more duplicate piece numbers between two simultaneous entries (per-entity counter), no more deletion by piece number, a collision with a core entry is refused before the commit; OD batches from the OD page are written in a single transaction, entirely or refused entirely
• Collected-VAT remainder recognised in the ledger: a remainder OD posted by hand and dated after the end of the period is no longer proposed again (reason, piece number, link to the ledger); nothing is ever posted or reversed automatically
• New "time-barred excess deduction" OD (lines 19/20, 44567 debit, income account credit): checkbox unchecked by default, date never earlier than 01/01 of N+4, mandatory reason; the collected-VAT remainder checkbox also reappears after a reversal
• OD page on a stale calculation: "Eligible" qualified, "Recorded OD / Replayed OD" block, mandatory reason to force the net 19/20 OD; OD reversal under the return lock; core API explorer: routes answering 501 removed
• AFTER THE UPDATE, DISABLE THEN RE-ENABLE THE MODULE: a database migration runs on activation (new table llx_tva_cerfa_3310_piece_seq, the piece-number counter, update_5.1.25_5.1.26.sql). Without re-enabling, every write by the module is refused ("re-enable the module"), with no data loss; no existing return or entry is modified. Tested on Dolibarr 18.0.10, 23.0.4 and 24.0.2; versions 19 to 22 declared compatible without testing

What's new in v5.1.25

• Reclassification of shifted expense reports proposed by the module: when an expense report is booked on a different date than its lines, the return page proposes the reclassification OD through the 471 suspense account (one checkbox per proposal, unchecked by default, then native confirmation) instead of manual entry; entry re-read under a lock and verified, all or nothing, links to the ledger entry
• Reversal of a reclassification OD: "Reverse" button with an editable date; two reports of the same amount are no longer mixed up (the reversal cancels the entry it names); a manual reversal without a reference is still matched by age and the block says so
• Reasoned correction of already-posted net 19/20 ODs that include an out-of-scope gap: full reversal of each checked entry, with reason, date and acknowledgement, all or nothing; reason carried in the line label, the private note and the module log
• Clearer messages: expense report never booked ("book the expense report first"), reclassification recognised on the amount alone, ambiguous OD confirmation that lifts no refusal
• Reversal confirmations: the fiscal year name no longer shows a literal "—" and the date label no longer appears twice
• No database migration: no declaration or entry is modified by the update. Tested on Dolibarr 18.0.10, 23.0.4 and 24.0.2; versions 19 to 22 declared compatible without testing

What's new in v5.1.24

• Miscellaneous entries (OD): no OD is proposed any more on a gap "outside the scope of article 208" (it is not a time-barred loss), nor before the return's balance entry has been posted; "Balance posted manually" button if the balance was posted outside the module
• Stale calculation: validation is refused if a document (invoice, expense report, miscellaneous entry) has changed since the last "Calculate", with the list of documents; new "Update the calculation" button; on a validated or locked return, the balance entry and ODs are refused while the calculation is stale
• Expense reports booked outside the period: shift between periods quantified, reclassification OD through the 471 suspense account recognised (no more double counting on line 20), balance entry refused until a shift is reclassified; new suspense account setting
• Omitted deductible VAT catch-up declared on line 2C, 20, 19 or 21: detected, confirmed by you, then offset on 44567 by a zero-net OD; the remainder is never cleared automatically (time-barred after 31/12 of N+3, to be handled with your accountant)
• New warning banners on the return: already-posted ODs that include an out-of-scope gap (read-only), forced entries without a trace (add the trace with a reason), catch-up whose target return was deleted
• The default VAT-to-regularise account 4458 is no longer wrongly refused when saving the configuration; rate-pair lock held until the OD page has finished saving (clear refusal for a second simultaneous user)
• Dolibarr 18: the PDF of a return carrying a blocking-check override no longer stops with a fatal error, and six links (OD banner, dashboard, credit choice) are clickable again instead of plain text
• No database migration: no declaration or entry is modified by the update. Tested on Dolibarr 18.0.10, 23.0.4 and 24.0.1; versions 19 to 22 declared compatible without testing

What's new in v5.1.23

• Progress (construction) invoices now counted in collected VAT: they were in no base (CA3 understated without any warning); they are now counted at their own amount (lines 08, 09, 9B, A1, non-taxable operations, exports, intra-EU supplies), with an acknowledgeable warning per progress invoice
• Blocking checks, which an administrator can lift with a reason: progress invoice lines differing from its header, VAT rate changed between two progress invoices, tax-point regime not declared or set to "cash basis" (the calculation stays on the accrual basis)
• New setting "Tax-point regime" (general configuration): set it to "debits" if your company is on the accrual basis; until then, validating a return whose period contains a progress invoice is refused (block that can be lifted with a reason). Returns without progress invoices are not affected
• Customer replacement invoices now counted in collected VAT (the abandoned original was no longer counted, nor was the replacement); if the original sits in an already-filed period, only the difference is kept, with a warning; doubtful cases: validation refused, can be lifted with a reason
• Supplier replacement invoices now counted in lines 19 and 20, reverse charge and imports; the original drops out of the calculation (the base is no longer doubled); a new trigger records the abandon date of a supplier invoice
• AFTER THE UPDATE, DISABLE THEN RE-ENABLE THE MODULE (registers the new trigger). No database migration: no declaration or entry is modified. Tested on Dolibarr 18.0.10, 23.0.4 and 24.0.1; versions 19 to 22 declared compatible without testing

What's new in v5.1.22

• Truncated declaration card fixed: an expense report with zero VAT and no accounting entry in the period made the ventilation control fail (the page stopped after "Total purchases excl. VAT", with no button and no message); the control now skips it
• An expense report with non-zero VAT whose entries are outside the period is flagged "not journalized" instead of breaking the page
• No database migration: no declaration or entry is modified by the update, no CERFA line changes. Tested on Dolibarr 18, 23 and 24

What's new in v5.1.21

• Deductible VAT entered as a manual journal entry (no source document) on 44562/44566: it was ignored by the line 19/20 calculation; it is now detected and shown on the card as a checklist, ticked by default except doubtful cases that are flagged (net credit, journal other than OD, no label, already attached by the module, ambiguous pairing)
• These entries are never multiplied by the deduction coefficient, a reversal follows its twin, the selection is frozen at validation, and the Apply button keeps an override; new read-only API route and new export component
• The balancing entry no longer leaves a remainder on 44566, and the 44567 carry-over of a forced line 20 takes it into account
• After the update: a new table is created when the module is reactivated (disable then enable); no existing return is modified and no CERFA line changes without action on your part. Tested on Dolibarr 18, 23 and 24

What's new in v5.1.20

• No more phantom non-deductible VAT entry on reverse charge: when nothing is actually non-deductible, the CA3 rounding difference is no longer spread into entries of a few cents
• 44562/44566 split check: a reverse-charge document with no VAT entry in the general ledger becomes a non-blocking piece of information and is no longer shown as correctable
• VAT invoiced by a non-EU supplier: listed in the export manifest with the reason for its exclusion, and reclassified as an expense by a separate entry submitted for your approval (nothing is deducted)
• No CERFA line changes. No database migration: no return or entry is modified by the update

What's new in v5.1.19

• Support tab: the scheduled-task log (a second file, written when the module runs as a scheduled task) is now offered besides the module log, with a download for each and the total size
• No database migration: no return or entry is modified by the update

What's new in v5.1.18 (includes 5.1.16 and 5.1.17)

• Settlement entry: line 15 (previously deducted VAT to be repaid) is debited to the adjustment account (4458) when the VAT held there covers it; otherwise the review gives the reason
• Settlement entry for returns with lines 2C and 5B: the part explained by batch B is reversed account by account, the rest goes to 4458, the forced gap is carried to 44567
• Manual 44567 entry attachable when its supporting document is not retained by the forced line's calculation, with the reason shown
• No more false reversal warning; share claimed elsewhere with a choice of target line (21, 20 or none)
• No database migration: no return or entry is modified by the update

What's new in v5.1.15

• Omission claimed on another declaration: its share is excluded from the batch B ceiling, with a per-origin check before posting (gap, share claimed elsewhere, projected 44567 balance) and an acknowledgement if the balance differs
• Manual 44567 entry can be attached despite a forced gap, when its supporting document was created after the line's last manual override
• After updating, deactivate then reactivate the module to run the automatic migration; no validated or locked declaration is modified

What's new in v5.1.14

• Additional omission of deductible VAT on a validated declaration, without returning it to draft: catch-up journal entry, L19/L20 gap updated, cancellable, visible in the summary, the PDF and the API
• Explicit attachment of a manual 44567 entry to a validated declaration; new "Actual deductible VAT balance" section on the VAT entry screen
• Closed fiscal year: carry-over to 44567 proposed by default; reimbursed expense reports whose journalised VAT exceeds their lines' VAT are flagged (expense reports setting required)
• Return to draft: art. 208 nature kept and "amounts not recalculated" banner; "regularised, filing pending" state with forfeiture countdown
• Fixes: truncated 208 qualification (automatic migration), deadlines shown on exactly 31/12 in any timezone, CSV exports protected against formula injection, Dolibarr 18 compatibility
• After updating, deactivate then reactivate the module to run the automatic migration; no validated or locked declaration is modified

What's new in v5.1.13

• Declaration base lines (09, 9B, 10): no more crossed columns, boxes are read and overridden in the right direction; existing declarations are migrated automatically
• Balance entry: can be rewritten after a reversal (rank -R1, -R2...), and the reversal now carries the original entry date
• Rate reclassification (5.5% / 10% pair): qualification, removal and one-line display with the net amount
• Entry screen fixes (line 08 base in real time, gaps); browser cache is refreshed on every version

What's new in v5.1.1

• New pre-check alert on lodging expenses (hotel, holiday rental, furnished rental...) carrying VAT: VAT on lodging and accommodation of managers and staff is not deductible (art. 206 IV-2-3 ann. II CGI), ancillary fees included
• It covers supplier invoices and expense reports, is never blocking, can be acknowledged in one click and reappears if the VAT changes; no invoice is modified
• Keywords and expense types are adjustable in the configuration; an invoice attached to a non-deductible VAT project is not flagged

What's new in v5.1.0

• New pre-check alert on a restaurant or food receipt entered entirely at 20%: it prevents overstating deductible VAT when actual rates are 5.5%, 10% or 20% depending on the line
• Non-blocking, acknowledgeable and adjustable alert (accounts, keywords, suspect rate, minimum VAT)
• Discrepancy summary: filter by fiscal year, as on the settlement entries screen ("To process" by default, a specific year, or "All")
• Note: the summary's CSV export now starts with a "Fiscal year" line followed by an empty line, before the column header

What's new in v5.0.x

• Settlement entry: collected VAT is settled to the cent, sub-account by sub-account; the rounding of the euro-rounded declared line goes to a rounding account (658 or 758) instead of leaving a residue on the VAT accounts
• Override of a taxable base (frames A, B, E, F, I) detected, justified and traced: reason mandatory above an adjustable threshold, "Overridden base" block in the form and the PDF, retroactive finding possible on an already validated return
• Multi-line reasons displayed correctly everywhere, accurate rounding note, PDF without characters replaced by "?"
• Automatic filing cycle: returns created by scheduled task, filing calendar with email reminders, monthly periodicity in addition to quarterly
• Non-EU imports automatically distributed on lines I1-I6 and A4, "Nil" header boxes of the form
• Smarter accounting allocation: configurable suggestion rules, learning from supplier history; support for non-deductible VAT projects (documented exclusion, never silent)

What's new in v4.1.1

• Return PDF generation rebuilt: full presentation of the form with the colour of your Dolibarr theme
• Reverse charge made reliable: neutrality between collected and deductible VAT, line-by-line allocation of mixed supplier invoices, supplier credit notes taken into account
• OSS regime refined (detection by customer country) and line A1 rounding consistent to the cent
• Interface fully translated in the 5 languages

Features

• Automatic calculation of the return from your Dolibarr customer and supplier invoices
• Full CERFA coverage: multi-rate (20%, 10%, 5.5%, 2.1%), reverse charge art. 283-2 (EU and non-EU services), intra-community acquisitions, imports, exports, non-taxable transactions
• Fiscal safeguards at validation: 12 internal consistency rules - an inconsistent return is blocked before filing
• Non-blocking pre-check alerts: lodging expense carrying VAT, restaurant or food receipt entered entirely at 20%
• VAT credit chain verified from one period to the next, with automatic propagation between periods
• Accounting allocation pre-check: fixed assets (2xxx) and expenses (6xxx) verified before any calculation
• Assisted accounting allocation: account suggestion based on your chart of accounts, applied in one click
• VAT settlement entry: collected VAT settled to the cent, sub-account by sub-account, with the rounding of the euro-rounded declared line posted to a rounding account
• Traced override of a taxable base: reason recorded, dedicated block in the PDF
• OSS (one-stop shop) option for EU B2C sales
• Return PDF reproducing the full form (sections, CERFA codes, bases and amounts)
• Multi-entity, 5 interface languages (FR/EN/DE/ES/IT), built-in documentation
• Compatible with Dolibarr 18 to 24, general and non-profit charts of accounts

License and subscription

After purchase on the DoliStore, download the module from your account and install it in Dolibarr (external module deployment).

The annual subscription (EUR 149 excl. VAT/year) includes:

• The complete module
• All regulatory updates (CERFA form changes, new tax authority rules)
• Email support (tvacerfa3310@ptitetete.org)
• Preparation for upcoming e-invoicing obligations

Compatibility

Dolibarr 18.0 to 24 | PHP 7.4 to 8.5 | MySQL 5.7+ / MariaDB 10.3+ | Multi-entity

Tested at each release on Dolibarr 18.0 (lower bound), 23.0 and 24.0. Versions 19 to 22 are declared compatible but are not tested: an issue reported on one of them is handled as a normal defect. Only one module version is maintained: the latest.

Information

Email: tvacerfa3310@ptitetete.org
Complete documentation included in the module

---

Association P'tite Tete - Dolibarr modules since 2021