Client Database Software: 2026 Prices, Field Schema and Setup

Client database software is the one place a small business keeps a single, clean record for every client: who they are, which company they belong to, what you sell them, what they agreed to receive, and everything that has happened since. For most firms under 15 people the right choice is a free or low-cost CRM (HubSpot Free for up to 2 users, Zoho CRM Free for 3, or Bigin Express at $7 per user per month billed yearly), or a no-code database such as Airtable or Notion when your records do not fit a sales pipeline. Every price below was read on each vendor’s own US pricing page on November 1, 2026.

This page is about the records themselves: what fields to store, how to structure and import them, the consent and security rules that attach to them, and which tool holds them best at your size. If you want a side-by-side of client portals, proposals and invoicing apps, that is a different job, covered in our comparison of 12 client management apps with verified prices.

Client database software options, from simplest to most capable

There are four tiers. Each one holds client records; they differ in how much structure they enforce, how many people can edit, and how many records fit before you pay or move.

Bigin counts every row you enter across pipelines, contacts, activities and notes as a record, according to its pricing page. A 400-client firm that logs a few notes per client can hit the 500-record free cap in its first month, so budget for Express from day one if you plan to log activity. HubSpot’s free tools also cap other standard objects at 1,000 records across the account.

Clio publishes only its entry price, and the client portal question for law firms is covered in the client management app comparison linked above, so this page does not repeat it.

What client database software costs at 1, 5 and 15 users

Per-seat prices hide the real number. This table multiplies each vendor’s published annual-billing price out for a full year, using the cheapest plan that covers the headcount. No discounts beyond those on the pricing pages.

A worked example. A 5-person bookkeeping practice has 1,800 clients and logs about 2 notes per client a year. HubSpot Free fails on users (2) and contacts (1,000). Zoho CRM Free fails on users (3). Bigin Free fails on users (1) and records (500). Bigin Express holds it for $420 a year: 1,800 contacts plus 3,600 notes is 5,400 records, well under 50,000. If the practice also prepares tax returns, the federal security rules below apply, and a vertical system such as TaxDome Pro ($5,000 a year at 5 seats) starts to earn its price because the portal, e-signatures and document storage come with it.

For a startup choosing between these on growth stage and startup discounts rather than record count, the CRM for startups guide runs the 3-year math.

What a client database must store: the five field groups

Every useful client record answers five questions: how to reach this person, which organization they belong to, what your relationship is, what they agreed to receive, and what has happened. Tools label these differently, but the groups are the same.

Tags are fine for loose interests (event attendee, newsletter topic). Anything you will filter by range, report on, or use to decide who gets a message belongs in a typed field with fixed options. A status typed as free text splits into “Active”, “active” and “Actve”, and each spelling drops records out of your segments. If your team struggles to keep fields filled, the issue is often skill, not software; our CRM proficiency levels and tests show what “can use the CRM” should mean.

Copy-ready client database field schema and CSV column mapping

Use these column headers for your import file. They map to HubSpot’s default contact properties where one exists, and to Airtable field types if you build in a database instead. Columns marked custom need a custom property or field created before you import.

client_id,first_name,last_name,email,mobile_phone,job_title,company_name,company_domain,street,city,state,postal_code,country,client_status,lifecycle_stage,owner_email,source,client_since,services,annual_value,renewal_date,email_marketing_status,email_opt_out_date,sms_consent,sms_consent_timestamp,consent_text_version,consent_source_url,do_not_call,do_not_call_date,last_contact_date,next_step,next_step_due

The format rules come from HubSpot’s import file requirements: a .csv, .xlsx or .xls file with one sheet and fewer than 1,000 columns; up to 20 MB and 500,000 rows a day on free tools; up to 512 MB on paid accounts with 1,048,576 rows per file. Dropdown and checkbox options must be created before the import, and imported values must match an option’s label or internal value.

Client database import checklist (pass or fail)

1. Every source exported. Pass: you have a CSV from the spreadsheet, your email contacts, your accounting system’s customer list and any old CRM. Fail: someone’s phone contacts still hold clients no one else can see.
2. One unique key chosen. Pass: email for people, domain for companies. HubSpot deduplicates on exactly these, so a matching email in an import updates the existing contact instead of creating a second one.
3. Duplicates merged in the file. Pass: sort by email, then by last name plus postal code, and merge before import. Fail: you plan to “clean it up in the CRM later”.
4. Options built first. Pass: every dropdown and checkbox value in the file exists in the new tool.
5. Consent columns carried over. Pass: every unsubscribed or do-not-call client stays flagged. Fail: the import resets everyone to subscribed.
6. Import order. Companies first, then contacts, then deals or matters, then notes, so each record has something to link to.
7. Test with 10 rows. Pass: names, owners, dates, multi-select values and company links all landed correctly.
8. Full import and count check. Pass: rows in the file equal records created plus records updated.
9. Old list frozen. Pass: the spreadsheet is set to view-only on a stated date, so there is one source of truth.

Data hygiene rules that keep a client database usable

Bad data costs money. In Validity’s State of CRM Data Management 2025 survey of 602 CRM users, 37% said they lost revenue as a direct result of poor data quality, and 76% said less than half of their organization’s CRM data was accurate and complete. More benchmark figures are in our CRM statistics roundup. Run these rules in a 15-minute weekly review.

Consent fields for CAN-SPAM and TCPA

Email and texting have different rules, so store them in different fields.

• Email (CAN-SPAM). The FTC’s CAN-SPAM compliance guide says you must honor an opt-out within 10 business days, keep the opt-out working for at least 30 days after you send, and include a valid physical postal address. It “makes no exception for business-to-business email”, and each violating email can draw a penalty of up to $53,088. What your database needs: an email marketing status field and the opt-out date, so every tool that sends email reads the same value.
• Calls and texts (TCPA). Under 47 CFR 64.1200, “prior express written consent” is a written agreement bearing the signature of the person called that clearly authorizes the seller, with a clear disclosure that signing is not a condition of purchase; electronic signatures count where law recognizes them. Revocations made in any reasonable manner must be honored within 10 business days, and a do-not-call request must be honored for 5 years. What your database needs: the consent timestamp, the exact wording version the person saw, the page or form it came from, and a do-not-call flag with its date.

This is general guidance, not legal advice. Confirm your consent language with counsel before you send marketing texts.

Privacy and security obligations for client records

If you are a “financial institution”: the FTC Safeguards Rule

The FTC’s Safeguards Rule guide lists tax preparation firms, mortgage brokers, finance companies, and credit counselors and other financial advisors among the businesses it covers. If that is you, your client database is part of your information security program, and these requirements land directly on it:

Firms holding customer information on fewer than 5,000 consumers are exempt from four paragraphs of the rule under 16 CFR 314.6, but MFA and encryption are not among them. Our tax client questionnaire template maps each requirement to an intake process, and the client management app comparison lists what each vendor claims on its own trust page.

State privacy laws: which ones reach a small business

Twenty states have comprehensive consumer privacy laws in effect as of November 2026, counting Florida’s narrower law, and four more are signed with later dates. The dates and thresholds below come from ComplyJet’s state list (October 16, 2026); California’s revenue figure is from the California Privacy Protection Agency and its other tests from the California Attorney General. The full 24-state list with opt-out signal rules is in our first-party data strategy guide.

For most service firms with a few thousand clients, the volume tests are far away. Texas is the one to check first, because it has no volume threshold and turns on whether you meet the SBA small business definition. Your state of residence field is what lets you answer “how many Virginia consumers do we hold?” in one filter. ComplyJet notes some thresholds come from group summaries, so confirm against the statute or with counsel.

Moving from a spreadsheet to client database software in 10 working days

1. Day 1: List every place client data lives today and export each one to CSV.
2. Day 2: Pick the tool from the decision table below and start the trial or free plan. Turn on MFA for your own login before you add anyone else.
3. Day 3: Create the custom fields and dropdown options from the schema above. Delete default fields you will never use so the record screen stays short.
4. Days 4 and 5: Clean the merged file: one row per person, split names, lowercase emails, one date format, consent columns filled from your email tool’s unsubscribe list.
5. Day 6: Import companies, then 10 test contacts. Check them field by field.
6. Day 7: Import everything, then notes and open deals. Compare counts with the file.
7. Day 8: Build saved views: active clients by owner, renewals in the next 90 days, records missing a required field, opted-out contacts.
8. Day 9: Connect email and calendar so new activity logs itself, and point website forms at the new tool with consent fields mapped.
9. Day 10: Set the old spreadsheet to view-only and tell the team the date it stops being updated.

Once the list is clean, segmenting it is a filter, not a project. The fields above (status, services, state, renewal date) are the ones most segments are built on.

Best client database for your business size: decision table

My rule of thumb: pick the tool whose free or cheapest plan already holds your next 12 months of records, not your current count. Migrating twice in a year costs more in staff time than the price gap between any two rows above. If you would like a second opinion on the schema or the tool before you import, you can book a consultation.

Frequently asked questions

What is the best client database software for a small business?

It depends on headcount and record count. One or two people with up to 1,000 contacts can run on HubSpot Free. Three people can use Zoho CRM Free. Teams of 4 to 15 usually fit Bigin Express or HubSpot Starter at $7 per user per month billed annually. Tax and accounting firms often do better on TaxDome or Karbon, where the record sits next to documents and e-signatures.

Is there free client database software?

Yes. HubSpot's free tools allow 2 users and 1,000 contacts. Zoho CRM Free allows 3 users. Bigin Free allows 1 user and 500 records, counting notes and activities. Airtable Free holds 1,000 records per base with up to 5 editors, and Notion has a free plan with 7 days of page history. Each free plan has a hard ceiling, so check it against next year's record count.

What fields should a client database have?

Five groups: contact (name, email, mobile, state of residence), company (name and domain), relationship (status, owner, source, client since, services, value, renewal date), consent records (email marketing status, opt-out date, SMS consent timestamp and wording version, do-not-call flag), and history (last contact, notes, next step and due date). Make status, owner and source required, and use dropdowns instead of free text.

Is customer record software the same as a CRM?

Mostly. Customer record software, client information software and client database software all describe the record layer: one entry per person or company with contact details, relationship data and history. A CRM adds pipelines, email logging and automation on top. A no-code database such as Airtable or Notion gives you the records without the sales features, which suits data that is not a pipeline.

Can I use Airtable or Notion as a client database?

Yes, if your records are not mainly sales deals. Airtable Team costs $20 per seat per month billed annually and holds 50,000 records per base; the free plan holds 1,000. Notion Plus is $10 per member per month billed yearly. Neither logs email automatically the way a CRM does, so plan a manual step for history, and build consent fields yourself.

How much does client database management software cost?

From $0 to about $1,200 per user per year. Free plans exist at HubSpot, Zoho CRM, Bigin, Airtable and Notion. Paid entry plans billed annually run $7 per user per month at Bigin Express and HubSpot Starter (new-customer price, $20 list), $14 at Zoho CRM Standard and Pipedrive Lite, and $20 at Airtable Team. TaxDome Pro is $1,000 per seat per year.

Do I need consent records in my client database?

If you market by text or automated calls, yes. The TCPA rule at 47 CFR 64.1200 requires prior express written consent for many marketing calls and texts and says revocations must be honored within 10 business days. For email, CAN-SPAM requires honoring opt-outs within 10 business days, including for B2B email. Store the consent timestamp, wording version and opt-out date as fields.