14 Reasons NOT to Use a Spreadsheet for Depreciation

There are many reasons why spreadsheets are not the “go to” for all business needs… especially when it comes to running and keeping track of fixed asset depreciation.  With so many potential causes and opportunities for errors, companies must look to software solutions that are specifically designed to automate, report and eliminate errors to critical financial data.

Here are the Top 14 Reasons why spreadsheets fall short:

  1. No pre-development design
  2. A spreadsheet’s purpose often not documented
  3. Meaningless cell references
  4. Dependencies are difficult to see
  5. Formulas are created manually
  6. “Sort” of confusing
  7. Formulas in every cell
  8. No version controls
  9. No audit trails
  10. Inconsistent data entry
  11. Security concerns
  12. Fraud
  13. Reporting deficiencies
  14. Changing a worksheet can be difficult

While spreadsheets can offer assistance in important parts of business operations, it is clear that it cannot perform all tasks businesses face for fixed asset management.  It’s important that your fixed assets are not overlooked – instead they should be properly recorded, calculated and tracked.

Fun Fact (I love these): 30% to 90% of all spreadsheets suffer from at least one major user error.

5 thoughts on “14 Reasons NOT to Use a Spreadsheet for Depreciation

  1. Pingback: Bonus Depreciation 2010 and 2011 « Crazy About Your ASSETS | b-l-o-g

  2. Pingback: SAP to FAS Asset Accounting: Live Update 7 « Crazy About Your ASSETS | b-l-o-g

  3. Pingback: Rolling Out Large Fixed Asset Management Projects « Crazy About Your ASSETS | b-l-o-g

  4. Pingback: Top 5 Ways To Find Money Through Fixed Assets « Crazy About Your ASSETS | b-l-o-g

  5. Pingback: Top 5 Ways To Find Money Through Fixed Assets « Crazy About Your ASSETS | b-l-o-g

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: