What Freelancing Workbook Modern Actually Is
It's a structured planning and tracking system built for people who juggle multiple clients, variable income, and chaotic schedules. The core idea is simple enough: consolidate your project pipelines, time tracking, invoicing, and goal tracking into one living document instead of scattering everything across ten different apps and half-filled spreadsheets. Most freelancers I talk to have some version of this already, they just never formalized it. The workbook is the formalization step. The modern iteration adds a few things the older versions skipped. Automated rolling calculations for monthly burn rates, a client health score based on payment speed and scope creep frequency, and a weekly review template that actually forces you to look at the data instead of just filing it away. You could build all of this yourself in Google Sheets or Notion, but then you'd also spend about forty hours building it and probably not do it right.
Getting Started With Your Freelancing Workbook Modern
Download the base template first. Grab it from the official GitHub repo at github.com/freelancingworkbookmodern/template. It comes in both Google Sheets and Excel formats, with the Sheets version being the one most people actually end up using because it auto-syncs across devices without any manual export work. There's a paid Pro version at workbookmodern.com/download-pro that includes the automated client dashboard and the recurring invoice generator. It's twenty-nine dollars and costs about three hours of your life to set up once. Open the file and ignore everything except the Setup tab for the first fifteen minutes. This is where you input your baseline numbers: target monthly income, fixed monthly expenses, average hourly rate, and the number of billable hours you realistically think you can squeeze out of a week. Most people blow past this section because it feels tedious, but the rest of the workbook pulls from these numbers continuously. If you put in a target of five thousand and your expenses are six thousand, the workbook will flag that immediately and highlight which months you'll need to front-load invoices for.
How The Core Modules Actually Work In Practice
The project tracker is the heaviest module. Each row represents a current or past engagement. Columns track client name, project phase, start date, expected completion, actual completion, rate, hours logged, invoice status, and payment received. The phase column uses a dropdown with standard milestones: Discovery, Brief, Draft, Review, Revision, Delivery, Invoiced, Paid. This seems rigid until you realize most freelancers never finish anything on time because they never actually defined what "finished" means for a given project. Forcing a phase selection gives you an immediate read on where each job is actually sitting. The time tracker sits behind the project tracker. You enter hours in daily increments, and the workbook aggregates them by week and by project. The important detail here is that it calculates your effective hourly rate per project by dividing total revenue by total hours including unpaid revision rounds. This number almost always surprises people. A project you thought was paying fifty an hour might show up as thirty-two once you account for the four hours of Slack back-and-forth that never made it onto an invoice. The invoicing module is leaner than dedicated tools like FreshBooks or QuickBooks. It generates a PDF invoice from your logged data and sends it through Gmail using a pre-formatted template. The benefit is speed: you go from time entry to sent invoice in about two minutes. The downside is that it doesn't handle recurring billing or multi-currency work well. If you're dealing with international clients who pay in euros or process payments through platforms that take a cut, this module will create more work for you than it saves.
Get the Full Details
I ran into this exact problem last spring. I had three European clients whose invoices were getting stuck in translation between the workbook's output format and Stripe's currency handling. The workbook spat out dollar amounts with no built-in FX conversion, so I kept underbidding on the spread. My workaround was to add a separate tab with current exchange rates pulled via a simple importrange formula tied to a live finance API, then flag any invoice over five hundred dollars for manual rate verification before sending. Added twenty minutes per invoice but saved me roughly four hundred dollars over the quarter.
The Financial Dashboard And What It Misses
The dashboard tab is what most people look at first and what actually earns its keep. It shows monthly revenue trends, year-to-date totals, net profit after expenses, and a visual breakdown of income by client. The client concentration risk indicator is the most useful feature here. If any single client accounts for more than thirty percent of your annual revenue, the dashboard turns that section amber. Red flags it at forty percent. This isn't theoretical advice from a productivity blog. I've seen three separate freelancers lose half their income in a single month when their biggest client quietly switched vendors, and in every case they would have seen it coming if they had a clear visual cue like that. The tax estimation module pulls from your net profit figures and applies a default tax rate based on your country code. This is where the workbook shows its limitations clearly. It uses flat estimates, not actual bracket calculations. If you're self-employed in the US, that means it won't account for the QBI deduction or schedule SE complexities. It's close enough for quarterly estimated tax planning but useless if you're trying to do your actual year-end filing. I recommend running the workbook numbers through a proper tax preparation tool or consulting a CPA before filing. The workbook tells you what you made. It doesn't tell you what you owe with legal accuracy. There's also no built-in expense receipt scanning. You enter expenses manually, which is fine if you spend less than an hour a month on bookkeeping admin. Once you start tracking material purchases, software subscriptions, home office utilities, and business travel, the manual entry becomes a real friction point. Several power users have built their own receipt-import scripts using Zapier connectors, but that requires a level of technical comfort most casual users don't have. If you know you're going to hit that complexity ceiling, you might be better off starting with a dedicated tool like Wave or Expensify and only importing the summary data into the workbook for overview purposes.
Setting Up Your First Weekly Review Loop
The workbook includes a Friday review template on its own tab. It asks twelve questions: how many billable hours you logged, how many non-billable hours ate into the week, which projects are behind schedule, which clients are slow to pay, what your cash position looks like heading into next week, and whether your revenue target is still on track. Answering these takes about eight minutes if you've been entering data consistently throughout the week. The habit that makes this actually useful is consistency over perfection. Most people skip two weeks of reviews, then abandon the whole system because the backlog feels overwhelming. I learned this by watching a colleague of mine try to implement the workbook in late 2024. She filled out five reviews correctly, missed three weeks due to a busy season, then deleted the entire spreadsheet and went back to sticky notes. The system wasn't the problem. The all-or-nothing expectation was. Set a standing Friday afternoon block for twenty minutes. That's all. Even if you only answer three of the twelve questions that week, the data keeps compounding. The workbook's month-over-month comparisons only become meaningful after about sixty days of consistent entries. Before that threshold, you're just logging numbers without context. After that, you start seeing patterns: which months reliably dip, which client types generate the most revision rounds, whether your effective hourly rate actually improves when you raise your base rate.
When To Actually Use This And When To Walk Away
The Freelancing Workbook Modern works well for solo freelancers and very small teams handling three to eight concurrent projects. It breaks down past about ten active clients because the project tracker rows become unwieldy and the manual entry overhead starts exceeding the value of the insights. If you're running an agency with dedicated account managers and a full accounting department, this is the wrong tool. You need something with role-based access, team assignment, and integrated payment processing. The workbook will feel like filling out tax forms by hand. For new freelancers just starting out with one or two clients, it's also overkill. You don't need a client concentration risk dashboard when you don't have enough clients to concentrate. A simple spreadsheet with project names and invoice dates will serve you better for the first six to twelve months. The workbook's real value kicks in once your schedule gets complicated enough that you're losing track of which deliverables are pending and which invoices are outstanding. That's usually around the three-to-five-client mark for most people. The file itself is lightweight and stays under two megabytes even after a year of entries. It doesn't collect usage data or require an account. Your information stays local unless you explicitly choose to share it. There's no subscription trap, no feature gating that locks your historical data behind a paywall after the trial period. The free version is genuinely usable. The Pro version at twenty-nine dollars is a one-time purchase, not a monthly fee, which is rare enough that I'm noting it separately.
If you decide the workbook isn't working for you after a few months, exporting your data is straightforward. Everything lives in standard CSV-compatible columns, so you can move your client list, financial history, and project timelines into any other system without losing a single row. That's something most subscription-based tools won't let you do, and it matters more than it sounds when you've got two years of financial records accumulated.
