include_in_pnl = true (UOB, MayBank, Stripe Clearing, Credit cards, Nigel Settlement Holdings, etc.). Excludes balance-sheet accounts.COALESCE(value_date, txn_date) — work/service period, not pay date. April work paid in May lands in April.| Name | Cashflow | Type | Op / Non-Op | Category | COGS | CapEx | BS |
|---|
| Month | Status | Bank In | Bank Out | Bank Net | Ledger In | Ledger Out | Ledger Net | Diff | Timing Lag | Real Diff | Bank Close | Ledger Close | Bal Diff | Recon |
|---|
| Name | Cadence | Next run | Last run | Lines | Total | Active |
|---|
| # | Time | User | Action | Record type | Record id | Payload |
|---|
Rules auto-match pending bank lines by description pattern. Each rule can create one or more transactions (splits).
| Name | Bank pattern (ILIKE) | Account | Splits | Total | Active |
|---|
| Month | Revenue | Bookings | Rev/Booking | Attended | Attend % | Late Cx | Allotted | Util % | Eff Util % | Rating | Rev MoM | Bk MoM | Receipt |
|---|
txn_date (money movement).
Profit groups by value_date (service period) — e.g. April fees paid in May are recognized in April. Gap between the two = timing differences.
Dotted lines on the chart = same-month last year. Next 3 months are forecast (trailing 3mo avg + locked-in recurring/recognition). Click any month row for item breakdown; click an item name there for a 12mo trend.
| Month | Cash In | Cash Out | Net Cashflow | Revenue | Expense | Net Profit | Timing Gap |
|---|
| Txn Date | Service Date | Item | Description | Amount | Direction |
|---|
| Name | Status | Source | Joined | Last Purchase | Purchases | Membership LTV | Ancillary LTV | Days Since | Actions |
|---|
| Member | Status | Joined | Last Purchase | Purchases | Membership LTV | Ancillary LTV | Days Since |
|---|
| Asset | Acquired | Cost | Accum. Dep | NBV | Status |
|---|
| Class | Revenue | Share | COGS (alloc) | Gross Profit | GM % | OpEx (alloc) | Net Profit | NM % |
|---|
kpi_targets). Pace = % of year elapsed. Status: on track ≥ pace−5pp, at risk ≥ pace−20pp, behind otherwise.
| Metric | Target | YTD Actual | Pace Expected | Variance | % of Target | Status |
|---|
Cash = bank balances. Burn = |trailing 3M avg monthly net|, only if negative.
| Wk | Start | End | In | Out | Net | Cumulative Cash |
|---|
| Mo | Active Members | Monthly Revenue | Cumulative |
|---|
recurring_templates with cash-out items) + variable estimate (trailing 3M actual − recurring). Apply uniform growth %.
| Mo | Recurring | Variable | Total | Cumulative |
|---|
| Year | Projected CF | Discount Factor | Present Value |
|---|
| Entity | Ccy | Revenue | COGS | OpEx | Net Profit | NM % |
|---|