Running the Customer Balance (Summary & Detail) report

What this does

The Customer Balance report shows how much money each of your customers owes you (outstanding invoices) or has credited to their account (advance payments or overpayments). You can view the data in summary form (one line per customer) or in detail (all transactions included).

Before you start

• You must have at least view access to the Reports section.
• You need to have existing customer transactions (invoices, payments, or receipts).
• Decide whether you want Summary view (totals only) or Detail view (line-by-line transactions). Both are available in the same report.

Steps

1. Go to Reports on the main menu. Open in Usystems

2. Under Receivables & Payables Reports, select Customer Balance (Summary & Detail).

3. Choose your report view:

   • Summary: Shows one row per customer with their total balance (amount owed or credit).
   • Detail: Shows every transaction contributing to that balance.

4. Set any filters you need (date range, specific customers, currency, etc.). See "Filters and options" for details.

5. Click Run Report (or the equivalent button on the report form).

6. The report displays on screen. You can now read it, export it, or print it.

Accounting impact

This report pulls data from your Accounts Receivable (AR) ledger. It includes all unpaid invoices and any advance payments or credit notes for each customer. The balances are calculated at the reporting date you select, typically today's date.

Tips & common mistakes

• Timing: Run the report at the end of your business day or cycle to get accurate closing balances.
• Filters: If a customer appears missing, check whether they have a transaction date outside your filter range.
• Currencies: If you work in multiple currencies, the Summary view shows each customer's balance in the currency they were invoiced in; use the currency filter to isolate one currency if needed.