• Product
        • Planning Maestro
          • Product Overview
          • Watch Demo
          • Schedule a Live Demo
          • Plans
          • Service & Support
        • Capabilities
          • Consolidation
          • Budgeting
          • Forecasting
          • Scenario Planning
          • Performance Dashboards
          • Financial Reporting
  • Solutions
        • Industries
          • Nonprofit
          • Healthcare & Life Sciences
          • Finance & Insurance
          • Manufacturing & Distribution
          • Retail & Hospitality
          • Software & Technology
          • Other Industries
        • Integrations
          • QuickBooks Online
          • Microsoft Dynamics 365
          • Sage Intacct
          • NetSuite
          • Abila
          • Other Integrations
  • Resources
        • All Resources
          • Our Blog
          • Webinars
          • Whitepapers & E-Books
          • Videos
          • Customer Case Studies
  • Company
        • About Us
        • Leadership Team
        • Partners
        • Press & News
        • Awards
        • Careers
  • Contact
  • Search
  • Menu Menu
Help Hub
Search
Watch Demo Request A Quote

Our Blog

An Open Door – Where Security Falls Short with Excel Budgets

June 26, 2018/ budgeting and planning, budgeting software/By Jason Lin, Chief Financial Officer

Using Excel for financial functions is on the decline, per the 2018 Benchmarking the Accounting and Finance Function report conducted by the Financial Executives Research Foundation.

Many companies moving off Excel cite the need for better collaborative tools and the need to be able to handle larger and larger data sets.

Another significant area where Excel falls short? Security. While the other issues can cause productivity slowdowns, the lack of security features in Excel can mean data getting into the wrong hands, or worse, lead to lawsuits because of unprotected data.

Not Intended for Security

Excel has a few features that allow a user to limit access to others. Things like file level password protection, workbook level protections and even worksheet level limitations are intended to prevent users other than the document’s creator to perform certain actions, such as adding or deleting cells, rows or columns or even changing data within a sheet.

Yet even Microsoft warns that these tools are not intended as security features, warning that you should not assume that the information in your spreadsheet is secure.

Where Excel Falls Short

When it comes to budget and financial planning, there are minimum features that organizations should utilize to protect their sensitive information. These features go far beyond simple file level password protection.

Probably the biggest threat to data stored in Excel is the lack of individual user access controls. When an Excel spreadsheet is password protected, it is given a single password for all users. If you have the spreadsheet and the password, you have access to all the data within.

Therefore, to have different departments collaborate on an organization’s budget, you have two options: create multiple spreadsheets or expose data to everyone.

Creating multiple spreadsheets means dividing the spreadsheet up and then spending valuable time re-combining sheets, importing data, and checking and re-checking to ensure the data and formulas are correct. After all of this, there is still no guarantee that data integrity has been maintained.

It isn’t just about your employees seeing data they shouldn’t. A spreadsheet containing all of your company’s financial data, falling into the wrong hands, can be easily compromised even with password protection.

Even utilizing the protections Excel does offer, those can be easily defeated. Opening an Excel spreadsheet in other spreadsheet programs removes some of the protections that can be added, like hidden sheets and locked cells and rows.

Excel works best, and is most secure, as a single user tool. Once you begin sharing, you open your data and ultimately your organization to significant risks.

Protecting your budgeting and planning data is paramount to success. When creating and storing business-critical data, organizations of every description rely on the Budget Maestro™ family of software solutions by Centage Corporation to improve the efficiency and effectiveness of their business budgeting and planning, financial forecasting, financial consolidation and reporting processes. For more information, take a tour of Budget Maestro, contact Centage, or call 800-366-5111 now

https://www.centage.com/wp-content/uploads/2022/10/cyber-security-cybersecurity-device-60504-scaled-1.jpg 1707 2560 Jason Lin, Chief Financial Officer /wp-content/uploads/2022/10/Group-780.svg Jason Lin, Chief Financial Officer2018-06-26 12:00:212022-11-01 19:40:11An Open Door – Where Security Falls Short with Excel Budgets
Back to List

Also by This Author

  • The Real Budgeting and Planning Complexities for Today’s Businesses
  • Forever Changed: The Rise of Cloud FP&A for Business Budgeting
  • Forever Changed: Business Budgeting for SMBs
  • The New Normal: Financial Consolidation and Data Transformation – Bringing Value to FP&A
  • Driver-Based Planning: The Benefits & The Barriers – Is It Right for Your Organization?

View Demo Video

Request a Quote

Centage Corporation
330 Cochituate Road, #807
Framingham, MA 01701
P: 800.366.5111

  • Product
  • Industries
  • Integrations
  • Resources
  • Company
  • Contact
  • Help Hub
  • Watch Demo
  • Request a Quote

© 2022 Centage

Privacy Policy

Terms of use

Sitemap

  • Product
    • Planning Maestro
      • Product Overview
      • Watch Demo
      • Schedule a Live Demo
      • Plans
      • Service & Support
      • Back
    • Capabilities
      • Consolidation
      • Budgeting
      • Forecasting
      • Scenario Planning
      • Performance Dashboards
      • Financial Reporting
      • Back
    • Back
  • Solutions
    • Industries
      • Nonprofit
      • Healthcare & Life Sciences
      • Finance & Insurance
      • Manufacturing & Distribution
      • Retail & Hospitality
      • Software & Technology
      • Other Industries
      • Back
    • Integrations
      • QuickBooks Online
      • Microsoft Dynamics 365
      • Sage Intacct
      • NetSuite
      • Abila
      • Other Integrations
      • Back
    • Back
  • Resources
    • All Resources
      • Our Blog
      • Webinars
      • Whitepapers & E-Books
      • Videos
      • Customer Case Studies
      • Back
    • Back
  • Company
    • About Us
    • Leadership Team
    • Partners
    • Press & News
    • Awards
    • Careers
    • Back
  • Contact

    Quick Links

  • Help Hub
  • Watch Demo
  • Request a Quote

Stay Informed