Statements

A statement is a summary of financial activity for a given period.

Important! You should only print statements once. Each time you print statements for a balance forward customer the unpaid invoices that were printed on the last statement will appear on the new statement as the Balance Forward amount without any invoice detail.

Important! If you need to reprint a statement, enter the statement end date for the statement that needs to be reprinted, or set up the selection criteria to select a customer number or customer number range.

In this Topic

Statements
1. Printing statements
1. Reprint statements
  1. Step 1: Delete statement date
  1. Step 2: Reprint statement
1. Age using
1. Credit balance customers
1. Customers with a balance and no current activity
1. Due date
1. Forms
1. Full invoice amount and all associated transactions
1. Mailing date
1. Print separate bill-to statements
1. Statement end date
1. Zero balance customers
1. Related Topics

Printing statements

1. Open Connect Accounts Receivable > Reports > Statements.

2. Select a report title.

3. Enter the Statement End Date.

The statement end date is the last date in the billing period.

What is the statement end date?

Prompt me to enter the due date when the report prints. Leave the Statement End Date field blank.
Let me enter the due date. Click Advanced Options to change variable the system is using to set the statement end date. If you would like to select a different day, because the due date falls on a weekend for example, select the Calendar Date option. Then, you can click the Calendar button to choose a different date

4. Enter the Due Date.

The due date is the date when payment is owed.

What is the due date?

Prompt me to enter the due date when the report prints. Leave the Due Date field blank.
Let me enter the due date. Click Advanced Options to change variable the system is using to set the due date. If you would like to select a different day, because the due date falls on a weekend for example, select the Calendar Date option. Then, you can click the Calendar button to choose a different date.

5. Enter the Mailing Date.

The mailing date is the date the statement will be sent.

What is the mailing date?

Prompt me to enter the mailing date when the report prints. Leave the Mailing Date field blank.
Let me enter the mailing date. Click Advanced Options to change variable the system is using to set the due date. If you would like to select a different day, because the due date falls on a weekend for example, select the Calendar Date option. Then, you can click the Calendar button to choose a different date.

6. Include Customers with a Balance and no Current Activity.

Use this option to search for customers that have a balance on their account without any activity in the current period.

Do you want to print statements for customers with a balance and no current activity?

Yes, print statements for customers with balances and no current activity. Click to select Customers with a Balance and No Current Activity.
No, do not print statements for customers with balances and no current activity. Click to clear Customers with a Balance and No Current Activity.

7. Include Zero Balance Customers.

Use this option to search for customers that have an account balance equal to zero (0) AND have transactions recorded during the report range.

Do you want to print statements for customers with a zero-balance?

Yes, print statements for customers with a zero balance. Click to select Zero Balance Customers.
No, do not print statements for customers with a zero balance. Click to clear Zero Balance Customers.

8. Include Credit Balance Customers.

Use this option to search for customers that have a credit balance, an overpayment, on their account.

Do you want to print statements for customers with a credit balance?

Yes, print statements for customers with a credit balance. Click to select Credit Balance Customers.
No, do not print statements for customers with a credit balance. Click to clear Credit Balance Customers.

9. Include Full Invoice Amount and All Associated Transactions.

The full invoice amount is the sum of sequences on an invoice including fees, penalties, and so on. Associated transactions includes other transactions created based on the invoice.

Do you want to show the full invoice amount, including associated transactions, on the statement?

Yes, show the full invoice amount and all of the associated transactions for each open invoice. Click to select Full Invoice Amount and All Associated Transactions.
No, show only the invoice open balance; applied transactions from prior statement periods will not be shown. Click to clear Full Invoice Amount and All Associated Transactions.

10. Set up the Print Separate Bill-To Statements checkbox.

A bill-to is set up when a third party is billed instead of the account holder. When an account has more than one bill-to address, you can use this option to send a statement to each bill-to address.

Do you want to print a statement for each bill-to address?

Yes, print a statement for each bill-to address. Click to select Print Separate Bill-to Statements.
No, print a statement for the primary account holder; do not print any statements for bill-to addresses. Click to clear Print Separate Bill-to Statements.

11. Click the Age Using tab.

Use the options on the Age Using tab to define the aging periods that will appear on the statement.

12. Set up the Set Aging Periods Using These Days.

You can age amounts based on the number of days in aging period or based on the statement period.

How do you want to define the aging period?

Age based on days. Click Days. Then, enter the number of days in each aging period in Aging 1 to 5.
Age based on statement period. Click Statement Period.

13. Set up the Aging Using.

You can use the date that the invoice was created or the date the invoice payment was due to determine the "age" of each unpaid balance. In addition, you can organize the printed report to print the ages by date or by GL Posting Period.

What do you want to age?

Age based on the payment due date. The payment due date is the date when the account needed to be paid. Click Payment Due Date.
Age based on the invoice date. The invoice date is the records the transaction. Click Invoice Date.

14. Click the Forms tab.

15. Select the Form.

A form is a document that has been set up to print information, such as text, titles, or variables.

16. Click Print (CTRL+P).

The report prints.

Reprint statements

You can reprint statements that were printed incorrectly or damaged by the printing process.

Step 1: Delete statement date

Run this routine to delete the statement.

Do this...

1. Open Organization > Delete Statements.

2. Use the Statement Date field to enter the statement date for the statement that needs to be deleted.

3. Do you want to delete statements for all customers?

Yes, delete statements for all customers. Change the Customer.Customer number value to All.
No, only delete statements for the selected customers. Double-click All, next to Customer.Customer number. Use the Values form to enter the customer numbers. Then, click OK.

4. Click GO (CTRL+G).

The statement is deleted.

Step 2: Reprint statement

After the statement is deleted, set up the Statements report to print the statement.

Do this...

1. Open Reports > Statements.

2. Select a report title from the Title menu.

3. Select the Statement End Date that you want to reprint.

4. Click the Forms tab.

5. Use the Selection Criteria to enter the customer numbers that need to be reprinted. It's located on the Report Options tab.

Tip! The option for Restart, located on the Forms tab, is usually used for changing the form printing order. This option is usually not used. For example, you might need to use this option if you were printing forms in name order instead of zip code order (default). This option allows the system to sort customers in the selected order and start printing again.

6. Click Print (CTRL+P).

The statement prints.

Age using

The Aging Report shows all unpaid balances and puts them into different aging time slots depending on how long the balances have been unpaid. Use the options on the Age Using tab to define the aging periods that will appear on the statement.