Customer Statement (report)
The Customer Statement report shows a customer statement for a specified period of time.
You can choose to show the overdue amounts in a separate section.
Similar to the Aged Receivables report, you can include an aging band. For the aging band, businesses often set 30D. 30D means 30 day intervals such as 30, 60, and 90 days overdue. The intervals start from the ending date, or 1M+CM. 1M+CM is the current month in a separate interval and then monthly intervals for the preceding months.
Note
In the customer list, this report also has a Scheduled Statements action. This action doesn't filter to the selected customer. It's the same report, but you use it when you want to send statements to one or more customers. You can filter the report to only show open entries for the customer. To apply the filter when you're setting up the report, in the Statement Style field, choose Open Items
Use cases
Send customers an overview of outstanding amounts, and also use as a payment reminder about overdue amounts.
Accounts receivable professionals use the report to:
- Generate customer statements for a specified time period to provide a clear view of all outstanding balances and transactions for the customer.
- Help reconcile customer accounts and ensure that all transactions are accurate and complete.
- Provide customer support by answering questions related to customer statements and resolving discrepancies or errors.
Collections specialists use the report to:
- Follow up with customers on overdue amounts and provide payment reminders based on the aging band used in the report.
- Analyze customer payment history and identify patterns or trends in late payments to proactively address potential issues.
- Prepare collection reports or dashboards for internal or external stakeholders.
Customer service representatives use the report to:
- Provide customers with an overview of their outstanding amounts and transaction history and help them understand the status of their account.
- Help answer customer inquiries related to their account, and provide support in resolving issues or discrepancies.
- Get data to prepare customer account summaries or sales reports for internal or external stakeholders.
Try the report
Try the report here: Customer Statement
Tip
If you press CTRL and choose the report link, the report opens in a new browser tab. This allows you to stay on this page while you explore the report in the other browser tab.
See also
Accounts receivable report overview
Key finance report overview
Ad hoc analysis on finance data
Financial analytics overview