Report · REP-012 · v1.0
Spica · Payroll and people costs
How much your people cost this month, in which areas and items, and whether it changed because of more people, a higher average pay or the variable part.
Turns the month's payroll by employee into a 6-page report: total cost with salaries, overtime, commissions, bonuses and benefits and employer contributions by area; headcount, FTE, hires, leavers and turnover; cost per FTE and people cost as a share of revenue, against budget and prior year.
Before calculating, your AI reconciles each payroll item with its account in the trial balance and the headcount with the monthly summary; if something does not tie out, it stops and asks. Each variance is split into a headcount effect, an average pay effect and a commissions effect, with the identity on the Control sheet.
Employees only appear as codes and no pay figure is shown for groups of fewer than 5 people. It does not recalculate statutory withholdings or contributions, does not recommend layoffs and does not invent causes: anything management did not explain stays as «[cause to be confirmed]». Terms and format come from the Repporti Standard for your country, framework and language.
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
NOT VERIFIED — controls not executed by code. Review the Control sheet of the XLSX.
Prompt outline
What the prompt contains, block by block
- 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
Repporti Standard
It comes out adapted to your report profile
Compatible with every country and framework in the Standard: when you copy, it is composed with your profile (country, accounting framework, report language, currency, unit and year-end). Terminology, number format and statement names come from the Standard, not from the prompt.
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 name → an alias (“Client 07”); tax ID → “ID-XX”.
- Customers, suppliers and employees → codes (C001, P001, E001). The mapping table stays on your computer.
- Use an AI that does not train on your data: business plan, API or training turned off.
Who it is for
Made for whoever delivers the report
- Area
- People
- Frequency
- Monthly
- Industry
- All
Compatibility
Which AI it works with
| Level | AI | |
|---|---|---|
| With code execution | ChatGPT · Claude | Designed for plans with data analysis (ChatGPT) or code execution (Claude): cuadre.py runs inside the AI. |
| No-code mode | Copilot · Gemini | Generates the Excel file with formulas and a Control sheet. The footer says “NOT VERIFIED” unless you run cuadre.py on your computer. |
Questions
About this report
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