The Subcontract Balance Report shows the total dollar amounts of your subcontracts. Invoice and payment information may be included.

To use this option, you need to have previously set up subcontracts.

The report is run for selected propertiescompanies.

Based on the current property'scompany's default entitycompany, if that entitycompany is setup for jobs, job parameters will be available to filter the data reported.

These fields allow you to select what prints on the report.

Select PropertyCompany (button)

Click the button to select the propertiescompanies for which you want to print the report and click Save.

Sort By

Select an option to sort the report by. Options are Subcontract, Vendor, Vendor/Job, Job, Job/Vendor.

Based on your selection, other options on the page may change.

New Page per Vendor/Job

Select this check box and the report displays a new page when the vendor/job changes.

This check box appears only when a vendor- or job-related option is selected for Sort By.

From Subcontract Date / Thru Subcontract Date

Pick a date range for the report. Click in a field and use the Electronic Calendarto select a date.

NOTE that the Thru Subcontract Date defaults to the login date.

From Subcontract / Thru Subcontract

Pick a Subcontract ID range for the report. Use the Lookup icon for each field to enter a starting and ending entry for the range. To run the report for one ID, select the same entry for the From and Thru fields.

From Vendor / Thru Vendor

Pick a Vendor ID range for the report. Use the Lookup icon for each field to enter a starting and ending entry for the range. To run the report for one vendor, select the same entry for the From and Thru fields.

From Job/ Thru Job

Pick a Job ID range for the report. Use the Lookup icon for each field to enter a starting and ending entry for the range. To run the report for one job, select the same entry for the From and Thru fields.

NOTE that this field appears only when a job-related field is selected for Sort By.

Vendor Type

Pick a Vendor Type for the report. Use the Lookup icon to select a Vendor Type from the select Vendor Type pop-up that opens.

Print Supporting Detail

Select this check box to print supporting detail in the report. An additional section appears on the report when there is supporting detail. If invoices are paid the detail does not display unless you check the Include Zero Balance Invoices option.

Include Zero Balance Invoices

Select this check box to print detail for invoices that are paid.

Subcontract Status

Select a status and only subcontracts with that status appear on the report. Status options are: Open, Closed, or Both (Open and Closed).

Print Required Document Dates

Unchecked (default).

Checked - If the Options & Status tab in Subcontract Entries has Required Documents, then the report will display the Required Document types and the dates for the documents.

Print Informational Message

Unchecked (default).

Checked - If any of the Required Documents from the Options & Status tab in Subcontract Entries is selected, but a date has not been entered, a message appears.

Report Format

Select a report format:

PDF Format: Print the report in PDF format for use in a PDF viewer, such as Acrobat.

Create Spreadsheet: Prints the report in an Excel spreadsheet.

1. From the Contracts menu, select Reports—Subcontract Balance.
2. Use the Field List for help selecting options.
3. Click Print.
4. If you selected Create Spreadsheet, you are prompted to open or save the report Excel file. Otherwise, the report opens in PDF format.