Configuration
After activating the module, access the configuration via Home > Setup > Modules > Accounting Assistant (gear icon) or from the Configuration link at the bottom of the module home page.
The configuration is organized in several tabs, each corresponding to a feature.
Payroll tab
| Setting | Description |
|---|---|
| Enable payroll entries import | Enables the payroll import menu and the associated feature |
| Payroll provider | Select your payroll software (Silae, FEC...) to adapt the import format |
VAT closure tab
This tab configures the generation of VAT closure entries.
| Setting | Description |
|---|---|
| Journal for VAT closure entries | Journal in which the entries are recorded (default OD, miscellaneous operations) |
| Rounding difference account (expense) | Account debited when the declared amount is higher than the ledger balance. Default 658 |
| Rounding difference account (income) | Account credited when the declared amount is lower than the ledger balance. Default 758 |
The two rounding difference accounts are required for the entry to balance. The closure clears the VAT accounts for their exact amount, down to the cent, while the VAT to pay is rounded to the euro as on the CA3: the difference, usually a few cents, has to land somewhere. Without these accounts, the module refuses to generate the entry. See VAT closure for the detail of the mechanism.
Some firms prefer 6788 and 7788 (miscellaneous exceptional expense and income) over 658 and 758. Both settings accept any account from your chart of accounts.
VAT allocation tab
This tab lets you define mapping rules between VAT rates and accounting accounts. These rules are used when transferring invoices to accounting to force a specific account according to the rate.
General settings
| Setting | Description |
|---|---|
| Enable allocation by VAT rate | Enables the automatic application of the rules when transferring to accounting |
| Log the mappings | Records in dolibarr.log each application of a rule (useful for diagnosis) |
Diagnostic
The diagnostic shows the state of your rules:
- Number of active VAT rates covered by a rule
- Alerts on accounting accounts referenced but not existing in the chart of accounts
Allocation rules
Each rule associates a combination of criteria with an accounting account:
| Field | Description |
|---|---|
| Product | A specific product or all products (global rule) |
| Type | Product, Service or All |
| Direction | Sale or Purchase |
| VAT rate | The VAT rate concerned (e.g. 20, 10, 5.5, 0) |
| Accounting account | The account to use for this combination |
VAT check tab
This tab configures the expected VAT rates according to seller/buyer fiscal zones. These rules feed the rate audit and the correction button on document cards.
General settings
| Setting | Description |
|---|---|
| Enable VAT rate check | Enables the audit and alerts on documents |
| Warn if the third party's postal code is missing | Displays a warning when a third party has no postal code (prevents determining its fiscal zone) |
The page shows the fiscal zone detected for your company (metropolitan France, Corsica, DOM with VAT, DOM without VAT) based on the postal code configured in your company card.
Fiscal zones
The available zones are:
- Metropolitan France -- Standard rates (20%, 10%, 5.5%, 2.1%)
- Corsica -- Specific rates (13%, 10%, 2.1%, 0.9%)
- DOM with VAT -- Guadeloupe, Martinique, Reunion (8.5%, 2.1%, 1.75%, 1.05%)
- DOM without VAT -- French Guiana, Mayotte (0%)
- Intra-Community B2B -- Professional customer in the EU with an intra-Community VAT number (0%)
- Intra-Community B2C -- Private customer in the EU (seller country rate)
- Export (outside EU) -- Outside the European Union (0%)
Pre-filling the rules
Click Pre-fill common rules to automatically create all the expected rates for your fiscal zone. Existing rules are neither modified nor duplicated. You can then adjust manually if needed.
Rules by product type
Some rules can distinguish products from services. For example, the reduced 5.5% VAT may apply only to food products while services remain at 20%.
Import reverse charge tab
This tab configures the generation of reverse charge entries for imports from outside the EU.
General settings
| Setting | Description |
|---|---|
| Enable VAT reverse charge on imports | Enables the menu and the detection/generation feature |
| Default VAT rate | Rate applied to invoice lines without an associated product (default 20%) |
Account mapping by rate
Define for each French VAT rate the accounting accounts to use:
| Field | Description |
|---|---|
| VAT rate | The VAT rate concerned |
| Deductible VAT account (debit) | Debited account (e.g. 44566 - deductible VAT on other goods and services) |
| Reverse-charged VAT account (credit) | Credited account (e.g. 4452 - intra-Community VAT payable) |
If no mapping is defined for a rate, the module uses Dolibarr's default accounts (constants ACCOUNTING_VAT_BUY_REVERSE_CHARGES_DEBIT and ACCOUNTING_VAT_BUY_REVERSE_CHARGES_CREDIT).
The diagnostic at the bottom of the page checks that all active VAT rates have a configured mapping.
Bernard tab
Bernard is a community accounting code suggestion service. The configuration takes place in several steps.
Connection
- Click Connect to Bernard
- The connection uses the email address of your Dolibarr account
- A Bernard account is created automatically if needed
- If the instance is already associated with another address, a verification code is sent by email
Settings (after connection)
| Setting | Description |
|---|---|
| Enable Bernard suggestions | Shows the "Ask Bernard" button on product cards without an accounting account |
| Offer to contribute after each manual assignment | After assigning an accounting code, offers to share it with the community |
| Review mode before sending | Validate each pattern individually before a grouped send |
Chart of accounts synchronization
The synchronization shares your chart of accounts and your entry patterns with the Bernard community. Only accounting codes and pattern labels are transmitted, no financial data.
Click Share my chart of accounts with Bernard to perform the initial synchronization. You can resynchronize at any time if your chart of accounts evolves.
Subscription
Bernard offers a free mode with a limited monthly quota (5 requests). To go beyond, take a subscription: the Subscribe button on the configuration page opens the Bernard order page, where the subscription is chosen and paid. The button is shown during the trial, in free mode and on a suspended account; it disappears once the subscription is active.
A subscription gives 10,000 requests per month. Once this ceiling is reached, searches display "Monthly subscription ceiling reached, it resets on ..." with the reset date (the 1st of the following month).
If a subscription invoice remains unpaid, the configuration page displays the warning "Invoice ... unpaid, access suspended on ... without payment" with a link to the order page. The service continues until that date; the warning disappears once the invoice is paid.