Payroll Transformation for Johns of Nottingham | RedSky

Transforming Payroll Efficiency with RedSky Time at Johns of Nottingham

Digitising timesheets and expenses has simplified Payroll processes at Johns of Nottingham and is saving tens of thousands of pounds a year.

After 25 years on DEMA (now a legacy software product), the prospect of migrating to the latest RedSky construction ERP solution was daunting, to say the least. But Matthew Chapman, Finance Manager at Johns of Nottingham, is very glad to have gone ahead with it.

Enhanced Efficiency Through Innovative Technology

The migration opened the doors to a new, more efficient way of working, with all documents now digitised and securely stored in a centralised online hub, ready for access within a few clicks.

It has also enabled the company to optimise many of its processes. Matthew said: “We get a lot of invoices every month – usually between 800 and 900. RedSky’s Invoice Register has digitised and streamlined our accounts payable processes, which are now around 40% faster than before.”

The Business Analytics reporting tool has also created new efficiencies and insights. “I’m not a programmer or a developer, but I’ve been able to create bespoke reports for each of our three divisions. The three most useful ones are sales ledger debtors, aged creditors and retention debtors. There’s no uploading or filtering involved – to run a report, I just press a button.” 

Having modernised Johns of Nottingham’s accounts payable and reporting processes, Matthew felt the time was right to deal with a long-standing bugbear: timesheets and expenses for the company’s 50 or so directly employed operatives.

Navigating Complex Payroll Variables for Accurate Job Costing

Payroll is by far the biggest expense for Johns of Nottingham. “Our payroll amounts to millions of pounds every year, so we need to record the time spent on individual jobs in an accurate way,” said Matthew.

The company had always relied on paper timesheets. However, processing the paper timesheets of directly employed operatives (who are all paid by the hour) had become the stuff of nightmares, mainly because of the large number of payroll variables involved. 

The process of recording these operatives’ costs on the system and then allocating them to individual jobs was labour-intensive, overly complicated and prone to error. There were so many factors involved, including:

  • Hours and mileage – if operatives worked on several different customer sites in a day, hours and mileage had to be captured accurately and allocated to the right jobs
  • Hotel and meal costs – if operatives worked for an extended period in another region, the costs of their hotel accommodation and meal allowances also had to be added to the mix and allocated to the right job(s)
  • Higher hourly rates – if any of night or weekend working was involved, these hours would need to be paid at a higher rate. 

“Every time a manager signs off a timesheet or an expense, they are effectively signing a cheque to be paid by the company,” said Matthew. “It’s a big responsibility that requires them to be super-accurate. 

“But the way that we were working was far too complicated.”

Identifying Hidden Costs in Traditional Timesheet Processes

Gathering in timesheets was often difficult too. 

Operatives would fill in a paper timesheet, get it signed off by their manager, then drive to the yard or the office at the end of the week to drop it off in person. “This was costing us an absolute fortune in travel time and petrol,” said Matthew. “I’d say we were wasting around £20,000 a year.”

From an administrative perspective, the process could be summed up in three words: 

  • Random (“some operatives dropped off their timesheets, while others preferred to send it by post or email”)
  • Time-consuming (“there were often missing timesheets to chase up…  it took me back to my school days, when excuses were along the lines of ‘the dog ate my homework’”)
  • Frustrating (“sometimes the paperwork we received was illegible, due to poor handwriting or dirt, or because it had been left in the operative’s back pocket and put through the weekly wash”).

Once all the approved paper timesheets were in, the next task was to enter all the details on the system. Every Wednesday, it would take Matthew more than three hours to complete this much-dreaded task, which required serious powers of concentration. Filing was the final job, of course, but he was usually able to delegate it.

“The entire process drove me up the wall!” he said. 

Implementing a New Digital Timesheet Solution

Matthew knew there had to be a better way – and RedSky Time fitted the bill perfectly.

This always-on, cutting-edge, online timesheet solution is designed for the construction industry. It can be accessed from any device with a browser, such as a phone or tablet, and enables workers to enter their hours on a digital form with minimum effort, at any time and from anywhere.

When he met with the RedSky team to discuss his requirements, Matthew already had a very clear idea of the data fields he wanted to include on the digital timesheet form. Most fields were to appear as dropdown lists to make sure data was entered in a consistent format by all the directly employed operatives. The operative’s name and employee number were to be preloaded on their timesheet form.

Streamlining Development and Testing of RedSky Time

Having signed up for RedSky Time, Matthew was relieved to find that the set-up process was “pretty simple really”. 

Even so, he did book consulting time with the Technical team to make sure the timesheet form included everything he needed. “We raised a fair few questions, of course. One of them was about how to capture expenses,” he said. 

“Many of our operatives have to stay in hotels, so they get a daily meal allowance. We explained the current process to RedSky – the operatives stapled their meal receipts to the back of their timesheet – and asked how that would work in the new, digitised process.”

In response to Matthew’s request, RedSky provided a solution enabling operatives to attach expenses receipts to their digital timesheet. He said: “The operatives just go on the app, click on the camera, take a photo of the receipt – it’s then automatically uploaded and attached to the timesheet.”

The Technical team pulled out all the stops to configure the timesheet form to meet all the identified requirements, including links to PD codes, to help streamline the payroll process and ensure accurate record-keeping. “There had clearly been a lot of work going on by RedSky in the background,” said Matthew.

He had to create fake accounts for the testing phase because, unlike the migration, the company didn’t have the data to work with. Nevertheless, the testing was very thorough. “I wanted us to invest time in getting the front end right, well before the roll-out,” said Matthew. “This approach definitely paid off because we were able to concatenate the data entry requirements down to certain fields. 

“For example, all the contract numbers and job numbers are available on a dropdown list, but operatives can also search by the customer’s name if they don’t have those numbers handy. We found that certain surnames were appearing a lot, which opened up the potential for error.

“To make sure the operatives always identified the right customer on the timesheet, we asked RedSky to configure a solution that concatenated the customer’s first and second name, plus the postcode of their property. We felt that all these little details were worth doing, to make sure RedSky Time worked smoothly.”

Effective In-House Training for Seamless Transition

Matthew delivered the training to the 50 directly employed operatives in small groups at the company’s head office. He said: “I told them straight: ‘This is going to make your life a whole lot easier.’”

Although the operatives would be accessing RedSky Time on their phone or tablet out in the field, during the training sessions they used laptops that were hooked up to a television.

Matthew taught them how to access the RedSky Time portal from the home screen by clicking on the portal logo. This took them straight to the log-in screen. Once logged in, they were presented with the digital timesheet form.

He said: “I showed them the fields on the timesheet form (date, contract number, van registration, task description, start and finish times, breaks and expenses) and how to enter the data. The more I delivered the training, the more familiar I became with the product, so I was able to pick out shortcuts and share them with the operatives.

“I like using technology to drive the efficiency of the business, so I was always very keen on the idea of digital timesheets. People usually don’t like change, so I was expecting a lot more backlash than I received. Admittedly, it was a bit of a stretch to get all the operatives to buy into this new way of working but they soon recognised how simple and easy it is to use the app.” 

As expected, training the nine contract managers was more of a challenge for Matthew, because of the complexity of the many checks they have to carry out before approving operatives’ timesheets and expenses claims. However, he was again able to pass on plenty of shortcuts, and the contract managers all gave the thumbs up to the new digital process.

One of them described RedSky Time as “a really good bit of software”.

Achieving Improved Accuracy and Speed in Payroll Processing

Matthew started implementing RedSky Time in July 2024. The timesheet process for the company’s 50 directly employed operatives was completely paperless by mid-September. 

“Everybody swears by RedSky Time now,” said Matthew. “The operatives love it because timesheets are so much quicker and easier for them to complete on their phones or tablets, with no end-of-week drop-offs for them to do. Most now enter their timesheet data each day, while the details are still fresh in their mind.”

This change in frequency (daily updates rather than weekly) has improved the flow of timesheet information no end.

The contract managers used to have a mad rush on a Friday afternoon or Monday morning to review a week’s worth of paper timesheets and chase up any that were missing. But with most operatives now entering their timesheet data on RedSky Time every day, managers can review the information in bite-sized chunks on screen at any point during the week – whenever is most convenient. 

Matthew added: “They still look at the tracker information from operatives’ vans, to double-check that the timings are correct, but that task is a lot easier using RedSky Time because everything’s now on screen.”

If an operative enters 39 hours on their digital timesheet but is authorised to work only 37 hours a week, their manager can quickly correct the error online by reducing the hours on the timesheet form and adding an explanatory note. 

Importantly, the operatives can now access the RedSky Time portal to view the number of hours that have been authorised by their manager, days before the payroll is run and the weekly wage is paid. This self-service approach is helping to reduce the number of payroll-related calls from operatives to the Finance team. Matthew will soon be taking this a stage further by enabling the operatives to use RedSky Time to access their payslips and P60s.

Realising Operational Efficiencies with RedSky Time 

One of the biggest efficiencies resulting from RedSky Time arises because data is entered once only (by the operative using the online form) and then validated by the contract manager online. Once the timesheet has been fully approved, the data automatically enters the Payroll system. 

The new expenses solution is working well for operatives and Finance team members alike. “For each receipt, we need to know if it’s an allowable expense so that we can get the tax right. Now that operatives’ digitised receipts are all stored logically in the system, the process of claiming back the VAT on allowable expenses is far easier.”

Matthew has set up the system to flag up any entries that don’t conform to normal parameters so that they can be checked out. He said: “I’ve created loads of reports to check the accuracy of the operatives’ timesheets. 

“For example, if a timesheet has fewer than 31 hours and the operative is neither off sick or on holiday, it’s flagged in red on the system. Duplicate entries and excessive hours are also flagged. It’s all about putting in checks and balances to make sure we get things right.

“It’s also good to know that the system maintains a robust audit trail.”

Futureproofing Payroll Processes with Continuous Improvement

Matthew is relieved to have modernised the timesheet process. “It’s like a breath of fresh air,” he said. 

“When we migrated to the latest software in April 2023, RedSky Time hadn’t even been developed, so it wasn’t part of the discussion. Yet here we are, just one-and-a-half years later, and we’ve already taken advantage of a brand-new product.

“Similarly, at the point when we signed the agreement for RedSky Time there was no facility to capture receipts. But the team took on board our feedback and by the time we went live, we had a nifty solution in place. 

“That’s one of the things I really appreciate about RedSky: they listen to customer feedback and use it to improve their software. I like that partnership approach. We are a company that wants to innovate and change, so we are a good match with RedSky.”

Summing up, Matthew offered the following advice to his fellow RedSky customers: “If you invest your time, you’ll reap the rewards. You’re in good hands with RedSky, but you’ve got to practise using the software, to really get the most out of it.” 

About Johns of Nottingham

Established in 1909, Johns of Nottingham is a third-generation, privately owned business that delivers decorative, insurance reinstatement and facilities management solutions across a wide range of UK sectors. The company has earned a strong reputation for customer service and the high-quality workmanship of its large, directly employed workforce.

Don’t delay - streamline your construction operations today.

With 50 years of experience developing construction-specific software, RedSky can provide your business with the right software solution.

Don’t delay - streamline your construction operations today.

With nearly 50 years’ experience as construction management software providers, RedSky will help find the right software solution for you. Get in touch today.

Budgeting for construction, man and woman writing construction budget on site