cancel
Showing results for 
Search instead for 
Did you mean: 
whighfill
Level 3

Inventory items and Progress Invoicing

I typically bid jobs as fixed price/lump sum. In the contract, I specify a draw schedule where I get paid some specified amount of money at key milestones in the project. My estimates in QB Desktop 2020 are a mix of inventory items, non-inventory items, and service items (labor). An example of this situation would be the contract (and the estimate in QB) is for $10,000 total. At point A in the project, the client owes me $3,000, point B they may owe me $4,000, and so on until the total contract sum is paid at project completion. The client never sees the details of the estimate, only the contract sum and the scope of work. So if I use 10 feet of an inventory item or 15 feet, it doesn't change the contract sum (ie, doesn't change what I get paid). As I do the project, I keep track of how much of the inventory item I actually use. In order to get that amount of inventory item out of inventory and charged against the job, my solution so far has been to create a sales receipt for that amount of inventory item at $0. But then what to do with the inventory items in the estimate as I progress invoice off the estimate? 

2 Comments 2
MJoy_D
Moderator

Inventory items and Progress Invoicing

I can share some information about handling your inventory items, whighfill.

 

The feature to include the number and amount of inventory items in your job is currently unavailable. This would be a great addition to our present features. Our customers like you will surely benefit from it.

 

I invite you to provide input to our developers so that this feature can be added to future releases. Rest assured, I'll do the same on my end.

 

Here's how:

 

  1. Select Send Feedback Online from the Help menu.
  2. Click the Product Suggestion from the drop-down menu.
  3. Fill out the on-screen instructions in the QuickBooks Feedback window.
  4. After that, click Send Feedback.

 

Creating a sales receipt is a great workaround for the meantime. You can record everything you deposited as a single record with one total by putting payments into the Undeposited Funds account. Then, record and make bank deposits in QuickBooks Desktop

 

Keep me posted if you have any other queries concerning inventory. I'm always happy to lend a hand in any way I can. Enjoy the rest of your day!

whighfill
Level 3

Inventory items and Progress Invoicing

Every time I ask how to do something, it's "that would be a great function, just send a product suggestion". It seems like QB is not built for contractors. For the 2nd time this year, I'm wondering if I wouldn't just be better off using excel.

Need to get in touch?

Contact us