The Spreadsheet Business Tools Checklist: What You Actually Need
The essential spreadsheets every small business needs — finance, CRM, inventory, project tracker, invoice. A practical checklist with Completo examples.
Most small businesses own too many tools and not enough spreadsheets
A typical small business in 2025 pays for a finance app, a CRM, a project manager, an inventory tool, and an invoicing service — five subscriptions, $150–$400 a month, and at least two of them are barely used. The uncomfortable truth is that four of those five jobs can be done by a well-built spreadsheet, and the fifth can be done by a spreadsheet-powered web app. This is the checklist.
Each item below is a real business function, not a nice-to-have, with what the spreadsheet needs to do and a Completo product we'd actually recommend. Run it as a quarterly audit: if you're missing one, that's a gap; if you're paying a subscription for one, that's a leak.
The five core spreadsheets
1. Finance tracker — tracks income, expenses, accounts, and ideally net worth. The non-negotiables are a 12-month rolling view, automatic categorization, and a dashboard that updates without manual refresh. If your finance 'tool' is a once-a-quarter bank export, you don't have a finance tracker; you have a cleanup project.
Monthly Personal Budget Planner for Google Sheets — income, spending, bills and savings on one sheet, with the dashboard already built. See it in the store →
2. CRM — contacts, deals, follow-ups. A spreadsheet CRM is the right answer for any solo operator or team under five. Beyond that you may want dedicated software — but for the first $50K–$200K of revenue, a sheet beats a $49-per-seat-per-month CRM every time. The non-negotiable is a follow-up date column that surfaces what's overdue.
Completo does not sell a CRM yet. The Google Sheets templates that are ready today are listed on the Sheets shelf. See it in the store →
3. Inventory — stock levels, reorder points, supplier history. Skip if you sell services or digital products; otherwise it's mandatory. Excel handles larger SKU counts better; Google Sheets works for under ~2,000 SKUs.
Inventory Management Excel Template — stock levels, low-stock alerts, purchases, suppliers and profit per product. See it in the store →
4. Project tracker — tasks, milestones, status. The temptation is Asana or Monday; the reality is that 95% of small teams need a status column, a due date, and an overdue view. A spreadsheet tracker takes ten minutes to learn and removes the third subscription from your stack.
No task tracker in the catalogue yet. The Excel workbooks that are finished and documented are here. See it in the store →
5. Invoice generator — generates, numbers, and tracks invoices. The classic approach is a Word template you copy-paste, which is how duplicates and missed numbers happen. The modern approach is a spreadsheet-powered web app: pick a client, pick line items, generate a numbered invoice, write it back to a tracking sheet.
An invoice generator built on this exact pattern is in progress. It will appear on the web-tools shelf. See it in the store →
The audit
Run this checklist against your current stack. For each item: do you have it, is it actually being used, are you paying a subscription for it? If yes to the third and 'barely' to the second, that's a $20–$50/month line item you can replace with a one-time purchase. Do that five times and you've cut $100–$250/month from your burn — and you own the tools forever.
The goal isn't to run your business on spreadsheets. The goal is to stop paying rent on software a spreadsheet can replace.
A small business with these five spreadsheets — finance, CRM, inventory, projects, invoices — has the operational backbone of a company twice its size, for a one-time cost around $170. The same backbone as subscriptions costs upwards of $150 every month, forever. The checklist is short. The savings compound.
Browse the store
Premium Google Sheets templates, Excel spreadsheets, and spreadsheet-powered web tools — each one finished, documented and ready to open.
Continue reading
Best Google Sheets Templates for Small Business (2026)
The four Google Sheets templates every small business needs in 2026 — finance, CRM, project tracking and inventory — what each one must already have built in, and how to tell a finished template from an empty grid.
Free vs Paid Spreadsheet Templates — What You Actually Get
Free spreadsheet templates from Reddit and GitHub vs paid templates — what you actually get for your money. Quality, support, updates, and customization.