Prévisionnel Complet

Prévisionnel turns your Dolibarr data into a financial analysis and an accounting forecast, as soon as it is enabled and with no setup.

Analyse the past, over any period

• Fiscal year, year to date, rolling 12 months, quarter, month or custom dates, compared with the previous year or the previous period.
• Management balances, income statement by account, monthly trends, balance sheet, top customers and suppliers.
• Ratios: profitability, break-even point and date, working capital, working capital requirement, customer and supplier payment terms, financial autonomy, debt, repayment capacity.
• Detailed trading margin: markup and margin rates, cost of goods sold computed from the cost prices on invoices.

Reliable figures, whatever your organisation

• For each month, the most accurate source is used: imported fiscal year, Dolibarr general ledger, or else Dolibarr documents (invoices, salaries, social charges, expense reports, loans).
• Import of previous fiscal years: French FEC file, trial balance, manual entry with balance check, or AI reading of a PDF balance sheet.
• Reference cash of your choice: Bank module, accounting, or your bank statement balance.

Projection over the current fiscal year and the next 3

• Landing forecast for the current year, income statement, management balances, ratios, financing plan, forecast balance sheet and monthly cash-flow plan including VAT.
• Computed automatically from your history: trend, seasonality, fixed and variable costs, measured payment terms, VAT, loan schedules, French corporate tax.
• Optional assumptions: growth, inflation, salaries, investments, loans, dividends, payment terms, revenue shock, purchase costs.

Scenarios and real-life events

• Six built-in scenarios: realistic, pessimistic, optimistic, crisis, rising costs, expansion.
• Create and save your own scenarios, then compare up to 8 side by side: revenue, EBITDA, net result, cash flow, break-even and cash.
• Add dated events, each shown with its effect on revenue and EBITDA over the next 12 months:
  • hiring, with 21 positions, their salary ranges and the estimated employer cost;
  • an employee leaving;
  • a customer lost, with its actual revenue, seasonality and margin;
  • a new contract, a price increase, a supplier price increase, a new expense;
  • an investment financed by a loan, a grant.

Exports and AI assistant

• PDF reports: a complete forecast file and a scenario comparison.
• Multi-sheet Excel workbooks, with details by account and by month.
• One-click monthly budget (planned vs actual) created from the projection.
• Optional Claude AI assistant (Anthropic): management commentary, reading of PDF balance sheets, budget analysis. It uses your own API key, set only in this module, and no third-party names are sent.

Compatibility: Dolibarr 20 to 24, MySQL / MariaDB and PostgreSQL. PHP 8.1 or later for the AI assistant. French and English.

AEGILIS, a SUD-EST IT product range.