Skip to content

Report guide · REP-025 · v1.0

Bellatrix · Project profitability for service firms

Project margin and team utilization.

PaidGlobal standardStandard 2026.10Controls 6/6MonthlyXLSXDOCXPPTX
Meridian Coffee Co. (Demo) · Project profitability for service firms · October 2026REP-025 · p. 1/1
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 6/6 · REP-025 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 6/6
REP-025 · Project profitability for service firms · October 2026 · illustrative example with fictitious data
  • Word (.docx), 5 A4 pages, ready to export to PDF
  • Excel (.xlsx) with Data, Hours, Calculation by project, Contracts, Capacity, Control and Charts sheets, with live formulas
  • Optional PowerPoint (.pptx) with one page per project at risk

Instructions for your AI; check sections, output files and controls before copying.

What it includes

5 sections, in this order

  1. 01In 30 seconds: project margin, unit margin, utilization and net contract position
  2. 02Project portfolio: revenue, cost, margin, realization and margin at completion against budget
  3. 03Projects at risk: progress, estimate at completion, change in estimate and expected loss
  4. 04People and capacity: utilization by role, internal hours, unrecorded hours and retainer overruns
  5. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you paste your filesFixed618
  2. 1Role, audience and business context839
  3. 2Parameters614
  4. 3Repporti standard405
  5. 4Data contract1,255
  6. 5Questions first420
  7. 6Validation with a hard stop1,814
  8. 7Calculation by code213
  9. 7-bisNo-code modeFixed455
  10. 8Formulas1,727
  11. 9Structure1,321
  12. 10Writing without «AI slop» and without invention908
  13. 11Theme and notation951
  14. 12QA, traceability and seal1,074
The licensed prompt is provided when copied.≈ 34,808 characters + cuadre.py (1,124 lines)

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.

Revenue recognition by progress and the expected-loss provision follow your profile's framework and your accounting policy; if they use another method, the AI asks before calculating.

See the Repporti Standard

How to use it

From the trial balance to the report in three steps

  1. 01Configure and copyCheck profile and period before copying.
  2. 02Paste into your AIPaste the prompt and attach anonymized files in your AI.
  3. 03Review and deliverCheck controls and seal before sharing.

Anonymize before pasting

  • Company → alias; tax identifier → ID-XX.
  • People → codes. Keep the mapping on your device.
  • Use business AI, API or disable training.

Files and figures go to your AI; Repporti does not receive them.

Made for whoever delivers the report

Who it is for

Finance manager / CFOAccountant / firmAgency
Area
Profitability and costs
Frequency
Monthly
Industry
Services, Agencies, Consulting

Which AI it works with

Compatibility

LevelAI
With code executionChatGPT · ClaudeRequires file analysis and Python execution for cuadre.py.
No-code modeCopilot · GeminiExcel 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.