Freelancing Template

What You Actually Need When You Start Taking on Client Work

Most people jump straight into building a portfolio site when they should be setting up their operating system first. I learned that the hard way after three months of bouncing between Upwork proposals and invoicing on a napkin. The Freelancing Template I eventually settled on isn't fancy. It's a spreadsheet, a Notion dashboard, and a single contract file that I've modified so many times it barely resembles the original anymore. Here's the structure. I keep it in Google Sheets because I need it to load fast on my phone when a client asks for a timeline at 11pm. Column A is project name. Column B is client contact. Column C is scope—this one matters more than people think. I write scope in bullet points, not paragraphs. "Design 3 homepage mockups" beats "Create a modern website" every single time because the second version is what gets you stuck in revision hell. Column D is deliverables. Column E is deadlines. Column F is payment milestone. Column G is notes. That's it. Twelve columns if I count the hidden ones for rate calculation and expense tracking. I used to have forty columns. It took me fourteen minutes to update it and six months to figure out why nobody was finishing their projects on time. The answer was that I was tracking too much data and not enough actual work.

My contract template lives in a separate Google Doc. One page. No legalese. It says what I'll do, when I'll do it, how much, and what happens if they disappear after I deliver. The clause I add every time now is "two rounds of revisions included." Without that line, I watched a client in 2022 ask me to rebuild their entire landing page five times because they "changed their mind about the direction." I sent them the invoice and walked away. The Freelancing Template didn't save me there—the contract did.

How I Actually Use This Between Projects

When a new lead comes in, I spend twenty minutes filling out columns A through F before I reply to their email. This isn't about being slow. It's about not accepting work that doesn't fit your current bandwidth. I once said yes to a two-week project while already sitting on three others. Two of them slipped. The client emailed me at midnight asking why the homepage wasn't ready. I replied at noon the next day. We didn't work together again. The rate column uses a simple formula: hourly rate times estimated hours. I put my floor rate in cell H1 and multiply. If the math comes out below sixty dollars per hour for design work, I either raise the price or reduce the scope. I don't negotiate my way into poverty. People tell me this sounds harsh. It worked when I needed to pay rent in March. Payment milestones follow a 50-30-20 split. Half upfront, half on delivery, twenty percent after final approval. Some clients push back on the upfront portion. They always say they've never had to do this before. Every single one of them paid late anyway. The milestone structure protects you whether they're honest or not.

The Part Nobody Talks About

Tracking revenue isn't the same as knowing if you're profitable. I missed this for eight months. My spreadsheet showed income coming in. My bank account told a different story. Once I added an expenses column—software subscriptions, stock footage licenses, the occasional paid stock photo—I realized I'd been undercharging by roughly thirty percent across the board. I adjusted my minimum rates and stopped doing free work for "exposure." Exposure doesn't pay internet bills. I also started logging revision rounds. After twelve projects, I noticed a pattern. Clients who gave vague briefs requested more revisions. The correlation was strong enough that I now ask a follow-up questionnaire before accepting any design work. It takes three extra minutes. It saves roughly four hours of back-and-forth editing per project. There are moments when this system breaks. Scope creep on long-running projects doesn't show up in a spreadsheet. I handle those by sending a change order email before starting additional work. One client in 2023 asked me to add mobile breakpoints after the desktop was already signed off. I quoted two hundred dollars for the extra work. They said no and hired someone else. I kept the final desktop files. Nobody sued. Nobody complained. Life went on.

Where This Template Falls Short

It won't manage client relationships. It won't help you negotiate. It won't stop you from saying yes to bad projects when you're desperate for cash. I've seen freelancers use a perfect system and still burn out because they treated the tool like a substitute for judgment. If you're doing collaborative work with other freelancers—say, a developer paired with a designer—the spreadsheet gets messy fast. You need a shared project management tool with permissions and status tracking. Trello, Notion, or ClickUp work better there. I use them alongside my template, not instead of it. Some industries require more than twelve columns. Agency work with retainer clients needs payment history, renewal dates, and contract end timelines. I keep a separate tab in the same Google Sheet for those accounts. It adds complexity but keeps everything in one place instead of forcing you to context-switch between three different apps.

The template itself is free. I don't sell it. I don't put it behind a paywall. I just write it down so the next person doesn't spend three months figuring out what matters. Open a new Google Sheet, add the columns I described, and start using it on your second project. By the time you finish your fifth one, you'll have added your own tweaks anyway. That's how this thing is supposed to work.