How Hourly Shares Customized Board and Investor Dashboards With Grid

About

Hourly combines payroll, workers’ compensation insurance, and time tracking, enabling SMBs to view labor costs and run payroll with one click. Founded in 2018, the company has partnered with industry leaders like Nationwide.

Challenge

Hourly’s team spent hours crunching numbers for financial reports

Hourly has raised seed and Series A funding since their inception. As they expanded, so did the company’s board reporting requirements. When the company’s board and investors requested KPIs and other metrics like NDR and ACV, CFO Sonia Faruqi and her team spent hours on manual calculations.

For instance, when board members requested churn metrics, Sonia’s team had to export data from their CRM, cross-reference it with billing data in spreadsheets, and recalculate it using different formulas.

Some stakeholders wanted churn calculated based on customer count, while others needed revenue-based calculations. This meant spending significant time building Excel models and verifying formulas before each board meeting. Without a secure way to access relevant data, the board and stakeholders relied on Sonia and the team for updated information — adding to the team’s workload and slowing decision-making.

In addition, these static reports quickly became outdated as new data came in. Board members couldn’t explore information independently or drill down to gain real-time insights. When asked follow-up questions about specific segments, the team had to restart the time-intensive process in Excel.

Sonia realized they needed a system to standardize calculations, automate board reporting, and provide stakeholders with always up-to-date metrics. When Tom Sagi, Hourly’s Co-Founder and CEO, recommended Grid, the team decided to move forward with automation.

Solution

Custom investor dashboards with real-time metrics‍

With Grid’s integrations, Hourly seamlessly centralized all their financial data from disparate sources, building self-service dashboards to deliver interactive, investor-ready metrics.

Using Grid’s standardized metrics, Hourly's finance team provides board members with secure access to relevant metrics using Grid’s easy sharing options. Hourly can flexibly calculate churn metrics — by customer count or revenue — and tailor insights. For example, when an investor requested information about ACV and churn, the team set up a specialized dashboard to identify opportunities to improve customer retention. These deeper insights into churn enable Hourly to prioritize customer retention efforts.

Hourly created custom investor dashboards with all KPIs in a single view, allowing board members to explore data on their own. “We created an investor dashboard and sent the link before the meeting so the board could see the numbers they’re interested in,” Sonia shares. Grid’s flexible permission settings enable teams to collaborate in one place, with customized access levels ensuring stakeholders see precisely what they need without compromising sensitive data. This means whether tracking churn, ACV, or NDR, stakeholders have actionable insights into revenue trends and customer retention without the finance team spending hours on manual reports.

Here’s how Grid transformed Hourly’s reporting:

• One central data hub: By centralizing CRM, billing, and financial data, Hourly has a single source of truth everyone trusts.
• Easy-to-build, shareable dashboards: With access control, the team quickly creates custom views and charts showing the data investors want to see without the Excel gymnastics.
• Real-time syncs: As new data comes in, dashboards refresh automatically, eliminating delays and enabling stakeholders to make faster, data-driven decisions.
• Standardized metrics: Using Grid’s library of SaaS metrics, Hourly ensured consistent and error-free reporting for key KPIs and metrics like NDR and ACV.

With Grid, Hourly’s team spends less time on manual reporting, giving board members and investors self-serve access to the latest financial insights.