Report guide · REP-021 · v1.0
Pollux · Inventory and turnover
Stock, inventory days and tied-up cash.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01In 30 seconds: bottom line, 3 bullets and 4 cards
- 02Where the inventory sits: categories, days by category and by line against the target
- 03Inventory that is not moving: age bands and slow items with cause and action
- 04Cash tied up above the target and decisions with owner and date
- 05Appendix: reconciliation to the trial balance, controls, assumptions and glossary
Controls 5/5
What it checks before writing a single figure
C1Clean items: value = quantity × unit cost, no repeated codes, no negatives and no dates after the cut-off.
C2Reconciliation: inventory by category and in total matches the inventory accounts in the trial balance.
C3Complete figures table: numeric values, no repeated lines, valid units and one sign for costs (checked by cuadre.py).
C4Double calculation: every figure computed with code matches the live Excel formula (Control sheet = 0).
C5Traceable figures: every figure in the Word file exists in calculo.json and the title moves in the same direction as days inventory outstanding.
If the script ran
Repporti controls 5/5 · REP-021 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 paste your filesFixed630
- 1Role, audience and business context824
- 2Parameters815
- 3Repporti standard414
- 4Data contract1,285
- 5Questions first423
- 6Validation with a hard stop1,045
- 7Calculation by code950
- 7-bisNo-code modeFixed498
- 8Formulas1,423
- 9Structure1,517
- 10Writing without «AI slop» and without invention1,144
- 11Theme and notation1,087
- 12QA, traceability and seal1,167
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
- Monthly
- Industry
- Retail and wholesale, Manufacturing, Agriculture
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 report guide
Does it work without a perpetual inventory system?
Yes, within limits: if cost of sales is not booked every month, days inventory outstanding are not reliable. The report says so under «Limitations» and focuses on inventory that is not moving and on the reconciliation to the trial balance.
Does it calculate impairment or net realisable value?
No. It flags items with no movement above your threshold and leaves them as «impairment to be assessed» so the accountant decides under your framework.
What if inventory does not match the trial balance?
The AI stops, shows the difference by category and the suspicious rows (an extra zero, a repeated code) and asks. It never adjusts anything on its own.
Can I use my own thresholds and days target?
Yes: dias_lento, dias_obsoleto and the days inventory target go in parametros.csv or in the opening questions. Without a target, the excess is not calculated and the report says so.
Does it work with thousands of items?
Yes. The code aggregates by category, line and age band; the Word file only lists the items above the slow-moving threshold, sorted by value.
Treasury and cash