Family Planner Australia 2027: School Terms by State, Bills and Pocket Money (Excel and Google Sheets)

Term starts Wednesday. The school fees are due Friday. And someone's birthday is in there too.

This spreadsheet keeps the family year in one place. Pick your state or territory once and it fills in the 2027 government school terms and public holidays. Then add your birthdays, bills, school costs and the kids' pocket money, and it puts the lot on one calendar. The Dashboard shows the next 14 days every time you open it.

All 8 states and territories. Every 2027 term date and public holiday for NSW, Victoria, Queensland, WA, SA, Tasmania, the ACT and the NT, taken from each state's education department and official public holiday page, with the source and the date checked next to each one. The few dates not published yet (like Victoria's AFL Grand Final Friday) are marked To be confirmed, with the page to check.

Who it's for

Australian families with school-age kids who want term dates, bills, birthdays, school costs and pocket money in one place. It doesn't sync with a phone calendar or send reminders, and it isn't a full budget. The terms are for government schools. Catholic and independent school families can type their school's dates over ours.

What's inside

• Dashboard: the next 14 days day by day, the next school milestone, the next public holiday, the next birthday, bills due in the next 14 days, this term's school costs, pocket money in hand, the school terms and bills by month.
• Family Calendar: pick a month and see every day's holidays, term dates, birthdays, events, bills and school costs, with school holidays and public holidays shaded.
• Our Dates: birthdays (with the age they turn), anniversaries and one-off events.
• Bills: each bill once, weekly to yearly. The next due date, days to go, cost per year and bills by month.
• School Costs: fees, uniforms, books, excursions and camps, totalled by term and by child, paid and still to pay.
• Pocket Money: up to 4 kids, weekly pocket money that adds up on its own, chores bonuses, gifts, spending, saving and a savings goal.
• Settings and Dates: your state, and every state's 2027 dates with sources.

What you get

• An example copy with a made-up family to learn on, and a BLANK copy to fill in
• A dark mode copy of each
• A step-by-step setup video
• Locked formulas, so nothing breaks if you type in the wrong spot

Works in Excel and Google Sheets. Made for Microsoft Excel 2019 or later, Microsoft 365 and Google Sheets. Not for Apple Numbers. To use Google Sheets, upload the .xlsx to Google Drive and open it with Google Sheets.

Need help? Email me at the address on your Payhip receipt and I'll help with how the sheet works.

A planning tool, not financial advice. Check school dates with your own school. Personal use licence for your household.

From Kitchen Table Sums.