Skip to main content

Work in Process

Learn about the Work in Process Account in Design Manager

Bobbie Combs avatar
Written by Bobbie Combs
Updated over 9 months ago

The Work in Process (WIP) account in the General Ledger and the Work in Process Report under Accounts Payable Reports hold the total of all Items purchased from the Vendor but not yet invoiced to the Client. This is supposed to be the work in process (progress) or Items that the Designer has paid for and is working on installing, it is like temporary inventory.

The Invoice to the Client signifies the transfer of title/ownership to the Client and pulls the goods out of WIP and places them into cost of goods sold. This also has the effect of matching revenues with costs in the appropriate financial period. For example, let's say that you purchase $100,000.00 of materials for a Project in March. In April, after the Project is completed, you invoice the Client for $150,000.00. If the March cost went directly to cost of goods sold it will appear that you are losing $100,000 in March when actually you will invoice them at completion for $150,000. In April it appears that you are making $150,000 in profit with no costs when you are actually only making $50,000 in profit. Since Design Manager automatically uses the WIP account to hold the costs, you get a matching profit and loss in April because the $100,000 is held in WIP on the balance sheet as an Asset (something your company owns) until April when the Client is billed.

Note: At the same time any retainer/deposit monies given by the Client are being held in a Client deposit liability account. When the Client Invoice is generated this is relieved and moved to revenue.

The WIP report lists all Items (as of the selected fiscal period) that make up the WIP account balance. Any Items that are old and should no longer be on the report are Items that have never been billed out to the Client. These may be Items that were given to the Client for free, a 100% deposit was already collected on, or Items purchased but for whatever reason never sold to the Client. If the Items were given to the Client at no charge or a 100% deposit was already given then a zero Invoice for the goods should still be generated. This Invoice is very important to signify that Client has received the goods; this Invoice also serves as the proof of collecting sales tax as well as the Client's proof the expenditure (receipt). For items that were returned to the Vendor or broken, etc. a negative Vendor Invoice should be entered for the return or damages against the Purchase Order designated on the WIP report.

To run this report, go to the left side menu and click on Reports. Then find the Work in Process report under Accounts Payable.

  • Choose the fiscal month

  • Select the Subtotal format; By Project or By Account (Cost of Goods Sold Accounts)

  • Optionally select one Project or a range of Projects. When left blank, the report will show all Projects if applicable

  • Optionally can show revisions or full Component description

Work in process page

Click on Run Report and a new tab will open showing the PDF report. Here is an example of this report:

Work in process report example

Did this answer your question?