Case Studies How Sourcegraph Drove 10X Faster Cash Flow and Expense Analysis

Edit This Case Study Record

	How Sourcegraph Drove 10X Faster Cash Flow and Expense Analysis

How Sourcegraph Drove 10X Faster Cash Flow and Expense Analysis

Technology Category	Analytics & Modeling - Predictive Analytics Functional Applications - Enterprise Resource Planning Systems (ERP) Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries	Professional Service Software
Applicable Functions	Business Operation
Services	Software Design & Engineering Services System Integration
Challenge	After raising $50M at their Series C, Sourcegraph was looking for a faster way to analyze cash flow and expenses to strategically manage investments aligned to the company's long-term growth goals. As the company was growing quickly, the finance team needed visibility into spend by department and category as well as an understanding of the inflows and outflows of cash that impacted their burn. The company typically only looked at those metrics on a quarterly basis. But after completing their Series B and Series C, they had multiple new investors and stakeholders on board and needed the information to be visible in real-time. Sourcegraph is a fully remote company, and their accounting function is outsourced—both of which made it difficult to get real-time data in a meaningful format within stakeholder deadlines. With revenue, expense, and headcount data all in different systems, the finance team struggled to get accurate, consolidated, real-time insight into the financial indicators that mattered most. Tasked with creating a long-term growth plan while maintaining a firm grasp on current performance, Sourcegraph’s finance team wanted a faster way to analyze expense trends and predict the burn rate based on aggressive hiring plans and R&D investment. Read More
About Customer	San Francisco-based startup Sourcegraph builds universal code search for every developer and company so they can innovate faster. They help developers and companies with billions of lines of code create the software you use every day. Their mission is to democratize code. Sourcegraph’s customers include many of the world’s leading companies, such as Amazon, PayPal, Uber, Lyft, Yelp, Atlassian, and Indeed. Much like their long-term company goals, the team at Sourcegraph aimed to democratize financial information to help guide future growth. Read More
Solution	Shifting from basic data analysis to insightful discussions around asset investment and liquidity management would require a more forward-looking approach. The Sourcegraph team turned to Mosaic, a Strategic Finance Platform that connects teams and tools to automate financial insights. Within days of integrating Mosaic, the Sourcegraph finance team reduced the time it took to pull ERP data from three days to minutes. Instead of routing key questions through the outsourced accounting firm, they could now gain insight from Xero and Salesforce data in real-time, from one centralized platform. Mosaic’s powerful analysis canvas allows them to access consolidated revenue metrics in a single, easily accessible dashboard tailored to how they want to see their business. They can automatically calculate critical SaaS metrics such as ARR, ARR changes, and net burn and load them onto interactive reports to create a shareable view of their cash position at any time. Analyzing expenses is also much simpler. With transaction-level data automatically pulled into pre-populated reports, the Sourcegraph team can easily view a consolidated list of department and account level expenses and drill down quickly to analyze variances. One-click and they can seamlessly triangulate the long-term impact of high-variance expenses like hiring 10 new engineers. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Predictive Analytics

Functional Applications - Enterprise Resource Planning Systems (ERP)

Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Professional Service

Software

Applicable Functions

Business Operation

Services

Software Design & Engineering Services

System Integration

Challenge

After raising $50M at their Series C, Sourcegraph was looking for a faster way to analyze cash flow and expenses to strategically manage investments aligned to the company's long-term growth goals. As the company was growing quickly, the finance team needed visibility into spend by department and category as well as an understanding of the inflows and outflows of cash that impacted their burn. The company typically only looked at those metrics on a quarterly basis. But after completing their Series B and Series C, they had multiple new investors and stakeholders on board and needed the information to be visible in real-time. Sourcegraph is a fully remote company, and their accounting function is outsourced—both of which made it difficult to get real-time data in a meaningful format within stakeholder deadlines. With revenue, expense, and headcount data all in different systems, the finance team struggled to get accurate, consolidated, real-time insight into the financial indicators that mattered most. Tasked with creating a long-term growth plan while maintaining a firm grasp on current performance, Sourcegraph’s finance team wanted a faster way to analyze expense trends and predict the burn rate based on aggressive hiring plans and R&D investment.

About Customer

San Francisco-based startup Sourcegraph builds universal code search for every developer and company so they can innovate faster. They help developers and companies with billions of lines of code create the software you use every day. Their mission is to democratize code. Sourcegraph’s customers include many of the world’s leading companies, such as Amazon, PayPal, Uber, Lyft, Yelp, Atlassian, and Indeed. Much like their long-term company goals, the team at Sourcegraph aimed to democratize financial information to help guide future growth.

Solution

Shifting from basic data analysis to insightful discussions around asset investment and liquidity management would require a more forward-looking approach. The Sourcegraph team turned to Mosaic, a Strategic Finance Platform that connects teams and tools to automate financial insights. Within days of integrating Mosaic, the Sourcegraph finance team reduced the time it took to pull ERP data from three days to minutes. Instead of routing key questions through the outsourced accounting firm, they could now gain insight from Xero and Salesforce data in real-time, from one centralized platform. Mosaic’s powerful analysis canvas allows them to access consolidated revenue metrics in a single, easily accessible dashboard tailored to how they want to see their business. They can automatically calculate critical SaaS metrics such as ARR, ARR changes, and net burn and load them onto interactive reports to create a shareable view of their cash position at any time. Analyzing expenses is also much simpler. With transaction-level data automatically pulled into pre-populated reports, the Sourcegraph team can easily view a consolidated list of department and account level expenses and drill down quickly to analyze variances. One-click and they can seamlessly triangulate the long-term impact of high-variance expenses like hiring 10 new engineers.

Impact #1	Consolidated ERP and CRM data available in real-time.
Impact #2	Interactive reports with account and department-level spend.
Impact #3	On-demand cash flow and expense reporting.

Impact #1

Consolidated ERP and CRM data available in real-time.

Impact #2

Interactive reports with account and department-level spend.

Impact #3

On-demand cash flow and expense reporting.

Benefit #1	Reduced the time to pull ERP data from three days to minutes.
Benefit #2	Enabled real-time insight from Xero and Salesforce data.
Benefit #3	Automated calculation of critical SaaS metrics such as ARR, ARR changes, and net burn.

Benefit #1

Reduced the time to pull ERP data from three days to minutes.

Benefit #2

Enabled real-time insight from Xero and Salesforce data.

Benefit #3

Automated calculation of critical SaaS metrics such as ARR, ARR changes, and net burn.

Download PDF Version

Overview

How Sourcegraph Drove 10X Faster Cash Flow and Expense Analysis

Operational Impact

Quantitative Benefit