This chapter covers the core features and capabilities of Annual Business Review Template.
| 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. |
| 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. |
| 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. |
Google Sheets:
1. Go to Google Sheets 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
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:
Follow the workflow in pages/annual-review-hub.md:
1. Phase 1 — Look Back (1 hour): Fill in the data sheets with your real numbers
2. Phase 2 — Analyze (30 min): Complete templates/year-in-review-worksheet.md
3. Phase 3 — Look Forward (1 hour): Set goals in templates/next-year-goals-template.md and break them into quarterly OKRs
Total time: 2-3 hours. Block a half-day.
Put these dates in your calendar NOW:
Follow this guide to get Annual Business Review Template up and running in your environment.
The sample data uses Design, Web Development, Content, and Consulting. Replace these with your actual service categories. Common alternatives:
The sample data models a $77,500/year freelancer. The templates and frameworks work at any revenue level — just replace the numbers. The metrics glossary includes benchmarks for different income tiers.
Save each year's completed review in a dated folder (e.g., 2025-Annual-Review/). After 2-3 years, you'll have trend lines that are more valuable than any single year's snapshot.
The included CSVs model a freelance designer/developer with this profile:
| Metric | Value |
|---|---|
| Annual gross revenue | $77,500 |
| Annual expenses | $4,280 |
| Net profit margin | 94.5% |
| Total clients | 8 |
| Total invoices | 27 |
| Average invoice size | $2,870 |
| Total hours worked | 1,080 |
| Average effective rate | $104.87/hr |
| Top client revenue share | 16.3% (healthy — no single-client dependency) |
| Repeat client rate | 37.5% |
This gives you a realistic frame of reference for what a completed review looks like.
Get the full Annual Business Review Template and unlock everything.
Get the complete guide with every chapter unlocked, including code samples, diagrams, and best practices.
Access all interactive tools with complete data, all workload profiles, and the full scenario library.
Downloadable source code, configuration files, and working examples from every chapter.
Free updates for life. Every new chapter, tool, and improvement included.