Recurring customer records

Subscription and Membership Customer Billing Records

If you bill the same customers on a repeating plan — a monthly SaaS seat, an annual gym membership, a quarterly box, a club due — the question that matters most is simple: who is on which plan, at what price, and when does it renew? Cash Workspace gives you one record per recurring customer to hold exactly that: the plan or tier they're on, the price you charge, the next renewal date, and whether the customer is currently active or has lapsed. It is a plan ledger, not billing software. Cash Workspace does not sync with your bank, does not charge cards, and does not send renewal reminders or process payments. What it does well is keep a clean, current, accountant-ready picture of your recurring book — every plan customer in one place, each with their renewal proof attached. It is free.

The problem

Why a recurring-customer ledger is its own record

A subscriber is not the same shape as a one-time client. A one-time client gets billed once for a project; a recurring customer sits on a plan that renews on a cycle, and the live question is always "is this still active, and what are they paying?" When that answer lives in scattered confirmation emails, a payment processor's dashboard you only glance at, and your memory, things slip: you keep counting a customer who quietly lapsed three months ago, you forget who's on the legacy price versus the new one, or you can't tell an accountant how many active plans you actually have. A single record per plan customer — plan, price, renewal date, status — turns "I think" into "I know."

  • Lapsed customers keep getting counted as active because nothing marks the change, inflating your sense of recurring revenue.
  • Old grandfathered prices get forgotten — you can't remember who is still on the $9 legacy tier versus the current $15 plan.
  • Renewal dates live only inside the payment processor or an email, so you never have a clean list of who renews this month.
  • At tax or review time, you can't quickly state how many active plans you hold and at what prices without digging through a dashboard.

Setup

Build your recurring-customer ledger

The goal is one record per recurring customer, grouped so you can read your whole subscription or membership book at a glance. Set it up once, then keep each record current as plans change.

  1. 1

    Create the parent folder

    Make a folder named Subscription Customers (or Members, for a club or gym). Inside, you can split into Active and Lapsed subfolders so a lapsed customer can be moved across rather than deleted — their history stays retrievable.

  2. 2

    Add one record per customer

    Create a record per recurring customer, named so it sorts cleanly — for example Members / Acme Co — Team plan or Members / R. Okafor — Annual Gold. One record holds one customer's current plan, not every invoice they've ever paid.

  3. 3

    Fill the plan fields

    On each record, fill the plan or tier, the price and billing cycle (e.g. $15/month, $180/year), the start date, and the next renewal date. If the customer is on a legacy or discounted price, note that explicitly so it isn't mistaken for the current rate.

  4. 4

    Set the status

    Mark each record Active, Lapsed, Paused, or Trial. When a customer cancels or a renewal fails, change the status and move the record to the Lapsed subfolder with the date — you keep the record, you just stop counting it as active.

  5. 5

    Attach the renewal proof

    Attach the signing or renewal confirmation — the plan agreement, the processor's renewal receipt, or the membership signup form — to the record. Cash Workspace does not read or extract anything from these files; it stores them attached to the right customer so the price and term are evidenced.

  6. 6

    Refresh on each cycle

    When a plan changes — upgrade, downgrade, price increase, cancellation — open the record and update the fields and renewal date. A quick monthly pass down the Active folder keeps the ledger honest and your renewal list accurate.

Record structure

Fields to record per recurring customer

These are the fields that make a plan ledger useful. Keep them consistent across every record so the folder reads as one table.

Customer name
The recurring customer or member as you bill them — e.g. Acme Co, R. Okafor. This anchors the record.
Plan or tier
The specific plan they're on — Team, Pro, Annual Gold, Monthly Basic, Family membership. The single most-asked field.
Price and billing cycle
The amount and how often — $15/month, $180/year, $49/quarter. Note legacy or promotional pricing explicitly if it differs from the current rate.
Status
Active, Lapsed, Paused, or Trial. The flag that decides whether this customer counts toward your live recurring book.
Start date
When the subscription or membership began, so you know tenure and which price era they joined under.
Next renewal date
The date the current term renews or expires — the field that lets you pull a clean who-renews-this-month list.
Last status change
The date you last marked them lapsed, paused, or upgraded — so a stale Active flag is easy to spot.
Renewal proof attachment
The plan agreement, signup form, or renewal receipt attached to the record as evidence of the term and price.

Example setup

An example layout

Here is how a small membership or subscription book might be organized. Folder and record names are examples — adapt the labels to your business.

Subscription Customers / Active

One record per live customer: 'Acme Co — Team plan ($45/mo, renews Aug 1)', 'R. Okafor — Annual Gold ($180/yr, renews Mar 15)', 'L. Park — Monthly Basic ($15/mo, renews 1st)'. Each holds the plan, price, cycle, renewal date, and an attached renewal receipt.

Subscription Customers / Lapsed

Records moved here when a plan ends: 'D. Reyes — Pro (lapsed May 3, last paid Apr)', 'Bright Studio — Team (canceled Feb 12)'. Status is Lapsed; the record and its proof stay retrievable for reference.

Subscription Customers / Trials & Paused

'N. Haddad — Pro trial (ends Jul 9)', 'Vela Co — Team (paused Jun–Aug, resumes Sep 1)'. Kept separate from Active so trials and holds don't get counted as confirmed recurring revenue.

Plan Reference

A short notes record listing your current plans and prices — Basic $15/mo, Pro $29/mo, Team $45/mo, Annual Gold $180/yr — plus any legacy prices still in force, so each customer record can be checked against the live tiers.

Common mistakes

Common mistakes to avoid

  • Deleting a customer's record when they cancel — move it to Lapsed instead, so the history and renewal proof stay retrievable.
  • Leaving the status as Active after a renewal fails or a customer cancels, so your active count silently overstates your book.
  • Logging every past invoice on the plan record — this is a current-plan ledger, not an invoice archive; keep paid-invoice history in your invoice records.
  • Forgetting to flag legacy pricing, so a grandfathered $9 plan gets mistaken for the current $15 rate during a review.
  • Recording a renewal date but never refreshing it after the cycle rolls, so your 'renews this month' view drifts out of date.
  • Mixing one-time project clients into the same folder — those belong in a static client profile, not the recurring-plan ledger.

How it helps

How Cash Workspace helps

One record per plan customer

Each recurring customer gets a single record holding their plan, price, cycle, renewal date, and status — your whole subscription book readable in one folder.

Active and lapsed stay separate

Move a record between Active and Lapsed subfolders instead of deleting it, so you keep history and stop counting customers who have churned.

Renewal proof attached

Attach the plan agreement or renewal receipt to the customer's record so the price and term are evidenced — not stored loose in your inbox.

Accountant-ready export

Export your records when it's time for a review or handoff, so your recurring book travels as organized files rather than screenshots.

FAQ

Frequently asked questions

Does Cash Workspace charge my customers or process subscription payments?
No. Cash Workspace is an organization layer, not billing or payment software. It does not charge cards, process payments, or sync with your bank or your payment processor. You record the plan, price, and renewal date yourself, and attach the renewal proof. Charging and collecting happens in whatever processor you already use.
Will it send renewal reminders automatically?
No. There are no automatic reminders or payment notices. The renewal date is a field you record and read; a quick monthly pass down your Active folder is how you spot what renews soon. This is organizational guidance, not automated billing.
What's the difference between this and a client billing profile?
A billing profile is a static master record for any client — name, address, tax ID, terms. This plan ledger is specifically for recurring customers and centers on the live plan, price, renewal date, and active/lapsed status. A one-time project client belongs in a profile; a repeating subscriber belongs here.
How do I handle a customer who cancels?
Change their record's status to Lapsed, note the date, and move the record into your Lapsed subfolder. You keep the record and its attached proof for reference rather than deleting it — and your active count stays accurate. For the formal closeout filing, see the subscription cancellation checklist.
Can I track memberships, not just software subscriptions?
Yes. The same record shape works for any recurring plan — gym and club memberships, box subscriptions, retainers, dues. Use Members or Subscribers as your folder name and record the tier, price, cycle, and renewal date the same way.

What this page is and isn't

This is organizational guidance for keeping recurring-customer records, not tax, legal, or accounting advice. Cash Workspace is not billing software or certified accounting software: it does not sync with your bank, charge cards, process payments, read or extract data from your documents, or send renewal reminders. It stores the plan details you enter and the proof files you attach. How you recognize subscription revenue or report it is between you and your accountant. Operated by HELPERG LLC — questions to info@helperg.com.

Start a free recurring-customer ledger

Bring every subscriber and member into one place — plan, price, renewal date, and status, each with its renewal proof attached. Open a free Cash Workspace and create your first plan record in a few minutes. It's free, and there's nothing to install.