
Annual Report
Docs + Word6 pages
FeaturedFree
Each child has a different college year and a different head start, so this tracker keeps them on separate rows. Beneficiaries holds the college start year, a savings goal, the opening balance, the amount you plan to add each year and the return you assume. It adds the deposits logged on Contributions, shows the balance now and the share of the goal, counts the years to go and projects the balance when college starts.
Projection blends all children into one line and shows money put in against projected balance for each of the next 18 years. The sample has an oldest child about ten years from college who is $24,600 short of a $90,000 goal at a 6 percent return. State plans differ in limits, fees and tax rules, so the sheet takes your assumptions and assumes nothing about them.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Beneficiaries tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
Record each deposit with its date, the child and who paid it. Add the opening balance when you start, and the total shows your balance from contributions. Your plan statement shows the market value.
It depends on the starting balance, yearly deposits, years to go and the return you assume. Enter them on the Beneficiaries tab and the projection updates; real returns will differ.
Many plans accept deposits from anyone, but rules and gift tax limits vary. Check your state plan and the IRS, and log the source in the From column.

Docs + Word6 pages
FeaturedFree
Excel
FeaturedFree
Sheets + Excel5 tabs
FreeSheets + Excel6 tabs
FreeSheets + Excel5 tabs
Free
Sheets + Excel6 tabs
FreeSheets + Excel6 tabs
Free
Sheets + Excel7 tabs
FreeSheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
FreeSheets + Excel5 tabs
FreeSheets + Excel6 tabs
Free
Sheets + Excel7 tabs
Free
Sheets + Excel5 tabs
Free