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.

Download Excel template (.xlsx) 92 KB · no macros · Excel 2016+ and Google Sheets · v1.0, 3 Nov 2026

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.

Preview: the Example tabs for a fictional employee in 2026: age 52, $180,000 salary paid biweekly, a $20,000 bonus on paycheck 6, and a 20% election (14% pre-tax, 6% Roth). The match is 100% of the first 4% of pay plus 50% of the next 2%, figured each paycheck with no true-up. Every number comes from the file.
$32,500deferral limit: $24,500 + $8,000 catch-up
Paycheck 21 of 26limit reached on 16 Oct 2026
$1,731match missed: $8,269 paid vs $10,000 on the annual formula
16.25%election that maxes out evenly (16% in whole %)
Example Paycheck log (fictional): employee deferral and employer match for each of 26 biweekly paychecks. Regular paychecks defer $1,384.62 and earn $346.15 of match; paycheck 6 with the bonus defers $5,384.62; paycheck 21 defers $807.60 and reaches the $32,500 limit; paychecks 22 to 26 defer $0 and earn $0 match.Your deferralEmployer match$0$1,000$2,000$3,000$4,000$5,000$6,0001611162126limit reachedPaycheck #
#Pay datePayPre-taxRothof which catch-upYTD deferralsEmployer matchStatus
1212 Jun 2026$6,923.08$969.23$415.39$0.00$20,615.44$346.15Paid
1326 Jun 2026$6,923.08$969.23$415.39$0.00$22,000.06$346.15Paid
1410 Jul 2026$6,923.08$969.23$415.39$0.00$23,384.68$346.15Paid
1524 Jul 2026$6,923.08$780.72$603.90$269.30$24,769.30$346.15Paid
167 Aug 2026$6,923.08$0.00$1,384.62$1,384.62$26,153.92$346.15Paid
1721 Aug 2026$6,923.08$0.00$1,384.62$1,384.62$27,538.54$346.15Paid
184 Sep 2026$6,923.08$0.00$1,384.62$1,384.62$28,923.16$346.15Paid
1918 Sep 2026$6,923.08$0.00$1,384.62$1,384.62$30,307.78$346.15Paid
202 Oct 2026$6,923.08$0.00$1,384.62$1,384.62$31,692.40$346.15Paid
2116 Oct 2026$6,923.08$0.00$807.60$807.60$32,500.00$346.15Paid · Limit reached
2230 Oct 2026$6,923.08$0.00$0.00$0.00$32,500.00$0.00Paid
2313 Nov 2026$6,923.08$0.00$0.00$0.00$32,500.00$0.00Planned · Stopped: limit reached
2427 Nov 2026$6,923.08$0.00$0.00$0.00$32,500.00$0.00Planned · Stopped: limit reached
2511 Dec 2026$6,923.08$0.00$0.00$0.00$32,500.00$0.00Planned · Stopped: limit reached
2625 Dec 2026$6,923.08$0.00$0.00$0.00$32,500.00$0.00Planned · Stopped: limit reached

Paychecks 12–26 of the Example Paycheck log. The workbook also draws deferrals and match by paycheck as a native chart on the Planner tab.

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 limit20252026Applies to
Elective deferrals, 402(g)$23,500$24,500Pre-tax + Roth, all your plans combined
Catch-up, age 50+$7,500$8,000Age 50 or over on 31 December
Catch-up, age 60–63 (SECURE 2.0)$11,250$11,250Turn 60, 61, 62 or 63 in the year; replaces the 50+ amount
Most you can defer, age 50–59 or 64+$31,000$32,500402(g) + catch-up
Most you can defer, age 60–63$34,750$35,750402(g) + higher catch-up
Annual additions, 415(c)$70,000$72,000Your deferrals (not catch-up) + employer money, per employer; also capped at 100% of pay
Pay that counts, 401(a)(17)$350,000$360,000Pay above this earns no match
Roth catch-up wage threshold$145,000$150,000Prior-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

TabWhat you typeWhat it calculates
Start hereNothingSteps, the rules used, colour key, limits, disclaimer
PlannerPlan 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/NYour 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 logOnly what differs: pay date, pay (bonus or raise), a new pre-tax or Roth % from that paycheck on, and paystub deferrals and match once paid60 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 logAlready filledThe fictional employee above, with paystub amounts typed for the 22 paychecks paid by 30 Oct 2026
IRS limitsNext year's row when the IRS publishes it2025 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

  1. 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.
  2. 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).
  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.
  4. 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.
  5. After each payday, copy the pre-tax deferral, Roth deferral and employer match from your paystub into that row.
  6. 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

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.

FieldFormula
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.

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

Limits of this template

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

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.