Does Cash Workspace find duplicate clients for me?

No. There is no automatic duplicate detection or name-matching. You spot duplicates yourself by sorting and searching your client list, then move records by hand. The workspace gives you the single client record to consolidate into, but the review is manual.

How is this different from the annual client record review?

Merging is the as-needed task of folding two-or-more records for the same client into one. The annual review is a yearly pass that refreshes stale fields (address, terms, rate) on records that already exist as single entries. Deduping fixes a split; the annual review fixes staleness.

Should I delete the duplicate or archive it?

After you have moved every invoice, receipt, and document onto the surviving record, delete the now-empty duplicate so it can't collect new entries. Archiving is for whole clients you no longer work with, and it keeps the record intact rather than emptying it; that is a separate workflow.

How do I avoid double-counting when both records hold the same invoice?

During the merge, find any item that exists on both sides, like one invoice entered under each name, settle on the correct status, keep a single copy, and delete the other. The surviving record's billed-to-date should equal the sum of distinct invoices only.

What if I'm not sure two records are the same client?

Don't merge until you're sure. Compare the bill-to address, the tax or registration ID, the email domain on attached invoices, and the contact. If the evidence is mixed, leave them separate. A wrong merge is harder to unwind than a duplicate left in place.

Cash Workspace

Use the Freelancer template

Client records cleanup

Merge duplicate client records: a consolidation checklist

When the same client ends up filed under two or more separate records, their finance trail splits in half. One record holds three paid invoices; the other holds two receipts and the signed agreement, and neither one tells the full story. This checklist walks through the as-needed task of finding those duplicates, deciding which entry to keep, and folding everything into a single client record. It covers detection and merging only: refreshing one client's stale address or terms is a separate yearly pass, and moving a dormant client out of the active list is archiving, not merging. Cash Workspace does not detect duplicates for you and does not read names out of your documents, so this is a manual review you run when you notice or suspect a split. It is organizational guidance, not accounting advice.

Start a free workspace See your clients side by side

The problem

Why one client ends up filed twice

Duplicate client records rarely come from carelessness; they come from small naming differences and from more than one person (or one busy person on different days) creating a record before checking whether one already exists. The result is a client whose money is recorded in two places at once, so any per-client total you read is wrong and any document you go looking for might be under the other entry.

The same business entered two ways: "Brightside Cafe", "Brightside Cafe LLC", and "Brightside Café" each become a separate record, so invoices land in whichever one was open at the time.
A trading name versus a legal name: you invoice "Maple Studio" but file a receipt under "Maple Creative Group Inc." without realizing they are the same payer.
A person versus their company: "Dana Holt" and "Holt Consulting" both exist because early jobs were billed to the individual and later ones to the entity.
A typo or extra space at creation time ("Acme Co" vs "Acme Co.") that sorts the two entries far apart in an alphabetical list.
A re-engaged client: someone you stopped working with got a fresh record on their return because the old one wasn't found, splitting their history across a gap.
The result is split totals and scattered documents: neither record shows true billed-to-date, and the agreement, receipts, and invoices for one client live under two names.

The merge

A step-by-step way to find and consolidate duplicates

Run this as a focused pass whenever you suspect a split, or as a quick sweep before you pull any per-client numbers. The goal is one surviving record per client with every invoice, receipt, and document gathered under it, and nothing double-counted. Work one duplicate group at a time and finish each merge fully before starting the next.

1
1. Scan the client list for look-alikes
Sort your clients alphabetically and read down the list watching for near-identical names: the same word with and without "LLC"/"Inc.", a name with and without an accent, singular/plural, or trailing spaces that push an entry out of place. Also search by a fragment you know is unique, like a surname or a street, to surface a partner record filed under a different name. Note each suspected pair or trio as a group to investigate.
2
2. Confirm it is genuinely the same client
Before merging anything, prove the two records are one payer, not two real businesses that happen to share a word. Compare the bill-to address, the tax/registration ID if you have it on each billing profile, the email domain on attached invoices, and the contact name. Two records named "Park Dental" in different cities with different IDs are NOT a duplicate. Only proceed when the evidence says it is the same client.
3
3. Pick the surviving record
Choose the entry you will keep, usually the one with the most complete and current details: correct legal name, current address, agreed terms, and the most documents already attached. Write down which record survives ("keep Brightside Cafe LLC") and which is the loser to be emptied ("merge from Brightside Cafe") so you don't lose track halfway through.
4
4. Move every record and attachment onto the survivor
Open the losing record and move each item it holds onto the surviving one: every invoice (with its status), every expense and receipt, every attached document such as the agreement or W-9, and any notes. In Cash Workspace this is a manual move of records and files; nothing is copied automatically. Go item by item so nothing is left behind.
5
5. Reconcile overlaps so nothing is double-counted
Where the same item exists on both records, for example invoice #2025-014 was entered under each name, keep one copy and delete the true duplicate so the merged total isn't inflated. If the two records held different statuses for the same invoice (one "paid", one "sent"), settle on the correct one before deleting the other. The merged record's billed-to-date should now equal the real sum of distinct invoices.
6
6. Empty and remove the loser, then spot-check the survivor
Once the losing record holds nothing, delete it so it can never collect new entries. Then read the surviving record top to bottom: confirm the name and bill-to details are the version you chose, every invoice and receipt is present, the agreement is attached, and the running total matches what you expect. Add a short note such as "Merged from 'Brightside Cafe' on 2026-06-29" for an audit trail.

Record structure

What to capture for each duplicate you resolve

A merge is easy to get half-done and hard to redo, so keep a short log of each consolidation. Record these fields in a note on the surviving record (or in a simple merge-log record) so anyone reviewing later understands what happened and can trust the totals.

Client (canonical name): The single name you standardized on, e.g. "Brightside Cafe LLC". This is the name the merged record now carries.
Duplicate names found: Every variant that was pointing at this client, e.g. "Brightside Cafe", "Brightside Café". Lists what you searched for and what you folded in.
Surviving record: Which entry you kept and why, e.g. "kept the LLC record; most complete address and terms".
Merged-from record(s): The record(s) you emptied and deleted, so the absence is explained rather than looking like lost data.
Items moved: A count or list of what was relocated: invoices, receipts, expenses, agreement, W-9. Confirms the move was complete.
Duplicates removed: Any item that existed on both sides and was deleted to avoid double-counting, e.g. "invoice #2025-014 (kept the paid copy)".
Total before / after: Billed-to-date on the survivor before and after, so you can sanity-check that the figure reflects distinct invoices only.
Merged on / by: The date and who did it, e.g. "2026-06-29, owner". Provides the audit trail for the consolidation.

Example setup

An example merge laid out

Here is one duplicate group before and after a merge in a Clients folder. The same cafe was filed three ways; after consolidation, one record holds the complete trail and the two extras are gone.

Clients / Brightside Cafe (before)

Invoice #2025-009 (paid), Invoice #2025-014 (sent), receipt-coffee-supplies.pdf. Created first; missing the agreement and uses a casual name.

Clients / Brightside Cafe LLC (before)

Signed-services-agreement.pdf, W-9.pdf, Invoice #2025-021 (paid), Invoice #2025-014 (paid). Has the legal name and documents but duplicates invoice #2025-014.

Clients / Brightside Café (before)

deposit-receipt-jan.pdf only. Created by accident from an email with an accented name; one stray document.

Clients / Brightside Cafe LLC (after merge)

Signed-services-agreement.pdf, W-9.pdf, Invoice #2025-009 (paid), #2025-014 (paid, single copy kept), #2025-021 (paid), receipt-coffee-supplies.pdf, deposit-receipt-jan.pdf, plus note: "Merged from 'Brightside Cafe' and 'Brightside Café' on 2026-06-29."

Clients / _merge-log (optional)

merge-log.txt: one line per consolidation recording canonical name, variants folded in, items moved, duplicates removed, and date. Lets you trace any past merge.

Common mistakes

Mistakes that turn a merge into a mess

Merging two records that are actually different clients because the names look alike. Confirm with address and tax/registration ID first; a wrong merge is much harder to unwind than a missed one.
Deleting the losing record before its invoices, receipts, and documents have been moved, which permanently scatters or loses the trail. Empty it completely, then delete.
Leaving both copies of an invoice that existed on each record, which inflates the client's billed-to-date. Reconcile overlaps and keep exactly one copy of each distinct item.
Keeping the casual or misspelled name as the survivor. Standardize on the correct legal/canonical name so future entries land in the right place.
Doing a half-merge and walking away, so the client is now split across the survivor and a not-yet-empty loser. Finish one group entirely before starting the next.
Skipping the merge note, so months later a deleted record looks like missing data instead of an intentional consolidation.

How it helps

How Cash Workspace helps (and what it doesn't do)

One record per client to merge into

Cash Workspace lets you keep a single record per client holding their invoices, expenses, receipts, and documents, which is the destination every merge consolidates toward.

Move records and attachments by hand

You manually relocate each invoice, receipt, and attached file from the duplicate onto the surviving record. The move is deliberate and visible, so you can confirm nothing was left behind.

Search and sort to surface look-alikes

Sorting the client list and searching by a name fragment helps you spot near-identical entries. The detection is yours to do; the workspace does not flag duplicates automatically.

A place for the merge note and totals

Notes on the surviving record (or a simple merge-log record) hold what you folded in, what you removed, and the before/after total, giving you an audit trail for the consolidation.

What it does not do

No duplicate detection, no automatic matching, no reading names out of your uploaded documents, and no bank sync. It is free organization software, not accounting or bookkeeping software, and this page is guidance, not accounting advice.

Client record annual review checklist

Once duplicates are merged, run the yearly pass that refreshes each client's stale address, terms, contact, and rate, the field-currency job that sits next to (but apart from) deduping.

Inactive client record archive folder

After merging, move clients you no longer work with into a standing dormant archive so the active list stays clean while their merged history remains retrievable.

Client billing profile records

Set the single canonical legal name, bill-to address, and tax ID on the surviving record so future invoices land on one entry instead of spawning a new duplicate.

Client account summary sheet

Read a current per-client one-pager of total billed and outstanding on the merged record to confirm the consolidated totals look right.

Duplicate receipt cleanup checklist

The receipt-level cousin of this page: find receipts filed twice (same merchant, date, and amount), keep one, and delete the copies.

Merge finance folders workflow

When two whole folder trees overlap rather than two client records, consolidate the trees and reconcile their duplicates without double-counting.

Finance organization library

Browse the full set of client, invoice, receipt, and document organization guides for Cash Workspace in one place.

FAQ

Questions about merging duplicate clients

Does Cash Workspace find duplicate clients for me?: No. There is no automatic duplicate detection or name-matching. You spot duplicates yourself by sorting and searching your client list, then move records by hand. The workspace gives you the single client record to consolidate into, but the review is manual.
How is this different from the annual client record review?: Merging is the as-needed task of folding two-or-more records for the same client into one. The annual review is a yearly pass that refreshes stale fields (address, terms, rate) on records that already exist as single entries. Deduping fixes a split; the annual review fixes staleness.
Should I delete the duplicate or archive it?: After you have moved every invoice, receipt, and document onto the surviving record, delete the now-empty duplicate so it can't collect new entries. Archiving is for whole clients you no longer work with, and it keeps the record intact rather than emptying it; that is a separate workflow.
How do I avoid double-counting when both records hold the same invoice?: During the merge, find any item that exists on both sides, like one invoice entered under each name, settle on the correct status, keep a single copy, and delete the other. The surviving record's billed-to-date should equal the sum of distinct invoices only.
What if I'm not sure two records are the same client?: Don't merge until you're sure. Compare the bill-to address, the tax or registration ID, the email domain on attached invoices, and the contact. If the evidence is mixed, leave them separate. A wrong merge is harder to unwind than a duplicate left in place.

Organization, not accounting advice

This page is organizational guidance for consolidating duplicate client records, not accounting, tax, bookkeeping, or legal advice. Cash Workspace does not detect duplicates, match records, read names from your uploaded documents, or sync with your bank; finding and merging duplicates is a manual review you perform. Deleting an emptied duplicate record is permanent, so move every invoice, receipt, and document onto the surviving record and confirm the totals before you remove anything. For how merged figures should be treated in your books, consult a qualified professional.

Keep each client in one place, for free

Start a free Cash Workspace and give every client a single record where their invoices, receipts, and documents live together, so a split is easy to spot and easy to merge. It's free, and you can clean up duplicates one group at a time at your own pace. Questions about organizing your client records? Reach the team at info@helperg.com.