Van Stock Count & Variance Audit
A blind-count van audit tool — your tech counts on-hand parts without seeing the expected numbers, the app values every variance, flags chronic offenders, and a supervisor approves the stock adjustments before anything posts.
A logged-in web tool where a tech enters a blind parts count, the app compares it to expected stock, values the variance in dollars, flags repeat offenders, and routes the variance report to a supervisor who approves the adjustments before van stock is corrected — with a clean CSV export.
Before you start
- A free Supabase account
- A free Vercel account
- A free Resend account
- A list of expected stock per van and your counted quantities (a Google Sheet or CSV is fine)
The problem this kills
Parts walk off trucks. Techs forget to log what they used on a job. Slowly, the stock your system thinks is on each van drifts away from what's actually rattling around in the bins — and you only find out when a tech shows up to a job missing the one part they needed.
The usual "fix" is a once-a-quarter count on a clipboard, where the tech can see the expected number while they count. That's not a count — that's confirmation. Nobody catches the missing five. The spreadsheet that follows is a mess of who-owes-what, and the adjustments get keyed into your system of record with zero review.
This tool replaces all of that. The tech counts blind — they never see the expected number while entering. The app does the math, puts a dollar value on every gap, flags the vans that come up short over and over, and makes a supervisor sign off before a single number changes.
What you'll build
A small, secure web app your parts team logs into. A tech (or a coordinator) opens a count session for a van, enters what they physically counted part by part — without the expected quantities showing — and submits. The app instantly produces a variance report: expected vs counted, the gap, and the dollar value of that gap per part and per van. Vans and techs that keep coming up short get a chronic-offender flag. A supervisor reviews the whole report, approves (or rejects) the adjustments, and only then does the van's stock get corrected. Everything is logged, and you can export the variance report as a CSV in the exact columns your inventory system expects.
What's inside the Implementation Plan
The plan is a complete, copy-paste runbook. It opens by interviewing you about your business — your vans, your part numbers, how you count today, your dollar thresholds, your approval rules, your messy exceptions — and then tailors the data model and every build step to your answers. It is not a generic template; the first thing it builds is your version.
After the interview it walks you, prompt by prompt, through standing up the database, the login, the blind-count entry screen, the variance math and valuation, the chronic-offender flags, the supervisor approval gate, the audit trail, and the CSV import/export — each step ending in a ready-to-paste prompt for your AI agent.
The governance it includes (this is the point)
- Login so only your parts team can open it.
- Row-level security so each organization only ever sees its own vans and counts.
- A blind count — expected quantities are hidden during entry so the count is honest.
- A full audit trail — who counted, who approved, what changed, and when.
- A hard approval gate — the AI drafts the variance and the proposed adjustments; a supervisor reviews and approves; only then does stock post.
- Duplicate guards — the same van + part + count session can't be entered or posted twice.
Who it's for
Parts coordinators, field supervisors, and inventory-control folks who manage truck stock and are tired of clipboard counts, shrink they can't trace, and adjustments nobody reviewed. No coding experience needed.
You've got this — paste the first prompt and let the plan interview you.