Percentage of Completion Schedule
Description: This percentage of completion schedule is an excel template that has been built using an excel table; as rows are added all of the necessary formulas are automatically populated and each row alternates color (the template is setup with blue and white alternating row colors, but you can quickly adjust the color scheme to your choosing).
Enter the job specific information into all of the columns that are not shaded gray (gray columns include formulas). All formulas are unprotected and can be seen so you can evaluate them for yourself. Additionally, no part of this excel template is locked - you can add additional information and track as many individual aspects of a project as you see fit.
The "Entries" section shows the amount of Billings In Excess of Costs / Costs In Excess of Billings, CY Revenue Recognized, as well as the amount of Accrued Loss (if this is a loss job) that would be recognized based on the information input. The calculations are based on the cost to cost method of accounting (i.e., the percent complete is a function of total costs actually incurred as compared to total costs expected to be incurred in order to complete the project).
The information you need to complete this schedule is as follows:
Note this excel template is formatted to print out on 11x17 sized paper (due to the number of columns).
Other Useful Tools & Excel Templates
Question or comments? Reach us Here
* Note, utilizing the features of this excel template requires Microsoft Excel® 2007 or later - some of the attributes such as the graded shading, tables, or 3-D formatting are not compatible with earlier versions.