Chart · GRF-006 · v1.0
Receivables aging chart
Overdues by bucket and client, reconciled to balance.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01Action title with the critical % and the customers behind it
- 02Horizontal stacked bars per customer, largest balance first, with «Other» last
- 03Total per bucket with amount and %, % past due and % over 90 days
- 04Sequential scale from gray to dark red, with legend and amounts
- 05Note with credit balances and the balance-sheet reconciliation, source and seal
Controls 4/4
What it checks before writing a single figure
C1Complete data: recognized headers, numeric figures, no repeated customers or buckets.
C2Income statement subtotals tie if the table includes them (N/A for an aging).
C3Sign convention: costs and expenses with a single sign.
C4Figures in the title, subtitle, note and alt text traceable to calculo.json, and a title consistent with the key figure.
If the script ran
Repporti controls 4/4 · GRF-006 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 pasteFixed366
- 1Role, audience and business context485
- 2Parameters365
- 3Repporti standard220
- 4Data contract: aging.csv or .xlsx867
- 5Questions first190
- 6Validation with a stop492
- 7Calculation and drawing by code458
- 7-bisNo-code modeFixed260
- 8Numeric rules217
- 9Chart structure438
- 10Title and texts303
- 11Notation and accessibility340
- 12QA, traceability and seal464
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
- Treasury and cash
- Frequency
- Whenever you need it
- Industry
- Retail and wholesale, Manufacturing, Services
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 chart
Can I paste the aging by invoice?
Yes. The AI groups by customer, computes days past due from the cut-off date and shows you the summary before drawing.
What if my buckets are different (0–15, 16–45…)?
The file's buckets are kept, in their order, with the same color scale from least to most overdue.
What happens to credit notes or unapplied advances?
They stay in their bucket so totals tie, but they are not drawn inside the bars: the note says how much they add up to.
What if my AI cannot run code?
It delivers the matrix with formulas and the steps to build the chart in Excel, and the footer says «NOT VERIFIED».
Treasury and cash