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.

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.

Student 1: Student A

Use a label such as Student A, not a real name, SSN or school ID.

Actual credit history for next-year rollover

Dated actual expenses and explicit allocations

Assign each paid dollar once: tax-free support below + AOTC + LLC + 529 + unallocated must equal the paid amount. Loans and gifts are not tax-free educational assistance. Use only actual payments in 2026, not billed balances. Credit academic periods can begin this year or January-March next year. Refunds and prior-year adjustments need independent review before using this model.

Paid expenses, benefit allocation and separate 529 review
Receipt aliasPaid dateAcademic startCategoryPaid amountAOTC allocationLLC allocation529 allocationUnallocated529 / room reviewRemove

Independently total applicable school cost-of-attendance allowances by living arrangement; consider actual school-owned housing charges where permitted. Do not repeat an allowance for each receipt.

Room/board never supports a credit here. AOTC can include needed course materials bought elsewhere; LLC materials must be required to be paid to the institution. Every 529 allocation needs its own eligibility and same-year review, including required materials or qualifying computer use. This ledger does not calculate taxable 529 earnings.

Tax-free support and restrictions

Enter only independently confirmed tax-free scholarships, employer assistance or other tax-free educational support. Apply the full recorded amount to specific receipts. The restrictions below record permitted categories, not a decision that a scholarship is tax-free. Taxable awards, excess aid, Coverdell coordination and changes in scholarship treatment need a separate review.

Actual tax document totals: 2026

For 1098-T enter boxes 1 and 5; for each 1099-Q enter actual gross distribution and earnings. Use a document alias, not a payer or account identifier. These amounts reconcile records; they never automatically populate credit expenses, MAGI or taxable earnings. Missing forms or exceptions need independent review.

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.

Separate supported-scope 529 withdrawal review

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.

TaxGuide Pro provides free state and federal tax calculators for individuals, freelancers, and small businesses.