The First-Time Founder's Guide to FP&A: What to Track from Day One

The Spreadsheet That Should Exist Before Your First Hire

Most first-time founders don't build a finance function — they inherit one, usually by accident, usually too late. It starts as a bank login checked every few days, becomes a shoebox of invoices come tax season, and eventually turns into a panicked scramble when an investor asks for a cap table reconciliation or a bank asks for 13-week cash projections before approving a line of credit.

The good news: you don't need a CFO, a finance degree, or expensive software to build good financial habits from day one. You need discipline around a small number of numbers, tracked consistently, from the moment you incorporate. Here's what actually matters in year one — and what can wait.

Start With Cash, Not Profit

New founders obsess over whether they're "profitable" long before profitability is even the right question. In year one, the only question that matters is: how many months of runway do I have, and is that number growing or shrinking?

Build this habit immediately:

• Track cash weekly, not monthly. A monthly view hides the week you almost bounced payroll.
• Separate operating cash from raised capital. If you took a loan or raised a pre-seed round, know how much of your bank balance is actually yours to burn versus obligated elsewhere.
• Calculate burn multiple early: net cash burned divided by net new revenue generated in the same period. It tells you how efficiently you're converting spending into growth, and it's a number investors will ask about before you even open your deck.

Accrual accounting matters eventually. In month three, cash is king.

The Five Numbers to Track From Day One

Forget dashboards with forty tiles. In the first year, five numbers will tell you almost everything you need to know:

1. Cash balance and runway (in months) — updated weekly.
2. Monthly burn rate — gross cash out, not netted against inflows, so you understand true spending velocity.
3. Revenue (or bookings, if pre-revenue) — tracked by the actual date cash or commitment was received, not vague projections.
4. Customer or unit count — however you define a "customer," track how many you have and how many you're losing.
5. Accounts payable aging — even at small scale, know what you owe and when it's due. This is the single most common blind spot that turns into a cash crisis.

Resist the urge to build elaborate models before you have twelve months of real data. A simple, honestly-maintained spreadsheet beats a sophisticated model built on guesses.

Set Up Your Chart of Accounts Like You Mean It

Most founders inherit a chart of accounts from whatever bookkeeper or software they used first, then never revisit it. This is a mistake that compounds. A messy chart of accounts in month one becomes an unusable general ledger by month eighteen, right when you need clean historicals for a fundraise or loan application.

Spend an afternoon in your first quarter doing this properly:

• Separate cost of goods sold from operating expenses clearly, even if the line is blurry for your business model. You'll need gross margin data sooner than you think.
• Break payroll into functional buckets (engineering, sales, G&A) rather than one lump "salaries" line. Investors and lenders will ask for this breakdown, and reconstructing it after the fact is painful.
• Tag one-time expenses separately from recurring ones. A legal bill for incorporation shouldn't live in the same bucket as your recurring software subscriptions.

Build a Simple 13-Week Cash Flow Forecast Early

According to a widely cited U.S. Bank study, roughly 82% of small business failures involve cash flow problems as a contributing factor — not lack of demand or a bad product, but a failure to see a shortfall coming in time to act.

A rolling 13-week cash forecast doesn't need to be sophisticated. It needs three columns: expected cash in, expected cash out, and ending balance, updated weekly. This single habit, maintained from month one, is what separates founders who see a cash crunch three months out from those who discover it the week they can't make payroll.

What Can Wait

Not everything needs to be built on day one. Founders often over-invest early in areas that don't yet matter:

• Complex financial models with five years of projections — useful for fundraising narratives, less useful for actually running the business in year one.
• Formal budgeting processes — with a small team, a simple spending ceiling per function is more useful than a rigid annual budget.
• Elaborate KPI dashboards — five well-tracked numbers beat forty poorly-maintained ones.

The SBA's guidance on financial management for new businesses echoes this: consistency and accuracy in basic tracking outperforms sophistication applied inconsistently.

When to Bring in Outside Help

Most founders don't need a full-time finance hire in year one, but they benefit from a part-time bookkeeper or fractional controller earlier than they expect — often around the time monthly revenue crosses low six figures, or the moment a fundraise or loan application requires clean historical financials. Waiting until you're overwhelmed means paying someone to untangle a mess rather than maintain a system.

Actionable Takeaways

• Track cash weekly, not monthly — runway visibility is the single highest-leverage habit a new founder can build.
• Pick five numbers and track them religiously: cash balance, burn rate, revenue, customer count, and AP aging.
• Build your chart of accounts correctly in quarter one — retrofitting a messy ledger later is far more expensive than doing it right upfront.
• Start a rolling 13-week cash forecast immediately, even if it's just a simple spreadsheet.
• Don't over-build. Skip elaborate models and dashboards until you have enough real data and enough team complexity to justify them.
• Bring in fractional finance help before you're desperate, not after.

The founders who avoid financial fire drills aren't the ones with the fanciest tools — they're the ones who built simple, consistent tracking habits before they ever needed to.