lamp.
ResourcesPricingAbout

Data consistency

Data consistency means the same fact is stored identically wherever it appears, with agreed formats and values, so reports from different places do not disagree.

What it means

Problems arise when a customer is "Sharma Traders" in sales, "M/s Sharma Trading Co" in accounts and a third name in dispatch. Inconsistent units, date formats and item codes cause the same trouble. Consistency is achieved by a single master list, agreed formats and checks that compare figures across departments.

Example

A hardware wholesaler's stock sheet shows 120 bags of cement, while the dispatch register's running count shows 98 and the accounts ledger counts 105. Because three teams record the same stock differently, the owner cannot trust any one figure.

Records and checks

  • Record the master list of names, codes and units, and the rule for how each field is written.
  • Verify by matching totals across sales, stock and accounts on a regular day each month.
  • The data owner maintains the master, and the accounts head investigates every mismatch found.

Common mistakes

  • Letting each department keep its own separate list of customers or items.
  • Fixing a mismatch in one place without correcting the source, so it comes back.
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 →