Skip to content

Report guide · REP-004 · v1.0

Altair · Budget vs actual with variance commentary

Material variances and causes to confirm.

Compare actual and budget

The Process organizes manual work; it does not run or validate resources.

PaidGlobal standardStandard 2026.10Controls 7/7MonthlyXLSXDOCXPPTX
Meridian Coffee Co. (Demo) · Budget vs actual · October 2026REP-004 · p. 1/2
FICTITIOUS DATA · USD thousands · RS2026.10Prepared with Repporti
Meridian Coffee Co. (Demo) · Budget vs actual · October 2026REP-004 · p. 2/2
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 7/7 · REP-004 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 7/7
01 / 02
REP-004 · Budget vs actual · October 2026 · illustrative example with fictitious data
  • Word (.docx), 5 to 8 A4 pages
  • Excel (.xlsx) with Data, Mapping, Budget, Actual_CC, Calculation, Variances, Control and Charts sheets, with live formulas
  • Optional PowerPoint (.pptx) with 3 to 5 slides

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

What it includes

8 sections, in this order

  1. 01Cover
  2. 02Summary: variance in profit for the period and the 3 largest material variances
  3. 03Month by line item: actual, budget, variance and execution
  4. 04Year to date by line item
  5. 05By cost center, with each center's operating profit
  6. 06Commentary on each material variance: what happened, why, type and what to do
  7. 07Non-material items and follow-up for the next close
  8. 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

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 filesFixed605
  2. 1Role, audience and business context749
  3. 2Parameters734
  4. 3Repporti standard280
  5. 4Data contract1,462
  6. 5Questions first397
  7. 6Validation with a hard stop450
  8. 7Calculation by code332
  9. 7-bisNo-code modeFixed503
  10. 8Formulas870
  11. 9Structure1,621
  12. 10Writing without «AI slop» and without invention945
  13. 11Theme and notation1,039
  14. 12QA, traceability and seal948
The licensed prompt is provided when copied.≈ 33,212 characters + cuadre.py (744 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

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.