TreasuryPro

Group Treasury Operations · Confidential

TreasuryPro
Liquidity Report
1 · Upload Files
2 · Map Columns
3 · Build Report
4 · Send & Export
Cash Position
Not uploaded
💰
Daily Cash Position Excel
.xlsx / .xls — drag & drop or click
Debt Book
Not uploaded
📒
Debt Breakdown Excel
.xlsx / .xls — drag & drop or click

Tip: upload either file alone to generate a single-section report.

📤 Upload Bank Statement

File will be sent to the ingestion agent for approval via Telegram.

Fill in fields above…
live

Cashflow Overview

Weekly cash-flow intelligence · source workbook parser · ready

No workbook loaded
⬡  Multi-Entity Cash Flow Intelligence
Load workbooks for up to 3 entities  ·  Individual or consolidated board reports  ·  Drag & drop supported per slot
Sheets: Inflows-Outflow · Rates · Cashflow
.xlsx  ·  .xls  ·  .xlsm
Entity 01
○ Not loaded
Drop file here or click Upload
Entity 02
○ Not loaded
Drop file here or click Upload
Entity 03
○ Not loaded
Drop file here or click Upload

📑 PROFESSIONAL CASH FLOW REPORT

Landscape board pack · actuals vs forecast bifurcation (split on generation date) · multi-currency conversion engine · render-check before generation.

Override below if needed:
Source currency (workbook):
Dates strictly before this date are treated as ACTUALS. Dates on/after are FORECAST. Defaults to today.
④ Currency Conversion Engine
Enter rates as "1 reporting ccy = X foreign ccy". The engine divides source values by the rate to convert into reporting currency.
💡 If source currency = reporting currency, leave the engine empty — no conversion applied. If they differ, you must provide a rate for the source currency, otherwise the render check will block report generation.
Run render check before generating.
Opening Balance
Load workbook
Closing Balance
Load workbook
Total Inflows
Cashflow sheet WTD
Total Outflows
Signed as source
Net Movement
Inflows + outflows
Forecast Horizon
Detected weeks/days

Executive Interpretation

Awaiting workbook
Upload the weekly cash-flow file to generate treasury commentary, liquidity drivers, and risk alerts.

Cash Flow Analytics

Daily movement, balance trajectory, category and bank mix

Weekly Cash Movement

Inflows · Outflows · Net

Active Liquidity Trajectory

Daily closing balance

Category Contribution

Summary categories with names and amounts

Upload workbook to view category contribution names.

Bank Movement Mix

Raw Inflows-Outflow sheet

Cash Bridge & Decision Intelligence

Opening cash to closing cash, top drivers and management actions

Cash Bridge Waterfall

Opening → category drivers → closing

Upload workbook to build the cash bridge.

Management Actions

Auto-prioritised from liquidity drivers

Upload workbook to generate action intelligence.

Category Driver Analysis

Ranked impact with contribution share

Upload workbook to view ranked drivers.

Liquidity Risk Monitor

Thresholds from settings panel

Upload workbook to assess liquidity runway and material movements.

Weekly Forecast Blocks

Detected directly from Cashflow sheet

Raw Transaction Detail

Inflows-Outflow sheet

Daily Summary Register

Cashflow sheet daily rows

FX Reference Rates

Rates sheet

Board Report Design

McKinsey-style PDF
  • Dashboard theme follows the dark console reference: black panels, monospace telemetry, orange highlight, compact KPI cards and analytics-first layout.
  • PDF export follows the attached executive-pack structure: black confidential header, numbered section bars, KPI tiles, visual pages, tables and methodology appendix.
  • Parser is calibrated to a standard weekly cash-flow workbook layout and preserves the exact source sign convention.
  • Single-file HTML: no server required for upload, analysis, CSV export or PDF generation.