accountingassistant - Assistant Comptable 1.5.0 (V18 - V23)

Dolibarr double-entry accounting keeps your general ledger, but fixing a batch of entries posted to the wrong account, closing VAT or preparing the CA3 return are still manual chores. Accounting Assistant brings into the Accounting menu the tools the standard lacks for these day-to-day and year-end operations. It complements the native Accounting module without replacing it, and follows French VAT rules and the French CA3 return.

Fix postings without re-entering anything

Mass reassignment of bookkeeping entries

• Reusable rules: source account, target account, pattern in the label (% wildcard), period and journal
• Preview of the matching entries, old and new account side by side, with debit and credit totals
• Applied in a single transaction, then the rule is locked and kept for the audit trail
• Validated entries and lines of a closed fiscal year are never modified
• "Reassign account" mass action straight from the general ledger lists

Bank line reassignment by statement

• A statement entered or reconciled on the wrong bank account is moved to the right account, with its new statement number
• Linked payments follow, the reconciliation status is kept and the balances of both accounts are recalculated
• Warnings before applying: target statement already in use, cheque deposit slip, internal transfer between the two accounts (reversed automatically)
• The move is refused if a line has already been transferred to accounting, so the bank and the ledger never drift apart

Sales account audit by zone

• List of the products sold without a France, EU or Export sales account, with the number of invoices and the amount sold per zone
• Missing accounts assigned in bulk, without overwriting those already set

VAT: from closure to return

VAT closure entries

• Deductible VAT, collected VAT, credit carried forward and the summer holiday down payment (account 44581) computed from the general ledger
• Prefilled, editable amounts, with a preview of the entries before they are generated
• VAT accounts cleared to the cent, VAT payable rounded to the euro as on the CA3: the difference goes to a configurable rounding account
• Warning when the difference reaches 1 euro, the sign of a discrepancy rather than rounding
• Entries already generated for a period can be viewed, regenerated or deleted

CA3 preparatory report in PDF

• The CA3 lines as they appear on impots.gouv.fr, frame A (transactions) and frame B (VAT computation), calculated from the general ledger
• Standard rates, French overseas departments and Corsica rates, import VAT, breakdown of transactions by country
• Cross-check between the general ledger, the transferred invoices and all invoices of the period, to spot those not yet in accounting
• Configuration warnings, including foreign supplier invoices without reverse charge, with the fix to apply
• PDF export to use while filing, and the declared amounts sent on to the VAT closure

VAT rate audit by fiscal zone

• Each thirdparty's zone derived from its country, postcode and intra-EU VAT number: mainland France, Corsica, overseas departments with and without VAT, EU B2B and B2C, export
• Expected rates prefilled for your zone, adjustable and able to tell products from services
• Audit of invoices, proposals, orders, contracts and recurring invoices, with grouped correction of draft documents
• Summary per thirdparty and per rate to quantify what was invoiced at a wrong rate
• Alert banner on the document card as soon as a line carries a suspicious rate, with a Fix VAT button; a validated invoice is never corrected automatically

Import VAT reverse charge

• Detection of non-EU supplier invoices already transferred to accounting and lacking a reverse charge entry
• Generation of the deductible VAT / self-assessed VAT pair of entries, using accounts set per rate
• Catches up a forgotten "VAT reverse charge" checkbox without transferring the invoice again
• Diagnosis when no invoice is found for the period

VAT rate to account mapping

• Rules linking a VAT rate, a direction (sale or purchase), a type (product or service) and optionally a specific product to an accounting account
• Account applied automatically when invoices are transferred to accounting
• Diagnosis of active rates without a rule and of accounts missing from the chart of accounts

Payroll entries import

• CSV files exported from Silae or FEC files, format detected automatically
• Analysis before import: period, number of entries, debit / credit balance
• Accounts missing from the chart of accounts listed, import blocked until they exist
• Import refused if the file or one FEC voucher does not balance, and warning if the period was already imported
• Preview of the entries before they are created in the general ledger

Bernard, community accounting suggestions

Bernard suggests accounting accounts based on the postings shared by other Dolibarr users.

• "Ask Bernard" button on product cards with no purchase or sales account
• Search by label (URSSAF, EDF...) and bulk analysis of the labels of bank account 512 over a year
• Local status of each suggestion: existing account, to be created, disabled or in conflict
• Share your postings one at a time or in bulk: only codes and label patterns are sent, never amounts, customer names or payroll data

Bernard is an optional online service run by CAP-REL. Every other tool of the module works without it. A free mode allows 5 requests per month; beyond that, a subscription separate from the module purchase gives unlimited suggestions, with an anti-abuse ceiling of 10,000 requests per month. It is taken out from the Bernard configuration page.

You stay in control

• Each tool has its own permissions: read, apply, generate, fix
• Payroll import, bank reassignment, VAT rate checking and reverse charge are enabled one by one in the configuration
• Reassignments, VAT closure, reverse charge and payroll import go through a preview and a confirmation before writing

Requirements

• Dolibarr 18 or later
• PHP 7.4 or later
• Double-entry accounting module enabled

Try it on a Dolibarr installed in less than 20 seconds: dolitest.fr/accountingassistant

Every feature is documented online: doc.cap-rel.fr/accountingassistant

What the purchase covers

• The module, and access to its updates for the period stated on this sheet
• Bug fixes, including the ones you report
• An email on every new release

To be told automatically about new versions, of this module and of the Dolibarr ecosystem at large, subscribe on dolinews.com: that is where our release announcements are published.

Support

Support goes through our support form, not through the comments on this sheet.

Support is not free. You want competent people on the other side: it is fair that they are paid for that time. The price shown covers the module and its updates. It covers neither installing nor configuring your Dolibarr, nor training your teams, nor specific developments, nor investigating an environment we do not host.

A reproducible bug in the module is fixed at no charge, as part of the updates above.

Before buying

• Check the Dolibarr and PHP versions stated at the top of this sheet: beyond them, the module is not tested
• Modules are deployed from Home > Setup > Modules > Deploy an external module, which requires an active custom directory on your installation
• When a module relies on an online service, the subscription to that service is separate from buying the module, and is stated above

Publisher

Module developed by CAP-REL, under the GPL-3.0-or-later licence. Online documentation at doc.cap-rel.fr.

Version history

1.4.0 -- 20260415

• VAT rate audit by fiscal zone: detect suspect VAT rates on invoices, proposals, orders, contracts based on seller/buyer zone rules
• Real-time VAT alert on document cards (invoice, proposal, order, contract): warning banner displayed on page view when suspect lines are found (works for lines created via UI, API, duplication, import)
• Auto-fix button to correct VAT rates on draft documents directly from the document card
• VAT rate audit page with summary table by third party and VAT rate, and totals per applied rate
• Prefill common VAT rules based on seller fiscal zone (metropole, Corsica, DOM, intra-EU, export)
• CA3 VAT declaration preparatory report with PDF export and cross-check totals
• Import VAT auto-liquidation for non-EU supplier invoices
• VAT mapping: automatic accounting code assignment based on VAT rate during transfer to bookkeeping
• Module index page with feature cards
• About page with module info, feedback form, donation, useful links and changelog
• Improved dol_syslog prefix consistency (AA prefix for grep)
• Memcached flush on module activation
• PHPStan static analysis configuration
• Makefile with documentation deployment and screenshot collection targets
• All module includes use dol_include_once (Dolistore compliance)

1.2.1 -- 20260218

• Handle "no answer" situation

1.2.0 -- 20260217

• Add bernard webservice

Truncated history, intermediate releases not shown: 1

The first release of this module dates from 2026-02-12.

1.0.0

• Initial version

The full changelog is on the "About" page of the module once it is installed.