I got tired of expensive accounting software for my side project. So I built a 6-tab Google Sheet that handles everything:
Tabs:
- Dashboard: instant runway & burn rate
- Revenue: monthly projections with formulas
- Expenses: categories for cloud, freelance, marketing
- Cash Flow: 12-month forward view
- Budget vs Actual: variance tracking
- Settings: customizable percentages
Key formulas used:
• =SUMIF for category totals
• =XLOOKUP for cross-tab lookups
• =ARRAYFORMULA for dynamic ranges
• Conditional formatting for overspend alerts
The best part? Costs zero subscriptions — runs entirely in Google Sheets.
I turned it into a template that fills in sample data so you can adapt in 2 minutes.
👉 Grab the template here: Bootstrap Budget Planner — Google Sheets
Upvote if this helps you track your startup cash!
Top comments (0)