Service charge reconciliation software Kenya property managers need should connect an approved operating budget to tenant or owner contributions, actual building costs, allocation rules and a clearly explained year-end adjustment. The goal is not to generate another invoice. It is to prove how the shared cost pool was assembled, why each party received its share and what changed between the amount collected and the cost incurred.
Service charges become contentious when the calculation is invisible. Occupiers see a total but cannot understand the budget categories, allocation basis, exclusions or supporting invoices. Owners receive inconsistent reports from different buildings. Finance staff rebuild schedules in spreadsheets, while property teams explain variances from memory. A controlled reconciliation replaces those fragmented explanations with one reviewable record.
This article provides an operational evaluation framework. Lease, title, management agreement, tax and accounting treatment can differ by property and arrangement. Obtain advice from qualified professionals and ask PMS.co.ke to demonstrate support for your actual allocation rules before relying on any workflow.
What a service charge reconciliation must explain
At the end of the period, an authorised reviewer should be able to answer:
- Which cost categories were included in the approved budget?
- How much was billed and collected from each contributing party?
- Which actual expenses entered the recoverable cost pool?
- Which invoices, approvals and payment records support those expenses?
- What allocation rule applied to each unit, tenant or owner?
- How were vacancies, caps, exclusions and part-year occupation handled?
- Which accruals, prepayments or corrections affected the period?
- Why does each account have an additional charge, credit or balance carried forward?
A spreadsheet can produce the arithmetic. The platform’s value is maintaining the source records, rules, versions, approvals and explanations behind the arithmetic.
Why service charge management breaks down
Problems usually begin before year-end. The approved budget is not loaded into the billing system. Suppliers are paid under inconsistent categories. An invoice covers two buildings but is charged entirely to one. Staff change floor areas without an effective date. A new occupier is billed using the previous tenant’s dates. Vacancy treatment is applied differently by each manager.
Then the reconciliation becomes a reconstruction exercise. Finance exports payments, property management supplies a budget, facilities sends invoices and leasing provides occupation dates. No one owns the complete record. The team may produce a total, but an owner, occupier or auditor cannot trace it efficiently.
Service charge software should be part of a broader commercial lease management workflow once that pillar is published, because allocation rules and contribution dates often originate in reviewed agreements. Until then, the current commercial lease escalation guide demonstrates how structured terms should retain their document source.
Build the approved budget inside the system
A budget needs more structure than one annual total. Create cost centres for each property or service area and categories such as security, cleaning, utilities, common-area maintenance, insurance, statutory services, management costs and planned works according to the approved arrangement. Record assumptions, quotation evidence, approval status and version.
| Budget control | Purpose | Evidence |
|---|---|---|
| Property and cost centre | Prevents costs being mixed between buildings or service areas | Property structure and approved budget schedule |
| Expense category | Supports consistent reporting and variance analysis | Chart of service-charge categories |
| Budget amount and assumption | Explains how the estimate was formed | Contract, quotation, prior result or documented basis |
| Recovery status | Distinguishes recoverable and non-recoverable cost treatment | Reviewed lease or agreement interpretation |
| Allocation pool | Links a cost to the parties receiving the service | Approved floor-area or benefit schedule |
| Approval and version | Prevents draft changes from altering billing | Reviewer identity, timestamp and notes |
When a budget is revised, retain the original, approved revision and effective billing date. Do not silently overwrite the figure that supported prior invoices.
Configure transparent allocation rules
An allocation basis might use floor area, unit count, benefit, consumption, ownership share or another documented method. Different cost pools can use different bases. A lift cost may not apply to every space. Water can be metered for some units and apportioned for common areas. The system should support the approved model or clearly identify where an external calculation is required.
Each unit or tenancy record should include the relevant numerator, total pool denominator, effective dates and source. When an area changes, the prior basis should remain visible for the period in which it applied. A reviewer should be able to reproduce a contribution without relying on hidden spreadsheet formulas.
Vacancy handling deserves explicit configuration. The lease, ownership or management arrangement may determine who bears the vacant share. Do not redistribute vacancy costs automatically unless the reviewed terms permit it.
Turn the annual budget into controlled billing
After approval, the system can convert the allocated budget into monthly, quarterly or other contribution schedules. Finance reviews the schedule before invoices are issued. New occupation, termination, floor-area changes and agreed concessions should generate pro-rated adjustments only after their effective dates are approved.
Invoices should label service charges separately from base rent and other charges. Receipts should allocate to the correct invoices so the company can distinguish service-charge debt from rent arrears. The aged-receivables workflow can then show outstanding contributions by property, tenant and period.
Capture actual costs with recovery evidence
Every actual cost should connect to a supplier, invoice, property, cost centre, category, service period, approval and recoverability decision. A payment record alone does not explain which period received the service or whether the full amount belongs in the shared pool.
Controls should detect duplicate invoice references, missing documents, suppliers not approved for the property, costs above the budget threshold and expenses posted outside the reporting period. Material variances can require an explanation before month-end close.
KRA provides information about eTIMS electronic invoicing. Property companies should ask their tax advisers what supplier evidence is required, then configure document and validation fields to support that process rather than treating every uploaded image as adequate evidence.
Use monthly budget-versus-actual monitoring
Waiting until year-end makes correction harder. A monthly report should show budget to date, actual or committed cost, variance amount, variance percentage, forecast and explanation by category. Property and facilities managers can address overspending, delayed contracts or incorrect coding while evidence is still available.
Variance alerts need sensible thresholds. A small category can have a large percentage variance but little financial impact. A large category can exceed budget materially with a modest percentage. Configure amount and percentage rules, then assign responsibility for explanation and action.
Forecasting is important because the objective is not simply to identify overspending after it occurs. Use contract commitments, seasonal consumption, planned works and known price changes to estimate the closing result. Where permitted, management can then communicate early and seek the necessary approvals.
Handle accruals, prepayments and late invoices carefully
A service may be received before the supplier invoice arrives. An annual insurance or maintenance contract may cover more than one period. The organisation’s accounting policy determines how accruals and prepayments are recognised. The system should preserve the service period, journal basis, preparer, approver and later reversal or settlement.
At year-end, list every estimate separately from final supplier invoices. When the actual invoice arrives, compare it with the accrued amount and record the difference transparently. Do not leave unexplained manual journals buried in the total cost pool.
The year-end reconciliation workflow
- Lock the approved budget and contribution schedule used during the period.
- Confirm occupation dates, unit areas and allocation bases.
- Reconcile billed contributions, receipts, credits and outstanding balances.
- Review every actual cost for property, category, service period and recoverability.
- Identify accruals, prepayments, duplicates, corrections and missing evidence.
- Compare actual recoverable cost with contributions by allocation pool.
- Calculate draft additional charges or credits for each account.
- Perform finance, property-management and authorised senior review.
- Generate an explanatory statement and supporting schedules.
- Approve posting, communicate the result and retain the audit pack.
Material unresolved items should not be concealed to force closure. Record the issue, value, owner and approved treatment. If a final amount depends on professional interpretation, obtain that review before posting.
Give occupiers and owners understandable statements
A reconciliation statement should explain the reporting period, approved contribution, actual allocated cost, prior credits or adjustments and resulting charge or credit. A supporting schedule can show cost categories, budget, actual, variance and key explanations. Authorised users should be able to reach invoice-level evidence where appropriate without exposing other parties’ confidential information.
Plain labels improve trust. Avoid internal ledger codes as the only description. If a category combines several services, provide a schedule. If a prior-year correction appears, state the affected period and reason.
Portfolio and owner reporting
Professional managers need both building-level detail and a portfolio view. Senior reports can show budget variance, collection rate, outstanding contributions, reconciliation completion, evidence exceptions and forecast exposure by property or owner. This helps management focus on properties that require intervention.
Client-money reporting should remain connected. Contributions collected for an owner or property should reconcile to the applicable control ledger and bank activity. Review the multiple-owner workflow when designing portfolio separation.
Communicate material changes before year-end
A large closing adjustment should not be the first time an owner or occupier learns that costs changed. Where the governing arrangement and communication policy allow it, use reviewed monthly or quarterly summaries to explain material contract increases, unusual consumption, emergency work or delayed expenditure. The communication should distinguish approved facts from forecasts and avoid promising a final adjustment before the period closes. Record what was shared, with whom and which report version supported it. Early, evidence-based communication gives stakeholders time to ask questions and lets the property team correct data while the relevant staff and documents are still available.
Approval, access and audit controls
Facilities staff may submit and classify costs. Property managers may review operational relevance. Finance checks accounting evidence and allocation. Senior management approves material adjustments. Those roles should be separated according to company policy. A person should not be able to create a supplier invoice, approve it, change the allocation basis and release the reconciliation without independent review.
Audit logs should capture budget revisions, allocation changes, journals, approvals, statement generation and period reopening. A closed reconciliation needs a governed correction process. Deleting and recreating the record destroys accountability.
Implementation and migration checklist
- Choose one pilot property with complete lease and cost records.
- Approve the cost-category and cost-centre structure.
- Validate unit, floor-area, occupation and ownership data.
- Document each allocation rule and its source.
- Load the approved budget and reconcile contributions billed to date.
- Import actual costs with supplier and invoice evidence.
- Test vacancy, pro-rating, cap, exclusion and late-invoice scenarios.
- Run a draft reconciliation and compare it with the prior method.
- Resolve differences and obtain multi-department sign-off.
- Document the monthly and year-end operating procedures.
A pilot should include the difficult transactions, not only a perfectly occupied building with equal units. The system earns trust by handling exceptions transparently.
Questions to ask PMS.co.ke
- Can one property contain several cost pools and allocation bases?
- Can rules change by effective date without altering prior periods?
- How are vacancies, part-year occupation, caps and exclusions handled?
- Can supplier costs carry service dates, invoices, approvals and recovery status?
- Does the system report budget, actual, committed cost and forecast?
- How are accruals, prepayments and late invoices controlled?
- Can a statement show a traceable calculation for each tenant or owner?
- Can closed periods be locked and later corrections audited?
- Which accounting and document integrations are supported?
- What migration, configuration, training and close support are included?
Use PMS features as the start of the evaluation, then request a scenario-driven demonstration. Do not buy based on the phrase “service charge” alone.
Frequently asked questions about service charge reconciliation software Kenya
What is service charge reconciliation software?
It is software that connects property budgets, contribution billing, actual shared costs, allocation rules and closing adjustments. It should help authorised users trace each result to supporting records and approvals.
Is service charge reconciliation the same as rent collection?
No. Collection records whether invoices were paid. Reconciliation compares approved contributions with actual recoverable costs and calculates the resulting adjustment under the applicable arrangement.
Can one building use several allocation methods?
Many buildings require different pools or methods. Buyers should verify that PMS.co.ke supports the precise combination, effective dates and exceptions used by their leases or ownership arrangements.
Can the system automatically decide which expenses are recoverable?
It should not replace professional interpretation. The platform can store reviewed recovery rules, classify costs and route exceptions for approval, but authorised professionals must confirm the treatment.
How are vacant units treated?
Treatment depends on the governing documents and circumstances. Configure the approved rule explicitly and keep the vacant share visible rather than silently reallocating it.
Can occupiers see supplier invoices?
Access depends on policy, contractual rights and data-protection considerations. The system should support permissioned evidence and reports without exposing unrelated confidential information.
Should reconciliation happen only once a year?
The formal adjustment may be annual, but monthly budget-versus-actual monitoring, evidence review and forecasting reduce surprises and improve the quality of the final close.
What data is needed to start?
Prepare the approved budget, unit and area schedule, occupation dates, allocation rules, billed contributions, receipts, supplier costs, accruals, prior adjustments and supporting documents.
