Report guide · REP-012 · v1.0
Spica · Payroll and people costs
Costs by area, headcount and average pay.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
6 sections, in this order
- 01In 30 seconds: the month's cost against budget and prior year, and 5 cards (cost, headcount, FTE, cost per FTE, people cost to revenue)
- 02Cost by area and item, with the reconciliation to the accounts
- 03Why it changed: headcount, average pay and commissions bridge by area
- 04Headcount and movements: hires, leavers, contracts, part time, turnover and a 13-month trend
- 05Average pay by area and level (groups of 5 or more), overtime and variable pay
- 06Risks and decisions with impact, owner and date; appendix with controls and glossary
Controls 6/6
What it checks before writing a single figure
C1Complete payroll: every row with a code (not a name), no repeated employees, cost centre present, total cost = sum of items and valid days paid.
C2Reconciled to the accounts: by accounting area and item, payroll adds up to the month's movement on its account (N/A without a trial balance).
C3Consistent headcount: opening + hires − leavers = closing by area, and the last month of the summary matches the payroll.
C4Jumps in cost per FTE explained, and on the Control sheet: headcount effect + average pay effect + commissions effect = each area's variance.
C5Figures table valid for the kit: numeric values, no repeated lines, valid units and costs with a single sign (cuadre.py validar).
C6Traceable figures: every figure in the Word file (and the PowerPoint) exists in calculo.json with the same rounding (cuadre.py verificar).
If the script ran
Repporti controls 6/6 · REP-012 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 filesFixed663
- 1Role, audience and business context701
- 2Parameters872
- 3Repporti standard438
- 4Data contract1,253
- 5Questions first511
- 6Validation with a hard stop1,184
- 7Calculation by code1,115
- 7-bisNo-code modeFixed495
- 8Formulas1,395
- 9Structure1,456
- 10Writing without «AI slop» and without invention1,038
- 11Theme and notation1,045
- 12QA, traceability and seal984
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
- People
- 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 calculate my country's statutory withholdings and contributions?
No. Your payroll software does that. The report takes what you already processed, reconciles it with the accounts and analyses it. Contributions are labelled with the Standard's names for your country, without recalculating rates.
What if my payroll has more items (allowances, insurance, severance)?
The AI proposes which of the 5 groups each item belongs to (salaries, overtime, commissions, bonuses and benefits, employer contributions), shows you and waits for your confirmation before calculating.
How does it protect employee privacy?
You provide the payroll with codes, without names or ID numbers; if the AI sees a name, it flags it without repeating it. No individual pay appears in the report and groups of fewer than 5 people are merged with the adjacent level.
What about staff whose cost goes to production or projects?
The AI asks which accounts hold each area's payroll. If part of it is capitalised in inventory or projects, the reconciliation is done against those accounts or stated under «Limitations».
What if my AI cannot run code?
It switches to no-code mode: it builds the Excel file with formulas by area and item and a Control sheet, and the Word footer says «NOT VERIFIED». You can run cuadre.py on your computer and get the seal later.
People