Skip to main content
February 21, 2022
Question

COGS Materials for a construction project and keeping track of how many of an item was purchased but it is not in our inventory..

  • February 21, 2022
  • 1 reply
  • 0 views

My boss, a general contractor, refuses to keep track of inventory because he says everything bought is used specifically for a project. I have uploaded detailed Home Depot receipts into QBO. They automatically enter line items.  

 

Where I am hitting a road block is, we do not have inventory but I need to show how much of each item was purchased for the project. Meaning, its somewhat inventory because we buy it, but we immediately use it and by it only because that project needs it. Example: Egg Shell white paint. I noticed that the cost of this item for the project was extremely high for what it should have been (by looking at homedepot.com and writing down every time it was bought and took hours). The project was projected to use 50 5 gallon buckets of that paint. When I was done calculating everything by hand, I realized that 86 were purchased instead of 50. We found out the painter had was purchasing for a different project of his but using our money to supply the paint. The only way I can think to prevent this is by keeping "inventory" but only to keep track of how many of that item was purchased and nothing else. 

 

I know this sounds confusing but I am completely lost on how to do this because I don't want it as an asset, it will not be invoiced to anyone (we do lump-sum contracts only), and I will not be keeping track of how much is on hand AFTER the project is done. 

 

Is there a way to do this? Any suggestions other than a spreadsheet? PLEASE HELP! I'm desperate!

 

1 reply

February 22, 2022

Hello HermesContracting, 

 

I appreciate you connecting with us in the Community. QuickBooks Online is a hassle-free program that simplifies the way you manage your accounting. I'll be glad to point you in the right direction so you can achieve your QuickBooks goals. Recording your transactions the right way is a good exercise for keeping your books accurate.

 

To ensure accuracy in your books, I recommend contacting an accounting professional to get expert advice. Doing this will help prevent any future discrepancies in your books. You can also reach out to accounting professionals on our site using this link here.

 

I'll also leave this question here so other accounting professional members can chime in and share their expert advice. Let me know if you have other questions, I'm here to assist.