lamp.
ResourcesPricingAbout

Data cleaning

Data cleaning is the work of finding and fixing duplicate, incomplete, inconsistent or wrong entries in records so the data can be trusted and reused.

What it means

Typical problems are the same customer entered three ways, item names with different spellings, units mixed between kg and tonnes, missing phone numbers and old inactive parties. Cleaning means agreeing a standard, merging duplicates, filling or flagging gaps and removing what is dead. It is usually done before moving data to a new system.

Example

A hardware wholesaler in Ahmedabad finds 4,800 item records, of which 600 are duplicates such as "MS Angle 40x40" and "M.S. angle 40*40". After cleaning, stock reports show true quantities and a ₹1.1 lakh stock mismatch appears.

Records and checks

  • Record the rules applied and a list of records merged or removed.
  • Verify counts and balances before and after cleaning.
  • The data owner approves merges; the accountant checks party balances.

Common mistakes

  • Deleting records that still have open transactions against them.
  • Cleaning once and then allowing the same mess to be entered again.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →