Free funded trader tax kit

Updated October 26, 2026

One spreadsheet to keep your prop firm taxes organized all year: every payout, every trading cost and every tax payment, with your set-aside worked out and a checklist for tax time. Free, no sign-up.

Download the tax kit (.xlsx)

Opens in Excel, Google Sheets (File → Import) and Apple Numbers. Nothing to install, no macros.

What's inside

• Payouts: date, firm and amount of every payout, including firms that don't send a 1099-NEC.
• Trading costs: evaluations, resets, activation fees, data and platforms, with a column to tick off the receipt.
• Tax payments: federal and state estimated payments with confirmation numbers, by tax year.
• Summary: totals for the year, net profit, your set-aside and what's not paid in yet, plus the year-end checklist.

How to use it

1. Run your numbers in the free calculator. It shows "From each new payout, set aside about …%".
2. Type that percentage into the green cell on the Summary tab.
3. Log each payout the day it lands and move the set-aside to a separate account.
4. Log each trading cost and tax payment as you make it.

Year-end checklist

• Every payout logged, from every firm, even with no 1099-NEC
• Each 1099-NEC matches your log for that firm
• Every trading cost logged with its receipt saved
• Estimated payments listed with confirmation numbers
• January 15 payment made, or W-4 withholding raised in December
• W-2s collected (yours, and your spouse's if you file jointly)
• Last year's return on hand, for the safe-harbor rule
• Questions for your CPA written down (see what to bring your CPA)

Want it done for you?

A PayoutTax account does the same tracking without the spreadsheet: it updates your set-aside, next due date and W-4 option after every payout. 3-day free trial, then $19 a year.

The kit is a planning tool, not tax advice. Confirm with a CPA. PayoutTax is not affiliated with any prop firm.