Reading and interpreting the Customer Payments report

The Customer Payments report is a summary of all cash received from your customers. Understanding how to read it helps you track payment behavior, identify slow-paying customers, and monitor your cash position.

What the report shows

The Customer Payments report displays a row for each payment received, typically organized by customer. Common columns include:

• Customer Name: the name of the customer who made the payment.
• Payment Date: the date the payment was recorded in the system.
• Amount: the monetary value of the payment, in your base currency or the currency of the transaction.
• Payment Method: how the customer paid (cash, bank transfer, check, etc.).
• Reference/Note: any memo, check number, or bank transaction ID attached to the payment.
• Invoice(s) Applied To: the invoice number(s) that the payment was used to settle.

Why this matters

Regular review of the Customer Payments report helps you:

• Monitor cash flow: see how much money is arriving each day or week.
• Spot trends: identify which customers pay on time and which are slow.
• Verify deposits: match reported payments against bank statements.
• Plan cash: know when large payments are expected to arrive.
• Detect errors: catch duplicate payments or payments recorded against the wrong customer.

How it works in Usystems

When you record a payment in Usystems (either via the Payments section or by marking an invoice as paid), the system creates a payment record linked to that customer. The Customer Payments report pulls all such records from your selected date range and customers, calculating totals by customer if grouped.

If a payment is split across multiple invoices, it may appear as one row with multiple invoice numbers, or as separate rows per invoice, depending on your report settings.

Where you see it

You access this report from Reports → Sales Reports Open in Usystems. Once generated, you can view it on screen, export to Excel or PDF, or print for records.

Related reports you may want to use:

• Contact Balance Report — shows current customer balances (both owed to you and owed by you).
• Accounts Receivable Aging — shows invoices not yet paid, grouped by how old they are.