
Annual Report
Docs + Word6 pages
FeaturedFree
Employees with more than one job and freelancers who work with several clients use this W-2 and 1099 form tracker to know what to expect. The Forms tab lists each payer, form type, deadline, receipt date, status, amount and saved path. The Follow-ups tab logs each time you chase a form. The Dashboard counts forms by type, shows how many are late and totals income on the forms already in hand.
In January, add a row for every payer who paid you. Mark each form Waiting, then switch it to Received when it comes and save its location. If a deadline passes, switch to Late and log the call or email on the Follow-ups tab. Compare the amount on each form with your own income records before you file.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Forms tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
Employers and payers have a deadline to send most forms near the end of January. Brokers and some partnerships send later. Check IRS guidance for the exact dates each year, and list them as the payer's deadline in the sheet.
Contact the payer first, and log the contact. Note what you were paid in your own files, since you still report the income. A tax professional can advise if the form never arrives.
Think of every job, client, bank, brokerage and benefit that paid you in the year. Last year's return is a good guide. Add a row for each, then update the status as forms arrive.

Docs + Word6 pages
FeaturedFree
Excel
FeaturedFreeSheets + Excel6 tabs
Free