Excel PRO Business Dashboard: Sales, Expenses, and Cash Receipts | French Template

RCHWeb — Excel Template in French

Find your main indicators in a monthly view: revenue excluding VAT, expenses, receipts including VAT, receivables and variances from targets.

FOR WHOM?
Managers of very small businesses, freelancers and administrative managers.

MAIN FUNCTIONS
- Monitoring of sales and invoiced pre-tax revenue.
- Expenses recorded excluding VAT and disbursements including VAT known.
- VAT receipts and customer receivables at the end of the period.
- Monthly targets and budget variances.
- Selection of the year and months of the period.
- Annual comparison of turnover with N-1.
- A4 summary with native indicators and graphs.
- Explicit distinction between invoicing, financial flows and management balance.

ABILITY
500 lines for each of the Sales, Expenses and Receipts tables.

WHAT YOU RECEIVE
A ZIP archive containing the blank template, a demonstration workbook with entirely fictitious data, the common PDF user guide for the suite, and a getting started guide.
Digital product: no physical item is shipped. Excel software and its license are not included.


FORMAT AND USE
XLSX files in French, amounts in EUR. Designed for Microsoft Excel 365 desktop.
No VBA macros, no Python installation, no API key, and no internet connection required by the workbooks.
This digital and visual recipe was created using LibreOffice 26.8.1.1. No testing within Microsoft Excel itself is claimed. Compatibility with Excel web, Excel mobile, Google Sheets, or other software is not guaranteed.
The input cells are identified; calculations are protected against accidental changes without a password. This protection does not constitute access security.


THINGS TO KNOW BEFORE BUYING
The net operating balance is not an accounting result. The known net cash flow is not a bank balance. Version 1 links the cumulative payment for an expense to a single date; it does not allocate payments spread across multiple periods. Disbursements remain partial if payment information is incomplete. Import the history necessary for calculating receivables without double counting.

GETTING STARTED
Extract the ZIP file, read the guide, watch the demonstration, and then work on a copy of the blank template. Check the warnings before using the results.

DESIGN
Model developed with the assistance of artificial intelligence tools, then subjected to digital and visual checks.

USER LICENSE
Purchase authorizes the use and modification of the templates for the internal needs of a single company or the independent purchaser. Resale, redistribution, public availability, or integration into a product for sale is prohibited, even after modification. Microsoft Excel software and its license are not included.