Almost half of financial professionals are still using Excel for debtor management

Despite the increasing availability of innovative new software on the market, nearly half of finance professionals can't escape from Excel.

wilco July 5, 2022
4 min read

Our Fintech Barometer, which gathers a range of data-related insights from the finance sector, is now in its fifth consecutive year, and among the significant statistics we found was the continued reliance on legacy solutions. Despite the increasing availability of innovative new software on the market, it remains the case that nearly half (49%) of finance professionals do not escape Excel, for making spreadsheets to log information and updates of customer payments into their business.

Even more concerning, this figure represents a slight increase on 2021 levels (46%), further reflecting the fact that the industry’s reliance on the long-standing application doesn’t look like it’s disappearing at any point soon. With Excel proving to be a mainstay, there’s also been a decrease in professionals using specialist credit management software, reducing from 38% in 2021 to 36% in 2022, and almost one-in-ten (8%) said that they don’t use any type of program for debt management.

Escape Excel

The tendency to keep Excel programs in place is particularly problematic due to data being based on disparate spreadsheets, with a resultant inability to integrate and share data securely between colleagues. This essentially leads to finance professionals working in inefficient individual siloes with a lack of focus on collaboration, and it’s this working culture which is also likely to be contributing to the bigger challenges in the order-to-cash process today.

Further findings from our research showed that 27% identified a lack of relevant insight into the customer’s situation as an issue, while accessing the right risk information (26%) and not having the correct technology/automation (24%) in place were also identified as among the biggest issues in improving credit management.

Free from frustrations

Sticking with Excel may also be playing a key role in the most frustrating aspects of a finance professional’s role today. Respondents identified manual, repetitive tasks (20%), systems that do not work well (16%) and dealing with a lot of different systems (14%) as among the biggest annoyances. A centralised cloud-based credit management platform with real-time data in one location, such as Credit Manager, can provide automated processes to help professionals bring structure to their working day.

The inability to gain oversight of data due to continued use of Excel is also likely to prevent finance professionals from effectively analysing datasets, with analytical ability considered a key skill by almost half (47%) of financial professionals.

Shaking off the shackles of isolated solutions

Undoubtedly, Excel is a useful tool in isolation, but finance professionals are essentially attempting to nurture customer relationships with their hands tied due to the inability to access data from across the business. With a centralised platform in place, professionals are able to break free from the shackles and escape Excel, while sharing real-time data to boost productivity and efficiency, providing a competitive edge in an increasingly digitised finance sector.

See the full picture of data insights in 2022 by reading our Fintech Barometer 2022 report.

Related
posts

Onguard office - 2025

E-invoicing mandates are here: What you need to know

Onguard and Storecove sat down for a joint session on the e-invoicing mandates reshaping how European businesses get paid. The takeaway: this isn’t a future problem anymore. France’s mandate went live on 1 September. Germany, Poland, Spain and Slovakia are next, with the EU’s ViDA directive setting a 2030 ceiling for the rest.

Onguard change of MD

Onguard announces change of Managing Director

Onguard announces a change in its Managing Director leadership, effective 1 August 2026. Adriaan Kom, who led Onguard for the past six years, has stepped down to take on a new opportunity in Rotterdam, his hometown. He has been succeeded by Dennis Kromhout van der Meer, proposed by parent group Norvato, who has taken on the role of Managing Director.

Onguard 2025 office -43

3 lessons for credit management in 2026: What the FinTech Barometer shows about DSO ownership

Onguard’s FinTech Barometer 2026 surveyed 336 CFOs, finance managers and credit management professionals in the Netherlands. The data shows that DSO isn’t a data problem, it’s an ownership problem: 81% of credit teams only explain DSO after the fact, 48% can plan incoming cash with confidence no more than two weeks ahead, and 1 in 9 organisations has no one to call when a DSO target is missed. For finance teams that want to lower DSO in 2026, fixing ownership matters more than adding another dashboard.