Report guide · REP-022 · v1.0
Castor · Expenses by cost center
Costs, variances and owners by center.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
6 sections, in this order
- 01In 30 seconds: bottom line, 3 bullets and 4 cards
- 02By cost center: actual, budget, prior year and expense-to-revenue ratio
- 03By expense type: center × type with the material cells explained
- 04What explains the deviation: up to 8 accounts with cause, owner and action
- 05People: headcount and personnel cost per person by center
- 06Appendix: reconciliation to the trial balance, expense-type mapping, controls and glossary
Controls 5/5
What it checks before writing a single figure
C1Reconciliation: expenses by center and account add up to the month's movement of each expense account in the trial balance.
C2Clean data: no repeated rows or blank centers, and every expense has a budget or is flagged «no budget».
C3Complete figures table: numeric values, no repeated lines, valid units and one sign for expenses (checked by cuadre.py).
C4Double calculation: every figure computed with code matches the live Excel formula (Control sheet = 0).
C5Traceable figures: every figure in the Word file exists in calculo.json and the title moves in the same direction as the operating expense variance.
If the script ran
Repporti controls 5/5 · REP-022 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 filesFixed743
- 1Role, audience and business context816
- 2Parameters719
- 3Repporti standard363
- 4Data contract1,285
- 5Questions first540
- 6Validation with a hard stop1,315
- 7Calculation by code891
- 7-bisNo-code modeFixed512
- 8Formulas1,142
- 9Structure1,639
- 10Writing without «AI slop» and without invention1,022
- 11Theme and notation1,084
- 12QA, traceability and seal1,178
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
- All
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 allocate administrative expenses to the business centers?
Not by default. Support centers are shown separately and compared with total revenue. If you provide an allocation basis, the AI adds a «with allocation (assumption)» table that never replaces the unallocated view.
What if my expenses by center do not add up to the trial balance?
The AI stops, shows the difference by account and the suspicious rows (a repeated row, another month, depreciation included) and asks. It never adjusts anything on its own.
Do I need a budget by center and account?
It is not mandatory. Without a budget, the report compares against prior year; if the budget comes by expense type instead of by account, it compares at that level and says so.
Does it show individual salaries?
No. It works with totals by center and expense type, names owners by job title and computes personnel cost per person as an approximation using month-end headcount.
Can I send each owner only their own part?
Yes: the Excel workbook includes a filterable «By center» sheet and, if you ask for it, one slide per center with its action title.
Profitability and costs