Free Expense Tracker Template for Google Sheets
Last updated: July 2026
Download our free template — or let ExpenseBot fill it automatically from your Gmail receipts. Categories, mileage log, monthly summaries, and a dashboard included.
Template downloads instantly — no sign-in. ExpenseBot (optional) uses a 30-second Google sign-in, read-only access.
Template: No signup needed · ExpenseBot: 60-day free trial, no credit card
Quick answer: What is an expense sheet?
An expense sheet is a simple table with one row per purchase — date, merchant, amount, category, payment method, and a note — that totals by category so you can file taxes or bill a client straight from it. The one column most homemade sheets leave out is business use %, and it is the column that decides how much of a mixed personal/business expense you can actually claim. A free copy of the sheet, with the columns and formulas already set up, is on this page. The free Google Sheets expense tracker template on this page includes an expense log, category dropdowns, a monthly summary, a mileage log, and a dashboard; download it as .xlsx with no sign-in, or let ExpenseBot fill it automatically from Gmail receipts.
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) →
Expense Sheet vs Expense Report vs Expense Spreadsheet — Which Do You Need?
These three get used interchangeably and they are not the same thing. Picking the wrong one is why people end up rebuilding their tracker in March.
| Term | What it actually is | When you want it |
|---|---|---|
| Expense sheet | The running log you keep — one row per purchase, all year. | Always. This is the underlying record everything else is built from. |
| Expense report | A summary produced from the sheet for a specific period or purpose. | When you submit for reimbursement, bill a client, or hand your accountant a year-end pack. |
| Expense spreadsheet | The file format the sheet lives in — a Google Sheet or Excel workbook. | It is the container, not a third method. Any sheet or report can live in one. |
In practice you keep one sheet and generate reports from it whenever someone asks. If you find yourself maintaining a separate file per report, the sheet is not doing its job — the summary should be a formula over the log, not a retyped copy of it.
The Exact Columns to Use (Copy-Paste)
Building your own from scratch? Paste this as row 1 and you have a working expense sheet:
Date Merchant Amount Currency Category Payment method Business use % Notes Receipt link
Why each one earns its place:
- Date — drives every period filter and the tax year the expense falls in.
- Merchant — what you search for when reconciling against a card statement.
- Amount — the figure that gets totalled.
- Currency — omit it and a single foreign purchase silently corrupts your totals.
- Category — the grouping your summary and your tax form both work from.
- Payment method — how you spot the personal-card purchase that needs reimbursing.
- Business use % — the column most homemade sheets skip, and the one that decides whether a mixed-use expense survives review. A phone bill at 60% business is not a 100% deduction.
- Notes — the business purpose. Six months later this is the only thing that reminds you why a restaurant bill was deductible.
- Receipt link — a link to the actual document. A number with no receipt behind it is a number you cannot defend.
The three formulas you actually need
Assuming the header row above sits in row 1, with dates in column A, amounts in column C and categories in column E:
Total for one category
=SUMIF($E$2:$E, "Software", $C$2:$C)
Running total (put in row 2, drag down)
=SUM($C$2:C2)
Total for one month — here, July 2026
=SUMIFS($C$2:$C, $A$2:$A, ">="&DATE(2026,7,1), $A$2:$A, "<"&DATE(2026,8,1))
Combine the last two ideas and you get a category total for a single month with a second pair of criteria on SUMIFS. All three work identically in Excel — the syntax is standard. Claiming vehicle costs too? The mileage calculator handles the 2026 split-rate year, which a flat per-mile formula in a spreadsheet will get wrong.
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.76 per mile, which on 15,000 business miles equals $11,400 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.76/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 → Closing a business instead? what to do with your records →
2026 Mileage Rates in the Template
The template has been updated with the current 2026 rates: IRS $0.76/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.
Be honest about the trade. A template costs nothing, and at low volume it works perfectly well — the arithmetic in a spreadsheet is not where anyone's books fall apart. What a template cannot do is entry discipline. Every row exists only because someone stopped and typed it, and the rows that never get typed are invariably the small ones: the parking, the app subscription, the coffee with a client. Those are also, in aggregate, a meaningful share of the deduction. The row nobody types is the deduction nobody claims — and no amount of extra columns fixes that, because it is a capture problem, not a spreadsheet problem. That is the gap ExpenseBot closes: receipts already sitting in your Gmail land in a sheet you own, in your own Drive, without anyone retyping them.
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.
Do I need an account or sign-in to get the template?
No. "Download Free Template" downloads the spreadsheet straight away — it's an .xlsx file you can open in Google Sheets or Excel, with no account, no email, and no sign-in. The only time you'll ever see a Google sign-in is if you choose to have ExpenseBot auto-fill the template for you; the template itself is never gated.
Why does it ask for Google sign-in?
The template download never asks you to sign in. The Google sign-in only appears if you pick the ExpenseBot option — and that's because ExpenseBot needs read-only access to your Gmail to find your receipts, and it writes the results into a Google Sheet in your own Drive. It never sends email and never deletes anything. You can close that prompt and still keep the free template.
What's the difference between the template and ExpenseBot?
The template is manual — you type in each expense yourself. ExpenseBot is the automated version of the exact same tracker: it reads the receipts already in your Gmail (and photos of paper receipts), extracts the vendor, amount, date and category, and fills this same layout for you. Same output, none of the typing. The template is free forever; ExpenseBot is free to try for 60 days.
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.
What is an expense sheet?
A table with one row per purchase — date, merchant, amount, category, payment method and a note — that totals by category. It's what you file taxes from, or hand to an accountant at year end. The sheet is the running log you keep all year; a report is the summary you produce from it.
What columns should an expense sheet have?
Date, merchant, amount, currency, category, payment method, business-use percentage, notes, and a link to the receipt. The business-use percentage is the one most homemade sheets skip, and it's what decides how much of a mixed personal/business expense you can actually claim — a phone bill at 60% business use is not a 100% deduction.
What's the difference between an expense sheet and an expense report?
The sheet is the running log you keep all year. The report is the summary you produce from it — for a reimbursement claim, a client, or your accountant. If you're maintaining a separate file for each report rather than generating it with a formula over the log, the sheet isn't doing its job.
Is a spreadsheet good enough for business expenses?
It's fine for the maths and fine at low volume. Where it fails is discipline: every row is manual, and the purchases you forget to type are the deductions you never claim. That's a data-entry problem, not a formula problem — which is why automating the capture matters more than a fancier template.
Can I use this expense sheet in Excel instead of Google Sheets?
Yes. "Download Free Template" gives you an .xlsx file, which opens directly in Excel as well as Google Sheets. The columns and the SUMIF/SUMIFS formulas are standard spreadsheet syntax and work the same in both.
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: