Almost a quarter (24%) of SME fleet managers are spending half their working day on spreadsheets, with more than half saying it prevents them from completing other important fleet tasks, new research suggests.

The survey, conducted by fleet management software company Vimcar, says that 46% of respondents find spreadsheets too time consuming and 37% say it leaves room for mistakes, with 63% admitting to having missed deadlines.

Vimcar says the systems being used by some fleet managers for keeping track of important fleet data are outdated and inefficient.

Ronald Clancy, UK country manager for Vimcar, said: “It’s clear from our research that those running fleets in SMEs are feeling defeated by their data, and it is having a negative impact on their businesses.

“Running a successful fleet starts with how its managed and fleet managers cannot be expected to run things efficiently while still relying on admin tools that aren’t fit for purpose.

“It is critical that fleet managers are well equipped with an automated and digitised management system that not only streamlines their data and daily tasks, but allows them to view, evaluate and compare the data held within the system.”

The research also reveals that the majority of fleet managers say vehicle maintenance and cost management is the most important part of their role, yet 60% are using multiple digital spreadsheets and 10% still using pen and paper, says Vimcar.

Of those surveyed, 79% have more than five different spreadsheets to keep track of important data such as cost, maintenance and mileage, with a further one-in-10 using more than 30.

Almost half said that spreadsheet set-up was too time consuming and was preventing them from completing other important tasks, with less than a quarter using a dedicated fleet management software designed specifically with their job in mind.

Vimcar customer Phillip Thompson, company firector at Active Traffic Management, said: “A fleet management solution like the one Vimcar provides give me the option to have everything in one place, which streamlines processes and gives me one system that works for everything, rather than everything spread across various spreadsheets and bits of paper.

“It also allows me to keep track of fuel costs and I have generally been able to manage my fleet better, with all-round ease.”