New Excel Template · Personal Finance
Coffee Spending Tracker
Find out exactly how much your daily coffee habit costs you — and what you could do with that money instead.
Final price may vary slightly on Etsy depending on your location and taxes.
Get it on Etsy →What's included
- →
Daily, monthly, and yearly coffee cost calculator
- →
Savings simulator: cut 25%, 50%, or 100%
- →
5-year compound growth projection (5% return)
- →
Real cost of small habits visualized instantly
- →
No formulas to edit — just fill in 3 inputs
Who it's for
- ·
Anyone who buys coffee daily and wonders where their money goes
- ·
People trying to cut small expenses without tracking everything
- ·
Anyone who wants a quick financial reality check
About this template
Most people underestimate their coffee spending by 3–5x. This simple Excel tracker calculates your real daily, monthly, and yearly coffee cost, shows how much you could save by cutting 25%, 50%, or 100%, and projects compound growth on those savings over 5 years. Enter 3 numbers, get instant clarity.
Common questions about this topic
How much does buying coffee every day cost per year?
If you buy 2 coffees per day at $3.50 each, that's $2,555 per year — or $12,775 over 5 years. Most people estimate they spend 3x less than the real number.
What is a coffee spending tracker?
A coffee spending tracker is a simple spreadsheet that calculates your real daily, monthly, and yearly coffee cost based on how many coffees you buy and what you pay. It also shows your savings potential and what happens if you invest that money.
How do I calculate my coffee spending?
Multiply (cost per coffee) × (coffees per day) × (days per week) × 52. For example: $3.50 × 2 × 5 × 52 = $1,820/year. This Coffee Spending Tracker does it automatically.
Is buying coffee every day expensive?
Yes — in ways most people don't realize. 2 coffees/day at $3.50 costs $2,555/year. Over 5 years at 5% compound growth, investing that money instead would grow to $14,200+.
What is "invisible spending" in personal finance?
Invisible spending refers to small, recurring expenses that feel harmless individually but add up to thousands per year — like daily coffee, streaming services, or small subscriptions. Coffee is one of the most common examples.
Can this template work in Google Sheets?
Yes. The template is built in Excel but is fully compatible with Google Sheets. Just upload the .xlsx file to Google Drive and open it with Sheets.
Frequently asked questions
Do I need Excel skills to use this?
No. You only fill in 3 yellow cells — cost per coffee, coffees per day, and days per week. Everything else calculates automatically.
What does the compound growth projection show?
It shows what your saved coffee money would become if invested at 5% annual return over 5 years. It's a reality check, not financial advice.
Can I change the interest rate in the projection?
Yes. The template has one input cell for the return rate (default 5%). You can adjust it to model different scenarios.
Is this a one-time purchase?
Yes. You pay $0.99 once and get the file instantly. No subscriptions.
From the blog
Guide
How Much Are You Really Spending on Coffee?
The real yearly cost of your daily coffee habit — and what happens if you invest that money instead.
Read the guide →
Ready?
Coffee Spending Tracker · $0.99 one-time
Keep building your system
More templates that work well alongside this one.
Personal Finance
Budget & Personal Finance Tracker
Stop wondering where your money goes. Track every euro, every month — and finally take control of your finances.
$16.99
Personal Finance
The $1,000 Leak Detector
Find every hidden subscription draining your budget. See the real yearly cost. Cut what you don't need. It takes 30 minutes.
$2.99