Education expense and funding spreadsheets

Keep the document trail with each amount

Start with invoices, account statements, payment dates and supporting records. A college charge, a payment to the school and a withdrawal from a savings account may refer to the same cost, but they are not the same transaction.

A 529 expense record is different from a savings projection. The first organizes what happened and how amounts were matched; the second estimates balances under assumptions. Do not use a forecast as evidence that a particular expense qualifies.

Check current IRS guidance and applicable plan rules before making tax decisions. Avoid assigning the same expense to multiple funding or tax purposes without resolving the relevant restrictions. The workbook’s scope and manual review fields matter as much as whether the totals reconcile.