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

What it is

The Customer Balance report is a financial statement that lists each customer and their current balance—the amount they owe you (positive balance) or the credit available to them (negative or pre-paid balance).

Why it matters

Knowing your customer balances helps you:

• Identify customers with overdue amounts due, so you can follow up on collections.
• Spot customers who have paid in advance or have credit notes, which can be applied to future invoices.
• Understand your overall Accounts Receivable position (the money owed to you).
• Manage cash flow by prioritizing collections on large, overdue balances.

How it works in Usystems

The report is generated from your Accounts Receivable (AR) ledger, which tracks all invoices, payments, credit notes, and adjustments for each customer.

In Summary view, you see:

• Customer name (or code): The customer's identifier.
• Balance: The net amount owed (invoices minus payments and credits).
• Currency: The invoice currency (if you use multiple currencies).

In Detail view, you also see:

• Transaction date: When each invoice, payment, or adjustment occurred.
• Transaction type: e.g., Invoice, Payment, Credit Note, or Adjustment.
• Amount: How much that transaction added to or reduced the balance.
• Running balance: The cumulative balance after each transaction.

Where you see it

Access the Customer Balance report at Reports → Receivables & Payables Reports → Customer Balance (Summary & Detail).

You can also access AR detail ledgers for a single customer by opening the customer's page and viewing their transaction history (if your system has that feature enabled).

Common balance scenarios

Positive balance (amount owed): The customer has unpaid invoices. Example: Customer owes 10,000 AFN.

Negative balance (credit/advance): The customer has paid in advance, or you issued a credit note. Example: Customer has a 2,000 AFN credit available.

Zero balance: The customer has no outstanding transactions (all paid or settled).