Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| Month shown | 46327 | Change the month, the currency and the warning level on the Settings sheet. | |||
|---|---|---|---|---|---|
| Spent this month | 2,392.11 | Expenses logged this month | 19 | ||
| Monthly budget | 2,715.00 | Average expense | 125.90 | ||
| Left to spend | 322.89 | Biggest category this month | Rent | ||
| Budget used | 88.1% | Categories over budget | 0 | ||
| Spent last month | 2,390.42 | Rows that need a fix (Check column) | 0 | ||
| Category | Budget | Spent | Left | % used | Status |
| Rent | 1,250.00 | 1,250.00 | 0.00 | 100.0% | Near limit |
| Groceries | 400.00 | 325.80 | 74.20 | 81.5% | Near limit |
| Dining out | 150.00 | 111.60 | 38.40 | 74.4% | On track |
| Utilities | 180.00 | 139.65 | 40.35 | 77.6% | On track |
| Transport | 160.00 | 103.60 | 56.40 | 64.8% | On track |
| Phone and internet | 90.00 | 89.99 | 0.01 | 100.0% | Near limit |
| Health | 80.00 | 60.00 | 20.00 | 75.0% | On track |
| Shopping | 150.00 | 129.00 | 21.00 | 86.0% | Near limit |
| Entertainment | 100.00 | 97.99 | 2.01 | 98.0% | Near limit |
| Subscriptions | 45.00 | 24.98 | 20.02 | 55.5% | On track |
| Gifts and donations | 50.00 | 25.00 | 25.00 | 50.0% | On track |
| Other | 60.00 | 34.50 | 25.50 | 57.5% | On track |
| Total, listed categories | 2,715.00 | 2,392.11 | 322.89 | 88.1% | |
| Not on the list | 0.00 |
Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
What is inside
- Dashboard: The month you are reviewing at a glance: spent this month, monthly budget, what is left, the share of budget used and spending last month. Below it, every category with its budget, spent, left, percent used and a status (On track, Near limit, Over budget), spending by payment method, and four charts.
- Expenses: The log you type into: date, description, category and payment method from dropdowns, and amount. A Check column flags a row with no amount, no date, no category or a category that is not on your list. Room for 1,500 expenses.
- Monthly: Every category across the twelve months of the year, with a monthly total, a line for spending outside your category list, and the year total of each category. A cell turns red when a category goes over its monthly budget.
- Categories: Your list of categories (up to 30) with a monthly budget for each, and your list of payment methods. They feed the dropdowns on the Expenses sheet.
- Settings: Your name, the currency symbol, any date in the month to review, and the percentage at which a category is flagged as Near limit.
The file opens on a start tab (“Start here”) that explains how to use it.
What makes it different
Most expense trackers stop at a list with a total. This one keeps the list simple, one line per purchase, and does the rest: it compares each category with its own budget, warns you before you go over, and shows the month beside last month and the rest of the year. The sample is one person's spending in October and November 2026, so you can see every sheet working before you replace it with your own.
How do I track my expenses in Excel?
Keep one table with one row per purchase: date, description, category, how you paid and the amount. Pick the category from a dropdown instead of typing it, so the same category is always spelled the same way. That is what makes the totals reliable.
Then add the totals with SUMIFS, which adds the amounts that match a category and a date range. In this template that is already done: the Dashboard adds up the month you choose, and the Monthly sheet adds every category for every month of the year. You only type the rows on Expenses.
How do I set a monthly budget for each expense category?
Write the categories you actually spend on and a monthly amount for each on the Categories sheet. Start from what you spent last month and round it, rather than from an ideal figure you will not keep. A category with a budget of 0 has no limit and is simply tracked.
In the sample, the monthly budgets add up to 2,715.00 and November spending so far is 2,392.11, which leaves 322.89 or 11.9% of the budget. Groceries is at 325.80 of 400.00, so its status reads Near limit. The Near limit warning starts at the percentage you set on Settings (80% in the sample).
Daily, weekly or monthly: how often should I log expenses?
Whatever you will keep doing. Logging each purchase on the day is the most accurate, and a weekly sit-down with your receipts and card statement works too, because every row carries its own date. The Dashboard does not care when you type a row, only what date is on it.
When you want the bigger picture, see the business expenses budget if the spending is for a business, or the cash book if you also want a running balance of cash in and cash out.
How to use it
- On Settings type your name, your currency symbol, and any date in the month you want to review. The Dashboard shows that month.
- On Categories list the places your money goes and a monthly budget for each one. Leave the budget at 0 if you do not want a limit. Edit the list of payment methods next to it.
- On Expenses add one row per purchase: date, a short description, the category and payment method from the dropdowns, and the amount.
- Read the Dashboard: spent this month, budget left, a status for each category (On track, Near limit, Over budget), spending by payment method and the monthly trend.
- Open Monthly to see every category across the twelve months of the year.
- To review another month, change the date on Settings. Your old rows stay on the Expenses sheet.
Before you start:
- Capacity: 1,500 expenses, 30 categories and 6 payment methods. The Dashboard lists the first 15 categories.
- The Settings date decides the month on the Dashboard and the year on Monthly. Change it and every figure follows.
- The Check column on Expenses flags a row with no amount, no date, no category or a category that is not on the Categories sheet.
- Spending in a category that is not on the list still counts in the monthly total and shows as "Not on the list" on the Dashboard.
- The status turns to Near limit when a category reaches the warning percentage on Settings (80% in the sample) and to Over budget past 100%.
- Use one currency in one workbook. The currency symbol on Settings is only a label.
Still running this on Excel?
This sheet needs you to open it and type in every expense. In MyAccBot you send a photo of the receipt or a voice message on Telegram, and it handles the rest.
| In this sheet | In MyAccBot |
|---|---|
| You open the sheet and type in every expense by hand. | You send a photo of the receipt, a line of text or a voice message on Telegram, and the data is extracted and classified as income or expense. |
| You find out about a budget overrun at the end of the month. | You set a monthly spending limit and get an alert at 80% and at 100%. |
| Summing up the month takes hours. | An Arabic PDF report on the first of every month, plus a formatted XLSX file you hand to your accountant. |
| You dig through old receipts looking for an amount. | You ask the bot for the total of a month, between two dates, or for a particular supplier, and it answers from your data. |
Frequently asked questions
Is this expense tracker really free?
Yes. Download it, use it for yourself or your household and change anything you like. There is nothing to sign up for to open the file.
Does it work in Google Sheets and LibreOffice?
Yes. It uses only ordinary formulas such as SUMIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets. In Google Sheets, upload the file to Drive and open it with Sheets.
How many expenses and categories can it hold?
1,500 expenses, 30 categories and 6 payment methods, and the Dashboard lists the first 15 categories. When the log is full, save a copy and start a new one for the next year.
Can I track a different month or year?
Yes. Change the date on Settings to any date in the month you want. The Dashboard shows that month and the Monthly sheet shows that year. Older rows stay in the log.
Why does a row say Unknown category?
The category on that row is not on the Categories sheet, usually because of a spelling difference. Pick it from the dropdown or add it to the list. Until then the amount still counts in the month's total and shows as Not on the list.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
More free templates for: Personal finance
More free templates
- Monthly Household Budget Template for Excel
- Monthly Habit Tracker Template for Excel (With Streaks)
- Rotating Savings Club Tracker for Excel (Susu, Tanda, ROSCA)
- Cash Flow Forecast Template for Excel (12 Months)
- Fixed Asset Depreciation Schedule for Excel
- Customer Statement Template with Aging (Excel)
- Gym Membership Tracker for Excel
- Freelance Project and Invoice Tracker for Excel
- Event Planning Checklist and Budget Template for Excel
- Fleet Fuel and Maintenance Log Template for Excel
- Ad Performance Tracker for Excel (ROAS, CPA)