Dashboard

Lending Finance Workspace  •  Dashboard
to

Daily balance trend (MYR)

Closing bank balance per day, carried forward on days without transactions

Recognized cash activity

Opening balance → money in → money out → ending balance · cash basis

Company balances

Selected date range · MYR

Daily balance breakdown (MYR)

Balance per entity per day · days without transactions carry the previous day's balance

Cash flow forecast (MYR)

Run-rate projection

Projected balance = latest closing balance + average daily net cash (In − Out, excluding opening balances) of the chosen window × number of days. A straight-line estimate from bank activity only — it does not know about scheduled payments or expected collections.

P&L statement (MYR)

Cash basis

Sub category comparison

Money out · current vs previous month

Largest outflows

Selected month

Cash flow statement (MYR)

Opening balance → cash in → cash out → closing balance

Monthly money in vs money out

All months in the data · respects the company filter

InOut

Company month-on-month

Net cash = In − Out (excluding opening balance)

Variance comparison analysis (MYR)

Balance of each entity at two points in time · Variance = Period A − Period B

vs
vs

Rows with a green dot take the balance from the bank statements automatically. All other rows are typed in: click a cell, enter an amount or a formula (e.g. =120000+30000) and press Enter — subtotals, totals and the variance update at once; press Save to keep them. Day mode stores figures per date, Month mode per month.

PG balance · daily check

10AM / 4PM gateway balances and settlements (top up)

Changes are saved automatically about a second after you type. Balance 10am / 4pm also take formulas like Excel, e.g. =120000+30000 or 250000-45000+1200.50 — calculated when you leave the cell. Type in the white (balance) and yellow (settlement / top up) cells — Enter jumps to the same column on the next row. Green columns are calculated: Balance after Settlement = Balance − Settlement; Total = Settlement 10am + Settlement 4pm. Wepay Balance 10am / 4pm are filled automatically at 10:00 and 16:00 from the Telegram balance bot (pg_wepay_sync.py).

HQ Bank

Head-office bank accounts · balances and statements

Reserved for HQ bank statementsThis section will hold the head-office bank accounts (e.g. BIMB - HBT, MBB - OTW, RHB - OTW). Tell us the accounts and the columns you need, and it will be set up in the same style as PG Balance.

OP Bank

Operating bank accounts · balances and statements

Reserved for operating bank statementsThis section will hold the operating bank accounts. Tell us the accounts and the columns you need, and it will be set up in the same style as PG Balance.

Inter-company exposure

Paid by (statement company, rows) on behalf of project owner (columns) · MYR · Out minus In

Contra transactions

Payments whose project belongs to another company · click a row to run an allocation trial

Rule checks

Every record in the selected period is scanned by the rules below. Click a rule to filter the cards.

Correction log

Decisions are stored in this browser only (audit trail). Nothing changes the bank data automatically.