Free Income and Expense Tracker for Self-Employed (Excel & Google Sheets)

When you work for yourself, nobody withholds taxes from your pay, nobody hands you an expense report, and nobody reminds you when the IRS wants money. That’s why a simple, consistent record of what you earn and spend matters more for freelancers, contractors and gig workers than for almost anyone else.

Self-employed contractor sorting receipts at his kitchen table

This free income and expense tracker for the self-employed is built for exactly that. You log payments and expenses on one sheet and business driving on another. A dashboard then shows your monthly profit, your expenses by category, receipts you still need to find, and how much to set aside for each IRS estimated-tax period.

Free, no sign-up. Works in Excel, Google Sheets and LibreOffice.

What’s inside the tracker

  • Start Here: five settings: your name, the tax year, your tax set-aside percentage and the two 2026 mileage rates.
  • Income & Expenses: one log for everything, with columns for client or vendor and a Receipt saved? check. Expenses without a receipt are highlighted in pink.
  • Mileage: a simple trip log (date, from, to, purpose, miles) that calculates the deduction for each trip.
  • Dashboard: year-to-date totals, a month-by-month table, an estimated-tax set-aside table that follows the IRS payment periods, and expenses by category.
  • Categories: 18 categories freelancers commonly use, which you can rename or extend.

If you run a business with more categories and want a full profit and loss statement, our small business bookkeeping spreadsheet may suit you better. This tracker is deliberately simpler and focused on the questions self-employed people ask most: Am I making money? Where is it going? How much do I owe the IRS?

How to set it up

1. Choose your set-aside percentage

On the Start Here tab, enter the share of your profit you want to move into a separate savings account for taxes. The template starts at 25%, a figure many freelancers use as a starting point. The right number for you depends on your total income, deductions, filing status and state, so treat it as a savings habit, not a tax calculation. A tax professional can tell you what fits your situation, and you can change the percentage at any time.

2. Check the mileage rate

The IRS sets a standard mileage rate each year. For 2026 the business rate is 72.5 cents per mile from January 1 to June 30 and 76 cents per mile from July 1, after a mid-year increase (IRS standard mileage rates). The template has both rates: 72.5 cents for trips from January to June and 76 cents for trips from July 1, and it picks the right one from each trip’s date. You can check the total with the mileage deduction calculator. When the IRS announces the 2027 rate, usually in December, enter it in the first rate cell.

3. Log income and expenses as they happen

Add one row for every payment you receive and every business expense you pay. Pick a category from the dropdown; the category decides whether the row counts as income or an expense, so amounts are always entered as positive numbers. Fill in the client or vendor. Six months from now, “Northside Dental, website project” will be much more useful than “payment”.

For expenses, set Receipt saved? to Yes once you have a copy of the receipt or invoice: a photo, a PDF in a folder or an email you’ve filed. The Dashboard counts every expense still missing a receipt, which makes it easy to catch up at the end of each month instead of digging through emails in April.

4. Log business miles

On the Mileage tab, record each business trip: the date, where you drove from and to, the business purpose and the miles. The tracker multiplies miles by the rate from Start Here. Two rules worth knowing: driving from home to a regular workplace is generally commuting, not business mileage; and if you use the standard mileage rate for a vehicle, you don’t also deduct that vehicle’s gas, repairs or insurance. Parking fees and tolls for business trips can still be recorded as expenses, which is why Parking & tolls has its own category.

Reading the dashboard

The top row shows six numbers: income, expenses, mileage deduction, net profit, the total to set aside for taxes, and how many receipts are missing. Below it, the month-by-month table shows income, expenses, mileage, net profit, profit year-to-date and miles driven.

Here’s what the monthly table looks like after six months of entries for a freelance web designer:

MonthIncomeExpensesMileage ded.Net profitProfit YTDMiles
January$2,980$245$10$2,725$2,72514.2
February$2,700$220$16$2,464$5,18822.5
March$2,700$549–$2,151$7,339–
April$2,580$282$7$2,291$9,6309.8
May$2,850$245$5$2,600$12,2316.4
June$2,700$220–$2,480$14,711–
Jan-Jun$16,510$1,761$38$14,711$14,71152.9
Example Dashboard figures for a freelance web designer, January to June 2026.

Monthly income and expense worksheet: how much to set aside

Many self-employed people use the tracker as a simple monthly income and expense worksheet: at the end of each month, check income, expenses and net profit, then move the tax set-aside into savings. Here is the same example at the template’s starting set-aside of 25%:

MonthNet profitSet aside (25%)IRS payment period
January$2,725$681.251
February$2,464$616.001
March$2,151$537.751
April$2,291$572.752
May$2,600$650.002
June$2,480$620.003
Jan-Jun$14,711$3,677.75
Monthly figures are rounded to whole dollars, so they can differ by $1 from the Profit YTD column above.

Grouped by IRS payment period, that is $1,835.00 saved for period 1 (January to March), $1,222.75 for period 2 (April and May) and $620.00 so far toward period 3, which runs June to August. Saving monthly means each payment is already sitting in the account when it is due. The 25% is only a starting point; your actual tax depends on your whole situation.

Want to see your self-employment tax on its own? Try the self-employment tax calculator or the quarterly estimated tax calculator.

Estimated taxes: the periods aren’t really “quarterly”

If you expect to owe $1,000 or more in federal tax when you file, the IRS generally expects you to pay during the year through estimated tax payments (IRS: Estimated taxes). Those payments cover income tax and self-employment tax, the Social Security and Medicare tax that self-employed people pay themselves. The self-employment tax rate is 15.3% (IRS Topic 554).

People call these “quarterly taxes”, but the four payment periods are uneven, and that trips up a lot of first-year freelancers:

PeriodIncome earnedPayment due (2026 tax year)
1January 1 – March 31April 15, 2026
2April 1 – May 31June 15, 2026
3June 1 – August 31September 15, 2026
4September 1 – December 31January 15, 2027
IRS estimated tax payment periods for the 2026 tax year (calendar-year taxpayers).

Notice that period 2 covers only two months and its payment is due just two months after the first. If a due date falls on a weekend or legal holiday, a payment made on the next business day counts as on time.

The Dashboard’s estimated-tax table uses these exact periods. For each one it shows your net profit, the amount to set aside at your chosen percentage, a yellow Paid cell where you record what you actually sent the IRS, and the difference. A period where you made a loss shows a set-aside of zero rather than a negative number.

The set-aside is a savings target, not your tax bill. Your actual estimated payments depend on your whole tax picture. Many people use last year’s tax return or the worksheet in Form 1040-ES to work out the real amounts, often with help from a tax preparer. What the tracker gives you is the habit: money set aside every period, so the payment is there when it’s due.

Mistakes that cost freelancers money

  • Spending the tax money. Move your set-aside into a separate savings account the day you get paid. Money left in your main account tends to disappear.
  • Forgetting platform fees. If a platform pays you $900 after taking a $90 fee, the fee is a business expense. Log the gross payment as income and the fee as an expense, so your records line up with the gross amounts platforms often report on 1099 forms.
  • Not tracking mileage as you go. Trying to rebuild a year of trips from memory is painful and less reliable. Log trips weekly at least.
  • Mixing personal and business spending. A separate bank account and card for your business make every step of this easier, from logging expenses to answering questions later.
  • Losing receipts. Keep them in one place, such as a folder in cloud storage, and mark them off in the tracker.

Frequently asked questions

Is this tracker only for freelancers?

No. It works for independent contractors, consultants, gig workers, creators and anyone with self-employment income, including people with a side business alongside a regular job.

Does it calculate the tax I owe?

No, and that’s on purpose. Your tax depends on things a spreadsheet can’t see, such as other income, deductions, credits and your state. The tracker organizes your numbers and helps you save consistently. Your tax preparer or tax software turns those numbers into a tax bill.

Can I use it in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The dropdowns, formulas and formatting carry over.

What about a home office?

There’s a Home office category for expenses you pay directly for your workspace. The home office deduction itself has specific rules and two calculation methods, so ask your tax preparer how to handle it before you rely on those numbers.

What should a self-employed income and expense spreadsheet include?

At minimum: the date, the client or vendor, a category, the amount, and whether you have the receipt. Add a separate mileage log if you drive for work, a monthly summary of income, expenses and profit, and a line that shows how much to set aside for taxes. This tracker has all of these on four tabs, so you don’t need to build the spreadsheet yourself.

What is a self-employment tracker?

It is simply a record of the money a self-employed person earns and spends, usually a spreadsheet or an app. It helps you see your real profit, keep receipts organized, save for estimated taxes and fill in your tax return (for most sole proprietors, Schedule C) at the end of the year.

How do I start a new year?

Save a copy of the file, clear the Income & Expenses and Mileage logs, change the tax year on Start Here and update the mileage rate.

More free tools for the self-employed: set your price with the self-employed hourly rate calculator, check which contractors need a form with the 1099-NEC checker, and if you work in a salon, compare booth rent vs commission.

This template and guide are for general record-keeping and educational purposes only and are not tax advice. Tax rules change; check current IRS guidance or ask a qualified tax professional. See our disclaimer.

Want it all in one file?
Bookkeeping Kit Pro 2026 links your P&L, invoices, bills, bank rec, mileage and quarterly tax in one Excel workbook (works in Google Sheets). The free templates on this site stay free.
Get the kit – $19 →

Comments

2 responses to “Free Income and Expense Tracker for Self-Employed (Excel & Google Sheets)”

  1. […] Free Income and Expense Tracker for Self-Employed […]