Skip to content

Dashboard guide · TAB-004 · v1.0

Sales and margin

Sales and margin by line, channel and client.

PaidGlobal standardStandard 2026.10Controls 4/4XLSXPower BI
Meridian Coffee Co. (Demo) · Sales and margin · October 2026TAB-004 · Dashboard · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · TAB-004 v1.0
Meridian Coffee Co. (Demo) · Sales and margin · October 2026TAB-004 · Dashboard · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · TAB-004 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 4/4
01 / 02
TAB-004 · Sales and margin · October 2026 · illustrative example with fictitious data
  • Excel (.xlsx): Dashboard, Data, Calculation with line, channel and customer tables, Control and Notes
  • Power BI: model in CSV (customers, lines, channels, months, sales and results), medidas.dax, tema_powerbi.json and a layout guide
  • PNG (2×, 16:9) of the screen and alt text per block

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

What it includes

6 sections, in this order

  1. 01Action headline with the line or channel that explains the month
  2. 02Cards: revenue, gross profit, gross margin, quantity, customers and concentration
  3. 0312 months of revenue by line with gross margin on a secondary axis
  4. 04Actual against budget by line with variance bars
  5. 05Margin by channel and customer Pareto by gross profit
  6. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you pasteFixed504
  2. 1Role, audience and business context723
  3. 2Parameters479
  4. 3Repporti standard241
  5. 4Data contract1,042
  6. 5Questions first390
  7. 6Validation with a stop843
  8. 7Calculation and build by code802
  9. 7-bisNo-code modeFixed337
  10. 8Formulas and measures762
  11. 9Dashboard structure959
  12. 10Headline, alerts and texts618
  13. 11Theme, notation (IBCS / ISO 24896:2026) and accessibility401
  14. 12QA, traceability and seal515
The licensed prompt is provided when copied.≈ 30,647 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

Finance manager / CFOFounder
Area
Profitability and costs
Frequency
Whenever you need it
Industry
Retail and wholesale, Manufacturing, Distribution

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 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.