← Back to all products

Annual Business Review Template

$19

Year-in-review framework analyzing revenue, clients, growth metrics, lessons learned, and goals for the next year.

24 files
MarkdownJSONGoogle SheetsExcel

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 24 files

annual-business-review/ ├── LICENSE ├── README.md ├── annual-business-review.xlsx ├── docs/ │ ├── how-to-run-your-review.md │ └── metrics-glossary.md ├── free-sample.zip ├── guide/ │ ├── 01_what-s-inside.md │ ├── 02_customization.md │ ├── 03_faq.md │ └── 04_disclaimer.md ├── index.html ├── interactive.html ├── pages/ │ ├── annual-review-hub.md │ ├── goal-setting-framework.md │ └── the-review-process.md ├── sample.xlsx ├── sheets/ │ ├── client-analysis.csv │ ├── growth-metrics.csv │ ├── revenue-breakdown.csv │ └── time-allocation.csv └── templates/ ├── next-year-goals-template.md ├── quarterly-okr-template.md └── year-in-review-worksheet.md

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)

FileWhat It Does
sheets/revenue-breakdown.csvMonthly 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.csvClient-by-client breakdown: revenue, hours, effective hourly rate, profitability grade, referral source, and relationship notes.
sheets/growth-metrics.csvYear-over-year comparison across 18 business metrics with target columns for next year.
sheets/time-allocation.csvWhere your hours actually went: billable work, sales, admin, marketing, skill development, and scope creep.

Review Templates (Markdown — fill in with your data)

FileWhat It Does
templates/year-in-review-worksheet.mdThe main review document. 7 sections covering revenue, clients, time, wins, lessons, and a business health scorecard.
templates/next-year-goals-template.mdTurn review insights into 6 concrete SMART goals with revenue math, rate increase scripts, and accountability schedules.
templates/quarterly-okr-template.mdBreak annual goals into quarterly Objectives and Key Results. Includes a filled Q1 example and end-of-quarter retrospective.

Guides & Reference Pages

FileWhat It Does
pages/annual-review-hub.mdCentral dashboard linking all sheets and templates. Review workflow (3 phases), quick-win health check metrics.
pages/the-review-process.mdStep-by-step guide to the 3-phase review: Look Back, Analyze, Look Forward.
pages/goal-setting-framework.mdSMART goal framework adapted for freelancers, with revenue growth benchmarks and the 3 levers of freelance revenue.
docs/how-to-run-your-review.mdDetailed walkthrough: what data to gather, how to fill each sheet, key questions to ask, quarterly planning principles, common mistakes.
docs/metrics-glossary.mdReference 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)

MetricThis 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.