City of Masvingo › Audit-Ready Reporting & Controls
Audit-Ready Reporting & Controls
Reporting period: FY 2025/26 · closed 30 JunAudit readiness
94%
42 of 45 checklist items evidenced
Controls passing
21 / 24
2 failed · 1 not yet tested
Open exceptions
7
2 high · 3 medium · 2 low
Register ↔ GL variance
$4,120
0.009% of NBV · 2 items unreconciled
Verification coverage
92.8%
sighted < 12 months · 129 outstanding
Fixed asset movement schedule — FY 2025/26
Drill to transactions →
| Class | Opening NBV | Additions | Disposals | Transfers | Depreciation | Impairment | Closing NBV |
|---|---|---|---|---|---|---|---|
| Water & sewer | $16.84M | $1.21M | ($0.06M) | $0.02M | ($0.71M) | ($0.18M) | $17.12M |
| Roads & drainage | $12.30M | $0.86M | — | — | ($0.62M) | — | $12.54M |
| Buildings | $9.42M | $0.34M | ($0.09M) | ($0.02M) | ($0.31M) | — | $9.34M |
| Fleet & plant | $2.21M | $0.39M | ($0.11M) | — | ($0.44M) | ($0.03M) | $2.02M |
| Land & stands | $4.86M | $0.12M | ($0.04M) | — | — | — | $4.94M |
| Furniture & equipment | $0.31M | $0.06M | ($0.01M) | — | ($0.12M) | — | $0.24M |
| Total | $45.94M | $2.98M | ($0.31M) | $0.00M | ($2.20M) | ($0.21M) | $46.20M |
Presented on the IPSAS 17 movement format. Every cell reconciles to the transaction ledger; disposals carry DOA approval references; impairment relates to PS-0012 (G5 condition assessment, Jun 2026).
Register ↔ General Ledger reconciliation
Register NBV $46,200,140
GL control acc. $46,204,260
Variance $4,120
Last run: today 06:00 · nightly job
2 unreconciled items
IT-0890 partial invoice ($2,890) posted to opex; donor borehole BH-0054 grant recognition timing ($1,230).
Internal control register — asset cycle All 24 controls →
| ID | Control | Type | Freq. | Owner | Last test | Result |
|---|---|---|---|---|---|---|
| AC-01 | Acquisitions approved per Delegation of Authority before commitment | Preventive | Per txn | Treasurer | Jun 26 | Pass |
| AC-04 | Disposals require committee resolution and two-quote valuation | Preventive | Per txn | Town Clerk | Jun 26 | Pass |
| AC-07 | Work order costs captured to asset before close-out | Detective | Monthly | Eng. Services | Jul 26 | Fail |
| AC-09 | Segregation: asset creation vs approval vs GL posting roles distinct | Preventive | Quarterly | ICT / HR | May 26 | Pass |
| AC-12 | Physical verification — every asset sighted within 12 months | Detective | Annual | Stores | Jul 26 | Fail |
| AC-15 | Depreciation run parameters locked; changes dual-approved | Preventive | Monthly | Treasurer | Jun 26 | Pass |
| AC-18 | GPS/photo evidence mandatory on field verification scans | Detective | Annual | Stores | — | Not tested |
Failed controls carry remediation owner and date — click a row for test evidence. Framework maps to the Auditor-General's asset-cycle expectations.
Exceptions queue All 7 →
Disposal without committee reference — VH-0098 (tipper)
Sold at auction 14 Jun; resolution number missing on record. Aging 26d.
Backdated value adjustment — LD-1180
Land value edited with effective date in closed period. Auto-blocked; pending Treasurer override with justification.
3 additions missing supplier invoices
Furniture receipts TK-2026-1209 batch; PO and GRN attached, invoices outstanding.
Orphan work order costs — $3,240
2 WOs closed against decommissioned asset SL-0311. Reallocation journal required.
Duplicate candidate — BH-0054 / BH-0055
Same GPS ±8m, same install date. Likely double-capture from donor handover sheet.
Immutable audit trail
Hash chain verified · 06:00
Append-only · each event carries the previous event's hash — click a row for before/after
| Timestamp (UTC) | Entity | Record | Action | User | Correlation | Hash |
|---|---|---|---|---|---|---|
| 2026-07-09 14:22:08 | Valuation | PS-0012 | UPDATE | P. Shoko | IMP-2026-004 | …8f3a91 ⛓ |
|
Before
Carrying amount$68,000
Impairment$0
NBV$68,000
ConditionG5
After
Carrying amount$68,000
Impairment($27,000)
NBV$41,000
ConditionG5
Impairment per condition assessment CA-2026-118 · dual-approved: P. Shoko → T. Marowa · evidence: assessment report + photos (3)
| ||||||
| 2026-07-09 11:05:41 | Disposal | LD-1180 | BLOCKED | system | EXC-2026-031 | …c27d04 ⛓ |
|
Attempted change
Land value$96,000
Effective date2026-05-30
System action
RuleClosed-period lock (FY25/26)
OutcomeBlocked → exception raised
Attempt by user account m.chirwa (Valuations). Override path: Treasurer dual approval with written justification — none received yet.
| ||||||
| 2026-07-08 09:47:12 | Asset | SL-9921 batch (×142) | CREATE | K. Dube | VER-2026-Q3 | …41be77 ⛓ |
|
Before
Records—
After
Assets created142 street-light poles
EvidenceGPS + photo per record
SourceField verification scan
Bulk create via mobile verification — validation report attached; 3 rejects (duplicate barcode) quarantined to staging.
| ||||||
| 2026-07-05 15:12:55 | Disposal | VH-0121 (pickup) | APPROVE | T. Marowa | DSP-2026-014 | …9a02e6 ⛓ |
|
Before
StatusPending approval
After
StatusApproved for auction
Committee refRes. 118/2026
Reserve$4,800 (2 valuations)
Approval chain complete: Fleet officer → Treasurer → committee resolution attached. Proceeds will post to disposal clearing account.
| ||||||
| 2026-07-01 07:30:00 | User/role | m.chirwa | UPDATE | system | HR-SYNC | …e55c1f ⛓ |
|
Before
RolesValuations + GL posting
After
RolesValuations only
ReasonSoD conflict (AC-09)
Automatic segregation-of-duties enforcement from quarterly role review — GL posting removed; HR notified.
| ||||||
Audit packs — one-click, indexed, evidence-linked
Asset register extract — year end
Full register at 30 Jun with cost, accumulated depreciation, NBV, condition, location, custodian. CSV + PDF with control totals.
Last: 01 Jul · P. Shoko
Movement & depreciation schedules
IPSAS 17 movement schedule with drill-through transaction listings and depreciation run logs, parameter change history included.
Last: 01 Jul · P. Shoko
Disposals file with approvals
Every disposal: committee resolution, valuations, auction/sale record, proceeds posting, and gain/loss computation.
Last: 28 Jun · T. Marowa
Verification & existence evidence
Sighting coverage report, GPS/photo evidence index, unverified asset list with aging, and the Sep programme plan.
Last: 04 Jul · K. Dube
Controls testing file
Control register, test procedures, samples, results, and remediation tracker — mapped to the Auditor-General asset-cycle framework.
Last: 06 Jul · T. Marowa
Audit trail export — period
Append-only event log for the period with hash-chain verification certificate; filterable by entity, user, action.
Last: 30 Jun · system