Use when the user says 'track my time', 'freelancer invoice', 'billable hours', 'time tracking', 'freelance finances', 'client billing', 'project hours', or needs invoicing, time tracking, or analytics patterns for freelance work. Do NOT use for general invoice templates or proposal writing.
Produces time tracking sheets, invoice calculations, and project analytics for freelancers managing multiple clients.
| Trigger | Status |
|---|---|
| User says "track my time" or "billable hours" | ACTIVE |
| User says "freelancer invoice" or "client billing" | ACTIVE |
| User says "freelance finances" or "project hours" | ACTIVE |
| User wants a formal proposal or SOW | NOT this skill — use Proposal Writer or Scope of Work |
| User wants a generic invoice template | NOT this skill — use Invoice Generator |
| Parameter | Default | Example |
|---|---|---|
| Hourly rate | Ask | $150/hr, $85/hr |
| Currency | USD | EUR, GBP, AUD |
| Billing cycle | Monthly | Weekly, per-project |
| Clients | Ask | Acme Corp, StartupX |
| Tax rate | 0% (user adds) | 20% VAT, 25% self-employment |
Create or update a tracking spreadsheet (CSV or markdown):
# Time Log — [Month Year]
## [Client Name]
| Date | Project | Task | Hours | Billable | Notes |
|------|---------|------|-------|----------|-------|
| 2026-04-01 | Website Redesign | Homepage wireframes | 3.5 | Yes | Completed v1 |
| 2026-04-01 | Website Redesign | Client feedback call | 0.5 | Yes | Revision notes |
| 2026-04-02 | API Integration | Auth endpoint | 4.0 | Yes | |
| 2026-04-02 | Internal | Admin/invoicing | 1.0 | No | Non-billable |
**Subtotal:** 8.0 billable hours / 9.0 total hours
Time tracking rules:
Compute totals from the time log:
# Invoice Calculation — [Client Name] — [Period]
| Project | Hours | Rate | Subtotal |
|---------|-------|------|----------|
| Website Redesign | 24.5 | $150 | $3,675.00 |
| API Integration | 16.0 | $150 | $2,400.00 |
| | |
|---|---|
| Subtotal | $6,075.00 |
| Tax ([rate]%) | $[amount] |
| **Total Due** | **$[amount]** |
| Payment terms | Net 30 |
| Due date | [date] |
For fixed-price projects, track hours anyway for profitability analysis.
Generate a freelancer dashboard:
# Freelance Analytics — [Month Year]
## Revenue Summary
| Client | Invoiced | Paid | Outstanding |
|--------|----------|------|-------------|
| Acme Corp | $6,075 | $6,075 | $0 |
| StartupX | $3,200 | $0 | $3,200 |
| **Total** | **$9,275** | **$6,075** | **$3,200** |
## Time Breakdown
- Total hours logged: 82.0
- Billable hours: 68.5 (83.5% utilization)
- Non-billable hours: 13.5
- Effective hourly rate: $135.40 (revenue / total hours)
## Client Concentration
- Acme Corp: 65.5% of revenue (risk: high dependency)
- StartupX: 34.5%
## Profitability by Project
| Project | Hours | Revenue | Effective Rate |
|---------|-------|---------|----------------|
| Website Redesign | 24.5 | $3,675 | $150/hr |
| API Integration | 16.0 | $2,400 | $150/hr |
| Maintenance | 28.0 | $3,200 | $114/hr |
Flag issues automatically:
| Alert | Threshold | Action |
|---|---|---|
| Low utilization | < 70% billable | Review non-billable time, reduce admin overhead |
| Client concentration | > 50% one client | Diversify — pursue new leads |
| Outstanding invoices | > 30 days | Send payment reminder |
| Effective rate below target | < 80% of hourly rate | Review scope creep, renegotiate |
| Overwork | > 45 hrs/week sustained | Raise rates or reduce commitments |
Recommended folder structure:
freelance/
clients/
acme-corp/
time-log-2026-04.md
invoices/
INV-2026-04-001.md
startupx/
time-log-2026-04.md
invoices/
analytics/
2026-04-monthly.md
templates/
invoice-template.md
time-log-template.md
Freelancer Report — [Period]:
- Billable hours: [N] ([utilization]% utilization)
- Revenue: $[amount] ([N] invoices)
- Outstanding: $[amount]
- Effective rate: $[rate]/hr
- Alerts: [list any flags]
Files updated: [list]