Report guide · REP-014 · v1.0
Aldebaran · Bank loan application package
Loan request, repayment capacity and collateral.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
6 sections, in this order
- 01Application letter: amount, tenor, rate, purpose, security and source of repayment
- 02The application on one page: 6 ratios against the bank's references
- 03The company and its track record: annual and interim results, growth and margins
- 04Balance sheet, cash flow and cash flow available for debt service
- 05Sources and uses of funds, repayment capacity and coverage under stress
- 06Existing debt, security, risks and the documents banks usually ask for
Controls 6/6
What it checks before writing a single figure
C1Balanced statements: for every year and cut-off, assets = liabilities + equity + profit for the year.
C2Continuity: closing equity = opening + profit − dividends; change in cash = operating + investing + financing flows; the interim statements match the trial balance at the cut-off.
C3Debt: existing debt adds up to the loans at the cut-off, and the loan's amortisation schedule adds up to the amount and ends at 0.
C4Reasonable projection: annual revenue growth up to 15% and EBITDA margin up to the historical maximum + 3 pp; otherwise the AI asks before going on.
C5Figures table valid for the kit: numeric values, no repeated lines, costs with a single sign and income statement subtotals that add up (cuadre.py validar).
C6Traceable figures: every figure in the Word file exists in calculo.json with the same rounding (cuadre.py verificar).
If the script ran
Repporti controls 6/6 · REP-014 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 filesFixed722
- 1Role, audience and business context739
- 2Parameters737
- 3Repporti standard460
- 4Data contract1,256
- 5Questions first565
- 6Validation with a hard stop1,029
- 7Calculation by code1,163
- 7-bisNo-code modeFixed470
- 8Formulas1,437
- 9Structure1,540
- 10Writing without «AI slop» and without invention979
- 11Theme and notation997
- 12QA, traceability and seal965
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
- Governance and financing
- Frequency
- One-off
- Industry
- All
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
What if I only have 2 closed years?
It works the same with 2 years plus the interim statements; the third is stated under «Limitations». Banks usually ask for 2 or 3: check with your relationship manager.
Does the AI know which documents my bank asks for?
No. The appendix lists the documents banks usually ask for, marked «confirm with the bank». The AI does not state requirements for any bank or country.
What if I have no projection?
The package comes out with historical and 12-month pro forma coverage, without projected coverage, and the gap is stated. If you provide the projection, it is labelled «management's» and also run under stress.
What does it do if a ratio misses what the bank requires?
It shows it on page 2 with its measurable cause and the projected figure. Hiding a weakness is the quickest way to get an application turned down.
What if my AI cannot run code?
It switches to no-code mode: it builds the Excel file with formulas (the schedule with PMT, IPMT and PPMT) and a Control sheet, and the Word footer says «NOT VERIFIED». You can run cuadre.py on your computer and get the seal later.
Governance and financing