Freelancer Tax Set-Aside Tracker (Excel + Google Sheets)

For US freelancers, creators and side-hustlers paid on 1099s. Every time a client pays you, the sheet tells you exactly how much to move to tax savings. It estimates self-employment, federal and state tax for each IRS period, compares that with what you have set aside and paid, and shows your next due date and amount.

What you get:

• Income tab: amount to move to tax savings on every payment, and the IRS period it belongs to
• IRS payment periods done right: Jan-Mar, Apr-May, Jun-Aug, Sep-Dec (most templates wrongly use calendar quarters)
• Due dates calculated from the tax year and moved off weekends; editable if the IRS shifts a date
• Quarterly tab: income, deductible expenses, net profit, est. SE tax, federal, state, total vs set aside and paid
• Safe-harbour calculator: 100% / 110% of last year's tax split into four payments
• Expenses: Schedule-C style categories, business-use %, meals at 50%
• BankImport tab: paste your bank CSV; money in = income, money out auto-categorised by keyword rules
• Change the tax year and every date updates: use it again next year

Included files:

• Freelancer Tax Set-Aside Tracker.xlsx (blank)
• Freelancer Tax Set-Aside Tracker - SAMPLE.xlsx (demo data)
• 'Start here' instructions tab

Works in: Microsoft Excel 2019, 2021, Microsoft 365 (Windows and Mac), Google Sheets (free), LibreOffice. One .xlsx file for both Excel and Google Sheets; no separate versions to mix up.

After purchase you get an instant download link by email (Payhip). This is a DIGITAL DOWNLOAD. Nothing physical will be shipped.

Refunds: because this is an instantly downloadable file, sales are final, but if the file doesn't open or a formula misbehaves, email me and I will fix it or refund you.

Designed, built and tested by me. I used AI tools to help write formulas and copy; every formula was recalculated and checked against hand calculations before listing.

This is a planning and record-keeping tool, not legal, tax or accounting advice.