Skip to content

Report guide · REP-008 · v1.0

Orion · 13-week cash flow

Receipts, payments and cash-risk weeks.

Review 13-week cash

The Process organizes manual work; it does not run or validate resources.

PaidGlobal standardStandard 2026.10Controls 5/5WeeklyXLSXDOCX
Meridian Coffee Co. (Demo) · 13-week cash flow · Nov 2026 – Jan 2027REP-008 · p. 1/2
FICTITIOUS DATA · USD thousands · RS2026.10Prepared with Repporti
Meridian Coffee Co. (Demo) · 13-week cash flow · Nov 2026 – Jan 2027REP-008 · p. 2/2
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 5/5 · REP-008 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 5/5
01 / 02
REP-008 · 13-week cash flow · Nov 2026 – Jan 2027 · illustrative example with fictitious data
  • Word (.docx), 3 to 4 pages, with the 13-week table on a landscape page
  • Excel (.xlsx) with Bank, Items, AR, AP, Flow13, Actual_vs_Forecast, Control and Chart sheets, with live formulas

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

What it includes

5 sections, in this order

  1. 01Summary: lowest-balance week, headroom, weeks at risk and net flow
  2. 02Chart of the 13 weekly closing balances against the minimum balance
  3. 0313-week table by cash-flow line
  4. 04Risks and decisions: quantified levers with an owner and a date
  5. 05Assumptions and bank reconciliation of the opening balance

Controls 5/5

What it checks before writing a single figure

  • C1Reconciled opening balance: bank + reconciling items = book cash (N/A if you do not attach the trial balance).

  • C2Complete data with no double counting: valid categories and signs, dates within the horizon, third parties as codes and no collection or payment repeated with receivables or payables.

  • C3Weekly continuity: opening + inflows − outflows = closing, and each closing balance is the next week's opening.

  • C4Cross totals: the sum by line, the sum by week and the change in balance match; collections do not exceed receivables and payments do not exceed payables.

  • C5Traceable figures: every figure in the Word file exists in calculo.json with the same rounding.

If the script ran

Repporti controls 5/5 · REP-008 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 filesFixed627
  2. 1Role, audience and business context772
  3. 2Parameters671
  4. 3Repporti standard271
  5. 4Data contract1,761
  6. 5Questions first645
  7. 6Validation with a hard stop502
  8. 7Calculation by code380
  9. 7-bisNo-code modeFixed555
  10. 8Formulas and rules894
  11. 9Structure1,257
  12. 10Writing without «AI slop» and without invention826
  13. 11Theme and notation949
  14. 12QA, traceability and seal946
The licensed prompt is provided when copied.≈ 33,144 characters + cuadre.py (808 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
Weekly
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 goes in partidas.csv?

Everything that moves cash and is not in receivables or payables: payroll, social charges, employee benefits, taxes, rent, debt, capex, cash sales and expected new sales, with date, amount and recurrence.

How is each customer's payment timing estimated?

Due date plus a lag in days. If you don't give one, the script uses the weighted average days late of your overdue receivables and states it as an assumption.

How do I update it every week?

Run it again with the new bank balances, receivables and payables. The previous week 1 moves to the Actual_vs_Forecast sheet to measure the difference.

Does it work in any country?

Yes. You set up your reporting profile once (country, framework, report language, currency, unit and year-end) and the prompt comes out with the Repporti Standard for that profile: terms, statements, number format and country pitfalls. The report core is the same everywhere.