Job Cost Capsheet (8 reports)

Top  Previous  Next

The Job Cost Capsheet Report is a job budget analysis report. The capsheet report includes columns for the estimated units and costs, the year-to-date and job-to-date totals for the amounts expensed including payables, the remaining budget balance, and the total percentage complete.

 

The capsheet report may be printed in a variety of formats:

 
Job Totals (Traditional Version Only)
Print a capsheet report that summarizes each job in the system on one report.
 
Job & Phase Totals
Prints a capsheet report with job cost phase totals for each job.
In the MAR version, double click on an amount to display the detail transactions.  
 
Job / Phase / Contract Totals  (MAR Version Only)
This version of the Job & Phase Totals capsheet includes a summary of contract information including original contract and budget amounts, total change orders, total billed, total received and total receivable.
 
Job / Phase / Account Totals  (MAR Version Only)

Prints a capsheet report with job cost phase totals for each job.  

Includes a grouping for each G/L acount within a phase.  

This report class (506) introduces several new fields that can be using for additional grouping, sorting, or filtering for custom reports:

 

oPhaseDivision – Cost Phase Divided by 1000 and truncated
oPhaseGroup – Integer Portion of Cost Phase (no decimal places)
oPhaseCategory – The decimal portion of the Cost Phase
oGLAccountDivision – GL Account Number Divided by 1000 and truncated
oGLAccountGroup – Integer Portion of the GL Account Number (no decimal places)
oGLAccountCategory – The decimal portion of the GL Account Number

 

Daily Labor / Equipment Drill Down  (MAR Version Only)

Prints a capsheet report with job cost phase totals for each job / phase/ glaccount PLUS a drill down on costs for daily labor hours and daily equipment hours from payroll time card entries.

Note: This report will NOT provide a drill down on payroll entries that were made BEFORE the installation of the 8504 Blue update which was released March 28, 2011.

 

 
Full Detail (Traditional Version Only)
Prints the capsheet report with job cost phase totals for each job but also includes a detailed list of each transaction that has been expensed to the job.
 
Job Cost Capsheet with Unposted Expenses (MAR Version Only)

This report is very effective for obtaining "real time" job cost reports for companies with heavy labor and equipment usage.  This report contains a column for unposted labor and/or in-house equipment rental from unposted time card batches from any and all user.  Drill down on the amount to view the individual transactions. Note: The job cost phase that the transaction is posted to must exist as a Detail Item in the job cost system before the 'unposted' expenses will print on this report.

 

Job Cost Capsheet Report – Linked Jobs (MAR Version Only)  which allows for pop up Master Job Entry to automatically group and select all related linked jobs with summarized totals for the Group included 2 and 3 tier linked jobs.

 

 

 

The Report Cutoff Period section of the screen has three options and is used to specify the cutoff date of the report.  The Current Job Totals option prints the report as of the current date. This option may be used to get an up-to-date job report in a new fiscal year when the prior fiscal year end has yet to be rolled. The By Cutoff Month option prints the report for any period within the current fiscal year. When the report cutoff month is entered, AccuBuild will display the cutoff date based on the current system date settings in the System Administrator > Configuration > Accounting option.  Both the Current Job Totals and the By Cutoff Month options will calculate the total estimated costs and total actual costs as of the specified period.  The Detail Cost Date Range is used to print actual costs, including costs accrued but yet unpaid, as of a specific date range which can be set to cover more than one fiscal year.  Please note that only the actual costs will be calculated based on the Detail Cost Date Range criteria and that the estimated costs printed on the report will be reflected by the Current Job Totals or the By Cutoff Month option.

 

The Partial Vendor option is used to select all actual costs, paid or unpaid, for a specific vendor based on the Report Cutoff Period and the job and phase selections.  If a partial job list is NOT selected, then this report can be used to review all costs for a selected vendor that have been charged to more than one job. Hint: Use this option in conjunction with the Detail Cost Date Range option to get a report that will suppress job cost phases that have zero actual costs for the selected vendor.