Printing Customer Statements

To print statements for one customer, all customers, or a range of customers, use the Customer Statements Report. You can also use this report to print statements for the statement cycle you define for each customer using the Customers form.

After making any changes to the selection criteria for this report, to print the report, click Print.

The statements list the open item transactions and the total amount each customer owes, along with the customer's amount due in each of the five aging buckets. The report also lists the Apply to Invoice number when printing payments, debit memos, and credit memos that are not open.

The report displays (Unapplied) Finance Charges first, followed by Open (Unapplied) Credit Memos, Debit Memos, and Payments, and lastly, Invoices in descending order. Each Invoice is followed by Credit Memos, Debit Memos, Finance Charges, and Payments applied toward the individual Invoice.

You can print statements for particular cycles and for ranges of customers. You can elect to include or exclude zero balance and credit balance customers. You can also elect to omit invoices that are older than a specific number of days. In addition, you can elect to print:

  • Aged totals
  • Open payments
  • Active transactions only
  • Euro totals
  • All posted transactions or only old ones

Transactions are displayed in the transaction currency and total amounts are displayed in the customer currency.

You can produce the statements for a particular site group's customers, or for customers in all site groups. You can also select the aging basis for the statements by invoice date or by due date, and can specify the date of the statements.

If an invoice has multiple due date payment terms, a line will print for each scheduled payment that has not been completely paid.