FormulaSurge

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 →

10+ years in ExcelNamed senior ownerFixed price, in writingDraft in 5 days or refundMutual NDA on request30-day warranty

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.

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.

  1. Step 01

    Tell us how stock moves

    Send a sample of your current sheet and exports. Mutual NDA first if you want one.

  2. 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.

  3. 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.

Replies within one working day, usually the same day

Calls 9am–7pm IST, Mon–Sat · How a project works

Service standards

Six rules on every Excel service project.

Project rules, not marketing copy. The same six on every dashboard build, audit, macro, model and clean-up.

15% OFF

15% off your first project

Start with the $99 Scoping Sprint - credited in full to your build.

View more

15% off the build fee of your first project. Mention it when you book; the Scoping Sprint is still credited in full.

The Scoping Sprint gives you a written diagnosis and a fixed price for your build in 2 working days.

Not ready yet? · Free

Free 10-minute Excel audit

Seven checks on your workbook, results in writing within one working day.