Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I work for a small landscaping company and currently using QuickBooks Desktop - Premier Plus Contractor Edition. We have bulk raw materials delivered to the shop (mulch, stone, sand, etc) which is then applied to jobs at a later date. In the winter we have rock salt that gets applied to sites as needed. For job costing, I have to apply the material, such as: 4 yards of mulch to grounds maintenance job A, or 3 tons of cobble to construction job B, or 40 tons of salt over 20 job sites per storm.
My question is do I set up raw materials as Inventory items or Non-Inventory items? For all of these jobs we do not sell the item individually, but as a component part of the overall contract. Which sounds like Non-Inventory part but I'd like to track the quantity so that is only available with Inventory part. Currently I put all the deliveries into a Shop Inventory account and create a monthly journal entry to COGS job materials (per division) with the customer/job. This is time consuming and requires a lot of rework to find the current quantity balance and cost of each aggregate. Hoping there is a better/faster way but that records the costs appropriately as well.
Thanks for sharing the details with me, @Peak Environmental.
Allow me to provide some information on how to achieve this. You’ll want to set up your raw materials as Inventory parts.
That way, the Cost of Goods Sold will be calculated when the item is assigned to a job. That being said, here’s how to set up an inventory item in your QuickBooks Desktop (QBDT) software:
You can also utilize this article for more details (select the Create an item section): Add, edit, and delete items.
I’d also recommend checking with your account for guidance if you’re unsure of what income account to choose in setting up your inventory item. This way, we’ll ensure the accuracy of your accounts.
Additionally, I'm adding these resource that you can use as reference in case you have other inventories stored at different sites or locations and want to track them: Set up Advanced Inventory.
Let me know if there’s anything else I can help you with about managing your inventory items. I'll be around ready to assist you. Have a great day ahead!
Consider having a construction management app to manage your inventories.
After setting up inventory items should bulk quantities purchased get charged to an “other current assets” account?
Allow me to chime in and provide some info about inventory purchases, @DanOlsen.
In QuickBooks Desktop, when you buy an inventory item, your bill, check, or credit card charge will debit the item's inventory asset account and credit your A/P, bank, or credit card account.
With regards to the account that will be charged, it depends on the asset account that you set up for the inventory items.
The best way to track your inventory purchases is to generate the Inventory Valuation Summary/Detail reports for all dates. For detailed steps, you may utilize this resource: Understand statements in QBDT.
You'll want to track inventory stored at different sites or locations. You can use the Advanced Inventory feature to ensure your quantity on hand by site is accurate.
Fill me in if you have other questions about inventory tracking in QuickBooks. I'm always around to help you. Stay safe and have a good day!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here