Customer Statement

Generates a customer statement for a specified time interval. It's usually sent to the customers to give them an overview of outstanding amounts and also as a reminder to pay any overdue amounts.

Feature details

If you open the Customer Statement report from the Customers list page or the role explorer, you'll find the following options in the Statement Style field on the request page:

image-20240205-124703.png

 

  • Balance gives customers an overview of outstanding amounts and a reminder to pay amounts that are overdue.

  • Open Items does the following:

    • Shows only open entries within the specified date range.

    • Shows a balance for open entries before the start date.

    • Ignores entries that have a posting date that's after the ending date.

You can choose to show the overdue amounts in a separate section.

You can include an aging band, you typically set 30D, which means 30 days intervals such as30, 60, 90, and 90+ days overdue, from the ending date, or 1M+CM, which will be 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 separate action, Scheduled Statements. This option does not filter to the customer you have selected. It's the same report but used when you want to send statement to all/more customers. You can filter the report so that it shows only entries that are still open for the customer. To apply the filter when you're setting up the report, in the Statement Style field, choose Open Items.