Skip to content

Report guide · REP-014 · v1.0

Aldebaran · Bank loan application package

Loan request, repayment capacity and collateral.

PaidGlobal standardStandard 2026.10Controls 6/6One-offDOCXXLSX
Meridian Coffee Co. (Demo) · Bank loan application package · October 2026REP-014 · p. 1/1
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 6/6 · REP-014 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 6/6
REP-014 · Bank loan application package · October 2026 · illustrative example with fictitious data
  • Word (.docx), 9 to 10 A4 pages: loan application memo, ready to export to PDF
  • Excel (.xlsx) with Statements, Interim, Ratios, Cash flow, Projection, Amortisation, Coverage, Control and Charts sheets, with live formulas

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

What it includes

6 sections, in this order

  1. 01Application letter: amount, tenor, rate, purpose, security and source of repayment
  2. 02The application on one page: 6 ratios against the bank's references
  3. 03The company and its track record: annual and interim results, growth and margins
  4. 04Balance sheet, cash flow and cash flow available for debt service
  5. 05Sources and uses of funds, repayment capacity and coverage under stress
  6. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you paste your filesFixed722
  2. 1Role, audience and business context739
  3. 2Parameters737
  4. 3Repporti standard460
  5. 4Data contract1,256
  6. 5Questions first565
  7. 6Validation with a hard stop1,029
  8. 7Calculation by code1,163
  9. 7-bisNo-code modeFixed470
  10. 8Formulas1,437
  11. 9Structure1,540
  12. 10Writing without «AI slop» and without invention979
  13. 11Theme and notation997
  14. 12QA, traceability and seal965
The licensed prompt is provided when copied.≈ 35,300 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
Governance and financing
Frequency
One-off
Industry
All

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

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.