How to Organize Your Business Information in One Spreadsheet

Prefer to watch?

This guide is also a video.

Watch the video →

What problem does one workbook solve?

Certain moments demand a specific piece of information immediately, and they arrive without warning:

In most small businesses, that information is distributed across a filing drawer, an email from two years ago, and the owner's head. Each retrieval becomes a search project, and a few of those a year quietly add up to real money in lost time. The last two rows carry a bigger point: a business whose critical information exists only in the owner's brain is worth less and is more fragile than the same business with its information documented.

One workbook with three tabs ends the searching.

What goes on the customer tab?

Tab one holds the customer tracker, and if you've built one already, nothing gets redone; the existing tracker becomes this tab, or gets mirrored into it. The full field-by-field breakdown lives in the guide on organizing customer information.

Businesses running a CRM keep running it. The point of tab one is completeness of the workbook itself: whoever opens this one file should find the customer basics alongside everything else, rather than being sent on a tour of your other systems.

What belongs in the business vitals tab?

Tab two is the one almost no business has, and the one that pays for the whole exercise. It collects the details that get hunted for a few times a year, in two blocks.

Legal and identity details

None of that is legal or accounting advice about what to file; it's record-keeping advice about what you have already filed. Keep the identifiers and confirmation numbers where they can be found in seconds.

Key accounts

Key accounts is the second block: the bank, the card processor, any loans, the utilities, every piece of software the business pays for. Four things per account: what it's for, a nickname or the last four digits, the renewal or due date, and the support phone number. Deliberately absent from that list: the password. That exclusion has its own section below.

What goes on the equipment tab?

Tab three covers anything with a serial number or a warranty: machines, vehicles, tools, computers. One line per item: what it is, purchase date, serial number, warranty end date, and the number to call when it fails.

Equipment failures pick their timing badly, which is exactly why this tab exists. The moment a machine dies mid-job is the most expensive possible time to reconstruct whether it's still under warranty. Thirty seconds of data entry at purchase converts a future crisis search into a lookup.

What must never go in the spreadsheet?

No passwords. No full account or card numbers. No bank logins. Nothing that functions as a live key to money or systems.

The reasoning is concentration of risk. A workbook this useful travels: it gets shared with a bookkeeper, opened on a phone, synced across devices. If it also contained credentials, any single compromise (e.g. a phished email account, a lost phone) would hand over the entire business in one file.

The workbook follows a strict division: it is the map, never the keys. The map says an account exists, what it's for, its last four digits, and who to call. The keys, meaning every password and login, live in a purpose-built password manager such as Bitwarden or 1Password. Both have free tiers, both are designed for exactly this, and both allow controlled sharing with a spouse or bookkeeper without anything sitting in plain text.

Who should be able to open the workbook?

An organized file locked away from everyone recreates the original problem, so decide access deliberately.

At minimum, one person besides the owner should have access today: a spouse, a business partner, a trusted employee. That's the difference between an inconvenience and a crisis when the owner is unreachable. Working helpers, like a part-timer who handles scheduling, can often be limited to the customer tab rather than the whole workbook; spreadsheet tools allow view-only sharing, which fits people who need to look things up but shouldn't edit.

Because the workbook contains no passwords, the blast radius of any single person's access stays limited. That's the map-and-keys division doing its job a second time.

How do I know the workbook works?

Apply the two-week test. Picture the person most likely to cover for you opening this file cold, with no phone call allowed. For two weeks they need to find an account number, call the right vendor, check a warranty, and pay the bill that comes due. Everywhere they'd succeed, the workbook is done. Anywhere they'd have to call you, you've found the next row to add.

The workbook has one designed limitation: it records what and where, never how. Instructions for tasks, how an invoice goes out, and how the shop opens and closes, belong in a separate folder of short standard operating procedure documents. Name it "Procedures" or "How We Do Things." Keeping instructions out of the spreadsheet keeps both pieces simple enough to maintain. If you want a broader check on your operations, the free self-assessment covers ten areas including business continuity.

How do I keep it current without it becoming a job?

Two habits, neither of which takes measurable time.

Resist decoration. Extra tabs multiply, forty-column layouts go unfilled, and merged-cell formatting breaks the first time someone sorts. Plain text, a few tabs, readable on a phone. And keep it in an account you own: core business information shouldn't be trapped inside a rented tool that can change its pricing or terms whenever it likes.