Financial Planning & Analysis with

Driving decision-making with visibility into your financial and operational dynamics.

Client: OnPlan
Industry: Financial Planning and Analysis SaaS Application
Key features: The financial forecasting platform

Case Study Overview

At the forefront of strategic product development and innovation, our team presents OnPlan—a Financial Planning & Analysis SaaS application meticulously crafted to meet industry demands.

Leveraging a deep-rooted understanding of industry insights, OnPlan stands as a testament to Innogent's commitment to redefining the financial planning space, further epitomizing the team's expertise in delivering tangible value to businesses worldwide.

Company Overview

OnPlan hosts a flexible financial planning, forecasting, and analytics SaaS application that combines insightful visualizations and collaboration on top of spreadsheets to fuel better decision-making within businesses.

The company thrives on making financial modeling intuitive and interactive through tailored models, visualization, integrated workflows, native scenarios, and variance functionality.

OnPlan financial planning and analytics dashboard

Problem Statements

Data Ingestion Complexity
The need to connect diverse source systems and expedite data pipelines for rapid model creation.
Scenario Planning and Budget Analysis
The need to evaluate "what-if" scenarios, compare budget variations, and capture snapshots of financial conditions at specific points in time.
Scalable Data Storage Layer
Conventional solutions struggled to support voluminous data storage and read data requests, hindering seamless analytics and reporting.
Bottlenecked Onboarding
Tedious customer onboarding, a roadblock to market expansion and value delivery.
Visualization
Converting complex data into visual formats for facilitating better comprehension and interpretation of insights.

Product Functions

OnPlan serves as a comprehensive toolset that transforms the way financial planning and analysis are conducted, enabling efficient decision-making and insightful projections.

Utilizes Google Sheets to seamlessly retrieve data from diverse and disparate sources and integrate it into a unified spreadsheet environment.

Efficiently gathers data from multiple sources, strategically maps it within Google Sheets, and performs calculations to generate accurate forecasts.

Streamlines the creation of multiple scenarios and budgets with a single click, providing users with flexibility.

Users are empowered to effortlessly generate various charts and graphs, enhancing the visualization of their reports.

Facilitates the creation of BVA (Budget Variance Analysis) reports, providing valuable insights in making informed business decisions.

Enables roll-forward modeling.

Benefits

Expanding Market Reach

Empowering clients to penetrate new market segments, capitalizing on opportunities that were once out of reach.

Elevated Margins

With newfound capabilities, the sales team closed deals at higher margins, contributing to enhanced profitability.

A Platform for Tomorrow

Our solution's scalability paved the way for future innovations, setting the stage for AI integration and further advancements.

Brute-force Solution
Validating the problem statement with a brute-force solution. Analyzing, improvising, and finalizing the proof-of-concept.
Addressing Scalable Data Storage
A conventional OLAP system wasn't the silver bullet. We embarked on a journey to create a robust solution within the Google ecosystem which further led us to design a custom data product leveraging Google BigQuery. An ingenious solution, infused with scalability and fault tolerance, enabled pivotal OLAP operations.
Conquering Data Ingestion Complexities
Extensive integration with a multitude of data sources, including prominent platforms like QuickBooks, NetSuite, Salesforce, BambooHR, Xero, and various others. Leveraging ETL tools and crafting bespoke pipelines for unique systems ensuring seamless data flow.
Elevating Onboarding Experience
Radically compressed the onboarding cycle from weeks to days.

Proficiency

At Innogent, we specialize in navigating intricate technological landscapes, delivering sophisticated solutions that resonate deeply with CTOs seeking refined financial planning strategies.

Within OnPlan's architecture, we addressed the intricate challenges of data ingestion by seamlessly integrating an array of platforms—from QuickBooks to Salesforce—crafting tailored pipelines that ensure a seamless flow of information.

Scalability emerged as a pivotal obstacle, which prompted us to engineer a custom solution within the Google ecosystem, leveraging BigQuery to facilitate fault-tolerant operations. Transcending industry norms, we revolutionized the onboarding processes by condensing timelines from weeks to mere days.

The application stands as a testament to our commitment to excellence in reshaping financial landscapes, exemplified through widened market access, amplified profit margins, and scalability to integrate AI seamlessly. Championing the fusion of Google Sheets' computational prowess, we further redefined the paradigm of financial modeling and strategic decision-making.

Our vision extends beyond mere conventions, ensuring that OnPlan stands as a beacon of innovation, poised at the forefront of revolutionizing financial analysis and foresight.

Impact Metrics

OnPlan delivery timelines before and after OnPlan
Attributes	Before OnPlan	After OnPlan
Problem Statement Discovery	1 week	1 week
Setting up Data Sources	1 week	3 days
Curating Essential Reports (BS, CF, INS)	3 weeks	2 days
UAT (First Financial Model)	2 weeks	3 days
Readjusting Model Based on Client Feedback	1 week	1 day
Go Live	1 weeks	4 hours

Conclusion

OnPlan is the solution for growing organizations that don't have the time or resources for legacy planning tools. Courtesy of an eccentric approach to product development and scaling, OnPlan has carved a niche in the FP&A space, attracted capital, and positioned itself better in a desirable customer quadrant.