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

📁 22 files
MarkdownGoogle 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 22 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 ├── 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.

Buy Now — $19 Back to Products