Skip to content

Report guide · REP-012 · v1.0

Spica · Payroll and people costs

Costs by area, headcount and average pay.

PaidGlobal standardStandard 2026.10Controls 6/6MonthlyXLSXDOCXPPTX
Meridian Coffee Co. (Demo) · Payroll and people costs · October 2026REP-012 · p. 1/1
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 6/6 · REP-012 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 6/6
REP-012 · Payroll and people costs · October 2026 · illustrative example with fictitious data
  • Word (.docx), 6 A4 pages, ready to export to PDF
  • Excel (.xlsx) with Payroll, Mapping, Summary, Bridge, Headcount, Series, Control and Charts sheets, with live formulas
  • Optional PowerPoint (.pptx) with 1 to 3 slides

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

What it includes

6 sections, in this order

  1. 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)
  2. 02Cost by area and item, with the reconciliation to the accounts
  3. 03Why it changed: headcount, average pay and commissions bridge by area
  4. 04Headcount and movements: hires, leavers, contracts, part time, turnover and a 13-month trend
  5. 05Average pay by area and level (groups of 5 or more), overtime and variable pay
  6. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you paste your filesFixed663
  2. 1Role, audience and business context701
  3. 2Parameters872
  4. 3Repporti standard438
  5. 4Data contract1,253
  6. 5Questions first511
  7. 6Validation with a hard stop1,184
  8. 7Calculation by code1,115
  9. 7-bisNo-code modeFixed495
  10. 8Formulas1,395
  11. 9Structure1,456
  12. 10Writing without «AI slop» and without invention1,038
  13. 11Theme and notation1,045
  14. 12QA, traceability and seal984
The licensed prompt is provided when copied.≈ 35,222 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

Accountant / firmFinance manager / CFO
Area
People
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 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.