Freelancer Bookkeeping & Tax Tracker

Income, expenses, mileage and quarterly taxes in one file. Schedule C ready.

$22~~$34~~one-time, USD

Instant download · Excel workbook (.xlsx), opens in Google Sheets
14-day refund, no questions asked
Personal and business use licence
Free updates to this version

Works with

Microsoft Excel 2010 or newer
Google Sheets (File > Import)
Excel for Mac
No macros, no add-ins

Made for: Freelancers and consultants filing Schedule C, Designers, developers, writers, photographers, Side-hustlers with 1099 income, Anyone who got surprised by a tax bill last April.

What is inside

7 tabs, one linked system

1
Settings
Name, tax year, estimated federal and state rates, SE tax rate and 92.35% factor, mileage rate, home office square footage and annual home costs (regular vs simplified shown), savings target %, Schedule C expense categories, income types.
2
Income
300 rows: date, client, description, type, gross, platform fee, net, payment method. Totals for gross, fees and net.
3
Expenses
500 rows: date, vendor, description, category (dropdown), amount, business-use %, deductible amount, receipt reference.
4
Mileage
300 trips: date, route, purpose, miles; deduction at the standard rate in Settings.
5
Quarterly
Per IRS quarter: net income, deductions, mileage, prorated home office, net profit, SE tax, half-SE deduction, taxable profit, federal and state estimates, total to set aside, due dates. Set-aside tracker with shortfall in red.
6
Dashboard
KPI strip (income, deductions, profit, margin, estimated tax, set aside, gap, effective rate), monthly table and chart, Schedule C summary by line, top categories, set-aside progress and next due date.
7
Clients
Gross and net per client, payment count, 1099-NEC $600 flag, notes for platform 1099-K.

Details

Built to be right, not just pretty

Expense categories mapped to Schedule C lines 8 to 27a
Business-use % per expense; meals at 50% handled
Mileage log in the format the IRS expects, deduction automatic
Home office: regular method vs simplified side by side
Quarterly estimates with uneven IRS quarters and due dates
Set-aside tracker shows the gap between tax owed and money parked
2,500+ formulas, all visible and editable; verified to the cent

Last updated November 2, 2026. Buyers get updates to this version free, by email.

Questions

Before you buy

Will this calculate my exact taxes?

No. It estimates with flat rates you enter (federal, state, SE) so you can set money aside each quarter. Your actual return depends on deductions, credits, other income and filing status; your preparer or IRS Form 1040-ES gives the final number.

Does it work in Google Sheets?

Yes. File > Import > Upload the .xlsx. Dropdowns, conditional formatting and the chart carry over. All formulas are Sheets-compatible; no macros.

Is it US-only?

The categories follow US Schedule C and the quarterly dates are IRS dates. Everything is editable: rename categories and change the quarter months for another country, the math is the same.

How do I handle an LLC or S-corp?

Single-member LLCs taxed as sole proprietors use it as-is. S-corp owners can still track income and expenses but should set the SE rate to 0 and talk to their preparer about payroll.

What if it is not what I need?

Email us within 14 days and we refund you. No forms, no questions.