Reading and interpreting the AR Balance report

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.