Why Stock, Cash and Sales Never Reconcile — and How to Fix It

Start with a simple equation

At a high level:

Opening stock + stock received − stock sold − damaged stock = expected remaining stock

The exact model varies by business, but the principle is consistent.

Every movement needs to be represented.

When one event sits outside the system, reconciliation weakens.

Opening stock matters more than teams realise

If the starting number is wrong, every downstream calculation can also be wrong.

That is why opening stock should be a deliberate operational event rather than an assumed value.

The system should know:

• what was expected
• what the driver confirmed
• whether it was changed
• who changed it
• when

That creates a reliable starting point. A shorter note on van stock control covers the day-to-day routine.

Sales need to affect stock

This sounds obvious, but disconnected systems often treat stock and sales separately.

If six cases are sold, those six cases should be reflected immediately in inventory.

That connection eliminates one major class of reconciliation work.

Damage needs its own workflow

Damaged stock should not simply disappear from the remaining count.

If ten cases are missing from expected stock and six were damaged, management needs to know that.

Recording damage separately means the operation can distinguish:

• known loss
• unexplained discrepancy

That distinction matters.

Cash reconciliation is a different problem

A perfect stock reconciliation does not automatically mean the cash position is correct.

Management also needs:

1. Expected cash
2. →Banked cash
3. →Outstanding cash

This becomes particularly important when sales can be:

• cash
• card
• mixed payment

The system should understand the payment method at the point of sale. The cash position is a different question from the stock position, which is why a cash routine still has a place beside the stock equation.

Timing matters

Banking reporting can become misleading if activity is assigned to the wrong period.

For example, cash generated during one reporting period may be banked later.

A useful system needs clear rules for which date drives each metric.

Without that, reports can technically be correct while operationally confusing.

Reconciliation should tell you what is wrong

The final goal is not simply producing totals.

It is isolating exceptions.

Instead of:

Stock doesn't reconcile.

Management should be able to see:

• Expected 42 cases.
• Confirmed 40.
• Difference: 2 cases.

Then investigation can focus on the difference.

Build reconciliation into daily activity

The strongest way to improve weekly reconciliation is not a better Friday spreadsheet.

It is better operational data throughout the week.

• Record the movement when it happens.
• Record evidence when it is created.
• Record the payment method when the sale occurs.
• Record the damage when it is discovered.

Then the weekly report becomes a review — not an investigation.

That review is what a weekly field operations report should be for.