Building a useful SaaS financial forecast requires more than projecting MRR or estimating how many subscribers a company will have next year.
Stripe provides detailed information about the subscription engine, including customers, subscriptions, recurring revenue, churn, expansion, contraction, and pricing. QuickBooks Online provides the broader accounting data needed to understand expenses, profitability, cash flow, assets, liabilities, and debt.
Combining Stripe and QuickBooks data allows SaaS companies to connect what is happening with recurring revenue to what is happening across the rest of the business.
RunSmart by Projection Genie connects to both Stripe and QuickBooks Online to automatically establish a financial baseline from historical performance. SaaS founders can then model changes to subscriber growth, churn, expansion revenue, pricing, hiring, spending, financing, and other assumptions to see how those changes could affect future revenue, profitability, cash flow, and runway.
This guide explains how to build a SaaS financial forecast using Stripe and QuickBooks data, which information should come from each system, and how SaaS operating assumptions can be translated into a broader financial plan.
What Is a SaaS Financial Forecast?
A SaaS financial forecast estimates how a SaaS company's financial performance and position could change over a future period.
A complete financial forecast can include projected:
- Revenue
- Cost of goods sold
- Operating expenses
- Profitability
- Cash flow
- Assets
- Liabilities
- Debt
- Cash balances
- Financial health
- Runway
For a SaaS company, the revenue portion of the forecast should also reflect the recurring economics of the business, including subscriber growth, churn, expansion, contraction, and pricing.
This is why SaaS financial forecasting often requires information from both a subscription billing platform and an accounting system.
Why Combine QuickBooks and Stripe for SaaS Financial Forecasting?
QuickBooks and Stripe contain different pieces of the information needed to understand a SaaS company's financial future.
Stripe provides detailed information about how recurring revenue is generated.
QuickBooks provides the broader financial information needed to understand what happens to the business after that revenue is generated.
For example, Stripe may show that MRR increased from $80,000 to $100,000.
But that increase alone doesn't answer:
- Did expenses grow faster than revenue?
- Is the company becoming more profitable?
- Is cash flow improving?
- Can the company afford additional employees?
- Are debt payments creating cash pressure?
- How much runway does the company have?
- What happens if subscriber growth slows?
- What happens if churn increases?
Combining the two data sources provides the context needed to answer these broader financial planning questions.
What Data Comes From Stripe and What Comes From QuickBooks?
For SaaS financial forecasting, Stripe and QuickBooks generally serve complementary roles.
Stripe provides information about the company's subscription engine, while QuickBooks provides information about the broader financial structure of the business.
Together, the two systems create a more complete historical foundation for forecasting.
How Does a SaaS Financial Forecast Work?
A SaaS financial forecast can be thought of as two connected layers.
Layer 1: Forecast the SaaS Revenue Engine
The first layer estimates how recurring revenue could change based on factors such as:
- Beginning subscribers
- New subscriber growth
- Churn
- Expansion
- Contraction
- Pricing
A simplified subscriber forecast can be expressed as:
Ending Subscribers = Beginning Subscribers + New Subscribers - Churned Subscribers
Recurring revenue can then be estimated using the projected subscriber base and expected revenue per customer.
For example:
Projected MRR = Projected Subscribers × Average Monthly Revenue per Subscriber
For companies with multiple subscription plans, upgrades, downgrades, or usage-based components, the calculation becomes more detailed.
Layer 2: Translate Revenue Into a Financial Forecast
The projected revenue then flows into the broader company forecast alongside expenses and other financial activity.
That allows the company to project financial statements and evaluate the effects on profitability, cash flow, financial health, and runway.
This second layer is where QuickBooks data becomes especially important.
Example: Building a SaaS Revenue Forecast
Consider a SaaS company with:
- 1,000 subscribers
- $100 average monthly recurring revenue per subscriber
- 50 new subscribers expected each month
- 3% monthly customer churn
Beginning MRR is:
1,000 × $100 = $100,000
At 3% monthly churn:
1,000 × 3% = 30 churned subscribers
After adding 50 new subscribers:
Ending Subscribers = 1,000 + 50 - 30 = 1,020
Projected ending MRR becomes:
1,020 × $100 = $102,000
That gives the company a projected recurring revenue figure.
But it still isn't a complete financial forecast.
Turning the Revenue Forecast Into a Company-Wide Financial Forecast
Suppose the same company has the following monthly expenses recorded through QuickBooks:
- Payroll: $65,000
- Marketing: $15,000
- Software and technology: $8,000
- Rent and facilities: $5,000
- Other operating expenses: $7,000
Total monthly operating expenses are:
$65,000 + $15,000 + $8,000 + $5,000 + $7,000 = $100,000
At $100,000 in MRR, the company may appear to be roughly at operating breakeven in this simplified example.
If recurring revenue grows to $120,000 while expenses remain near $100,000, profitability and cash generation could improve.
But if the company hires additional employees and increases marketing spending at the same time, the result may be very different.
That's why SaaS financial planning requires the revenue model and expense model to work together.
What Should a SaaS Financial Forecast Include?
A useful SaaS financial forecast should connect operating assumptions to their potential financial effects.
This allows founders to move beyond simply forecasting MRR and evaluate what those changes could mean for the company as a whole.
How Do You Forecast SaaS Expenses?
SaaS expenses can be forecast using historical accounting data and assumptions about future business decisions.
Historical QuickBooks data can help establish patterns in categories such as:
- Payroll
- Marketing
- Software
- Hosting and infrastructure
- Professional services
- Rent
- Insurance
- Interest
- Other operating expenses
Some expenses may follow historical patterns, while others should reflect known future decisions.
For example, a founder may already know that the company plans to hire three employees in six months.
Rather than relying entirely on historical expense patterns, those hires can be incorporated into a scenario so their expected compensation and related costs are reflected in the forecast.
How Do You Model Hiring in a SaaS Financial Forecast?
Hiring decisions can materially change SaaS cash flow and runway.
Suppose a SaaS company is considering hiring two employees with annual salaries of $120,000 each.
Ignoring benefits and payroll taxes for simplicity:
Annual Salary Cost = 2 × $120,000 = $240,000
Monthly salary cost would be approximately:
$240,000 ÷ 12 = $20,000 per month
If both employees start in July, the forecast should begin incorporating approximately $20,000 of additional monthly salary expense starting in July rather than applying that expense to the entire year.
The founder can then compare the company's forecast with and without those hires.
The important question becomes more than:
Can we afford $240,000 in annual salaries?
It becomes:
How would these hires affect profitability, cash flow, and runway given our expected subscriber growth and churn?
How Do You Model SaaS Churn in a Financial Forecast?
Churn should affect more than a standalone SaaS KPI.
Suppose a company has:
- $100,000 MRR
- 3% baseline monthly churn
- $500,000 in cash
Management wants to understand the financial consequences if churn rises to 5%.
The higher churn assumption reduces the number of customers retained in future periods. That reduces future recurring revenue compared with the baseline forecast.
Lower revenue can then flow through the broader financial forecast, potentially affecting:
- Gross profit
- Operating profit
- Cash flow
- Ending cash balance
- Financial health
- Runway
This is why connecting SaaS metrics with accounting data provides more useful planning information than looking at churn independently.
How Do You Model a SaaS Pricing Change?
Pricing changes can be modeled by changing the expected revenue generated by customers.
For a simple example, suppose a company has 1,000 subscribers paying an average of $100 per month.
Current MRR is:
1,000 × $100 = $100,000
If the average monthly price increased to $110 and every subscriber paid the new price:
1,000 × $110 = $110,000 MRR
That represents a potential $10,000 monthly increase in recurring revenue before considering any resulting changes in customer acquisition, churn, discounts, grandfathered plans, or other customer behavior.
A useful pricing scenario therefore shouldn't automatically assume that every other variable remains unchanged.
Founders may want to compare multiple scenarios involving different combinations of pricing and churn.
How Do You Create SaaS Financial Scenarios?
A financial scenario changes one or more assumptions while leaving the original baseline available for comparison.
For example, consider a SaaS company evaluating four possible futures:
These scenarios allow management to compare how different operating assumptions could affect the broader financial forecast.
Rather than trying to predict one exact future, scenario planning helps founders understand the range of financial outcomes that different decisions or business conditions could produce.
What Is a Baseline Financial Forecast?
A baseline financial forecast represents the expected future trajectory of the business before additional what-if assumptions are introduced.
The baseline provides a reference point against which alternative scenarios can be compared.
RunSmart automatically establishes this baseline using the company's historical financial and operating performance.
Founders can then create scenarios to model how changes to SaaS drivers or broader business decisions could alter that trajectory.
This approach separates two important questions:
Where does the business appear to be heading based on its existing performance?
and:
What could happen if something changes?
How RunSmart Combines QuickBooks and Stripe Data
RunSmart by Projection Genie connects QuickBooks Online and Stripe data to create a unified financial planning environment for SaaS companies.
Stripe provides the subscription-level information needed to understand SaaS revenue drivers, while QuickBooks provides the financial history needed to understand the broader business.
RunSmart uses that historical data to automatically establish a forward-looking baseline.
Founders can then model changes involving:
- Subscriber growth
- Churn
- Expansion revenue
- Pricing
- Hiring
- Operating expenses
- Financing
- Other financial assumptions
RunSmart recalculates the forecast so founders can evaluate how those changes could affect future revenue, profitability, cash flow, financial health, and runway.
The result is a financial model grounded in the company's actual historical performance without requiring the founder to build and continually maintain a complex spreadsheet model.
QuickBooks + Stripe vs. a Spreadsheet Financial Model
Spreadsheets can be extremely flexible, but building and maintaining a SaaS financial model manually requires ongoing work.
For founders who enjoy building financial models, spreadsheets may continue to provide useful flexibility.
For founders who primarily want to understand where the business is heading and model decisions without maintaining the underlying model themselves, an automated financial planning platform can reduce much of that work.
Why SaaS Founders Need More Than an MRR Forecast
MRR is one of the most important metrics in a SaaS business, but increasing MRR doesn't automatically mean the company's financial condition is improving.
A SaaS company can grow MRR while simultaneously:
- Burning more cash
- Increasing operating losses
- Hiring too quickly
- Spending heavily on customer acquisition
- Taking on debt
- Experiencing deteriorating margins
- Shortening its runway
This is why SaaS founders should connect recurring revenue forecasts with the rest of the company's financial model.
The goal isn't simply to answer:
How much MRR might we have in 12 months?
The more important question is:
What would that level of MRR mean for the financial future of the company?
Frequently Asked Questions
Can you build a SaaS financial forecast using QuickBooks and Stripe?
Yes. Stripe can provide detailed subscription and recurring revenue information, while QuickBooks provides accounting information about revenue, expenses, assets, liabilities, debt, and cash flow. Combining the two creates a stronger foundation for company-wide SaaS financial forecasting.
Why isn't QuickBooks alone enough for SaaS forecasting?
QuickBooks provides detailed accounting information but generally doesn't contain the same subscription-level operating data available through Stripe. SaaS forecasting can benefit from understanding subscriber growth, churn, expansion, contraction, and pricing alongside the accounting data.
Why isn't Stripe alone enough for financial forecasting?
Stripe provides detailed billing and subscription information, but a complete company financial forecast also requires information about expenses, assets, liabilities, debt, cash, and other financial activity that typically resides in the accounting system.
What is the difference between a SaaS revenue forecast and a SaaS financial forecast?
A SaaS revenue forecast estimates future revenue based on factors such as subscriptions, growth, churn, expansion, contraction, and pricing. A SaaS financial forecast goes further by incorporating expenses and other financial activity to project profitability, cash flow, financial position, and potentially runway.
Can SaaS churn be included in a financial forecast?
Yes. Churn affects future customer retention and recurring revenue. Changes in projected revenue can then flow through the broader financial forecast and affect profitability, cash flow, cash balances, and runway.
Can hiring be included in a SaaS financial forecast?
Yes. Planned employees can be incorporated into future periods based on expected start dates, compensation, benefits, and other employment costs. This allows founders to evaluate the financial effect of hiring plans before making those commitments.
Can pricing changes be modeled using Stripe data?
Yes. Pricing assumptions can be incorporated into recurring revenue projections. A comprehensive scenario may also consider whether a pricing change could affect churn, subscriber growth, or other customer behavior.
What financial statements should a SaaS forecast include?
A comprehensive financial forecast can include projected income statements, cash flow statements, and balance sheets. Together, these provide a more complete picture than forecasting revenue alone.
How does RunSmart forecast SaaS financial performance?
RunSmart combines historical QuickBooks Online financial data with Stripe subscription data to establish a baseline financial forecast. Founders can then model changes to SaaS revenue drivers and broader financial assumptions to compare how different scenarios could affect future financial performance.
Does RunSmart require founders to build a financial model?
No. RunSmart automatically establishes the baseline using historical business data, allowing founders to focus on customizing assumptions and modeling potential decisions rather than building and maintaining the underlying financial model themselves.
Turning SaaS Data Into a Financial Plan
Stripe and QuickBooks answer different but complementary questions.
Stripe helps explain how the SaaS revenue engine is performing.
QuickBooks helps explain how the overall business is performing financially.
Combining them allows SaaS founders to connect subscriber growth, churn, expansion, and pricing with expenses, profitability, cash flow, and runway.
RunSmart brings those data sources together, automatically establishes a forward-looking financial baseline, and lets founders model what could happen if their business or their decisions change.
Instead of maintaining separate SaaS metrics, accounting reports, and spreadsheet forecasts, founders can use their actual historical performance as the starting point for understanding what may come next.
