• FREE RESOURCES
        • Accounts Payable
          Finally! The trick to securing greater T&E compliance
          Benefits
          Rooting out folks who don’t belong on your health plan: A 6-point dependent audit checklist
          IT
          3 costly misconceptions about biz email compromise
          Credit and Collections
          Collecting via email: 4 must-make moves in your subject line
          Accounts Payable
          5 Tough-to-spot signs that an invoice is fake
  • PREMIUM CONTENT
        • Staff management
          120 Proven Communications Tips for Today’s CFO
        • Payroll
          Handling Nonexempt Employee Pay: Stay Compliant and Avoid DOL Audits
          Accounts Payable
          T&E Best Practices: Complete Guide to Ensure Compliance
          Payroll
          Payroll Best Practices: 4 Ways to Save Time and Money
        • Staff management
          Email Best Practices: A 6-Question Quiz
          Staff management
          Innovative Communications Strategies: An Email Case Study
          Staff management
          A 5-part Framework for Successful Workplace Communications
        • SEE MORE
          PREMIUM RESOURCES
  • CORONAVIRUS RESOURCES
  • LOG IN
  • SIGN UP FOR FREE

Resourceful Finance Pro

  • FREE RESOURCES
        • Accounts Payable
          Finally! The trick to securing greater T&E compliance
          Benefits
          Rooting out folks who don’t belong on your health plan: A 6-point dependent audit checklist
          IT
          3 costly misconceptions about biz email compromise
          Credit and Collections
          Collecting via email: 4 must-make moves in your subject line
          Accounts Payable
          5 Tough-to-spot signs that an invoice is fake
  • PREMIUM CONTENT
        • Staff management
          120 Proven Communications Tips for Today’s CFO
        • Payroll
          Handling Nonexempt Employee Pay: Stay Compliant and Avoid DOL Audits
          Accounts Payable
          T&E Best Practices: Complete Guide to Ensure Compliance
          Payroll
          Payroll Best Practices: 4 Ways to Save Time and Money
        • Staff management
          Email Best Practices: A 6-Question Quiz
          Staff management
          Innovative Communications Strategies: An Email Case Study
          Staff management
          A 5-part Framework for Successful Workplace Communications
        • SEE MORE
          PREMIUM RESOURCES
  • CORONAVIRUS RESOURCES
  • Accounts Payable
  • Credit and Collections
  • Payroll
  • Accounting
  • Benefits
  • Finance Technology
  • Sales & Use Tax
  • More
    • Employment Law
    • Strategy
    • Policy and Culture
    • Fraud
    • Budgeting and Forecasting
    • Banking
    • Staff Management
    • Cost Control
  • Finance Technology
2 minute read

Survey: Spreadsheets still prevalent in financial processes

despite newer tech many companies cling to tried and true programs
Alyssa Pedrick
by Alyssa Pedrick
July 1, 2021
  • SHARE ON

Regardless of how much the FinTech world criticizes manual spreadsheets, they’re still a reality for the majority of finance teams.

Almost two-thirds (64%) of companies still use spreadsheets in some way to support their payment processes, according to a recent survey from market research company International Data Corporation (IDC).

While companies might like to ditch manual spreadsheets for more automated processes, sometimes, that’s not a possible move. Whether it’s due to economic constraints or the fact that staffers are Excel pros and it simply works well, it’s safe to say manual spreadsheets will be around for some time to come.

Update and optimize spreadsheets

Of course, if your team’s going to use tried-and-true spreadsheet programs like Excel, you want them to do so efficiently.

It’d be smart to talk to your finance managers and verify their staffers have the latest version of Excel installed. (And, going forward, they should continue to look out for updates.)

If they haven’t updated the program for some time, they could be missing out on things like:

  • new functions (like CONCAT, aka, a new version of CONCATENATE)
  • more chart options (like map charts to display geographical data or funnel charts to display values across process stages)
  • enhanced sharing (e.g., quickly inserting recent links, viewing/restoring changes in shared workbooks, saving files to recent folders faster), and
  • developments in business analytics (e.g., publishing locally stored Excel files to Power BI for online viewing).

In addition, you’ll want to make sure staffers are regularly upping their skills and becoming more efficient with spreadsheets. That will save your company time and money.

How Not to Wreck Your Reconciliations

For example, you could bring in an expert to host training session semi-annually to go over recent updates and more strategic functions, formulas and data analysis tips. You could also encourage staffers to regularly share their spreadsheet best practices for data entry, keyboard shortcuts, formatting and more.

Alyssa Pedrick
Alyssa Pedrick
Alyssa, a member of the Resourceful Finance Pro staff, has written extensively on business and finance for several years. She has produced content for accounts payable professionals and finance executives and has developed whitepapers and infographics for the finance and accounting industry.

Get the

Resourceful Finance Pro Logo

Newsletter

With Resourceful Finance Pro arriving in your inbox, you will never miss critical stories on accounting, benefits, payroll & employment law strategies.

  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • This field is for validation purposes and should be left unchanged.
Resourceful Finance Pro Logo
  • ABOUT
  • CONTACT
  • WRITE FOR US
  • ADVERTISE WITH US
  • Accounting
  • Benefits
  • Payroll
  • Policy and Culture
  • Employment Law
  • Fraud
  • Finance Technology
  • Sales & Use Tax
  • Accounts Payable
  • Credit and Collections
  • Strategy
  • Budgeting and Forecasting
  • Banking
  • Staff Management
  • Cost Control

Resourceful Finance Pro, part of the SuccessFuel Network, provides the latest Finance and employment law news for Finance professionals in the trenches of small-to-medium-sized businesses. Rather than simply regurgitating the day's headlines, Resourceful Finance Pro delivers actionable insights, helping Finance execs understand what Finance trends mean to their business.

Privacy Policy | Terms of Service
Copyright © 2023 SuccessFuel

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In

During your free trial, you can cancel at any time with a single click on your “Account” page.  It’s that easy.

preloader