Why excel sales logs aren’t a good use of data

Excel SalesLogs are an excellent way of tracking your sales performance of individuals but also of the overall team and their common target. They are also commonly used to plan deliveries and act as a source of truth for many dealership sales departments.

Despite, all the data being available in a DMS, dealerships still create custom spreadsheets to measure, compare and track their daily, weekly and monthly sales performance. Does it matter?

For a number of reasons, it doesn’t make sense for dealerships to persist with siloed spreadsheets. Ideally, a Dealer Management System should have a detailed and flexible sales log that just represents the data already inputted into a format that Dealers want. This is obviously not happening, or they wouldn’t be going to the effort to create complex spreadsheets.

Stop using spreadsheets!

They are inefficient. Your sales team has already entered in the data, whether it be the sales contract or other means, it is a waste of everyone’s time to re-enter the data just to produce a report that should be automatic.

If you add up all the hours these spreadsheets cost in inputting and maintenance, is the data that is extracted really that important?

They are not secure. Because spreadsheets have the flexibility of macros imbedded into their code architecture, they can be easily customised and automated to complete tasks. This is fantastic, but it is also a security risk. Hackers, frequently target business computer users with phishing emails which often have word and excel documents attached, which then have macros programmed to exploit a companies IT infrastructure. The best way of combating this is to have a network policy of preventing macros on all devices, however this can prevent many useful spreadsheets from operating.

In addition, these spreadsheets are often full of useful data and customer information which in the wrong hands could become a target of ransomware.   

The data is siloed. By having a dedicated spreadsheet for sales performance and delivery information, this data often sits in the spreadsheet never to be referenced or cross joined to other useful data. For example. Wouldn’t it be nice if you could compare and combine your sales delivery performance with your finance performance? Or easily understand which customers have a finance application pending? Or, measure the total income generated by your salesperson including aftermarket, finance and vehicle gross?

They are not historical. Often, SalesLogs are workbooks with tabs setup for individual branches or months. By having this data housed within individual spreadsheets, it is very difficult to compare that data to previous years or even months. 

Ditching the spreadsheet could be the best decision you make this year.