The Customer Statement report generates account activity, balance, aging, and open items for one customer.
What this report is for
Use Customer Statement when you need to review or send one customer's account activity.
The statement combines transaction history with an aging summary and open items as of today.
Screen path
Dashboard > Sales > Reports > Customer Statement
Filters and actions
| Control | What it does |
|---|---|
| Customer search | Searches active customers by customer code or name. |
| Start date | Optional beginning transaction date. |
| End date | Optional ending transaction date. |
Generate |
Builds the customer statement. |
Copy for Excel |
Copies statement transactions, aging, and open items to the clipboard. |
Print PDF |
Downloads a statement PDF. |
If no start or end date is entered, the statement shows all transactions returned for the customer.
Statement sections
| Section | What it shows |
|---|---|
| Customer header | Customer name and customer code. |
| Balance summary | Beginning balance when a start date is selected, plus ending balance. |
| Transactions | Date, invoice, type, customer PO or description, charges, and credits. |
| Aging Summary | Current, 1-30, 31-60, 61-90, 91+ days, and total due as of today. |
| Open Items | Open invoices and available credits with original amount, credits/adjustments, balance due, and bucket. |
Transaction types can include:
InvoiceCash ReceiptReturn CreditDiscountCredit on AccountCheck IssuedRestocking Fee
What happens behind the scenes
PAX reads customer, invoice, payment, return, discount, available credit, refund check, and restocking fee data for the selected customer.
When a start date is selected, PAX calculates a beginning balance from activity before that start date. The transaction list then uses the selected date filters.
The aging summary is calculated as of today, not as of the report end date. Available unlinked customer credit is applied against aging buckets before total due is shown.
Print PDF generates a PDF using the statement data and tenant company configuration. It does not change customer balances or mark the statement as sent.
Running, copying, or printing the statement does not update invoices, payments, returns, customer credit, or accounting.
Troubleshooting
Generate is disabled
Likely cause: A valid customer has not been selected.
Safe fix: Search by customer code and select the customer from the list.
Contact support if: The customer is active but cannot be selected.
The transaction list date range differs from aging
Likely cause: Transaction dates follow the selected statement range, but the aging summary is always as of today.
Safe fix: Use the transaction list for period activity and the aging/open items section for current balance review.
Contact support if: Current aging does not match AR Aging for the same customer.
PDF download fails
Likely cause: The browser blocked the download or PDF generation failed.
Safe fix: Generate the statement again and retry Print PDF.
Contact support if: PDF download fails repeatedly for the same customer.