Season 2  |  Ep. 17: Inefficiencies of Spreadsheets and Manual Data Entry: A Hidden Factory Lesson
Podcast

Season 2 | Ep. 17: Inefficiencies of Spreadsheets and Manual Data Entry: A Hidden Factory Lesson

April 16, 2024

In the latest episode of the Risk Intel podcast, Beth Nilles, Watchtower's Director of Implementations, sheds light on the pervasive issues of hidden factories within the banking industry. Through a candid discussion with host Ed Vincent, Beth shares her firsthand experiences and insights into the operational challenges faced by financial institutions, particularly in the realm of data management, data analysis, and the time it takes to compile reporting when relying on manual processes.

The conversation begins with Beth reflecting on her diverse background, having worked across various banks, from smaller institutions to top-tier financial entities. Despite the differences in scale, Beth reveals that hidden factories are a common phenomenon, albeit more pronounced in smaller banks where resource constraints amplify the impact of inefficient practices.

One poignant anecdote shared by Beth involves her time at a small bank, where she collaborated closely with the Chief Credit Officer. Together, they grappled with the cumbersome task of preparing and reconciling data, diverting precious time and resources away from essential activities such as credit risk analysis. Beth recalls the frustration of relying on manual processes and spreadsheets, which not only increased the risk of errors but also hindered productivity.

“It would be really nice if we could spend more time analyzing the data and less time preparing and reconciling data [board reports]”

Beth vividly describes the laborious process of collecting and managing data, highlighting the inherent risks associated with spreadsheet-based systems. She points out instances where data integrity was compromised due to manual data entry errors or unauthorized modifications to formulas, underscoring the fragility of such makeshift solutions.

The Cost Of Hidden Factories

One of the key takeaways from Beth's account is the underestimated cost of hidden factories. While the initial investment in a centralized data management system may seem prohibitive, Beth argues that the long-term benefits far outweigh the immediate expenses. She emphasizes the hidden costs beyond monetary value, including the opportunity cost of lost time and the heightened risk of errors.

Throughout the discussion, Beth and Ed stress the importance of reevaluating current practices and investing in sustainable solutions to combat hidden factories. They urge listeners to consider the true cost of operational inefficiencies, particularly during critical periods such as quarter-end and month-end reporting cycles. By prioritizing efficiency and innovation, financial institutions can mitigate the impact of hidden factories and unlock new opportunities for growth and optimization.

"It wasn't just my time, we had to take our data, compared it to accounting's data, and then make sure the board had all the correct data they needed - if we just had a centralized system, yes a system would have cost money, but not in the long run," said Beth Nilles. "At quarter end it could have been several days wasted, probably 3 days just working on quarter end reports - I had plenty of other things to do."

In conclusion, the episode serves as a poignant reminder of the pervasive nature of hidden factories within the banking industry. Beth's personal anecdotes and insights offer valuable lessons for financial professionals navigating the complex landscape of data management and operational efficiency. By confronting hidden factories head-on and embracing transformative risk intelligence solutions, banks can pave the way for a more agile, resilient, and sustainable future.

Key Takeaways:

  1. Underestimated Cost of Hidden Factories: Financial institutions often underestimate the true cost of hidden factories. While the immediate expense of implementing centralized data management systems may seem prohibitive, the long-term benefits, including increased efficiency, reduced risk of errors, and enhanced productivity, far outweigh the initial investment.
  2. Impact on Operational Efficiency: Hidden factories hinder operational efficiency by diverting valuable time and resources away from essential activities such as data analysis and risk assessment. Manual data entry processes and reliance on spreadsheet-based systems exacerbate the problem, leading to increased labor intensity and heightened risk of errors.
  3. Importance of Sustainable Solutions: To combat hidden factories effectively, financial institutions must prioritize sustainable solutions that address underlying inefficiencies. By investing in a holistic centralized data management systems and embracing innovation, banks can streamline operations, mitigate risks, and unlock new opportunities for growth and optimization.

Overall, it's crucial for banks to recognize the hidden costs beyond monetary value, including the opportunity cost of lost time and the heightened risk of errors, and take proactive steps to address these challenges.

Catch up on previous episodes in our Hidden Factory series:

RMA RIsk Maturity Framework

Powered by SRA Watchtower

Take the self-assessment today to
measure your institutions risk maturity.
SCHEDULE a demo
risk maturity framework

EXPERIENCE. WISDOM. KNOWHOW.

Book an

SRA CONSULTING

discovery session

SCHEDULE NOW
enterprise risk management for credit unions
Three ways to tap into the people, technology and insights of SRA Watchtower.
We're focused exclusively on the serving the financial & Insurance industries.

DISCOVERY 
SESSION

Discovery Session
Schedule a 30 minute discovery call with an SRA Watchtower risk expert to understand your challenges or opportunities ahead to see how Watchtower's holistic risk intelligence platform can support your goals.
SCHEDULE NOW

WATCHTOWER
DEMO

watchtower demo
Look inside Watchtower, the holistic risk intelligence platform to learn how it helps executives navigate risk and drive growth.
BOOK TODAY

Risk Intel
Podcast

Risk Intel Podcast
Listen and learn from SRA Watchtower risk enthusiasts, customers, and experts across the financial industry through our weekly risk focused podcast.
REGISTER

RMA RIsk Maturity Framework

Powered by SRA Watchtower

Take the self-assessment today to
measure your institutions risk maturity.
SCHEDULE a demo
risk maturity framework