Personal Expense Tracker

About the Personal Expense Tracker

Most people underestimate their spending in exactly the categories that quietly drain a budget: food, transport, and small conveniences. This tracker fixes that by making you log real transactions with a date, category, description, and amount, then instantly totalling everything and breaking it down by category with each slice's share of the whole. Instead of guessing where the money went, you get an itemised record and a ranked picture of your largest spending buckets.

The category breakdown is the heart of the tool. A running total tells you how much left your account, but the per-category percentages tell you why. Seeing that housing is three-quarters of the month while food is the second-largest slice reframes the conversation from vague guilt to specific, fixable line items. Categories are free text, so you can be as broad or granular as you like and rename them to match how you actually think about your money.

It works as a rolling log you add to throughout the month, or as an after-the-fact reconciliation you build from a bank statement in one sitting. Either way, the value comes from capturing real numbers rather than estimates.

How the Personal Expense Tracker works

Each row holds a date, a category label, a free-text description, and an amount. The tracker sums the amount column into total spent, and it also groups rows by their category text, adding up the amounts within each group. Any row left without a category is bucketed as Uncategorized so nothing silently disappears from the totals.

The category summary is then sorted from largest to smallest so your biggest spending appears first, and each category shows both its dollar total and its percentage of overall spending, calculated as the category total divided by the grand total. Because grouping keys off the exact category text, two rows must use identical spelling and capitalisation to merge, so Food and food would count as separate categories.

Everything recalculates as you edit, add, or delete rows, so the totals and the ranking always reflect the current list. There is no date filtering; the tool sums whatever rows are present, so keep one list per period you want to analyse.

Worked example

The default log has six entries for January 2026: Rent 1,500, Groceries 220, Gas 60, a movie night 35, a restaurant meal 85, and an electric bill 110. The amount column sums to a total spent of 2,010 dollars, shown in the headline figure.

Grouped by category, Housing leads at 1,500 dollars, which is 74.6 percent of the month. Food combines the 220 grocery run and the 85 restaurant meal into 305 dollars, or 15.2 percent, making it the clear number-two category. Utilities is 110, Transport is 60, and Entertainment is 35, each a single-digit share. The lesson is immediate: housing dominates and is hard to move quickly, so the fastest discretionary wins live in the food category, where the 85 dollar restaurant meal is more than a third of total food spend.

Tips & common mistakes

• Keep category names consistent. Because grouping matches exact text, Food and Dining split into two buckets and hide your true food total; pick one label and reuse it.
• Log every small purchase, not just the big ones. The 35 dollar and 60 dollar rows are exactly the discretionary spending that adds up and that people forget when estimating from memory.
• Use one tracker per month so the totals and percentages describe a clean period. Mixing months makes the category shares meaningless.
• Rebuild a month quickly by pulling transactions straight from your bank and card statements rather than reconstructing from memory, which almost always undercounts.
• Watch the percentage column, not just the dollars. A category that is a small dollar amount but a growing share of your total is an early warning of lifestyle creep.

Personal Expense Tracker: frequently asked questions