cwinvestments Freelancer Toolkit: Setting up freelancer workflows...
Produces time tracking sheets, invoice calculations, and project analytics for freelancers managing multiple clients.
Activation
| 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 |
Context Guard
- Do NOT use for proposal writing (that's proposal-writer)
- Do NOT use for scope of work documents (that's scope-of-work)
- Do NOT use for generic invoice templates (that's invoice-generator)
- This skill covers the full freelancer workflow: tracking time → calculating billable → generating invoice → analyzing profitability
Steps
Step 1: Gather freelancer context
| 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 |
Step 2: Time tracking sheet
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:
- Log daily, reconstructing from memory loses hours
- Separate billable from non-billable (admin, learning, invoicing)
- Round to nearest 15 minutes (0.25 hr increments)
- Include project and task for accurate per-project reporting
- Notes field captures context for invoice line items
Step 3: Invoice calculation
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.
Step 4: Monthly analytics
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 |
Step 5: Alerts and recommendations
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 |
Step 6: File organization
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
Output Template
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]
Disambiguation
- "track my time" / "billable hours" / "freelancer invoice" = Freelancer Toolkit
- "write a proposal" / "project proposal" = Proposal Writer (not this skill)
- "scope of work" / "SOW" = Scope of Work (not this skill)
- "create invoice" / "invoice template" = Invoice Generator (not this skill)
- "financial model" / "projections" = Financial Model (not this skill)
Level History
- Lv.1: Base: Time tracking, invoice calculation, monthly analytics, profitability analysis, alerts. (Origin: MemStack v3.5, Apr 2026)