Record-keeping mistakes: the seven most common

Most record-keeping errors are not random: they recur in the same places for the same reasons. So you can learn them in advance and put a short check against each. Below are seven mistakes, each with its telltale sign and a way to prevent it. As an example, take an electrical-supplies shop: cable, sockets, bulbs, circuit breakers.

Receipt and issue errors

Mistake 1: an unrecorded receipt. The truck arrived, the goods went on the shelf and nobody entered them in the table. Sign: there are sales, but the balance is zero or negative. The easiest check: filter the table for rows with a negative balance. A negative balance cannot exist physically, so behind it lies an unrecorded receipt or a wrong unit. It most often happens during a rushed unloading or late in the evening. Write the delivery-note number for each batch into the table: a document without a number counts as not entered.

Mistake 2: an issue recorded twice. The sale is on the till receipt and someone also enters it in the table by hand. Sign: the balance in the table is steadily lower than on the shelf, and the sales total is higher than the till shows. The remedy is simple: sales data comes from one source only, such as the daily till report, and from nowhere else. Otherwise even 10 sockets a day entered twice make the table show 70 fewer by the end of the week, while the goods are still on the shelf.

Mistake 3: mixed units of measure. Cable arrives in coils and is sold by the metre. The receipt was entered as "3" (coils) and the sale as "40" (metres). The balance came out at 3 − 40 = −37, although the warehouse actually holds 260 metres of cable. The right way: pick one base unit, the metre, and convert coils on receipt: 3 × 100 = 300 metres. Then 300 − 40 = 260.

Timing and formulas

Mistake 4: late entry. "I'll write it later" turns into half a week's pile in two days, and the person no longer remembers what was not recorded. Rule: an entry is made within 24 hours at most. If there is no time, at least photograph the till receipt or delivery note: the entry will be made later, but the source will not be lost. Late entry has another cost: the day's prices and discounts are forgotten, and tomorrow you can no longer recall the exact selling price.

Mistake 5: a broken formula. When a new row is added the total does not include it, or someone, for a "quick fix", types a number by hand in place of a formula. Sign: the total differs from a manual recalculation. Once a month recalculate five rows on a calculator and colour the formula columns: a hand-typed number then stands out at once. Protect the formula columns and leave separate columns for input.

Mistakes in correcting

Mistake 6: correcting by deleting. If you delete the wrong row and write a new one, the trace of the error disappears, how and why it happened stays unknown and the mistake keeps recurring. The right way: leave the old row and write a correcting row beneath it: "−2 pieces, reason: entered twice". The table grows a little longer, but every number is explained.

Mistake 7: quietly levelling a difference. After a count the balance is set to the number on the shelf, but nobody records how big the difference is or where it came from. For example, the table shows 120 sockets and the count finds 114. If you quietly correct it, both the shortage of six and its cost disappear. Write: "−6 pieces, count, cause being investigated", then find the cause. Differences accumulated month after month give a true picture of shrinkage.

Three checks in ten minutes

You need not hunt the seven mistakes one by one. Once a week spend ten minutes on three actions:

1. Filter rows with a negative balance (mistakes 1, 3 and 4).
2. Compare sales totals in the till and in the table (mistakes 2 and 4).
3. Recalculate by hand the total and balance for five rows (mistake 5).

Conclusion

There is no one who never makes mistakes, but there are systems that find mistakes quickly: one unit, one source, daily entry, protected formulas and entries that are never deleted. If errors have already piled up and you do not trust your balances, the AniqHisob team can run a stock count, help restore the records and train staff to enter data correctly.