Clients - Spend by Year/
Top-level folder. Holds one record per client plus a README note stating the shared basis (invoiced, fiscal year) and how trend tags are applied across the whole folder.
Client finance records / multi-year trend
Client spend-by-year records
Some clients grow with you for years. Others quietly taper off — a smaller project this year, nothing the next — and you only notice when you stop and add it up. A client spend-by-year record gives each client one row of yearly totals: 2022, 2023, 2024, 2025, side by side. Read across the row and the story is obvious. This page shows you how to set up that multi-year view in Cash Workspace, what to record per year, and how to keep it honest. It is a free, organize-only workspace: you enter or paste the figures and attach the proof — Cash Workspace does not connect to your bank, does not read your invoices, and does not calculate totals for you. Think of it as a clean, durable home for numbers you already know, arranged so the trend jumps out.
The problem
Why a year-by-year view, and why it usually doesn't exist
Most businesses can tell you what a client owes right now, or what they billed last month. Almost none can tell you, without digging, whether that client spent more or less with them than three years ago. The yearly numbers exist — they're buried inside invoice folders, old statements, and accounting exports — but they're never lined up where you can compare them. The cost is real: a flagship account that has shrunk 40% over four years can hide behind one decent recent month, and a small client steadily doubling each year can go unnoticed until they ask for a discount you'd happily have given. This record fixes only that one gap: it lines up each client's annual spend totals so the multi-year direction is readable at a glance.
- Yearly totals live in different places — last year's accounting export, this year's invoice folder, a statement from the year before — so no one ever lays them side by side.
- A single strong recent month masks a multi-year decline; a slow steady climb goes unrewarded because nobody compared 2022 to 2025.
- Renewal and rate conversations happen with no sense of where the account has been heading over several years.
- When a client goes quiet, there's no record showing the year they peaked or the year the drop-off started.
- 'How much has this client spent with us, all-time?' takes an afternoon of digging instead of one glance at a row.
Setup
Building the spend-by-year record in Cash Workspace
The structure is deliberately simple: one record per client, one figure per year, with the source for each figure attached so the number can be trusted later. You bring the totals — from your own invoice records, year-end statements, or accounting export — and Cash Workspace keeps them lined up.
- 1
Make one folder, one record per client
Create a folder named Clients - Spend by Year. Inside, add one record per client: Acme Retail - Spend by Year, Northwind Studio - Spend by Year, and so on. One record holds every year for that one client, so the trend lives in a single place rather than scattered across annual folders.
- 2
Add a row for each year you can source
Within each client record, enter a line per year: 2022, 2023, 2024, 2025. For each line record the total invoiced (or total paid — pick one basis and keep it consistent) for that calendar or fiscal year. Don't invent figures for years you can't verify; leave them blank and note why.
- 3
Attach the source behind each year's number
For every yearly figure, attach the proof it came from: that year's year-end statement, the annual income summary, or an export of that client's invoices. This is what separates a defensible record from a guess you'll second-guess in a year. Cash Workspace stores the attachment with the line; it does not extract the number from it for you.
- 4
Note the basis and any one-off distortions
Add a short note per record stating the basis (invoiced vs received, calendar vs fiscal year) and flagging anything that distorts a year — a one-time large project, a credit, a paused contract. A 2024 spike that was a single migration project shouldn't read as organic growth.
- 5
Read the row and tag the direction
With the years lined up, read across: rising, flat, declining, or dormant. Optionally tag each client record (Growing / Steady / Shrinking / Dormant) so the folder doubles as a quick segmentation of your book. Keep this as your read of the numbers, not a forecast.
- 6
Refresh once a year and lock the prior year
At year-end, add the just-closed year's total to every client record, attach its source, and treat earlier years as settled. Export the folder when you want an offline copy or something to hand to a partner or accountant for context.
Record structure
What to record per client
Keep each client record lean — identity at the top, then one line per year. These are the fields that make the multi-year trend readable and the figures verifiable.
- Client name + internal ID
- The client this record belongs to, matching how they appear elsewhere in your workspace (e.g. Acme Retail / CL-0142) so the spend record ties back to their profile.
- Year
- The calendar or fiscal year the figure covers (e.g. FY2024). One line per year, kept in order so the row reads chronologically.
- Total spend for the year
- The single annual figure for that client — total invoiced or total paid. The number you're trending; everything else supports it.
- Basis
- Whether the figure is invoiced or received, and calendar vs fiscal — recorded once and kept identical across all years so the comparison is apples to apples.
- Source attachment
- The document the figure came from: year-end statement, annual income summary, or that year's invoice export, attached to the line as proof.
- Year note / distortion flag
- A short note on anything unusual — a one-off large project, a paused contract, a credit applied — so an outlier year isn't misread as a trend.
- Trend tag (optional)
- Your read of the direction after lining up the years: Growing, Steady, Shrinking, or Dormant — a label, not a projection.
- Last refreshed
- The date you last added a year or updated a figure, so you know the record is current through which year-end.
Example setup
An example layout
Here's how a small agency's spend-by-year folder might look. Each client is one record; each record carries four years lined up with the source attached behind every figure.
Acme Retail - Spend by Year.record
2022: $18,400 · 2023: $26,900 · 2024: $41,200 · 2025: $44,800. Tag: Growing. Each line has that year's invoice export attached. Note: 2024 includes a one-off $12k site rebuild.
Northwind Studio - Spend by Year.record
2022: $33,000 · 2023: $31,500 · 2024: $19,800 · 2025: $9,200. Tag: Shrinking. Year-end statements attached per line. Note: retainer dropped from monthly to ad-hoc in mid-2024.
Harbor Cafe Group - Spend by Year.record
2022: $7,100 · 2023: $7,400 · 2024: $7,250 · 2025: $7,600. Tag: Steady. Annual income summary attached per year. Flat, dependable account.
Old Mill Press - Spend by Year.record
2022: $14,500 · 2023: $4,000 · 2024: (blank) · 2025: (blank). Tag: Dormant. 2024-25 left blank with note: no work commissioned since Q1 2023.
_README - basis and tags.note
States the folder's rules: figures are total invoiced, fiscal year Jan-Dec; tags reflect the reader's view of direction, not a forecast; blank years mean unverified or no activity, never zero by assumption.
Common mistakes
Mistakes that make the trend lie to you
- Mixing bases across years — invoiced one year, received the next — so a flat client looks like it jumped. Pick one basis and hold it.
- Filling unverified years with a guess instead of leaving them blank, turning a gap into a fake data point.
- Letting a one-off large project read as growth because no distortion note was added next to it.
- Treating the year-by-year record as a live current balance — it isn't; for what a client owes right now, use a current-snapshot summary, not this trend record.
- Comparing partial years to full years (a client onboarded in October vs a full prior year) without flagging it.
- Never refreshing — the record stops two years back and quietly becomes useless for the conversation you're having today.
How it helps
How Cash Workspace helps (and what it leaves to you)
One durable record per client
Each client gets a single record holding every year, so the multi-year row stays together instead of fragmenting across annual folders. You can find and read any client's history in seconds.
Proof attached to every figure
Attach the year-end statement, income summary, or invoice export behind each yearly total. The number and its source live together, so a figure you entered two years ago is still defensible.
Your numbers, entered by you
You type or paste the totals you've already calculated. Cash Workspace does not sync with your bank, does not read attached documents, and does not sum your invoices — it organizes what you bring.
Tags and notes for fast segmentation
Optional Growing/Steady/Shrinking/Dormant tags and per-year distortion notes turn the folder into a quick read of your whole client book without adding any automation.
Export when you need it elsewhere
Download the folder for an offline copy, a partner review, or to give an accountant context. The workspace stays the organizing layer, not the system of record for your accounting.
Related
Related records and workflows
Client account summary sheet
The current-snapshot counterpart: total billed to date, outstanding now, terms, and contacts on one page. Use it for where a client stands today, not the multi-year trend this page builds.
Client profitability tracker
Pairs spend with the cost to serve, so a high-spend client that's expensive to deliver doesn't look better than it is. The margin lens beside this revenue-trend lens.
Client-by-client finance overview
Compares all clients side by side at one moment (billed/paid/outstanding). Where this page trends one client over years, that page compares every client right now.
Client estimate vs final record
Per-client history of quoted vs finally-billed amounts to sharpen future quoting. A different relationship history — quoting accuracy rather than total yearly spend.
Income by month summary folder
Trends your whole-business income across months of a year, including seasonality. The business-wide companion to this per-client, year-over-year view.
Client finance dashboard
A single client's finance picture pulled into one place. Useful when you want depth on one account beyond just its yearly spend totals.
Finance organization library
The full index of Cash Workspace record types and workflows, if you want to see where the spend-by-year record fits among client and invoice records.
FAQ
Common questions
- Does Cash Workspace calculate the yearly totals for me?
- No. You enter the annual figure for each client and year yourself, from totals you've already worked out in your invoice records, year-end statements, or accounting export. Cash Workspace does not sum invoices, read attached documents, or connect to your bank — it organizes and stores the numbers and proofs you provide.
- How is this different from a client account summary sheet?
- The account summary is a current snapshot — what one client has billed to date and owes right now. This spend-by-year record is a multi-year trend: one figure per year, lined up, so you read direction over time. Use the summary for today's position and this record for the long arc.
- What if I don't have reliable figures for older years?
- Leave those years blank and add a note explaining why (records not migrated, no activity, unverified). Never fill a gap with a guess — a blank year is honest, a fabricated total quietly corrupts the trend you're trying to read.
- Can I use this to forecast next year's spend or for tax planning?
- It's a record of what happened, not a forecast or a tax tool. The trend tags reflect your own read of past direction. Cash Workspace gives organizational structure, not financial, tax, or accounting advice — talk to a qualified professional for projections or filing decisions.
What this record is — and isn't
A spend-by-year record is organizational guidance, not financial, tax, or accounting advice. Cash Workspace stores the yearly figures and source documents you enter; it does not sync with your bank, does not read or extract numbers from attached files, does not total your invoices, and is not accounting or bookkeeping software. The totals and any growth/decline reading are yours, based on figures you bring. For projections, valuations, or anything you'll act on financially, consult a qualified professional. Cash Workspace is free and operated by HELPERG LLC (info@helperg.com).
Line up your clients' years in one place
Start a free Cash Workspace, create a Clients - Spend by Year folder, and add a record for your biggest account. Drop in the totals you already have, attach the source behind each one, and read the row. The trend you've been guessing at becomes something you can simply see.