Services · Excel Inventory System
Custom Excel Inventory Management System
Stock in and out, reorder alerts and a stock dashboard, built around your SKUs. Builds from $75 / £60, fixed in writing.
- inventory
- stock
- reorder
- ecommerce
- dashboard
Start here · Scoping Sprint
Know the exact price in 2 working days. $99, credited in full to your build.
Builds from $75, fixed in writing · Working draft in 5 days or your first payment back · Mutual NDA first if you want one
See a sample Sprint report →Who you'll work with: two partners, 10+ years on finance workbooks →
Stock counts live in one sheet, purchase orders in another and sales in a Shopify or till export. Someone reconciles them by hand, so you find out you are out of stock when a customer asks.
We build an inventory workbook around how you already work: your SKUs, locations, suppliers and lead times. Stock updates from your sales and purchase exports, reorder alerts fire before you run out, and a dashboard shows stock value and slow movers. No new software or subscription.
What we do
An inventory system that fits your business, not a template.
Stock in and out
Goods received, sales, returns and transfers between locations, each logged once and rolled into live stock on hand.
Reorder alerts
Reorder points from your sales rate and supplier lead time, with a list of what to order this week.
Import your exports
Shopify, Amazon, WooCommerce, Xero, QuickBooks or till CSVs loaded with Power Query, so nobody retypes sales.
Stock dashboard
Stock value, slow and dead stock, best sellers and stock cover in days, refreshed in one click.
Free Self-Serve Excel Tools
Interactive in-browser calculators and diagnostics. No sign-up, no email required.
Workbook Compare
Drop two versions of a file and see every changed cell and formula, inserted rows, and formulas someone typed over.
Workbook Map
See how your sheets feed each other as a diagram, with links to other files, hidden feeders and circular links flagged.
Formula Explainer
Paste any formula and read it in plain English, step by step in the order Excel calculates it.
Related
Keep reading
Service
Financial Model Review
Independent review of your Excel financial model before investors or lenders see it, with every issue and its fix in a written report.
Service
Excel to Google Sheets Migration
Move Excel workbooks and macros to Google Sheets: formulas rewritten, VBA rebuilt in Apps Script, outputs checked.
Service
Speed Up Slow Excel
Slow or crashing Excel file? We find the cause and fix it without changing a single output, quoted in writing first.
Service
Sales Commission Calculator
Custom sales commission calculator for your exact plan, with rep statements that show the working, tested against a past pay period.
Service
Inherited Spreadsheet Takeover
Inherited an Excel workbook nobody understands? We map it, document it and make it safe to change, at a fixed price in writing.
Service
Accounting Exports to Excel Reports
QuickBooks, Xero, Sage, Zoho Books or Tally exports into a monthly Excel management report that refreshes in one click.
Prices
What each price band includes.
The exact price is fixed in writing before any work starts. Bigger jobs start with the Scoping Sprint, credited in full.
Quick fix
$75 – $180
Your current stock sheet repaired, with a reorder column added.
- Delivery: 1–5 working days
- 1 review round
- 30-day warranty
Standard
$180 – $500
Inventory workbook for one location: stock in and out, reorder alerts and a dashboard.
- Delivery: 10–15 working days
- 2 review rounds
- 30-day warranty
Complex
$500 – $2,000+
Several locations, one-click imports from your sales exports and a full stock dashboard.
- Delivery: 15–30 working days
- 3 review rounds
- 30-day warranty
Will it pay for itself? Work it out with the free Hours-Saved Calculator →
Deliverables
What you receive.
- Inventory workbook built around your SKUs and locations
- Reorder report with suggested order quantities
- One-click refresh from your sales and purchase exports
- Stock dashboard and checks that flag negative or missing stock
- Short user guide and handover call
- 30-day warranty against the Definition of Done
Tools
What we work in.
- Excel tables
- Power Query
- XLOOKUP / dynamic arrays
- Data validation
- PivotTables
- Optional VBA forms
- Google Sheets on request
Process
How it runs.
- Step 01
Tell us how stock moves
Send a sample of your current sheet and exports. Mutual NDA first if you want one.
- Step 02
Scoping Sprint (2 days)
$99 / £79 or your local price: the design, a fixed price and a Definition of Done. Credited in full to the build.
- Step 03
Build and hand over
Builds from $75 / £60. Working draft within 5 working days of the first payment, then testing on your real data.
Frequently asked
Before you commission an Excel inventory system.
Is Excel enough, or do I need inventory software?
Excel works well for a single business with hundreds or a few thousand SKUs and a few people updating it. If you need many users editing at once or live barcode scanning across sites, the Sprint report will say so honestly.
Can it connect to Shopify or Xero?
It imports their exports in one click with Power Query. Live API connections are a different kind of project, and we will tell you if you need one.
Can I try the maths first?
Yes. The free Reorder Point Calculator shows how reorder points are worked out from sales rate and lead time.
Related: Free Reorder Point Calculator · Excel automation · E-commerce
Start with a Scoping Sprint
Stop finding out about stock-outs from customers.
Send your current stock sheet or describe how stock moves. We reply within one working day with the next step and the Sprint price in your currency.
Calls 9am–7pm IST, Mon–Sat · How a project works