
Annual Report
Docs + Word6 pages
FeaturedFree
IRA deposits made in January through April can count toward the year before, which is why this tracker asks for a tax year on every row. The Deposits tab records the date, account, tax year, amount and method. The Limit tab holds the year, your yearly limit, any extra amount you qualify for and the deposit deadline, all typed in from IRS figures rather than built into formulas.
Progress compares what you have deposited for the chosen tax year with that limit and shows the room left, the share used and the days remaining. Two charts split deposits by account and by tax year. Sample rows show three early-year deposits for 2025 followed by monthly Roth deposits and two Traditional deposits for 2026.
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 Deposits 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.
Record each deposit by date, account and the tax year it counts toward. Sum them per tax year and set that sum against the limit for the same year. Brokerage statements confirm the totals.
The IRS allows deposits for the prior tax year until its filing deadline, usually in April. Mark such deposits with the earlier tax year so they count against the right limit. Confirm the dates with the IRS or a tax professional.
Extra deposits above the limit can trigger a tax penalty until they are corrected. Tracking the total per tax year helps you catch it early; ask your provider or a tax professional how to fix an excess deposit.

Docs + Word6 pages
FeaturedFree
Excel
FeaturedFree
Sheets + Excel5 tabs
FreeSheets + Excel6 tabs
FreeSheets + Excel6 tabs
FreeSheets + Excel5 tabs
Free
Sheets + Excel6 tabs
FreeSheets + Excel6 tabs
Free
Sheets + Excel7 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
FreeSheets + Excel5 tabs
FreeSheets + Excel6 tabs
Free
Sheets + Excel7 tabs
Free
Sheets + Excel5 tabs
Free