PVC Mesh Banner Stocktake Procedure

Update Inventory in Xero

• Go to Xero > Business > Products and Services.
  
  

• Locate the corresponding PVC mesh product.
  
  

• Click "New Adjustment".
  
  

• Enter the New Quantity on Hand (i.e., the new total length calculated from the stocktake).
  
  

• Fill in the Adjustment Account and Reference
  
  

• Click Next to confirm the adjustment.

Accounting Treatment

The adjustment will generate the following accounting entries:

• Debit: Mesh Expense
  
  

• Credit: Inventory

Short Rolls Handling

For short rolls, we can expense them directly.

• Go to Xero > Business > Products and Services.
  
  

• Find the product labeled "Short Roll".
  
  

• Repeat the same steps as in Step 2 above:
  
  

  • Click "New Adjustment".
    
    

  • Set New Quantity on Hand to 0.
    
    

  • Enter the Adjustment Account (e.g., "Mesh Expense") and a Reference (e.g., "Stocktake [Date]").
    
    

  • Click Next to complete the adjustment.
    
    

This will expense out the short rolls and remove them from inventory.

Mesh Stock Stake Sheet Update

After completing the stocktake, open the Mesh Stock Stake spreadsheet.

https://docs.google.com/spreadsheets/d/1jYW13AVpQW9Ym6w_JVzxzKmxciMh3pjGoRdIjinikl8/edit?usp=sharing 

• Update the In Stock and Orders Coming In fields to ensure they match the Mesh Stock Count sheet.
  
  

• This sheet helps us monitor stock levels and decide when to place new orders.
  
  

A new order should be considered when:

• Months Stock Held is less than 3 months, and
  
  

• The total Rolls Needed reaches 150 rolls。