Why Do Different Reports Show Different Numbers?

Because one day’s output is counted at four different points by four different people, and each count is honest when it is taken: the line’s own count, the register typed into Excel that night, the store’s record, and a figure quoted from memory. The numbers disagree because there are four of them, not because someone made a mistake.

Which number is right when two reports disagree?

Usually both. You cannot fix this by hunting for the mistake. Most of the time there is none.

Somebody brings a figure for Tuesday. Somebody else brings a different one. The next twenty minutes go on finding out which is correct. The supervisor counted what came off the line before the last bundle was checked. The register was written at six and typed into Excel at nine, and one line was skipped. The store counted what reached finishing, which was less, because a bundle was still on the floor. The figure told to the buyer was rounded, on the phone, from memory.

Nobody argued about accuracy. Four people counted four different things and called all four “Tuesday’s production”.

Where do the numbers come apart?

In four places. Every number that disagrees with another one disagrees at one of them.

One day's output, copied four times, arriving as four different numbers Two panels side by side. On the left, a single day's sewing output branches into four routes: a WhatsApp group, a paper register typed into Excel at night, the store's own count, and a figure quoted from memory on a buyer call. Each route arrives at a different total: 1,840, 1,795, 1,760 and about 1,800. On the right, the same output is entered once, at the line, and the daily report, the delivery plan, the Dashboard and Insights all read the same figure of 1,840. Four routes Line 4, Tuesday Group message Register, typed at night Store's own count Quoted on the buyer call 1,840 1,795 1,760 ~1,800 Every one of them defensible. One entry Line 4, Tuesday 1,840 entered at the line Daily report Delivery plan Dashboard Insights 1,840 1,840 1,840 1,840 Every one reads the same entry.
An example. The numbers are made up to show the gap. Four routes out of one day’s work give four totals you can defend. One entry, made where the work happened, gives one.

How do you get one number?

You do not need software for this. You need four decisions. They hold on paper as well as in a system.

What does it cost when reports disagree?

More than the irritation. Twenty minutes of a production meeting spent on Tuesday’s total is twenty minutes not spent on the order that is going to be late. Worse, a team that has learned its reports disagree stops acting on any of them. It waits for a number it trusts. That usually means waiting until the problem is visible without a report, and by then it is too late to prevent.

How does StitchLogic keep to one number?

The supervisor enters the day’s output once, on a phone, at the line. The entry names the order and the colour, so the count point is clear. The daily report, the delivery plan and the cost per piece all read that same entry. Shipped pieces are added up from each consignment and never typed in as a second total. Every entry shows who made it and when. If an entry is edited or deleted, the Activity page keeps what it said before.

Two reports that disagree are four count points with one name.

The fix is not in the report. It is upstream, at the moment the number is first written down.

Try this tomorrow. Take the next figure that two people disagree about. Do not decide who is right. Ask each of them four questions. At what time did you count? At which point on the floor? How many times has this number been copied? Against which quantity? You will almost always find both are correct, and the report was unclear. Then see what one entry at the line looks like, or read why cut dates slip.

Common questions

Why do production numbers differ between Excel sheets?

Because the same day is counted at different times, at different points on the floor, and then copied by hand. Each copy is a chance for the figure to change. The sheets are not wrong. There are just several of them.

How do I track garment production without a big system?

Enter each day’s output once, at the line, by the person who saw it, with the order and colour written beside it. Keep one record. Add up totals from that record every time, and never keep a second typed total. A phone and a simple tool can do this.

Which count point should a daily production report use?

Pick one point, such as cut, sewn or packed, and write its name on the report. A report that does not say what it counts will be read three different ways.

What is the difference between order quantity and chart quantity?

Order qty is what the buyer ordered. Chart qty is the quantity you plan to produce. They can differ. Decide which one your reports measure against, and say so on each report.

How do I stop mistakes from copying numbers by hand?

Copy fewer times. Enter the number once where it happens, and let every report read that one entry. A number copied three times has had three chances to change.

Back to Notes