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.

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:
| Month | Income | Expenses | Mileage ded. | Net profit | Profit YTD | Miles |
|---|---|---|---|---|---|---|
| January | $2,980 | $245 | $10 | $2,725 | $2,725 | 14.2 |
| February | $2,700 | $220 | $16 | $2,464 | $5,188 | 22.5 |
| March | $2,700 | $549 | – | $2,151 | $7,339 | – |
| April | $2,580 | $282 | $7 | $2,291 | $9,630 | 9.8 |
| May | $2,850 | $245 | $5 | $2,600 | $12,231 | 6.4 |
| June | $2,700 | $220 | – | $2,480 | $14,711 | – |
| Jan-Jun | $16,510 | $1,761 | $38 | $14,711 | $14,711 | 52.9 |
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%:
| Month | Net profit | Set aside (25%) | IRS payment period |
|---|---|---|---|
| January | $2,725 | $681.25 | 1 |
| February | $2,464 | $616.00 | 1 |
| March | $2,151 | $537.75 | 1 |
| April | $2,291 | $572.75 | 2 |
| May | $2,600 | $650.00 | 2 |
| June | $2,480 | $620.00 | 3 |
| Jan-Jun | $14,711 | $3,677.75 |
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:
| Period | Income earned | Payment due (2026 tax year) |
|---|---|---|
| 1 | January 1 – March 31 | April 15, 2026 |
| 2 | April 1 – May 31 | June 15, 2026 |
| 3 | June 1 – August 31 | September 15, 2026 |
| 4 | September 1 – December 31 | January 15, 2027 |
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.
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.
Related calculators and templates
- Uber & DoorDash Driver Earnings Calculator (real pay and tax set-aside)
- Sales Tax Calculator: Price Plus Tax
- Free Small Business Bookkeeping Spreadsheet
- Self-Employment Tax Calculator 2026
- Mileage Deduction Calculator 2026
- How to Do Bookkeeping in Excel
- Weekly Cash Flow Forecast Template (Google Sheets & Excel)
Comments
2 responses to “Free Income and Expense Tracker for Self-Employed (Excel & Google Sheets)”
[…] Free Income and Expense Tracker for Self-Employed […]
[…] Free Income and Expense Tracker for Self-Employed […]