2026 Expense Tracker Template

What is an expense tracker?

The 2026 Expense Tracker is an expense tracker template built as one free expense tracker template for Google Sheets and Excel: a Google Sheets expense tracker when you want shared finance work, an Excel workbook when you want local control, a business expense tracker for freelancers and small teams, a personal expense tracker for households, and a monthly budget template when the question is simply where the money went. Four columns stay mandatory: date, vendor, category, amount. The rest — type, method, notes — is just enough context to make the monthly review useful.

The monthly cadence is the important part. Unlike budgeting apps that want a daily habit, a template-based tracker works best as a once-a-month ritual: import the statement, reconcile the categories, review the deltas, and close the month. Fifteen minutes on a Sunday, not five minutes every day. That is the rhythm people actually sustain.

The 2026 Expense Tracker is built for that monthly rhythm. Five tabs, one accent color, no pie charts, no multi-currency columns, no subcategory hierarchy. The Summary tab surfaces this month's total, top category, and budget status at a glance. The Monthly tab shows a 12-month rollup driven by SUMIFS — a grid that works identically in Excel and Google Sheets without a pivot table. The Transactions tab is the entry surface, with dropdown-enforced categories and a frozen header.

What's inside the 2026 Expense Tracker

The 2026 Expense Tracker is a spreadsheet workbook with five sheets: one setup sheet, one dashboard, one entry surface, one 12-month rollup, and one reference list. It is designed as a free expense tracker template you can inspect, edit, and reuse without macros, add-ons, or a paid account.

• Start Here — a one-page editorial masthead with the three design rules, the monthly ritual, and a contents index. Reads like the front matter of a magazine.
• Summary — a dashboard with four cards (This Month, YTD, Top Category, Budget Used) plus a sorted-descending horizontal bar chart of category spend and a per-type split for personal, business, and reimbursable rows.
• Transactions — the entry surface. Seven columns: date, vendor, category, amount, type, method, notes. Frozen header and date column, dropdown-enforced categories, right-aligned amounts.
• Monthly — a 12-month × category grid driven by SUMIFS. Each cell sums the matching category for the matching month; the rightmost column is the annual total, the bottom row is the month total.
• Categories — an editable reference list with 14 seed categories spanning personal and business spend, plus a monthly budget target per category that feeds the Summary's Budget Used card.

The download includes a blank workbook and an example workbook. The blank file is ready for your own month; the example file shows what six weeks of realistic spending looks like when the Summary, Transactions, Monthly, and Categories tabs are connected. Because the file is native .xlsx, you can use it as an expense tracker in Excel, upload it as an expense tracker template in Google Sheets, or keep it in any storage system that handles spreadsheets.

Free Google Sheets expense tracker template

To use the workbook in Google Sheets, download the ZIP, unzip it, open Google Drive, choose New, File upload, and upload the blank workbook. Open the uploaded file with Google Sheets, then choose File, Save as Google Sheets if you want a fully native copy. You now have a tracker that can be duplicated for each year, shared with a partner or accountant, or stored beside your other finance docs.

Google Sheets renders the whole workbook natively — formulas, dropdowns, conditional formatting, the category bar chart, and the frozen header + date column all work without modification. The SUMIFS formulas on the Monthly tab evaluate live as you add rows to Transactions; the Summary dashboard updates automatically. If you prefer QUERY over SUMIFS, the grid is small enough that either approach works; we use SUMIFS because it survives column inserts and copy-paste between Sheets and Excel.

Excel expense tracker template for 2026

To use the Excel version, open the blank workbook directly after unzipping the download. Save a master copy before editing, then duplicate that copy for each year. Excel is the right choice if you prefer local files, need offline access, want to adapt the workbook with Power Query connections to your bank export, or plan to extend the tracker with your own formulas or pivot tables.

The workbook uses plain Excel features only — no macros, no VBA, no add-ins. The SUMIFS on the Monthly tab, the COUNTIFS on the Summary, and the dropdown validation on Transactions all work in Excel 2016 and later. The bar chart on the Summary tab is a standard Excel chart that you can restyle or replace without breaking anything downstream.

Monthly expense tracker: 12-month rollup

The rollup is a 12-month × 14-category grid. Read it top to bottom to see which category you spent on every month; read it left to right to see how each month compares. The rightmost column sums the year per category; the bottom row sums the month across all categories; the intersection at the bottom-right is your annual total.

Each cell on the Monthly tab is a SUMIFS formula — not a pivot table. Pivot tables are powerful, but they break when you insert a column, rename a header, or copy the workbook to a coworker who does not know they need to press Refresh. A SUMIFS grid looks like a formula you can read, survives template sharing, and works identically in Excel and Google Sheets. The tradeoff: if you add a 15th category, you add a row. That is the price of portability.

For the chart on the Summary tab, we picked a horizontal bar chart sorted by category total. Pie and donut charts look friendly but lose ordinality past six slices — your eye can compare adjacent bars in a glance but cannot tell whether a 12% slice is smaller than an 11% slice. A bar chart is the quietly correct choice for category spending and the one Notion, Linear-style, and 37signals-adjacent design tend to land on.

How to use this expense tracker

To use the expense tracker, record transactions on the Transactions tab, review them monthly on the Summary tab, and adjust categories or budget targets on the Categories tab when the pattern changes. The template is designed around a short monthly habit rather than daily data entry.

1. Import the month. Once a month, copy your bank or card statement rows into the Transactions tab. The dropdown catches uncategorized rows — if a vendor does not fit an existing category, assign it to Misc and decide later whether it deserves its own row in Categories.
2. Reconcile the categories. Scan the new rows. If Misc is accumulating, promote the pattern into a real category. If a category has been at zero for three months, retire it. A category list that only grows becomes a trap.
3. Check the Summary. Open the Summary tab and read the This Month total, the Top Category, and the Budget Used percentage. If any category shows more than 100% of its monthly budget, that is the conversation worth having with yourself.
4. Review the Monthly. Scroll through the Monthly tab to compare this month to the previous three. Which categories crept up? Which dropped? The month-over-month pattern is more useful than any single month in isolation.
5. Adjust the Categories. Raise the Monthly Budget for categories you consistently exceed; lower it for ones you rarely fill. Budgets are a prediction, not a promise, and the prediction improves with each month of data.

The ritual is intentionally small. Fifteen minutes on the first Sunday of the month is enough to keep the workbook current; less than that and the data gets stale; more than that and the habit does not survive past month three. Skip the ritual if a real emergency happens; do not skip it twice.

How to make a budget with this expense tracker

If you are starting from zero, do not build a second planning system beside the tracker. Use the same workbook. A budget is just a prediction placed next to the log: Categories for targets, Transactions for reality, Summary for the gap. That is how to make a budget without adding another app to maintain. The tracker is not trying to teach personal finance. It is trying to keep the math visible enough that decisions stop feeling abstract.

The 50/30/20 split in one formula

For a quick 50/30/20 budget template, add a spare column on Categories and mark each category as Need, Want, or Saving. Then use SUMIF to total those groups against your take-home income: 50 percent for needs, 30 percent for wants, 20 percent for saving or debt. The formula is deliberately blunt. It gives the household budget a boundary before you spend an evening debating whether coffee belongs under Groceries or Dining. If income changes, update one cell and the recommended caps move with it. That is the part most static budget PDFs miss.

Setting monthly budget targets by category

The Monthly Budget column on Categories is where the plan becomes specific. Start with the last three months if you have them; otherwise, make a plain estimate and expect to be wrong. Rent, software, insurance, and subscriptions can be exact. Groceries, dining, transport, and health need a little margin. The goal is not a heroic monthly budget. The goal is a target you can review without flinching. Keep the first pass boring: round numbers, no subcategories, no annualized guesses hidden in notes. You can make it sharper after two real reviews.

Reviewing actual vs. budget each month

At month end, import the transactions, reconcile the categories, and open Summary before touching the targets. Budget Used tells you whether the plan was useful; the bar chart tells you where the drift happened. If one category is over once, leave it alone. If it is over three months in a row, change the target or change the habit. The Monthly tab keeps the argument honest because it shows the pattern, not just the latest bad week. Write the decision in Notes if it affects next month: cancel, renegotiate, move, ignore. Future-you needs the reason, not just the number.

Business expense tracker: track work spending in the same file

For work spending, the 2026 Expense Tracker uses a single unified sheet with a Type flag rather than two separate workbooks. Every row on Transactions is tagged Personal, Business, or Reimbursable. The Summary dashboard shows a per-type split for the current month; filter the Transactions table by Type to review just one side.

Freelancers who drive for work can keep mileage in the same file rather than maintaining a separate mileage log template. Add one row per trip under Travel or Transport, put the miles and route in Notes, and the mileage tracker sits beside the rest of the business expenses. When tax time arrives, filter Transactions by Type = Business and export the relevant rows for your accountant.

This design is correct for freelancers, solopreneurs, consultants, and anyone whose business is themselves. It starts breaking down at roughly 50 business transactions per month, when you have a separate business bank account, or when sales tax tracking becomes important. At that point, the right call is two workbooks: one for personal, one for business. YNAB, QuickBooks, and most accountants agree — the moment reconciliation matters, split.

The Categories tab ships with fourteen seed categories chosen to span both sides: eight leaning personal (Housing, Utilities, Groceries, Dining, Transport, Health, Subscriptions, Entertainment) and five leaning business (Software, Marketing, Travel, Professional Services, Office), plus a Misc catch-all. The Default Type column is advisory only — a hint about how a category is usually classified. The Transactions.Type column overrides it per row, so you can categorize a flight as Business this month and Personal the next without changing the reference list.

Export to CSV for your accountant

When it is time to send your expenses to an accountant, bookkeeper, or tax-prep software, the Transactions tab exports cleanly to CSV. In Excel: File, Save As, CSV UTF-8. In Google Sheets: File, Download, Comma-separated values. The resulting file has one row per transaction with date, vendor, category, amount, type, method, and notes — the columns every downstream tool expects.

For quarterly or annual filings, filter the Transactions table by Type = Business before exporting. The Categories used for business spend (Software, Marketing, Travel, Professional Services, Office) map cleanly to IRS Schedule C expense lines in the United States and to equivalent categories in most other tax jurisdictions. If your accountant uses QuickBooks or Xero, the CSV imports directly with a standard column mapping.

The methodology: why these five sheets, not seven

The 2026 Expense Tracker deliberately cuts the features most other templates include. Every omitted feature is a choice, not an oversight.

Four-column core, three optional columns

The required columns are Date, Vendor, Category, and Amount. Type, Method, and Notes are optional — the template will not complain if you leave them blank. Research across power-user spreadsheet communities converges on the same minimum: every additional required column roughly doubles entry friction and halves the chance the tracker still gets opened in month four.

No subcategory hierarchy

A Groceries > Produce > Apples split looks precise but almost never gets queried. Subcategories double entry time and rarely reward the effort. If a category becomes useful enough to split, promote the split to its own top-level category and retire the parent.

No multi-currency column

Ninety-five percent of a typical user's rows are in one currency. A currency column taxes every entry to account for the five percent that are not. If you genuinely need multi-currency tracking — say, for international business travel — add a second Transactions-style tab for foreign-currency rows and reconcile them separately. A single column is the wrong place to solve it.

SUMIFS, not pivot tables

Pivot tables are excellent tools when you own the workbook. They are fragile when you ship a template: they need refreshing, break on column inserts, and confuse non-power-users. A SUMIFS grid looks like a formula you can read, survives the copy-paste test, and renders identically in Excel and Google Sheets. The only cost is manual maintenance when you add a category — fair trade for a template designed to be shared.

Bars, not pies

A horizontal bar chart sorted descending is more readable than any pie or donut chart past six categories. Bars give you ordinality and precise comparison; pies give you vibes. For a category spending view, bars are the quietly correct choice.

Who the 2026 Expense Tracker is for

The 2026 Expense Tracker is for people who want a portable spreadsheet they can actually sustain — not a finance app with notifications, budgets, and weekly insight emails. It works especially well for freelancers, consultants, small-business owners, and anyone tracking a mix of personal and business spending without a full accounting stack.

• Use it if your monthly habit is more likely to stick than a daily habit.
• Use it if you want a file you can copy forward each year rather than a subscription.
• Use it if you share numbers with a partner, accountant, or bookkeeper and want them to open what you sent without installing anything.
• Use it if you like spreadsheets because they are transparent, portable, and easy to customize.

It is not the right fit if you need automatic bank sync, receipt scanning, tax-lot tracking, multi-user editing with change history, or full double-entry bookkeeping. Use Mint, YNAB, QuickBooks, or a dedicated accounting app for that. The 2026 Expense Tracker is deliberately smaller — one person, one workbook, one monthly ritual.

Expense tracker vs. other approaches

Several ways to track expenses work well; they just optimize for different habits and different levels of complexity.

The spreadsheet format is the main advantage. You own the file, you can open it in any year with any spreadsheet app, and you can customize it freely without waiting for a feature request to land. That makes the 2026 Expense Tracker a practical middle ground between a paper ledger and a heavyweight accounting platform.

Use with DropFile

The tracker stands on its own, but DropFile can help you get more out of the data. Use the workbook as your source of truth, then generate custom spreadsheet formulas to extend the Summary or Monthly tabs, set up conditional formatting to highlight over-budget categories, or use the PDF extractor to pull line items out of scanned receipts and statements before you paste them into Transactions. The tracker records the spend; the tools help you work with it.

When to branch out

This template handles ongoing personal expense tracking with one workbook. If your needs branch into specialized territory, a sibling template often fits better. For setting a monthly plan up front and watching budget vs. actual, the monthly budget template is built around income allocation and a 50/30/20 dashboard. For freelancers and small-business owners who need Schedule C-ready category mapping with deductibility tracking, the business expense tracker separates business and personal cleanly. For mileage logging tied to IRS Schedule C, the mileage log template handles odometer arithmetic, business-percentage splits, and IRS-rate reimbursement totals you can drop straight into a return.