Dashboard guide · TAB-004 · v1.0
Sales and margin
Sales and margin by line, channel and client.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
6 sections, in this order
- 01Action headline with the line or channel that explains the month
- 02Cards: revenue, gross profit, gross margin, quantity, customers and concentration
- 0312 months of revenue by line with gross margin on a secondary axis
- 04Actual against budget by line with variance bars
- 05Margin by channel and customer Pareto by gross profit
- 06Alerts (3 to 5) and a note with standard or actual cost, sources and seal
Controls 4/4
What it checks before writing a single figure
C1Complete data: recognized headers, numeric figures, no repeated lines, channels or customers and valid units.
C2Gross profit = revenue − cost of sales for the month; the dashboard script reconciles customer sales, 12-month series and budget.
C3Sign convention: costs and expenses with a single sign.
C4Figures in the headline, alerts, notes and alt texts traceable to calculo.json, and a headline in the direction of the key figure.
If the script ran
Repporti controls 4/4 · TAB-004 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 pasteFixed504
- 1Role, audience and business context723
- 2Parameters479
- 3Repporti standard241
- 4Data contract1,042
- 5Questions first390
- 6Validation with a stop843
- 7Calculation and build by code802
- 7-bisNo-code modeFixed337
- 8Formulas and measures762
- 9Dashboard structure959
- 10Headline, alerts and texts618
- 11Theme, notation (IBCS / ISO 24896:2026) and accessibility401
- 12QA, traceability and seal515
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
- Profitability and costs
- Frequency
- Whenever you need it
- Industry
- Retail and wholesale, Manufacturing, Distribution
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 dashboard guide
Does the margin include freight and commissions?
No: it is gross margin (revenue − cost of goods sold). For contribution after cost to serve, use REP-011 Antares.
What if customer sales do not add up to booked revenue?
It stops and shows the difference by line. It is usually a return, a credit note or a sale booked in another month: bring it in and run it again.
Does it work if I sell services, not kilos?
Yes: quantity can be hours, units or contracts. If it is not homogeneous across lines, the dashboard does not compute an average price.
Can I filter by salesperson or region?
Yes, if you bring the column in ventas.csv: it becomes one more dimension in Power BI and one more table in Excel.
Profitability and costs