How to Handle Work in Progress (WIP) or Construction in Progress (CIP) in QuickBooks
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…”
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.
Ruth Perryman, MBA, CMA, CFE, CFM is a Certified Advanced QuickBooks ProAdvisor and an Intuit Solutions Provider. She
specializes in customizing QuickBooks Enterprise and POS. She can be reached at 800-707-0940 x101 or ruth@theQBspecialists.com. You can also follow her on Twitter at http://twitter.com/ruthperryman
Looking for more QuickBooks Tips & Tricks? Visit our blog or subscribe to our newsletter at
http://www.theQBspecialists.com
Related articles by Zemanta
- Quick Books Managing Your Business Finances (slideshare.net)
- Intuit’s chief on economy: Welcome to the ‘new normal’ (news.cnet.com)
- Now Available: QuickTax Online Free (newswire.ca)
- Ubikwiti Provides FREE Personal Expenses Application for Facebook Users (seomashup.blogspot.com)
- Outright’s Simplified Online Bookkeeping Leaves Stealth Mode With $2 Million In Funding (techcrunch.com)
- michael arrington: Intuit’s Partner Platform Goes Multilingual With Federated Apps (techcrunch.com)
- Use Quickbooks for Free! (scrapbookupdate.com)
- Small Businesses – Unite (and win up to $30K)! (entrepremusings.com)
- Intuit reaching out to Indian market (accountancyage.com)
- FastDue raises $5M for free business tools (venturebeat.com)
![Reblog this post [with Zemanta]](http://img.zemanta.com/reblog_e.png?x-id=d9395b4c-b4a8-4d17-b7ea-510533ee2049)
Related Posts
- Balance Sheets : Creating a Balance Sheet for a Small Business
- Business & Accounting Terms : How to Define Inventory Turnover Ratio
- m.a.s accountants - business accounting - To be or not to be audited - Feb 2010
- Accounting system Xero gives you more time to run your business
- Tax Accounting Services
