Property management commission tracking software Kenya agencies use should make every fee explainable from the signed management agreement to the owner statement. The finance team should be able to show which income was eligible, which rule applied, what exceptions changed the result, who approved the charge and how the fee affected the owner’s closing balance.
This is more demanding than multiplying rent by a percentage. One owner may pay a fee on cash collected, another on amounts billed and another a fixed monthly charge. Some agreements exclude deposits, utilities or service charges. A rate can change on renewal. A reversal received after month-end can require a documented correction. When those differences live in separate spreadsheets, even an accurate formula can produce the wrong contractual result.
This is a substantial replacement for the existing PMS.co.ke canonical guide at this same URL. It retains the established search intent while expanding the workflow around agreement versions, client-money separation, exceptions, approvals, payout control and implementation. Agencies should obtain qualified accounting, tax and legal advice; software cannot interpret an agreement or determine statutory treatment on its own.
The five questions every monthly commission report must answer
- Which management agreement and version governed the property during the period?
- Was the fee based on collected income, billed income, a fixed amount or another documented basis?
- Which transactions entered or were excluded from that basis?
- Which reversals, waivers, corrections, taxes or minimums changed the draft fee?
- Who reviewed and approved the amount before it reached the owner statement?
A dashboard total cannot answer those questions. The report needs drill-down to the agreement, receipts, invoices, adjustments and approval record.
Why commission errors happen in property agencies
Commission calculation usually fails at the boundaries. Staff use an expired rate because an amendment was not communicated. A deposit is included in the income base. A tenant part-payment is treated as full collection. A reversed M-Pesa transaction remains eligible. A fee waiver agreed with the owner is handled by deleting the charge, so no one can explain the difference later.
Spreadsheet versioning creates another risk. The accountant prepares one schedule, the client manager changes a rule and the director approves a different attachment. The owner statement may use a fourth copy. The agency cannot prove which schedule was final or whether a later edit occurred.
At portfolio scale, the problem grows. Review the multiple-owner property-management workflow to see why owner, agreement, property and transaction separation must remain consistent across shared teams.
Create a governed management-agreement register
Commission setup should begin with an authorised register, not with a remembered percentage. Each record needs the signed agreement or amendment, effective dates, owner, properties, fee basis, rate or fixed amount, minimum, inclusions, exclusions, tax treatment, approval route and statement presentation.
| Agreement field | Risk it controls | Test case |
|---|---|---|
| Effective dates and version | Old rates continuing after an amendment | Rate changes halfway through a reporting period |
| Fee basis | Billed income being confused with cash collected | Invoice unpaid at month-end |
| Included charge types | Deposits or unrelated recoveries entering the base | Rent and utility paid in one transaction |
| Rate, fixed fee and minimum | One formula being copied to every owner | Collection below the monthly minimum |
| Waiver and exception authority | Unexplained manual reductions | Approved temporary discount |
| Tax and invoice treatment | Inconsistent statutory handling | Fee invoice and effective tax rule |
| Statement label and schedule | Owner unable to reproduce the charge | Supporting collection schedule |
Only an authorised role should activate a rule. A draft agreement under negotiation must not drive live calculations. When the contract changes, the system should preserve the old version and apply the new rule only from its reviewed effective date.
Choose the correct fee basis
Commission on cash collected
The eligible base is formed from allocated receipts under the agreement. The system must decide how to handle part-payments, payments covering several charge types, late allocations and reversals. Receipt date and allocation date should both remain visible.
Commission on amounts billed
The eligible base comes from approved invoices rather than payment. Credits, cancelled invoices, concessions and retrospective corrections require controlled treatment. The owner should understand that the fee basis may differ from cash received.
Fixed, minimum and hybrid fees
A fixed fee may vary by property, unit band, service package or period. A minimum can apply when a percentage result falls below a threshold. Hybrid arrangements need explicit calculation steps and effective dates. Buyers should test all combinations currently used by the agency.
The platform should calculate only models it supports reliably. Where a special arrangement remains outside the configured model, use a documented exception workflow rather than forcing it into an unrelated rule.
Connect commission to receipt allocation
For collection-based agreements, commission accuracy begins before the fee calculation. A receipt first needs to be imported, matched to the correct tenant and allocated to the correct invoice and charge type. Only eligible allocations should enter the fee base.
An unmatched payment belongs in suspense, not in an arbitrary owner’s total. A duplicate should be blocked or flagged. A reversal should retain its connection to the original receipt. A cross-owner correction should require reason and approval. The rent roll and aged-receivables guide provides the wider month-end context.
Keep client money and agency income distinct
Rent received on behalf of an owner is not automatically earned agency revenue. The approved commission is the agency charge produced under the management agreement and accounting policy. The system should show the movement transparently rather than mixing the owner balance and agency income in one unexplained account.
Kenya’s Estate Agents (Accounts) Rules address clients’ money and accounting records. Obtain professional advice on applicability and required controls. In software evaluation, ask how owner ledgers, collection accounts, agency fees and payouts remain separately traceable.
The dedicated client money accounting software guide should become the main internal reference once published. It treats the commission as one approved movement within a wider owner-accounting chain.
Handle exceptions without hiding them
Every exception needs a type, amount, reason, supporting evidence, preparer and approver. Examples include:
- Part-payment requiring an allocation decision
- Receipt reversal after a prior fee was approved
- Refund or credit affecting the fee base
- Deposit or utility recovery excluded by the agreement
- Approved temporary fee waiver
- Minimum fee applied after a low-collection month
- Rate changing during the period
- Late identification of a previously unmatched receipt
- Owner dispute awaiting resolution
A waived fee should show the calculated amount, approved waiver and final charge. A reversed transaction should link to the original. A correction after close should identify the prior period it affects. Deleting the original evidence may make the report look clean, but it weakens accountability.
Use maker-checker approval
The preparer checks agreement versions, eligible transactions and exception evidence. The reviewer investigates unusual movements, compares the total with prior months and verifies material adjustments. An authorised approver releases the fee to the owner statement. Role design should match the agency’s size and risk policy.
The system should prevent a user from preparing and approving the same material adjustment where segregation is required. Delegation during leave needs an effective period and audit event. Administrator access should not become a routine way to bypass finance approvals.
Make the owner statement reproduce the fee
The owner statement should include the reporting period, fee description, eligible basis, rate or fixed rule, charge, approved adjustments and closing balance. A supporting schedule can list the receipts or invoices included. Labels should match the agreement; vague descriptions such as “admin deduction” invite questions.
The statement total should reconcile through opening balance, collections, expenses, commissions, other approved movements, payout and closing balance. If a prior fee is corrected, state the affected period and reason rather than silently changing history.
Commission forecasting and agency performance
Once rules and collection data are reliable, management can forecast earned fees by portfolio, owner, branch and account manager. Compare expected commission with approved commission and investigate gaps caused by arrears, vacancies, concessions, expired agreements or data issues.
Do not use the report only to rank staff. It can reveal portfolios requiring operational support, contracts that no longer reflect service effort and owners whose fee disputes repeat. Management should interpret numbers alongside service quality and contract obligations.
Month-end commission checklist
- Confirm all collection channels are imported and reconciled.
- Resolve or formally age unmatched and reversed transactions.
- Lock the eligible receipt or invoice population for the cut-off.
- Validate current agreement versions and effective dates.
- Calculate draft fees and minimums.
- Review exclusions, waivers, refunds and cross-period corrections.
- Perform preparer and independent reviewer checks.
- Approve commissions and post them to owner ledgers.
- Generate owner statements and proposed payout schedules.
- Lock the period while retaining an auditable correction process.
A dashboard should show completion and unresolved exceptions by portfolio. Directors need to know which statements remain unapproved before payouts begin.
Use analytical review before approving the batch
Approval should include a reasonableness test, not only a check that the formula ran. Compare commission with the prior period, collections, occupied units and the approved forecast. Flag a material increase, unexpected zero fee, repeated manual waiver, negative correction or result outside the agreement’s normal range. The reviewer then records whether the movement came from genuine collections, a rate change, a new property, a reversal or a data problem. Analytical review will not prove every transaction is correct, but it can direct attention to the entries most likely to require evidence before owner statements and payout schedules are released.
Retain a compact approval pack for each run: agreement version, eligible transaction schedule, exception register, calculation summary, reviewer notes, approval timestamp and owner-statement reference. The pack should be generated from the governed records rather than assembled manually after a dispute. When a later correction is necessary, link the new adjustment to the original run and keep both decisions visible. This gives client managers a consistent explanation and helps auditors sample a fee from summary to source without searching several personal folders.
Set practical service levels for the exception queue as well. A disputed receipt, unsigned amendment or missing approval should have a named owner, target date and escalation route. The agency can then release unaffected portfolios while holding only the fee calculations that lack evidence. This is safer than delaying every owner statement or, at the other extreme, approving incomplete calculations simply to meet a calendar deadline.
Migrating existing commission schedules
Inventory every active management agreement and amendment. Group arrangements by fee model. Reconcile current owner balances and identify which historical fees remain disputed. Do not import spreadsheet formulas as if they were approved contract terms.
Create test cases for each model: normal full payment, part-payment, reversal, excluded charge, minimum fee, rate change, waiver and late allocation. Run at least one month in parallel and compare fee, owner statement and payout totals. Finance and client-management leaders should sign off before the system becomes authoritative.
Questions for a PMS.co.ke demonstration
- Can the platform support collected, billed, fixed, minimum and hybrid fee models?
- Can rules be versioned by agreement effective date?
- How are eligible charge types and exclusions configured?
- What happens to commission when a receipt is reversed?
- Can a fee waiver show calculation, approval and final charge?
- Does the owner statement reveal the fee basis?
- Can preparer and approver roles be separated?
- How are closed-period corrections recorded?
- Can commission reports be filtered by owner, property, branch and manager?
- What migration, configuration and month-end support is available?
Review the current PMS features and ask for an end-to-end scenario from tenant receipt to owner payout. Published pricing should be considered together with implementation, integration, training and support requirements.
Frequently asked questions about property management commission tracking software Kenya
What is property management commission tracking software?
It organises management agreements, eligible income, fee rules, exceptions, approvals and owner reporting so an agency can explain how each commission was produced.
Should commission be calculated on rent billed or rent collected?
That depends on the reviewed management agreement and applicable professional advice. The system should apply the documented basis for each owner rather than assume one model.
Can different owners use different commission rates?
That is an important capability to test. Rates, fixed fees, minimums, exclusions and effective dates should remain attached to the correct agreement and portfolio.
How should a reversed M-Pesa payment affect commission?
The reversal should remain linked to the original receipt and follow the agency’s approved correction policy. The resulting fee adjustment must be visible and reviewed.
Can PMS calculate VAT or other taxes on management fees?
Buyers should verify current software capabilities and obtain tax advice. Tax rules should be configurable by effective date and supported by the required invoicing records.
Can owners see the commission calculation?
The owner statement and supporting schedule should provide enough information to understand the basis, rate, adjustments and final charge without exposing unrelated clients’ data.
Does commission software replace contract review?
No. Qualified professionals must interpret the agreement. Software stores the approved interpretation and applies it consistently to operational records.
Should the existing commission article get a new URL?
No. This content is designed to replace and strengthen the established canonical at property-management-commission-tracking-software-kenya, preserving its URL history and avoiding duplication.
