Free Expense Tracker Spreadsheet Template
Log every expense, track receipts, and generate category summaries. Free template for personal or business use.
What is an expense tracker spreadsheet?
An expense tracker logs every transaction — date, description, category, amount, payment method, receipt status, and notes — so you have a clean audit trail of your spending. Unlike a budget (which plans ahead), a tracker records what actually happened. This template combines a transaction log with a category summary block so you can review spend at a glance in Excel, Google Sheets, or Griddy.
What's included
Each row captures: date, description, category (from a dropdown list), amount, payment method, receipt status, and notes. Alternating row styles make the log easy to scan, while the summary block rolls category totals into a compact month-to-date view. Categories are fully customisable — rename or add rows to match how you actually spend.
Who should use this template?
Freelancers tracking deductible business expenses. Employees submitting expense reports. Small businesses monitoring operational costs. Students tracking spending against a monthly allowance. Anyone preparing for tax season who needs a clean, sortable transaction log with receipt context.
How to use it
Open the template in Griddy. Enter transactions as you make them, or batch-enter weekly. Use the dropdown in the Category column to keep data consistent, and mark whether each receipt is attached. Review the summary block at the bottom to see which categories are driving spend. At the end of the year, the category breakdown is ready to hand to your accountant.
Related guides
Learn how teams actually use this template
Google Sheets Freeze Rows
Freeze rows in Google Sheets so headers, dates, owner names, and review labels stay visible while you scroll through large spreadsheets.
Read guideGoogle SheetsHow to Sort in Google Sheets
Sort data in Google Sheets by date, status, owner, amount, or multiple columns without breaking the structure of your working spreadsheet.
Read guideGoogle SheetsHow to Use ARRAYFORMULA in Google Sheets
Use ARRAYFORMULA in Google Sheets to apply one formula across an entire column, fill calculated fields, and avoid fragile copy-down formulas.
Read guideSkip the setup
This template is ready in your browser.
Click “Open in Griddy” to load the template instantly. No download required. Griddy's AI is already connected, so you can customise it in plain English.
Open in Griddy