Skip to main content
November 20, 2020
Question

Inventory

  • November 20, 2020
  • 1 reply
  • 0 views

Hi, 

 

I am currently trialing QBO Plus for my construction business. I am hitting a road block trying to utilize inventory for the way our company purchases materials. The background to my issue:

 

  • I want to make use of inventory to track surplus materials generated from a project. 
  • We purchase materials throughout a project specifically for that project as opposed to purchasing materials as stock / inventory and drawing down from it (this would be too time consuming for us to track). 
  • At the end of every project there are always materials left over due to minimum order quantities. 
  • I want to be able add these materials to inventory so they show on our accounts as stock assets until we have a use for them on another project. At which point we will drawdown from the inventory as normal. 
  • I want the transfer of materials from a project to inventory to reduce project COGS.
  • The issue is every way I have tried (refund, credit note, zero sales receipts etc.) seems to result in various incorrect results i.e. incorrect inventory quantities, or project COGS remain unaffected , or a reduction in project income (as opposed to COGS). 

This is a key feature that will sway our decision on whether or not to proceed with QBO. I would therefore be hugely grateful if anybody is able to help me on this. 

 

I must add, I am not a bookkeeper / accountant and only have a relatively entry level knowledge of this topic. We leave this to an accountant, however since we are only testing software at this stage we are not in a position to run this past our accountant just yet. 

 

Thanks in advance for your help. 

1 reply

LieraMarie_A
November 20, 2020

Don't worry, I'll help you get a better grasp on the inventory and project feature in QuickBooks Online, @Mackem90.

 

Did you select the project name when creating a transaction? To track expenses and income you incurred and earned on your customer's behalf when you perform work for them in a specific project, you'll have to select the project name instead of the customer's name. Doing this will result in or affect project COGS and income.

 

I've got some articles here to help you navigate this feature and I'm sure you'll get the hang of it in no time.

 

If you still need a little more guidance, please don't hesitate to comment below. We are here to help!