Why outlet sales reports never match: fixing multi location data

One outlet reports sales before discounts and another after, a third includes sales tax and a fourth leaves out delivery fees. Each sheet looks tidy. None of them can be added to the next.

The mismatch is rarely arithmetic. It is definition. Head office never wrote down what a sales figure contains, so each manager filled the gap with habit, and the habit hardened into a column header.

Start by listing every figure that moves between an outlet and head office, then write one sentence defining each.

Outlets copy a template once and then edit it. A column gets renamed, a tab moves, and someone adds a total row at the bottom that breaks the import. Within a year you hold forty versions of one report.

Time is the second leak. A late-night dosa counter or pub closes at two in the morning, so its Tuesday spills into Wednesday. Head office sees a flat Tuesday and a Wednesday spike. Neither can be explained.

Fix the business day, not the clock. Define it as a start and end time, and make every outlet close against it.

A shared chart of accounts gives every outlet the same heads: product sales, service sales, discounts, refunds, tax collected, tips and cash banked. Outlets pick from a dropdown list. Nobody types labels into free cells.

A local manager may feel boxed in. Allow extra detail underneath each head, such as a separate line for each delivery app, but never extra heads on top. The rollup reads the top level, and the outlet keeps its own view below.

Mapping old sheets to the new heads takes an afternoon per outlet. It pays back every month.

Ask each outlet to submit once a day, with cash counted against the register and card settlements checked against the terminal report. A blank required field blocks the submission.

Once head office accepts a day, it locks. Later changes need a reason and an approver, and that one rule stops numbers shifting after the board pack has gone out.

Errors then surface the next morning, while the shift manager still remembers the rush, instead of waiting three weeks for the reconciliation to find them.

With definitions fixed and days locked, the rollup becomes a query. Sales by outlet, region, daypart and week are ready without anyone opening an Excel attachment, and variance against target sits beside them.

Keep a short exceptions list for late submitters and failed till-to-cash checks. Chasing five names is easier than chasing the whole network.

This week, take three outlets and set their last month side by side. Mark every row where the meaning differs. That marked list becomes your definition document.