Parents and carers know this pattern well: the school term brings a stream of small payments, uniforms, excursions, canteen top-ups, and a camera roll full of confirmation screenshots to match. To turn them into expense entries, group the screenshots by purpose first and by date second. The purpose is what you will want to see at the end of term.
Why group by purpose
A school-term expense is not interesting as a date. It is interesting as a purpose: how much went on uniforms, how much on excursions, how much on the canteen. If you enter rows in date order, you must regroup later. If you sort the screenshots into purpose folders first, the totals fall out as you go.
Setting up the folders
- Make one folder for each purpose: Uniform, Excursions, Canteen, Books and supplies, Other.
- Move each screenshot into its folder as you open it.
- Open each folder in turn and enter its rows in your sheet.
- Total each folder and add the totals for the term.
- Keep any screenshot that shows a reference number someone might ask for.
A worked example in Australian dollars
Say one term's screenshots, invented for illustration, sort like this.
| Purpose | Screenshots | Amounts | Total |
|---|---|---|---|
| Uniform | 3 | A$45.00, A$62.50, A$18.00 | A$125.50 |
| Excursions | 2 | A$35.00, A$28.00 | A$63.00 |
| Canteen top-ups | 4 | A$20.00 each | A$80.00 |
| Books and supplies | 2 | A$41.20, A$16.80 | A$58.00 |
The term's total is 125.50 plus 63.00 plus 80.00 plus 58.00, which is A$326.50. Over thirteen screenshots, that is a manageable figure, and you can now see that the canteen cost A$80.00 across four top-ups. If you wanted to change one thing next term, this is the table that would tell you where to look.
What if two screenshots look the same?
Four canteen top-ups of A$20.00 are not duplicates. They are four payments on four dates. The test is the date and time on the screenshot, not the amount. If the screenshot has no time on it, look at your bank record for the same day.
What about payments made on behalf of someone else?
Sometimes you pay for a relative's child, or a friend pays you back. Enter your own payment as the expense and record the repayment separately as money received. Do not reduce the expense by the repayment, or your month will look cheaper than it was. A note saying "repaid on 12 Aug" is enough.
Do I need to keep the screenshots afterwards?
Keep the ones that prove a payment you could be asked about, such as a deposit for a camp or a fee. The rest can go once the row is entered and checked against your statement. If you are unsure, keep screenshots for the term and clear them when the next one begins.
Spreading the work across the term
Do not wait until the term ends. Each time a payment screenshot arrives, drop it into its purpose folder straight away. At the end of each fortnight, spend five minutes entering that fortnight's rows. By the end of the term, the sheet is already complete and the only job left is to check the total against the statement.
Sharing the job with a partner
If two adults pay school costs, agree which of you enters the rows. Both of you can drop screenshots into the same folder, but only one person should type them in, otherwise the same payment is entered twice. Say who paid in a notes column so that the record shows both.
A short checklist for the end of term
- Every screenshot has been filed in a purpose folder and entered.
- Each purpose has a total, and the totals add up to the term's figure.
- The term's figure agrees with your statement for the same dates, or the gap is written down.
- Screenshots with account details have been cropped or deleted.
- One idea noted for next term, based on the biggest purpose.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

