Thanks for reaching out to the Community space, @GolfNut72.
Currently, we don't have a WIP feature in QuickBooks Desktop (QBDT). However, we can create an account called Work in Progress. This way, we can track the revenue (as liabilities) and costs (as assets) until the end of the job. Here's how:
Step 1: Create an account
- Go to the Lists menu, and select Chart of Accounts.
- Click the Account button, and then select New.
- Select Other Current Asset for the account type.
- Click Continue.
- For the Account Name, you can put Work in Progress.
I'd also recommend reaching out to an accountant to help you choose the right account.
Step 2: Change the item account
- Go to the Lists menu, and select Item List.
- Change the expense account on your service items to the asset account you set up above.
- Add Other Charge items.
- Transfer out of WIP as the account and the amount in the description should be positive.
- Make sure to use the Items tab instead of the Expenses on all your transactions.
However, if you use Job Profitability reports, we can filter them to include your WIP account. I'll guide you how:
- Go to the Reports menu.
- Select Custom Reports and then Summary.
- Click the Customize Report tab, then select Filters.
- Select the Account drop-down arrow, then choose Multiple accounts.
- Verify all income and expense accounts and your WIP account, then click on OK twice.
Once done, generate a report to track the amount in WIP by the job.
- Go to the Reports menu.
- Select Custom Reports and then Summary.
- Click the Customize Report tab, then select Display.
- Select the Display columns by drop-down arrow, and then choose Account list.
- Click the Display rows by drop-down arrow, and then choose Customer.
- Select the Filters tab.
- Click the Account drop-down arrow, and then choose your WIP account.
- Click OK once done.
When the projects complete, make the invoice or sales receipt for the sales price. Then, add the two charged items to ensure a negative amount for Transfer into COS. The invoice end total must match the sales price.
I've also added these articles about customizing reports and job costing:
Feel free to drop a comment below if you have other questions. I'm always here to help you some more.