Running a small business on spreadsheets

Practical guides for small teams that run on spreadsheets: tracking stock, orders and quotes in Google Sheets, and asking a sheet questions from an AI assistant.

  1. How to set a reorder level for each product in a spreadsheet

    Work out a reorder level for every product from your own sales and supplier lead times, with three Google Sheets formulas and a worked example.

  2. Spreadsheet or app: when should a small business switch?

    A plain way to decide whether to keep running stock, orders or quotes on a spreadsheet or move to dedicated software, with the real costs of each.

  3. How to ask a Google Sheet questions from ChatGPT or Claude

    Three ways to ask an AI assistant about a live Google Sheet, what each one is good for, and where each goes wrong.

  4. How to track inventory in Google Sheets

    Set up a two-tab stock tracker in Google Sheets that works out stock left, stock value and what to reorder, using three formulas.