Free Expense Tracker Template
Free download · No sign-up

Free Expense Tracker Template for Google Sheets

Last updated: November 2026

Download the free template, or let ExpenseBot fill it from your Gmail receipts. Includes categories, a mileage log, monthly summaries and a spending-by-category chart.

Or let ExpenseBot fill it for you — free for 60 days

Free download, no sign-in. ExpenseBot is optional: 60-day free trial, no credit card, read-only Gmail access.

Quick answer: Where can I get a free expense tracker template for Google Sheets?

Download the free expense tracker template on this page: it is an .xlsx file that opens in Google Sheets or Excel, with no sign-in. It has an Expense Log with category and payment-method dropdowns, a Monthly Summary that totals each category by month, a Category Breakdown with a chart, a Mileage Log, and a Settings tab.

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. Fill the template in by hand, or let ExpenseBot fill the same layout 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) →

What's in the Expense Tracker Template

Six tabs, with five example expenses already entered so you can see the format:

  • Expense Log — columns for Date, Vendor, Amount, Category, Payment Method, Tax/GST/HST, Notes, Receipt Link and Deductible %. Category, Payment Method and Deductible % are dropdowns.
  • Monthly Summary — every category's total for each month, January to December, with a yearly total. It recalculates from the Expense Log.
  • Category Breakdown — total spent, number of expenses and share of total for each category, plus a Spending by Category chart.
  • Mileage Log — date, from, to, purpose, distance, round trip, total distance and deduction. The deduction is total distance times the rate on the Settings tab.
  • Settings — tax year, mileage rate, home currency, business name and accountant email.
  • About — a short note on the template and where to get help.

The Category dropdown has 20 options, from Office Supplies, Travel and Meals & Entertainment to Software/SaaS, Vehicle Expenses, Bank & Merchant Fees and Other.

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.

TermWhat it actually isWhen you want it
Expense tracker templateThe ready-made starter file — columns, dropdowns and summary formulas set up, plus a few sample rows you delete.When you are starting out and do not want to build the sheet yourself. The download on this page is one.
Expense logThe list of rows itself — one line per purchase in date order. In this template it is the Expense Log tab.Every time you spend. The log is what you add to; the summary tabs only read from it.
Expense sheetThe running log you keep — one row per purchase, all year.Always. This is the underlying record everything else is built from.
Expense reportA 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 spreadsheetThe 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.

An expense tracker template becomes your expense log the day you enter the first row, and an expense log template is the same file described by its main tab. Separate mileage records belong in a mileage log: the template has one on its own tab, and the mileage log template is a fuller version.

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.

A business expense template and a business expense spreadsheet are the same object described from two directions: the template is the empty file with the columns and formulas already set up, and it becomes your expense spreadsheet the moment you start entering rows. The one on this page is both — download it empty and fill it in by hand, or connect it and let your receipts populate 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

A simplified preview of the Expense Log, with example entries so you can see the format immediately

Expense Log (Main Tab) — Your free Google Sheets expense tracker template
DateVendorCategoryPaymentAmountNotes
Jan 15, 2025StaplesOffice SuppliesVisa ****4521$47.99Printer paper & ink
Jan 14, 2025UberTransportationVisa ****4521$23.45Client meeting downtown
Jan 12, 2025Delta AirlinesTravelAmex ****8901$387.00Chicago conference
Jan 10, 2025Adobe Creative CloudSoftware/SaaSVisa ****4521$54.99Monthly subscription
Jan 8, 2025Whole FoodsMeals & EntertainmentDebit$34.50Lunch w/ client
✓ Expense Log Tab✓ Monthly Summary Tab✓ Category Breakdown + Chart✓ Mileage Log Tab✓ Settings Tab

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. For 2026 the IRS standard mileage rate is 72.5 cents per mile for miles driven January 1 to June 30 and 76 cents per mile from July 1. Worked example: 7,500 business miles in each half of the year comes to $5,437.50 + $5,700 = $11,137.50. Without a mileage log, you have no record to support that deduction. 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 Form 1099-K: the IRS says payment apps and online marketplaces report payments that exceed $20,000 across more than 200 transactions. Your platform income is taxable whether or not a 1099-K arrives, and 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. The Schedule C lines above are the usual ones; confirm with your tax professional how your own costs are treated.

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 Make an Expense Tracker in Google Sheets

Five minutes by hand, or let ExpenseBot do the typing.

1
Download and open the free template

Click "Download Free Template" above. It downloads an .xlsx file you can open in Google Sheets or Excel, instantly — no signup or email required. To save it as a Google Sheet, upload the file to Google Drive, open it, then choose File → Save as Google Sheets. In Excel, just open it. The expense log, monthly summary, mileage log and categories are already set up.

2
Match the categories to your situation

The template ships with 20 common business expense categories pre-built. Freelancers: put the client name in Notes. Drivers: enter your mileage rate on the Settings tab first, because the template ships with an example rate (the 2026 IRS rate from July 1). Landlords: duplicate the Expense Log tab per property. The category dropdown is editable — change anything to match your real expense categories.

3
Enter one row per expense

Add each receipt to the Expense Log tab: date, vendor, amount, category, payment method and a note. Or connect Gmail and ExpenseBot writes them in for you overnight: Amazon, restaurants, subscriptions, travel.

4
Check your monthly summary

Switch to the Monthly Summary tab to see totals by category. Track spending trends month over month.

5
Log business mileage

Use the Mileage Log tab for each trip: date, from, to, purpose and distance. The deduction uses the rate on the Settings tab. ExpenseBot calculates distances via Google Maps and imports trips from Google Calendar.

6
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.

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 → Holding a cash float on the premises needs a narrower sheet: free petty cash log template →

2026 Mileage Rates in the Template

The template's Settings tab ships with an example rate of $0.76 per mile, so check the rate for your country and dates before you log trips. 2026 rates: IRS 72.5¢/mile January 1 to June 30 and 76¢/mile from July 1 (details), and CRA 73¢/km for the first 5,000 km, 67¢/km after (details). The Mileage Log uses one rate for every row, so a US 2026 log needs the rate changed at July 1. 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.

Small-Business Version: Categories and Tax-Ready Columns

The same file works as a small business expenses template. Three columns do the tax work, and all three are already on the Expense Log:

  • Tax/GST/HST — the sales tax printed on the receipt, in its own column. Totalled on its own, it is the figure you need for a GST/HST input tax credit or a VAT return.
  • Deductible % — a dropdown of 100%, 75%, 50%, 25% and 0% for costs that are only partly claimable, such as a phone you also use personally. The template's example lunch is set to 50%.
  • Receipt Link — a link to the receipt in Google Drive, so every row can be backed up by a document.

For a small business, set up the sheet once before the first entry:

  1. On Settings, enter your tax year, home currency and business name.
  2. Check the 20 categories against the lines your tax return uses (Schedule C in the US, T2125 in Canada) and rename any that do not match in the Category dropdown. The Monthly Summary and Category Breakdown formulas match each category by its exact name, so update the name in those formulas too.
  3. Delete the five example rows.
  4. Start a new copy of the file for each tax year rather than mixing years in one log.

The template does not decide what is deductible. The categories and percentages are a way to organize your records; confirm with your tax professional how each category is treated where you file.

ExpenseBot is an AI expense tracker that reads receipts from your Gmail and receipt photos and writes each expense, including the tax amount, into a Google Sheet you own. It is not a general ledger and does not file your taxes. If you would rather keep the spreadsheet than type into it, that is the step it automates.

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.

FeatureFree TemplateExpenseBot
Expense tracking in Google Sheets✓✓
Manual data entry requiredYes — every receiptNo — AI auto-extracts
Gmail receipt scanning✗✓ — auto-scans your inbox
Photo receipt scanning✗✓ — snap and submit
Auto-categorization✗✓ — AI-powered GL coding
Mileage trackingManual entryGoogle Maps auto-calculates
Duplicate detection✗✓
Exports to QuickBooks/Xero/Sage✗✓ — one-click sync
Multi-user / accountant accessManual sharingBuilt-in team features
Data stays in your Google Drive✓✓
CostFreeFree 60-day trial, then $10/mo

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!”

★★★★★  Gregg Towsley, Business Owner

“Saved THOUSANDS in tax deductions. It recovered nearly 10,000 receipts across 6 years from email, properly categorized.”

★★★★★  Brian Wise, Business Owner

4.7/5 average across G2 and Trustpilot, from freelancers and small-business owners.

Auto-fill this template free →

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.

Try ExpenseBot Free →

Want auto-fill? Use the automated receipt scanner for Google Sheets →

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 download an .xlsx file you can open in Google Sheets or Excel. 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. Once it is open in Google Sheets or Excel it is an ordinary spreadsheet — add columns, change categories, modify formulas, add your own charts. The category dropdown on the Expense Log is a plain data-validation list you can edit. 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, a category breakdown with a chart, and a mileage log. Download it, open it in Google Sheets, 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 download an .xlsx file, then open it in Google Sheets or Excel. No signup, no email, no credit card. It includes a pre-built expense log, category dropdowns, a monthly summary, a category breakdown with a chart, and a mileage log.

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.

What should a business expense spreadsheet include?

At minimum: date, vendor, amount, category, payment method, and a note for business purpose — that last one is what makes a row defensible if it is ever questioned. Add a tax-year column if you track more than one year in the same file, and keep one row per purchase rather than combining a day's spending into a single line. The template on this page ships with these columns and the category totals already wired up.

Is there a free expense sheet template?

Yes — the one on this page. "Download Free Template" gives you an .xlsx file with the columns, categories and totalling formulas already built, and it opens in either Google Sheets or Excel. There is no signup, no email and no credit card, and it stays free however long you use it.

Does the template already have the 2026 mileage rate in it?

No — set it yourself. The Settings tab ships with example values (tax year 2026 and $0.76 per mile, the IRS rate from July 1), and the Mileage Log multiplies each trip's total distance by whatever rate is in that one Settings cell. For 2026 the IRS business rate is 72.5 cents per mile for miles driven January 1 to June 30 and 76 cents from July 1, so a single cell cannot price a full 2026 year correctly; enter the rate for the period you are logging, or use the mileage calculator. Canadian users enter the CRA per-kilometre rate instead.

I run a small business and pay GST/HST or sales tax. Which columns do I need?

Use the Tax/GST/HST column for the tax shown on each receipt, so you can total the tax you paid for a GST/HST input tax credit or VAT return. Decide once whether Amount includes that tax and apply the same rule to every row, so the tax is not counted twice. Use Deductible % for anything that is only partly claimable. Both columns are already in the template's Expense Log. Confirm with your tax professional how your jurisdiction treats each category.

Related Resources

Google Sheets Expense Tracker (Automated)Gmail Receipt ScannerExpenseBot for FreelancersContent Creator Expense TrackerFree for Accountants

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:

AI Expense Tracker·Gmail Receipt Scanner·Google Sheets Tracker·Expense Report Template
ExpenseBot