Contents
- Index
- Previous
- Next
Subcontractor Cost Analysis by Job
The purpose of the Subcontractor Cost Analysis by Job is to provide a flexible and complete summary analysis of the balance to be invoiced by project based upon accounts payable invoices paid and payable compared to the original vendor contract including change orders.
The first step in setting up your reports is to select the end date for the time period you want to cover, select the level of summarization desired, select the specific projects you want to analyze, and define how you want your reports to be sorted.
End Date: Enter the last date for which you want to include accounting and job cost transactions on your reports. The default date the system will automatically select for you is today's system date on your computer. For fiscal period-end reports, set this date to the last date in the range of fiscal periods you want your reports to cover.
Select The Report Summarization Level: Click the level desired. If you click the Project level, then whatever jobs, cost codes, and tasks have been setup for that project will be rolled up and summarized at the project level. Likewise, if you select the Job level of summarization, all cost code and task level transactions will rolled up and summarized by job, etc.
Project "Ribbon": Listed here will be all of the projects that have been setup in your system for which there are transactions recorded in the system through the end date you have specified. In a manner similar to the selection process explained in Job Cost Reports, use the ">" and ">>" buttons to select one or more projects that you want to generate reports for.
Sort By: Click on either Name or Number to specify how you want your projects, jobs and cost codes sorted. Name sorts alphabetically by descriptions you have defined, number by the numeric code you have defined.
The columns on the report are as follows:
Job Cost Number: This will print the job cost number for each vendor you have contracted with to perform work on the projects you have selected for this report.
Vendor: This will print the name of the vendor you have entered into your PPT supplier records.
Contract Amount: This will print the contract amount you have entered in the job cost master record sub contract tab.
Change Orders: This will print the total of all change orders (if any) you have entered in the job cost master record sub contract tab.
Revised Contract Amount: This is the total of the Contract Amount and Change Orders.
Invoices Paid: This will be the total of all AP invoices you have entered into your system and paid through the end date you have specified.
Invoices Payable: This will be the total of all AP invoices you have entered into your system but have not paid through the end date you have specified.
Balance To Be Invoiced: This is calculated as the Revised Contract Amount Less (Invoices Paid + Invoices Payable). Assuming there will be no further change orders issued to the vendor displayed, or adjustments made due to prior AP invoices received from this vendor, this amount represents the total amount you might expect to be billed between the end date you have specified for this report and completion of the project/job for which this vendor is providing material, labor or services to your organization.
The levels you selected during report setup determine the levels of summarization for this report.