Free Expense Tracker Template for Google Sheets
Last updated: June 2026
Download our free template — or let ExpenseBot fill it automatically from your Gmail receipts. Categories, mileage log, monthly summaries, and a dashboard included.
You'll sign in with Google next — takes 30 seconds, read-only access.
Template: No signup needed · ExpenseBot: 60-day free trial, no credit card
An expense tracker template is a ready-made spreadsheet for logging what you spend — each row holds the date, vendor, amount, category, and payment method, and a summary tab totals it by category so you can see where your money goes and claim every deduction at tax time. To use it, make a free copy, enter one row per expense, and pick a category from the dropdown.
The catch with any plain template is the manual typing. The National Association for the Self-Employed estimates independent workers miss $3,000–$5,000 in legitimate deductions every year — usually because receipts never make it into a tracker. ExpenseBot fixes that by reading your Gmail receipts and receipt photos and filling this exact layout automatically. Grab the free template below, or skip the manual entry and auto-track with ExpenseBot (free) →
What the Template Looks Like
Pre-filled with example entries so you can see the format immediately
| Date | Vendor | Category | Payment | Amount | Notes |
|---|---|---|---|---|---|
| Jan 15, 2025 | Staples | Office Supplies | Visa ****4521 | $47.99 | Printer paper & ink |
| Jan 14, 2025 | Uber | Transportation | Visa ****4521 | $23.45 | Client meeting downtown |
| Jan 12, 2025 | Delta Airlines | Travel | Amex ****8901 | $387.00 | Chicago conference |
| Jan 10, 2025 | Adobe Creative Cloud | Software/SaaS | Visa ****4521 | $54.99 | Monthly subscription |
| Jan 8, 2025 | Whole Foods | Meals & Entertainment | Debit | $34.50 | Lunch w/ client |
Expense Tracker for US Uber, Lyft, and DoorDash Drivers
If you're a US rideshare or delivery driver — Uber driver, Lyft driver, DoorDash driver, Instacart shopper, or any other gig worker — this free expense tracker template is pre-configured with the categories you'll need for Schedule C. Vehicle expenses go on Schedule C Line 9, supplies (delivery bags, phone chargers, dashcam) on Line 22, commissions and platform fees on Line 10, and cell phone/data on Line 25 at business-use percentage.
The single biggest deduction for most rideshare drivers is mileage. The 2026 IRS standard mileage rate is $0.725 per mile, which on 15,000 business miles equals $10,875 in deductions. Without a mileage log, that deduction is disallowed. See our 2026 IRS mileage rate guide and pair this template with our mileage tracker app so every Uber pickup, DoorDash drop, and Instacart delivery is logged with Google Maps auto-calculated distance.
A note on 1099-K: starting in 2026, third-party payment platforms (Uber, Lyft, DoorDash, Stripe) issue Form 1099-K at the $600 transaction threshold per the latest IRS phase-in. Your gross earnings from the platform show up on that 1099-K; your expenses (including mileage) are what reduce it to taxable income on Schedule C. Tracking expenses carefully is how gig worker tax bills go from painful to manageable.
For full Schedule C automation — every Uber trip, every DoorDash delivery, every platform commission — use the Schedule C expense tracker. For freelancers beyond rideshare, see the freelancer expense tracker. Canadian rideshare drivers: see our T2125 Uber driver guide.
How to Set Up Your Google Sheets Expense Tracker in 3 Steps
You can be running in under 5 minutes — manually, or fully automated.
Click "Download Free Template" above. It makes a copy in your Google Drive instantly — no signup, no email required. The template opens with your expense log, monthly summary, mileage log, and tax deduction categories already set up.
The template ships with the most common Schedule C categories pre-built. Freelancers: rename the client tag column. Rideshare drivers: mileage log is already configured for the 2026 IRS rate ($0.725/mile). Landlords: duplicate a tab per property. The category dropdown is editable — change anything to match your real expense categories.
If you'd rather not enter expenses manually, connect Gmail to ExpenseBot. The nightly scan reads receipt emails — Amazon, restaurants, subscriptions, travel — and writes them to the same Google Sheet format automatically. You get the spreadsheet you already know, filled without lifting a finger.
Want to go further? Full setup guide with screenshots → or how to automate your Google Sheets expense tracker →
2026 Mileage Rates in the Template
The template has been updated with the current 2026 rates: IRS $0.725/mile (details) and CRA 73¢/km for the first 5,000 km, 67¢/km after (details). Want AI-powered auto-filling? The AI expense tracker that auto-fills this template reads your Gmail receipts and populates the sheet overnight. Estimate a trip's deduction with the mileage calculator, or build a Google Sheets expense tracker from scratch using this template as a starting point.
What's in the Free Template
A genuinely useful expense tracker — not a throwaway freebie
Expense Log
Date, vendor, amount, category, payment method, notes, and a receipt link column for manual Google Drive links. Category dropdowns pre-built.
Monthly Summary
Auto-calculated monthly totals by category. See exactly where your money goes each month without building formulas from scratch.
Tax Deduction Categories
Pre-built categories matching common tax deductions: Office Supplies, Travel, Meals, Software, Professional Services, Vehicle, and more.
Mileage Log
Separate tab for business mileage. Date, destination, purpose, distance, and automatic rate calculation using current IRS/CRA standard mileage rates.
Dashboard with Charts
Visual breakdown of spending by category with pie and bar charts. See your top expense categories at a glance without pivot tables.
Settings Tab
Configure tax year, mileage rate, home currency, and custom categories. Change settings once and formulas update everywhere.
Template vs. ExpenseBot — Why Automate?
The template is great for getting started. ExpenseBot is what you upgrade to when you're tired of manual entry.
At 50 receipts/month × 2 min each = 100 minutes saved monthly. That's 1.5+ hours for $10.
“Blown away at how easy it is to scan receipts and have them automatically put into a Google spreadsheet. It has saved me hours worth of time!”
“Saved THOUSANDS in tax deductions. It recovered nearly 10,000 receipts across 6 years from email, properly categorized.”
4.7/5 average across G2 and Trustpilot, from freelancers and small-business owners.
60-day free trial · No credit card · Data stays in your Google Drive
Want it Filled Automatically?
ExpenseBot scans your Gmail, snaps receipt photos, and fills your Google Sheets expense tracker automatically. Zero typing.
Want auto-fill? Use the automated receipt scanner for Google Sheets →
How to Use This Template
A step-by-step guide to making an expense tracker in Google Sheets
Download the Template
Click "Download Free Template" above — Google Sheets opens and makes a copy in YOUR Drive. No signup, no email, no credit card.
Start Entering Expenses
Add each receipt to the main Expense Log tab: date, vendor, amount, category, payment method, and notes.
Or connect ExpenseBot to pull expenses from Gmail automatically — no typing needed.
Categorize Each Expense
Use the dropdown to assign a category. Tax deduction categories are pre-built: Office Supplies, Travel, Meals, Software, Vehicle, and more.
ExpenseBot auto-categorizes every expense using AI-powered GL coding.
Check Your Monthly Summary
Switch to the Monthly Summary tab to see totals by category. Track spending trends month over month.
Log Business Mileage
Use the Mileage Log tab to record trips: date, destination, purpose, and distance. Rate calculation is automatic.
ExpenseBot calculates distances via Google Maps and imports trips from Google Calendar.
Export for Tax Time
At tax time, filter by deduction category and export to CSV or share with your accountant.
ExpenseBot generates a complete year-end tax report with receipt images, totals by category, and accounting software export.
Who Is This Template For?
Freelancers
Track deductible expenses for Schedule C or T2125. Keep receipts organized for tax season.
See ExpenseBot for freelancers →Small Business Owners
Separate business from personal spending. Track expenses by category and payment method.
Automate with ExpenseBot →Accountants
Share with clients who need a simple starting point. When they outgrow it, upgrade them to ExpenseBot (free for accountants).
ExpenseBot for accountants (free forever) →Google Sheets Users
If you already live in Google Sheets, this template fits your workflow. No new app to learn.
Frequently Asked Questions
Is the template really free?
Yes, 100% free forever. Click "Download Free Template" to make a copy in your Google Drive. No signup, no email, no credit card required. Use it as long as you want.
Can I customize the template?
Absolutely. It's a regular Google Sheet — add columns, change categories, modify formulas, add your own charts. It's designed as a starting point you can build on.
Does it work on mobile?
Yes. Open it in the Google Sheets app on iOS or Android. Enter expenses on the go from your phone or tablet.
What if I want automatic receipt scanning?
Try ExpenseBot free for 60 days. It scans your Gmail receipts automatically, extracts vendor, amount, date, and tax, and fills your Google Sheets expense tracker with zero manual typing.
Can my accountant use this?
Yes — just share the Google Sheet with them directly. Or upgrade to ExpenseBot for built-in accountant access with one-click export to QuickBooks, Xero, Sage 50, and more.
How do I make an expense tracker in Google Sheets?
The easiest way is to download this free template — it already includes expense log columns, category dropdowns, a monthly summary tab, mileage log, and a dashboard with charts. Just make a copy and start entering expenses. For automatic tracking, try ExpenseBot.
Is there a free expense tracker template for Google Sheets?
Yes — ours is 100% free. Click "Download Free Template" to make your own copy in Google Drive. No signup, no email, no credit card. It includes a pre-built expense log, category dropdowns, a monthly summary, a mileage log, and a dashboard.
How do I track business expenses in a spreadsheet?
Add one row per expense with the date, vendor, amount, category, and payment method, then total each category on a summary tab. This template has those columns and formulas already built. To skip the manual entry, ExpenseBot reads your Gmail receipts and receipt photos and writes each expense into the same layout automatically.
Can I import receipts into the template automatically?
A plain Google Sheets template can't pull in receipts on its own — that's exactly what ExpenseBot adds. Connect Gmail and it auto-imports receipts (Amazon, Uber, airlines, hotels, SaaS), extracts the vendor, amount, date, and tax, and adds each to your tracker. You can also snap photos of paper receipts and they're added the same way.
Ready to Stop Entering Expenses Manually?
Start with the free template. Upgrade to ExpenseBot when you want AI to do the typing. Either way, your data stays in Google Sheets in YOUR Drive.
Try ExpenseBot free for 60 days — no credit card required.
✓ Template: No signup needed · ✓ ExpenseBot: 60-day free trial
✓ Data in YOUR Google Drive · ✓ Cancel anytime
Also from ExpenseBot: