Show navigation

How to Handle Work in Progress (WIP) or Construction in Progress (CIP) in QuickBooks

» Articles » Construction Articles » Article

October 15, 2009

Builders and contractors who purchase land and then develop it have to comply with accounting requirements for revenue and expense recognition that are a little different and require a some modification of the standard QuickBooks set up. The accounting rule is that revenue and costs are not to be recognized on financial statements as income and expense until the job is complete, or in some cases as certain milestones are completed for the job. Many engineering firms, attorneys and other similar organizations like to use work in progress (WIP) accounts as well.

The procedure described here for handling work in progress (WIP) or construction in progress (CIP) in QuickBooks assumes that all revenue and costs will be tracked as assets (for costs) and liabilities (for revenues) until the end of the job, when they'll be transferred to income and expense accounts.

1. Set up a new account called Work in Progress or Construction in Progress-go to Lists > Chart of Accounts, click the Account button and select New. Select Other Current Asset for the account type.

2. Go to Lists > Item List and change the expense account on your service items to the asset account you set up above. If you don't see an expense account, click the button next to This item is used in assemblies..."

Continue reading below

FREE Construction Training from Lorman

Lorman has over 32 years of professional training experience.
Join us for a special live webinar registration and level up your Construction knowledge!

Construction Cost Estimating - Sep 5, 2019
Presented by Saleh Mubarak

Learn More

3. Add two Other Charge items:

a. Transfer out of WIP - with WIP as the account and note in the description that the amount should be positive
b. Transfer into COS - with COS as the account and note in the description that the amount should be negative

4. Make sure to always use the Items tab instead of the Expenses tab on all your transactions

5. If you use Job Profitability reports, modify/filter them to include your WIP account. Click on Modify Report, select the Filters tab, select Account, select Multiple Accounts, check All income and expense accounts and your WIP account. Memorize the report.

6. Create a report to track the amount in WIP by job by going to Reports > Custom Summary Report. Click on Modify Report, select Display Columns = Account List and Display Rows = Customer. Click on the Filters tab, select Account = your WIP account. Memorize the report.

7. Once the project is completed, prepare an invoice or sales receipt with a line for the sales price (mapped to an income account) and then add the two other charge items you created above making sure to use a negative amount for Transfer into COS. Once done, the ending total for the invoice should match the sales price.

About the Author
Ruth Perryman, MBA, CMA, CFE, CFM is a Certified Advanced QuickBooks ProAdvisor and an Intuit Solutions Provider. She can be reached at 800-707-0940 x101 [email protected]. Follower her on Twitter:

The material appearing in this web site is for informational purposes only and is not legal advice. Transmission of this information is not intended to create, and receipt does not constitute, an attorney-client relationship. The information provided herein is intended only as general information which may or may not reflect the most current developments. Although these materials may be prepared by professionals, they should not be used as a substitute for professional services. If legal or other professional advice is required, the services of a professional should be sought.

The opinions or viewpoints expressed herein do not necessarily reflect those of Lorman Education Services. All materials and content were prepared by persons and/or entities other than Lorman Education Services, and said other persons and/or entities are solely responsible for their content.

Any links to other web sites are not intended to be referrals or endorsements of these sites. The links provided are maintained by the respective organizations, and they are solely responsible for the content of their own sites.