What's new in version 1.5.0

Version 1.5.0 brings bank reassignment, consolidates the VAT closure, the CA3 report and the payroll import, and connects the module to the Bernard subscription. It also significantly strengthens page security and rights control.

Before updating: the module now requires Dolibarr 18 or newer and PHP 7.4 or newer; it works up to Dolibarr 24. After the update, disable then re-enable the module (see the "Update" section at the bottom of the page): without this step, nobody can access the VAT closure anymore.

Bank reassignment

A reconciliation or transaction entry made on the wrong bank account is fixed without re-entering everything: the tool moves the transactions of a statement from the source account to the right account, with a new statement number. Payments stay attached to their bank transactions and follow them; the ledger is never modified.

An internal transfer between the two accounts is automatically reversed, to remain a valid transfer.
The move is refused if a transaction of the statement is already transferred to accounting, if the currencies differ or if the target account is closed.
An applied rule is locked and can no longer be deleted.

The feature is disabled by default. It is enabled in the module configuration (Home > Setup > Modules/Applications > Accounting Assistant, Payroll Import tab, option Enable bank reassignment), then used from Accounting > Accounting Assistant > Bank reassignment, with its own permissions (read, modify, apply, delete).

To learn more: Bank reassignment.

VAT closure

Automatic rounding difference: the VAT accounts are cleared to the cent, the VAT to pay is rounded to the euro as on the CA3. The difference is automatically posted to a rounding expense or income account (658 and 758 by default), to choose in the VAT closure tab of the configuration. A warning is displayed if the difference exceeds one euro.
Chart of accounts labels: the entries take the labels of your accounts.
Dedicated permission: the VAT closure has its own permission, "Generate and delete VAT closure entries", separate from the other VAT tools. Users who could apply reassignment rules automatically receive it when the module is re-enabled.
Accounts from your chart of accounts: the VAT accounts cleared are those set in Dolibarr (default accounts and VAT rates dictionary accounts), and no longer only the standard accounts.
VAT credit carry forward: the credit left by the previous month's closure is automatically proposed and deducted from the VAT to pay.
Guardrails: the closure refuses an invalid period, and stops if the search for an already generated closure fails.

To learn more: VAT closure.

CA3 preparatory report

Reverse-charged intra-Community VAT: it is taken up in the rate line (08 for 20%), whether posted on a 4452, a 4457 or the account set in Dolibarr.
Lines 17 and 18: the report shows VAT on intra-Community acquisitions and on transactions destined to Monaco.
Monaco: a customer or supplier established in Monaco is treated as French, both in the report and in the VAT rate check.
The report flags supplier invoices subject to reverse charge that are missing from the return, with the procedure to follow depending on the case: invoice not yet transferred, non-EU import or intra-Community purchase.
It also flags a reverse charge disabled in Dolibarr or reverse charge accounts missing from the chart of accounts.
The calculation stops with a message rather than displaying wrong amounts if the control totals, the reverse charge setup or the previous month's credit cannot be read.

To learn more: CA3 preparatory report.

Import VAT reverse charge

Your purchase journal: the entries are posted in a purchase journal of your chart of accounts, whatever its code (AC, HA...), and no longer in a fixed ACH journal. With several purchase journals, you choose yours on the page, and the module then proposes it by default. Without an active purchase journal, the generation is refused with a message.
The page recognizes invoices already processed thanks to the configured reverse charge accounts, so as not to propose them a second time.

To learn more: Import VAT reverse charge.

Automatic VAT rate correction

The purchase price and the line period dates are preserved during the correction.
The audit summary by third party and by rate covers all result pages, and no longer only the displayed page.
The correction is refused on an invoice that is paid, partially paid, closed or already accounted, and without the rights to modify the document.

Payroll import

An import is refused if its balance or a FEC document does not add up.
UTF-8, Windows-1252 or ISO-8859-1 files are recognized automatically, and kept on disk until the end of the import.
Accepted files are limited to 10 MB, in .csv, .fec or .txt.
Silae entry labels no longer contain the employee's name.
Silae dates are accepted with or without a leading zero on the day and month; an impossible date, such as 31/02, is rejected.

Accounting reassignment

Validated entries and lines of a closed financial year are never reassigned.
An already applied rule can no longer be deleted, to keep the audit trail; deleting a rule asks for confirmation.
The mass action also updates the account label and checks that the target account exists; applying a rule is refused in the same way if its target account has been deleted or deactivated since its creation.
Searching in the rule lists works like in Dolibarr lists: several words, and ! in front of a word to exclude it.
On Dolibarr 22 and newer, this feature is part of Dolibarr: its menus, its home card and its mass action are no longer displayed.

To learn more: Accounting reassignment.

Bernard

Subscribe from the module: the "Subscribe" button on the Bernard page opens the Bernard order page directly.
Subscription ceiling: the subscription offers unlimited suggestions with an anti-abuse ceiling of 10,000 per month. The module clearly indicates when this ceiling is reached and the date it resets.
Unpaid invoice: if a subscription invoice is unpaid, the Bernard page displays it, with the date on which access will be suspended when known.
Subscription states: trial, free, active and suspended are displayed correctly.
Payroll data: no personal payroll data is transmitted to Bernard.
Rights: using suggestions requires the "Use Bernard suggestions" permission, and applying a suggestion requires the right to modify products for a product, services for a service.

To learn more: Bernard.

Sales accounts audit

The bulk update of accounts requires the right to modify the products or services concerned.

Demo data

A new Demo tab in the module configuration generates, then purges, a complete dataset: a fictitious bakery with its customers and suppliers, two months of invoices transferred to accounting (one clean month for the CA3 and the VAT closure, one month containing errors that the audits detect), two bank accounts with their statements and reassignment rules. It is reserved for test or presentation instances, and the purge only removes the data marked by the module, in the current entity only. The demo account lands on the module home page, with a short guided tour.

To learn more: Installation.

Comfort and security

A slow form can no longer be submitted twice.
The module signals, on activation, that a newer version is available.
All delivered languages are complete, permissions included, and Brazilian Portuguese makes its entry.
Displayed data is escaped, every action that modifies data checks its security token, and return links can no longer lead outside Dolibarr.
Module activation is refused if one of its tables could not be created, instead of failing later.
The VAT closure page opens again when the company's country is filled in.
Month names follow the user's language on the CA3 report, its PDF and the reverse charge page.
Country names also follow the user's language in the CA3 report and the reverse charge page, and default journals are displayed with their translated name.
On Dolibarr 22 and newer, the entries of the payroll import and of the VAT closure receive their document number in the ledger, like Dolibarr's transfers.

Update

Check that your Dolibarr is version 18 to 24, with PHP 7.4 or newer.
Replace the accountingassistant folder with the one from the new archive.
Disable then re-enable the module in Home > Setup > Modules/Applications. This step creates the bank reassignment table and the new permissions, grants the VAT closure permission to users who could apply reassignment rules, and automatically converts the journal chosen for the VAT closure to the new format.
Check in the user and group cards the new permissions: VAT closure, bank reassignment, VAT rate correction.
If you want to use bank reassignment, enable it in the module configuration (Payroll Import tab).