December gets busy, and the year ends before you've had a chance to look at it. Then January starts with resolutions that have nothing to do with what actually happened. An end of year reflection fixes that, but "what did you learn this year?" is too big a question to answer cold.
So this post breaks it down month by month. You pull up a few records, answer short questions for each month, count a handful of numbers, and finish with a short list of things to carry into 2027.
TL;DR
- You end up with a month-by-month look at 2026 and three to five things to change in 2027.
- Use records, like your calendar and photos, because memory skips whole months.
- The most common mistake is reflecting only on the last two months because they're the freshest.
Who this is for
- Data analyst: You live in spreadsheets, so counting your year in numbers will feel natural.
- Freelance consultant: A month-by-month look shows which clients and months were worth it.
- Middle school teacher: You can reflect on the calendar year separately from the school year.
- Small business owner: Seasonal patterns from 2026 become planning notes for 2027.
- Graduate student: You can see where research time actually went across the year.
What to pull up first
Give yourself about two hours. Open:
- Your 2026 calendar.
- Your photo roll, starting in January.
- Your sent email folder, if work is part of the reflection.
- Your journal or notes app, if you keep one.
- A blank page or sheet with 12 rows, one per month.
Questions for each month
Go through the months in order. For each one, answer three short questions in its row:
- What took most of my time this month?
- What's one thing I'm glad happened?
- What's one thing I'd do differently?
One line each. Don't polish. If a month is blank in your memory, that's what the calendar and photos are for. Some months will have nothing to say and that's useful too: it might mean a month on autopilot.
A few prompts that help when you're stuck:
- Who did I spend the most time with in this month?
- What did I spend money on that I'd spend on again?
- What was I worried about, and did it happen?
- What did I start that I didn't finish?
Count a few numbers
Numbers keep a reflection honest. Pick three to five things you can actually count: trips taken, books finished, days off, workouts, projects shipped, clients worked with.
If a lot of your year happened in Google Sheets, Sheets Wrapped does some of the counting for you. It's a free Google Sheet, like Spotify Wrapped but for your spreadsheets. You make a copy, open the Sheets Wrapped menu, click "Wrap my 2026 Sheets", and a new tab fills with things like hours spent in Sheets, cells edited, your first sheet of the year and how many files are still called "Untitled spreadsheet".
It runs as plain Apps Script inside your own Google account, with no AI and no outside services. It only reads names, dates and sharing info, never opens your files or reads your email, and only writes to your own copy. You can also schedule it to run on a date you pick, like New Year's Eve.
Find the patterns
Read down your 12 rows and the numbers. Look for:
- Repeats. The same "do differently" answer showing up in three or more months.
- Good months. The months with the best "glad it happened" lines. What did they have in common?
- Lost months. Months you couldn't remember without the calendar.
- Seasons. Busy stretches that come back at the same time each year.
Write three to five sentences that start with "In 2027, I want to..." based on what you found. Keep them concrete: "keep August free of client launches", not "find more balance".
Carry it into 2027
A reflection that stays in a notes app gets forgotten by February. Put the decisions on a calendar.
Copy Big Year 2027 (free, the whole year on one Google Sheets tab) and turn each "In 2027" sentence into something on the page. If August was a lost month in 2026, block it out now. If your best months had a trip in them, put a trip in the empty quarter. Add the seasonal crunches you spotted in the SETTINGS tab or as notes on the days, so they highlight before they arrive.
Then put a 30 minute check-in on the last day of each quarter to read your reflection again.
Common pitfalls
- Only remembering November and December. Start in January and go month by month with your calendar open.
- Writing essays. One line per question is enough. Long answers make you quit by April.
- No numbers at all. Count at least three things so you can compare next year.
- Stopping at insight. Each finding should become a date or a block on your 2027 calendar.
- Doing it on New Year's Eve. Pick a quiet evening in mid to late December instead, when you're not also hosting.
FAQ
What questions should I ask for an end of year reflection?
Start with three per month: what took my time, what I'm glad happened, and what I'd do differently. Then look across all twelve months for patterns.
How long does an end of year reflection take?
About two hours if you go month by month with your calendar and photos open. You can split it over two evenings.
When should I do my end of year reflection?
Mid to late December works well. Early enough to use what you learn when you plan January.
What is Sheets Wrapped?
A free Google Sheet that summarizes your year in Google Sheets: hours spent, sheets created, untitled files and more. It runs inside your own Google account.
Can I do a reflection for an earlier year?
Yes. In Sheets Wrapped you can change the year and wrap any year back to 2006.
Done looking back? Get the Big Year, a free 2027 calendar in Google Sheets, and plan what's next.
