Sage 50 will let you sell more stock than it shows as on hand.\u00a0 But have you ever wondered how cost of goods sold is calculated for those sales?\u00a0 And have you ever seen entries in your general ledger with the description “Syscost Adjustment” and wondered where they came from?\u00a0 Let’s look at what happens when you let your inventory go into the negative.<\/p>\n
Let’s say you have been buying widgets for $100 each.\u00a0 You get an order for 5 widgets. Sage 50 says you have 4 on hand, but you know more are coming so you enter the invoice and tell the customer they will be delivered in a few days.\u00a0 Now your inventory shows -1 on hand. Since Sage 50\/Peachtree has no way of knowing differently, it assumes that when you replenish this item the cost will be the same as the last time you purchased it.\u00a0 So in this case, COGS for the fifth widget would be $100, just like each of the other 4 units.\u00a0 If you look at the Inventory Valuation Report, you will see -1 widgets on hand with a value of -$100.<\/p>\n
If the new widgets also cost $100 each, the cost of goods sold entry will be unchanged and there will be no real affect to letting your inventory go negative.<\/p>\n
If the new widgets cost $105, and you record their purchase on the same date as the sales invoice (or earlier) the cost of goods sold for the 5th widget will be changed to $105.\u00a0 All of your reports will look the same as they would if you had originally had 4 on hand at $100 and 1 at $105.<\/p>\n
If the new widgets cost $105, and the purchase is dated after<\/span> the sales invoice, a System Cost Adjustment, (or Syscost Adjustment in older versions of Peachtree), will be made that debits COGS and credits Inventory for $5.\u00a0 This entry keeps the general ledger in line with the Inventory Valuation Report and corrects your total COGS on the income statement.\u00a0 But the cost adjustment does not get linked back to the sale.\u00a0 So if you look at the Items Sold To Customers report you will see that the COGS still shows $500, not $505.\u00a0 The same is true of the Item Profitability Report.\u00a0 And the Item Costing Report will show the $5 in the Adjust<\/em> column, not Cost of Sales<\/em>.<\/p>\n It’s up to you to decide if this is a problem.\u00a0 If you closely monitor profitability by item, or you pay commissions based on profit instead of total sales, you probably should not allow your inventory to become negative.\u00a0 Although, even then it would depend on how much your costs change.<\/p>\n If you use average costing, Sage 50 won’t always use last cost in negative inventory situations.\u00a0 If you bought one widget for $100 and another for $110, you would have 2 on hand with an average cost of $105.\u00a0 If you sell 3 widgets on one invoice, Sage 50 would assume the same cost of $105 each for all three units.\u00a0 But if you sold 2 on one invoice, bringing your QOH to 0, and then sold another widget on a separate invoice, Sage 50 would use your last cost ($110) as the COGS amount for that invoice.\u00a0 But system cost adjustments work the same way and have the same effect on reporting regardless of your costing method.<\/p>\n","protected":false},"excerpt":{"rendered":" Sage 50 will let you sell more inventory than you have on hand. But how does that affect inventory and cost of goods sold?<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/517"}],"collection":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=517"}],"version-history":[{"count":8,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/517\/revisions"}],"predecessor-version":[{"id":646,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/517\/revisions\/646"}],"wp:attachment":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}