Report · REP-004 · v1.0
Altair · Budget vs actual with variance commentary
The month's budget execution by line item and cost center, with double materiality and a comment on what happened, why and what to do, with no invented causes.
Compares actual against the approved budget for the month and year to date, by line item and cost center, with variance, variance % and execution. Only deviations above double materiality (percentage and amount) get a comment; the rest is summarized as a net effect on profit.
Every comment follows the same form: what happened, with figures; why (citing the number of management's note or «[cause to be confirmed]»); the type of deviation only if someone confirmed it; and what to do, with an owner and a date. An expense that goes up is never shown in green, however «high» its execution.
The script checks that the budget has no duplicate rows or unknown line items and that actuals by cost center add up to the trial balance. Delivers a 5 to 8-page Word file and an Excel workbook with Budget, Actual_CC, Variances and Control sheets.
What it includes
8 sections, in this order
- 01Cover
- 02Summary: variance in profit for the period and the 3 largest material variances
- 03Month by line item: actual, budget, variance and execution
- 04Year to date by line item
- 05By cost center, with each center's operating profit
- 06Commentary on each material variance: what happened, why, type and what to do
- 07Non-material items and follow-up for the next close
- 08Appendix: controls, assumptions, limitations and glossary
Controls 7/7
What it checks before writing a single figure
C1The trial balance balances: debits = credits, balances net to 0 and there are no duplicate accounts.
C2Continuity by account: opening balance + debits − credits = closing balance.
C3Signs by line item: assets carry debit balances and liabilities credit balances; otherwise, reclassify.
C4Hierarchy and mapping: subtotals equal the sum of their detail accounts and 100% of detail accounts are mapped (by the reference chart or by the «rubro» column).
C5Consistent budget: valid line items and months, no duplicate rows and rows for the report period.
C6Actuals by cost center add up to the trial balance for each line item (N/A if you do not attach the cost-center file).
C7Traceable figures: every figure in the Word file (and the PowerPoint) exists in calculo.json with the same rounding.
If the script ran
Repporti controls 7/7 · REP-004 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 filesFixed605
- 1Role, audience and business context749
- 2Parameters734
- 3Repporti standard280
- 4Data contract1,462
- 5Questions first397
- 6Validation with a hard stop450
- 7Calculation by code332
- 7-bisNo-code modeFixed503
- 8Formulas870
- 9Structure1,621
- 10Writing without «AI slop» and without invention945
- 11Theme and notation1,039
- 12QA, traceability and seal948
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
- Profitability and costs
- 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
What format should the budget have?
One row per line item and month (YYYY-MM) with its amount in your currency and, if you have it, the cost center. Line items can be given by code (ING, GADM…) or by name.
What if I don't have actuals by cost center?
The analysis stays by line item, control 6 shows «N/A» and the cost-center section says «N/A». Nothing is allocated on assumptions.
Who decides whether a deviation is timing or permanent?
You or management. The AI only classifies it if notas.txt or your answer says so; otherwise it stays «[type to be confirmed]».
What if my chart of accounts is not the reference one?
Add a «rubro» column to the trial balance with the ID of each detail account (ING, CV, GADM, GVEN, CLI, PROV…): it overrides the account code. The AI proposes it from the account names and asks you to confirm before calculating.
Profitability and costs