7+ years of inventory mistakes, major inventory and COG discrepancies

SOLVED

Hello!
I started work for a company less than year ago - a small business (just me and the owner). She has owned the business for 4 years, and she inherited a very misused version of Sage. Inventory and costs seem to have been never entered correctly before she owned the business (biggest issue, every time someone couldn't find an item they were looking to sell they just... made another one... completely ignoring how it was logged on the purchase...), thus - COGS and Inventory levels are all very very wrong every year. Our accountant seems confident in his ability to decipher our mess every year, we do manual counts and digging to make sure our info is accurate, but we're looking to fix it for many glaringly obvious reasons. He does not understand technology very well, and we are not even close to accountants. So... seeing as how we calculate the correct costs and inv counts anyway, is there any way to update simply to reflect that so we have less of a headache next year? A former employee tried by using the "Adjust Inventory" function, and that made even more of a mess, so I'm admitting ignorance, exercising caution and asking here before I do something dumb... Thanks in advance for the patience Face palm, trust me, i am grateful. 

Parents
  • +1
    verified answer

    Hi 

    First I think best to check what inventory costing method the file uses , Avg cost or FIFO?

    then best find out if inventory is set to sell below zero, and how many item cost, value, quantity is inaccurate.  (for example if you have ten thousand item that is out, i think best is start over a new file might be better)

  • 0 in reply to Jason.

    Avg cost and yes, allows below zero. 
    We do have a need to view our history, we're constantly looking up old invoices (pre 2014) to see what was ordered, so as much as I'd get a deep satisfaction to blow everything away, it would hinder us way too much. Unfortunately, I also feel pretty comfortable in saying that nearly every single item is wrong (both cost per and qty, usually) and needs fixing, and we have around 600 items in use. 

  • 0 in reply to Atcan Display Inc.

    When you are using average cost for your inventory it will go wrong if you allow inventory to go below zero. This is something I try to avoid with clients if inventory is a major concern for them. (ie manufacturing or retail ) As soon as an item goes below zero the average cost will go wrong and it will not correct itself by adding more inventory. An adjusting entry would be necessary and the correct entry would require a lot of tracking outside of Sage 50. 

    Inventory works well if you do not allow it to go below zero. It just takes better inventory control and purchasing lead times. Processing the paper work in the correct order helps tremendously.

Reply
  • 0 in reply to Atcan Display Inc.

    When you are using average cost for your inventory it will go wrong if you allow inventory to go below zero. This is something I try to avoid with clients if inventory is a major concern for them. (ie manufacturing or retail ) As soon as an item goes below zero the average cost will go wrong and it will not correct itself by adding more inventory. An adjusting entry would be necessary and the correct entry would require a lot of tracking outside of Sage 50. 

    Inventory works well if you do not allow it to go below zero. It just takes better inventory control and purchasing lead times. Processing the paper work in the correct order helps tremendously.

Children
No Data