Outdated processes were slowing down SOX reporting and review at Dr Pepper Snapple Group.
Use Wdesk for Controls Management to accelerate report development and support strategic planning initiatives.
- Collaboration on strategic planning with SOX experts from Workiva
- Time-savings on administrative tasks and report development
- Real-time status reports for management
SOX Compliance, SEC Reporting, Financial Reporting
When you think of products from Dr Pepper Snapple Group (DPS), the word that comes to mind is “refreshing.” While the products, which include 7UP, Canada Dry, and Sunkist, are refreshing, the company’s SOX compliance process was anything but. Instead, it was outmoded, slow, and frustrating.
Eddie Holt is the SOX compliance manager for DPS. While he is responsible for SOX compliance, quarterly SOX reports to management, and preparing audit committee reports, he relies on people throughout the company for data, review, and testing. Holt has extensive SOX compliance experience working for other companies. After arriving at DPS and understanding its process, he began looking for a more efficient way to track testing progress and produce SOX reports.
He categorizes the company’s previous SOX compliance process as “pretty typical” and “manual.” Information was gathered from around the company, processed in Word® and Excel®, stored in SharePoint®, and reported to management using PowerPoint®. The cumbersome approach caused version control issues and made it difficult to track document changes, especially in the company’s 2,000-line control spreadsheet.
“A lot of people were working on it,” explains Holt. “You were never feeling really sure if somebody changed something and you didn’t know about it. Trying to keep up with that was just a nightmare.”
With a green light from management to find a better solution, DPS assembled a team from around the organization, including internal auditors, compliance managers, and other users, to choose a solution. “They all had some skin in the game for making it a success, so we were all headed toward the same goal.”
The team looked at several options, but most vendors only wanted to implement enterprisewide solutions. Since DPS was already using Wdesk for SEC reporting, the team just needed a solution for SOX compliance. “When it came down to it, Wdesk was the solution that really worked for us. It was the best for sure,” comments Holt.
A demonstration of the Wdesk blacklining function, which shows when and where changes were made, helped seal the deal. “The ability to see what was changed, who changed it, and when was a huge factor. In fact, it may have been the final point that tipped the decision for us,” explains Holt.
DPS uses a lean management method called “value stream mapping,” which involves analyzing current processes and then designing a future, improved state. Before implementing Wdesk for Controls Management, Holt invited his Workiva solution architects and customer success managers to take part in the value stream mapping exercise for SOX.
The two Workiva teams used an iterative process to help the DPS team understand how Wdesk fit into the team's plans and supported its goals. “Having someone there who is an expert in your system, an expert in SOX, and who sees lot of companies’ best practices was a big advantage,” says Holt. “The Workiva representatives understood what we were trying to do, then they redesigned our process, and went about implementing Wdesk for us.”
Holt expected the full implementation to take six months. “Wdesk was up and running in just a few weeks!” he says. After the solution was in place, Holt loaded his data, built matrices, test sheets, and plans. Now, DPS is seeing results.
“The beauty of Wdesk is that it cuts down on so much administrative time. I don’t have to ask 30 people how we’re doing because it’s already on a dashboard in the system,” Holt explains. “With Wdesk I have real-time answers for where we are in percentage of completion and deficiencies. It’s been a huge time-savings for us.”
Holt especially appreciates the linking capabilities in Wdesk. “It’s the coolest thing to go in and change one control, and then it’s changed all the way through. We really like that.”
DPS used Wdesk to build a risk control matrix (RCM), a self-assessment library, and a control library. Then, DPS linked them with its test plans and used the dashboards to track it all. “Now that the dashboards are connected to our testing, I know our progress in real time,” Holt says.
That’s particularly important when he’s working on presentations to give to the audit committee board. “In the past, the information they’d get was at least two weeks old—sometimes three. Now, they get up-to-date information. That’s a huge advantage because management can see where we are on a more timely basis.”
And with Wdesk, DPS can measure and report on things it's never measured before, including the number of tests each compliance manager or tester completes. Holt uses that information to balance workloads.
Wdesk also streamlines the partnership with external auditors because they see how everything is linked and where changes are made in real time. “We set things up for them to view, and they go in and do what they need to do,” explains Holt. “The feedback from them has been great.”
Wdesk is saving time at different stages of the DPS SOX process. “I spend less time gathering information now, so I have more time to look at deficiencies and evaluate test plans,” explains Holt. The narrative review process, which he says used to be slow and painful, is improved because everyone comments in the same platform and can review each other’s input. And compliance managers say Wdesk simplifies their work, too.
Holt expects even more time-savings in the second year of using Wdesk. “Now that everything is linked, when we refresh next year, all of that information will already be in there,” he notes. That’s going to liberate him—as well as compliance managers and internal auditors from so much routine SOX work. “That will free them up to do more of the things they were hired to do.”
Microsoft Excel and Word are registered trademarks of Microsoft Corporation in the United States and/or other countries.
The information contained herein is proprietary to Workiva and cannot be copied, published, or distributed without the express prior written consent of Workiva. © 2016.