Spreadsheets vs. ERP

Spreadsheets are an amazing tool that are simple to use and readily accessible.
They can be used effectively for modeling, analysis, building lists, scenario planning and complex calculations.  However, companies will often use spreadsheets to duplicate tasks that are already built into Enterprise Resource Planning (ERP) systems.

In a recent survey, 17% of small to midsize companies had yet to take the plunge to an ERP system.  What do they use to run their businesses? 57% said they still use spreadsheets to run their business.  However, there is a certain element of danger inherent in using spreadsheets to run a business:

  • Spreadsheets do not offer an auditable system. Spreadsheets are considered an “undocumented application” because the formulas are so easily edited by the user.  If all of your financial data is recorded using spreadsheets, you would have a very difficult time substantiating claims using only a spreadsheet.
  • It’s really easy to delete or amend data. Research recently conducted found that only one in every five spreadsheets are error-free and will give you correct results.  They offer so much flexibility that calculation mistakes are incredible easy to make.
  • They lack collaboration. We’ve all had three versions of the same spreadsheet floating around in the same organization.  This is troublesome when you are in need of actionable financial data.  How can you know which one is the most accurate and up to date?  Oftentimes, they all have pieces of correct data but not the complete picture.
  • They offer only limited reporting. Spreadsheets provide graphing and some reporting but it is limited to the fields that the spreadsheet designer elected to include.  What if you need a PO report by date and they have only included PO numbers?  Most companies need a lot more flexibility in their reporting.
  • Security is very low. Spreadsheets are easily transportable and offer very limited security.  Financial data deserves more protection than that.  You never want that data to get into the wrong hands.

ERP systems allow collaboration, high and customizable security, a trustworthy audit trail and limitless reporting without any of the drawbacks that spreadsheets can create.  Of companies that did take the plunge into ERP, they saw the following results about nine-months after their “Go-Live” date:

  • 21% saw a reduction in operating cost
  • 17% reduction in inventory
  • 19% reduction in administrative cost

If you’ve outgrown spreadsheets, click here to download our whitepaper “Ten Signs You Need  A New Solution”.

*statistics adapted from www.erpsoftwareblog.com

Bookmark and Share
This entry was posted in Enterprise Resource Planning (ERP), June 2011, Newsletter. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>