Kaya Palazzo Auditor working paper FY Ended 30 June

Master multi-year commission audit reconciliation

Continuous balance sheet and profit & loss schedule across statutory financial years ended 30 June (FY 2023 – FY 2027 YTD). Generated on 2026-10-14 04:54:02.

Executive audit briefing on statutory financial year ended 30 June

This master schedule reconciles Kaya Palazzo's affiliate commission program with standard accrual accounting principles (MFRS/IFRS) based on the statutory financial year ending 30 June. Because salesmen operate with a cumulative digital wallet balance, they do not withdraw funds at the exact moment sales are made. The tables below decouple the Income Statement Expense (recognized in the fiscal year sales occur) from the Balance Sheet Liability Settlement (cash disbursements when salesmen withdraw). This provides a complete mathematical audit trail explaining why bank payouts in any fiscal year frequently settle commissions earned in prior financial periods.

Cumulative ledger overview (Inception to 14 Oct 2026)

Cumulative commissions earned

RM 4,034,159.33

21,030 confirmed sales (P&L expense)

Cumulative withdrawals paid

RM 3,959,626.60

9,205 bank payouts (cash outflow)

Current outstanding liability

RM 74,532.73

Unwithdrawn balance as of 14 Oct 2026

Prior-period commissions settled

RM 193,794.40

631 cross-period payout events

1. Continuous multi-year roll-forward schedule (Ended 30 June)

Annual continuous reconciliation connecting balance sheet liabilities and income statement expenses.

Financial year Opening liability (01 Jul) Commissions earned (P&L expense) Withdrawals paid (cash outflow) Closing liability (30 Jun) Year-end audit pack
FY 2023 (Pre-launch) RM 0.00 + RM 0.00
(0 txns)
- RM 100.00
(1 payouts)
RM -100.00 View FY 2023 report
FY 2024 RM -100.00 + RM 1,248,972.38
(4,950 txns)
- RM 1,156,627.13
(2,237 payouts)
RM 92,245.25 View FY 2024 report
FY 2025 RM 92,245.25 + RM 1,260,807.24
(6,705 txns)
- RM 1,234,891.66
(2,943 payouts)
RM 118,160.83 View FY 2025 report
FY 2026 RM 118,160.83 + RM 1,209,376.19
(7,162 txns)
- RM 1,245,987.35
(3,124 payouts)
RM 81,549.67 View FY 2026 report
FY 2027 YTD RM 81,549.67 + RM 315,003.52
(2,213 txns)
- RM 322,020.46
(900 payouts)
RM 74,532.73 View FY 2027 report
Cumulative totals - RM 4,034,159.33 RM 3,959,626.60 RM 74,532.73 Fully balanced
Mathematical proof: Cumulative commissions incurred since inception (RM 4034159.33) minus cumulative withdrawals paid (RM 3959626.60) exactly equals the current outstanding liability of RM 74,532.73. There is zero ledger leakage.

2. Cross-period payout summary (Settling prior FY commissions)

Quantifies the exact prior financial period commission amounts settled by cash disbursements in each subsequent financial year.

Disbursement financial year Commission origin Prior-period commission settled Affected withdrawals 30 June boundary straddles Detailed schedule
FY 2023 (Pre-launch) Earned prior to 30 June 2022 RM 0.00 0 payouts RM 0.00 (0) View breakdown
FY 2024 Earned prior to 30 June 2023 RM 0.00 0 payouts RM 0.00 (0) View breakdown
FY 2025 Earned prior to 30 June 2024 RM 76,904.04 217 payouts RM 1,439.67 (4) View breakdown
FY 2026 Earned prior to 30 June 2025 RM 86,370.03 274 payouts RM 9,054.33 (8) View breakdown
FY 2027 YTD Earned prior to 30 June 2026 RM 30,520.33 140 payouts RM 208.65 (3) View breakdown

3. Recommended accounting entries for external audit (FY Ended 30 June)

Standard journal adjustments to align financial statements with MFRS/IFRS accrual standards.

1. P&L commission expense

Book the Commissions Earned figure from Schedule 1 as the true statutory annual commission expense for the financial year (01 July – 30 June).

Debit: Commission Expense (P&L)
Credit: Accrued Commission Payable (B/S)

2. Cash payout settlement

Book all bank withdrawal disbursements as settlements against the liability account, regardless of whether the underlying sales occurred before or after 30 June.

Debit: Accrued Commission Payable (B/S)
Credit: Bank / Cash (B/S)

3. Year-end balance sheet

Verify that the ending balance in Accrued Commission Payable as of 30 June equals the Closing Liability in Schedule 1.

Fully supported by the itemized salesman sub-ledger files (audit_salesman_balances_*.csv).