Outstanding balance report: how to see who owes you money (2026)

"Crazy you can't pull a report on outstanding balances." That is a paying customer, in the HoneyBook Community, asking for the single most basic view a business can want: who owes me money, and how late is it? If your invoicing tool cannot answer that in one screen, you end up building it in a spreadsheet — and a spreadsheet that depends on your memory is always slightly wrong. This guide covers what a good outstanding balance report shows, the weekly rhythm that keeps it clean, and how to run it in professional services billing software where the report sits beside the client record.

Quick answer

An outstanding balance report lists every unpaid amount: open invoices not yet due, overdue invoices sorted into aging buckets (1–30, 31–60, 61–90, 90+ days), and totals per client. Review it weekly for 15 minutes, work it oldest-first, and keep the report in the same tool as the invoices and the client conversation — so a number on a report is one click from the follow-up that collects it.

What a good report actually shows

A balance total is not a report. To be useful, the view needs four things:

• Open invoices. Everything issued and unpaid, including amounts not yet due. This is your incoming cash, before anything goes wrong.
• Overdue invoices. The subset that has crossed its due date — the list that needs action this week, not eventually.
• Aging buckets. Overdue amounts grouped by how late they are: current, 1–30, 31–60, 61–90, and 90+ days past due. Buckets turn a flat list into a priority order, because a 4-day-late invoice and a 74-day-late invoice are different problems.
• Totals by client. One client with five small late invoices is a relationship problem; five clients with one each is a process problem. You cannot see that in a grand total.

Two extra columns earn their place: the payment terms each invoice went out with, and the last follow-up date. Chasing a client you already chased yesterday is how good accounts go cold.

The weekly rhythm that keeps it clean

The report only works if someone looks at it on a schedule. A 15-minute weekly review, same time every week:

1. Start with the oldest bucket. Anything at 60 or 90+ days gets a decision today: a direct call, a written payment plan, or an escalation. Old receivables do not fix themselves.
2. Work the 1–30 bucket with reminders. These usually pay from a nudge — a friendly note with the payment link, not a confrontation.
3. Check what is about to come due. A reminder sent two days before the due date is the cheapest collection tool there is.
4. Clear the data. Mark disputed invoices, promised dates, and partial payments so next week's report reflects reality.

That is the whole system. Businesses that drown in receivables rarely lack effort — they lack the standing appointment. Our late payment follow-up sequence gives you the actual reminder wording for each stage, and the how to get paid faster guide covers prevention on the invoicing side: deposits, shorter terms, and online payment links.

One more habit belongs in that weekly review: read the report as a forecast, not just a to-do list. The open column is next month's cash, so a week where "open" shrinks and "overdue" grows is a cash-flow warning before it shows up in the bank balance. And when the same client lives in the 60+ bucket every month, the report is telling you to change the terms — a deposit up front, shorter due dates, or work paused until the balance clears — rather than to chase harder.

From report to follow-up without losing the thread

A report tells you what is late; it does not tell you why. Was the invoice received? Is there a dispute? Did the client's AP person change? That context lives wherever the conversation lives — and if the conversation is in a different tool from the balance, every follow-up starts with archaeology.

This is the deeper problem in that community thread: the tracking was removed from the invoicing tool, so the numbers lost their home. When a balance sits beside the client record — the invoice, the signed proposal, the project status, the email and call history — the follow-up writes itself. You are not reconstructing the story; you are continuing it.

How Workspace369 reports receivables

Workspace369 keeps receivables reporting in the same workspace as the work: open and overdue invoices, AR aging buckets, and per-client totals, with each number one click from the client record that produced it. The invoices feature page shows how billing connects to the record — invoice, payment link, reminders, and history together. Invoices and online payment links are on every plan from Cadet at $29/month, so the report above is not an enterprise feature.

For clients who genuinely cannot pay in one go, the answer is a structured plan rather than a drifting balance — how to set up payment plans for clients covers the deposit-plus-schedule pattern (payment plans are included from the Specialist plan at $149/month for five seats).

The bottom line

You should never have to wonder who owes you money. A report with open, overdue, aging buckets, and per-client totals — reviewed for 15 minutes every week — keeps receivables small and conversations friendly. Run it where the invoices and the client history already live.

Start a 14-day trial — invoices, payment links, and AR reporting from $29/month — or see Workspace369 pricing for the full plan breakdown.