1. Introduction & Design Philosophy

Advanced Accounting Office turns Dolibarr into a complete, professional solution for running a chartered-accountant / bookkeeping practice. It is delivered as a business layer that sits ON TOP of Dolibarr’s native accounting rather than replacing it.

Core principle — no duplication of the ledger

The module never reinvents Dolibarr accounting. It relies on the existing native modules and extends them with the specific workflow of an accounting firm. Every heavy computation reuses native tables (third parties, customer & supplier invoices, payments, bank, accounting bookkeeping, projects, users, agenda, document management) and adds only the firm-specific business objects on top.

What the module adds

·       Client centralisation — a dedicated accounting client file (dossier comptable) extending each native third party.

·       Mission steering — accounting missions with a drag & drop Kanban board, deadlines and progress.

·       Fiscal supervision — a fiscal & social deadline calendar, declaration tracking and filing workflow.

·       Task automation — accounting tasks, recurring fees, and a daily supervision cron.

·       Financial analysis — per-client turnover, unpaid invoices, profitability and a cabinet dashboard.

·       Firm & staff management — collaborator workload, performance and client assignments.

2. Native Dolibarr Integration

The module is connected directly and deeply to the following native Dolibarr modules. When an optional module is disabled, the related features degrade gracefully and never block activation (only the Third Parties module is a hard dependency).

3. Functional Features (Detailed)

3.1 Client Management (Accounting Client Files)

Centralises every accounting client as a structured file (dossier comptable) built on top of the native third party, adding the accounting-specific attributes a firm needs.

·       Native extension — linked one-to-one to a Dolibarr third party; the native record is never duplicated.

·       Client classification — company, individual or association, plus legal form (SARL, SAS, EI, SCI, association…).

·       Fiscal identity — SIREN, intra-community VAT number, VAT regime (normal / simplified / franchise) and tax regime (CIT, PIT-BIC, PIT-BNC, micro).

·       Assignment — a lead accountant (native user) and recurring fee amount and periodicity per file.

·       Complete history — automatic link to native invoices, payments and accounting entries via the card cockpit.

·       Client cockpit — the file card shows native invoiced turnover, VAT regime, fee, number of missions and every linked record.

3.2 Accounting Client Dossiers

Each client file acts as the central hub that centralises everything the firm handles for that client.

·       Centralisation — invoices, accounting entries, fiscal declarations and documents are all reachable from the file.

·       Linked-records panel — missions, deadlines, entries, audits and documents of the file are listed with one-click "add linked" buttons.

·       File status tracking — active / closed / cancelled status with a clear visual badge.

·       Deep-link creation — any linked record can be created already attached to the file, without retyping the relation.

3.3 Complete Bookkeeping (Cabinet View)

Provides a multi-client cabinet accounting view on top of the native accounting engine — with no duplicated ledger.

·       Multi-client consolidation — one row per client file showing debit, credit and balance from the entry-control layer.

·       Native turnover — per-client managed turnover read from native customer invoices.

·       Native movements — when the Accounting module is enabled, native bookkeeping movement counts are shown per file.

·       Entry quality control — the number of entries still to be controlled is surfaced per client and globally.

·       Integration status — live badges show which native modules (Accounting, Invoicing) are active.

3.4 Entry Capture & Processing

Adds a firm-oriented quality-control and validation layer over the native bookkeeping.

·       Simplified entry sheet — piece, journal (VE/AC/BQ/OD/CA), account, debit, credit and date per entry.

·       Control workflow — each entry carries a control status: to control, validated or anomaly.

·       Validation by collaborator — entries record who entered and who validated them (native users).

·       Correction workflow — entries flagged as anomaly are surfaced in the validation cockpit for correction.

3.5 Billing & Fees (Honoraires)

Manages engagement letters and recurring fees using native Dolibarr invoicing.

·       Engagement letters — per-client engagement type, fee amount, periodicity and validity dates, optionally linked to a native contract.

·       Fee models — recurring fee lines with amount, VAT rate and period, linked to an engagement.

·       Native invoicing — fee lines link to native customer invoices; a trigger marks them invoiced when the invoice is paid.

·       Client profitability — the reporting hub compares fees vs. invoiced amounts per client.

3.6 VAT & Taxation

Uses the native Dolibarr VAT computation and adds fiscal deadline supervision and preparation.

·       Deadline tracking — fiscal & social deadlines (VAT, CIT, tax package/liasse, CFE, CVAE, DSN, DAS2, PIT) per client file.

·       Automatic alerts — the dashboard and calendar highlight deadlines due soon and overdue; a daily cron flags them.

·       Declaration preparation — estimated amounts, periods and responsible collaborators per deadline.

·       VAT summary — a dedicated report summarises VAT base, tax and filing status per period.

3.7 Balance Sheets & Income Statements

Analytical reporting generated from Dolibarr accounting and the module layer.

·       Cabinet multi-client view — debit/credit/balance and result per client from the entry-control layer.

·       Comparative analysis — turnover, result and profitability compared across the whole client portfolio.

·       Exports — every report exports to PDF, Excel and CSV, plus direct print.

3.8 Collaborator Management

Uses native Dolibarr users and adds firm-level workload and performance steering.

·       Client assignment — collaborators are assigned to client files with a role (lead, assistant, reviewer, payroll manager).

·       Workload — workload percentage per collaborator and number of files handled.

·       Performance — missions, open missions, late missions, tasks to do and a computed performance score per collaborator.

3.9 Accounting Task Management

Uses the native agenda / projects and adds accounting missions and deadlines.

·       Accounting missions — bookkeeping, review, annual accounts, tax package, VAT, payroll, legal and advisory missions.

·       Kanban board — missions move across six stages (to do, collecting, in progress, under review, validated, closed) by drag & drop.

·       Deadlines & reminders — each mission and deadline carries a due date; a daily cron flags lateness automatically.

·       Tasks — granular accounting tasks (capture, reconciliation, declaration, control, lettering, review) linked to missions and files.

3.10 Accounting Documents (GED)

Uses the native Dolibarr document management and classifies documents per client file.

·       Automatic classification — documents typed by nature (balance sheet, tax package, invoices, bank statement, articles, Kbis, general ledger, trial balance).

·       Fiscal archiving — each document carries a fiscal year and an archived flag for legal retention.

·       Per-file organisation — documents are attached to the client file and reachable from its linked-records panel.

3.11 Internal Audits

Analysis built on Dolibarr data to verify accounting consistency and report anomalies.

·       Audit types — consistency, VAT, lettering and analytical review audits per client file.

·       Anomaly reports — each audit lists detailed anomalies (imbalance, unusual account, inconsistent VAT, missing voucher, duplicate) with severity, account and amount.

·       Quality score — a per-audit quality score and anomaly count feed the dashboard and reports.

3.12 Validation Workflows

Uses Dolibarr triggers/hooks and provides a one-click validation cockpit.

·       Entry validation — validate an entry or flag it as an anomaly directly from the cockpit.

·       Declaration validation — mark declarations as filed once submitted.

·       Invoice coherence — a native trigger marks linked fees as invoiced when the customer invoice is paid.

3.13 VAT Management

A dedicated VAT layer that tracks each declaration period per client alongside the native VAT engine.

·       VAT periods — monthly/quarterly periods per client with collected VAT, deductible VAT, VAT credit and VAT due.

·       Filing status — preparation, verification, filed status and responsible collaborator per period.

·       Dashboard & report — a "VAT due" KPI and a "VAT by client" report consolidate the whole portfolio.

3.14 Payroll Management

A simplified HR/payroll layer to run the payroll service a firm offers to its clients.

·       Payroll slips — employee payslips per client with gross salary, social charges and net salary.

·       Period tracking — pay period, pay date, filing status and the collaborator in charge.

·       Reporting — a "Payroll by client" report totals gross, charges and net across the portfolio.

3.15 Advisory Engagements

Structured management of the advisory services a firm delivers beyond bookkeeping.

·       Advisory types — tax, financial, legal/administrative advisory and company-setup support.

·       Follow-up — meeting dates, next appointment, expected deliverable and advisory fee.

·       Reporting — an "Advisory by type" report shows volume and fees per advisory category.

3.16 Time Tracking (Temps passe)

Captures the time spent per client and per mission to drive productivity and profitability.

·       Timesheets — time entries per client and mission with duration, date and collaborator.

·       Billable time — billable / non-billable flag and hourly rate per entry.

·       Profitability — "Time by collaborator" and "Profitability by file" reports compare fees against time spent.

4. Modern Cabinet Dashboard

A modern accounting-firm cockpit connected to Dolibarr data, organised in KPI zones and charts.

4.1 KPI widgets

·       Client portfolio — active clients, open missions, late missions and recurring fees.

·       Fiscal supervision — VAT to file, deadlines due within 15 days, overdue deadlines and declarations filed this year.

·       Entry quality control — entries to control, entries in anomaly, audit anomalies and controlled volume.

·       Payroll & advisory — open dossiers, VAT due for the period, open advisory engagements and hours logged this month.

·       Managed billing — managed turnover this year, unpaid invoices and invoice count (native invoices scoped to the firm clients).

4.2 Charts

·       Missions by stage — distribution of missions across the Kanban stages.

·       Turnover by client — top clients by native invoiced turnover (pie).

·       Deadlines by month — upcoming fiscal deadlines over the next months.

·       Missions by collaborator — workload distribution across the team.

5. Reporting

Seventeen reports, based only on Dolibarr data (native invoices) and the module business layer, each exportable to PDF, Excel and CSV with a print option.

6. Configuration

·       Firm parameters — default currency, deadline alert threshold (days), default VAT regime and quality target.

·       Native integration status — live indicators for Third Parties, Invoicing, Accounting, Bank, Projects, Agenda and GED.

·       Permissions — granular Dolibarr rights per feature group (see Security).

·       Demo data — one-click install or secure removal of the demonstration dataset.

·       Dashboard colours — a consistent teal / navy accounting charter across all screens.

7. Demonstration Data

On first activation the module seeds a complete, realistic demonstration dataset so dashboards, KPIs, charts, reports and lists are immediately meaningful. The purge removes only the module’s own demo data and the native objects it created — never core Dolibarr data.

·       30 native third parties + 30 accounting client files + 45 accounting dossiers

·       70 accounting missions across all Kanban stages and 90 accounting tasks

·       130 fiscal deadlines, 80 declarations and 96 VAT periods

·       160 bookkeeping entries to control, 30 engagement letters and 90 recurring fee lines

·       80 payroll slips, 40 advisory engagements and 150 timesheet entries

·       24 internal audits with 36 detailed anomalies, 60 classified documents and 50 collaborator assignments

·       60 native customer invoices (a mix of drafts, validated and paid) linked to the demo clients

8. Architecture, Security & Technical Specifications

8.1 Architecture

·       Standard Dolibarr module — follows native conventions: hooks, triggers, cron jobs and extended native classes.

·       SQL prefix — all module tables use the llx_advancedaccountingoffice_ prefix (17 tables).

·       Business objects — 17 objects: client files, accounting dossiers, missions, tasks, deadlines, declarations, VAT periods, entries, engagement letters, payroll slips, audits, anomalies, advisory engagements, documents, timesheets and assignments.

·       Cron — a daily fiscal-deadline supervision job flags overdue deadlines and late missions.

8.2 Security

·       Dolibarr permissions — read/write/delete rights across 16 feature groups (clients, dossiers, missions, tasks, deadlines, declarations, VAT, entries, contracts, payroll, audit, advisory, documents, timesheets, assignments, reporting) plus an admin right — 47 rights in total, mappable to firm roles (partner, mission manager, accountant, auditor, assistant, reader).

·       CSRF & XSS protection — CSRF tokens on all state-changing actions and systematic output escaping.

·       SQL safety — prepared/escaped queries throughout the data layer.

·       Multi-company — fully multi-entity compatible (entity-scoped data).

8.3 Technical specifications

9. Multilingual Support

The module ships with five complete language files, so every label, menu, report and message is fully translated:

·       French (fr_FR)

·       English (en_US)

·       Spanish (es_ES)

·       Italian (it_IT)

·       German (de_DE)