AR Retainage Report

Select PropertyCompany

Click to select propertiescompanies from the Select PropertiesCompanies tab. The report runs for all selected propertiescompanies.

Sort By

Select a sort option for the report: Job/Customer (default) or Customer/Job.

The report will print and have totals based on the sort chosen, or by Customer if not using Jobs.

NOTE that this option appears only when using Jobs.

From Customer ID / Thru Customer ID

To run the report for a specific Customer or Customer ID range, click the Lookup icon to display a pop-up and then select a starting Customer ID. Repeat the process to select an ending Customer ID.

Entries on this list are established in Customer Setup.

NOTE that this option appears only when using Jobs.

From Job / Thru Job

To run the report for a specific Job range, click the Lookup icon to display the Select Job pop-up and then select a starting Job ID. Repeat the process to select an ending Job ID.

Entries appearing on this list are established in Jobs Setup.

NOTE that this option appears only when using Jobs.

From Prd / Fiscal Year / Thru Prd / Fiscal Year

To run the report for a specific range of values for Period/Fiscal Year, click the Lookup icon to display a pop-up and then select a starting Period/Fiscal Year. Repeat the process to select an ending Period/Fiscal Year.

Include Zero Balance Customers (check box)

Select this check box to include Customers on the report that have a zero balance.

Include Unapproved

If Include Unapproved is checked (default), unapproved transactions are included in the report.

If Include Unapproved is unchecked, unapproved transactions are excluded in the report.

Print by PropertyCompany (check box)

If Print by PropertyCompany is not selected (default), a PropertyCompany ID column is included, with the propertycompany listed for each line, and a list of selected propertiescompanies prints at the end of the report.

If Print by PropertyCompany is selected, the report prints grouped by propertycompany and has a total for each selected propertycompany.

Report Format

PDF Format (default): Select this option to print the report in PDF format.

Create Spreadsheet: Select this option to print the report in an Excel spreadsheet.

Click to print the report.

This report lists AR Retainage information. For each item, the report shows the PropertyCompany ID, Period, Year, Total Retainage, Total Drawn (against Retainage), and Amount Remaining (of Retainage).

The report prints and has totals based on the Sort By option chosen, or by Customer if not using Jobs. Sort By options are Job/Customer or Customer/Job.

The From and Thru ranges limit the data based on selections.

If Print by PropertyCompany is not selected (default), a PropertyCompany ID column is included, with the propertycompany listed for each line.

If Print by PropertyCompany is selected, the report prints grouped by propertycompany and has a total for each selected propertycompany.

If Include Zero-Balance Customers is selected, the report includes Customers that have a zero amount in the Amount Remaining column. Otherwise, only Customers that have an amount are included on the report.

The report total prints at the end of the report for all data reported.

AR: AR Retainage