BlackLine Home page BlackLine home page
Solutions
Solutions
Financial Close Management
Financial Close Management
Overview
Overview
Account Reconciliations
Account Reconciliations
Task Management
Task Management
Transaction Matching
Transaction Matching
Journal Entry
Journal Entry
Financial Reporting Analytics
Financial Reporting Analytics
Variance Analysis
Variance Analysis
Smart Close for SAP
Smart Close for SAP
Accounts Receivable Automation
Accounts Receivable Automation
Overview
Overview
Cash Application
Cash Application
Credit & Risk Management
Credit & Risk Management
Collections Management
Collections Management
Disputes & Deductions
Disputes & Deductions
Team & Task Management
Team & Task Management
AR Intelligence
AR Intelligence
Invoicing & Compliance
Invoicing & Compliance
Intercompany Financial Management
Intercompany Financial Management
Overview
Overview
Intercompany Non-Trade
Intercompany Non-Trade
Intercompany Balance & Resolve
Intercompany Balance & Resolve
Intercompany Net & Settle
Intercompany Net & Settle
By Organization Size
By Organization Size
Midsize Organizations
Midsize Organizations
Large Enterprises
Large Enterprises
By Industry
By Industry
Banking & Financial Services
Banking & Financial Services
Consumer Products & Services
Consumer Products & Services
Energy & Raw Materials
Energy & Raw Materials
Healthcare & Life Sciences
Healthcare & Life Sciences
Manufacturing
Manufacturing
Retail
Retail
Technology, Media & Communications
Technology, Media & Communications
See All Industries
By ERP
By ERP
SAP
SAP
Oracle
Oracle
Oracle NetSuite
Oracle NetSuite
Microsoft Dynamics
Microsoft Dynamics
See All ERPs
By Topic
By Topic
Environmental, Social, and Governance
Environmental, Social, and Governance
Recruiting & Retaining Top Talent
Recruiting & Retaining Top Talent
Enabling an ERP Transformation
Enabling an ERP Transformation
CFO & CIO Collaboration
CFO & CIO Collaboration
F&A Transformation
F&A Transformation
IPO Readiness
IPO Readiness
Mergers & Acquisitions
Mergers & Acquisitions
Revenue Cycle Optimization
Revenue Cycle Optimization
Regulatory Compliance
Regulatory Compliance
Customers
Customers
Customer Success
Success Stories
Success Stories
Community
Community
Services
Services
Overview
Overview
Professional Services
Professional Services
Training & Education
Training & Education
Customer Success
Customer Success
Transformation Services
Transformation Services
Global Support
Global Support
Resources
Resources
Events
Events
Upcoming Webinars
Upcoming Webinars
On-Demand Webinars
On-Demand Webinars
White Papers
White Papers
Blog
Blog
Accounting Glossary
Accounting Glossary
Developer Portal
Developer Portal
About
About
Company
Company
About BlackLine
About BlackLine
Leadership
Leadership
Diversity, Equity & Inclusion
Diversity, Equity & Inclusion
Environmental, Social & Governance
Environmental, Social & Governance
In the News
In the News
Press Releases
Press Releases
Investors
Investors
Awards & Recognition
Awards & Recognition
Careers
Careers
Partners
Partners
Consulting Alliances
Consulting Alliances
Solution Provider Partners
Solution Provider Partners
Software & Cloud Partners
Software & Cloud Partners
Business Process Outsourcers
Business Process Outsourcers

3 Reasons You're Stuck on Spreadsheets

image

The unexpected and unprecedented disruption we experienced throughout 2020 shone a spotlight on all the issues that arise when accounting teams rely on manual processes, especially while closing the books with a distributed workforce.

So, as a continuation of our Spreadsheet Series, we partnered with Capstone Insights to quantify how pervasive spreadsheet use was last year, identify the pitfalls involved, and explore the reasons why relying on these manual processes can feel like such a hard habit to break.

For their recent report, Global Confidence Check for Finance and Accounting, Capstone Insights surveyed 1,520 F&A professionals, asking a battery of questions to explore the ways organizations use software to fulfill their accounting and finance requirements. The questions regarding spreadsheet use led to some interesting discoveries:

  • 63% of global survey respondents reported extensive use of spreadsheets in their monthly close process

  • At 69%, Australian F&A professionals reported the most reliance on spreadsheets for managing the monthly close, followed by the UK at 63% and Spain at 59%

  • SaaS-only organizations expressed higher confidence in the accuracy of their data, with 77%agreeing or strongly agreeing that they had complete trust in the numbers vs. only 57%of their spreadsheet-only peers

Spotting Spreadsheets in the Wild

We already knew reliance on spreadsheets and manual processes was common in accounting circles, but we were surprised by how many survey respondents heavily relied on them during the month-end close. We talked with some of our customers to dig a little deeper into how spreadsheets are being used today, and especially when they undermine confidence in data accuracy.

Quest

Prior to deploying BlackLine, Quest Diagnostics’ accounting teams were leveraging a combination of Excel spreadsheets and paper filing systems to fulfill their monthly financial close obligations. Employees had difficulty tracking the status of account reconciliations, a challenge that was compounded as the company made acquisitions and added general ledger accounts. Before closing the books each month, Quest’s employees would run a trial balance to identify areas that were not reconciled and needed more work. This process was labor-intensive and could not be supported as a permanent practice.

Union Bank & Trust

Union Bank and Trust’s reconcilements were tracked using spreadsheets that were printed, put in binders, transported to the relevant departments, and then manually checked for errors before being approved. The process itself was labor-intensive and inefficient, and after it was completed, the binders were stored off-site, taking up significant storage space.

Hershey Company

For Hershey, reconciliation of accounts was particularly problematic, with 4,104 active account reconciliations prepared by 121 people and approved by 77 people—all with varying styles, formats, and deadlines. Data was kept in spreadsheets, on paper, and in emails, and was stored in shared drives, local computers, and file cabinets rather than in a central repository. It was clear that Hershey needed a far more efficient approach.

In these and countless other discussions with current and prospective customers, we identified three common themes for companies that are having a hard time letting go of spreadsheets—including the ones collecting dust in a storage unit.

Rapid Growth

Mergers, acquisitions, and expansion are signs of opportunity, but they can also introduce disparate systems, information hierarchies, and approval processes. Some F&A professionals report needing a close spreadsheet to keep track of all the close spreadsheets!

“As a global organization, having visibility into the entire balance sheet is a need,” says John Zimmerman, Director of Financial Data Systems at Hershey. “The more global we became, the more oversight we needed into the chart of accounts. We were looking for process efficiency around balance sheet control, preparation, and reconciliation.”

Inertia

Resistance related to inertia may sound a lot like “But our spreadsheets are already built out,” or “If it’s not broken, don’t fix it,” or even “But we’ve always done it this way!” The older an organization is, the more likely that it has entrenched manual processes. After all, if you’ve put a lot of effort into figuring out how to get everything to work together, you may be less inclined to abandon that process, even if the system is no longer serving you.

Fear

Change is hard, and humans are, as a species, very resistant to it. Stakeholders may be concerned that moving away from spreadsheets might take too long, or that the ROI might not be sufficient to justify the investment of time and money required. The good news is that BlackLine returns $2.67 on average for every dollar spent, and we offer guided 60- and 90-day implementation and role-based training to get you up to speed fast.

Read the full Capstone Insights report to discover where organizations are reporting the largest gaps in F&A performance and strategies for improving organizational effectiveness, transparency, and collaboration.

Get your copy