Annual Business Review Template
Year-in-review framework analyzing revenue, clients, growth metrics, lessons learned, and goals for the next year.
📄 Product Preview
Try the interactive reader and demo tools below, or get the full product with all content unlocked.
📖 Interactive Reader (Free Preview) ⚙ Try Demo Tools 📦 Download Free Sample📁 File Structure 22 files
📖 Documentation Preview README excerpt
Annual Business Review Kit for Freelancers
Stop guessing about your freelance business. Run a data-driven annual review that shows you exactly where the money came from, which clients are worth keeping, and where to focus next year.
What's Inside
Data Sheets (CSV — import into Google Sheets or Excel)
| File | What It Does |
|---|---|
sheets/revenue-breakdown.csv | Monthly revenue by service category with expenses, profit margins, and an annual summary row. Sample: 7 months of design/dev/content work across 7 clients. |
sheets/client-analysis.csv | Client-by-client breakdown: revenue, hours, effective hourly rate, profitability grade, referral source, and relationship notes. |
sheets/growth-metrics.csv | Year-over-year comparison across 18 business metrics with target columns for next year. |
sheets/time-allocation.csv | Where your hours actually went: billable work, sales, admin, marketing, skill development, and scope creep. |
Review Templates (Markdown — fill in with your data)
| File | What It Does |
|---|---|
templates/year-in-review-worksheet.md | The main review document. 7 sections covering revenue, clients, time, wins, lessons, and a business health scorecard. |
templates/next-year-goals-template.md | Turn review insights into 6 concrete SMART goals with revenue math, rate increase scripts, and accountability schedules. |
templates/quarterly-okr-template.md | Break annual goals into quarterly Objectives and Key Results. Includes a filled Q1 example and end-of-quarter retrospective. |
Guides & Reference Pages
| File | What It Does |
|---|---|
pages/annual-review-hub.md | Central dashboard linking all sheets and templates. Review workflow (3 phases), quick-win health check metrics. |
pages/the-review-process.md | Step-by-step guide to the 3-phase review: Look Back, Analyze, Look Forward. |
pages/goal-setting-framework.md | SMART goal framework adapted for freelancers, with revenue growth benchmarks and the 3 levers of freelance revenue. |
docs/how-to-run-your-review.md | Detailed walkthrough: what data to gather, how to fill each sheet, key questions to ask, quarterly planning principles, common mistakes. |
docs/metrics-glossary.md | Reference for every metric: definition, formula, worked example, and "what good looks like" benchmarks. 20+ metrics covered. |
Quick Start
1. Import the CSV files
Google Sheets:
1. Go to [Google Sheets](https://sheets.google.com) and create a new spreadsheet
2. For each CSV file: File > Import > Upload > select the CSV
3. Choose "Replace current sheet" for the first file, "Insert new sheet" for the rest
4. Rename each sheet tab to match the file name
Excel:
1. Open Excel and go to Data > From Text/CSV
2. Select each CSV file and import
3. Each file becomes a new worksheet
2. Replace the sample data
The CSV files contain realistic sample data for a $77,500/year freelancer doing design, web development, and content work. Replace this with YOUR actual numbers:
- Pull revenue and expense data from your invoicing tool (FreshBooks, Wave, QuickBooks, etc.)
- Pull hours from your time tracker (Toggl, Harvest, Clockify)
- Pull client details from your CRM or project notes
... continues with setup instructions, usage examples, and more.
📄 Content Sample templates/next-year-goals-template.md
Next Year Goals Template
Turn your review insights into concrete, measurable goals.
Use the SMART framework: Specific, Measurable, Achievable, Relevant, Time-bound.
Your Numbers Baseline (from the Year-in-Review Worksheet)
| Metric | This Year (Actual) | Next Year (Target) | Growth % |
|---|---|---|---|
| Gross Revenue | $________ | $________ | ___% |
| Net Profit | $________ | $________ | ___% |
| Average Hourly Rate | $________ | $________ | ___% |
| Number of Clients | ________ | ________ | |
| Billable Utilization | ___% | ___% | |
| Largest Client Share | ___% | <___% |
Goal 1: Revenue
Target: $____________ gross revenue (___% growth from this year)
How I'll get there (pick 2-3):
- [ ] Raise rates by ___% across all services (effective date: _________)
- [ ] Add ___ new clients at $_________ average project value
- [ ] Convert ___ project clients to retainer at $________/month
- [ ] Launch new service offering: _________________ at $________
- [ ] Increase average project size from $________ to $________
- [ ] Reduce client churn by phasing out C/D clients, replacing with A/B
Revenue math check:
Current recurring revenue: $________/month × 12 = $________/year
+ New retainers expected: $________/month × ___ months = $________
+ Project work pipeline: ___ projects × $________ avg = $________
= Projected Revenue: $________
Does this hit your target? Yes / No / Close (within 10%)
Goal 2: Profitability
... and much more in the full download.