Sales accounts audit by zone
This tool analyzes your sales by geographic zone (France, European Union, Export) and identifies the products that have no sales accounting account configured for each zone. It then allows assigning the missing accounts in bulk.
Access
Accounting > Accounting Assistant > Sales accounts audit by zone
Usage
Overview
The page displays a summary in three indicators:
- Sold products -- Total number of products with sales over the period
- Products with anomalies -- Products for which at least one sales account is missing
- OK products -- Products whose accounts are all correctly configured
Filters
| Filter | Description |
|---|---|
| Year | Financial year to analyze |
| Zone | France, EU or Export (or all) |
| Status | All, With anomalies, OK |
Results table
For each sold product, the table displays:
- Reference and name of the product (link to the card)
- For each zone (France, EU, Export):
- Number of invoices and total sales amount
- Assigned accounting account or red Missing badge
Bulk assignment
- Tick the products to correct (only products with anomalies can be selected)
- Enter the accounting account to assign for each zone concerned (France, EU, Export)
- Click Apply to selected products
Only empty accounts are updated: if a product already has an account for a zone, it is not overwritten.
Accounts concerned
The three sales account fields by zone correspond to the following Dolibarr fields on the product card:
| Zone | Dolibarr field |
|---|---|
| France | Sales account (accountancy_code_sell) |
| EU | Intra-Community sales account (accountancy_code_sell_intra) |
| Export | Export sales account (accountancy_code_sell_export) |