Good afternoon, ladies and gentlemen. My name is Catherine, and I will be your host operator on this call. After the prepared comments, we will conduct a question-and-answer session. Instructions will be provided at the time. [Operator Instructions] Please note that, this call is being recorded on August 4, 2020, at 5:00 p.m. Eastern Time.
I'd now like to turn the meeting over to your host for today's call, Adam Terese, Director of Investor Relations at Workiva. Please go ahead..
Good afternoon, and thank you for joining us for Workiva's second quarter 2020 conference call. Today's call has been prerecorded and will include comments from our Chief Executive Officer, Marty Vanderploeg; followed by our Chief Financial Officer, Stuart Miller. We will then open the call up for a live Q&A session.
Jill Klindt, our Chief Accounting Officer will also be on the call. A replay of this webcast will be available until August 11. Information to access the replay is listed in today's press release, which is available on our website under the Investor Relations section.
Before we begin, I would like to remind everyone that during today's call, we'll be making forward-looking statements regarding future events and financial performance, including guidance for the third quarter and full fiscal year 2020. These forward-looking statements are subject to known and unknown risks and uncertainties.
Workiva cautions that these statements are not guarantees of future performance. All forward-looking statements made today, reflect our current expectations only and we undertake no obligation to update any statement to reflect the events that occur after this call.
Please refer to the company's annual report on Form 10-K and subsequent filings for factors that could cause our actual results to differ materially from any forward-looking statements. Also, during the course of today's call, we will refer to certain non-GAAP financial measures.
Reconciliations of non-GAAP to GAAP measures and certain additional information are also included in today's press release. With that, we'll begin by turning the call over to our CEO, Marty Vanderploeg..
Thank you, Adam, and thank you to everyone for joining today's call. Despite challenges from the COVID-19 pandemic, we are pleased with our second quarter 2020 financial results, which exceeded guidance for revenue and operating results. Our results reflect our employees' resiliency and their dedication to our customers.
Our sales and marketing teams have successfully transitioned to a virtual environment, and we now have greater visibility into the second half of the year. As a result, we are reinstating full year guidance, which is close to our pre pandemic full year guidance for revenue.
Stuart will provide further details about our financial results and outlook later in the call. In Q2, demand for our platform improved across all of our growth vectors, which include EMEA, Wdata, and our platform solutions for Integrated Risk, Global Statutory Reporting, and the U.S. Government.
Our partnerships with technology companies and advisory firms remains an important catalyst for our long-term growth. We are proud that three of the four largest advisory firms in the world are now Workiva partners.
Customers are embracing our new platform's capabilities as we further streamline their complex business and reporting processes by connecting teams documents and data from initial sources to final reports. Our new platform also increases our flexibility and speed when developing new solutions, enabling us to enter more markets faster than ever.
For example, our FERC reporting and ESEF solutions were both launched on the new platform. After identifying the opportunity, we quickly moved from concept to launch within a few months. Developing and delivering new solutions on our platform will continue to be a key driver to our success.
As we discussed last quarter, we switched to virtual marketing events in response to COVID-19. We have been pleased with the large attendance at our virtual events and the number of sales leads generated. Next month, we will host our Annual Amplify Global User Conference virtually.
This year's timely theme is “Building trust in business data and supporting business continuity in an age of transformation.” Over 4,500 people have already registered to attend. At Workiva, culture is a key driver of our success.
Every day, whether we are in our offices or working remotely, our employees create award-winning workplace that attracts and retains top talent. Recently, Computerworld named Workiva One of the 2020 Best Places to Work in IT. And Fortune named us a 2020 Best Workplace in New York.
In closing, we are pleased with our second quarter results and our team's ability to effectively execute during this challenging time. We remain well positioned and confident in our ability to capitalize on the many opportunities that lie ahead of us. With that, I will turn it over to Stuart Miller. .
Thank you, Marty. Following the initial shock of COVID-19 in March, we began to see a more predictable cadence to closing deals particularly in June and into July suggesting that our customers and prospects are settling into a new normal.
I want to highlight one market development related to COVID-19, the Financial Conduct Authority or FCA that the U.K. regulator has opened a consultation on whether it should delay the initial ESEF reporting deadline by a year. While the comment period lasts another month, we expect the FCA to approve the delay for U.K. companies.
Of the 5,300 companies affected by the ESEF mandate, approximately 1,400 are headquartered in the U.K.. Our expectation of a delay of the mandate for the U.K. market has had no material impact on our outlook for EMEA. Now turning to our financials. As always, I will talk about our results and guidance on a non-GAAP basis.
Refer to our press release for a reconciliation of our non-GAAP and GAAP results and guidance. I'll address our performance against Q2 guidance first. We beat Q2 2020 revenue guidance at the midpoint by $3.3 million. Higher subscription revenue accounted for most of the beat.
We succeeded in collecting a high percentage of the receivables that we had held in reserves at the end of Q1. The pandemic had less of an impact on collections than we had anticipated in March. We beat guidance on Q2 operating income by more than $5 million. The revenue beat I just mentioned accounted for 2/3 of the swing.
Lower employee travel and entertainment and medical care expenses accounted for the remaining 1/3 of the beat on operating income. Now turning to a comparison of Q2 2020 to Q2 last year. We generated total revenue in the second quarter of $83.9 million, an increase of 14.1% from Q2 2019.
Breaking out revenue by reporting line item, subscription and support revenue was $70.7 million, up 16.9% from Q2 2019. New logos and new solutions helped drive strong revenue growth in Q2 2020. 53% of the increase in S&S revenue in Q2 came from new customers added in the last 12 months.
The balance of the increase came from companies who have been our customers for more than a year. Professional services revenue was $13.2 million in Q2 2020, an increase of 1.2% from the same quarter last year. Growth in revenue from setup and consulting overcame a small decrease in XBRL services relative to Q2 last year.
Turning to our supplemental metrics, we finished Q2 with 3,512 customers, a net increase of 91 customers from Q2 2019 and a net increase of five customers from Q1 2020. The average annual contract value of the new logos signed in Q2 2020 was 34% higher than the same value for a churn account in Q2. Our revenue retention rates remained strong.
Our subscription and support revenue retention rate was 94.5% for the second quarter of 2020 compared to 95.4% for the same period last year. Almost half the attrition in the quarter came from M&A, delistings, and bankruptcies.
With add-ons, our subscription and support revenue retention rate was 107.9% for the second quarter of 2020 compared to 114.5% in Q2 2019. The decline reflects winding down conversion of customer contracts to solution-based licensing as well as pandemic-related impacts on both price increases and solution churn.
We continue to increase our number of larger subscription contracts. In the second quarter of 2020, we had 716 contracts valued at over $100,000 per year, up 28% from Q2 of the prior year. The number of contracts valued at over $150,000 totaled 342 customers in the second quarter, up 44% from Q2 2019 results. Moving down the P&L.
Gross profit totaled $62.4 million in Q2, up 16.4% from the same quarter a year ago. Consolidated gross margin was 74.4% in the latest quarter versus 73% in Q2 2019 a net expansion of 140 basis points. Breaking out gross profit.
Subscription and support gross profit totaled $59 million, equating to a gross margin of 83.5% on S&S revenue, a contraction of 30 basis points compared to Q2 2019. Additional headcount to help upgrade customers to our new platform was the primary driver of the contraction.
Professional services gross profit in the second quarter was $3.4 million equating to a 25.7% gross margin compared to 22.8% in Q2 2019. Research and development expense in Q2 totaled $21.5 million, up 7.6% from Q2 2019, primarily due to higher compensation costs. R&D expense as a percentage of revenue improved 25.6% in Q2 2020 from 27.1% in Q2 2019.
Sales and marketing expense for the quarter increased 23.5% from Q2 2019 to $32.3 million, primarily reflecting our investment in sales talent to drive bookings growth. General and administrative expenses totaled $10.5 million in Q2, up $3.1 million compared to Q2 2019.
G&A expenses as a percentage of revenue increased 240 basis points to 12.5% due to severance costs, additional headcount and higher software expenses. We posted an operating loss of $1.9 million in Q2 2020 compared to an operating profit of $86,000 in Q2 2019. Workiva's operating margin in Q2 was better than our guidance as I discussed earlier.
Turning to our balance sheet and cash flow statement. At June 30, 2020, cash, cash equivalents and marketable securities totaled $509 million an increase of $12.5 million compared to the balance at March 31, 2020.
In Q2, 2020, net cash provided from operating activities totaled $7.1 million, compared with cash provided of $18.8 million in the same quarter a year ago. At the end of each quarter, we review outstanding invoices to determine which ones present a collection risk due to a variety of factors including credit risk consistent with ASC 606.
We remove the invoices at risk and take the amounts out of both accounts receivable and deferred revenue until payment is collected which is when we begin to recognize that revenue. At June 30, 2020, we classified $5.6 million of receivables to this reserve account, up from $3.2 million of receivables at June 30, 2019.
This reserve account reduced deferred revenue by an equal amount and therefore it reduced billings at the end of the quarter. Remaining performance obligations on subscription contracts continue to vary from deferred revenue as we implement multiyear contracts with annual billing terms for some customers. Turning to our guidance.
As Marty indicated, we are reinstating guidance for full year 2020 based on improved visibility on new business both pipeline and deals closing. Our new full year guidance is close to our pre-pandemic full year guidance on revenue and substantially improved on operating loss.
We are factoring in the expected impact of COVID-19 on our business and results of operations based on information available to us today. For the third quarter of 2020, we expect total revenue to range from $84.3 to $84.8 million. We expect subscription revenue to grow at a faster rate than services revenue in Q3.
We expect non-GAAP operating loss to range from $5.2 million to $5.7 million. For full year 2020, we expect total revenue to range from $341.5 million to $342.5 million. We expect non-GAAP operating loss to range from $11.5 million to $10 million. We will now take your questions. Operator, we're ready to begin the Q&A session. .
[Operator Instructions] And your first question comes from the line of Tom Roderick with Stifel..
Gentlemen, thank you for taking my questions. Congratulations on a great finish to what was starting out to be a tough quarter. So well done on that.
I guess, I want to go back to 90 days ago and you – Marty you had talked about a number of deals I think at the time there were some 50 deals that had kind of slipped out of closures and into the next quarter, 40 of them were kind of put back in the pipeline maybe 32 were put back in the pipe. But regardless, it was a pretty big number.
Would love to just hear about what you did with the sales team? Any strategic changes? Any splits you put in place? What did you do in terms of getting the sales team to help close those deals? And then as you look at the pipeline, I'd love to hear a little bit more about what you're doing also to replenish the pipeline.
Since it sounds like a lot of those deals did in fact close this quarter close rates are up. But talk a little bit about more of the pipeline replenishment as well. Thanks..
Well, good question. The first comment I would say is that, of those deals that slipped first quarter, we had a pretty typical distribution. A number of those closed, a number of those are still in the pipe for this quarter and potentially next quarter. And some went away.
I mean, the examples, the really – the industries that are still suffering from COVID-19, hospitality airlines things like that. Those deals are not going to come back anytime soon. So, we saw – we didn't – one category didn't sort of outpace the rest, but we closed some, some slipped, and some are on long-term hold for sure.
In terms of our sales team pivoting to virtual selling, we've really been pleased with that not only in closing deals but building pipe. And when you take into consideration a certain percentage of the economy is damaged and you really can't sell those industries.
I mentioned previously, the rest of the economy is really, as Stuart said, come back to a new normal, and we're seeing pipe building very similar to we did in the past. And the closure rate is also coming back to sort of the normals before COVID.
So, with the exception of those damaged industries or I should say stressed industries for the time being, we're seeing things sort of normalize and come back to normal. So things look pretty good from three months ago. The shock definitely affected everybody. And – but now after some time has settled in, we're just seeing normalcy sort of returning..
Yes. That's great to hear Marty. Thanks for that. Stuart you mentioned, Europe just a little bit – in your comments you referenced, the FDA evaluating a one-year delay.
I guess, what I'd love to hear is how are your customers and potential customers over in Europe thinking about this ESEF mandate? I know that it was meant to be sort of a multiphase implementation anyway. So, it wasn't like a Y2K event where you either did it by January 15 or you didn't.
Do you think that this FCA evaluation slows down the pipeline in the U.K., or is it sort of irrelevant where customers are thinking about digital transformation anyway and you're still ramping your own build over there in terms of sales headcount and marketing spend to improve awareness?.
Yes. It's a good question. As we've indicated before Tom, we were using the ESEF mandate not as an opportunity to sell a point solution, but as an opportunity to get a meeting with the right people at the front end to sell the platform. And we're seeing a lot of success with that.
So we don't see the delay on -- the potential delay coming out of FCA on ESEF is slowing down that motion at all. So in fact, we've already -- we've made quite a bit of penetration into those accounts and broadened the discussion beyond ESEF.
And I -- as I indicated in my earlier comments, we really -- it didn't affect our forecast and it really hasn't affected our staffing..
Outstanding. I’ll jump back in the queue, but thank you guys. Nice job..
Thanks, Tom..
Thanks..
Your next question comes from the line of Alex Sklar with Raymond James. .
Thanks. Stuart, just a question retention held really strong in Q2, but I was wondering if you could characterize the step down in the add-on revenue.
How much of that is just math around the lapping of SBL?.
Yes. Certainly, it was a combination of SBL and not taking price increases particularly for companies that were renewing and industries affected by COVID. And then a bit of solution churn, particularly from companies that were affected by COVID. Specifically, it's hard to isolate SBL.
But as we've said in the past, it accounted for probably a couple of hundred basis points of the move..
Okay. Great. Thanks. And then Marty you mentioned in the prepared remarks, the partner channel you highlighted three of the top four global consulting partners.
I'm just curious if you see any changes in terms of partner involvement in deals or partner resources being devoted to Workiva versus prior quarters?.
Yes. We're really happy with our partner activity right now. Our partners are starting to recognize that not only can they make money deploying our solution and advising customers on how to use it, they can also build a real practice around it.
And so, we're seeing a lot of our partners not just the big ones taking us very seriously and engaging with their clients. So that's been a really positive thing for us. And like we've said all along, it takes a while to build that momentum, but we're really seeing it pay off now. .
All right. Great. Thank you..
Thanks, Alex..
Your next question comes from the line of….
Hey, guys. This is actually Nick on for Terry. Thanks for taking my questions. So, the first one was kind of pivoting back toward the ESEF mandate opportunity.
I was just hoping you guys give us an update on the, I guess, on how conversations are progressing with both larger organizations and maybe the lower end of the market that -- in which you're addressing them with the W for ESEF solution, can you just give us an update on both sides? And I guess, as a follow-up are you seeing any changes in terms of competitive dynamics in EMEA?.
Let me start just by saying that sort of echoing what Stuart said, the ESEF is sort of one the mechanisms we used to get to customers and to talk to them. We've had a lot of engagement over ESEF. We are starting to close deals on the bottom two-third of the market.
And on the high end of the market the top one-third where we sell platform sales not our scale down product we haven't seen any effect there. Those are large companies. They're making platform type investments to satisfy more than just ESEF. They may be doing SEC in there.
They may be doing all sorts of different types of compliance and internal reporting things. And so it's been a nice entry into those big companies and I have -- we haven't seen any change I don't expect any, but it's going very well. On the bottom two-thirds of the market we're getting really good engagement.
And, like I said, we're starting to close some business. And again, there's a certain percent of those companies that are going to carry on no matter what. They want to get it handled. They want to comply and be good citizens. So we've had good luck engaging and we don't see this delay in the U.K. really affecting our advancement in the market..
Got it. Okay. That's helpful. And then, I guess, just kind of pivoting more towards go-to-market.
With the hire of Julie is earlier this year, I was wondering if you guys could potentially touch on some of the operational enhancements she's put in place? And if these enhancements are leading to increased efficiencies in certain areas of the organization? Thanks..
Well, yes, happy to answer that. Julie has been a great addition for our company. She has brought a lot of operational discipline. As I mentioned in the last call, I was trying to do two jobs and it was not going as well as it could. And so, she has brought operational discipline, a lot more metric-driven decisions.
And in terms of go-to-market, we have really sort of focused on packaging how we're going to go-to-market in terms of positioning communication with -- in terms of value. And so, we've spent a lot of time investing in that, also sell our skills and she's done a great job on all that.
So we feel like the stuff she's doing is definitely going to improve sales efficiency and go-to-market efficiency. I could have more to talk to you about if COVID hadn't come in the middle of it. But in terms of anecdotal type of things and what I observe in the company itself, it's going very well. .
Got it. Okay. Thanks, guys..
Your next question comes from the line of Stan Zlotsky with Morgan Stanley..
Perfect. Thank you so much, guys and hopefully everybody is doing well in the current environment. Couple of questions from me, on the ESEF mandate. As much as U.K.
is considering potentially delaying, have you heard any kind of rumblings about the rest of EMEA potentially also putting that discussion on the table?.
We -- I have not. I'm sure that it's being bounced around, but I have not heard anything official. I tend to think that, in the current state of the European Union, I don't think they're going to necessarily be concerned about moving forward. Obviously, they're doing better than us on COVID in general.
But even if they do, as Stuart has said many times, we have not built that into our forecast in a significant way. And even if it's the delayed year, as I mentioned, it's still going to be something that will give us a chance to talk to new prospects and existing customers.
So I -- even before COVID, we had thought that there was a chance that we could delay the year. That just seems to be what most of these regulatory things do and we've seen it in others. And we had built a model that more or less accounting for that already..
Okay. Perfect. Guys, that makes….
But then, to your question, we really haven't seen it happen in Europe. But if it does, it's not something I'm very concerned about. It's still going to happen and the conversations are still taking place..
Right. No it's just a matter of time. Makes sense. And then, maybe just a follow-up for Stuart.
Can you help us unpack the $5.6 million of allowance for receivables that you guys now have? And what -- how that impacted billings in the quarter? Just the kind of the moving pieces of billings declining 2% year-on-year? I just want to make sure we have it all correct. .
Absolutely. So the way to think about it is -- I think is to compare it to the June 30, 2019, Stan. So what -- the $3.2 million that was in the reserve last year at June 30 and then $5.6 million.
So if you were to look at a pro forma change in short-term billings, short-term billings would have been up 6.6% if you adjusted both numbers for that, if you added back those reserves for it..
But that change that's a year-on-year change, or is that sequential change?.
Yes, that's the year-on-year change. The sequential one would have been -- I mean I think that's the right way to look at it because our business is seasonal right? It -- particularly when it comes to billings. But the $6 million one was at the end of March this year. And so that -- if you look at it as a percentage of the combined number.
So receivables plus the add-back it was about the total was $6 million was about 11.6% of the total at 3.31 or it was about 11.9% at 6.30. .
Got it. Maybe we can follow-up one-on-one. Thank you so much. Appreciate it.
You bet. Thank you..
Your next question comes from the line of Mike Grondahl with Northland. .
Yes. This is Michael on for Mike. Thanks for taking my question. Maybe first off just on the 10-Q on the segments it seems like it's pretty broad-based across the different silos even a couple of points and growth in energy year-over-year.
Anything to call out there as far as surprises in the quarter more strengthening in certain industries?.
I would say that the one that's really showing a lot of promise is global statutory reporting. We're seeing very good-sized deals. And the competition there is much different. So it's an older technology competition.
So that's all of the growth vectors showed very good progress through the first half of the year, but global statutory part really, really stood out. .
Got it.
And maybe just comments on changes in the last couple of quarters in the potential M&A market pipeline there?.
I'll let Stuart comment on that. Go ahead Stuart. .
Yes. I mean we continue to look at opportunities brought to us and initiate conversations ourselves. I think it's fair to say that the pandemic has caused most of the companies that might be interested in selling to slow down on the M&A front. So I would say it's been relatively quiet. .
Okay. And you do have a follow-up question from the line of Tom Roderick with Stifel. .
Hi, guys. Thanks for taking a follow-up. Marty I was hoping you could just go into a little bit more detail on the next-generation platform here. We're getting some nice feedback from customers that have seen at play with that perhaps even using it already.
That's -- that feel like it's really kind of a game changer with respect to how remote employees can interact with each other they can sort of be in the same line and edit the same line at the same time things like that.
So I guess the question I'd have for you is number one are you getting a better reception on the product with respect to adoption as more and more of your customers' employees are working from home? And then secondarily what's sort of the monetary add-on opportunity as you roll this product out? Does it interact better with some of these add-on features whether it's Wdata or global statutory or some of the other products? Just kind of think -- love to hear a little bit more about how you're thinking about monetizing that because it does seem like it's a little bit of a functionality game changer?.
Well I would say first off that our rolling out of next-gen has been a very, very pleasant surprise. It's been very stable and has really performed well. When you do -- when you rebuild a platform the size of ours that's a big undertaking. And we've been extremely pleased with how that's turned out.
In terms of the leverage, we're going to get from that platform. Remember, we've gone to a truly modern micro services architecture.
And for instance, FERC and W for ESEF those two solutions, I mentioned in the prepared remarks at the beginning, we created specific solutions for those in just a couple of months and package them and are selling them already and generating bookings. So, we aren't going to see direct new revenues from switching customers from classic to next-gen.
But what we see in 2021, the leverage we're going to get there is, we're going to be able to package more and more specific solutions for sellers to put in their bag. And so that's really where we get the leverage..
Yeah. And then, just perhaps one quick follow-on on that.
Wdata, would love to just hear a little bit more about that? Customers that are adopting it, what is that doing to the deal prices, and who are you looking at -- or who are they looking at a potential alternatives for Wdata? Is this more of a data prep tool-type of solution like an Alteryx, or is it pretty much something historically, they've just done it manually?.
Yeah. It's, let's say, a baby version of what Alteryx does, but it's put together for our particular product and our particular customers. And it is sort of a data prep tool. But the big thing for us is connectivity. You can bring your data in there and do all the things you need to prep data for our solutions and our use cases, which customers love.
But the really good thing is we can connect to a large number of source systems, not just ERPS but CRM tools and tools like Concur, all the sales forces. So you can pull in data, that's not just back office data, but front office data and we're seeing customers using the platform more and more for that.
So Wdata, like I said, was the missing link in the platform, and we do a platform sale with Wdata. We're getting considerably higher ADSs. And so it's -- it was -- in terms of product, it was the missing piece for us having a true platform. So, that's really how to look at it..
That’s great. That’s it for me. Thank you, guys. Appreciate it..
Thanks, Tom..
Thanks, Tom..
And your last question comes from the line of Rob Oliver with Baird..
Thanks, guys. It's Matt Lemenager on for Rob. I have one on the growth in customers greater than $150,000, which is held fairly steady. And I guess just comparing that with the growth in customers greater than $100,000 is kind of decelerated a little bit.
Is there anything to unpacked there? I mean it seems like maybe it's more a platform sale and the traction, but just kind of seeing that growth in $100,000 have come down a bit at least compared to two or three quarters ago while the growth in $150,000 is holding in strong.
So, anything to think about there?.
Hey, Matt, it's Stuart. So, a, we're really happy to be growing them both at those kinds of levels during the time of COVID. I do think that the growth of the over $150,000 does reflect strength on selling the platform. But the 28% is down a little bit, and I do think that that's reflective of the impact of COVID more than anything else..
Okay. Okay, got it. Yeah. And Stuart, I was just going to ask on cash flow. Sometimes, you've provided additional color on the calls around operating cash flow or how to think about that? I mean been operating cash positive, and it sounds like collections were strong in the first half.
Is there anything you want to point people to looking at the second half of the year, anything around cash flow?.
Yeah. Not specifically around the second half of the year. I mean we're pleased to be nicely cash flow positive on the first half of the year. So, I'll leave it at that..
Okay, sounds good. Thanks guys..
Thank you, Matt..
Ladies and gentlemen, this concludes today's conference call. We thank you for your participation. You may now disconnect..