Skip to content

Chart · GRF-006 · v1.0

Receivables aging chart

Overdues by bucket and client, reconciled to balance.

PaidGlobal standardStandard 2026.10Controls 4/4XLSXDOCXPPTX
Meridian Coffee Co. (Demo) · Receivables aging · as of 10/31/2026GRF-006 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · GRF-006 v1.0
Meridian Coffee Co. (Demo) · Receivables aging · as of 10/31/2026GRF-006 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · GRF-006 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 4/4
01 / 02
GRF-006 · Receivables aging · as of 10/31/2026 · illustrative example with fictitious data
  • Excel (.xlsx) with a native chart, the customer × bucket matrix in formulas and a Control sheet
  • PNG (2×, 16:9) and SVG for Word or PowerPoint
  • Alt text (alt.txt) ready to paste

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

What it includes

5 sections, in this order

  1. 01Action title with the critical % and the customers behind it
  2. 02Horizontal stacked bars per customer, largest balance first, with «Other» last
  3. 03Total per bucket with amount and %, % past due and % over 90 days
  4. 04Sequential scale from gray to dark red, with legend and amounts
  5. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you pasteFixed366
  2. 1Role, audience and business context485
  3. 2Parameters365
  4. 3Repporti standard220
  5. 4Data contract: aging.csv or .xlsx867
  6. 5Questions first190
  7. 6Validation with a stop492
  8. 7Calculation and drawing by code458
  9. 7-bisNo-code modeFixed260
  10. 8Numeric rules217
  11. 9Chart structure438
  12. 10Title and texts303
  13. 11Notation and accessibility340
  14. 12QA, traceability and seal464
The licensed prompt is provided when copied.≈ 27,295 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

Accountant / firmFinance manager / CFO
Area
Treasury and cash
Frequency
Whenever you need it
Industry
Retail and wholesale, Manufacturing, Services

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