A Simple Invoice and Expense Tracking System for Freelancers

Not tax advice: this post is about staying organized. For tax questions, check IRS.gov or talk to a tax professional.

Most freelancers don't need accounting software in their first year. They need answers to three questions at any moment: Who owes me money? What have I spent? What did I actually make? A small, consistent system answers all three. Here's one you can set up in an afternoon and keep up in about fifteen minutes a week.

The four parts

1. An invoice log: every invoice you send, with its status.
2. An expense log: every business purchase, with a category.
3. A monthly summary: income and expenses rolled up by month.
4. A weekly money check: a short routine that keeps it all current.

A single spreadsheet with a tab for each part works fine.

Part 1: The invoice log

Give every invoice one row. Useful columns:

• Invoice number (sequential, like 2026-001)
• Client
• Description
• Date sent
• Due date
• Amount
• Status (Draft, Sent, Paid, or Overdue)
• Date paid
• Days overdue

Days overdue is the column that pays for itself. Use a formula like =IF(Status="Paid","",MAX(0,TODAY()-DueDate)) and every late invoice surfaces on its own. Sort by that column once a week and you have your follow-up list.

Tips for getting paid on time:

• Put your payment terms (for example, "Net 15") and accepted payment methods on every invoice.
• Send invoices the day the work is delivered, not at the end of the month.
• Follow up politely on the first day an invoice is overdue, then again at 7 and 14 days. A short template email makes this painless.

Part 2: The expense log

Give every business expense one row:

• Date
• Vendor
• Description
• Category
• Amount
• Deductible? (Y/N, your best guess, to confirm later)
• Receipt saved? (Y/N)

Keep categories few and consistent. Ten to twelve is plenty for most freelancers, such as software and subscriptions, equipment, office supplies, internet and phone, travel, meals, education, advertising, contractors, bank and payment fees, and other. Use a dropdown so "Software," "software," and "SaaS" don't turn into three separate categories.

Save receipts the moment you get them. Make one cloud folder per year and name each file by date and vendor, like 2026-03-14_Adobe.pdf. Mark "Receipt saved" Y once it's filed.

Count payment-processor fees. If clients pay through a processor, its fees are a real cost. Record them as expenses, or log the gross payment as income and the fee separately.

Part 3: The monthly summary

This tab pulls your two logs together. For each month, show:

• Income received (paid invoices, by date paid)
• Total expenses
• Profit (income minus expenses)

With SUMIFS it fills in on its own. For example, monthly income is the invoice amounts where status is Paid and the date paid falls in that month. Add year-to-date totals at the bottom and an unpaid-invoices total at the top, and you have a basic dashboard.

Watching profit by month helps you spot slow seasons, decide when to raise rates, and plan how much to set aside for taxes, if you do that.

Part 4: The weekly 15-minute money check

A system only works if it stays current. Pick a fixed time, like Friday afternoon, and run through this list:

1. New invoices: add anything you sent this week.
2. Payments: mark paid invoices and enter the date paid.
3. Overdue: sort by days overdue and send follow-ups.
4. Expenses: check your bank and card statements and log any business charges.
5. Receipts: file anything still sitting in your inbox.
6. Glance at the summary: is this month on track?

That's it. Fifteen minutes a week saves hours of digging through statements at year end.

Keep business and personal money separate

The single most helpful thing you can do is use a separate bank account, and ideally a separate card, for business. Your bank statement then matches your expense log almost line for line, and the weekly check gets much faster.

Build it or start from a template

Everything above can be built from scratch in Excel or Google Sheets in an afternoon. If you'd rather start with it already set up, TallySheet is a $19 one-time template with this exact structure. It has Invoices with days-overdue formulas, Expenses with category and deductible dropdowns, an Income Summary, a Dashboard, and a Quarterly Tax Estimate tab, with room for 500 invoices and 500 expenses. It works in Google Sheets and Excel.

Either way, the tool matters much less than the habit. Pick something simple, run the weekly check, and you'll always know where your freelance money stands.

This post is general information, not tax, legal, or accounting advice. Confirm what's deductible and what you owe with IRS.gov or a qualified professional.