Purchase orders, bills & inventory

2 results found

1. Inventory - Record Quantity on Hand for untracked items

   HI
   we work in wine retail & record our product &service on xero (we have moved from sage 50 2 years now)
   we cannot use track inventory option as this doest work with our current setup
   please can we simply have like a small box under each inventory saying quantity on hand for e.g 2 or if its negative like - 2 ( as this is really trouble some for me to all the time go to report & manually set my filters all the time with dates,& other details.
   ) please like on sage50 we had always a number showing negative,positive or 0 (if buying equalls selling) kindly please add this simple feature - Thanks

   HI
   we work in wine retail & record our product &service on xero (we have moved from sage 50 2 years now)
   we cannot use track inventory option as this doest work with our current setup
   please can we simply have like a small box under each inventory saying quantity on hand for e.g 2 or if its negative like - 2 ( as this is really trouble some for me to all the time go to report & manually set my filters all the time with dates,& other details.
   ) please like on sage50 we had always a number… more

   • 

   8 votes

   vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   1 comment  ·  Inventory  ·  delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   Not in pipeline  ·  AdminKelly Munro (Community Manager, Xero) responded

   Hi community, while we appreciate some customers may want to rack quantity on hand for untracked items in their products and services this isn't something we have plans for. Tracked Inventory is the feature within Xero that will enable this capability and while we understand this may not work for all customers flows we want to be transparent with you through the idea here.

2. Reporting - Calculate COGS for Untracked Inventory items: Opening Stock + Purchases - Closing Stock

   To make the profit and loss report calculation is based on Cost of Goods Sold = Opening Stock + Purchases - Closing Stock.

   Purpose: To get the figures easily in P&L report by deducting the closing stock from purchases.

   14 votes

   vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   3 comments  ·  Inventory  ·  delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   Not in pipeline  ·  AdminKelly Munro (Community Manager, Xero) responded

   Hi community, in the way untracked inventory in Xero works it isn't possible to automatically calculate cost of goods sold for a period in your reports. 

   There is a way to go about this yourself through entering Manual Journals to account for the Cost of Goods sold, and adjusting the value of inventory on your Balance Sheet. 

   You'll want to enter your Conversion Balances into an account that has a Current Asset type rather than an inventory type (Inventory type is reserved for use with tracked inventory in Xero and can't be coded to on manual journals).
   To avoid potential taxation and reporting issues - We highly recommend contacting your accountant to check whether this is suitable for your business, or if you need additional clarification on what journals to enter.