Quarterly Tax Tracker for Freelancers, 1099 Income and Expense Spreadsheet, Estimated Tax Planner, Self Employed, Google Sheets & Excel

Quarterly tax tracker for freelancers and the self-employed: log what clients pay you and what the business costs, and it works out your profit for each estimated-tax period, what to pay by each due date, how much to set aside each month, and whether each 1099 matches your own records.
Made for US freelancers, contractors, creators and side-hustlers who pay estimated taxes four times a year. The Q4 payment for 2026 is usually due in mid-January; the workbook starts fresh for the 2027 tax year (change the year on Setup to track any other year).

WHAT'S INSIDE (8 tabs)
- Start Here: three steps, one color rule (yellow cells are where you type) and quick answers
- Setup: tax year, currency, your own tax rates, the estimate method, the four periods and due dates (prefilled with the usual IRS calendar, editable), up to 40 clients with the form you expect, and 30 expense categories with a deductible %
- Income: 1,500 rows for payments received, with platform fees; month and quarter worked out from the date
- Expenses: 1,500 rows with category and an optional business % for costs that are only partly business
- Quarterly Taxes: income, expenses and profit per period, federal and state amounts due by each date, a log of the payments you made, what's still open and a Paid / Due soon / Overdue status
- Monthly Summary: every month's profit, a set-aside suggestion, what you actually set aside and your tax savings balance
- 1099 Tracker: for each client, what your records say they paid vs the amount on the form they send, with Matches / Differs by / Waiting
- Dashboard: income, expenses, profit, estimated tax, next payment, tax paid, savings balance, 1099s received and 2 charts

HOW IT WORKS
1. Set up once: tax year, your own rates (from your tax professional or last year's return), the due dates and your clients.
2. Record as you go: income, expenses and every estimated tax payment.
3. Pay on time: Quarterly Taxes shows what to pay by each due date. In January, check each 1099 against your records.

WHAT MAKES IT DIFFERENT
- Your rates, not ours: no tax rate is built in. You type a self-employment rate and the income tax rates that apply to you, so nothing goes stale when rules change.
- Two ways to estimate: "As I earn" (tax on your profit so far, minus what you already paid) or "Equal quarters" (a quarter of yearly amounts you type, for example a safe-harbor figure).
- Platform fees handled: type the gross and the fee; profit uses the net, the 1099 check uses the gross.
- A 1099 check per client: spot a wrong form before you file.
- Works the same everywhere: every formula was tested in LibreOffice with a filled sample year and uses only functions that Excel and Google Sheets share. No macros, nothing locked.

FILE FORMAT
You receive one ZIP file containing:
- Freelancer_Quarterly_Tax_Tracker.xlsx (Excel 2010 or later, Excel for Mac, LibreOffice)
- Quick_Start_Guide.pdf (6 pages, with a worked example)
Google Sheets: upload the .xlsx to Google Drive, open it with Google Sheets, then File > Save as Google Sheets. Formulas and dropdowns carry over; Google redraws the charts, so they may look slightly different.
Apple Numbers can open the file but is not supported.
The sample business and amounts in the photos are invented.

Digital download, nothing is shipped.

Because this is a digital file, returns and exchanges aren't accepted. If something isn't working, message me and I'll help put it right.

Not tax advice. The workbook estimates from the rates and amounts you type; it doesn't know your full tax situation and doesn't file or pay anything. Confirm amounts and dates with your tax professional and current IRS and state rules.

Designed by WrenWorks with AI assistance.