SaaS P&L Template

Each month, enter your actual figures in three places: new and churned ARR in the waterfall, actual department expenses in the expense sheet, and any one-time or professional services revenue directly in the Monthly P&L. The gross profit calculation, operating expense totals, and all dashboard metrics update automatically. If you're using this for forward planning rather than actuals, enter your projected numbers the same way — the template works for budgets, forecasts, and actuals without any changes to the structure.

The key distinction in a SaaS P&L is how you structure the three layers: recurring revenue vs. one-time revenue, COGS vs. operating expenses, and then operating expenses broken out by functional area. COGS for SaaS includes infrastructure, customer success, and payment processing — costs that scale roughly with revenue. Operating expenses — R&D, Sales & Marketing, G&A — are the investment layer that should eventually produce leverage as the business scales. Investors evaluate SaaS companies on gross margin (is the core product profitable?), CAC payback period (how fast does new ARR pay back its acquisition cost?), and the Rule of 40 (is growth rate plus profit margin above 40?).