Home › Templates › 401(k) contribution tracker
401(k) Contribution Tracker Spreadsheet
A free 401(k) contribution tracker and paycheck planner for Excel and Google Sheets. Type your pay, pay frequency, pre-tax and Roth percentages and your employer's match formula. It logs every paycheck's deferral against the 2025 or 2026 IRS limit, adds the right catch-up for your age, applies the Roth catch-up rule, checks the 415(c) total limit, shows the percentage you need to max out, and warns you when you will hit the limit early and lose match.
Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up and no account link: you type the numbers from your pay settings and paystubs.
US plans only. Federal limits for 401(k) plans (the same deferral limits apply to 403(b) and governmental 457 plans). Your plan can set lower limits and its own match rules. No tax estimate.
| # | Pay date | Pay | Pre-tax | Roth | of which catch-up | YTD deferrals | Employer match | Status |
|---|---|---|---|---|---|---|---|---|
| 12 | 12 Jun 2026 | $6,923.08 | $969.23 | $415.39 | $0.00 | $20,615.44 | $346.15 | Paid |
| 13 | 26 Jun 2026 | $6,923.08 | $969.23 | $415.39 | $0.00 | $22,000.06 | $346.15 | Paid |
| 14 | 10 Jul 2026 | $6,923.08 | $969.23 | $415.39 | $0.00 | $23,384.68 | $346.15 | Paid |
| 15 | 24 Jul 2026 | $6,923.08 | $780.72 | $603.90 | $269.30 | $24,769.30 | $346.15 | Paid |
| 16 | 7 Aug 2026 | $6,923.08 | $0.00 | $1,384.62 | $1,384.62 | $26,153.92 | $346.15 | Paid |
| 17 | 21 Aug 2026 | $6,923.08 | $0.00 | $1,384.62 | $1,384.62 | $27,538.54 | $346.15 | Paid |
| 18 | 4 Sep 2026 | $6,923.08 | $0.00 | $1,384.62 | $1,384.62 | $28,923.16 | $346.15 | Paid |
| 19 | 18 Sep 2026 | $6,923.08 | $0.00 | $1,384.62 | $1,384.62 | $30,307.78 | $346.15 | Paid |
| 20 | 2 Oct 2026 | $6,923.08 | $0.00 | $1,384.62 | $1,384.62 | $31,692.40 | $346.15 | Paid |
| 21 | 16 Oct 2026 | $6,923.08 | $0.00 | $807.60 | $807.60 | $32,500.00 | $346.15 | Paid · Limit reached |
| 22 | 30 Oct 2026 | $6,923.08 | $0.00 | $0.00 | $0.00 | $32,500.00 | $0.00 | Paid |
| 23 | 13 Nov 2026 | $6,923.08 | $0.00 | $0.00 | $0.00 | $32,500.00 | $0.00 | Planned · Stopped: limit reached |
| 24 | 27 Nov 2026 | $6,923.08 | $0.00 | $0.00 | $0.00 | $32,500.00 | $0.00 | Planned · Stopped: limit reached |
| 25 | 11 Dec 2026 | $6,923.08 | $0.00 | $0.00 | $0.00 | $32,500.00 | $0.00 | Planned · Stopped: limit reached |
| 26 | 25 Dec 2026 | $6,923.08 | $0.00 | $0.00 | $0.00 | $32,500.00 | $0.00 | Planned · Stopped: limit reached |
2025 and 2026 401(k) limits (IRS)
These are the figures in the IRS limits tab. They come from Notice 2024-80 (2025) and Notice 2025-67 (2026), and match the IRS COLA table. The IRS announced 2026 in IR-2025-111: "the amount individuals can contribute to their 401(k) plans in 2026 has increased to $24,500, up from $23,500 for 2025."
| IRS limit | 2025 | 2026 | Applies to |
|---|---|---|---|
| Elective deferrals, 402(g) | $23,500 | $24,500 | Pre-tax + Roth, all your plans combined |
| Catch-up, age 50+ | $7,500 | $8,000 | Age 50 or over on 31 December |
| Catch-up, age 60–63 (SECURE 2.0) | $11,250 | $11,250 | Turn 60, 61, 62 or 63 in the year; replaces the 50+ amount |
| Most you can defer, age 50–59 or 64+ | $31,000 | $32,500 | 402(g) + catch-up |
| Most you can defer, age 60–63 | $34,750 | $35,750 | 402(g) + higher catch-up |
| Annual additions, 415(c) | $70,000 | $72,000 | Your deferrals (not catch-up) + employer money, per employer; also capped at 100% of pay |
| Pay that counts, 401(a)(17) | $350,000 | $360,000 | Pay above this earns no match |
| Roth catch-up wage threshold | $145,000 | $150,000 | Prior-year FICA wages from the plan sponsor; 2025 was a transition year |
The IRS usually publishes next year's limits in the autumn. When it does, add a row on the IRS limits tab and pick that year on the Planner. No figures for 2027 are in the file, because none had been published on 3 November 2026.
What's inside the spreadsheet
| Tab | What you type | What it calculates |
|---|---|---|
| Start here | Nothing | Steps, the rules used, colour key, limits, disclaimer |
| Planner | Plan year, age on 31 Dec, annual pay, pay frequency, first pay date, pre-tax %, Roth %, catch-up allowed, last year's FICA wages, deferrals in other plans, as-of date; match tiers (up to 3), nonelective %, true-up Y/N | Your limits (402(g), catch-up type and amount, 415(c), 401(a)(17), Roth catch-up), projected year-end deferrals split pre-tax / Roth / catch-up, even % to max out, whole-% election, % for the full match, % needed on the paychecks left, the paycheck and date you hit the limit, match per paycheck vs the annual formula, true-up or match missed, 415(c) room, front-loading and excess-deferral warnings, a native chart |
| Paycheck log | Only what differs: pay date, pay (bonus or raise), a new pre-tax or Roth % from that paycheck on, and paystub deferrals and match once paid | 60 rows (52 weekly + extras): pay date, pay, elected deferral, deferral after the limit, catch-up portion, pre-tax and Roth, YTD, room left, pay counted for match, match, nonelective, YTD 415(c) additions, paid or planned, limit notes, a Check column |
| Example Planner, Example Paycheck log | Already filled | The fictional employee above, with paystub amounts typed for the 22 paychecks paid by 30 Oct 2026 |
| IRS limits | Next year's row when the IRS publishes it | 2025 and 2026 limits with their sources |
A paystub amount, once typed, replaces the plan for that paycheck, so the year-end projection is always "actual so far + plan for the rest". The Check column flags bad entries, paystub deferrals above pay, pre-tax catch-up when it must be Roth, and deferrals above your limit.
How to use it
- On Planner, pick the plan year and type your age on 31 December, the annual pay your plan counts, your pay frequency and the first pay date of the year.
- Type your pre-tax and Roth percentages. If you already deferred money in another employer's plan this year, type the total. Type last year's FICA wages from this employer (W-2 box 3).
- Type the match as tiers. "100% up to 4%, then 50% of the next 2%" is tier 1 rate 100% on 4%, tier 2 rate 50% on 2%. Set true-up to Y only if your plan document says the match is trued up after year-end.
- On Paycheck log, add a bonus to the pay of the paycheck it comes with, and type a new percentage on the paycheck where an election change starts.
- After each payday, copy the pre-tax deferral, Roth deferral and employer match from your paystub into that row.
- Read the Planner results. If the front-loading warning is red, lower your election to the whole % it suggests (if that still gets the full match), or ask HR whether the plan trues up.
How the limits work
- One limit for pre-tax and Roth. The IRS designated Roth FAQs say "the combined amount contributed to all designated Roth accounts and traditional, pre-tax accounts in any one year for any individual is limited (under IRC Section 402(g))."
- All your plans count. The IRS 401(k) limits page says: "Generally, you aggregate all elective deferrals you made to all plans in which you participate to determine if you have exceeded these limits."
- Catch-up, age 50+. The IRS catch-up page: "Individuals who are age 50 or over at the end of the calendar year can make annual catch-up contributions." Deferrals "are not treated as catch-up contributions until they exceed the limit of $24,500 in 2026", so the sheet counts as catch-up only what goes above the base limit.
- Age 60–63. The same page: "a higher catch-up contribution limit applies for employees who turn 60, 61, 62, and 63 in a calendar year starting in 2025 ... For 2026, this higher catch-up contribution limit is $11,250 (instead of $8,000)." The sheet uses your age on 31 December to pick the amount.
- Roth catch-up for higher earners. Notice 2025-67: the threshold that decides whether catch-up contributions for 2026 "must be designated as Roth contributions, is increased from $145,000 to $150,000." It is measured on the prior year's FICA wages from the employer sponsoring the plan (T.D. 10033, IRB 2025-40). The IRS catch-up page: "Beginning in 2026, participants of plans with Roth features offering catch-up contributions must make catch-up contributions on a Roth basis if prior-year wages with the plan sponsor exceeded $150,000 (for 2026)." The final regulations "generally apply to contributions in taxable years beginning after Dec. 31, 2026", with good-faith compliance allowed before then.
- 415(c) total additions. The IRS limits page: annual additions "cannot exceed the lesser of: 100% of the participant's compensation, or $72,000 in 2026 ($80,000 including catch-up contributions or up to $83,250 for those age 60 to 63)". Additions are your deferrals (not catch-up), employer match, employer nonelective contributions and forfeitures.
- Pay that counts. "The amount of your compensation that can be taken into account when determining employer and employee contributions is limited to $360,000 for 2026." The sheet stops counting pay for the match once year-to-date pay reaches it.
Front-loading and the missing match
Many plans figure the match on each paycheck: the tiers are applied to what you defer from that paycheck's pay. If a high election or a bonus takes you to the limit before the last payday, payroll stops your deferrals, and the per-paycheck match stops with them. Some plans add a true-up after year-end that tops the match up to what the annual formula gives. Others do not. The IRS pages above do not set this rule; your plan document and summary plan description do.
The Planner works out the match both ways. Per paycheck adds the match from each row. Annual formula applies the same tiers to the year's total pay (capped at the 401(a)(17) limit) and total deferrals. The difference is the true-up if your plan has one, or the match you miss if it doesn't. The fix is usually a lower, even election: the Planner shows the percentage that maxes out exactly on the last paycheck and the whole % below it. Check that it is still at or above the "% needed for the full match".
The formulas, explained
Exact formulas from the blank tabs (first data row). On the Paycheck log, L is pay used, M and N the pre-tax and Roth % used, O the elected deferral, P YTD deferrals before this paycheck, F and G paystub amounts. 'Planner'!$B$32 is the limit left for this plan, $B$31 the base limit left.
| Field | Formula |
|---|---|
| Planner B29: catch-up amount (60-63 replaces 50+) | =IF(LEFT(Planner!$B$28,6)="Age 60",IFERROR(INDEX('IRS limits'!$D$5:$D$10,MATCH(Planner!$B$4,'IRS limits'!$A$5:$A$10,0)),0),IF(LEFT(Planner!$B$28,7)="Age 50+",IFERROR(INDEX('IRS limits'!$C$5:$C$10,MATCH(Planner!$B$4,'IRS limits'!$A$5:$A$10,0)),0),0)) |
| Planner B32: deferral limit left for this plan | =MAX(0,Planner!$B$30-N(Planner!$B$13)) |
| Planner B38: catch-up must be Roth | =IF(AND(Planner!$B$29>0,Planner!$B$37="Yes",N(Planner!$B$12)>Planner!$B$36),"Yes","No") |
| Paycheck log Q8: deferral this paycheck (stops at the limit) | =IF(L8="","",IF(OR(F8<>"",G8<>""),N(F8)+N(G8),ROUND(MAX(0,MIN(O8,L8,MAX(0,Planner!$B$32-P8))),2))) |
| Paycheck log R8: catch-up portion | =IF(L8="","",ROUND(MAX(0,P8+Q8-Planner!$B$31)-MAX(0,P8-Planner!$B$31),2)) |
| Paycheck log T8: Roth this paycheck | =IF(L8="","",IF(OR(F8<>"",G8<>""),N(G8),ROUND((Q8-R8)*IF(M8+N8=0,0,N8/(M8+N8))+IF(Planner!$B$38="Yes",R8,R8*IF(M8+N8=0,0,N8/(M8+N8))),2))) |
| Paycheck log W8: pay counted for match (401(a)(17)) | =IF(L8="","",MIN(L8,MAX(0,Planner!$B$35-SUM(L$7:L7)))) |
| Paycheck log X8: employer match, per paycheck | =IF(L8="","",IF(H8<>"",N(H8),ROUND(W8*(N(Planner!$B$16)*MIN(IF(L8=0,0,Q8/L8),N(Planner!$B$17))+N(Planner!$B$18)*MIN(MAX(IF(L8=0,0,Q8/L8)-N(Planner!$B$17),0),N(Planner!$B$19))+N(Planner!$B$20)*MIN(MAX(IF(L8=0,0,Q8/L8)-N(Planner!$B$17)-N(Planner!$B$19),0),N(Planner!$B$21))),2))) |
| Planner B51: deferral % that maxes out evenly | =IF(N(Planner!$B$43)<=0,"",MIN(1,Planner!$B$32/Planner!$B$43)) |
| Planner B57: % needed on the remaining paychecks | =IF(SUMIFS('Paycheck log'!$L$8:$L$67,'Paycheck log'!$AE$8:$AE$67,0)<=0,"No paychecks left",MAX(0,Planner!$B$32-Planner!$B$56)/SUMIFS('Paycheck log'!$L$8:$L$67,'Paycheck log'!$AE$8:$AE$67,0)) |
| Planner B61: match by the annual formula | =ROUND(MIN(N(Planner!$B$43),Planner!$B$35)*(N(Planner!$B$16)*MIN(IF(N(Planner!$B$43)=0,0,Planner!$B$46/Planner!$B$43),N(Planner!$B$17))+N(Planner!$B$18)*MIN(MAX(IF(N(Planner!$B$43)=0,0,Planner!$B$46/Planner!$B$43)-N(Planner!$B$17),0),N(Planner!$B$19))+N(Planner!$B$20)*MIN(MAX(IF(N(Planner!$B$43)=0,0,Planner!$B$46/Planner!$B$43)-N(Planner!$B$17)-N(Planner!$B$19),0),N(Planner!$B$21))),2) |
| Planner B67: 415(c) annual additions | =Planner!$B$46-Planner!$B$49+Planner!$B$66 |
Match tiers. For a deferral rate d (deferral ÷ pay for that paycheck), match = pay counted × [rate1 × MIN(d, tier1) + rate2 × MIN(MAX(d − tier1, 0), tier2) + rate3 × MIN(MAX(d − tier1 − tier2, 0), tier3)]. At d = 0 after the limit, the match is $0.
Rounding. Pay per paycheck, deferrals and match are rounded to cents, as on a paystub, so the year's Roth total can differ from a hand calculation by a few cents.
Worked example (fictional)
The Example tabs show one employee in 2026. All names and amounts are made up.
- Limit. Age 52 on 31 December 2026, so the 50+ catch-up applies: $24,500 + $8,000 = $32,500. No other plan this year, so all $32,500 is available in this plan.
- Regular paycheck. $180,000 ÷ 26 = $6,923.08. At 20%, each paycheck defers $1,384.62: $969.23 pre-tax and $415.39 Roth. The match is 4% + 50% × 2% = 5% of pay, $346.15.
- Bonus. Paycheck 6 (20 Mar 2026) includes a $20,000 bonus, so pay is $26,923.08, the deferral $5,384.62 and the match $1,346.15.
- Catch-up. Paycheck 15 takes year-to-date deferrals past $24,500: $269.30 of it is catch-up. Last year's FICA wages were $172,000, above the $150,000 threshold, so every catch-up dollar goes to Roth. From paycheck 16, the whole deferral is Roth catch-up. The year ends with $17,149.94 pre-tax and $15,350.06 Roth, including $8,000.00 of catch-up.
- Limit reached. Paycheck 21 (16 Oct 2026) defers only $807.60, the room left, and year-to-date deferrals reach $32,500.00. Paychecks 22–26 defer nothing and get no match.
- Match. Per paycheck the employer pays $8,269.15. The annual formula gives 5% of $200,000.08 = $10,000.00. With no true-up, $1,730.85 of match is missed.
- The fix. $32,500 ÷ $200,000.08 = 16.25%. A 16% election (whole %) keeps deferrals going on every paycheck and is still above the 6% needed for the full match.
- 415(c). Additions are $32,500.00 − $8,000.00 catch-up + $8,269.15 employer = $32,769.15, well under the $72,000 cap.
The Planner's warning reads: “Warning: you reach the limit on paycheck 21 of 26 (16 Oct 2026). Match stops after that, and with no true-up you miss $1,731. An election of 16% spreads deferrals over the year.”
Common mistakes
- Counting only one job. The 402(g) limit is per person. After a job change, add what you deferred at the old employer, or you can go over.
- Rounding the election up. 16.25% rounded to 17% reaches the limit early. Round down.
- Forgetting the bonus. If your plan counts bonuses as pay, your election applies to them and can bring the limit forward by months.
- Adding the match to the $24,500. Employer money counts toward 415(c), not the deferral limit.
- Assuming catch-up can stay pre-tax. From 2026, higher earners' catch-up must be Roth. Check last year's W-2 box 3.
- Using the wrong age. Catch-up eligibility uses your age at the end of the calendar year, not on the payday.
Limits of this template
- One employer's plan at a time; deferrals in other plans are one number. No SIMPLE 401(k) limits, no after-tax (non-Roth) contributions, no forfeitures, no vesting schedule, no investment growth, no tax estimate.
- Your plan's rules decide the real numbers: its definition of pay, whether bonuses count, whole-% elections, whether catch-up is matched, true-up timing and plan-imposed limits for highly compensated employees.
- Catch-up is counted as deferrals above the base 402(g) limit, as the IRS describes. A plan that hits a plan limit or ADP test limit first can count it differently.
- Semi-monthly dates are the first pay date's day and the month end; type actual dates if yours differ. Up to 60 paycheck rows.
- Recalculated and cross-checked in LibreOffice; the functions also exist in Excel 2016+ and Google Sheets.
FAQ
What is the 401(k) contribution limit for 2026?
$24,500 of elective deferrals, up from $23,500 in 2025 (IRS news release IR-2025-111 and Notice 2025-67). Pre-tax and Roth deferrals share this one limit. If you are 50 or older by December 31 you can add an $8,000 catch-up ($32,500 in total), and if you turn 60, 61, 62 or 63 in 2026 the catch-up is $11,250 instead ($35,750 in total), if your plan allows catch-up contributions.
How do I calculate the 401(k) percentage I need to max out?
Divide the limit you have left by the pay still to come. For a full year: (402(g) limit + catch-up − deferrals in other plans) ÷ annual pay the plan counts. For example, $32,500 ÷ $200,000 = 16.25%. If your plan only takes whole percentages, round down (16%), not up, or you reach the limit before the last paycheck. The Planner shows both numbers and the % needed on the paychecks you have left.
What happens if I max out my 401(k) early?
Payroll stops your deferrals for the rest of the year. If your employer figures the match each paycheck and has no year-end true-up, it stops too, because there is no deferral to match. In the example, reaching the limit on paycheck 21 of 26 costs $1,731 of match. Plans with a true-up add the difference after year-end. Your plan document or summary plan description says which applies.
Does the 401(k) limit include the employer match?
No. The $24,500 limit (2026) is for your own deferrals only. Employer match and other employer contributions count toward a separate total limit, section 415(c): the lesser of 100% of your pay or $72,000 in 2026 ($70,000 in 2025). Catch-up contributions are on top of it: the IRS gives $80,000 including catch-up, or up to $83,250 for ages 60 to 63, for 2026.
Do I have to make catch-up contributions as Roth?
Under SECURE 2.0, if last year's FICA wages from the employer that sponsors the plan were above the threshold, your catch-up contributions must be Roth. For 2026 the threshold is $150,000 of 2025 wages (Notice 2025-67); for 2025 it was $145,000, but an administrative transition period ran until December 31, 2025. The final regulations generally apply from 2027, and plans can apply the rule in good faith before then. Check box 3 of last year's W-2 from your employer.
Do 401(k) limits apply per employer or per person?
The 402(g) deferral limit is per person: the IRS says you generally add up all elective deferrals to all plans you take part in. If you changed jobs this year, type what you deferred at the old job in the Planner. The 415(c) total additions limit applies to each employer's plans separately.
What if I contributed more than the 401(k) limit?
Tell the plan and ask for the excess deferral to be paid out. The IRS says the plan must pay it by April 15 of the following year. If it is not taken out by then, the excess is taxed twice: in the year you deferred it and again when it is distributed. The Paycheck log flags any row where paystub amounts go over your limit.
Can I use this 401(k) tracker in Google Sheets?
Yes. In Google Sheets choose File → Import → Upload and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. It uses only functions found in Excel 2016+ and Google Sheets (SUMIFS, INDEX/MATCH, EDATE, EOMONTH, ROUND, TEXT and the usual IF/AND/OR). No macros, no add-ons.
Related templates and tools
- Retirement planner spreadsheetWill your savings last?
- FIRE calculator spreadsheetYour financial independence number
- RSU and ESPP trackerEquity pay, vests and cost basis
- HSA tracker spreadsheetAnother tax-advantaged account
- DCA calculatorInvesting a fixed amount each paycheck
- All templatesFree spreadsheets
Educational template only, not tax, legal or investment advice. Limits are from IRS Notice 2024-80, Notice 2025-67, IRS news releases IR-2024-285, IR-2025-111 and IR-2025-91, T.D. 10033 and the IRS retirement topic pages, all retrieved on 3 November 2026. Rules and limits change, and your plan documents decide your case. The example employee and all example numbers are fictional.