Why I Built Something Simpler Than My Client's $400 Project Management Tool
Most freelancers I talk to are drowning in project management tools they don't need. They'll spend more time configuring Notion dashboards and ClickUp automations than they actually do on billable work. I hit that wall around 2018 when I was juggling twelve clients across four platforms. The answer wasn't better software. It was less of it. The Freelancing Planner Simple is what you get when you strip away everything a freelancer never uses. It's a single spreadsheet-style grid where each row is a client project and each column tracks status, hours logged, invoices sent, and next action. That's it. No Kanban boards. No team collaboration features. No Gantt charts. Just rows and columns that you can glance at while you're actually working. I built my first version in Google Sheets during a flight delay in 2019. The spreadsheet was maybe two hundred cells across. I spent three hours setting it up and another two adjusting the color coding. It took me about four minutes per day to update after that. Compare that to the six-to-eight hours a month I was losing trying to keep Monday.com and Airtable synced. The math was brutal.
How It Actually Works Day to Day
Here's the practical setup. Column A is the project name. Column B is the client. Column C is the current status — active, waiting on feedback, invoiced, complete. Column D is hours committed. Column E is hours logged. Column F flags the next action due within seven days. Columns G through J track milestone dates, invoice amounts, payment status, and a notes field for anything too specific to fit elsewhere. The format forces a discipline most planners skip. You can't hide behind a project's vague timeline because "next action due" is a hard constraint. If you're staring at a blank cell in column F and can't fill it, that project needs a conversation with the client, not another tool setting. I learned that the hard way when a website redesign stalled for three weeks because I had it marked "active" but never actually written down what was blocking progress. The grid exposed it immediately.
Things Beginners Get Wrong on Day One
The biggest mistake I see people make is overcomplicating the status column. They'll create six or seven different statuses like "in research phase," "awaiting assets," "first draft in review," "revisions round two," and so on. This creates more cognitive load than it removes. Four statuses is the ceiling: active, waiting on client, invoiced, complete. If a project doesn't fit neatly into one of those buckets, it's your planning system that's broken, not the project. Another common failure point is the hours tracking. People either log every single hour with minute-level precision, which takes ten minutes per day and yields numbers nobody actually uses, or they never log hours at all, which makes rate negotiation impossible six months later. The sweet spot I found is logging daily totals in rough quarter-hour blocks. That's about two minutes a day. It gives you enough data to identify which clients are profitable without turning admin into a second job.
Get the Full Details
Where This Falls Apart
Be honest with yourself about when this approach stops working. If you have more than eight concurrent projects, the spreadsheet becomes unreadable even with color coding. If any of your clients require shared visibility into project progress, a private sheet won't cut it. If you're part of a small agency with three or more freelancers working together, the lack of collaboration features becomes a real bottleneck fast. In those cases, I'd recommend either switching to a lightweight Kanban tool like Trello or accepting that you'll need a second system for team coordination while keeping the planner simple for your own personal tracking. There's also the data problem. If your spreadsheet gets to a thousand rows and you haven't archived completed projects, performance degrades noticeably. I keep current projects in one sheet and archive by year in separate files. It's crude but it keeps the active view fast enough to open in under two seconds on a decent laptop.
Getting Started
You don't need to download anything or pay for a subscription. Open a blank Google Sheet or Airtable base and build the grid I described above. Set the column widths so the next-action column is always visible on screen — that's where attention should go. Add a conditional formatting rule that highlights anything past due in orange and anything due within three days in yellow. That's roughly twenty minutes of setup total. The actual file lives here if you want to copy it directly rather than build from scratch: Download the Freelancing Planner Simple template. I've kept it deliberately unpolished. The formulas are basic, the styling is minimal, and there's no onboarding walkthrough. That's intentional. Spend ten minutes exploring the cells and you'll understand it faster than you'd understand any tutorial. Update it every evening while your coffee is still warm. Don't let the log pile up for a week and try to reconstruct it from memory. That's how you lose data reliability and end up right back where you started.
