# 💼 Freelancer Project Tracker

> AI-powered client management, project tracking, and invoicing system for freelancers.

---

## 📋 How to Use
1. Duplicate this page to your Notion workspace
2. Add your clients and projects
3. Use AI prompts for proposals, pricing, and client communication
4. Track time, invoices, and revenue

---

## 👥 Client Database

| Client | Contact | Email | Project | Status | Rate | Total Billed |
|--------|---------|-------|---------|--------|------|--------------|
| | | | | 🟢 Active | $/hr | $ |
| | | | | 🟡 Pending | $/hr | $ |
| | | | | 🔴 Completed | $/hr | $ |
| | | | | ⚪ Lead | $/hr | $ |

---

## 📊 Project Pipeline

### Active Projects

| Project | Client | Deadline | Progress | Hours | Budget | Spent |
|---------|--------|----------|----------|-------|--------|-------|
| | | | ░░░░░ 0% | 0h | $ | $ |
| | | | ██░░░ 40% | 0h | $ | $ |
| | | | ████░ 80% | 0h | $ | $ |

### Project Stages
| Stage | Description |
|-------|------------|
| 💡 Discovery | Initial client call, scope discussion |
| 📝 Proposal | Sending proposal, negotiation |
| ✅ Accepted | Contract signed, deposit received |
| 🔨 In Progress | Active work |
| 🔄 Review | Client review and feedback |
| 📦 Delivered | Final delivery |
| 💰 Invoiced | Invoice sent, awaiting payment |
| ✨ Completed | Paid and archived |

---

## ⏱️ Time Tracker

| Date | Client | Project | Task | Hours | Billable? |
|------|--------|---------|------|-------|----------|
| | | | | | ✅ |
| | | | | | ✅ |
| | | | | | ❌ |

### Weekly Summary
| Week | Billable Hours | Non-Billable | Total | Revenue |
|------|---------------|-------------|-------|---------|
| | h | h | h | $ |

---

## 💰 Invoice Tracker

| Invoice # | Client | Amount | Date Sent | Due Date | Status |
|-----------|--------|--------|-----------|----------|--------|
| INV-001 | | $ | | | ⬜ Draft |
| INV-002 | | $ | | | 📤 Sent |
| INV-003 | | $ | | | ✅ Paid |
| INV-004 | | $ | | | ⚠️ Overdue |

### Revenue Dashboard
| Month | Invoiced | Collected | Outstanding | Expenses | Net Profit |
|-------|----------|-----------|-------------|----------|------------|
| Jan | $ | $ | $ | $ | $ |
| Feb | $ | $ | $ | $ | $ |
| Mar | $ | $ | $ | $ | $ |

---

## 🤖 AI Prompt Station

### Proposal Generator
```
I need to write a freelance proposal for:
- Client: [name/company]
- Project: [describe the project]
- My skills: [relevant skills]
- Timeline: [estimated duration]
- Budget range: [if known]

Please create a professional proposal that includes:
1. Understanding of their needs (show I listened)
2. My approach and methodology
3. Deliverables with timeline
4. 3 pricing tiers (Basic/Standard/Premium)
5. Why I'm the right fit
6. Social proof section (where to add testimonials)
7. Next steps / CTA

Tone: Professional but personable
Length: 1-2 pages
```

### Pricing Calculator Prompt
```
Help me price this freelance project:
- Service type: [design/development/writing/etc.]
- Scope: [describe deliverables]
- Estimated hours: [your estimate]
- My experience level: [junior/mid/senior/expert]
- Client type: [startup/small biz/enterprise/agency]
- Market: [US/EU/global]

Please provide:
1. Hourly rate recommendation (with reasoning)
2. Project-based price (3 tiers)
3. Value-based pricing option
4. Comparison to market rates
5. Upsell opportunities to increase project value
```

### Client Communication Templates
```
Generate professional email templates for:
1. Initial inquiry response (within 2 hours)
2. Follow-up after discovery call
3. Proposal send + gentle follow-up sequence (day 1, 3, 7)
4. Project kickoff email
5. Progress update (weekly)
6. Revision request handling (scope creep prevention)
7. Invoice send with payment reminder sequence
8. Project completion + testimonial request
9. Re-engagement email (past client, 3 months later)

My name: [name]
My service: [service]
Tone: [professional/friendly/casual]
```

### Scope Creep Prevention Prompt
```
A client is asking for additional work beyond the original scope:
- Original scope: [what was agreed]
- New request: [what they're asking for]
- Relationship: [new client/long-term/VIP]

Help me craft a response that:
1. Acknowledges their request positively
2. Clearly explains it's outside scope
3. Offers it as an add-on with pricing
4. Maintains the relationship
5. Sets a precedent for future boundaries
```

---

## 📈 Annual Goals

| Goal | Target | Current | Progress |
|------|--------|---------|----------|
| Annual Revenue | $ | $ | ░░░ 0% |
| Active Clients | | | |
| Avg Project Size | $ | $ | |
| Hourly Rate | $/hr | $/hr | |
| Testimonials | | | |

---

## 📚 Resources & SOPs

| Process | Link/Notes |
|---------|------------|
| Onboarding checklist | |
| Contract template | |
| Invoice template | |
| Portfolio link | |
| Rate card | |

---

*Template by [AI Notion Templates](https://writsop.github.io/notion-ai-templates/) • v1.0*