How to organize business data: start with a list, not an app
Here is how to organize business data: start with a list, not a new app. Write down what you keep track of, every place you keep each one, and the one place you own for it. You can make that list in about five minutes.
If your booking app says "Harbour Cleaning" and your invoicing app says "Harbor Cleaning Co.", the list is where the fix starts. It takes three things: the list, a file you can open in any spreadsheet, and a plan to move one thing at a time.
The list does not have to be perfect. Proton's guide to sorting business data says it well: "The first audit doesn't need to be perfect." A rough list is enough to start.
Start with the list before any new app. Insightly's guide to customer information notes that "customer data can be especially difficult to manage." We agree, and a new app does not fix that on its own. A new app without a list gives you the same mess in a new place.
This page is by the clevrstart team. We moved our own business into one place we own on 2026-08-06, and we started with the same kind of list.
Signs your business information is a mess
Four illustrations, not measured cases. If one of them sounds like your week, start with the list.
01
The same client, three spellings
Your booking app has "Harbour Cleaning", your invoicing app has "Harbor Cleaning Co." and your phone has "Harbour - Dave". Nothing tells you they are the same client.
02
One question, two apps
A client asks if last month's visit was paid. You open the calendar to find the date, then the invoicing app to find the payment, and you match them by hand.
03
The quote that does not match
You changed a price after a call. The email shows the old price and the PDF shows the new one, and the client asks which one is right.
04
The app that will not let go
You ask a tool for all your client information and it offers one PDF per client, or a message that says to contact support.
Domo's guide to managing data says that getting it right starts with "governance that creates accountability." In plain words, someone has to decide which version is the right one. In a small business, that someone is you, and the list is how you decide.
Step 1: make your list
Your list has five columns. Here is what to write in each one.
The five columns, and what to write in each
| Column | What to write |
|---|---|
| What you keep track of | Your client list, quotes you send, invoices, payments you receive, appointments, hours worked, files and documents, passwords and logins. Add anything else you keep. |
| Where it is today | Every place you keep it: your phone, your email, a spreadsheet, paper, your calendar, your booking app, your invoicing app. |
| How many places | Count the places in the column before. |
| Where it should be | Leave it empty for now. Step 2 fills it in. |
| Who can see or edit it | Only you, you and your team, or your clients too, if they book or pay online. |
Here is one row filled in, as an illustration, not a measured case:
One row filled in, as an illustration
| What you keep track of | Where it is today | How many places | Where it should be | Who can see or edit it |
|---|---|---|---|---|
| My client list | My phone, my email, my booking app | 3 | One place I own | Me and my team |
Three places means three versions that drift apart. When a client changes their phone number, two of them stay wrong.
Your first list will be rough, and that is fine. Fill in the first two columns, then count. For the whole method and why one place matters, read our guide on how to centralize your business data.
Step 2: choose one place you own for each
"One place you own" means one spot that holds the information once. Every app you use reads from it, and you can take it with you if you leave. Anything you keep in two places or more goes there first.
Collate's guide to data management explains that good integration lets people work "with consistent, up-to-date information." That only works when each kind of information has one place that is right.
To choose the place, ask one question: can you take out everything you put in, in a file other programs can open, without asking anyone? We set out this test on our page about what a business operating system is. A place that fails the test cannot be the one you own.
Then connect the tools you keep. QuickBooks, your calendar and Google Business Profile can stay. They read from the one place instead of keeping their own version. You do not need to buy a new product for this step.
Step 3: move one thing at a time, on a copy
With a place chosen for each row, the move is four short steps. Each step can be slow, and that is normal.
01
Practise on a copy
Take a copy you can test on, and run the move there first, never on the information you use every day.
02
Clean only the copy
Merge the three spellings into one, add the missing phone numbers, and fix the errors in the copy you test on.
03
Move one thing at a time
Start with your client list, because quotes, invoices and appointments all name a client.
04
Keep the old app for a week
Leave the old app in place until the new place has worked without problems for a week. Then close it.
Large organizations have the same problem. DAMA International's article on data strategy lists "an incomplete inventory of enterprise data" among the problems that hold them back. The list is the fix at every size.
Our own example: what we listed before our move
We did this ourselves. Before 2026-08-06, each of our apps kept its own information and its own set of logins. On 2026-08-06 we moved them into one place we own, a Postgres database (one store that every app reads from). Before the move, we wrote one line for each app and what it kept:
What we listed before our move, and where it is now
| What we listed | Before 2026-08-06 | Now |
|---|---|---|
| Each of our websites: its pages and articles | In that website's own store | In one place we own |
| The content engine: articles and the files they are written from | In its own store | In its own section of the same place |
| The booking app: events, schedules, availability and meetings | In its own store | In its own section of the same place |
| The logins | One set per app | One shared set for every app, since 2026-08-18 |
Our Business app's clients, quotes, invoices and hours now sit in the same place, beside the website content.
Our rules were the same as Step 3. We practised every step on a copy first. We moved one app at a time: copy its information, point the app at the new place, start it, test it. We kept the old stores until the new place had worked for a week, then shut them down. We moved the logins last, and accepted that everyone signs in again once.
One thing stayed out on purpose. One product we sell to others keeps its own place, so its users and ours never mix.
Our free tool. The business data inventory asks four questions, a few taps each. It makes your map, marks what you keep twice, and lets you download the result as a spreadsheet file. It takes about five minutes, needs no account, and saves nothing. This is the fastest way.
Start from our empty sheet, which lists the five columns and names eight rows already. It is a spreadsheet file. Then pick one of three ways to fill it.
Your AI chat. ChatGPT and Claude both accept a file upload: see OpenAI's guide to working with files and Anthropic's note that Claude can now create and edit files. Upload the empty sheet, then paste this prompt:
I run a small business. Attached is a sheet that lists what I keep track of: my client list, quotes, invoices, payments, appointments and so on. Help me fill it in. Ask me one question at a time: where do I keep each one today (which apps, files or notebooks), and who can see or edit it. Do not guess. When we are done, write “One place I own” next to everything I keep in more than one place, and give me the filled sheet back as a file I can download.
Give it the names of your apps, never your clients' names or numbers.
Google Sheets. Open Google Sheets, then File, Import, Upload, and choose the sheet. Google's help page on how to import data sets and spreadsheets shows the steps. Fill it in by hand. On paid Google plans (Workspace Business Standard or Plus, Enterprise, Google AI Pro or Ultra), Fill with Gemini can help, as Google's July 2026 update explains.
Bring your map to a free call
Finish the list first. Then, if you want help, book a call. Our services page describes it: thirty minutes. Scope, feasibility, complexity, then a number. The call and the number are free; you owe nothing until you accept one.
Bring your map. With your information already listed, the call is about what you need, not about finding out where everything is. When you choose the place itself, our coming page on what a small business database must do covers what that place has to hold.
Our founder's column, Why I put my whole business in one database, tells the longer story of our own move.
Questions about organizing business data
01What is the first step to organize business data?
02What columns should my business data list have?
03How do I move my data once the list is done?
04What does 'one place you own' mean?
Start
Bring your map to a free call
Thirty minutes. Scope, feasibility, complexity, then a number. The call and the number are free; you owe nothing until you accept one.
More on the topic