Report · REP-021 · v1.0
Pollux · Inventory and turnover
How much inventory you hold, how many days of cost it covers, what has not moved for months and how much cash it ties up, reconciled to the trial balance.
Turns the inventory valued by item and the month's trial balance into a 5-page report: inventory by category and by line, days inventory outstanding and inventory turnover against prior year and your target, items with no movement by age band and the cash tied up above the target.
Before calculating, the AI checks with code that every item adds up (quantity × cost), that there are no duplicate codes or negative balances, and that inventory matches the trial balance accounts. If something does not reconcile, it stops, shows the difference and asks. Causes come only from your notes; anything else stays as «[cause to be confirmed]».
It never calls anything «obsolete» or a «loss»: items above your threshold stay as «impairment to be assessed» by the accountant under your framework. Delivers a Word file and an Excel workbook with live formulas and a Control sheet, using the terms, statements and number format of the Repporti Standard in your profile, and the script checks every figure before printing the seal.
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
NOT VERIFIED — controls not executed by code. Review the Control sheet of the XLSX.
Prompt outline
What the prompt contains, block by block
- 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
Repporti Standard
It comes out adapted to your report profile
Compatible with every country and framework in the Standard: when you copy, it is composed with your profile (country, accounting framework, report language, currency, unit and year-end). Terminology, number format and statement names come from the Standard, not from the prompt.
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 name → an alias (“Client 07”); tax ID → “ID-XX”.
- Customers, suppliers and employees → codes (C001, P001, E001). The mapping table stays on your computer.
- Use an AI that does not train on your data: business plan, API or training turned off.
Who it is for
Made for whoever delivers the report
- Area
- Treasury and cash
- Frequency
- Monthly
- Industry
- Retail and wholesale, Manufacturing, Agriculture
Compatibility
Which AI it works with
| Level | AI | |
|---|---|---|
| With code execution | ChatGPT · Claude | Designed for plans with data analysis (ChatGPT) or code execution (Claude): cuadre.py runs inside the AI. |
| No-code mode | Copilot · Gemini | Generates the Excel file with formulas and a Control sheet. The footer says “NOT VERIFIED” unless you run cuadre.py on your computer. |
Questions
About this report
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