Skip to main content
A
Alan_Alter
March 16, 2021
Question

How to control inventory between employees and sales

  • March 16, 2021
  • 1 reply
  • 0 views

I am part owner of a business within which we have 2 main sources of income. 

 

1. we sell retail building supplies and equipment to the trade and domestic market. We are in the middle of setting up a stock control system for every single item we sell on.

 

2. We carry out contracting work within the construction industry, we have 16 construction operatives employed.

 

I am wondering how to track items such as tape measures, safety boots, Hard hats etc. which are all issued FOC to our employees but also sold to trade customers coming in the door.

 

I would also like to run a report on each individual employee to analyse costs per employee

 

Another issue we are having is allocating costs of material to each project. This is fundamental to the stock control system as we need to allocate material out to jobs, so stock numbers are accurate.

 

Someone has suggested zero £ invoices raised against each project but never sent to the customer but i think there must be a better way?

 

Any suggestions would be extremely helpful?

1 reply

Rustler
Rustler
April 6, 2021

What ever you issue to an employee as part of their job, is usage. Either sell the item for a zero sales price to a generic customer, or use inventory adjust - lower the qty on hand and use a tools or equipment expense account as the adjusting account

 

In QB inventory does not post to COGS and sales income unless it is on an invoice. So yes, use a zero sales price invoice to "sell" the item to the job

Terms & ConditionsAccessibility statement