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:
- Growing sales: you are invoicing more customers (healthy, but you need to ensure payment)
- Slow payment: customers are paying later than expected (cash-flow risk)
- 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?