Report Builder
The Report Builder is an admin-only tool for configuring the structure of Moroccan statutory financial reports: Bilan (Balance Sheet), CPC (Income Statement), ESG (Management Balance Statements) and the Cash Flow Statement.
Access
Section titled “Access”This tool is visible to administrators only. Access it from the accounting menu or the Reports tab → Builder.
Template List
Section titled “Template List”The home page lists all available report templates with their code, label and type. Click a template to open its editor.
Click New template in the top-right to create a new template.
Report Structure
Section titled “Report Structure”Each report is organized into:
- Sections — Major blocks of the report (e.g., “FIXED ASSETS”)
- Lines — Grouped by line number within a section
- Zones — Columns of a line (e.g., Gross / Amort. / Net for the Balance Sheet)
- Sources — Calculation method + account pattern or formula for each zone
Editor Interface
Section titled “Editor Interface”The editor is split into two panels:
- Left panel: report structure tree (sections and lines with sources summary)
- Right panel: context-sensitive configuration form
Selecting a Section
Section titled “Selecting a Section”Click a section header (colored bar) to open its edit form in the right panel. You can edit:
- Code and Label of the section
- Sign (+1 or -1) — determines whether amounts are shown positive or negative
- Columns — comma-separated list of column labels (e.g.,
N, N-1)
Selecting a Line
Section titled “Selecting a Line”Click a line row to open the zone editor in the right panel. You can:
- Edit the code, label, and official code of each zone
- Reorder zones using the ▲▼ buttons
- Add or delete zones
- Configure sources for each zone
Reordering Lines
Section titled “Reordering Lines”Use the ▲▼ buttons on the right of each line row to change its position within a section.
Calculation Sources
Section titled “Calculation Sources”Each zone can have one or more sources. A source defines how the zone’s value is calculated.
| Method | Description |
|---|---|
balance | Debit total minus credit total (can be negative) |
balance_debit | Debit balance only, zero if credit exceeds debit |
balance_credit | Credit balance only, zero if debit exceeds credit |
debit_moves | Sum of all debit entries |
credit_moves | Sum of all credit entries |
formula | Arithmetic expression using zone codes |
Account Patterns
Section titled “Account Patterns”For non-formula sources, enter an account pattern:
21%— All accounts starting with 21 (wildcard%)2111— Exact account number- Multiple patterns: click Add source to add another pattern as a separate source
Formulas
Section titled “Formulas”For formula sources, use zone codes as variables:
A_BT + A_AM— Sum of two zones from the same reportA_BT - A_AM— Difference between two zonesESG_MA:CAF— Reference a zone from another template (formatTEMPLATE_CODE:ZONE_CODE)T1 + T2 + T3— Sum of multiple zones
Configuration Help
Section titled “Configuration Help”Click the ? button in the line panel header to display the full legend of calculation methods, patterns and formulas.
Completeness Warning
Section titled “Completeness Warning”If a line has fewer zones than the number of columns defined in its section, a red indicator (e.g., 2/3) is shown to signal an incomplete configuration.
Troubleshooting
Section titled “Troubleshooting”- Page not accessible: this editor is restricted to administrators. Log in with an administrator account.
- Missing zone: the red indicator means a line’s zone count does not match the expected column count — add the missing zones.
- Invalid formula: verify that the referenced zone codes exist in the report, or use the
TEMPLATE_CODE:ZONE_CODEformat for cross-report references.
Need help? Contact our technical support.