Startup Cost Template Excel: Worksheet With Runway

Quick Answer: A startup cost template in Excel needs two blocks: one-time costs you pay before opening (equipment, deposits, licenses, a website) and monthly operating costs you pay until revenue covers them. Add a contingency line, multiply the monthly block by the months you expect to run before breaking even, and the sum is the cash you need to start.

Startup costs are the money you spend before the business pays for itself. For a business plan, lenders and partners want to see that figure split into one-time purchases and recurring expenses, with a cushion for surprises and a runway estimate. A single Excel sheet with four sections and a few SUM formulas does the job.

What goes on a startup cost worksheet?

The SBA's page on calculating startup costs groups expenses into one-time and monthly, and lists the usual suspects: office space, equipment and supplies, communications, utilities, licenses and permits, insurance, lawyer and accountant, inventory, employee salaries, advertising and marketing, market research, printed materials and a website. Not every business has every line. A consultant working from home may have six rows; a café may have forty.

For each row record four facts:

• Item — specific enough to price ("commercial vacuum x2", not "equipment").
• Type — One-time or Monthly.
• Estimate — the amount, with the source in a note (a quote, a vendor's price page, a mentor's figure).
• Confidence — High for quoted prices, Low for guesses. You will use this to size the contingency.

Layout: one sheet, four blocks

Set the sheet up top to bottom so a reader can follow it without scrolling sideways.

1. Inputs (rows 2–5). Contingency rate in B2 (say 15%), months of runway in B3, expected first-month revenue in B4, expected monthly revenue growth in B5.
2. One-time costs (from row 8). Item, category, estimate, confidence, note.
3. Monthly operating costs (below that). Same columns, but the estimate is a monthly amount.
4. Totals (at the bottom). The formulas that turn the lists into the number the plan quotes.

Give the input cells defined names (Contingency, Runway, StartRevenue, Growth) so totals read as =OneTime*(1+Contingency) rather than =D30*(1+B2). That makes the sheet much easier for a lender's analyst to audit.

The totals, cell by cell

A more realistic runway subtracts expected revenue. Put month numbers 1 to 12 across a row, revenue for month one from B4, then =prior*(1+Growth) for each later month. Below it, net burn is =MAX(0,Monthly-Revenue). Sum the net burn across the months before revenue exceeds costs and use that instead of Monthly*Runway. The plain version overstates the need; the revenue version understates it if your sales forecast is optimistic. Show both and say which one the request uses.

Worked example: a two-crew home cleaning service

One-time costs:

Monthly operating costs: van payment and insurance $780, fuel $450, supplies restock $300, software $120, phone $90, advertising $600, payroll for two part-time cleaners $5,200, bookkeeping $250. Monthly subtotal: $7,790.

With four months of runway, the reserve is $31,160. A 15% contingency on one-time plus runway is ($13,550 + $31,160) × 0.15 = $6,707 (rounded). Cash needed to start: $13,550 + $31,160 + $6,707 = $51,417.

If the owner expects $3,000 of revenue in month one growing 40% a month, net burn is $4,790, $3,590, $1,910, and in month four revenue of $8,232 exceeds costs. Runway reserve from the revenue version is $10,290, and the request falls to about $27,400 after contingency. The honest plan shows both figures and explains the sales assumption.

How does the IRS treat startup costs?

The tax treatment is separate from the planning sheet, but it changes how you label rows. IRS Publication 583, Starting a Business and Keeping Records, says you can elect to deduct up to $5,000 of business start-up costs and up to $5,000 of organizational costs, that each $5,000 is reduced by the amount the costs exceed $50,000, and that any remaining costs must be amortized, pointing to the Instructions for Form 4562. An IRS newsroom article on deducting startup costs (marked archival) describes recovering the rest over 180 months and lists examples such as market analysis, opening advertisements, training wages and consultant fees.

Three practical consequences for the worksheet:

• Add a tax column. Mark each one-time row as Start-up, Organizational (forming the entity), or Asset. Equipment and vehicles are generally depreciated, not treated as start-up costs, which is why the van in the example is its own category.
• Keep the evidence. The figure your accountant uses will come from what you actually paid, not the estimate. Keep a second column for Actual and fill it from invoices and statements as the money goes out.
• Do not guess the election. Whether and how to elect is a question for your tax preparer once the year closes.

Turning estimates into actuals

The worksheet is most useful after launch if you keep it. Add an Actual column next to Estimate and a Variance column =Actual-Estimate. Most pre-opening spending goes through one business bank account and one card, so the monthly statements are the record. Bank CSV exports are the easiest source; if you only have PDF statements, QuickBankConvert turns each one into dated, signed rows you can sort by payee and match to the worksheet lines.

That comparison tells you which estimates were wrong, by how much, and whether contingency was big enough. It is also the cleanest possible file to give whoever prepares your first return.

Where this fits in the business plan

The SBA's guide to writing a business plan puts startup costs and funding needs in the financial section. Paste the totals table, not the full item list, and attach the detailed sheet as an appendix. If you are already operating and the plan is for a loan, lenders will also want to see bank statements; using bank statements in a business plan explains how they are read. After launch, the startup sheet hands off to an ongoing small business budget template and regular bookkeeping for a small business.

Mistakes that make the number wrong

• Forgetting the owner's own living costs during runway. If you will draw nothing for four months, say so; if you need a draw, it is a monthly row.
• Pricing equipment new when you will buy used, or the reverse.
• Leaving out deposits (lease, utilities) because they are refundable. You still need the cash.
• Using one contingency rate for everything. A 10% cushion on quoted items and 30% on guesses is more defensible than a flat 15%.
• Counting a loan you have not been approved for as money already in hand.