Customer Invoice Aging by Project screen

Use the Customer Invoice Aging by Project screen to create a detailed report of all open customer invoices aged and totaled based on the invoice date or the invoice due date. The report shows the invoice date and retainage for each invoice as well as the current on-account balance by division. The invoices are sorted by customer, project, and invoice date. You can print or save this report.

Invoices that are created by the release of retainage on contract billing are indicated by an asterisk on the report.

For more information on running this report, see Run and Print Reports.

Note: To open the Customer Invoice Aging by Project screen, click Customer > Reports > Customer Invoice Aging by Project in the All Tasks pane.

You can control the output of the Customer Invoice Aging by Project report by entering details in one or more of the following fields on the Options tab:

  • Select Format - If you have modified the format and layout of this report on the Modify Reports screen, click to select the version to use for this report. If you haven't modified the report, this field doesn't appear.

  • Report Through Date - Enter the date to age invoices against for the report, click to select the date from a Date Picker, or click to enter a Date Formulas. If you want to save the information in the date field when you save the report options, you must use a date formula. If you do not enter a date, ProContractor uses the current date.

Company - Click to select one or more companies for the report. If no companies are selected, all companies appear in the report.

  • Division - Click to select one or more divisions for the report. If no divisions are selected, all divisions appear in the report.

Customer - Click to select one or more customers for the report. If no customers are selected, all customers appear in the report.

Project - Click to select one or more projects for the report. If no projects are selected, all projects appear in the report.

Age Invoice Based Off - Select Invoice Date to base the invoice aging on the invoice date. Select Invoice Due Date to base the invoice aging on invoice due date.

  • Days for First Aging - Enter the number of days in the first aging period. Invoices that are up to this number of days old are totaled. This field is required.

  • Days for Second Aging - Enter the number of days in the second aging period. Invoices that are over the days for first aging up to this number of days old are totaled. This field is required.

  • Days for Third Aging - Enter the number of days in the third aging period. Invoices that are over the days for second aging up to this number of days old are totaled. Invoices that are over this number of days old are also totaled. This field is required.

    Tip: You can use the Modify Reports screen to customize the format and layout of this report.