Reports & Analytics

Reading and interpreting the AR Balance report

Understand what each column means and how to spot patterns in customer debt.

Jul 11, 2026

The AR Balance report is a straightforward list, but understanding its structure helps you spot trends, problem accounts, and cash-flow risks.

What the report shows

The AR Balance report displays one row per customer (or per customer per currency if using multi-currency). Each row includes:

  • Customer Name: the company or individual who owes you money
  • Total Balance: the total unpaid amount in their account
  • Currency (if applicable): the currency in which the balance is recorded
  • Number of Invoices: how many unpaid invoices they have (in some versions)
  • Oldest Invoice Date: the date of their oldest unpaid invoice—use this to spot overdue balances

Why it matters

A rising AR balance usually signals one of three things:

  1. Growing sales: you are invoicing more customers (healthy, but you need to ensure payment)
  2. Slow payment: customers are paying later than expected (cash-flow risk)
  3. Uncollected debt: some customers may not pay at all (write-off risk)

By reviewing AR periodically, you can spot slow payers early and adjust credit terms or pursue collection before amounts become uncollectible.

How to interpret common patterns

  • Many small balances from many customers: typical for high-volume business; set a policy for follow-up below a certain age (e.g., contacts over 30 days old)
  • One or two large balances: may indicate a major customer or a problem account; verify with them directly
  • Balances growing over time: check if payments are delayed or if customers are simply buying more; compare with prior month's report
  • Oldest invoice date is very old: this customer is delinquent; decide whether to pursue payment or write it off

Where you see it in Usystems

Access the AR Balance report via Reports → AR Balance Report Open in Usystems. You can also drill down from individual customer records to see their invoice history.


Was this helpful?

More like this