Tab Handled
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.
About the Author
____________________________________________________________
Ruth Perryman is the president of The QB Specialists. She is a Certified Advanced Quickbooks ProAdvisor and an Intuit Solutions Provider, with over 19 years of industry experience including 5 years as a Chief Financial Officer. She has been working with Quickbooks since 1996, and specializes in QuickBooks Enterprise and POS installations and troubleshooting. She also provides virtual controller and CFO services.
If you need additional assistance, please call our QuickBooks technical support line at 888-351-5285. The first ten minutes are absolutely free! Plus receive additional free minutes with every purchase – visit our website for more details.
|
|
Dopp Milan Traditional Framed Toiletry Bag $42.99 The Milan Traditional Framed Kit is made from Deer Cowhide and features a wide mouth framed opening, interior slip pocket, Dopp logo pull tabs and a carry handle. |
|
|
Safe-er-Grip 11.5-inch Bathtub/ Shower Assist Bar (Pack of 2) $25.16 Get a handle on bathroom safety with Safe-er-Grip assist barShower aid keeps parents and children steady in and around the tubEasy-release, flip-up tabs makes daily living aids simple to attach, remove or relocate |
|
|
Safe-er-Grip 4.25-inch Portable Shower Arm (Pack of 2) $23.99 Get a handle on bathroom safety with Safe-er-Grip portable shower armShower aid keeps parents and children steady in and around the tubEasy-release, flip-up tabs makes daily living aids simple to attach, remove or relocate |
|
|
Red Fire Black Blade Stainless Steel Folding Pocket Knife $7.32 This pocket knife is excellently crafted with a 3.25 inch stainless steel blade that has a resilient black coated finish with an easy open tab. It has a convenient pocket clip and aluminum handle that is modernly styled. |
|
|
Safe-er-Grip 16.5-inch Bathtub/ Shower Assist Bar (Pack of 2) $37.49 Get a handle on bathroom safety with Safe-er-Grip assist barShower aid keeps parents and children steady in and around the tubEasy-release, flip-up tabs makes daily living aids simple to attach, remove or relocate |