Client records / yearly maintenance

Client record annual review checklist

Client master records drift quietly. A contact leaves, an office moves, terms get renegotiated mid-year over email, your rate goes up in January — and the record you build invoices from still says what it said two years ago. This page is a once-a-year pass to walk every active client record and refresh the fields that go stale: bill-to address, payment terms, billing contact, and agreed rate. It is a field-currency refresh only. It is not about finding duplicate entries (that is a separate merge task), and it is not a year-end review of your books, income, or receivables. The goal is simple: at the end of the pass, every active client record reflects what is true today.

The problem

Why client master data goes stale

Master-data fields are written once at onboarding and then rarely revisited, but the real world keeps changing underneath them. A client moves offices, the person who approves your invoices changes jobs, you agree a new rate over a quick call, or a client switches from Net 30 to Net 45 during a contract renewal. None of those changes announce themselves in your records — you only discover them when an invoice bounces, lands at the wrong address, or quotes last year's rate. A scheduled yearly sweep catches the drift on your terms, not on a client's complaint.

  • A billing contact left months ago and your invoices are still going to a dead inbox or an unmonitored address.
  • The bill-to address on file is the client's old office, so posted or PO-coded invoices miss the right desk.
  • Payment terms were renegotiated mid-year by email, but the record still shows the original Net 15.
  • Your standard rate increased in January, yet the client record still carries last year's number.
  • A registration or tax ID changed when the client restructured, and the stale value rides onto every new invoice.
  • Nobody owns the question 'is this still correct?', so fields are only ever fixed reactively after something breaks.

The yearly pass

How to run the annual review

Pick a fixed date each year — the start of your fiscal year or a quiet week in January works well — and walk every active client record once. The steps below are field-by-field so nothing slips through. Cash Workspace stores and organizes the records; you are the one confirming what is current.

  1. 1

    1. List the records in scope

    Open your Clients folder and list every active client record. Skip clients already moved to your inactive/archive folder — dormant accounts are out of scope here. Note the date you started the pass so you can see at a glance when each record was last confirmed.

  2. 2

    2. Walk the four drift-prone fields per client

    For each client, look at the fields that go stale: bill-to address, payment terms, billing contact, and agreed rate. Read each one and ask 'is this still true today?' Mark anything you can't confirm from memory as Needs check rather than assuming it is fine.

  3. 3

    3. Confirm or correct against a source

    For each Needs check field, confirm the current value from a real source — the latest signed agreement, a recent email thread, the client's current invoice portal, or a quick message to your contact. Update the field in the record and, where it helps, attach the document you confirmed it against (the renewal email, the new rate agreement).

  4. 4

    4. Stamp the record as reviewed

    Add a 'Last reviewed' date and your initials to each record as you finish it. This is the single most useful output of the pass: next year you can see which records were confirmed and when, and spot any that were skipped.

  5. 5

    5. Note anything out of scope for follow-up

    If you spot a duplicate client entry, a client that should be archived, or a books question, jot it on a short follow-up note and route it to the right place — don't try to fix it here. Keep this pass strictly to refreshing fields.

Record structure

Fields to confirm on each client record

These are the master-data fields most likely to have drifted since last year. For each one, the detail notes what to check and what counts as a trustworthy source to confirm against. You are refreshing existing fields, not adding new record types.

Bill-to address
Confirm the client hasn't moved offices or changed the billing entity. Check against their most recent signed agreement or a recent invoice they accepted. Update both street and any suite/floor.
Payment terms
Confirm the term (e.g. Net 30, Net 45, due on receipt) still matches the latest agreement. Mid-year renegotiations are the usual culprit — check the most recent contract or renewal email.
Billing contact name + email
Confirm the accounts-payable contact still works there and the email still reaches them. A quick message or a glance at recent correspondence usually settles it.
Agreed rate
Confirm the standard rate or rate card on file matches what you currently charge this client. Catch annual increases and any client-specific negotiated rate.
Registration / tax ID
Confirm the company number or tax ID is unchanged. These shift when a client restructures or re-registers; verify against a recent official document they sent.
PO-required flag
Confirm whether this client still requires a PO before they'll pay. Procurement policy changes; an outdated flag causes rejected or delayed invoices.
Remittance / payment method note
Confirm any note about how they pay (portal, bank transfer reference, check) is still accurate, especially if they switched AP systems this year.
Last reviewed date
Stamp the date and your initials when you finish the record. This field is what makes next year's pass fast and shows which records have been confirmed.

Example setup

Example: an annual review folder layout

A simple way to organize the pass without disturbing your live client records: keep a small review folder that holds your status sheet and any confirmation documents, while the actual edits happen in each client's own record. Here is one workable layout.

Clients / Annual review 2026

The working folder for this year's pass. Holds the review status sheet and confirmation docs you gather, separate from the live client records you edit.

Annual review 2026 / Review status sheet

One row per active client: client name, the four drift-prone fields, a Confirmed/Needs check/Updated mark per field, last-reviewed date, and reviewer initials.

Annual review 2026 / Confirmation docs

Source documents you confirmed values against this year — e.g. 'Acme Co — renewal Net45 email.pdf', 'Bright Studio — new rate agreement 2026.pdf'.

Clients / Acme Co (record)

The live client record itself. During the pass you update its address, terms, contact, and rate fields here, then stamp 'Reviewed 2026-01-12 — PH'.

Annual review 2026 / Follow-up notes

A short note of out-of-scope items spotted during the pass: a suspected duplicate to merge, a client to archive, or a books question to raise elsewhere.

Common mistakes

Common mistakes to avoid

  • Assuming a field is current because nothing has gone wrong yet — silent drift is exactly what this pass exists to catch.
  • Updating a value from memory instead of confirming it against a real source like the latest agreement or a recent email.
  • Forgetting to stamp a 'Last reviewed' date, so next year you can't tell which records were actually checked.
  • Letting the pass sprawl into merging duplicate records or reviewing income — those are separate jobs; just note them and move on.
  • Reviewing only your biggest clients and skipping the smaller ones, where stale contacts and addresses are just as common.
  • Editing fields without keeping the confirmation document, so there's no record of why the value changed if a client later disputes it.

How it helps

How Cash Workspace helps

Keep all client records in one folder

Organize each client as a record inside a Clients folder, so the annual pass is just walking one list rather than hunting across scattered files.

Attach the proof to the record

When you confirm a new rate or term, attach the renewal email or signed agreement to the client record so the current value always has its source nearby.

Hold the review in its own folder

Create a dated 'Annual review' folder for the status sheet and confirmation docs, keeping this year's pass tidy and separate from the live records.

Reusable checklist, every year

Save the review status sheet as a template you clone each year, so the yearly pass starts from the same structure instead of from scratch. It's free to use.

FAQ

Frequently asked questions

How often should I run this review?
Once a year is the intent of this pass — pick a fixed date, such as the start of your fiscal year. If a specific field changes mid-year (a client moves or renegotiates terms), update that record immediately; the annual pass is the safety net that catches anything you missed.
Is this the same as a year-end review of my books?
No. This is strictly a refresh of client master-data fields — address, terms, contact, rate. It does not touch income, receivables, or your books. A year-end financial review is a separate task with its own checklist.
What if I find two records for the same client?
Note it on a follow-up note and handle it separately. Spotting and merging duplicate client entries is its own job, covered by the merge-duplicate-client-records checklist. Keep this pass to refreshing fields only.
Does Cash Workspace detect stale fields automatically?
No. Cash Workspace does not read your documents, sync with any external system, or flag fields as outdated. You confirm each field against a source and update it yourself; the workspace stores the records, the review folder, and the attached proof.

What this page is and isn't

This is organizational guidance for keeping client reference fields accurate, not accounting, tax, or legal advice. Cash Workspace helps you store and organize client records and attach supporting documents; it does not sync with your bank, read or auto-extract data from your documents, or detect changed fields for you. Confirming what is current and updating each field is a manual step you perform. Operated by HELPERG LLC — questions: info@helperg.com.

Start a free workspace

Keep your client records in one place, attach the proof behind every value, and run a clean yearly refresh. Cash Workspace is free — set up your Clients folder and a dated review folder, and your next annual pass will be a quick walk through an organized list.