I Built a 10,000-Formula US Tax Workbook: What You Should Track All Year

Abhishek Salaria — Fri, 06 Nov 2026 17:28:49 +0000

Contract work pays well, but January has a way of ruining it: a pile of invoices, a year of subscriptions nobody categorized, and no idea what to set aside. Here's the setup that fixes most of that, whatever tool you use.

1. Track income by client and by date received

Log each payment with the client, the date you were paid, and the amount, not the invoice date.
Watch which clients cross the 1099-NEC reporting threshold [confirm the current figure on IRS.gov]. The income counts whether or not a client sends the form.
Reconcile at year end: client totals should add up to gross receipts.

2. Tag expenses when you pay them, not in December

Common categories for developers:

Software and SaaS: IDEs, hosting, domains, dev tools, API credits
Equipment: laptops, monitors, peripherals (ask your accountant how to treat larger purchases)
Home office: only if you meet the rules, so read the IRS guidance
Internet and phone: only the business-use share
Education: courses, books, conferences
Coworking and professional fees: legal, accounting
Meals: generally limited, so log them separately

Ask your accountant which Schedule C line each of these belongs on. Pick a category when you log it, because reconstructing a year of card statements is the real pain.

3. Log business mileage as you go

Client meetings and coworking trips add up. The IRS business rate changed mid-year in 2026 (72.5 cents, then 76 cents from July 1), so a single flat rate in a spreadsheet will be wrong for the year. Keep a date on every trip.

4. Set aside for quarterly estimated taxes

As a contractor, nobody withholds tax for you. Self-employment tax has a Social Security part that stops at a yearly wage base, and a Medicare part that doesn't. If you also have a W-2 job, that income uses up part of the base, which a lot of simple calculators ignore.

A rough running estimate from year-to-date numbers is better than a surprise bill. It's an estimate only, so confirm the real figures with a tax pro. Estimated payments are due four times a year, and the last one for 2026 falls in January 2027.

5. Things I see freelancers get wrong

Mixing personal and business spending in one card
Logging income by invoice date and expenses by payment date
Forgetting that income counts even without a 1099
Hard-coding last year's rates into a spreadsheet

The tracker I use

I did this in a spreadsheet for years. You could build one yourself, and I did, but the edge cases ate the time: the mid-year mileage rate, the wage-base cap with W-2 income, the per-client 1099 flags, and keeping every rate sourced and dated. If you'd rather spend January on billable work, I turned mine into a template: https://salarialabs.etsy.com/listing/4611177226/1099-tax-tracker-google-sheets-excel

Works in Google Sheets and Excel, with no macros
Every formula is visible and editable, with no black box
Every IRS rate sits in one tab with its source link and verified date
Federal estimates only, for tax year 2026, US only. It's an organizer, not tax advice.

What does your freelance setup look like? Spreadsheet, accounting software, something else? And what did you miss on your first self-employed tax return?