Multi-client comparison
When you work with more than a handful of clients, the question "who owes me, and who's all paid up?" is buried across separate invoices, folders, and threads. A client-by-client finance overview answers it in one glance: one row per client, with billed, paid, and outstanding sitting side by side so you can compare every client at once. Cash Workspace lets you build that single comparison record by hand and keep it next to the invoices it summarizes. It is free, and it is an organization layer, not accounting software: you decide what each number is and type it in. This page covers only the all-clients comparison view. For one client's full current snapshot use the account summary one-pager, and for a single project's cash read use the per-project view; this overview is the row-per-client roll-up that sits above them.
The problem
Each client lives in its own corner of your workspace, so the totals you actually want to compare are never on the same screen. You can tell whether one specific invoice is paid, but you cannot answer "across all clients, where is the most money still outstanding?" without opening five folders and adding in your head. A flat side-by-side roll-up fixes exactly that, and nothing more.
Build it
The overview is one record with a row per client and the same three money columns repeated down the page. You maintain it by hand from the invoice statuses you already track, so it stays a comparison layer rather than a calculator. Keep it inside the current fiscal-year folder so the numbers all share one period.
Inside your current fiscal-year folder (for example, 2026), add a record named "Client Overview - 2026 (Billed / Paid / Outstanding)". This single record holds every client; you are not making one per client here.
List each client as a row: Northwind Design Co., Harbor Dental Group, Acme Retail LLC, Riverside Bakery. Keep inactive clients out so the comparison stays about who is live right now.
For each client, type Billed (sum of invoices issued this period), Paid (sum marked paid), and Outstanding (billed minus paid). You read these from invoice statuses you already keep; Cash Workspace does not total them automatically.
Order rows by Outstanding to see who owes the most at the top, or by Billed to see your biggest clients. Add an "As of" date so everyone knows how current the snapshot is.
Keep this record flat. When a row needs backup, point to that client's account summary or open-invoice records rather than copying invoice-level lines into the overview.
Update the figures weekly or monthly, stamp a new "As of" date, and export the record when you send your books to your accountant so they get the same one-screen comparison you use.
Record structure
Keep every row to the same small set of fields so the columns line up and the comparison stays honest. These are the metadata you type per client; they are organizational, not calculated.
Example setup
Here is how the comparison record and its surrounding folder might look. The overview itself is a single record; the other folders are where each client's detail already lives and what the overview points to rather than copies.
One row per client, all on one screen: Northwind Design Co. — Billed $22,000 / Paid $22,000 / Outstanding $0 (All paid). Harbor Dental Group — $14,200 / $9,200 / $5,000 (Overdue). Acme Retail LLC — $31,500 / $18,000 / $13,500. Riverside Bakery — $4,800 / $4,800 / $0. As of 2026-06-29.
A folder per client (Northwind Design Co., Harbor Dental Group, Acme Retail LLC, Riverside Bakery) holding their individual invoices and account detail. The overview row links here for backup; it does not duplicate these invoices.
Issued invoices with their statuses (issued, paid, overdue). These are the source you read when you hand-fill the Billed and Paid columns in the overview.
An exported copy of the Client Overview record alongside the supporting invoice records, so the figures you compare match what your accountant receives.
Common mistakes
How it helps
Build a single roll-up record with a row per client so billed, paid, and outstanding sit next to each other and the whole client base fits on one screen.
Store the overview in the same fiscal-year folder as your client folders and invoice records, so the comparison and its backup never drift into separate apps.
Export the overview as part of your handoff so your accountant sees the same per-client comparison you use, alongside the supporting invoice records.
Cash Workspace does not sync with your bank, read your invoices, or reconcile anything automatically. You type each figure from statuses you already track, which keeps you in control of what every number means.
Related
Drill into one client's current snapshot — total billed, outstanding now, terms, and contacts — when a single row in your overview needs the full picture.
Trade the current side-by-side view for a year-over-year grain that shows whether each client's spend is growing or shrinking across multiple years.
Drop below the client level to pair expected inflows and costs for a single project's net-cash read.
A broader client-finance view for organizing one client's invoices, payments, and documents together in a single workspace.
Track the individual overdue invoices behind a client's outstanding column, invoice by invoice.
Zoom out to the structural hub that links invoices, expenses, receipts, clients, and documents across your whole workspace.
Package the overview and its supporting records into a clean export for your bookkeeper or accountant at period end.
FAQ
This client-by-client overview is an organizational layer for comparing clients at a glance, not tax, accounting, or debt-collection advice. Cash Workspace does not sync with your bank, read or extract data from your invoices, or reconcile or total anything automatically — you enter every figure by hand from statuses you already track. Outstanding amounts and status flags are your own notes for review, not guaranteed balances or compliance determinations. For the treatment of any number, check with your accountant.
Start a free Cash Workspace, create one roll-up record, and add a row per client with billed, paid, and outstanding side by side. In a few minutes you will be able to answer "who owes me?" at a glance — and hand the same view to your accountant when it counts. Free to use; operated by HELPERG LLC, info@helperg.com.