Skip to content

Report guide · REP-022 · v1.0

Castor · Expenses by cost center

Costs, variances and owners by center.

PaidGlobal standardStandard 2026.10Controls 5/5MonthlyDOCXXLSXPPTX
Meridian Coffee Co. (Demo) · Expenses by cost center · October 2026REP-022 · p. 1/1
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 5/5 · REP-022 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 5/5
REP-022 · Expenses by cost center · October 2026 · illustrative example with fictitious data
  • Word (.docx), 5 to 6 A4 pages, ready to export to PDF
  • Excel (.xlsx) with Data, Mapping, Calculation, Control, By center and Charts sheets, with live formulas
  • Optional PowerPoint (.pptx) with one slide per material center

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

What it includes

6 sections, in this order

  1. 01In 30 seconds: bottom line, 3 bullets and 4 cards
  2. 02By cost center: actual, budget, prior year and expense-to-revenue ratio
  3. 03By expense type: center × type with the material cells explained
  4. 04What explains the deviation: up to 8 accounts with cause, owner and action
  5. 05People: headcount and personnel cost per person by center
  6. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you paste your filesFixed743
  2. 1Role, audience and business context816
  3. 2Parameters719
  4. 3Repporti standard363
  5. 4Data contract1,285
  6. 5Questions first540
  7. 6Validation with a hard stop1,315
  8. 7Calculation by code891
  9. 7-bisNo-code modeFixed512
  10. 8Formulas1,142
  11. 9Structure1,639
  12. 10Writing without «AI slop» and without invention1,022
  13. 11Theme and notation1,084
  14. 12QA, traceability and seal1,178
The licensed prompt is provided when copied.≈ 35,463 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.

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 / firm
Area
Profitability and costs
Frequency
Monthly
Industry
All

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 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.