Student Loan and Finance Record

Who this is for

Every instalment of student funding in one place. Loans, grants, bursaries and scholarships are listed term by term with the date and amount you were told to expect beside what actually arrived, so a late or short payment is spotted early.

Students funded from more than one source who want to know what has come in, what is still to come and whether any payment has gone missing.

What this helps you track

• Each instalment expected from each funding source, by term
• The date and amount that actually reached your account
• Any payment that arrived short, late or not at all
• What has been received so far and what is still expected for the year

How to use it

1. Write your name, the academic year, the funding body and your customer reference at the top.
2. From your funding letters, list every instalment you have been told about in term order, with the term, its expected date and amount.
3. When money arrives, fill in the date and the amount received from your bank statement.
4. The difference per line, the running total received and the summary are worked out in the browser and the workbook; on paper, subtract across and add down.
5. Chase any line with a gap or a negative difference with the body that pays it, and note the reference you are given.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

Does it work out interest or repayments?

No. It only records money coming in. It carries no interest rates, repayment thresholds or loan terms; those come from whoever lent the money and the rules where you are, and they change from year to year.

Why record the term on each line?

Most funding is paid in instalments tied to terms. Listing lines in term order means the running total shows how much had arrived by the end of each term. If your course pays differently, use Other and note the period.

What does a negative difference mean?

Received minus expected, so a negative figure means less arrived than you were told to expect. Check whether a deduction, an overpayment recovery or a change of circumstances explains it before contacting the funder.

Can I include money from family or a job?

Yes, use the Other source for regular family support or anything else you rely on. Wages are better kept in a separate hours and pay log so this sheet stays a record of funding.