lamp.
ResourcesPricingAbout

Data source

A data source is the original place a piece of data comes from, such as a register, a sheet, a machine log, a bank statement or a signed document.

What it means

Every figure in a report should have a named source and an owner. Where a number appears in several places, one source must be designated as the master, and the others should copy from it. Naming sources prevents the common argument in meetings over whose figure is correct, and tells you where to correct a mistake.

Example

A distributor's outstanding payments figure appears in a sales sheet, an accounts ledger and a collection tracker. The owner decides the ledger is the source, and the other two must be refreshed from it each Monday morning.

Records and checks

  • Record each report figure's source, its owner and how often it is refreshed.
  • Verify that copies match the source by comparing totals on a set date.
  • The owner of the source keeps it up to date, and the report owner confirms the link each month.

Common mistakes

  • Treating a copy as the source and editing it directly, so the original goes out of date.
  • Having no named owner, so nobody corrects an error once it is spotted.
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 →