Running the AR Balance report

The AR (Accounts Receivable) Balance report shows you exactly what each customer owes at any point in time. Use it to track outstanding invoices, identify overdue amounts, and monitor your cash flow.

Before you start

• You need permission to view reports
• Ensure customer invoices are already recorded in Usystems
• Decide what date range you want to review (optional; the report defaults to all open balances)

Steps

1. Navigate to Reports → AR Balance Report and Open in Usystems.

2. On the Reports page, locate and click AR Balance (or the full title "Accounts Receivable Balance").

3. (Optional) Set any filters:

   • Date As Of: select a specific date to see what was owed on that date
   • Customers: filter to one or more specific customers
   • Status: show only open invoices, or include paid/cancelled

4. Click Generate or Run Report to execute the report.

5. The report displays in a table showing each customer's total balance. Review the amounts and verify they match your expectations.

Accounting impact

This is a read-only inquiry report — it does not create any journal entries or transactions. It pulls data directly from your invoice records.

Tips & common mistakes

• The balance includes all unpaid invoices — even if a payment is recorded but not yet cleared, it may still appear here temporarily. Verify with the Payment records if needed.
• Date As Of matters: if you select a past date, the report shows what was owed then, not today. Leave it blank to see current balances.
• Watch for multi-currency: if you have customers in different currencies, balances are shown separately by currency.