Overview
The Work in Progress (WIP) Active Projects report gives you job-level financial data to help calculate over and under billing, support WIP accrual entries, and evaluate project performance. Unlike the standard WIP report, it focuses specifically on active jobs and provides the detail needed to track revenue, costs, and billing more accurately.
For a more high-level report, see Work in Progress (WIP) report.
Who uses this feature
Administrators, office employees, managers, accountants, and bookkeepers
Applies to all business types
Feature configuration
Account configuration is required to use this feature. Please contact Technical Support for details.
Things to know
The project start date on the Project Edit page should have value in order to run the WIP report.
The WIP report will be populated if the project completion date is either blank or after the date that is indicated in the As of date field.
Create an Active Projects WIP report
Follow the steps to create a custom report based on the WIP report template.
From the Choose report type dropdown, select All.
From the Select report template dropdown, select Work In Progress - Percentage of Completion (Active Projects).
On the Set Details screen that opens, enter the report name.
From the Category dropdown, select Accounting.
You can add a description for the report if necessary.
When you're finished, click Save.
Run an Active Projects WIP report
This report shows the sum of transactions for active projects excluding transactions that happen after the Transaction As of Date. The data in this report gets refreshed Monday through Friday, every 2 hours from 6 am EST to 10 pm EST.
Go to the navigation bar and click Reports.
From the side menu, click All Reports and click WIP.
Tip: You can use the Search field to find the report you want.
On the report screen, set the following filters:
Projects Completed On or After Date: Shows only projects completed on or after the selected date.
Transactions As of Date: Includes transaction information recorded up to the selected date.
Project Status: Filters projects by their current status
Click Run Report.
Read Active Projects WIP report results
Your report results are displayed in a table based on the filters you set. The WIP report for Active Projects includes the following columns:
Project Details
Project Name: Project title
Project Number: Assigned project number
Project Type: Project category or type
Project Manager: The project manager assigned to the project
Project Business Unit: The business unit assigned to the project
Project Status: Current status of the project
Project Sub Status: Sub status of the project, if available
Project Start Date: Date the project started
Project Completed On Date: Date when the project was completed
Project Created On: Date the project was created
Project Contract Date: Date when the contract for a project is signed or agreed upon
Project Retainage Percentage: Percentage of payment withheld from project invoices to ensure project completion and quality.
Customer Name: Customer associated with the project
Location Name: Location associated with the project
Location Address: Location street address associated with the project
Location City: Location city associated with the project
Location State: Location state associated with the project
Location Zip: Zip code of the location associated with the project
User Completion %: Percentage of completion entered by the user
Completion %: Percentage of completion of the project
Payment Terms: Payment terms defined for the project
Estimate Details
Contract Estimate Sold By: Technician or employee responsible for selling the contract estimate
Contract Estimate Sold On: Date when the contract estimate was sold
Contract Summary: Total price and tax of items added to the sold estimate. This value includes change orders.
Change Order Summary: Total price and cost changes made after original sold estimate
Cost Adjustments: Cost changes made after original sold estimate
Estimated Labor Hours: Estimated number of labor hours required to complete the project
Estimated Labor Cost: Estimated cost of labor for the project based on the estimated labor hours and the hourly rate assigned to the technician performing the work
Estimated Material Cost: Estimated cost of materials required for the project
Estimated Equip. Cost: Estimated cost of equipment required for the project
Estimated Total Cost: Estimated total expenses for completing the project
Job Details
Jobs Count: Total number of jobs associated with the project
Jobs Completed Count: Total number of jobs marked as completed within the project
Payroll Cost Details
Actual Labor Hours: Total hours logged by technicians while working on tasks or jobs associated with the project
Actual Labor Cost: Total costs incurred for labor on the project
Actual Burden Cost: Expenses associated with labor on the project, beyond just wages. This cost includes additional factors such as payroll taxes, benefits, insurance, and other labor-related overhead.
Payroll Adjustments: Total payroll adjustments associated with the project
Performance Pay: Total performance pay associated with the project
Purchasing Cost Details
Invoice Material Cost: Costs associated with invoiced materials used in the project
Invoice Equipment Cost: Costs associated with invoiced equipment used in the project
Actual Cost Tax: Recorded tax applied to the actual costs of materials, labor, or other project expenses
Actual Cost Shipping: Actual shipping costs incurred for materials and products associated with the project
Actual Pre-Tax Discount: Discount applied to the project cost before taxes are calculated
Actual Pre-Tax Charge: Actual costs charged for a service or item before any tax is applied.
Actual Post-Tax Discount: Discounts applied to a project or invoice after taxes have been factored in
Actual Post-Tax Charge: Final amount added to the project or invoice after applying taxes
Vendor Restocking Fees: Charges incurred when returning products to a vendor
Vendor Accounting Adjustment: Adjustments made to the financial details related to a vendor, such as adjusting costs, payments, or balances within the project
Vendor Credit: Vendor credit applied to the project
Vendor Credit Sales Tax: Sales tax associated with vendor credit within the project
Committed Cost: Costs for materials, labor, or services that are expected to be incurred but have not yet been realized. This is calculated by looking at purchase orders not yet received.
Committed Cost Tax: Taxes associated with committed costs within a project
Actual Total Cost: Actual total expenses for completing the project. This is based on invoices, timesheets, and the calculation option selected in the Costing settings.
Total Actual Material Costs: Actual cost of materials required for the project
Total Actual Equipment Cost: Actual total expenses for completing the project
Project Cost Details
Cost to complete: Difference between actual and budgeted expense
User cost to complete: Cost to complete as entered by the user
% Cost to complete: Percentage of cost to complete
% User cost to complete: Percentage of cost to complete as entered by the user
Sales tax: Amount of tax applied to the total invoice billed for the project
Revenue Details
Actual Revenue: Actual income or earnings generated from the project based on what has been paid
Invoice Billed: Total amount invoiced to the customer for the project
% Billed: Percentage of the total project value that has been invoiced to the customer
Payments Collected: Total amount of payments collected for the project
Balance to Finish: The difference between the contract sum and the invoiced amount
Earned Revenue: Recognized income as the project progresses through milestones
Earned Profit: Profit recognized from the project based on earned revenue and actual cost
Pre-Tax Retainage Amount: A portion of the project's total cost, before tax, withheld until the project is completed or certain milestones are met
Summary Details
Estimated Margin: Projected profit margin of the project
Estimated Margin %: Percentage of the projected profit margin for the project
Actual Margin: Actual profit margin of the project
Actual Margin %: Percentage of the actual profit margin for the project
Over Billing: The difference between actual revenue and recognized revenue if the value is negative
Under Billing: The difference between actual revenue and recognized revenue if the value is positive