If your energy crashes some afternoons, your anxiety spikes some evenings, or you wake up some mornings feeling foggy and irritable, caffeine and alcohol are often quietly involved. The problem is that the connection isn’t always obvious in the moment — a second coffee at 2pm or a couple of drinks on a Tuesday rarely feels like a big deal until you look back and notice the pattern.
Table of Contents
Tracking mood alongside your caffeine and alcohol intake turns that guesswork into evidence. This guide walks through exactly what to log, how to lay out a simple daily tracker, and how to read the patterns once you have a week or two of data — plus a free printable log you can use to get started right away.
Quick Answer
Track mood and caffeine/alcohol intake by logging four things at the same time each day: a mood rating (1-10 or a simple word), what and how much caffeine or alcohol you had and when, hours of sleep the night before, and any notable symptoms (anxiety, crash, headache, poor sleep). After 1-2 weeks, compare entries side by side to see which habits line up with your best and worst mood days.
What to Log Each Day
Keep the daily entry short enough that you’ll actually fill it in. A workable layout has one row per day with these columns: Date; Mood rating (a simple 1-10 scale, or just “good / okay / low”); Caffeine — type, approximate amount, and time of last cup (e.g., “2 coffees, last one 1pm”); Alcohol — type and number of drinks, with time; Sleep — hours slept and a rough quality rating; and a Notes column for anything else that might matter, like a stressful meeting, exercise, or a late meal.
Rate mood at least once a day, ideally at the same time (many people find evening works best since it captures the whole day), and add a second quick rating in the morning if you want to catch next-day effects from the night before. For caffeine, note the time of your last dose, not just the total amount — caffeine’s effects can last several hours after you drink it, so a coffee at 4pm can still be affecting you at 9pm. For alcohol, log drinks as standard units (one beer, one glass of wine, one shot) rather than vague terms like “a few,” since consistency is what makes the log useful later.
A printable log works well for this because it removes the friction of opening an app — keep it on the counter or nightstand and fill it in before bed. Lay it out as a simple weekly grid: seven rows (one per day) and columns for Date, Morning Mood, Evening Mood, Caffeine (amount + last time), Alcohol (drinks + time), Sleep Hours, and Notes, with a blank Weekly Summary section at the bottom to jot down anything that stood out.
Finding the Patterns
Once you have at least a week of entries, read across the rows rather than down one column at a time. Look specifically at: whether low-mood or anxious days cluster after days with more caffeine, especially caffeine later in the afternoon or evening; whether the day after drinking tends to show lower mood ratings than days without alcohol, even on days you don’t feel outright hungover; and whether sleep hours are the real middle step — caffeine late in the day and alcohol close to bedtime both tend to reduce sleep quality, and poor sleep is one of the strongest everyday drivers of low mood and irritability the next day.
It helps to separate “dose” from “timing.” Some people handle a morning coffee fine but feel wired or anxious from an afternoon one; some people feel fine after one drink but notice next-day flatness after two or more. Tracking both amount and timing for 2-3 weeks — long enough to cover a mix of weekdays, weekends, and at least one higher-intake day — usually makes the pattern clear enough to act on, like moving your last coffee earlier or capping drinks on nights before a demanding day.
Tips and Common Mistakes
Rate mood at a consistent time each day, since comparing a 9am rating on one day to a 9pm rating on another will muddy the pattern. Log caffeine and alcohol as you have them rather than trying to recall everything at the end of the day — memory for “how many” gets unreliable fast, especially for alcohol. Don’t skip the sleep column; it’s often the hidden link between what you drank and how you felt, and ignoring it can make caffeine or alcohol look more (or less) responsible than they actually are. Finally, give it real time — one bad day after one drink isn’t a pattern, but a trend across two or three weeks is worth adjusting for. If low mood, anxiety, or sleep problems are persistent or severe regardless of what you’re tracking, bring the log to a doctor or therapist; it can help them spot things faster than a verbal recap alone.
Explore more: more mental health tracking guides.
mood and caffeine/alcohol tracking FAQs
How long should I track before looking for patterns?
Aim for at least 1-2 full weeks, including a mix of weekdays and weekends, before drawing conclusions. Three to four weeks gives an even clearer picture, especially if your caffeine or alcohol habits vary from week to week.
Should I track caffeine amount in milligrams?
It’s not necessary. Tracking by cups, cans, or shots with the type (coffee, energy drink, espresso) is usually specific enough to spot patterns, since what matters most is the relative change day to day, not an exact milligram count.
Does the time I drink caffeine or alcohol matter more than how much?
Both matter, but timing is easy to overlook. Caffeine late in the day and alcohol close to bedtime are especially likely to disrupt sleep, which often shows up as low mood or irritability the next day even if the total amount wasn’t unusually high.
Skip the Spreadsheet — Track It in ZenDuel
Habit streaks, mood tracking, and accountability duels in one free app — no template maintenance required. Get ZenDuel.
Want a calmer inbox? Subscribe to the free newsletter.
Photo: Thought Catalog thoughtcatalog / CC0, via Wikimedia Commons.
