Demo Al Noor Municipality: public services and fund control

Demo Al Noor Municipality manages parks, roads, permits, waste collection, and community facilities across four districts. It receives government appropriations, service fees, restricted grants, and fines. Public money must remain traceable to a fund, programme, budget line, purchase, delivery, beneficiary, and approved purpose. This case shows how an OSERP tenant can support that control without treating every department as a separate legal company.

1. Establish the fund and organisation model

Create legal company ANM, districts D01 through D04, and departments for roads, parks, permits, waste, finance, and procurement. Add funds for General Operations, Restricted Parks Grant, Road Safety Grant, and Community Facilities. A fund is a source-and-use restriction; a department is an accountable owner. A project is the delivery vehicle for a programme.

Dimension / field	Demo value	Control impact
Fund	Restricted Parks Grant	Prevents spending on unrelated work
Programme	PRK-2026 Greener Districts	Outcome and grant reporting
Department	Parks Operations	Budget owner and approval route
District	D03	Geographic reporting
Budget year	FY2026	Period and appropriation control
Revenue source	Government appropriation	Funding provenance
Grant end date	31-Dec-2026	Prevents late or ineligible spend
Procurement threshold	AED 50,000	Determines quotation/tender route
Asset class	Public lighting	Capitalisation and maintenance

The chart of accounts should separate cash, receivables, fees, grants, salaries, supplies, capital work, restricted fund balance, and encumbrances. Dimensions should be mandatory on public spending lines. A general journal without fund and programme should be blocked or routed to a clearly monitored suspense queue.

2. Load the approved budget

Open Budgeting → Annual Budget → New Version. The header records budget year, legal company, currency, approval authority, version, and effective date. Lines contain fund, programme, department, district, natural account, period, approved amount, and control type.

For PRK-2026, the restricted grant is AED 12,000,000: AED 4,000,000 for irrigation, AED 3,500,000 for trees, AED 2,000,000 for playgrounds, AED 1,500,000 for lighting, and AED 1,000,000 for programme management. Select hard control for grant-funded procurement and soft warning for general operations. Once council approves version 1, lock it; revisions become version 2 with author, resolution number, reason, and delta.

The budget availability view shows approved, revised, encumbered, actual, commitments, and remaining. A purchase request for AED 300,000 irrigation equipment must reserve the correct fund and programme before a purchase order is issued. A budget check should explain the exact line that failed rather than merely saying “insufficient funds.”

3. Register a permit and collect a fee

A business requests a street-closure permit. Create Citizen Services → Permit with applicant, national identifier, address, activity, district, requested dates, safety plan, approving officer, and fee schedule. The fee calculation records permit type, duration, area, rate, discount or exemption, tax, and payment reference.

For a 3-day closure of 240 square metres, the configured fee is AED 7,200 plus VAT if applicable. Posting debits receivable or bank and credits permit-fee revenue and tax. If payment is made before approval, keep it as an unapplied deposit linked to the application; do not recognise the fee as approved revenue until policy allows it.

The permit status transitions from draft to submitted, inspection required, approved, issued, expired, or rejected. Each transition records user, timestamp, reason, and evidence. A permit officer can approve but cannot alter the tariff table or post a refund.

4. Operate a waste service request

A resident reports missed collection. Create a service request with district, address, GPS or route, category, priority, contact, desired response, and privacy flag. The request creates a work order for the waste route. Detail lines capture crew, vehicle, bin type, estimated hours, fuel, disposal site, and completion evidence.

When the crew completes the request, record arrival, completion time, weight collected, disposal ticket, photographs, and supervisor approval. A route exception such as unsafe access changes status to rescheduled with reason and customer notification. If the service uses a contractor, the work order can generate a measured-service receipt for invoice matching.

5. Procure playground equipment with grant restrictions

The parks department raises a purchase request for AED 600,000 of playground equipment under fund Restricted Parks Grant and programme PRK-2026. Required fields are specification, quantity, delivery site, safety certification, budget line, project manager, required date, and procurement method. Because the amount exceeds AED 50,000, OSERP routes the request through the tender approval path.

The purchase order stores tender reference, supplier, contract, currency, incoterm, warranty, retention, fund, programme, and district. Receipt records serials, safety certificates, quantities, inspection, and installation site. An invoice is matched to order and receipt; a price or quantity variance becomes an exception for procurement and finance.

Capital equipment is not immediately expensed if the capitalisation policy is met. The asset record includes tag, location, custodian, in-service date, useful life, depreciation method, grant fund, and warranty. When a playground is commissioned, create the asset from approved construction or procurement costs and retain the handover certificate.

6. Manage a restricted grant and reimbursement

The Road Safety Grant reimburses 60% of eligible road-marking expenditure. Create a grant record with funder, award number, start/end date, approved ceiling, eligible categories, matching requirement, reporting dates, and contact. Each eligible purchase line carries the grant ID and evidence type.

If ANM spends AED 1,000,000 on approved markings, it records the expense and a grant receivable or deferred funding according to policy. A reimbursement claim groups eligible documents, excludes rejected categories, and shows prior claims, current claim, ceiling, and remaining balance. The fund report must reconcile grant claim totals to the subledger and bank receipt.

7. Payroll, commitments, and encumbrance release

Payroll is processed by employee and department, then allocated to programme or overhead using approved timesheets. A parks employee charging 60% to PRK-2026 needs timesheet or allocation evidence. Salary posting debits expenditure and credits payroll liability; payment clears the liability.

When a purchase order is partially received and invoiced, OSERP releases the corresponding encumbrance and records actual cost. A cancelled order releases the balance with cancellation reason. The budget report must never show a commitment for a closed order.

8. Refunds, fines, and citizen privacy

If a permit is cancelled, create an approved refund linked to application, receipt, rule, amount, bank account, and authoriser. Fines require violation, officer, evidence, appeal status, and payment reference. Waivers are separate approval events and should not edit the original fine.

Resident identity, bank, and complaint data require field-level permissions and retention rules. Public dashboards may show service counts by district but must mask personal information. Export rights should be narrower than view rights, and every bulk download should be audited.

9. Transparent close and performance measures

At month end, finance reconciles fund cash, fee receivables, grant claims, payroll, procurement commitments, capital assets, tax, bank, and budget availability. The close checklist confirms that restricted funds have no ineligible charge, permits issued match fees collected, work orders have completion evidence, and all refunds have authorisation. Period locks prevent backdated spending after council reporting.

KPI	Baseline	After OSERP discipline	Improvement
Budget variance found at year end	AED 2.1m	AED 0.4m	81% lower
Permit application-to-payment match	76%	98%	+22 points
Grant claim preparation	14 days	2 days	86% faster
Missed-collection resolution	48 hours	11 hours	77% faster
Unreleased purchase commitments	AED 900k	AED 90k	90% lower
Audit sample retrieval	4 hours	15 minutes	94% faster

Practice challenge

Load the restricted parks budget, create a permit with payment, raise a tender-controlled purchase request, receive and capitalise playground assets, complete a waste work order, submit a grant reimbursement, process a refund, and run the monthly fund close. Explain every dimension, approval, budget reservation, journal, privacy rule, and report drill-down. Then attempt to charge a road-safety purchase to the parks grant and prove the control rejects it.

Related: Accounting, Advanced GL Mapping, Procure to pay, Projects workflow, and API library.