目标:提高每小时创造的佣金收入。
- 优先开发有明确买卖计划的客户。
- 提高对高价值公寓、投资型房产和换房需求的理解。
- 建立买家与卖家的持续开发渠道。
- 每个月复盘不同类型销售的实际佣金与投入时间。
Gross section weights, and the same sections net of debt
Cash receivables and income projections
High-yield savings by account
Current investment market value
| Investment account | Capital / allocation | Current value |
|---|
Supplementary Retirement Scheme · click a card for details
Housing · real estate investment tracker
Current balances for 2026 · statements through 31 Dec 2025
Bigger commission, less hassle. Rentals only as a side line.
Talk to them, follow up, stay in their mind.
Aim for higher-quality, higher-end clients.
Hit it in the shortest time possible.
目标:提高每小时创造的佣金收入。
目标:让过去的工作持续产生未来的机会。
目标:逐步提高客户质量和单笔交易价值。
Closed deals and the prospect group · double-click any cell to edit
| # | Property | Asset type | Receivable (S$) | Received (S$) | Official (S$) | CLIENT | Contact | Refer by | Status | Exercised Date | Files | Remarks |
|---|
Tenancy commissions · the tenant has 30 days from the lease start to report defects · Renting, Sourcing and Upcoming rows carry no Start or End Date · Defects due is N/A for rooms, commercial and industrial units, Renewing, Renewed and Terminated · Terminated means the tenant has moved out: the row greys out and is no longer tracked · Other side is the tenant on an LL row (direct or represented by an agent) and the landlord's agent on a TT row, with a WhatsApp link where a number is recorded · the book in Defects due opens the bilingual handover note for that tenant, ready to copy or send
| # | Property | Asset type | Days expiry | Start Date | End Date | Defects due 30-day report | Receivable (S$) | Received (S$) | Official (S$) | Client | Contact | Refer by | Status | TA format | Rep | Other side | Remarks |
|---|
Referral fees, MCST reimbursements and ad-hoc sales
| # | Property | Item | Receivable (S$) | Received (S$) | Official (S$) | Client | Remarks |
|---|
Monthly non-taxable Passive Income · cash total is calculated
| # | Month | UOB One (S$) | UOB Stash (S$) | UOB Tax R (S$) | REITs (S$) | Property (S$) | Cash total (S$) | CPF (S$) | Remarks |
|---|
2026 workbook · sales, other, rental and passive income
How much each income stream brings in, and its share of the total · active income counts received plus A.1 / A.2 receivables · pick a year to look back on
Summary block of the workbook · Income, Ratio and Official · Income is what has come in plus, for A.1 and A.2, what is still owed in Receivable · the A.1, A.2, B and C lines are read-only, pulled from their section tables, and the Total line sums the income lines above it and then subtracts the Income Tax line · pick a year to read that year's roll-up
| # | Item | Income | Ratio | Official |
|---|
All recorded years · received commission, not property price · closed sales are Sold, Bought or Completed · Renting, Sourcing and Upcoming tenancies are left out
| Asset class | Closed sales average / case | Rentals average / case |
|---|
Who introduced whom across Sections A.1, A.2 and B · a rounded rectangle is a client and its size is the sales and rental commission that client has brought in · only clients with at least one recorded introduction are drawn
| Section | Description | Amount |
|---|
| Liability | Description | Amount |
|---|
| Section | Description | Gross value | Liability | Liquid value |
|---|
| Month | File | Statement |
|---|
| Statement year | File | Statement |
|---|
| Year | Bank | Amount (SGD) | Limit | % Used | Notes |
|---|---|---|---|---|---|
| Total | S$66,600.00 | S$76,500 | 87.1% | ||
| Asset Class | Market Value | % of Portfolio |
|---|
| Category | Amount (SGD) | Notes |
|---|---|---|
| P/L on Sold Stocks | +S$245.85 | NetLink NBN Trust — sold Apr 2026 at S$1.00/unit |
| Dividends & Interest Income (combined) | +S$5,295.61 | Breakdown not separately recorded |
| Total Realized | +S$5,541.46 |
| Name | Qty | Avg Cost | Mkt Price | Cost Basis | Mkt Value | P/L | ROI% |
|---|
| Metric | Value | Description |
|---|---|---|
| Simple Annual Yield | 4.40% | Total return divided by years held |
| IRR (estimated) | — | Money-weighted, Jan 1 contribution dates |
| XIRR | 7.01% | Most accurate — from DBS statement |
| Code | Name | Type | Units | Cost | Mkt Value | P/L |
|---|
| Ticker | Name | Type | Units | Avg Cost | Mkt Price | Mkt Value | P/L | ROI% |
|---|
| Ticker | Name | Units | Cost | Proceeds | Realized P/L | Status |
|---|---|---|---|---|---|---|
| CJLU.SI | NetLink NBN Trust | 5,000 | S$4,754.15 | S$5,000.00 | +S$245.85 | Sold Apr 2026 |
| Year | Contribution (SGD) | Balance Δ vs prev year | Balance % vs prev year | Year-end balance |
|---|
| Year | Contribution (SGD) | Balance Δ vs prev year | Balance % vs prev year | Year-end balance |
|---|
| Year | Contribution (SGD) | Balance Δ vs prev year | Balance % vs prev year | Medical used | Year-end balance |
|---|
| Year | Housing amount (SGD) | Δ vs prev year | % vs prev year | Note |
|---|
| Ticker | Name | Market Price (SGD) |
|---|
| Year | Bank | Amount (SGD) | Limit (SGD) | Notes |
|---|
| Date | Total Value | Cash Balance |
|---|
| Ticker | Name | Type | Units | Avg Cost | Mkt Price |
|---|
| Year | OA bal | SA bal | MA bal | OA in | SA in | MA in | Housing | Medical used |
|---|
| Property | Owner | Owner contact | Managed by | Relationship | Managed contact | Drive folder |
|---|