KENYA · GUIDE 0590 · EDITION 4.7
Data cleanup service in Kenya: Planning Worksheets and Source Register
Editorial update: 28 October 2026 · Business planning reference · Review scope
Keep records that answer a specific question
Use a buyer brief, quotation comparison, acceptance record and cash ledger matched to data cleanup service.
This is a planning reference for data cleanup service. The order below is an invented teaching case. It is not a completed customer job, an operating approval or a prediction of demand or earnings.
The example offer and its boundary
Fictional cleanup CLN-90 standardises 500 contact rows while retaining the original file and a row-level change log. Allowed transformations are trim outer whitespace, normalise approved category spelling, preserve phone/code fields as text and flag candidate duplicates. Fixture: ' Asha ' becomes'Asha'; phone'0712345678' keeps its initial 0; 'Retail ' maps to approved'Retail'. Shared reception emails and similar names are not merged automatically. Output is cleaned copy, unresolved list and before/after counts. Marketing, identity investigation and deletion of originals are excluded.
A prefilled brief to adapt
| Record field | Teaching entry or business-specific prompt |
|---|---|
| Guide and case reference | 0590 — invented planning case |
| Buyer group | Businesses preparing data for software or reporting. |
| Output and boundary | Clean and standardize a dataset without discarding unapproved records. |
| Charging basis | dataset project |
| Input suitability | Check which fields are sensitive and avoid unnecessary copies. |
| Final acceptance gate | No record vanishes without a documented rule/approval; reopen export through intended import route. |
| Unresolved evidence | Actual contact data, duplicate rules and lawful processing basis unverified. |
Carry the same reference through the documents
- Buyer brief: approved specification, exclusions, authority and delivery window.
- Supplier comparison: actual quote, matched specification, quantity, landed cost, expiry and buying check.
- Work and acceptance card: actual observations, accepted/held/rejected output, changes and correction references.
- Cash ledger: invoice, advance, credits, collections, balance and date due.
- Decision note: evidence, unresolved limits, responsible person and next review point.
An invented invoice-and-collection record
TRAINING-0590: a fictional order for the scoped offer in section 01, using 500 priced units at KSh 10.00 each. Buyer group: Businesses preparing data for software or reporting. No buyer was contacted and no order was completed.
Teaching invoice = 500 x KSh 10.00 = KSh 5,000.00. The selected input lines in section 06 total KSh 3,900.00; their difference from this assumed invoice is KSh 1,100.00 before excluded costs and tax.
For cash-timing practice only, suppose a buyer pays a 30% advance of KSh 1,500.00. The invoice balance is KSh 3,500.00. If the selected input bill is paid before the balance arrives, additional cash of KSh 2,400.00 is needed after applying the advance. The advance is counted once, not again at final collection.
These sample entries are not your actual job records. Keep names, contacts and payment references in private copies. The paid pack contains offline editable costing, operations and cash-planning tools; this public sheet explains how the records connect.
References and their limits
Keeping leading zeros and large numbers — Microsoft
Import identifier columns as text to preserve zeros and precision. Reference check recorded 2026-10-26.
Import data from data sources (Power Query)
Import preview and data-source workflow; version-specific menus may differ. Reference check recorded 2026-10-26.
Rights Of A Data Subject
Kenyan privacy principles and data minimisation; not a complete compliance assessment. Reference check recorded 2026-10-26.
Recorded references support only the scope stated beside them. They do not prove current supplier stock, a local quotation, actual buyer demand, operator competence or the feasibility of this particular business. Later editorial changes do not refresh earlier source-check dates.
Prepared by Business Starter Guides using AI-assisted drafting and desk editorial checks. Independent operator trials and specialist certification are not claimed. See the editorial method for the review scope.
Editorial method and evidence limits