Does Cash Workspace calculate the totals automatically?

No. Cash Workspace does not sync with your bank or read your invoices. You read the figures off your own invoice records and type them in. That manual step is what keeps the snapshot a deliberate, accurate read — just remember to re-stamp the as-of date each time you refresh.

How is this different from the client billing profile?

The billing profile is the static master reference — legal name, address, tax ID, remittance details — that rarely changes. The summary sheet is a current-snapshot of the numbers: total billed, outstanding now, plus a quick copy of terms and contacts. Keep both; they do different jobs.

Should I list every invoice on the summary?

No — that would recreate the open-invoice statement. Record current totals plus a single pointer to the oldest open item. The full invoice list stays in your invoice records, which the summary points to rather than duplicates.

How often should I update it?

Refresh whenever you issue an invoice or log a payment, and re-date it. A quick monthly pass is a good safety net. Because nothing updates automatically, the page is only as accurate as your last refresh.

Can I share just this one page with a client?

Yes. Export the single summary record to hand over a clean one-pager showing billed, outstanding, terms, and contacts — without opening the rest of your workspace.

Cash Workspace

Use the Freelancer template

Client finance records

Client account summary sheet: a current-snapshot one-pager per client

When someone asks "where do we stand with Northgate Studios?" you want one screen that answers it — not a scroll through eleven invoices and three email threads. A client account summary sheet is exactly that: a single record per client that holds the numbers as they stand today. Total billed to date, what is outstanding right now, the agreed payment terms, and who to contact about money. It is deliberately a point-in-time snapshot — a clear read of the present, not a multi-year trend and not the full static profile. In Cash Workspace you keep one summary record per client, update the figures when something changes, and always have a tidy one-pager ready to glance at or share. Cash Workspace is free, and it does not sync with your bank or read your invoices automatically — you type in the current numbers, which is what keeps this a deliberate, accurate snapshot rather than a guess.

Start a free workspace See all clients side by side

The problem

Why a per-client snapshot earns its place

Most of your client money information already exists somewhere — in individual invoices, in a follow-up tracker, in the billing profile. The trouble is that none of those gives you the one number people actually ask for: the current state of this one client. A summary sheet sits between the granular open-invoice statement (every line) and the all-clients dashboard (everyone at once). It is the middle altitude: one client, right now, on one page.

A client emails asking for their current balance and you have to add up invoices by hand before you can reply.
You are about to take a call with a client and want a 10-second refresher on terms, outstanding amount, and who handles payment.
Your figures live in five places: invoices, a follow-up list, the billing profile, your inbox, and your memory.
You want a single page you can screenshot or export and hand to a partner without exposing your whole workspace.

Step by step

Building one summary sheet in Cash Workspace

Create one summary record per client and treat it as a living one-pager you refresh whenever the numbers move. Here is a practical order to set it up and keep it current.

1
Create one summary record per client
Inside a Clients folder, make a record named for the client, e.g. 'Northgate Studios — Account Summary'. Keep exactly one per client so there is never ambiguity about which page is the truth. This is separate from the client's static billing profile and from individual invoices.
2
Fill in the current figures
Enter total billed to date and the outstanding-now balance as they stand today. These are numbers you read off your own invoice records and type in — Cash Workspace does not calculate or pull them for you. Add the 'as of' date so anyone reading knows how fresh the snapshot is.
3
Pull terms and contacts in for reference
Add the agreed payment terms (e.g. Net 30) and the key money contacts (who approves, who pays) so the one-pager stands on its own. Treat these as a convenience copy of the source records; the authoritative versions live in the billing profile and billing-contact records.
4
Note the oldest open item, not every line
Rather than listing all invoices, record one pointer: the oldest unpaid invoice number and its age (e.g. 'INV-2041, 38 days'). That keeps the sheet a snapshot while flagging anything that needs attention. The full invoice-by-invoice statement stays where the invoices live.
5
Refresh on a trigger, then re-date
Update the figures whenever you issue a new invoice or log a payment, and re-stamp the 'as of' date. A quick monthly pass works too. Because you update it deliberately, the page is only ever as accurate as your last refresh — so make re-dating part of the habit.
6
Export or screenshot when you need to share
When a client or a partner wants the current state, export the single summary record. You hand over one clean page — billed, outstanding, terms, contacts — without opening the rest of your workspace.

Record structure

What to record on the summary sheet

Keep the field set lean — a snapshot is useful precisely because it fits on one page. These are the fields that answer "where do we stand today" and nothing more.

Client name: The display name this client is filed under, matching the billing profile, e.g. 'Northgate Studios LLC'.
As-of date: The date the figures were last refreshed, e.g. '2026-06-29'. This is the single most important field — it tells the reader how current the snapshot is.
Total billed to date: The cumulative amount you have invoiced this client across the relationship, e.g. '$48,200'. A figure you read off your invoices and enter by hand.
Outstanding now: What is unpaid at this moment, e.g. '$3,150'. The headline number most people are asking for.
Oldest open item: A single pointer to the oldest unpaid invoice and its age, e.g. 'INV-2041 — $1,200 — 38 days'. Flags trouble without listing every invoice.
Payment terms: The agreed terms copied in for reference, e.g. 'Net 30, PO required'. Authoritative copy lives in the billing profile.
Key contacts: Who approves and who pays, e.g. 'Approves: Dana Liu · Pays: ap@northgate.example'. A convenience copy of the billing-contact record.
Status note: One short line of current context, e.g. 'On retainer; June invoice issued, awaiting PO' — not a conversation log, just today's headline.

Example setup

An example layout in Cash Workspace

A simple folder of one-pagers, one record per client. The summary sheets sit alongside — not inside — the detailed invoice and profile records they summarize.

Clients / Account Summaries /

One summary record per client: 'Northgate Studios — Account Summary', 'Bellweather Cafe — Account Summary', 'Orin Consulting — Account Summary'. Each is a single current-snapshot one-pager with an as-of date.

Northgate Studios — Account Summary

As of 2026-06-29 · Total billed to date $48,200 · Outstanding now $3,150 · Oldest open: INV-2041, $1,200, 38 days · Terms: Net 30, PO required · Approves: Dana Liu / Pays: ap@northgate.example · Note: June invoice issued, awaiting PO.

Bellweather Cafe — Account Summary

As of 2026-06-29 · Total billed to date $9,400 · Outstanding now $0 · Oldest open: none · Terms: Due on receipt · Pays: owner@bellweather.example · Note: All caught up.

Clients / Northgate Studios / (source records)

The detail this snapshot draws from but does not replace: the full invoice list, the static billing profile, and the billing-contact record. The summary points to these; it is not a copy of them.

Common mistakes

Common mistakes to avoid

Turning the snapshot into a ledger. If you start listing every invoice and payment, you have rebuilt the open-invoice statement. Keep it to current totals plus the oldest open item.
Forgetting the as-of date. Without it, no one knows whether 'outstanding $3,150' is from today or three months ago, and the page loses its trust.
Treating it as the master profile. Legal name, full address, and tax ID belong in the billing profile; the summary only carries terms and contacts for quick reference.
Adding year-by-year history. Multi-year growth is a separate trend record; this page is strictly the present moment.
Expecting it to update itself. Cash Workspace does not sync banks or read invoices — if you do not refresh and re-date, the snapshot quietly goes stale.

How it helps

How Cash Workspace helps

One record per client, easy to find

Keep all summary one-pagers in a single Account Summaries folder so the current state of any client is one click away.

Reference fields and source records together

Hold the snapshot fields on the summary record while keeping the detailed invoices, profile, and contacts in their own records nearby — organized, not duplicated.

Export a clean one-pager

Export a single summary record to share the current state with a client or partner without opening your whole workspace.

Free and manual by design

Cash Workspace is free. You enter the figures yourself, which keeps the snapshot a deliberate, accurate read rather than an automated guess — there is no bank sync or document reading.

Client billing profile records

The static master profile — legal name, bill-to address, tax ID, terms, remittance — that your summary sheet copies terms from for quick reference.

Client billing contact records

The accounts-payable contacts (who approves, who pays, who to escalate to) that feed the key-contacts line on the snapshot.

Client spend by year records

The multi-year trend view per client — use this when you want growth over time rather than today's point-in-time snapshot.

Unpaid invoice tracker

The invoice-by-invoice view of what is outstanding; the summary sheet's 'outstanding now' figure is read from here.

Client finance dashboard

The all-clients view that compares every account side by side — one level up from a single-client summary sheet.

Finance organization library

Browse the full set of finance-record templates and workflows, including the rest of the client-records cluster.

FAQ

Frequently asked questions

Does Cash Workspace calculate the totals automatically?: No. Cash Workspace does not sync with your bank or read your invoices. You read the figures off your own invoice records and type them in. That manual step is what keeps the snapshot a deliberate, accurate read — just remember to re-stamp the as-of date each time you refresh.
How is this different from the client billing profile?: The billing profile is the static master reference — legal name, address, tax ID, remittance details — that rarely changes. The summary sheet is a current-snapshot of the numbers: total billed, outstanding now, plus a quick copy of terms and contacts. Keep both; they do different jobs.
Should I list every invoice on the summary?: No — that would recreate the open-invoice statement. Record current totals plus a single pointer to the oldest open item. The full invoice list stays in your invoice records, which the summary points to rather than duplicates.
How often should I update it?: Refresh whenever you issue an invoice or log a payment, and re-date it. A quick monthly pass is a good safety net. Because nothing updates automatically, the page is only as accurate as your last refresh.
Can I share just this one page with a client?: Yes. Export the single summary record to hand over a clean one-pager showing billed, outstanding, terms, and contacts — without opening the rest of your workspace.

A snapshot you maintain, not advice

This page is organizational guidance, not accounting, tax, or legal advice. Cash Workspace helps you organize client finance records; it does not sync with your bank, read or extract figures from your invoices, reconcile accounts, or calculate balances for you. The totals on a summary sheet are only as current and correct as the numbers you enter and the date you stamp on them — so refresh and re-date deliberately.

Start your free client summary sheets

Open a free Cash Workspace, create an Account Summaries folder, and build one current-snapshot one-pager per client. Next time someone asks where you stand, the answer is one click away. Questions? Reach the team at info@helperg.com.