---
title: "Usage"
weight: 30
description: "User guide for the dashboard and the advanced analytics page."
source_hash: "9ee4b048"
---

# Usage

## Dashboard

The dashboard is accessible from the **Lightpilot > Dashboard** menu. It presents a summary of your commercial and financial activity.

### Selecting the period

A selector at the top of the page lets you filter the data by period:

- **Current month** - From the first to the last day of the month
- **Current quarter** - From the first day of the quarter to the last
- **Current year** - From January 1st to December 31st
- **Fiscal year** - Current, N-1 or N-2, depending on the fiscal year dates configured in Dolibarr

Changing the period is immediate: select a value in the list and the page reloads automatically.

#### What the period drives

The period applies to the indicators and evolution charts: invoiced revenue, proposals pipeline, orders in progress, transformation and conversion rates, commercial funnel, top customers, top products and services, sales by category, as well as the revenue, net margin and cash flow evolution curves. Each chart displays the range of months represented next to its title, for example `Jan. 2025 - Dec. 2025`.

Two rules complete this behavior:

- When the selected period is in progress, the window stops at the current month. Choosing the current year in June therefore displays the months from January to June, with no empty months on the right.
- A very short period is extended to a minimum of three months, otherwise an evolution chart would have nothing left to show. Selecting the current month therefore displays the last three months.

The projection over the next 3 months is only displayed if the selected period ends on the current month: projecting the future after a closed fiscal year would make no sense.

#### What stays at today's date

Some blocks describe a situation at the present moment and deliberately do not follow the selector. Their title carries the mention `(as of today)`:

- Customer receivables and aged balance
- Proposals to follow up, late invoices, orders to process
- Current bank balance

Filtering unpaid items or follow-ups over a past fiscal year would make no sense: these are actions to take today.

### Excl. tax / incl. tax convention

The labels displayed in the dashboard are systematically suffixed with `(excl. tax)` or `(incl. tax)` to remove any ambiguity. The rule:

- **Commercial indicators** -- revenue, proposals pipeline, orders in progress, top customers, top products, margins, evolution graphs -- are **excl. tax**. This is the economic value (the actual revenue for the company, taxes excluded).
- **Collection indicators** -- customer receivables, aged balance, late invoices -- are **incl. tax**. This is what the customer actually owes, taxes included.
- **Cash flow evolution** is **incl. tax** because it reflects real bank movements.

**Credit notes** (type 2) are systematically deducted from revenue: if you issue a 1,000 EUR excl. tax credit note, the displayed revenue drops by that amount. This is consistent with the Dolibarr invoice list.

### Key indicators (KPIs)

Seven indicators are spread over six cards at the top of the dashboard: realized revenue and projected revenue open the line, then the proposals pipeline and orders in progress share the same card, in two columns separated by a line.

![KPI cards of the Lightpilot dashboard](screenshots/kpi-cards.webp)

The **Projected annual revenue** card is the only one that does not follow the period selector: it always covers the **current fiscal year**, the one defined by the fiscal year start month configured in Dolibarr (Home > Setup > Company). The label recalls the fiscal year concerned, and the tooltip details the four calculation sources as well as the start and end dates of the fiscal year.

| Indicator | Meaning |
|-----------|---------|
| Invoiced revenue | Total excl. tax amount of validated invoices for the selected period. Displays the variation compared to the **same window of the previous year** (for example: from January 1st to today vs from January 1st to the same day last year). The tooltip additionally indicates the N-1 revenue over the **full** period to avoid comparing 3 months with 12 months. |
| Projected annual revenue | Revenue expected over the current fiscal year: revenue already invoiced, plus the proposals pipeline weighted by the historical transformation rate, open orders (at 95%) and recurring invoices left to generate. The percentage indicates the share already realized. |
| Proposals pipeline | Total excl. tax amount of proposals awaiting signature (validated status). Indicates the number of proposals concerned. |
| Orders in progress | Total excl. tax amount of validated orders not yet delivered or invoiced. |
| Customer receivables | Total excl. tax amount still to be collected on unpaid invoices. |
| Transformation rate | Percentage of signed proposals among closed proposals (signed + refused). The color varies according to the [configured thresholds](/lightpilot/configuration). |
| Conversion rate | Percentage of proposals converted into an order or an invoice among all proposals of the period. |

### Charts

#### Revenue evolution

This line chart displays, month by month over the range of the selected period (recalled next to the title), several series:

- **Invoiced** - Excl. tax amount of invoices validated in the month.
- **Collected** - Amount of payments received in the month.
- **Invoiced N-1** and **Collected N-1** - Same series shifted by one year (in light dashes) for comparison. The shift follows the displayed window: on fiscal year N-1, the comparison therefore covers N-2.
- **Projection** - 3 additional months on the right with signed proposals pipelines, open proposals (weighted by the transformation rate), open orders (weighted at 95%) and recurring invoices to generate. These series only appear on a period in progress.
- **Break-even threshold** - If you have defined at least one threshold in the [configuration page](/lightpilot/configuration#seuils-de-rentabilité), a red step line appears and indicates the excl. tax monthly threshold applicable to each month. This line is extended over the 3 projection months with the last known value.

The **Proj. recurring invoices** series is calculated from the Dolibarr recurring invoice templates (menu **Invoicing > Recurring invoices**). Each active template is rolled out from its next generation date, following its periodicity (monthly, quarterly, annual...), until the end of the projection horizon. It is the most reliable source of the projection, since it is revenue already contracted.

Three rules frame this calculation:

- **Suspended** templates and those that have reached their **maximum number of generations** are excluded. A template limited to a number of generations stops at the right month instead of running indefinitely.
- If the generation scheduled task is late, already overdue dates are **not** carried over to the coming months: the projection stays conservative and does not artificially inflate the first month.
- The series only appears on the chart if at least one template feeds the projected months.

![Monthly evolution chart of invoiced and collected revenue](screenshots/graphique-chiffre-affaires.webp)

#### Commercial funnel

This chart represents the progression of opportunities through the stages of the sales cycle: proposals, orders, invoices. It displays the number of documents at each stage.

#### Cash flow evolution

This chart only appears if the **Bank** module is enabled. It displays, month by month over the range of the selected period, inflows, outflows and the bank balance. The current balance of each bank account is displayed next to the chart: unlike the curve, this balance is always today's, hence the `(as of today)` mention.

![Cash flow evolution chart with inflows, outflows and balance](screenshots/graphique-tresorerie.webp)

#### Monthly net margin (management)

This stacked bar chart displays, over the range of the selected period, the monthly breakdown of the result as it emerges from the **management data entered in Dolibarr**:

- **Revenue** (blue bar, positive) - Total excl. tax of customer invoices validated in the month.
- **Supplier purchases** (red bar, negative) - Total excl. tax of supplier invoices (`llx_facture_fourn`) on the same invoice date.
- **Social charges** (orange bar, negative) - Total of the charges recorded in the Social charges module (`llx_chargesociales`), classified by due date.
- **Salaries** (purple bar, negative) - Total of the salaries recorded in the Salaries module (`llx_salary`), classified by end of pay period.
- **Net margin** (green line) - Revenue - purchases - charges - salaries. Going below zero indicates a loss-making month.

![Monthly net margin chart, management view](screenshots/graphique-marge-nette.webp)

An alert banner appears if a category is empty over the period (or if its module is not enabled): the displayed net margin is probably overestimated because costs are missing.

#### Monthly net margin (accountancy)

This chart only appears if the Dolibarr **Accountancy** module is enabled. It has the same structure as the previous one (stacked bars + net margin line), but the amounts are read directly from the **validated accounting entries** (`llx_accounting_bookkeeping`) rather than from management entries.

The breakdown by category relies on the **account number prefixes** configured in the [configuration page](/lightpilot/configuration#marge-nette-comptable----préfixes-de-comptes). The default values follow the French PCG:

- Revenue: accounts starting with `70`
- Purchases: accounts starting with `60`, `61`, `62`
- Social charges: accounts starting with `63`, `645`
- Salaries: accounts starting with `641`, `644`

For revenue accounts (class 7), the module computes `credit - debit`. For expense accounts (class 6), it computes `debit - credit`. The result stays positive when the activity is profitable.

An alert banner signals discrepancies: no entry for the period (accounting allocation not yet done), or an empty category with a reminder of the prefixes used -- useful for spotting a bad setting.

The gap between the two graphs (management vs accountancy) is in itself information: it reveals the delay between daily entry and validated accounting allocation. When you work with an external accountant, the accountancy graph is the official picture of the result; the management graph is more reactive but may contain discrepancies (entries not yet allocated, social charges managed outside Dolibarr, etc.).

### Data tables

The dashboard contains several detailed information tables.

#### Aged balance

Distribution of customer receivables by age: not yet due, 1-30 days, 31-60 days, 61-90 days, more than 90 days. The oldest brackets are highlighted when they contain amounts.

#### Top customers

Ranking of the best customers by invoiced amount over the period, with the percentage of total revenue. A click on the customer name opens their Dolibarr card.

#### Proposals to follow up

List of open proposals whose age exceeds the configured threshold. Each line displays the proposal reference, the customer, the amount and the age. A link at the bottom of the table gives access to the full list of open proposals in Dolibarr.

#### Late invoices

List of unpaid invoices whose due date has passed. Each line displays the reference, the customer, the remaining amount due and the number of days late. A link at the bottom of the table gives access to all late invoices.

#### Orders to process

List of validated orders awaiting processing. A link at the bottom of the table leads to the full list of open orders.

#### Top products and top services

Ranking of the best-selling products and services over the period, with the quantity sold and the excl. tax amount.

#### Sales by category

Distribution of sales by product category and by service category, with the number of products and the total amount.

### Rearranging the page

The dashboard boxes (indicators, charts, tables) can be moved and widened at will, to fit the page to the size of the screen. The page is divided into 12 columns: each box takes up a number of them, and the boxes follow one another from left to right.

1. **Long press** (about half a second) on a box, or click the **Rearrange** button next to the period selector. The page switches to edit mode: the columns appear in the background and each box shows its width (for example `4/12`).
2. **Drag** a box to move it: a dotted placeholder shows where it will land.
3. **Pull the right edge** of a box to widen or narrow it, one column at a time. Each box keeps a minimum width to stay readable.
4. Click **Done**, press Escape or click outside the boxes to leave edit mode.

The layout is saved on every change, **in the browser of the computer you use**: your laptop and your desktop computer each keep their own layout. It is specific to each user. The **Reset layout** button of edit mode restores the original layout, as does clearing the browser's browsing data.

With the keyboard, in edit mode: the arrow keys move the box that has the focus, Shift + left or right arrow narrows or widens it.

On a narrow screen (phone, reduced window), the boxes stack across the full width and edit mode is not available.

The advanced analytics page is rearranged the same way, with its own layout.

## Advanced analytics

The advanced analytics page is accessible from the **Lightpilot > Advanced Analytics** menu. It offers detailed analyses and comparison tools.

### Filters

Two filters are available at the top of the page:

- **Period** - Same selector as the dashboard (month, quarter, year, fiscal year)
- **Comparison** - No comparison, comparison with the previous year or with the previous period

Click **Apply** after changing the filters.

![Filters of the advanced analytics page with the period selector and the comparison mode](screenshots/analyses-filtres.webp)

### Revenue forecasts

This table summarizes the revenue forecasts over the **current fiscal year** (recalled next to the title), combining:

- The revenue already invoiced since the start of the fiscal year
- The proposals pipeline weighted by the historical transformation rate
- The orders pipeline weighted at 95%
- The **recurring invoices** left to generate until the end of the fiscal year
- The projected total

The projected total of this table is the one displayed by the **Projected annual revenue** KPI card of the dashboard. The recurring invoices line only appears if active templates will still produce invoices before the end of the fiscal year. It follows the same rules as the dashboard projection: suspended and exhausted templates excluded, overdue dates not carried over. No double counting is possible with the revenue already invoiced, since only future generations are counted.

### Period comparison

When a comparison mode is selected, a table displays side by side the indicators of the two periods: number and amount of proposals, orders and invoices, with the variation in percentage.

### Seasonality

A table displays the revenue month by month over the last three years, which makes it possible to identify seasonal trends.

### DSO (Days Sales Outstanding)

Evolution over 12 months of the average customer payment time, expressed in number of days. The lower the DSO, the faster your customers pay you.

### Average order value

Evolution over 12 months of the average amount of proposals, orders and invoices.

### Statistics by sales rep

Summary table by sales rep: number and amount of proposals, orders and invoices. This makes it possible to evaluate the performance of each member of the sales team.

### Sales by product category

Distribution of sales by product category with the number of products sold, the quantity and the total excl. tax amount.

### Geographic distribution

Two tables display the distribution of customers and revenue by region and by department.

### Inactive customers and attrition

This section identifies customers without recent activity (proposal, order or invoice) based on the [configured inactivity threshold](/lightpilot/configuration).

Each inactive customer is accompanied by:

- Their inactivity age in months
- Their last activity date
- Their total past revenue
- A GDPR indicator (OK, warning or limit exceeded)

A summary displays the global indicators: number of active, inactive, new and lost customers, as well as the attrition, retention and growth rates.

### Management PDF report

The **Export PDF** button at the top of the page produces a management report, ready to share with a partner, a banker or your accountant. It uses the period and the comparison mode chosen in the page filters.

![PDF export button on the advanced analytics page](screenshots/export-pdf.webp)

Before the download, a window lets you choose the sections to include. All of them are ticked by default, and each one starts on a new page.

![Choice of the PDF report sections before the export](screenshots/export-pdf-sections.webp)

| Section | Content |
|---------|---------|
| Summary | Up to eight indicators with their variation over the comparison period, the current key findings, and the monthly revenue evolution against the break-even threshold |
| Revenue and profitability | Monthly net margin, month-by-month figures table, projection of the fiscal year and its breakdown |
| Sales activity | Funnel of proposals, orders and invoices with the transformation and conversion rates, top customers and their share of revenue, results by sales rep and by category, proposals to follow up |
| Cash and collection | Evolution of the bank balance and movements, aged balance, average payment delay, late invoices |
| Customer portfolio | Active, new and lost customers, inactive customers to follow up with their GDPR status, three-year seasonality |
| Definitions | How each indicator of the report is computed |

![Summary page of the PDF report: indicators, key findings, monthly revenue](screenshots/rapport-pdf-synthese.webp)

#### Key findings

The summary opens with at most six findings, written from your figures and sorted from the most urgent to the most reassuring: invoices more than 60 days overdue, proposals to follow up, months below the break-even threshold, transformation rate below the alert threshold of the setup, weight of the top customers in revenue, evolution of the payment delay, revenue growth. Each finding carries a colour mark and a symbol: `!` for what calls for action, `+` for good news, `i` for information.

#### Comparisons

- With no comparison chosen in the filters, the indicators are shown without variation.
- A running period is cut at today's date before being compared: January 1st to today is compared with January 1st to the same day of last year, never with a full year.
- "Previous period" compares a quarter with the quarter before, a month with the month before.
- The net margin is computed, and compared, only when costs (supplier invoices, social charges, salaries) are entered for at least half of the months of each period. Otherwise the "margin" would be the same as the revenue.

![Revenue and profitability page of the PDF report](screenshots/rapport-pdf-chiffre-affaires.webp)

![Sales activity page of the PDF report](screenshots/rapport-pdf-commercial.webp)

#### Who can export the report

The report holds company-wide figures: cash, margin, other customers. It is reserved for internal users; an external user, linked to a third party, does not see the button.
