Skip to content

Report guide · REP-021 · v1.0

Pollux · Inventory and turnover

Stock, inventory days and tied-up cash.

PaidGlobal standardStandard 2026.10Controls 5/5MonthlyDOCXXLSXPPTX
Meridian Coffee Co. (Demo) · Inventory and turnover · October 2026REP-021 · p. 1/1
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 5/5 · REP-021 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 5/5
REP-021 · Inventory and turnover · October 2026 · illustrative example with fictitious data
  • Word (.docx), 4 to 5 A4 pages, ready to export to PDF
  • Excel (.xlsx) with Data, Mapping, Calculation, Control and Charts sheets, with live formulas
  • Optional PowerPoint (.pptx) with 1 or 2 slides

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

What it includes

5 sections, in this order

  1. 01In 30 seconds: bottom line, 3 bullets and 4 cards
  2. 02Where the inventory sits: categories, days by category and by line against the target
  3. 03Inventory that is not moving: age bands and slow items with cause and action
  4. 04Cash tied up above the target and decisions with owner and date
  5. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you paste your filesFixed630
  2. 1Role, audience and business context824
  3. 2Parameters815
  4. 3Repporti standard414
  5. 4Data contract1,285
  6. 5Questions first423
  7. 6Validation with a hard stop1,045
  8. 7Calculation by code950
  9. 7-bisNo-code modeFixed498
  10. 8Formulas1,423
  11. 9Structure1,517
  12. 10Writing without «AI slop» and without invention1,144
  13. 11Theme and notation1,087
  14. 12QA, traceability and seal1,167
The licensed prompt is provided when copied.≈ 35,451 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 / CFOAccountant / firm
Area
Treasury and cash
Frequency
Monthly
Industry
Retail and wholesale, Manufacturing, Agriculture

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