Receivables · Aging

Build an aging receivables log with 30/60/90 buckets

When you run a service business, the danger is not the invoice that's a week late — it's the one that quietly drifts past 90 days while you're heads-down on client work. An aging log groups every unpaid invoice by how long it has been outstanding, so the oldest receivables stay at the top of your attention. Cash Workspace gives you one place to record each unpaid invoice and tag it with the bucket you set by hand.

The problem

Why aging receivables slip out of view

Most freelancers track unpaid invoices as a flat list with no sense of age, so a 95-day-old invoice looks the same as one sent yesterday. Without buckets, the oldest and riskiest receivables blend in.

  • A single unpaid list treats a 5-day-late invoice the same as a 100-day-old one.
  • You can't tell at a glance which client owes you the most for the longest.
  • Invoices cross the 90-day mark without anyone noticing until year-end.
  • You re-do the same mental math every week to figure out what's oldest.
  • At tax time you have no clean view of which receivables are still open and how stale they are.

The workflow

Set up and maintain the aging log

Record every unpaid invoice once, then assign and update its aging bucket by hand on a regular pass.

  1. 1

    List every unpaid invoice

    Add a record for each invoice that isn't fully paid, with client, invoice number, amount, issue date, and due date.

  2. 2

    Decide the buckets

    Use Current (not yet due), 1-30, 31-60, 61-90, and 90+ days past due as your fixed set so every invoice fits one.

  3. 3

    Assign a bucket by hand

    Look at today's date against the due date and set the aging bucket field yourself for each open invoice.

  4. 4

    Group by bucket

    Use a folder or grouped view so the 90+ and 61-90 invoices sit at the top where you'll see them first.

  5. 5

    Re-bucket on a schedule

    Once a week, move invoices that have crossed into an older bucket and clear out any that got paid.

Record structure

What to record for each receivable

A consistent set of fields makes the aging buckets meaningful and easy to re-check.

Client
The client who owes the invoice, kept as a consistent client record.
Invoice number
Your reference number so the log ties back to the original invoice.
Amount
The outstanding amount and currency for this invoice.
Issue date
When the invoice was issued, for context on how long the cycle has run.
Due date
When payment was due — the anchor you compare against to choose a bucket.
Aging bucket
A manually set label: Current, 1-30, 31-60, 61-90, or 90+ days past due.
Last reviewed date
When you last re-checked the bucket, so stale entries are obvious.
Follow-up note
A short note on the last contact or next planned step for this receivable.

Example setup

An example aging folder setup

One way to lay out the buckets inside your workspace.

Current (not yet due)

Invoices sent but not past their due date, kept here until the date passes.

1-30 days past due

Recently overdue invoices that usually just need a gentle nudge.

31-90 days past due

Invoices in the 31-60 and 61-90 range, ordered oldest first.

90+ days past due

The oldest receivables, with follow-up notes attached to each.

Common mistakes

Mistakes to avoid

  • Tracking unpaid invoices as one undifferentiated list with no age.
  • Setting a bucket once and never re-checking it as invoices get older.
  • Leaving paid invoices in the buckets so the totals look worse than reality.
  • Using fuzzy buckets like 'old' instead of fixed day ranges.
  • Skipping the weekly pass so 61-90 invoices silently become 90+.

How it helps

How Cash Workspace helps

One place for unpaid invoices

Record every open receivable with client, amount, and dates so the whole picture lives in one list.

Manual aging buckets

Tag each invoice with the bucket you set by hand and update it on your weekly pass.

Grouped folder views

Group invoices by bucket so the oldest receivables stay at the top instead of blending in.

FAQ

Aging receivables FAQ

What are standard accounts receivable aging buckets?
A common set is Current (not yet due), 1-30, 31-60, 61-90, and 90+ days past due. You can use these ranges as fixed labels and assign each invoice to one by hand.
Does Cash Workspace calculate the aging automatically?
No. You compare today's date to each invoice's due date and set the aging bucket yourself; Cash Workspace records the bucket and groups invoices by it so the log stays organized.
How often should I re-check the buckets?
A weekly pass works well for most freelancers — move anything that crossed into an older bucket and remove invoices that got paid.

Organizing help — not tax, accounting, or legal guidance

Cash Workspace is a free workspace for organizing invoices, expenses, receipts, clients, and documents. This page is organizing guidance only — not tax, accounting, legal, or bookkeeping guidance. Cash Workspace does not connect to your bank, does not scan or read your receipts for you, and does not move or collect payments. Whether an expense is deductible depends on your situation, so confirm it with a qualified accountant or tax professional.

Keep your oldest receivables in view

Start a free workspace and record every unpaid invoice with a manual aging bucket so the 90+ day receivables never slip out of sight again.