How do I know when we've outgrown spreadsheets for inventory?

Spreadsheets become risky when stock changes often, several people update them, locations disagree, purchasing depends on manual counts, or sales can happen faster than the file is updated. If inventory decisions require constant reconciliation, a shared inventory or ERP system may be a better fit.