DEV Community: Alex Lin

How to Set Up a Simple Bookkeeping System for Your Freelance Business

Alex Lin — Thu, 12 Nov 2026 13:09:17 +0000

How to Set Up a Simple Bookkeeping System for Your Freelance Business

Most freelancers don't have a bookkeeping problem. They have a "where did the money go" problem — income lands in one account, expenses leak out of another, and by tax time the whole year is a pile of bank statements and guesswork.

A bookkeeping system doesn't need to be complicated. It needs to answer three questions at any moment: how much came in, how much went out, and how much is actually mine to spend. Here is the setup I use, built in one afternoon and maintained in about 30 minutes a week in the sample below.

1. Give every dollar a bucket the moment it arrives

Freelance income is not salary. No one withholds tax, no one sets aside savings, and the number that hits your account is not the number you can spend. So the first rule: split income the day it arrives, before you spend any of it.

I use five buckets: tax set-aside, business expenses, savings, personal spending, and a small buffer for slow months. In the sample month I use here — $3,200 of income — that looks like $480 to tax (15%), $320 to business expenses, $320 to savings, and the rest split between personal spending and the buffer. The exact percentages matter less than the habit: money that is never split is money that gets spent twice.

Do this in a budget planner, not in your head. One row per payment received, one column per bucket, and the split happens automatically.

2. Log expenses the same day, or they disappear

The expenses that hurt freelancers are rarely the big ones. They're the $9 subscription, the $14 font license, the $22 domain renewal — small, forgettable, and tax-deductible only if you can prove them.

The rule is simple: if it takes more than two minutes to log, you won't do it. So keep one expense tracker with four columns — date, what it was, how much, and which client or project it belongs to — and fill it in the same day. In the sample month, the tracker caught $96 of subscription spend I had forgotten about; cancelling two unused ones cut it to $61. That's $35 a month found by a two-minute habit.

Receipts go in one folder, physical or digital. A deduction without a record is a deduction you can't defend.

3. Track invoices like money owed, not money earned

An invoice is not income until it's paid. Freelancers who count invoiced work as earned money spend money they don't have yet — and then chase clients from a position of panic instead of routine.

Keep one invoice tracker: client, invoice number, amount, date sent, due date, and status. In the sample month: 4 invoices sent, 3 paid on time, 1 overdue by 12 days — visible at a glance instead of discovered at the end of the month. Send the reminder on the due date, not two weeks later. A short note with the invoice number and amount is enough; most late payments are forgetfulness, not refusal.

Your books should show two numbers side by side: invoiced and received. The gap between them is the only cash-flow number that matters.

4. Keep one client list with rates, not five scattered notes

Every freelancer has a client whose rate they can't quite remember, or a project whose scope crept past the quote. That confusion costs money — usually in the form of undercharging a returning client.

One client tracker solves it: name, contact, agreed rate, payment terms, and a note on the last job. When a client comes back, you open one row instead of searching old emails. When it's time to raise your rates, you can see exactly who pays what and who hasn't had an increase in a year.

This is also where scope creep gets caught. If the note says "10 hours, $750" and the work is at 16 hours, you know before the invoice goes out — not after.

5. Reconcile once a week, in 30 minutes

Reconciliation sounds like accounting. In practice it means: open your bank statement, check every line against your income and expense logs, and fix anything that doesn't match. In the sample week it takes about 30 minutes, usually less.

What you're looking for: payments received that never got logged, subscriptions you forgot to cancel, a client who paid a different amount than invoiced, and expenses that belong to the wrong month. Catch these weekly and they're five-minute fixes. Catch them in April and they're a weekend of archaeology.

Pick a fixed time — Friday afternoon works well — and treat it like a client meeting. It doesn't move.

6. Close the month in one page

At the end of each month, write one page: income received, expenses paid, tax set aside, invoices still outstanding, and the buffer balance. Five numbers, one page, ten minutes.

That page is the whole point of the system. It tells you whether the month was actually profitable, whether the slow season is coming, and whether your rates still make sense. A freelancer who closes the month knows their business. A freelancer who doesn't is guessing — and guessing is how you end up working more and keeping less.

Keep the twelve monthly pages together. At year end, you already have your tax numbers, your income total, and your deductible expenses — no reconstruction required.

The one-afternoon setup

Here is the order, if you do it today: set up the five money buckets, build the expense tracker, build the invoice tracker, build the client list, then schedule the weekly 30-minute reconciliation. In the sample run, the setup took one afternoon and the weekly habit takes about 30 minutes.

You don't need accounting software for this. A spreadsheet is enough — the system is the valuable part, not the tool. The tools I use are the same spreadsheets I sell: a budget planner for the buckets, an expense tracker for the daily logging, an invoice tracker for the money owed, and a client tracker for the rates. But any spreadsheet works, as long as all four pieces live in one place and get used every week.

Alex Lin — fishdp@proton.me. I build small tools and spreadsheet templates that save you time: https://payhip.com/AlexLin

Freelancer Budget Planner ($14): https://payhip.com/b/Es7B5
Freelancer Expense Tracker ($10): https://payhip.com/b/gKnm7
Freelancer Invoice Tracker ($10): https://payhip.com/b/VkExQ
Freelancer Client Tracker ($10): https://payhip.com/b/coiFO

Freelancer Year-End Money Checklist: 7 Things to Do Before December 31

Alex Lin — Thu, 12 Nov 2026 12:04:33 +0000

Freelancer Year-End Money Checklist: 7 Things to Do Before December 31

December is the one month when a freelancer's money habits pay off twice: once in the tax bill, and once in the clean start to January. The work is not glamorous — it's invoices, receipts, and a spreadsheet — but an afternoon spent now is worth a frantic week in April.

Here is the checklist I run every year, in order. It takes about two hours in the sample run below, and every item either saves money or prevents a headache.

1. Chase every unpaid invoice now, not in January

Open your invoice tracker and list everything still unpaid. In the sample year I use here, that was 3 invoices totalling $2,400 — money already earned, just not yet collected.

Send a polite reminder before the holidays, while your clients are still at their desks and still have this year's budget. A short note works: the invoice number, the amount, the original due date, and a simple "could you confirm this is scheduled?" Clients pay faster in December than in January, because January brings their own year-end chaos.

Rule: no invoice older than 30 days should roll into the new year without a reminder sent.

2. Estimate your tax bill before the year ends

Freelancers don't get tax withheld, so December is your last chance to know the number instead of guessing at it in April. Add up the year's income, subtract deductible expenses, and apply your tax rate to what's left.

In the sample: $52,000 of income, $7,800 set aside for tax at a 15% effective rate. If the estimate is bigger than what you've set aside, you still have time to top up the savings — or to make a legitimate deductible purchase before December 31 that lowers the bill.

The mistake is waiting until tax season to do this math. By then the number is a surprise, and surprises cost money.

3. Sweep December for deductible expenses you forgot

Business expenses hide in December: the software renewal that auto-charged, the domain registration, the home-office supplies, the mileage to a client meeting. Go through bank and card statements for the last month and tag anything business-related.

In the sample sweep, that surfaced $1,150 of deductible expenses that had never been logged — mostly small subscriptions and one annual renewal. At a 15% effective rate, that's real money back.

Keep the receipts. A deduction without a record is a deduction you can't defend.

4. Reconcile your books so January starts clean

Match every payment received against an invoice, every expense against a receipt. If something doesn't match, find out why now — a missing payment, a double-charged subscription, a client who paid a different amount than invoiced.

The goal is a December 31 balance you trust. If your books close clean, January starts with real numbers instead of a mystery you keep postponing. Two hours of reconciliation in December replaces ten hours of archaeology in April.

5. Check your savings goals before the year resets

Did the year's savings actually happen? Compare what you planned to set aside against what you actually saved — tax set-aside, emergency fund, and any goal you were funding.

If the emergency fund is short, December is the time to say so honestly and set a realistic monthly target for next year, rather than carrying a fantasy number forward. A savings goal you can actually hit beats an ambitious one you quietly abandon by February.

6. Set next year's rates and budget on real numbers

December is the best time to raise your rates, because you have the year's data in front of you: total income, total hours, effective hourly rate, and the months where money was tight. If the numbers say you're undercharging, set the new rate now and tell existing clients before January.

Build next year's budget from this year's actuals, not from optimism. A budget built on the real average month — including the slow ones — is a budget you can keep.

7. Back up everything, then close the books

Export your invoices, your expense records, your bank statements, and your tax estimate. Keep a copy somewhere that isn't the same laptop that holds the only copy. Then mark the year closed.

Closing the books is a psychological trick as much as an administrative one: it tells you the year is done, the numbers are known, and January is a fresh start instead of a continuation of the mess.

The two-hour version

If you only have one afternoon, do the items in this order: chase unpaid invoices, estimate the tax bill, sweep December expenses, reconcile, check savings, set next year's rates, back up and close. In the sample run, that took about two hours — and it turned a year of scattered records into a number you can act on.

The tools I use for this are the same spreadsheets I sell: a tax estimator for item 2, an expense tracker for items 3 and 4, an invoice tracker for item 1, a budget planner for item 6, and a savings goal tracker for item 5. You can do all of it with any spreadsheet — the checklist is the valuable part, not the tool.

Alex Lin — fishdp@proton.me. I build small tools and spreadsheet templates that save you time: https://payhip.com/AlexLin

Freelancer Tax Estimator ($12): https://payhip.com/b/LeRno
Freelancer Budget Planner ($14): https://payhip.com/b/Es7B5
Freelancer Expense Tracker ($10): https://payhip.com/b/gKnm7
Freelancer Invoice Tracker ($10): https://payhip.com/b/VkExQ
Savings Goal Tracker ($10): https://payhip.com/b/owFg1

Stop Fighting Messy Pasted Text: Clean It Before It Hits Your Code

Alex Lin — Thu, 12 Nov 2026 11:03:29 +0000

Stop Fighting Messy Pasted Text: Clean It Before It Hits Your Code

Every developer has lived this bug: you copy a snippet from a chat message, a doc, or a web page, paste it into your editor, and something breaks. The code looks identical. The error message insists it isn't. You stare at two lines that appear to be the same string, and one of them is lying.

The lie is the paste. Text that travels through rich-text apps picks up invisible baggage — smart quotes, non-breaking spaces, doubled line breaks, zero-width characters — and your editor pastes all of it faithfully. The fix is not to squint harder. The fix is to clean the text before it ever reaches your code.

1. Smart quotes are the classic trap

Word processors and chat apps love turning straight quotes into curly ones. "hello" becomes "hello". In prose, that's typography. In code, it's a syntax error — or worse, a string that looks right and silently isn't.

The same goes for apostrophes in SQL, em dashes where a hyphen should be, and ellipses where three dots were expected. None of these show up in a quick visual scan. They only show up when the build fails, the query returns nothing, or the test turns red for no visible reason.

Rule of thumb: if text came from anywhere with formatting — a doc, an email, a chat app, a web page — treat it as dirty until proven clean.

2. Invisible characters are worse than wrong ones

A wrong character at least shows up. An invisible one doesn't. The worst offenders:

Non-breaking spaces (U+00A0): look exactly like a normal space, break tokenizers, and survive most find-and-replace passes because you're searching for the wrong character.
Zero-width spaces (U+200B): completely invisible, commonly inserted by web pages and chat apps, and happy to sit inside identifiers.
Mixed line endings: a paste that mixes CRLF and LF can confuse diff tools and linters into flagging every line.
Double spaces and trailing whitespace: harmless-looking, but they make diffs noisy and break exact-match comparisons.

In one sample paste of about 200 lines from a chat thread, a cleaning pass fixed 47 smart quotes, removed 12 non-breaking spaces, and normalized the line endings — and the snippet that had failed three times finally ran. The code was never wrong. The paste was.

3. The ten-second habit that prevents all of it

You don't need a new workflow. You need one step between copy and paste:

Paste the text into a cleaner first.
Let it normalize quotes, strip invisible characters, collapse double spaces, and unify line breaks.
Copy the clean result into your editor.

Ten seconds, done once, saves the three minutes you would have spent hunting a phantom bug — and the twenty minutes you'd spend explaining to a teammate why the code "works on my machine" but not in the snippet they pasted.

The habit compounds: once you clean before pasting, you stop distrusting pasted code, and you stop rewriting snippets by hand just to be safe.

4. Markdown has the same disease

Docs, READMEs, and blog posts suffer the same way. Paste a draft from a word processor into a Markdown file and you get smart quotes in code blocks, non-breaking spaces in tables, and line breaks that render as one giant paragraph or twelve tiny ones.

Cleaning the text first means the Markdown you write is the Markdown that renders. Headings stay headings, tables keep their columns, and code fences contain actual code instead of typographic lookalikes. If you publish docs or write for Dev.to, this is the difference between a post that looks professional and one that looks like it was fought with.

5. What a good cleaner actually does

A text cleaner is not a formatter and not an editor. It does a small, specific job:

Converts smart quotes and apostrophes back to straight ASCII.
Replaces non-breaking spaces and other invisible characters with normal ones.
Collapses repeated spaces and blank lines without touching intentional indentation.
Normalizes line endings to one style.
Leaves your actual content alone — no rewording, no reformatting, no surprises.

The point is predictability: what you paste is exactly what you see, byte for byte. Anything fancier is a different tool.

6. The free tool and the $9 tool

I built two small tools for exactly this, because I kept hitting the same bug myself:

CleanPaste (free, no install): paste text in, get clean text out. It runs entirely in your browser — nothing is uploaded, nothing is stored. Use it at https://alexlinexcel.github.io/cleanpaste/ whenever a paste looks suspicious. It handles the quotes, the invisible characters, the double spaces, and the line endings in one click, and you can download the result as a .txt file.
CleanMarkdown ($9): the same cleaning, built for people who live in Markdown — writers, doc maintainers, anyone turning messy drafts into clean posts. It takes pasted text and returns tidy Markdown, ready to publish. Find it at https://payhip.com/b/oPS2n.

Start with the free one. If you paste text into code, docs, or chats more than a few times a day, the habit alone is worth more than either tool — but the tools make the habit effortless.

Alex Lin — fishdp@proton.me. I build small tools and spreadsheet templates that save you time: https://payhip.com/AlexLin

CleanPaste (free, no install): https://alexlinexcel.github.io/cleanpaste/
CleanMarkdown ($9): https://payhip.com/b/oPS2n

The 5 Spreadsheets Every Freelancer Needs to Run Their Business

Alex Lin — Thu, 12 Nov 2026 10:01:29 +0000

The 5 Spreadsheets Every Freelancer Needs to Run Their Business

Freelancing has two jobs: the work clients pay for, and the business around it. Most freelancers are good at the first one and run the second one on memory, scattered notes, and a bank app they check with one eye closed. That works until the first slow month, the first late payment, or the first tax bill that arrives bigger than expected.

You don't need accounting software to fix this. You need five simple spreadsheets, each doing one job, kept up to date. Here they are, in the order that matters.

1. A budget planner: know what the month has to earn

Everything starts here. A budget planner answers one question: how much money has to come in before the month is safe?

List every cost — rent, food, software, insurance, tax set-aside, and a buffer for slow months. In this sample, the freelancer needs $4,800 a month to cover everything, including tax. Divide that by realistic billable hours — about 110 a month once admin, quotes, and chasing invoices are accounted for — and you get a break-even rate of about $44 an hour. Anything below that and the month quietly goes backwards, no matter how busy it feels.

The planner also holds the two things a budget alone can't: a paycheck plan that spreads irregular income across the month, and a savings goal so the good months actually fund the slow ones. Update it once a week, not once a quarter. A budget you look at weekly is a tool; a budget you look at at tax time is an autopsy.

2. A time tracker: stop working for free

If you don't track hours, you bill from memory, and memory is generous to clients and cruel to you. The sample freelancer bills $75 an hour; a week of 27.5 billable hours is $2,062.50. But the same week usually hides about 3.5 hours of work that never gets logged — small fixes, quick calls, "just one more thing" — worth $262.50 that simply never gets invoiced.

A time tracker fixes this with one habit: log hours the same day, never from memory. One row per task, one column for billable vs. non-billable, and a weekly total that shows your utilization rate. When the non-billable share creeps up, you can see it in numbers instead of feeling it as vague exhaustion. Track the hours and the money follows; guess the hours and the money leaks.

3. An invoice tracker: get paid on time

Sending the invoice is not the same as getting paid. An invoice tracker is the sheet that makes sure the money actually arrives.

Every invoice gets a row: client, amount, date sent, due date, and status. The rule that makes it work is the follow-up rhythm — a friendly reminder on day 7, a firmer one on day 14, and a pause on further work on day 30. In the sample, a 20-hour project at $75 an hour bills $1,500; with a 50% deposit upfront, $750 is already in hand before the work starts, and the remaining $750 has a due date and a reminder attached to it.

Add a late fee of 1.5% a month, stated on the invoice before the work starts. Most clients never trigger it. The ones who do pay faster the second time, because the cost of being late is now visible instead of free.

4. An expense tracker: keep every deductible dollar

Freelancers pay tax on profit, not revenue — and the gap between the two is every business expense you bothered to record. Software subscriptions, a new laptop, mileage, the coworking day pass: if it's not in the sheet, it doesn't exist when tax day comes.

An expense tracker needs four columns to be useful: date, what it was, how much, and which category. The fifth column is the one people skip and later regret: whether it's tax-deductible. A $50-a-month tool is $600 a year; at a 25% tax rate, recording it properly is worth about $150 back. Multiply that across every subscription and receipt, and the sheet pays for itself many times over.

The discipline is simple: log expenses the day they happen. A receipt in your pocket is an expense; a receipt you can't find in April is a donation to the tax office.

5. A client tracker: remember who owes what

The fifth sheet is the one that ties the other four together. A client tracker holds, for each client: their rate, what you've billed, what they've paid, what they still owe, and when you last heard from them.

This is where the numbers from the other sheets land. The time tracker says how many hours a client used; the invoice tracker says what's outstanding; the client tracker says whether that client is worth keeping. A client paying $75 an hour who always pays on day 30 is a different business decision from a client paying the same rate who pays on day 3. Same rate, very different cash flow — and only the tracker shows you the difference.

It also stops the awkward moments: quoting a returning client a rate you already raised, or forgetting that a "quick favor" for one client is now eating ten hours a month. The sheet remembers so you don't have to.

How the five fit together

The system is a loop, not a pile. The budget planner sets the monthly target ($4,800 in the sample). The time tracker records the hours that earn it. The invoice tracker turns hours into money owed. The expense tracker keeps the costs honest. The client tracker tells you which relationships are actually carrying the business.

Run the loop weekly: fifteen minutes on a Friday to log hours, send invoices, record expenses, and check who still owes you. That's the whole system. No software to learn, no monthly fee, no dashboard you need a course to understand. Five sheets, one habit, and a business you can actually see.

If you'd rather start from finished templates than build them yourself, here are the five I use and sell:

Or browse the full shop: https://payhip.com/AlexLin

Alex Lin — fishdp@proton.me

How to Price Your Freelance Services (Without Guessing or Undercharging)

Alex Lin — Thu, 12 Nov 2026 08:00:53 +0000

How to Price Your Freelance Services (Without Guessing or Undercharging)

Most freelancers set their first rate by copying someone else's number, then never touch it again. The result is predictable: busy weeks, thin months, and a quiet feeling that the work pays less than the job it replaced. Pricing isn't a talent. It's arithmetic plus one honest conversation with the client. This guide does the arithmetic first, then the conversation.

1. Find your break-even rate before you quote anything

A rate that feels fair means nothing until you know the number below which you lose money. Work it out once a year and write it down:

Monthly costs first. Rent, food, software, insurance, tax set-aside, and a buffer for slow months. In this sample, the freelancer needs $4,800 a month to cover everything, including tax.
Realistic billable hours, not fantasy hours. A 40-hour week is not 40 billable hours. Admin, quotes, chasing invoices, and learning all eat into it. In this sample, about 110 billable hours a month is realistic — roughly 27 a week.
Do the division. $4,800 divided by 110 billable hours is about $44 an hour just to break even. Anything below $44 and the month quietly goes backwards, no matter how busy it feels.

The sample rate of $75 an hour leaves real margin above that $44 floor. The gap between the two numbers is the whole point of the exercise: it is the difference between surviving and actually getting ahead.

2. Pick a pricing model that fits the job, not the other way round

There are three honest ways to charge, and each one fits a different kind of work:

Hourly — best when the scope is fuzzy. The client doesn't know exactly what they want yet, or the work will change as it goes. You get paid for every hour, and the client pays for the uncertainty. In the sample, a 20-hour project at $75 an hour bills $1,500.

Fixed project price — best when the scope is clear. The client knows the deliverable and you know how long it takes. Price it from your hourly rate times your estimated hours, then add 15–20% for the risk you're absorbing. A 20-hour project becomes $1,500 plus a buffer — about $1,750 — because you're the one carrying the overrun risk now.

Value-based — best when the work makes the client real money. A sales page, a pricing model, a dashboard that saves a team ten hours a week. Here the price follows the outcome, not your hours. This is the hardest model to sell and the most profitable once you can. Start with hourly and fixed, and move here when you have results to point at.

Pick one per project and say it out loud in the quote. A client who hears "fixed price, $1,750, delivered in 5 days" can say yes. A client who hears "it depends" cannot.

3. Quote the project, not the hour

Clients don't buy hours. They buy the finished thing and the feeling that the price is fair. So frame every quote around the outcome:

Name the deliverable first. "A cleaned customer workbook, deduplicated and CRM-ready, delivered in 3 days" — then the price.
Give two options, not one. A basic scope at $1,200 and a fuller scope at $1,750 lets the client choose instead of haggling. Most pick the fuller one, and the ones who pick basic have still said yes.
Put the number in writing before you start. Email beats a chat message. It stops the "I thought it included that" conversation before it starts.

In the sample, the same 20 hours of work is $1,500 hourly or about $1,750 fixed. The fixed price is higher because the client is buying certainty, and certainty is worth paying for. If you only ever quote hourly, you are giving that certainty away for free.

4. Raise your rate on a schedule, not on a feeling

Rates go stale quietly. If you haven't raised yours in a year, you have taken a pay cut — costs went up, the rate didn't. Build the raise into the calendar:

New clients first. Every new client gets the new rate. No awkward conversation, no existing relationship to renegotiate.
Existing clients get notice, not a surprise. "From March, my rate moves from $65 to $75 an hour. Here's what that covers." Thirty days' notice, one sentence of reason, no apology tour.
Small steps beat big jumps. 10–15% a year is normal and rarely loses a client. A 50% jump after two silent years does.

In the sample, moving from $65 to $75 an hour on the same 110 billable hours a month adds $1,100 a month — $13,200 a year — for the same work. The clients who leave over a 15% raise were the ones most likely to haggle over every invoice anyway.

5. Handle "that's too expensive" without dropping your price

Every freelancer hears it. The wrong move is to cut the price on the spot. The right move is to find out what "too expensive" actually means:

Ask what they expected. Often the gap is smaller than the objection sounds — $1,750 against a $1,500 budget is a scope conversation, not a rejection.
Trim scope, not rate. "I can do the core dashboard for $1,200 and leave the extra reports for later." Same rate, smaller job, client keeps their budget.
Offer a smaller first step. A paid sample — one cleaned workbook, one page of the dashboard — lets the client check your quality before committing to the full price. It works because it removes risk, not because it cuts your rate.
Let some walk away. A client who only hires the cheapest option will be the client who disputes the invoice. Saying no to them is how you keep room for the ones who pay properly.

Your rate is not a negotiation starting point. It's the number the arithmetic gave you, and the arithmetic doesn't care how confident the client sounds.

6. Track what you actually earned per hour

The rate on the invoice is not the rate you earned. The honest number is money invoiced divided by all hours worked, including the non-billable ones. In the sample week, $2,062.50 invoiced over 34 total hours is about $61 an hour — not the $75 on the invoice. That gap is admin, quotes, and chasing payments, and it only shrinks when you track it.

Once a month, check four numbers:

Break-even rate — about $44 an hour in the sample. If your working rate drifts toward it, raise the rate or cut the costs.
Utilization — billable hours divided by total hours. Under 60% for weeks on end means admin is eating the business.
Effective hourly rate — money in divided by all hours out. This is the number that has to cover your costs.
Unbilled hours — hours worked that never made it onto an invoice. When this hits zero for a month, the system is working.

Five minutes a month. If the effective rate holds above break-even with margin to spare, the pricing works. If it slides, you know it the same month — not when the rent is due.

If you'd rather start from a working file than a blank grid, I sell the exact trackers I described here:

Freelancer Time Tracker — https://payhip.com/b/0bijT
Freelancer Invoice Tracker — https://payhip.com/b/VkExQ
Freelancer Client Tracker — https://payhip.com/b/coiFO
Freelancer Budget Planner — https://payhip.com/b/Es7B5

Either way, the rule is simple: work out the break-even number once, price from it instead of from a feeling, and raise the rate on a schedule. The hours you're selling below break-even are the hours you're paying the client to work for them — and in this sample, that's $31 an hour, every hour.

Alex Lin builds spreadsheet tools for freelancers. Questions or a workbook that doesn't fit your situation — fishdp@proton.me.

How to Track Billable Hours as a Freelancer (and Actually Get Paid for Them)

Alex Lin — Thu, 12 Nov 2026 07:03:24 +0000

How to Track Billable Hours as a Freelancer (and Actually Get Paid for Them)

Most freelancers don't have an income problem — they have a leakage problem. The work gets done, the hours blur together, and by Friday you can only remember about 80% of what you actually did. The missing 20% is money you earned and never billed. The fix isn't working more hours. It's writing the hours down while they're still fresh, and having a system that turns them into an invoice without a second round of detective work.

1. Billable vs. non-billable: sort every hour into one of two buckets

Before you track anything, decide what counts. There are only two buckets, and every hour goes in one of them:

Billable — the client pays for this. Client work, revisions the client asked for, meetings the client requested, research for a specific client project. In this sample week that's 27.5 hours: Client A 12.5 h, Client B 9 h, Client C 6 h.

Non-billable — the business pays for this. Admin, quotes, chasing late invoices, learning a new tool, your own marketing. In this sample week that's 6.5 hours.

The point of the split is the ratio. Billable hours divided by total hours is your utilization: 27.5 out of 34 hours is about 81%. If your utilization sits under 60% for more than a couple of weeks, you're either undercharging or spending too much of your week on work nobody pays for. You can't see that ratio at all if you only track the hours you remember to invoice.

2. Log hours the day you work them — never from memory

The whole system stands or falls on one rule: the log happens the same day, before you close the laptop. A Friday reconstruction from memory is where the leakage lives. In this sample week, reconstructing from memory recovered 24 of the 27.5 billable hours — the missing 3.5 hours were two short client calls and a round of small fixes that felt too small to write down. At $75 an hour, that's $262.50 unbilled in a single week. Over a year, that's the difference between a comfortable month and a tight one.

Keep the entry stupidly simple — four fields and nothing else:

Date and client — which day, whose project.
What you did, in one line — "Client A: revised homepage mockups" beats a paragraph.
Start and end, or just the total — 1.5 h is enough; stopwatch precision is not the goal.
Billable or not — one tick box decides which bucket it lands in.

That's it. If logging takes more than 30 seconds, the system is too heavy and you'll stop using it by Wednesday.

3. Price the hour before you sell it

Tracking hours is pointless if the rate is wrong. The rate is not "what feels fair" — it's your costs divided by your billable hours, with margin on top. Work it out once a year and stop guessing:

Monthly costs first. Rent, food, software, tax set-aside, a buffer for slow months. In this sample, say the freelancer needs $4,500 a month to cover everything, including tax.
Realistic billable hours, not fantasy hours. A 40-hour week is not 40 billable hours. At the sample week's utilization (81%), a 40-hour week gives about 32 billable hours, or roughly 128 a month.
Do the division. $4,500 divided by 128 billable hours is about $35 an hour just to break even. The sample rate of $75 an hour leaves real margin — and explains why a week at 27.5 billable hours bills $2,062.50 instead of barely covering costs.

If your rate is below your break-even number, no amount of careful tracking will fix the month. Run the numbers once, write the rate down, and let the tracker tell you whether the hours are actually there.

4. Turn the week's hours into an invoice in minutes, not an evening

The second place hours leak is the gap between the log and the invoice. A clean week log should become an invoice in under ten minutes:

Group by client first. Client A gets one invoice: 12.5 hours at $75, $937.50, with the one-line descriptions attached. Three clients, three invoices, no cross-contamination.
Attach the log, don't rewrite it. The same one-line entries from the tracker go on the invoice as line items. The client sees exactly what they're paying for, and you never retype anything.
Invoice on a fixed day. Every Friday, or the 1st and 15th — pick one and don't move it. In the sample week, Friday's invoices total $2,062.50 and go out the same day the work is done, while the memory is fresh and the client still remembers the calls.

The habit that pays: invoice the week you worked it. A two-week delay isn't just late cash — it's an invoice you're now writing from a log you half-remember, and the disputed line item that comes back is always the one you can't explain.

5. Watch the numbers that tell you if the week worked

Track four numbers once a week, on invoice day, and nothing else:

Billable hours — 27.5 in the sample week. Falling for two weeks running means the pipeline is thinning before the bank account shows it.
Utilization — billable divided by total hours, about 81% here. Under 60% means admin is eating the week; over 90% for long stretches means you're heading for burnout with no buffer.
Effective hourly rate — money invoiced divided by all hours worked, including non-billable. In the sample week: $2,062.50 divided by 34 total hours is about $61 an hour. That's the honest rate — the one that has to cover your costs, not the $75 on the invoice.
Unbilled hours found — the 3.5 hours the same-day log caught that memory would have lost. When this number hits zero for three weeks straight, the system is working.

Five minutes on Friday. If the billable hours are up and the effective rate holds, the week worked. If either slides, you know it the same week — not when the rent is due.

6. Build it once, then it runs itself

You can build this in a spreadsheet in an afternoon: one sheet logging date, client, task and hours; one sheet rolling the week up by client so the invoice writes itself; and a small dashboard showing billable hours, utilization and effective rate at a glance. If you'd rather start from a working file than a blank grid, I sell the exact tracker I described here:

Freelancer Time Tracker — https://payhip.com/b/0bijT
Freelancer Invoice Tracker — https://payhip.com/b/VkExQ
Freelancer Client Tracker — https://payhip.com/b/coiFO
Freelancer Budget Planner — https://payhip.com/b/Es7B5

Either way, the system is simple: log the hours the day you work them, split billable from non-billable, and invoice the week you worked it. The hours you're not tracking are the hours you're working for free — and in this sample, that's $262.50 a week.

Alex Lin builds spreadsheet tools for freelancers. Questions or a workbook that doesn't fit your situation — fishdp@proton.me.

How to Pay Off Debt on Irregular Freelance Income

Alex Lin — Thu, 12 Nov 2026 06:03:42 +0000

How to Pay Off Debt on Irregular Freelance Income

Salaried debt advice assumes a steady paycheck. Freelance income doesn't work like that: $6,000 one month, $1,200 the next, and the credit card minimum is due either way. The fix isn't earning more — it's giving every irregular payment a fixed job the moment it lands. Here's the system.

1. List every debt on one page — balance, APR, minimum

You can't attack what you can't see. One row per debt: balance, APR, minimum payment. Here's the sample I'll use through this article:

Debt	Balance	APR	Minimum
Credit card	$4,600	24.9%	$120
Personal loan	$2,100	11.5%	$80
Student loan	$8,700	5.5%	$150
Total	$15,400	—	$350

Three debts, $15,400 total, $350 a month in minimums. That last number is the floor: minimums get paid every month, no matter what the month looked like. Everything above the floor is where the payoff actually happens.

2. Pick your order: snowball or avalanche — and mean it

There are only two honest orders, and the right one is the one you'll stick to.

Snowball — smallest balance first. Attack the $2,100 personal loan first. In this sample, with $600 a month going to debt, the loan is gone in about 7 months. That's the point: an early win proves the system works, and the freed-up $80 rolls straight onto the next debt. Total time to debt-free in this sample: roughly 31 months.

Avalanche — highest APR first. Attack the $4,600 credit card first, because 24.9% is where the interest bleeds fastest. The card takes about 19 months to clear, so the first win comes much later — but in this sample the avalanche costs roughly $380 less in total interest than the snowball, and finishes only about 2 months later.

Neither is wrong. If you've quit payoff plans before, take the snowball — the 7-month win is worth more than $380. If you're disciplined and the APR gap is big, take the avalanche. The expensive mistake is switching orders halfway because a different method looked better that week. Pick one, write it down, and don't re-decide it monthly.

3. The freelancer's payment rule: a fixed cut of every invoice

A fixed $250-a-month extra payment only works if the money is there every month. With irregular income, flip it: take a fixed percentage of every payment the day it lands.

In this sample the payoff budget is $600 a month: $350 of minimums plus $250 extra. The rule that makes it real:

Every invoice payment gets split the day it arrives — tax set-aside first, then the debt cut, then spending. If the debt cut is 15% of each payment, a $2,000 month sends $300 to debt and a $800 month sends $120. The amount flexes; the habit doesn't.
Budget on your worst month, not your best. If your worst recent month was $1,500, the minimums ($350) plus rent and food must fit inside $1,500. Good months are for extra debt payments, not for upgrading your lifestyle to match the good month.
Windfall rule: half of anything above baseline goes to debt #1. A $3,000 month when your baseline is $1,500 means $750 extra to the current target debt, the same day. No "I'll do it next month" — next month is how debt survives.

This is the whole trick: minimums are a bill, the percentage cut is automatic, and windfalls attack the target debt before they can become spending.

4. What to do when a slow month hits

Slow months will happen. The plan survives them if you decide the rules before they arrive:

Minimums never pause. $350 goes out even in a $1,200 month. That is the non-negotiable floor — missing a minimum costs late fees and a credit hit, which makes the hole deeper.
The extra payment pauses, the order doesn't. In a bad month the debt cut shrinks to whatever the percentage gives you, maybe $60 instead of $250. You still pay the target debt first and the others at minimum. You do not reshuffle the order because the month was thin.
Never add new debt to smooth a slow month. A slow month paid for with the credit card is two slow months: this one, plus the one where the card bill arrives. If the month is genuinely short, cut spending or take a small job — not the card.

A plan that only works in good months isn't a plan. The version above works in a $1,200 month and a $6,000 month, because the only thing that changes is the size of the extra payment.

5. Watch the number that matters: months to zero

Track three numbers and nothing else:

Total balance — $15,400 at the start, falling every month. If it isn't falling, the minimums are only covering interest and something is wrong.
Months to debt-free — in this sample, about 31 months on the snowball, about 33 on the avalanche. Every extra payment pulls that date closer; write the date down and watch it move.
Interest paid this month — the credit card at 24.9% is the expensive one. When its balance drops, the monthly interest drops with it, and the same $600 buys more principal every month. That's the snowball inside the math.

Check them once a month, on the same day you pay the bills. Five minutes. The month you see the first debt hit zero is the month the system becomes self-evident — and it's only about 7 months away on the snowball in this sample.

6. Build it once, then it runs itself

You can build this in a spreadsheet in an afternoon: one sheet listing every debt with balance, APR and minimum; one sheet for the snowball order next to the avalanche order so you can see which saves more; and a monthly tracker showing balance, interest, payment and principal until the balance hits zero. If you'd rather start from a working file than a blank grid, I sell the exact planner I described here:

Debt Payoff Planner — https://payhip.com/b/qBMT5
Freelancer Budget Planner — https://payhip.com/b/Es7B5
Savings Goal Tracker — https://payhip.com/b/owFg1

Either way, the system is simple: minimums every month without exception, a fixed cut of every invoice to the target debt, and one order you don't re-decide. Irregular income doesn't stop you paying off debt — it just means the payment has to be a percentage, not a fixed number.

Alex Lin builds spreadsheet tools for freelancers. Questions or a workbook that doesn't fit your situation — fishdp@proton.me.

How to Get Paid on Time as a Freelancer: Invoices, Reminders, and Late Fees That Actually Work

Alex Lin — Thu, 12 Nov 2026 04:38:50 +0000

How to Get Paid on Time as a Freelancer: Invoices, Reminders, and Late Fees That Actually Work

The fastest way to go broke as a freelancer isn't low rates. It's unpaid invoices. A client who pays 45 days late costs you exactly as much as a client who haggles your rate down — except the late payer also steals your time chasing them. Getting paid on time is a system, not a personality trait. Here's the one I use.

1. Invoice the day the work is done, not the end of the month

Every day between delivery and invoicing is a day the client forgets what they bought. Send the invoice the same day you deliver, while the value is fresh in their mind.

A good invoice needs exactly seven things — nothing more:

Your name, email, and payment details
The client's name and company
A unique invoice number (INV-2026-001, then count up)
Date issued and date due
A one-line description of the work, with the agreed rate
The total, with tax if applicable
How to pay (bank transfer, PayPal, or card link — one click, no instructions to follow)

If a client has to email you to ask how to pay, you built the friction yourself. The payment link goes on the invoice, not in a follow-up message.

2. Set payment terms before the work starts, in writing

"Net 30" means nothing if it was never agreed. Before you start, put these four lines in your quote or contract:

Payment due 14 days after invoice (or 7, if your clients accept it — shorter terms are normal for freelancers, not rude)
A late fee of 1.5% per month on overdue balances, or a flat $25 fee — pick one and state it
Work pauses if an invoice is more than 30 days overdue
A 50% deposit upfront for new clients, or for any project over $500

Clients who balk at a deposit are telling you something. Listen the first time — it is cheaper than chasing an invoice for three months.

3. Track every invoice like it's cash in the bank — because it is

An invoice you forgot about is money you gave away. Keep one log with a row per invoice: client, date sent, amount, due date, date paid, and days overdue. Then check it on a fixed schedule — this takes five minutes and it is the highest-paid five minutes of your week.

My rhythm:

Day 0: invoice sent, logged the same day.
Day 7 (if unpaid): short, friendly reminder — "Just checking this landed okay. Due on [date]." Most late payments are a lost email, not a refusal. This one email recovers most of them.
Day 14 (due date): second reminder, same tone, with the payment link again. Make paying easier than ignoring you.
Day 21: firm note — mention the late fee from your terms, give a new date 7 days out, and pause new work until this clears.
Day 30+: final notice, then stop work entirely. No new deliverables for a client with a 30-day-overdue invoice. Ever.

The key is that none of this is personal. You are not "being pushy." You are running the billing half of your business, and the reminders are just the system doing its job.

4. Three mistakes that keep freelancers unpaid

Mistake 1: No invoice log. If your invoices live in your sent mail and your memory, some of them will quietly never get paid. One sheet, one row per invoice, checked weekly — that is the whole fix.

Mistake 2: Apologizing for asking to be paid. "Sorry to chase…" trains clients to treat your invoice as optional. A reminder is a normal business email. Write it like one: short, polite, with the amount, the due date, and the payment link. No apology needed.

Mistake 3: Starting the next job before the last one is paid. This is how a $400 late invoice becomes a $2,000 hole. New work for a client with an overdue invoice starts only after the overdue one clears — no exceptions, no "just this once."

5. The numbers that tell you who to keep

After three months, your invoice log tells you the truth about every client:

Average days to pay — under 14 is great, over 30 is a problem client.
How many reminders each invoice needed — zero-reminder clients are gold; three-reminder clients cost you hours of admin per project.
Total overdue right now — if it's more than one month of income, your cash flow problem is a collections problem.

Raise your rates for the slow payers, or let them go. The clients who pay on time are subsidizing the ones who don't — and you get to choose which group you keep.

6. Build it once, then it runs itself

You can build this in a spreadsheet in an afternoon: one sheet for invoices, one for clients with their payment history, and a time log so every billable hour lands on an invoice instead of evaporating. If you'd rather start from a working file than a blank grid, I sell the exact trackers I described here:

Freelancer Invoice Tracker — https://payhip.com/b/VkExQ
Freelancer Client Tracker — https://payhip.com/b/coiFO
Freelancer Time Tracker — https://payhip.com/b/0bijT
Freelancer Budget Planner — https://payhip.com/b/Es7B5

Either way, the system is simple: invoice the day the work is done, remind on a schedule, stop work at 30 days overdue. The freelancers who get paid on time aren't luckier — they just send the reminder.

Alex Lin builds spreadsheet tools for freelancers. Questions or a workbook that doesn't fit your situation — fishdp@proton.me.

The Subscriptions You're Still Paying For (and the Bills You Keep Missing)

Alex Lin — Thu, 12 Nov 2026 03:03:02 +0000

The Subscriptions You're Still Paying For (and the Bills You Keep Missing)

Two things quietly drain a budget, and neither one feels like spending. A bill you forget doesn't feel like a choice — it feels like a late fee appearing out of nowhere. A subscription you stopped using doesn't feel like spending either — $12.99 a month is small enough to ignore, right up until you add up a year of it.

I ran the numbers on a sample month in my own tracker, and the totals surprised me. Eight subscriptions added up to $83.44 a month — $1,001.28 a year. Two of them, the ones I'd honestly forgotten I had, cost $28.98 a month. Cancelling just those two saves $347.76 a year. That's not a budgeting revolution. It's a free $347 for noticing.

1. Your subscriptions have a real yearly price — find it

Monthly prices lie by being small. The fix is a list with two columns: what it costs per month, and what it costs per year. Yearly plans are the sneaky ones — a $12 domain renewal looks like nothing until you realize you pay it every year forever, and a $120 yearly plan you forgot about is $10 a month you never budgeted for.

Write down every recurring charge: streaming, music, cloud storage, software, shopping memberships, the app you downloaded for one trip. Then give each one a status: Keep, Review, or Cancel. In my sample list, Netflix ($15.49), Spotify ($11.99), iCloud+ ($2.99), Notion Plus ($10.00) and Canva Pro ($12.99) were easy Keeps. YouTube Premium ($13.99) and Amazon Prime ($14.99) went to Review — used sometimes, not obviously worth it. The rule for Review: if you can't name the last time you used it, it becomes Cancel.

The math that matters: monthly cost × 12 is the number to look at, not the monthly price. $83.44 a month sounds manageable. $1,001.28 a year is a vacation, or a month of groceries, or the emergency fund you keep meaning to start.

2. Bills need a due-day list, not a memory

Forgetting a bill is never about the money — the money was there. It's about the due day living only in your head, or in an email you never opened. In my sample month, total bills were $1,545: $1,095 paid, $450 still unpaid at the time I checked. The unpaid $450 wasn't a cash problem. It was three bills whose due days I'd lost track of.

The fix is one page with five columns: bill name, category, due day, amount, and paid or not. Sort it by due day, not by amount. Check it twice a month — once on the 1st, once mid-month — and mark each bill paid the day you pay it. Autopay helps for the fixed bills (rent, insurance), but only if you also check that the autopay actually ran; a failed autopay plus a forgotten bill is how a $120 electric bill becomes a $120 bill plus a late fee plus a reconnect charge.

One habit makes the whole page work: when a new bill arrives, it goes on the list the same day. Not "later." Later is where bills go to become late fees.

3. Cancel & Save: make the savings visible before you cancel

People don't cancel subscriptions because cancelling feels like losing something. The trick is to see the savings first. Mark a subscription Cancel on the list and watch two numbers appear: what you save per month, and what you save per year. In my sample, cancelling the two Review items showed $28.98 a month and $347.76 a year — instantly, before I'd cancelled anything.

That number is the motivation. $28.98 a month is forgettable. $347.76 a year is a reason to spend the ninety seconds cancelling. Do the Review pile once a quarter — subscriptions creep back in (free trials that convert, annual renewals you forgot you agreed to), so the list needs a regular sweep, not a one-time purge.

4. The yearly overview is where it all lands

Bills plus subscriptions, twelve months side by side, one full-year total. That's the number your budget actually has to cover, and it's the number most people never see because they think in months. A month where bills are $1,545 and subscriptions are $83.44 is a $1,628 month — and the year is twelve of those, plus the months where an annual renewal lands.

Once you can see the full year, two things get easy: spotting the expensive months before they arrive, and deciding what a subscription is actually worth. A $15.49 streaming service is $185.88 a year. Maybe it's worth it — but now it's a decision, not a default.

5. The whole system is three habits

Log every bill the day it arrives — name, due day, amount, paid status. Two minutes, same day.
List every subscription with its real yearly cost — monthly × 12, yearly plans divided by 12 for the monthly view. Status: Keep, Review, or Cancel.
Sweep the Review pile once a quarter — cancel what you don't use, and watch the yearly savings number before you decide.

That's it. You can build this in an afternoon: one bills sheet with a due-day sort, one subscriptions sheet with monthly and yearly cost columns, and a cancel-and-save view that totals the savings. If you'd rather start from a working file, I sell the tracker I described here as the Bill & Subscription Tracker ($10), with matching Budget Planner and Savings Goal Tracker spreadsheets in the same shop:

Bill & Subscription Tracker — https://payhip.com/b/Tf3ou
Freelancer Budget Planner — https://payhip.com/b/Es7B5
Savings Goal Tracker — https://payhip.com/b/owFg1

Either way, the spreadsheet is the easy part. The habit — write it down the day it arrives, check the real yearly price, cancel what you don't use — is the whole game. Start with the subscriptions: ten minutes, one list, and you'll probably find your own $347.

Alex Lin builds spreadsheet tools for freelancers and households. Questions or a tracker that doesn't fit your situation — fishdp@proton.me.

Freelancer Taxes: Know What You Owe Before Tax Day

Alex Lin — Thu, 12 Nov 2026 02:00:45 +0000

Freelancer Taxes: Know What You Owe Before Tax Day

Nobody withholds tax from a freelancer's pay. The money lands in full, it feels like yours, and then April arrives with two bills at once: income tax and self-employment tax. The fix isn't a better accountant — it's a running estimate, updated every time you get paid, so the number is never a surprise.

1. The two taxes every US freelancer pays

First, self-employment tax: 15.3% of 92.35% of your net freelance income (the standard IRS rule — Social Security and Medicare, both halves, since there's no employer paying the other half). Second, ordinary income tax at your bracket on the same net income. Add them together and most freelancers land near a 25–30% effective rate on net income. That's the number to plan around — not the 10% or 15% you'd guess from the income-tax bracket alone.

A real sample quarter from my own tracker: $613.82 estimated tax on the quarter's net income, an effective rate of 25.3%. Nothing exotic — just income minus deductible expenses, times the two rates. The point is that the number existed in July, not the following April.

2. Set the money aside the day it lands

The rule that makes everything else work: every payment gets split the day it arrives. Before you spend a dollar of it, move the tax share out of your spending account — 25% is a safe default for most US freelancers, 30% if your income is high or your state has income tax too.

Why the same day? Because money sitting in your checking account feels spendable, and a $3,000 invoice in October becomes a $750 tax bill you've already spent by January. The split takes thirty seconds when the payment lands and a panicked weekend when it doesn't. If you use a budget workbook, make the split part of logging the payment, not a separate chore you'll skip.

3. Quarterly payments are deadlines, not suggestions

The IRS expects estimated tax four times a year, and the penalty for skipping them is real — interest on the underpayment, on top of the tax itself. The deadlines (mid-April, mid-June, mid-September, mid-January) are easy to miss because nothing reminds you: no employer, no payroll system, no letter until it's late.

Keep a simple payments sheet with four rows: due date, estimated tax due, amount paid, remaining, and status. Check it once a month. The quarter you "forget" is the quarter that costs you a penalty plus the stress of catching up.

4. Deductions are the part freelancers leave on the table

Your tax bill is calculated on net income — gross minus deductible business expenses. Every legitimate expense you forget to log is money taxed as if it were profit. The common ones:

Home office (the simplified $5 per square foot, or actual expenses)
Software and subscriptions you use for work
Internet and phone, the business share
Equipment: laptop, monitor, desk
Mileage for business trips
Health insurance premiums (if self-employed and eligible)

Log expenses the same day, in the same place as income, with the category attached. A shoebox of receipts in April is worth nothing; a categorized expense log is worth real money. In one sample year I tracked, deductible expenses came to $755.85 out of $808.15 in business spending — 93.5% of it legitimately deductible, because it was categorized as it happened instead of reconstructed later.

5. A running estimate beats a yearly panic

The whole system is three habits:

Log every payment the day it lands — date, source, gross, expenses, net.
Split the tax share immediately — 25% out of the spending account, same day.
Check the quarterly sheet monthly — what's due, what's paid, what's left.

That's it. The estimator is just arithmetic: net income × self-employment rate + net income × income-tax rate, per quarter, with a running total. You can build it in an afternoon (one income log, one estimate sheet with the two rates in editable cells, one payments sheet with the four deadlines). If you'd rather start from a working file, I sell the estimator I described here as the Freelancer Tax Estimator ($12), with matching Expense Tracker, Budget Planner, and Invoice Tracker spreadsheets in the same shop:

Freelancer Tax Estimator — https://payhip.com/b/LeRno
Freelancer Expense Tracker — https://payhip.com/b/gKnm7
Freelancer Budget Planner — https://payhip.com/b/Es7B5
Freelancer Invoice Tracker — https://payhip.com/b/VkExQ

Either way, the spreadsheet is the easy part. The habit — split it the day it lands, pay it the quarter it's due — is the whole game.

This is a planning estimate, not tax advice. Rates and rules change; check the current IRS figures or ask a tax professional for your situation.

Alex Lin builds spreadsheet tools for freelancers. Questions or a tracker that doesn't fit your situation — fishdp@proton.me.

How to Track Income From Multiple Side Hustles Without Losing a Dollar

Alex Lin — Thu, 12 Nov 2026 01:01:13 +0000

How to Track Income From Multiple Side Hustles Without Losing a Dollar

One side hustle is a hobby with a spreadsheet. Three side hustles is a small business that will quietly leak money if you don't track it — a $40 payout you forgot to chase, an hour you never billed, a platform fee you didn't notice eating 20% of a gig. The fix is boring and it works: one income log, one time log, and a weekly review that takes ten minutes.

1. One income log for every stream, not one per hustle

The mistake is keeping a separate notebook (or no notebook) for each gig: Etsy sales in one app, freelance invoices in email, tutoring payments in a chat thread. Money you can't see in one place is money you'll forget.

The log needs exactly seven columns:

Date — when you earned it, not when it hit your bank
Hustle / stream — the name of the income source
Client or platform — who paid
Gross amount — what they paid before fees
Fees — platform cut, payment processing, anything taken off the top
Net amount — what actually reaches you
Status — paid, pending, or overdue

That last column is the one that pays for the whole system. In a sample month I tracked recently, $620.40 was safely in hand — but $223.30 was still sitting in "pending" across two platforms. Without the status column, that $223.30 looks like money you have. It isn't, until it clears.

2. Track hours like you track money — because hours ARE money

If any of your hustles bills by the hour, untracked time is unpaid work. The rule is simple: log the session the day you do it, with four fields — date, client, hours, and whether it's billable.

A real two-week sample: 26.0 hours worked, 23.5 billable, 2.5 non-billable (admin, quotes, revisions you didn't charge for). At an average billable rate, those 23.5 hours were worth $2,002.50. The 2.5 non-billable hours are the interesting number — if that share creeps above 15%, you're doing free work for someone and should either charge for it or stop doing it.

Two habits make time tracking survive past week one:

Log the same day, not on Sunday night. Memory lies about hours. A session logged three days late is a guess, and guesses always round down.
One row per session, not per day. "Tuesday: 4.5 hours" tells you nothing. "Tuesday 9:00–11:30, Brightwave Studio, logo revisions" tells you exactly what to bill and what to chase.

3. Know which hustle actually earns

"I'm making money from three side hustles" means nothing until you divide by the hours. Once a month, compute three numbers per stream:

Net income — after fees, after refunds
Hours spent — including admin, listing, messaging, revisions
Effective hourly rate — net income divided by hours

The results are usually uncomfortable. The hustle that "makes the most money" often has the worst hourly rate once you count the unpaid admin around it. The quiet one with fewer dollars but almost no overhead is frequently the best business you own. Kill or fix the bottom one — don't keep feeding hours into a hustle that pays less than your worst freelance rate.

4. The invoice chase: money owed is not money earned

Every hustle has a different payment rhythm — net-15, net-30, "whenever the platform feels like it." Your log needs a follow-up rule, or invoices will age silently:

7 days overdue: one polite reminder, same day you notice
14 days overdue: a firmer note with the original invoice attached
30 days overdue: stop new work for that client until it's settled

In the same sample month: $8,020.00 invoiced across 8 clients, $5,310.00 paid, $2,710.00 still outstanding. That's a third of the month's billings sitting unpaid — and every dollar of it was visible in the log the day it went overdue, because the status column said so. The follow-up email takes two minutes. The money you never chase takes forever.

5. The weekly 10-minute review

A tracker you don't open is decoration. Every Friday:

Log the week's income and hours (5 minutes).
Flag anything pending more than 7 days and send one reminder (3 minutes).
Check the month-to-date totals per hustle — is the effective hourly rate holding up? (2 minutes).

That's it. Ten minutes a week, and you always know three things: how much you've actually been paid, how much is owed to you, and which hustle deserves more of your time next week.

6. Build it yourself, or start from a template

You can build all of this in an afternoon — an income log with a status column, a time log with a billable flag, and a summary that divides net income by hours per stream. The formulas are simple (SUMIFS for per-stream totals, a running balance, and one division for the hourly rate). If you'd rather start from a working file than a blank grid, I sell the tracker I described here as the Side Hustle Income Tracker ($10), with matching Time Tracker, Client Tracker, and Invoice Tracker spreadsheets in the same shop:

Side Hustle Income Tracker — https://payhip.com/b/urNs5
Freelancer Time Tracker — https://payhip.com/b/0bijT
Freelancer Client Tracker — https://payhip.com/b/coiFO
Freelancer Invoice Tracker — https://payhip.com/b/VkExQ

Either way, the spreadsheet is the easy part. The habit — log it the day it happens, chase it the day it's late — is the whole game.

Alex Lin builds spreadsheet tools for freelancers. Questions or a tracker that doesn't fit your situation — fishdp@proton.me.

Freelancer Budget Spreadsheet: How to Track Income, Tax, and Savings in One Workbook

Alex Lin — Thu, 12 Nov 2026 00:27:06 +0000

Freelancer Budget Spreadsheet: How to Track Income, Tax, and Savings in One Workbook

Freelance income is lumpy. One month you invoice $6,000, the next month $1,200 — and the tax bill arrives whether or not you had a good quarter. The fix isn't willpower. It's a single workbook where every dollar gets a job the moment it lands. Here's the setup I use, and the one I build for clients.

1. Start with the paycheck rule, not the budget

Salaried workers get a paycheck with tax already removed. Freelancers have to do that split themselves, every time money arrives. The rule that makes everything else work:

Every payment gets split the day it arrives: tax first, then savings, then spending.

A split that works for most US freelancers:

25–30% → tax set-aside (covers federal + self-employment tax; adjust to your bracket)
10% → savings / emergency fund
The rest → operating budget

The percentage matters less than the habit. If you only remember one number, make it the tax percentage — the IRS doesn't care that your client paid late.

2. The five sheets you actually need

One tab is not a system. A workbook that survives a full year has five sheets, each with one job:

Sheet 1 — Monthly budget. Fixed costs (rent, software, insurance) in one column, variable costs (food, transport, gear) in another. The only number that matters here is the gap between your average monthly income and your fixed costs. If fixed costs are more than 70% of your average month, you have no slack — and that's a pricing problem, not a budgeting problem.

Sheet 2 — Income log. One row per invoice: client, date sent, date paid, amount, and a "days to pay" column. After three months this sheet tells you which clients pay on time and which ones quietly cost you a month of cash flow. Chase the slow ones first; fire the ones who never improve.

Sheet 3 — Tax estimator. Multiply each payment by your set-aside rate the moment it lands, and keep a running total of what you've set aside versus what you owe per quarter. The common failure mode is simple: people track income and forget the tax column exists until April.

Sheet 4 — Expense tracker. Business expenses only, with a category column (software, travel, equipment, home office). Categorized expenses are deductible expenses — an uncategorized pile of receipts is worth nothing at tax time. Snap the receipt, log it the same day.

Sheet 5 — Savings goals. One row per goal with a target, a deadline, and a monthly contribution. Emergency fund first (3–6 months of fixed costs), then everything else. A goal without a monthly number is a wish.

3. The weekly 15-minute routine

A spreadsheet you don't open is decoration. The routine that keeps it alive is short:

Monday: log last week's payments and split them (tax/savings/spending).
Friday: log the week's expenses, flag any invoice that's more than 7 days overdue, and send one reminder.
Month end: compare actual spending to the budget sheet, move the tax set-aside into a separate account, and update the savings goal sheet.

Fifteen minutes a week beats a panicked weekend in April.

4. Three mistakes that sink freelance budgets

Mistake 1: Budgeting on your best month. Use your average of the last 3–6 months, or your worst month if you're just starting. Budgeting on a $6,000 month when the next one is $1,200 is how credit card debt starts.

Mistake 2: Mixing business and personal money. One account for business, one for personal, and a transfer between them on payday. If you can't tell in ten seconds whether a charge was business or personal, your books are already broken.

Mistake 3: No tax set-aside. This is the one that actually ends freelance careers. Set the money aside the day you're paid, in a separate account, and don't touch it. Quarterly estimated tax is not optional, and the penalty for skipping it is real money.

5. Build it yourself, or start from a template

You can build all five sheets yourself in an afternoon — the formulas are simple (SUMIFS for category totals, a running balance column, and a percentage split on the income log). If you'd rather start from a working file than a blank grid, I sell the workbook I described here as the Freelancer Budget Planner ($14, five sheets, formulas included), with matching Tax Estimator, Invoice Tracker, Expense Tracker, and Savings Goal Tracker spreadsheets in the same shop:

Freelancer Budget Planner — https://payhip.com/b/Es7B5
Freelancer Tax Estimator — https://payhip.com/b/LeRno
Freelancer Invoice Tracker — https://payhip.com/b/VkExQ
Freelancer Expense Tracker — https://payhip.com/b/gKnm7
Savings Goal Tracker — https://payhip.com/b/owFg1

Either way, the spreadsheet is the easy part. The habit — split every payment the day it arrives, fifteen minutes a week — is the whole game.

Alex Lin builds spreadsheet tools for freelancers. Questions or a workbook that doesn't fit your situation — fishdp@proton.me.