DEV Community

Brad
Brad

Posted on

How I Track All My Freelance Income and Clients with Just 4 CSV Files

#freelancing #productivity #tools #beginners

How I Track All My Freelance Income and Clients with Just 4 CSV Files

Most freelancers I talk to either use nothing (mental notes + email search) or pay $50/month for project management software that has 200 features they never use.

I landed on a middle ground: 4 CSV files that sync to Notion and cover 95% of what a freelance business actually needs.

The 4 Files

1. Client Tracker (clients.csv) 

name,email,company,status,source,first_project_date,notes
Acme Corp,jane@acme.com,Acme Inc,active,cold_email,2026-01-15,Python data pipeline
Startup XYZ,bob@xyz.io,XYZ Ltd,prospect,referral,,Intro call pending
Enter fullscreen mode Exit fullscreen mode

Columns that matter:

  • status: prospect → active → dormant → churned
  • source: where they came from (referral, cold email, upwork, etc.)
  • notes: one sentence about what they needed

2. Project Tracker (projects.csv) 

id,client,title,status,fee_usd,paid,start_date,end_date,notes
P001,Acme Corp,Data Pipeline v1,done,500,yes,2026-01-15,2026-01-28,
P002,Startup XYZ,API Integration,in_progress,300,no,2026-02-01,,50% milestone paid
Enter fullscreen mode Exit fullscreen mode

The key column: paid — yes/no/partial. Nothing else matters as much.

3. Invoice Tracker (invoices.csv) 

id,project_id,client,amount_usd,due_date,paid_date,status
INV-001,P001,Acme Corp,500,2026-01-30,2026-01-28,paid
INV-002,P002,Startup XYZ,150,2026-02-15,,pending
Enter fullscreen mode Exit fullscreen mode

Rule: one row per invoice, never delete rows, set status to overdue after due date.

4. Weekly Review (weekly_review.csv) 

week,revenue,hours_billed,hours_worked,leads_contacted,proposals_sent,notes
2026-W04,500,8,12,5,2,Finished Acme project
2026-W05,150,4,5,3,1,XYZ milestone
Enter fullscreen mode Exit fullscreen mode

Five minutes every Friday. The hours_billed vs hours_worked ratio tells you if you're undercharging.

How I use these in Notion

Notions CSV import creates a database. Once imported, you can add:

  • Computed fields (revenue by month = SUMIF on weekly_review)
  • Filtered views ("All active clients", "Overdue invoices")
  • Kanban view (drag projects through status columns)

The actual template (free download)

If you want the exact 4 CSVs with the column definitions and formula notes:

Freelance Business Starter Kit — $9, includes all 4 templates with README and Notion import guide.

Or for the Notion-optimized version with richer property types:
Notion Freelance OS — $12.

Why not just use FreshBooks/Harvest/etc.?

  • $0/month vs $20–50/month
  • You own the data, no vendor lock-in
  • Takes 15 minutes to customize vs learning a new product
  • Works offline (it's CSVs)

For most freelancers under $100K/year, specialized accounting software is overkill. Quarterly taxes need a simple income log. These 4 files are that log.

What do you use to track freelance work? Curious whether most people are still using spreadsheets or have moved to something else.

Top comments (0)