Which college expenses support a credit, a 529 withdrawal or neither?
Record actual payments, restricted tax-free support and student-specific allocations before comparing benefits. Keep AOTC, LLC and 529 expense definitions distinct. Reconcile forms to records rather than turning a form box into a credit. Reviewed 2025-2026 credit estimates are optional; 2027 is allocation-only.
College expense worksheet: 2026
Manual postsecondary expense allocation for one U.S. resident claimant return, not a filed credit or 529 tax calculation. Independently review eligible institutions, dependency/claimant rights, payment timing, all tax-free support and restrictions. No scholarship taxability optimization, student income/kiddie tax, Coverdell, refunds, recapture, state rules or 529 earnings taxation. Credit estimates cover reviewed 2025-2026 facts only; 2027 is allocation-only pending year-specific review. Do not enter SSNs, account numbers or real student names.
Entered assumptions and records
- Scope
- Manual postsecondary expense allocation for one U.S. resident claimant return, not a filed credit or 529 tax calculation. Independently review eligible institutions, dependency/claimant rights, payment timing, all tax-free support and restrictions. No scholarship taxability optimization, student income/kiddie tax, Coverdell, refunds, recapture, state rules or 529 earnings taxation. Credit estimates cover reviewed 2025-2026 facts only; 2027 is allocation-only pending year-specific review. Do not enter SSNs, account numbers or real student names.
- Source review date
- 2026-11-09
- Tax year / status
- 2026 / single
- Credit estimate / MAGI / remaining tax / refundable review
- false / not entered / not entered / unreviewed
- Scope / records / claimant reviewed
- false / false / false
- Student A: credit / prior AOTC years / actual current-year claim
- none / not entered / unreviewed
- Student A: history / undergrad / half-time / other AOTC / LLC reviews
- false / false / false / false / false
- Student A: room/board aggregate cap / reviewed
- not entered / false
Plans on this device
Current rule identifier: education.2026-11-09.r1. Public rule and scope change log. Rule identifiers are distinct from compatibility dates; no earlier source review or equivalent result is inferred.
Primary sources and independent next review
Sources checked 2026-11-09. Linked Pub. 970 and Form 8863 are the 2025 editions, including Pub. 970's 2026 identification update. Review applicable final-year forms before filing. This worksheet does not decide scholarship taxability or compute a student's tax.
- IRS Publication 970 (2025), chapters 1-3 and 7; 2026 identification update
- IRS Form 8863 instructions (2025), qualifications and credit coordination
- IRS Form 8863 (2025), per-student AOTC and return-wide LLC
college expense allocation worksheet
Quick answer
Assign each paid expense once among restricted support, one selected student credit, 529 and unused expenses. Reconcile tax documents separately and apply return-wide limits only once.
Also answers
- 529 and AOTC allocation
- 1098 T 1099 Q reconciliation
- education benefit expense ledger
Good fit when
- Semester payment records by student
- Avoiding education-benefit double use
- Reconciling school and 529 forms
Have ready
- Student eligibility and actual prior AOTC claim history
- Dated expenses, academic periods and tax-free support restrictions
- Explicit allocations, source documents and reviewed claimant facts
Result you get
Per-student and return totals, no-double-use validation, document differences and optional supported-year credit estimates; no 529 earnings tax.
How this calculation works
- Keep separate students, payment dates, academic-period starts, expense categories, restricted support and source-document aliases. Do not enter real names, Social Security or account numbers.
- Require each expense's tax-free support, AOTC, LLC, 529 and unallocated shares to reconcile to its paid amount. Support restrictions and used support totals are checked independently.
- Required tuition/fees, course materials, 529-only computers and room/board do not have interchangeable eligibility. Room/board allocations require half-time review and a single aggregate eligible cap.
- Compare 1098-T tuition/scholarship fields and 1099-Q distributions/earnings with the actual ledger. Differences are prompts for review, not automatically taxable distributions or deductible expenses.
- Optional supported-year credits use per-student AOTC, a single return-wide LLC expense ceiling and remaining household nonrefundable tax capacity. Refundable AOTC eligibility must be separately reviewed.
Common mistakes and caveats
- No scholarship taxability optimization, student tax/kiddie tax, Coverdell, refund/recapture, state benefit or 529 earnings-tax calculation. Do not silently assume excluded interactions are zero.
- Dependency, claimant rights, institution eligibility, timing and benefit restrictions need independent verification. A 1098-T amount alone does not establish qualified expenses.
- 2027 supports records and allocation only, not a final education-credit estimate. The linked 2025 instructions and their applicable updates do not certify final 2026/2027 filing forms.
- Rollover needs reviewed actual AOTC claim history, not an assumed claim because a prior scenario selected AOTC. New-year expenses, support, documents, amounts and confirmations reset.
FAQ
Can tuition support both a tax-free 529 withdrawal and AOTC?
Not the same dollars. Allocate qualified expenses after relevant tax-free support so one dollar is not assigned to two benefits. Other unused expenses may support a different benefit if its own rules are met.
Does every student get a separate $2,000 LLC ceiling?
No. The LLC ceiling is return-wide. This ledger aggregates the eligible LLC expense base before applying its limit and the household's available nonrefundable tax capacity.
Why does my 1098-T differ from the ledger?
A form is a source record, not a substitute for payment dates, expense types, scholarships and claimant facts. Reconcile the difference with school and payment records before selecting a benefit.
Does the worksheet calculate tax on 529 earnings?
No. Distributions and earnings are recorded for reconciliation. Recipient tax, taxable earnings and additional-tax exceptions require a separate supported withdrawal calculation and applicable instructions.
Last updated & sources
Last updated November 9, 2026.
TaxGuide Pro provides free state and federal tax calculators for individuals, freelancers, and small businesses.