FINBIZTOOLS
How to Use an Expense Tracker
What this template contains and who it is for
This workbook suits personal spending review. It contains Instructions, Expense Log and Summary & Analysis. The log records date, category, description, payment method, amount and notes. Use consistent category names because summaries match categories. Sample dates and payees are examples, not your records. For business purchases, use the separate Business Expense Tracker and appropriate supporting evidence.
Worked example
Three purchases of ₹200, ₹350 and ₹450 total ₹1,000. If one purchase is entered twice, a correct SUM formula still reports an incorrect total. Reconcile entries rather than trusting the dashboard alone.
How to use FinBizTools
- Download the Personal Expense Tracker and keep an untouched original.
- Read Instructions and replace the sample rows in Expense Log.
- Use consistent dates, categories and numeric amounts.
- Check Summary & Analysis against your source statements and confirm expanded rows are covered by formulas.
Open the tools
Download related templates
Common mistakes and limitations
A spreadsheet is not a bank reconciliation service. Text-formatted dates or amounts may not behave like real dates or numbers. Do not assume a category summary proves tax eligibility.
Setting up your categories
The Summary & Analysis sheet groups spending by category, so the categories you use in the Expense Log decide what you learn. Before you start, choose eight to twelve categories that reflect how you actually spend, for example: Groceries, Eating out, Transport, Housing and utilities, Health, Shopping, Entertainment, Education, Gifts and festivals, and Miscellaneous. Spell each category exactly the same way every time — “Groceries” and “Grocery” are counted as different categories by the summary formulas.
Worked example: a week of entries
| Date | Category | Description | Payment method | Amount |
|---|---|---|---|---|
| 2026-10-01 | Groceries | Weekly vegetables and milk | UPI | ₹1,450 |
| 2026-10-02 | Transport | Metro card top-up | UPI | ₹500 |
| 2026-10-03 | Eating out | Dinner with friends | Credit card | ₹1,200 |
| 2026-10-05 | Housing and utilities | Electricity bill | Net banking | ₹1,850 |
| 2026-10-06 | Groceries | Monthly staples | Debit card | ₹3,200 |
After this week the summary would show Groceries ₹4,650, Housing and utilities ₹1,850, Eating out ₹1,200 and Transport ₹500, totalling ₹8,200. Recording the payment method as well lets you see, for example, how much went on the credit card before the bill arrives.
A routine that takes five minutes
- Daily or every other day: enter new expenses from your UPI app history and card notifications while you still remember what they were.
- Weekly: glance at the category totals and compare them with your budget.
- Monthly: reconcile with your bank and card statements, add any cash spending you missed, and copy category totals into the Monthly Budget Planner as actuals.
Getting more out of the data
- Filter the log by category or payment method to see every entry behind a total.
- Sort by amount to find your largest expenses quickly.
- Compare months by keeping one file per month, or by adding a month column and using a pivot table.
- Spot small leaks: frequent small amounts — coffee, food delivery, subscriptions — often add up to more than people expect.
Tracking cash and shared expenses
Cash spending is the easiest to forget. Withdrawals from an ATM are not expenses themselves; record what the cash was spent on, or record the withdrawal under a “Cash” category if you cannot remember. For shared expenses such as a trip or rent split with flatmates, record only your share, and note who owes what in the Notes column. If you track business purchases, use the separate Business Expense Tracker, which has GST columns and keeps business and personal records apart.
Frequently asked questions
Why is an entry missing from a category total?
Check the category spelling, the cell type and whether the entry is inside the formula’s referenced range.
Disclaimer
This guide is educational. Examples are illustrative, not financial, tax or legal advice. Verify important decisions and current requirements. Read the FinBizTools Disclaimer.