Self-Employed Tax Tracker - Income, Expenses, Mileage + Quarterly Tax (Excel & Google Sheets)

Log your income, expenses and business miles, and this spreadsheet shows your profit, an estimate of what you owe in self-employment and income tax, and how much to send for each IRS quarterly payment. Works in Microsoft Excel and Google Sheets. Instant download.

WHAT'S INSIDE (8 tabs)

• Dashboard: income, deductions, net profit, estimated tax, paid in and take-home. Quarterly payment status (Covered, Due soon, Late). "Set aside X% of every dollar" figure. Monthly income/profit chart and a deductions breakdown.
• Quarterly Tax: the real IRS periods (Jan-Mar, Apr-May, Jun-Aug, Sep-Dec) with due dates. Income, deductions and profit per period, year-to-date SE tax and income tax, amount owed each period after what you already paid. Enter your payments and the status updates.
• Income: 1,000 rows. Date, client or platform, amount, category, invoice number.
• Expenses: 2,000 rows. Business % for mixed-use items (phone, internet), meals counted at 50% automatically, receipt tick with a reminder when it's missing.
• Mileage: 1,000 trips. Miles x the standard rate you set becomes a deduction.
• Year: every income and expense category by month, with the matching Schedule C line next to each expense category.
• Setup: your federal and state rates, mileage rate, optional cushion, and editable categories.

HOW THE ESTIMATE WORKS

Self-employment tax = profit x 92.35% x 15.3%. Income tax = (profit - half of SE tax) x your federal + state rates. It ignores the standard deduction and credits on purpose, so it leans toward setting aside a little too much. It is a planning tool, not tax advice.

DETAILS

• Comes with a full sample year so you can see it working. Clear the yellow cells to start.
• Formulas protected (no password) so you can't break them by accident.
• No macros, no add-ons, no account. Your data stays on your computer or in your own Google Drive.

You get a .zip with the .xlsx file and a quick-start guide. Personal use license. Please don't resell or share the file.