Spring Sprint: Our Business Spreadsheet Library, Built Out

It started with a whiteboard and one question: what does a small business owner actually need from a spreadsheet, beyond the cash flow forecast and P&L we’d already shipped?

The list got long. Way longer than we expected. So we did the only reasonable thing - we stopped trying to ship it all in one big release and just started building, one workbook a week. A bookkeeping ledger in March. KPI dashboard the week after. Restaurant model. SaaS metrics. Real estate underwriting. By the time we looked up, it was thirty workbooks and a stack of bundles deep.

Time to write it all down in one place.

How these are built

Open any of the new workbooks and you’ll find the same skeleton underneath: a dashboard up top, two or three data sheets where you actually do the typing, a variance or scenarios view that derives itself from the data, and a settings sheet that controls the rest. No macros. No add-ons. No setup wizard that asks you twenty questions before you can start.

The sample data is already populated. That part matters more than it sounds. You can see exactly how the formulas behave before you put your own numbers in - and when something looks wrong later, you have a working version to compare against.

Excel works. Google Sheets works. The formulas were written to stay inside the subset that survives both apps, so dragging the .xlsx into Drive and opening with Sheets carries everything across: charts, formatting, calculations. Nothing rebuilds itself wrong.

Here’s the library.

Business finance

The everyday accounting stack. Cash flow, the three statements, daily books, who-owes-what, and an annual tax view.

• Cash Flow Forecast - Twelve-month rolling cash flow with pipeline weighting, scenario toggles, and a closing-balance trajectory. The workbook we ship first when someone says “I have no idea if I can make payroll next month.”
• Profit & Loss Statement - Monthly and YTD P&L with category-level expense breakdown. Margins calculated; the comparison view next to last year does itself.
• Balance Sheet - Assets, liabilities, equity, all reconciled. Includes a working-capital view because that’s what you actually look at most weeks.
• Bookkeeping - Single-entry transaction ledger. Type every income and expense once and a chart of accounts, P&L summary, and 12-month trend build themselves. The bridge between “I just export from the bank” and “I should probably use QuickBooks.”
• AR / AP Tracker - Who owes you, who you owe, with aging buckets (current, 30, 60, 90+) deriving from invoice and bill dates. Past ten customers, this stops being optional.
• Business Tax Tracker - Annual tax overview that pulls deductible expenses across categories. Schedule C lines are pre-mapped. Pairs naturally with the Annual Tax Planner on the quarterly side.

Business operations

The daily mechanics. Budgeting, invoicing, paying people, tracking what you bought.

• Monthly Business Budget - Plan the month, log what actually happened, see the variance. Budget by category, with a dashboard summary.
• Annual Business Budget - Same idea, twelve-month horizon. Useful for the conversation with whoever signs off on the year ahead.
• Invoice Generator & Tracker - Build invoices, send them, watch them flow through paid/unpaid/overdue. Includes a sales-by-client view that tells you where your revenue concentration is (often more concentrated than you think).
• Payroll Tracker - Multi-employee payroll log with gross, net, employer taxes, YTD totals. Not a payroll service, but the workbook you reach for when you’re double-checking what Gusto sent.
• Expense Report - Submitting expenses or receiving them. Categories, totals, reimbursement status.
• Inventory Management - SKU-level inventory with reorder points and stock-on-hand. The version that actually warns you before you run out, not after.

Business planning

Where the questions stop fitting on a single sheet. KPIs, projections, break-even, forecast, valuation.

• KPI Dashboard - Define your KPIs once in settings, log monthly readings, watch the trend and the traffic-light variance against targets. The dashboard you actually look at on Monday mornings.
• 5-Year Financial Projections - Income statement, balance sheet, cash flow - all three, linked, projected out five years. The version investors ask for. Most founders build a version of this anyway; might as well start from one that’s already wired up.
• Break-Even Analysis - Fixed costs, variable costs, contribution margin, break-even quantity. The sensitivity view tells you what happens when price or volume moves by 10 percent. Worth keeping open during pricing conversations.
• Sales Forecasting - Twelve-month sales forecast with pipeline weighting and seasonality. Captures the math behind “how confident are we in the number?” - which is the question that actually matters, not the number itself.
• Business Valuation - DCF and multiples-based valuation in one workbook. The model you want to walk into a negotiation with, not invent on the back of a napkin while the other side is doing the same.

Industry models

These are the ones we’re most happy with. Each one captures the metrics that vertical actually runs on - not a generic P&L with relabeled rows.

• Restaurant Financial Model - Food cost percent, labor cost percent, prime cost, cover counts, ticket averages. If you’ve worked in restaurants, you know these numbers tell the whole story.
• E-commerce Financial Model - Unit economics with ad spend, CAC, AOV, contribution margin. The ad-spend break-even point - that’s the one that decides whether scaling is even a good idea.
• SaaS Metrics & Financial Model - MRR, ARR, churn, LTV, CAC payback, net dollar retention. Investors will ask for these in roughly that order. The team should be watching them weekly anyway.
• Startup Financial Model - Runway with headcount-driven costs, scenario toggles, and a cap table tab. Helps with the unfun conversation about dilution at the next round.

Freelancers, agencies, creators

Solo operators and tiny services firms. We spent a lot of time on this category because the existing options (one giant “freelancer template” trying to do everything) felt wrong.

• Freelancer Finance Suite - One workbook for the whole freelance business: project ledger, income and expense tracking, tax setaside, runway. The all-in-one version for people who don’t want six workbooks.
• Solo Consultant Rate & Capacity - This one was fun to build. It prices your work based on the hours you actually have, not the hours you wish you had. Adjusts for vacation, sick days, admin time, and the meetings nobody pays you for.
• Tiny Agency Capacity - Team utilization for a 2-5 person agency. Who’s overbooked, who has slack, what that does to delivery dates. Built it after talking to three agency owners who all said the same thing: “I have no idea where the time goes.”
• Creator Revenue Tracker - Multi-stream income: sponsorships, ad share, products, affiliate. Quick way to find out which stream is actually paying the bills versus which one feels like the main thing.
• Course Launch P&L - Pre-launch projections and post-launch reconciliation in the same workbook. Compare what you planned to what happened. The leak is almost always in a place you didn’t expect.

Real estate

Property analysis and the financing math behind it.

• Rental Property Analysis - Long-term rental underwriting with gross rent, operating expenses, NOI, cap rate, cash-on-cash, year-one cash flow. Use it before you make an offer.
• Airbnb / STR Tracker - Multi-property short-term rental tracking. Occupancy, ADR, RevPAR, and the cleaning and turnover math that long-term models politely ignore.
• Commercial Property Analysis - NOI, cap rate, debt service coverage ratio, and a 10-year hold analysis. Office, retail, mixed-use.
• Mortgage Analysis - Side-by-side financing comparison: 30-year fixed vs 15-year fixed vs ARM. Total interest, monthly payment, break-even on points. The math we wish we’d had during our last refi.

The bundles

Rather than category-mega-bundles (“here are all the freelancer templates, good luck”), we built smaller bundles around specific buyer personas. Each one is three templates that genuinely go together for a particular operator.

• Solo Freelancer Bundle - Finance Suite + Rate & Capacity + Tax Tracker. Earn, price, plan taxes.
• Agency Owner Bundle - Tiny Agency Capacity + Sales Forecasting + KPI Dashboard. Capacity, pipeline, operating metrics.
• Creator Business Bundle - Creator Revenue + Course Launch P&L + Tax Tracker. Multi-stream income, launches, 1099 planning.
• Restaurant Owner Bundle - Restaurant Model + Bookkeeping + Break-Even. The food cost, labor cost, prime cost math that drives every restaurant decision.
• E-commerce Seller Bundle - E-commerce Model + Break-Even + Sales Forecasting. Unit economics, ad-spend breakeven, twelve-month forecast.
• SaaS Founder Bundle - SaaS Metrics + KPI Dashboard + 5-Year Projections. MRR math plus the projection model investors expect.
• Startup Founder Bundle - Startup Model + 5-Year Projections + Valuation. Runway, projections, valuation for fundraising.
• Rental & STR Investor Bundle - Rental Analysis + Airbnb Tracker + Mortgage Analysis. Underwrite long-term, run short-term, compare financing.
• Commercial Real Estate Bundle - Commercial Property + Mortgage + Valuation. NOI / cap rate, financing, valuation for commercial deals.
• Small Business Books Bundle - Bookkeeping + AR/AP + Tax Tracker. Daily admin for service businesses.

We also broke up the old Business Operations Bundle (which had quietly grown to six templates - too many for one bundle to feel coherent) into two:

• Small Business Budget Bundle - Monthly + Annual Budget + Expense Report.
• Day-to-Day Operations Bundle - Invoice Tracker + Payroll Tracker + Inventory Management.

Excel and Google Sheets, both

Each business workbook ships as a real .xlsx file. Excel opens it natively. So does Google Sheets - upload to Drive, right-click, “Open with Google Sheets”, and the workbook converts. Formulas, charts, formatting, everything.

A few of the older templates are still Google-Sheets-first (Financial Planning, Net Worth Tracker, the monthly budget family from the personal finance side). Every product page now shows which apps it works in, so there’s no guessing.

What’s next

The Spring Sprint is the larger build of the year for business templates. Summer is going to be lighter and more focused: multi-currency support on the workbooks that don’t yet have it, FAQ pages for the new templates, and an investing-focused workbook (portfolio tracker with rebalancing math). The full picture, as always, sits on the roadmap page.

If there’s a template you’ve been waiting on that isn’t in this list - tell us. The next sprint’s list usually starts with the questions people asked first.