Spreadsheets
Customer Stories Customer Stories
Equity Administration, Equity Management & Reporting

Switching From Spreadsheets

View Case Study

Equity Management Customer Profile

Company Name:
Anonymous Public Company

Client:
Controller

Key Result:
Significant decrease in time spent due to efficient and automated reporting that auditors trust.

Certent lets us use our limited resources more productively.”

The Situation

A public company offered standard stock options plus restricted stock for its 100 participants. When a new controller joined the company, he was concerned that the Excel spreadsheet being used was inaccurate and would make it difficult to address ASC 718 requirements. Having used an online equity administration software at a previous company, the controller knew that was the direction he wanted to take.

The Transformation

The controller researched all the major players for the public company functionality he needed. He knew it was essential that the tool pass muster with their auditors. The research uncovered that Certent offered the best combination of broker neutrality and cost effectiveness, and provided a comfort level for both the finance team and the auditors.

Once the company had selected Certent, the controller and one of his team members worked together to complete the implementation. “Certent made the data conversion process easy, helping us format data properly and working with us to tie back to our Excel spreadsheets. The process was very straightforward and spanned a period of six weeks. We thoroughly tested the data from Certent against our prior 10Q and 10K to make sure it mirrored the data from our spreadsheets. Running the history gave me comfort with the Certent solution.”

The Results

The client found value in all the pieces of the Certent system. They especially appreciated having an active database, calculations for weighted average shares outstanding, and the information needed to meet SEC disclosure requirements. The disclosure (or footnote) report can take days to prepare manually – it contains 47 lines of information—but with Certent, the report can be rendered in a web page within 45 seconds.

The client also enjoys the tables and reports that mirror what they submit in their filings. The auditor is happy with the Certent solution and the clean data it provides. The client also saves time and money – the return on investment was seen in the first three to six months through a reduction of auditor questions and time spent on daily management and oversight. Using Certent for stock plan management provided a level of comfort to a company that has limited resources for managing the process.

Resources

Learn More About Equity Management & Reporting

Webinars & Videos Webinars & Videos
On Demand NVCA Q3 Webinar
Equity Management & Reporting
On-Demand Webinar: The Resilience of...
Watch Video
Webinars & Videos On-Demand Webinar: The Resilience of US VC in Q3 2020: Overcoming a Pandemic
Customer Stories Customer Stories
Attractive Indian woman office worker typing on computer
Equity Management & Reporting
Atlantic Capital Bank Minimizes Compliance...
View Case Study
Customer Stories Atlantic Capital Bank Minimizes Compliance Risk and Manual Work with Certent
White Papers White Papers
EBOOK Getting Your Stock Plans IPO-Ready
Equity Management & Reporting
eBook: Getting Your Stock Plans...
Read White Paper
White Papers eBook: Getting Your Stock Plans IPO-Ready