Two Harpreet Kaurs and One Second-Hand Laptop
Kiran runs a tailoring unit in Ludhiana with three sewing machines and one helper. Orders arrive on WhatsApp and are written in a register: about 300 a month, each with customer name, mobile number, measurements, design number, advance paid and delivery date. Two customers named Harpreet Kaur were recently confused and one received the other's blouse. Kiran buys a second-hand laptop (Windows 10, 4 GB RAM, antivirus not updated since 2023) and wants billing, measurement records and a backup. Power fails four to six times a day; broadband is unreliable, but a 4G phone hotspot works most evenings. The helper types at about 20 words per minute and has never used a spreadsheet. The budget is ₹15,000 for the year. Turnover is below the GST threshold, so no GST invoice is needed.
1. Recommend a spreadsheet or a packaged billing package, justifying the choice against the unit's constraints.
Read the worked answer
Choose a spreadsheet (LibreOffice Calc is free), set up as a small database rather than a loose page.
Constraints: ₹15,000 for the year rules out most billing packages once AMC and support are counted; unreliable broadband rules out cloud-only tools; 4 GB RAM is fine for Calc; the helper can learn a form-like sheet faster than a multi-screen package.
Structure that fixes the real problem: one row per order with columns - order number, booking date, customer ID, name, mobile, measurements, design number, advance, balance, delivery date, status. A separate customer sheet holds ID, name, mobile and address. Customer ID, not name, is the key - this is what prevents two Harpreet Kaurs being merged; the mobile number is the practical identifier, with a serial suffix for shared numbers.
Billing scope: no GST fields are needed, but every order still gets a numbered receipt showing advance, balance and delivery date, printed or sent on WhatsApp.
Revisit when: orders exceed about 500 a month, a second person needs simultaneous access, or measurements outgrow one row per order. Until then, a well-structured sheet beats software nobody has time to learn.
2. Design a data-entry accuracy routine that would have caught the Harpreet Kaur mix-up and the usual typing errors.
Read the worked answer
Fix identity first. Before creating any customer, search by mobile number. If a match exists, reuse that customer ID. If the name matches but the mobile differs, create a new ID and add a distinguishing note (for example 'Harpreet Kaur, Model Town, blouse order'). Names are labels; IDs are identity.
Validate at the point of entry: order number from a pre-printed pad, mobile exactly 10 digits, measurements within sensible ranges (for example bust 60–130 cm), delivery date after booking date, advance not more than total. Reject impossible values rather than spotting them later.
Read-back at booking: the helper repeats measurements and the delivery date to the customer and ticks a printed slip - cheap, and it catches transcription errors while the customer is still present.
Daily reconciliation: cash advances in the drawer must equal the day's advance column; any mismatch is investigated the same day.
Weekly spot-check: pull 10 random open orders and verify measurements and delivery dates against the original WhatsApp message. Record errors and their cause; if the same field keeps failing, change the form rather than blame the typist.
3. Propose a backup, power and security plan that fits the budget and can be operated by non-technical staff.
Read the worked answer
Power: a small UPS (roughly ₹4,000) on the laptop, plus auto-save every five minutes and a habit of Ctrl+S at each entry. Save with a dated filename (orders_2026-07-14) so a corrupt file is never the only copy. Power cuts are the most likely cause of lost data, and this is the cheapest fix.
Backup, 3-2-1 in miniature: two labelled pen drives used alternately, one kept at home and one at the shop, copied daily; a weekly upload to free cloud storage over the evening hotspot; a monthly restore test - open the backup on the laptop and confirm the row count matches. A backup never restored is a hope, not a backup. Total cost roughly ₹1,200–1,500.
Security: a password on the laptop, a separate standard user account for the helper, the spreadsheet password-protected and formula cells locked, and antivirus installed and updated monthly along with Windows updates. Do not reuse the shop's WhatsApp password anywhere else.
Budget: UPS ₹4,000 + pen drives ₹1,500 + antivirus ₹1,000 leaves about ₹8,500 for a used monitor or a printer, which is more useful than extra software. Publish a one-page checklist in Punjabi so the routine survives Kiran's absence.