Reports & Analytics

Reading and interpreting the Contact Balance (Summary & Detail) report

Understand what each balance means and how to spot aging or overdue amounts.

Jul 11, 2026

The Contact Balance report is central to managing receivables and payables. Understanding what you see helps you follow up with customers, manage vendor payments, and spot problems early.

What it shows

Summary mode displays:

  • Contact name — the customer or vendor.
  • Balance — the total amount owed to you (positive) or by you (negative). Positive means the contact owes you; negative means you owe them.
  • Document count — how many invoices, bills, or other transactions make up this balance.
  • Oldest transaction date — when the earliest unpaid document was created.

Detail mode adds a row for each transaction:

  • The document type (Invoice, Bill, Sales Receipt, etc.).
  • Document date and number.
  • Amount on that specific transaction.
  • Running balance at that point.

How to read balances

A positive balance means a customer owes you money (accounts receivable).
A negative balance means you owe a vendor money (accounts payable).
A zero balance means the contact is settled (no open documents).

Spotting aging and overdue amounts

Look at the Oldest transaction date:

  • If it is more than 30 days old and the balance is still unpaid, it is aged and may be overdue.
  • Most businesses aim to collect receivables within 30–60 days and pay payables on the vendor's terms (often 30–45 days).

If a contact's balance has been unpaid for a long time, it may indicate a cash flow problem, a dispute, or an invoice that was never processed. Follow up promptly to clarify.

Where you see it in Usystems

You can run Contact Balance from Reports → Contact Balance and optionally filter by date, contact type, or account. The report updates in real time as you create invoices and receive payments.

Was this helpful?

More like this