1099 Income & Expense Tracker + Quarterly Estimated Tax Calculator for Self-Employed Tradespeople (Excel + Google Sheets + Printable Checklist)

Self-employed and dreading tax time? This kit keeps your trade business income and expenses in one place all year, estimates how much to set aside each quarter, and hands your tax preparer clean totals.

The spreadsheet

• Income: 300 rows. Date, customer or payer, job, amount, and how you got paid.

• Expenses: 400 rows with 20 trade-friendly categories (supplies and materials, tools and equipment, contract labor, insurance, phone and internet share, and more) from a dropdown. Meals are counted at 50%.

• Category Totals: a year-end total for every category, a chart, and a check that flags anything left uncategorized.

• Income by Payer: totals by payer next to the 1099 amounts you receive, with the difference shown.

• Quarterly Taxes: profit by IRS estimate period, an estimated self-employment tax, your federal and state set-aside, and what you've already paid, with typical due dates (check irs.gov).

• Settings: set-aside percentages, standard mileage rate, and your yearly business miles.

The printable checklist (4 pages)

Tax-time document checklist, a quarterly payment tracker, habits that make April easy, questions to ask your preparer, and notes.

Works in Excel, Google Sheets and LibreOffice. Example entries are filled in so you can see how it works.

Not tax advice. This is an organizer and estimating tool. Tax rules, rates and due dates change. Check irs.gov and talk to a tax professional.