Coffee journal: what to track and why (and how to actually stick with it)

Most home baristas track nothing. A smaller group keeps a chaotic stack of notes in their phone. A tiny, obsessive minority have a proper coffee journal, and their espresso gets better faster than everyone else's.

This guide is about how to join that third group without making it feel like a second job. What to log, why each field matters, how to choose between paper, spreadsheets and apps, and the honest tricks for not abandoning the habit in week two.

Why keep a coffee journal at all?

Here is the uncomfortable truth about dialling in espresso without a journal: you are not actually learning. You are guessing, getting a result, forgetting the inputs and guessing again the next morning. The fact that you make coffee every day doesn't help. Repetition without measurement is just vibes.

A journal fixes three specific problems.

You stop losing your good shots. The best shot you've ever pulled happened on a Tuesday. It was 18.2g in, 37g out, 28 seconds, grind setting 2.1 on a cheap hand grinder, a specific bag of Ethiopian natural that was 14 days off roast. Without writing that down, it is gone. You will spend the next three mornings trying to recreate something you can't remember.

You spot patterns you'd never notice day-to-day. "I rate my morning shots higher than my afternoon shots" is obvious in a journal and invisible in your head. So is "light roasts need 2 more seconds of preinfusion" and "my grinder drifts coarser after 50 shots."

You cut dial-in time in half. Dialling in a new bag from scratch takes 3 to 6 shots for most people. If you've kept notes on similar beans, it takes one or two. You already know roughly where the grind should be, what ratio suits that roast level, what extraction time to target.

What actually belongs in a coffee journal

Here is the minimum viable field list. Not every entry needs all of these, but if you're going to log a shot, these are the ones that pay rent.

The non-negotiables

Dose (coffee in, grams). Without this, nothing else is measurable. Aim for 0.1g precision. Yes, really. On an 18g dose, 0.5g off is about 3% and you will taste it.

Yield (coffee out, grams). Pair this with dose and you get your brew ratio, which is the single most-cited variable in espresso. A 1:2 ratio is 18g in, 36g out. Track the actual number, not the target. (Plug your numbers into our brew ratio calculator to see where you actually landed.)

Time (seconds). From pump-on to pump-off. Includes preinfusion on machines that have it. A 25 to 35 second extraction is a common target range, but the number matters less than pairing it with the shot's taste.

Grind setting. Whatever number or notation your grinder uses. This is the variable you'll adjust most. If your grinder has steps, log the exact step. If it's stepless, note the dial position as precisely as you can.

Bean. Which bag, which roaster, which roast date. This is the field most journals skip and then wonder why none of the data is useful two months later.

Rating (1 to 10). Pick a scale and stay consistent. A 10-point scale gives you enough resolution to notice small improvements. A 5-point scale flattens the data too much.

The high-leverage optionals

Tasting notes. One short sentence. Not "delicious". Something like "bright, clean, slight apricot on the finish" or "muddy, bitter tail, dry on the tongue." How to taste espresso has the full sensory framework if you want to go deeper.

Drink type. Espresso, cortado, flat white or latte. Milk drinks hide extraction flaws and demand different ratios.

Roast date and days off roast. Coffee changes dramatically over its first 6 weeks post-roast. Coffee freshness for espresso goes into the why.

Machine and grinder loadout. If you only have one setup, skip this. If you switch between machines, cafe, work or a second grinder for decaf, tag every shot.

Temperature and pressure. Only useful if your machine actually lets you adjust them (flow-profiling machines, dual-boilers with PID). On a single-boiler Gaggia, set and forget.

Basket size (single, double, triple). Dose ranges differ dramatically. Logging this prevents you from comparing an 18g double-basket shot to a 14g single-basket shot as if they were the same kind of animal.

Photo of the pour or crema. Channelling is almost invisible in the moment but obvious in a photo. Also, latte art progress is embarrassing to track in your head and motivating to see in a gallery.

The ones you can skip

Water ratio or weight brought in. Not relevant for espresso (it's for brewed coffee).

Ambient temperature and humidity. Yes, they affect grind. No, logging them manually is not worth the effort for 99% of home baristas. If your grinder drifts seasonally, just adjust grind. Don't run a weather station.

Every step of your puck prep routine. Unless you're actively experimenting with WDT patterns or tamping pressure, this becomes write-only noise.

Paper, spreadsheet or app: honest trade-offs

The single biggest question is which medium to use. All three work. All three have failure modes.

Paper notebook

Pros: Zero setup. Calming. Good for single-purpose ritual. You'll remember shots you wrote out by hand.

Cons: No search. No sorting. "What was my best shot with that Colombian?" requires flipping pages. No automatic math (you compute ratios yourself). Falling behind by three days means you'll never catch up.

Paper works best if you journal fewer than about 5 shots a week and treat it like a diary rather than a database.

Spreadsheet (Excel, Google Sheets, Numbers)

Pros: Searchable. Sortable. Brew ratio autocalculates if you set it up. Free. Yours forever.

Cons: 30+ minutes of template work before your first entry. One missing decimal point and a row goes sideways. One-handed data entry while the puck is extracting is miserable. Mobile spreadsheet UIs are all bad.

Spreadsheets win for a certain kind of person. The one who already uses spreadsheets for everything else. For most people they stall out around entry 40.

Dedicated app

Pros: Built for the format. Brew ratio, shot time, caffeine and bean freshness all autocalculate. One-handed entry is designed for. History, filters and pattern detection come free.

Cons: Lock-in risk if the app shuts down or goes aggressively paid. Privacy risk if it syncs your data somewhere. Decision fatigue about which one to pick.

The lock-in problem is real but solvable: only pick apps that export your data in a readable format (JSON or CSV). If they can't hand you back your own history, walk away.

How to choose an app without regretting it

We wrote a full breakdown of what to look for in a coffee tracking app, but the short version is six questions:

1. 1.Can you export your data? If not, hard no. Your shot history should be yours.
2. 2.Does it require an account? Every account is a future password reset, breach risk and email-list invitation. A good coffee app should open and work.
3. 3.Is the free tier useful, or is it a demo? Some "free" apps cap you at 10 shots before a paywall. That is not free, that is a trial.
4. 4.Does it understand brew ratio? You would be surprised how many don't.
5. 5.Can you log a shot in under 30 seconds? If the happy path requires 7 taps, you will quit by week three.
6. 6.Does it work offline? You will try to log a shot on a plane. You will try to log one in a cabin. You will try to log one in a cafe basement with no signal.

PUCK YEAH! passes all six. It's free, signup-free, offline-first, exports everything as CSV or JSON and logs a shot in about 20 seconds. That's not an accident. It's the brief.

The habits that make a journal stick

Most coffee journals die in week two. Here is how to not do that.

Log the shot before you drink it, not after

The instant after the pump stops is the moment you have dose, yield, time and grind in short-term memory. If you wait until after you've sipped and made a face, you'll round-number everything and lose precision. Weigh out, weigh in, set the timer. These are one-handed actions that happen while you're already standing there.

One-sentence tasting notes are enough

Nobody is reviewing your prose. "Sour, thin, weak finish." "Syrupy, sweet, chocolate." "Muddy, ashy, bad." Thirty seconds of writing gives you a year of pattern data.

Skip days are fine, but skip weeks kill the habit

If you took three days off, don't backfill from memory. That data will be garbage and will pollute your trend lines. Just start again today. The journal doesn't care about streaks. You do.

Journal one bag through end-to-end, not all bags halfway

A complete record of one bag from day 4 to day 30 teaches you more than scattered entries across six bags. You learn how a bean develops, where the sweet spot sits, when it dies. Then you generalise.

Review once a week for ten minutes

Filter your last seven days. Look at average rating, best shot, worst shot and which ratios scored highest. Ten minutes of review turns logging into learning. Without this, you are just typing into the void.

A starter template you can copy

Here is the minimum structure we'd recommend for a spreadsheet or paper journal. Adapt to taste.

That's it. Eleven fields, ten of them under 10 characters to enter. If you can't get through that template in 30 seconds you are overthinking it.

Or skip the setup entirely

If you want the full template, autocomputed ratios, days-off-roast tracking, shot timer, filterable history, taste pattern detection and trend graphs, without the 30-minute spreadsheet build, that is literally what PUCK YEAH! is. Free, no signup, works on iOS and the web, shot data stays on your device by default.

Either way, start today. A week of even messy notes beats a year of perfect intentions.

Further reading

• What to track in your espresso journal. The field-by-field deep dive on why each variable matters for dialling in.
• How to dial in espresso. The full process a good journal makes three times faster.
• How to taste espresso. The sensory framework behind useful tasting notes.
• How to choose an espresso tracking app. Deeper criteria if you're picking between apps.