Self-employed expense spreadsheet and quarterly tax tracker
By the BizDocs Studio team · Updated
- •Log income (gross, platform fees, net) and expenses by Schedule C category as they happen.
- •Track business miles and home-office use; both are common, valuable deductions with record-keeping rules.
- •Self-employment tax is about 15.3% of net earnings (on 92.35% of net profit), on top of income tax.
- •Estimated payments are due four times a year; a quarterly view shows how much to set aside.
Freelancers and 1099 workers have no employer withholding taxes, so the tax bill arrives all at once unless you plan for it. A simple spreadsheet that categorizes as you go and estimates each quarter removes the April surprise.
What to record
- Income: date, client, gross amount, platform or payment fees, net
- Expenses: date, vendor, Schedule C category, amount, receipt reference
- Mileage: date, purpose, miles (standard mileage rate set yearly by the IRS)
- Home office: square footage of the dedicated space and of the home
Common Schedule C categories
| Category | Examples |
|---|---|
| Advertising | Ads, website, business cards |
| Car and truck | Business miles or actual costs |
| Contract labor | Subcontractors you pay |
| Insurance | Business liability, professional |
| Legal and professional | Accountant, attorney |
| Office expense | Supplies, postage |
| Software and subscriptions | Often under other expenses |
| Travel and meals | Business travel; meals usually 50% |
| Home office | Simplified or regular method |
Estimating quarterly tax
Each quarter: net profit = income − deductions. Self-employment tax ≈ net profit × 92.35% × 15.3%. Add estimated income tax at your expected rate, subtract half of SE tax as a deduction, and you have a planning number for the quarterly payment. Safe-harbor rules based on last year's tax can reduce underpayment penalties.
Q2 net profit: $14,000
SE tax ≈ $14,000 × 0.9235 × 0.153 = $1,978
Income tax at an estimated 12% on ($14,000 − half SE tax $989) ≈ $1,561
Suggested Q2 set-aside ≈ $3,540
Income, expenses, mileage and quarterly taxes in one file. Schedule C ready.
Use a template
Our freelancer tracker categorizes income and expenses by Schedule C line, calculates mileage and home office, and shows each quarter's net profit, SE tax and a suggested estimated payment in Excel or Google Sheets. It is a planning tool; confirm figures with a tax professional.
Records the IRS expects
- Receipts or statements for each business expense
- A mileage log with date, destination, purpose and miles (written at the time, not reconstructed)
- Home office measurements and photos of the dedicated space
- 1099 forms received and invoices for income not reported on a 1099
Simplified vs regular home office
| Method | How it works | Good for |
|---|---|---|
| Simplified | Fixed rate per sq ft of dedicated space, up to a cap | Small spaces, minimal record keeping |
| Regular | Share of actual home costs by area percentage | Larger spaces or high home costs |
The space must be used regularly and exclusively for business in most cases. Check the current IRS rate and cap for the simplified method each year.
Separate business money
A separate bank account and card for business transactions turns bookkeeping from detective work into copying a statement. Even as a sole proprietor, keeping business and personal spending apart makes the spreadsheet accurate and audits far less painful.
Frequently asked questions
How much should a freelancer set aside for taxes?
Many set aside 25–30% of net profit, covering self-employment tax and income tax. Your actual rate depends on income, deductions and state taxes.
When are quarterly estimated taxes due?
Four times a year, roughly mid-April, mid-June, mid-September and mid-January. Check the IRS dates for the current year.
Can I use a spreadsheet instead of bookkeeping software?
Yes, for most solo freelancers. Keep receipts, categorize consistently and back up the file.
Income, expenses, mileage and quarterly taxes in one file. Schedule C ready.