Google Sheets Expert

Home / Services / Inventory tracking

Inventory tracking

Inventory tracking that reconciles instead of drifting

Stock spreadsheets fail the same way every time: someone edits the on-hand number directly instead of recording a movement.

The fix is structural. On-hand is never typed; it is calculated from an append-only movement log — receipts, issues, adjustments, transfers. That single decision is the difference between a system you can audit and a number nobody can explain.

On top of that we add the things that make it usable on a warehouse floor: a phone-friendly entry form, barcode scanning into the movement log, reorder points that raise an alert rather than waiting to be noticed, and a variance report that reconciles counted stock against calculated stock after each stocktake.

You probably recognise at least one of these

  • On-hand figures that nobody trusts by the end of the month
  • No way to see why a quantity changed or who changed it
  • Stockouts discovered by a customer rather than by the system
  • Separate sheets per location that never reconcile
  • Stocktake variances with no audit trail to investigate

What you get

  • Append-only movement log with user, timestamp and reason on every line
  • Calculated on-hand by SKU and location, never hand-edited
  • Mobile entry form, with barcode scanning where hardware allows
  • Reorder point alerts by email
  • Stocktake and variance reconciliation sheet
  • Valuation report on FIFO or weighted average, as you prefer

How the engagement runs

Model your movements

Every way stock can enter, leave or move. Getting this list complete is most of the job.

Fixed quote

Scope, price, date.

Build and load

Opening balances loaded from your current counts.

Pilot and roll out

One location or one team first, then the rest.

Questions we get asked

Can it handle barcodes?
Yes. Any USB or Bluetooth scanner that types acts as a keyboard, and the mobile entry form accepts scanned input directly into the movement log.
What about multiple warehouses?
Supported, including transfers between them, which are recorded as paired movements so nothing is created or destroyed in transit.
At what point do we need real inventory software?
Roughly when you pass a few thousand SKUs, need serial or batch tracking with expiry, or need to integrate purchasing and invoicing. We will tell you when you are approaching that line.

Tell us what it needs to do

Share the file or describe the outcome. We reply with scope, price and a delivery date.

Get a fixed quote