Report guide · REP-025 · v1.0
Bellatrix · Project profitability for service firms
Project margin and team utilization.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01In 30 seconds: project margin, unit margin, utilization and net contract position
- 02Project portfolio: revenue, cost, margin, realization and margin at completion against budget
- 03Projects at risk: progress, estimate at completion, change in estimate and expected loss
- 04People and capacity: utilization by role, internal hours, unrecorded hours and retainer overruns
- 05Decisions (change orders, reassignments, rates and losses), assumptions, controls and glossary
Controls 6/6
What it checks before writing a single figure
C1Complete data: headers, numeric figures, no duplicate lines and valid units (cuadre.py).
C2Pre-check stop: nobody records more hours than available, all hours go to an existing project and every fixed-price contract has its cost to complete.
C3Hours and capacity reconcile: project + internal + unrecorded hours = available hours, in hours and in cost (Control sheet = 0).
C4Fixed-price contracts: cumulative revenue = progress × contract value and estimate at completion = cumulative cost + cost to complete (Control sheet = 0).
C5Billing and margin: cumulative billing = prior + month, and total margin = revenue − direct costs − provisions (Control sheet = 0).
C6Traceable figures: every figure in the Word file exists in calculo.json with the same rounding (cuadre.py verificar).
If the script ran
Repporti controls 6/6 · REP-025 v1.0 · RS2026.10 · {fecha} · fingerprint {hash}
If it did not run
UNVERIFIED: code not run. Review Control in Excel.
What the prompt contains, block by block
Prompt outline
- 0Before you paste your filesFixed618
- 1Role, audience and business context839
- 2Parameters614
- 3Repporti standard405
- 4Data contract1,255
- 5Questions first420
- 6Validation with a hard stop1,814
- 7Calculation by code213
- 7-bisNo-code modeFixed455
- 8Formulas1,727
- 9Structure1,321
- 10Writing without «AI slop» and without invention908
- 11Theme and notation951
- 12QA, traceability and seal1,074
Core available in: Spanish · English
It comes out adapted to your report profile
Repporti Standard
Your profile sets country, framework, language, currency, scale and year-end.
See the Repporti StandardHow to use it
From the trial balance to the report in three steps
- 01Configure and copy
- 02Paste into your AI
- 03Review and deliver
Anonymize before pasting
- Company → alias; tax identifier → ID-XX.
- People → codes. Keep the mapping on your device.
- Use business AI, API or disable training.
Made for whoever delivers the report
Who it is for
- Area
- Profitability and costs
- Frequency
- Monthly
- Industry
- Services, Agencies, Consulting
Which AI it works with
Compatibility
| Level | AI | |
|---|---|---|
| With code execution | ChatGPT · Claude | Requires file analysis and Python execution for cuadre.py. |
| No-code mode | Copilot · Gemini | Excel with Control sheet; UNVERIFIED until cuadre.py runs. |
Questions
About this report guide
Does it work if I don't track hours by project?
Not fully: without hours there is no cost by project. If you only have hours by person and week, the AI asks you to split them by project and states it as an assumption; the report flags that margin as estimated.
How is revenue recognized on a fixed-price contract?
By default, over time by progress measured as cost incurred over total estimated cost. If your accounting policy or framework uses another method (milestones, hours), the AI asks before calculating.
Why does a project show a negative margin for the month if the contract still makes money?
Because the project manager raised the estimated cost to complete, and the catch-up on everything recognized so far is booked in the month. The report separates that effect from the month's work.
Do individual salaries show up?
No. Cost goes by role (loaded hourly cost) and people only by code. Low utilization is presented as available capacity, not as performance.
Profitability and costs