Customer - Balance to date (report)
The Customer - Balance to date report shows the open customer ledger entries until the ending date.
This report shows similar content as the customer statement but with no indication if the entry is overdue.
Note
The date filter applies to the detailed customer ledger entries. You might have payments later than the ending date that are applied to invoices within the date range. Those invoices appear in the report because they weren't closed by the ending date.
Use cases
Sales representatives use the report to:
- Track the payment status of customers and follow up on overdue balances.
- Identify the customers with the highest outstanding balances and follow up to help collection efforts.
As a sales manager, use the report to:
- Monitor the performance of sales representatives in terms of collecting payments from customers.
- Identify customers that might be bad for
As an accounts receivable specialist, use the report to:
- Identify customers who have overdue balances and take appropriate actions to collect payments.
- Review the payment history of customers and investigate discrepancies or potential issues.
- Monitor the aging of customer balances and prioritize collection efforts based on the level of delinquency.
As a finance manager, use the report to:
- Analyze the performance of the accounts receivable function, such as average collection period and bad debt ratio.
- Monitor the cash flow and liquidity of the company by reviewing the accounts receivable balance.
- Review the customer aging report to identify trends and potential risks to the company's financial health.
Try the report
Try the report here: Customer - Balance to date
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
Sales reports
Ad hoc analysis of sales data
Sales analytics overview