1099 tracker spreadsheet
Log every payment at gross, by payer, the day it arrives. In January, checking the forms takes minutes instead of a weekend.
Why track by payer
The IRS receives a copy of every 1099 sent to you and matches it with your return. If a client's 1099-NEC says 6,000 and you can only find 5,400 in your bank, you need to know why before you file. Tracking income by payer, at the same gross amounts the forms use, makes that check simple.
What to log for each payment
- Date received
- Payer: the client, app or marketplace
- How you were paid: transfer, check, card, app
- Gross amount: before any fee
- Fees taken by the platform or processor
- Refunds or chargebacks
- Net deposited in your bank
- Personal? A flag for money that is not business income, like a friend paying you back
Example with made-up numbers
Mar 3 · Client A · transfer · gross 2,000 · fees 0 · net 2,000
Mar 9 · Etsy · payout · gross 1,240 · fees 132.60 · refunds 45 · net 1,062.40
Mar 12 · Venmo · friend repaid dinner · 60 · personal
Gross vs net
Payment platforms report gross. Your bank shows net. If you log only what reaches the bank, your income will look lower than the 1099-K and the difference will be hard to explain. Log gross, and record fees and refunds as their own columns: they become deductions on Schedule C.
The January reconciliation
- List the forms you expect from each payer (1099-NEC from clients paying $2,000 or more by transfer or check; 1099-K from platforms over the federal limits or your state's).
- As each form arrives, enter its amount next to your total for that payer.
- Look at the difference. Common reasons: a payment sent in late December and received in January, a refund, a payment made through a platform that the client also put on a 1099-NEC, or personal money mixed in.
- Ask for a corrected form if the payer made a mistake.
- Note payers that did not send a form. The income is still reported.
What goes on Schedule C
Line 1 gets gross receipts: everything you were paid for the business, with or without a form. Line 2 gets returns and allowances (refunds). Platform and processing fees are expenses; many people put them under commissions and fees. Any backup withholding shown on a 1099 is claimed as tax already paid.
Habits that help
- Use one bank account and one payment app profile for business only.
- Update the tracker weekly, not in April.
- Download each platform's annual sales report in early January; it shows the same gross figures the 1099-K uses.
Use the free Will I get a 1099? checker to see which form each payer should send. For the rules behind each form, see 1099-NEC vs 1099-K, and for invoices still unpaid, the freelance invoice tracker.
Frequently asked questions
How do I keep track of 1099 income?
Log every payment by payer with the date, gross amount, fees, refunds and net deposit. Then compare each 1099 with your total for that payer in January.
Should I record income gross or net of fees?
Gross. Platforms report gross on 1099-K, and fees are deducted separately on Schedule C. Recording only net makes your income look lower than the forms.
What if I did not receive a 1099 from a client?
Report the income anyway. A missing form does not make the income tax-free, and your own records are what you file from.
General information, not financial, tax or legal advice. Examples use made-up numbers.
1099-K / 1099-NEC Income Reconciler 2027
Match every 1099 with what you were actually paid, payer by payer, and get Schedule C line 1 ready.