Monthly Graphic Design Business Cheat Sheet

Tracking the actual money instead of pretending

I used to run my design business on a spreadsheet that was basically just a list of invoices and a lot of hopeful thinking. It worked fine until it didn't. One month I had six projects in flight, three clients who paid late, and no idea what my real profit margin was after software subscriptions, stock assets, and the hour I spent chasing a payment that turned out to be a dispute over scope creep. I lost about $2,400 that month without realizing it until the bank account told me. That's when I built a Monthly Graphic Design Business Cheat Sheet. Not a fancy dashboard. Just a single working document that forced me to look at the numbers before I got distracted by the next project. It took me about three hours to set up properly and maybe twenty minutes each month to run through it after that.

Monthly Graphic Design Business Cheat Sheet

The structure is simple enough that it could be done in plain text, but I use a basic table layout because it forces you to separate revenue from expenses and then subtract the things that always get forgotten. Here's the skeleton. Revenue column — actual cash received this month, not invoiced. This distinction matters more than people admit. You can invoice for $8,000 and still only have $3,200 in the bank if three clients pay on net-45 terms and one ghosts you entirely. I track what actually landed. Invoiced revenue goes in a separate row because it's a promise, not money. Direct project costs. Stock photography, font licenses, premium plugin purchases, outsourcing payments to other designers or illustrators, print proofs, expedited shipping for physical deliverables. These are usually 8 to 18 percent of project revenue but they vanish from your mental picture if you don't write them down immediately. A client once asked me why my quote on a brand identity package jumped from $4,500 to $5,100. The extra $600 was a type foundry license I hadn't accounted for because I was pricing off memory instead of receipts. I was absorbing that cost for six months before I caught it.

Overhead allocated per month. Adobe CC, Figma Pro, project management tools, cloud storage, accounting software, your business insurance premium divided by twelve, the percentage of your home office space that's actually your studio. Most designers skip this or lump it into a vague "expenses" bucket. I allocate it monthly because it changes the picture. A $2,400 annual software bundle is $200 a month. That's $2,400 you need to earn back before you're actually profitable. Self-employment tax estimate. I set aside 25 to 30 percent of net income here. Not because the IRS is going to surprise me, but because I learned the hard way that not setting it aside means January is a panic month. This is the part that makes the cheat sheet feel less like a productivity hack and more like damage control. Profit calculation. Revenue minus direct costs minus overhead minus tax reserve equals what you actually keep. If the number is negative, you know immediately. If it's positive but lower than you expected, you also know immediately instead of finding out three months later when you're trying to pay a vendor.

I ran this system for about fourteen months straight. The first month felt tedious. By month four it took me about twelve minutes. By month eight I could look at the bottom line and instantly know whether I could say yes to a new project or whether I needed to slow down. There are limitations worth acknowledging. This method works well for solo practitioners and small teams up to maybe five people. Once you have multiple designers on different projects with different billable rates and split revenue agreements, the single-sheet approach breaks down and you need something more structured like a proper project accounting system. Also, the cheat sheet doesn't help with cash flow timing problems. If your clients consistently pay late and you have fixed monthly obligations, knowing your profit margin doesn't solve the fact that you can't make payroll on the fifteenth. That requires a separate cash flow buffer, which is why I keep a minimum of thirty days of overhead sitting in a separate account regardless of what the cheat sheet says. One thing beginners consistently mess up is mixing personal expenses into the direct project costs column. A coffee subscription isn't a project cost. Your gym membership isn't either. But a domain renewal for a client's project is. The line feels arbitrary until you've reviewed this with an accountant and realized you wrote off $3,000 in things that weren't deductible. I stopped guessing after that.

If you want the actual file I used, it's a Google Sheets template. I don't host it anywhere formal. I'll share the structure directly so you can rebuild it yourself in whatever tool you already use. Create these sections at the top: total cash received, total invoiced but unpaid, direct project costs, allocated overhead, tax reserve, and net profit. Below that add a project-by-project breakdown showing revenue per project, direct costs per project, and project margin percentage. The margin column is where you spot the clients who look profitable on the surface but actually eat into your time and resources without compensating return. I found that projects quoted at $2,000 were sometimes running at 12 percent margin while a $800 quick job was clearing 67 percent because it required almost no revision rounds and the client had clear direction from the start. The cheat sheet made that visible. Before that I was chasing bigger numbers and ignoring the efficiency signal.

You can set this up in an afternoon. The real value shows up around month three when you start noticing patterns — which seasons are profitable, which types of projects consistently underperform, which clients drain your margin even when they pay on time. That pattern recognition is what turns a tracking document into something that actually changes your business decisions instead of just recording them.