Spreadsheet Templates for Freelancers: A Simple Money System
Updated
Freelancing means you're also the bookkeeper, the billing department and the person who has to find the receipts in April. You don't need accounting software to stay on top of it. A few well-designed spreadsheets and a weekly habit are enough for many solo freelancers. This guide shows which spreadsheet templates for freelancers are worth setting up, what each should track, and a routine that keeps it all current.
General information, not tax, legal, accounting or financial advice. How much to set aside, what you can deduct and when to pay are personal decisions. Talk to a qualified tax professional.
What a freelancer's money system needs to answer
Before choosing templates, decide what you want to know at a glance:
- How much did I earn this month, counting only what's actually been paid?
- What did I spend, by category?
- Who still owes me, and how late are they?
- Have I set money aside for taxes at the rate I chose?
- What's my profit this year so far?
A good freelancer setup answers all five from one place or a couple of linked files.
Template 1: Income log
Record every payment you receive or expect:
- Date, client and project
- Amount
- Status: paid or unpaid
Only paid income should count toward profit. Unpaid work is money owed to you, not money in the bank. Keeping both in one log, with a status column, means nothing gets forgotten.
Template 2: Expense log
Log every business expense with a date, amount, short description and category. Use a fixed category list in dropdowns (software, equipment, contractors, phone and internet, travel and so on) so totals are consistent. Anything you file under a category that's not on the list should still be counted, for example as "Other", so your totals still add up.
Some expenses have special rules. For example, the IRS says business meals are generally only 50% deductible, with some exceptions (see IRS Publication 463). Track the full amount you paid, and ask your tax professional how your meals should be treated.
Template 3: Unpaid invoices
If you invoice clients, you need to see open balances. At minimum, track the invoice date, due date, amount and amount paid. A separate invoice tracker with aging buckets helps if you have many clients or long payment terms. Sorting overdue balances by how late they are tells you who to contact first.
Template 4: Tax set-aside
Some freelancers move part of each payment into a separate savings account so money is available when estimated tax payments come due. A spreadsheet can make that habit visible:
- Enter a set-aside percentage you choose (with your tax professional's input). No template should pick it for you.
- Multiply it by your net profit (income minus expenses) to see your set-aside target.
- Log what you've actually set aside or paid, so you can see the gap.
This is a budgeting habit, not a tax calculation. Your actual tax depends on many factors a spreadsheet doesn't know. The IRS explains who generally needs to make estimated payments, and the payment due dates, on its Estimated taxes page and the Form 1040-ES page. A qualified tax professional can help you decide how much to set aside and when to pay.
Template 5: Mileage (if you drive for work)
If you drive to clients or job sites, log each business trip with the date, start point and destination, purpose and miles. The IRS business rate changed mid-year in 2026 (72.5¢/mile Jan–Jun, 76¢/mile Jul–Dec), so the rate should be applied by trip date. Confirm current rates on the IRS standard mileage rates page: https://www.irs.gov/tax-professionals/standard-mileage-rates.
Put it on one dashboard
The five logs above feed one summary:
| Line | Where it comes from |
|---|---|
| Paid income (by month) | Income log, status = paid |
| Expenses (by month and category) | Expense log |
| Net profit | Income − expenses |
| Unpaid invoices | Income log or invoice tracker |
| Set-aside target vs actual | Your % × net profit vs what you logged |
A monthly view shows seasonality: which months are lean and which carry the year. That's useful for planning time off or deciding when to raise rates.
The 15-minute weekly routine
- Enter income received and mark invoices as paid.
- Enter expenses from your bank and card statements.
- Log trips if you drove for work.
- Check flagged rows: typos, bad dates, entries from the wrong year.
- Move your set-aside amount, then log it.
- Glance at the dashboard: profit so far, unpaid total, set-aside gap.
Once a month, add one more step: chase anything overdue.
Common freelancer mistakes
- Counting unpaid invoices as income.
- Mixing personal and business expenses in the same log.
- No savings habit for taxes, so estimated payments become a scramble.
- Inconsistent categories that make year-end totals meaningless.
- Rebuilding records from bank statements once a year instead of weekly.
Ready-made option
If you'd rather not build this from scratch, our Freelancer Income Expense Tax Tracker ($16, for Google Sheets & Microsoft Excel) includes:
- An income log with paid/unpaid status (only paid income counts)
- An expense log with 12 editable categories, where anything outside your list is totaled as "Other"
- Business meals counted at 50% by default (editable; see IRS Pub 463 for exceptions)
- A mileage log that applies the 2026 IRS rates by trip date (confirm current rates at irs.gov)
- A monthly P&L dashboard and a quarterly estimated-tax view with an estimated-payments log
- A tax set-aside line at a percentage you choose (we don't recommend a rate)
It's one of our spreadsheet templates for freelancers and small businesses, all delivered as an .xlsx file plus a Google Sheets "Make a copy" link.
The bottom line
The best spreadsheet templates for freelancers are simple: log paid income, categorized expenses, unpaid invoices, your chosen set-aside and any business mileage, and review it all weekly. Fifteen minutes a week beats a lost weekend every April.
Microsoft Excel is a trademark of Microsoft Corporation; Google Sheets is a trademark of Google LLC. Sheetsmith Studio is not affiliated with, sponsored or endorsed by either.
This article is general information, not tax, legal, accounting or financial advice. Talk to a qualified professional about your own situation.