
Annual Report
Docs + Word6 pages
FeaturedFree
Many schools let families spread tuition across monthly installments. The Terms tab holds every term with its tuition and fees, grants and aid, any plan fee and the number of installments. The sheet works out the total to pay and the amount of each installment. The Payments tab lists every installment with its date, term, number, method and a status of Paid, Scheduled or Late.
The Balance tab shows the total to pay, what has been paid, the balance left plus any late installments, with a chart of the total against the paid amount for each term. Sample entries show a fall term nearly paid, with a late final installment, and spring and summer terms still scheduled. Swap them for the plan your school bursar gave you.
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 Terms 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.
List each term with its total, then add one row per installment with the date and amount. Mark each Paid when it clears and the Balance tab shows what remains.
Yes. Enter grants and aid for each term and the total to pay is tuition minus aid plus any plan fee.
Update the Terms row, then change the affected installment amounts on the Payments tab to match the new schedule.

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