Notion, a spreadsheet or an agency app: where should client records live?

A web designer running a one-person AI agency has twelve clients. The café's details are in a spreadsheet. The notes from the dentist's call are in a notes app. The florist's logins are in a password manager, her care plan is in a PDF attached to an email from March, and the promise to update the Easter menu is on a sticky note that fell behind the desk.

Nothing is lost exactly. It's just in five places, and none of them knows about the others.

Where client records live matters less than whether they live in one place you open every week, with a date on everything, and whether you can get them out again as ordinary files. A spreadsheet, a notes tool like Notion, and a project app like ClickUp can all do that job. They differ in how much setup they need, what they're good at, and what goes missing as the work grows. Here's a fair look at each.

What should client records include?

Before choosing a tool, be clear about what it has to hold. For a one-person agency running websites and care plans, each client needs:

• Who they are: business name, contact person, phone, email, address.
• What they bought: the proposal or offer, the price, what's included and not.
• What you promised: anything with a date, including things said on calls.
• Money: invoices sent, payments received, what's still owed.
• Accounts: domain, hosting and listings, and whose name each is in.
• History: notes from calls, decisions made, versions approved.

Good client records for freelancers come down to five records, and that post goes into each one in more detail. Whatever tool you choose, it should hold all of them for each client, or point clearly to where each one lives.

How do the three options compare?

	Spreadsheet	Notion	An app like ClickUp
Best at	Lists: clients, money, dates	Linked notes and pages	Tasks, due dates, projects
Setup	Minutes	Hours, to build it your way	Hours, to fit it to your work
Holds notes and files well	No	Yes	Partly, attached to tasks
Reminders and dates	You check them	Possible, with setup	Built in
Getting data out	Download as a file	Export as Markdown, CSV, HTML or PDF	Export task data as CSV
Rough budget	Often free	Free to start, paid as you grow	Free to start, paid as you grow

None of these is wrong. The right one depends on how many clients you have, how much you'll set up, and what you tend to lose track of.

When is a spreadsheet enough?

For a handful of clients, a spreadsheet is hard to beat. You already know how to use it, it opens instantly, and it's easy to sort by "what's due" or "who owes me". Google Sheets and Excel both let you download a copy of the file whenever you like, so your records never depend on one company.

Where it strains:

• Notes don't fit in cells. A call summary or the reason a design changed ends up in a comment, a separate doc, or nowhere.
• Files live elsewhere. The proposal, the care plan and the logo sit in folders the spreadsheet can only link to.
• Nothing reminds you. A date in a cell is only useful if you look at it.

A spreadsheet works best as the list that points to everything else, checked in a weekly routine. An agency weekly review is one way to make sure you look.

When does Notion make sense?

Notion's strength is that you can build almost any structure: a client database where each client has its own page, with call notes, files and linked projects inside it. There are many templates made for freelancers and agencies, so you rarely start from nothing.

That flexibility is also the cost. You design the system, so you maintain it. When a template doesn't quite fit, you adjust it, and over time the setup can become a project of its own.

Getting data out is well documented. Notion's help centre says you can export a page, a database or a whole workspace at any time, as Markdown and CSV, HTML or PDF. Databases export as CSV files, with Markdown files for each page inside them. Those are ordinary, readable formats. Do a test export early and open the files, so you know how your setup looks outside Notion.

When does a project app like ClickUp fit?

Apps like ClickUp are built around tasks: who does what, by when, in which project. For client work, that's useful for the "what have I promised" part. Every promise can be a task with a due date, and the app reminds you.

Where it fits less naturally is the rest of the client record. Contact details, what the client bought, whose name the domain is in and the history of decisions can be stored in tasks, custom fields and documents, but they're scattered across the structure you build.

Exporting is possible: ClickUp's help centre describes exporting task data from chosen spaces, folders or lists as a CSV file, including task names, descriptions, dates, comments and attachment links. It also says what you can export depends on your plan and your role in the workspace. Check that before your records depend on it.

What goes missing, whichever tool you pick?

The same things, in every tool, for the same reasons:

• Promises made on calls. They go missing unless you write them down straight after.
• The reason for a decision. The tool records what changed, rarely why.
• Money received versus money promised. An invoice marked "sent" can look a lot like one marked "paid".
• Whose name an account is in. Most tools have no natural place for it, so it lives in your head.

That last one matters more than it looks. When a client leaves, or when you stop working, the records need to show which accounts belong to the business. Owner-held accounts explains why the client's domain, hosting and listings should be in their name, with you as a helper.

How do you leave a tool later?

Plan the exit before you arrive. Every tool you use for client records should pass three checks:

1. You can export everything. Not just a list, but notes, dates and files, in formats like CSV, Markdown or PDF.
2. You can open the export without the tool. Try it. A folder of files you can read in any editor is the test.
3. You know where the files and accounts are. Records that point to attachments or logins inside the old tool aren't complete on their own.

Do a test export in your first week, and again once a year. It takes minutes, and it tells you whether your records would survive a move.

Where does Volant fit?

Volant is an app for this job, built for one-person agencies. It's a desktop app that keeps your clients, projects and files next to each client's promises, payments and history. You can export your clients, projects and files as normal files that open without Volant. The ownership page covers keeping client records and accounts in the right names, and keeping track of clients and promises shows the weekly side of it.

Whichever you choose, pick one place, put a date on everything, and make sure you can get it all out as ordinary files.