Personal Expense Tracker

Most money advice was not written for us.
Save twenty percent, run the 50/30/20 rule, open a brokerage account, invest early. It is everywhere, and almost none of it survives contact with how money actually works in Pakistan.

When the average income is a few hundred dollars a month, saving twenty percent is a rounding error, and “invest early” is a distraction from the one thing that moves the needle at that stage: earning more.

I made that whole case in Having a Money Mindset. This guide is the practical other half: a personal expense tracker built for the realities here, so you can actually see where your money goes.

The systems here are not built to track your money for you. Banking apps are bad and barely talk to each other. Utility bills are not automated, plenty of people still stand in line to pay them.

The newer digital wallets do not cleanly plug into anything. Other places, an app quietly categorizes every swipe for you. Here, if you want to know where your money goes, you have to be the system. That is what this guide is: a way to run your own finance department, in whatever tool you already use.

Nothing to download.

Track Your Money Like a Business

I have tracked my own money this way for the better part of six years: fixed costs, variable costs, and a balance sheet at the end of every month.

Nobody taught me the format, it was just what made sense to me. It was only when I started running a business that it clicked, what I had built for myself was almost exactly what a business does with its books: a P&L and a balance sheet.

That is first-principles thinking doing its quiet work. Break a problem down to what it actually is, money in, money out, what you are left with, and you tend to land on the same answer serious operators reached, without ever being taught it. Fundamentals winning again. I wrote more about reasoning this way here: first principles.

So run your personal money like the business it is. A simple monthly P&L, income minus expenses, and a running balance sheet of what you are actually worth. That is the whole system. It sounds heavy. It is really a table you update a few minutes a week.

And it genuinely does not matter what you build it in. This used to be an Excel sheet for me, but I am not going to pretend the tool matters. Google Sheets, Excel, Notion, Obsidian, anything with cells, rows, and basic arithmetic works. You could vibe-code a little app with AI in an afternoon if you wanted, that is completely standard now. There is no excuse left for not organizing yourself like this.

What Tracking Actually Tells You

At the end of the month there is less than you hoped, and you cannot fully explain where it went. So you tell yourself a story:

“That was an expensive month”
“Next month I will be careful”
“I just need to save more”

Then next month looks exactly the same, because you are managing something you never measured.

That last line is the reflex everyone reaches for: “I need to save more”
Usually it is the wrong lever. There are only three: spend less, save more, or earn more.

Your actual problem is one of them, and you cannot know which until you have the numbers in front of you. For most people reading this, the honest answer is to earn more. When your income is low, trimming your spending frees up scraps, while the same effort put into raising your income changes the whole picture.

But you only earn the right to that conclusion by tracking. If you do not know where your income actually goes, you cannot tell whether it is leaking out the bottom or there was never enough coming in the top.

So the tracker is really a diagnostic. Maybe your fixed costs are quietly eating you. Maybe your spending is lean and you are simply underpaid. Maybe both are fine and you never move anything aside. Same feeling of “money is tight” three completely different fixes. If earning turns out to be your lever, that is its own skill, start with Having a Money Mindset and Salary Negotiation Strategy.

Fixed vs Variable, Tracked Separately

The tracker holds two kinds of expenses, and the whole thing works better if you keep them apart.

Fixed costs are the same every month no matter what you do. Rent. Internet. Your mobile plan. Subscriptions. You set them once and they barely move.

Variable costs change month to month with how you live. Groceries, fuel, eating out, utilities that swing with usage, shopping. Most of your actual decisions live here.

Here is what the two look like, with rough monthly figures (just as example) in rupees

Fixed

Fixed Expense	Amount	Notes
Rent	45,000	paid 1st, bank transfer
Maintenance	3,000	building / society charge
Internet	4,000	auto-debit monthly
Mobile	1,500	prepaid top-up
Subscriptions	10,000	Netflix, iCloud, Spotify, gym
Total Fixed	63,500	check once a month

Variable

Variable Expense	Amount	Notes
Groceries	28,000	one cell, add as you go
Utilities (electricity, gas, water)	15,000	swings with the season
Fuel / Transport	12,000
Eating Out / Delivery	9,000
Charity	8,000	zakat, donations
Shopping	7,000	clothes, gadgets
Health / Misc	4,000
Total Variable	83,000	log chunky items as they happen

Two small tricks make this painless.

On the variable side, keep each category on one row and let the cell do the adding. Start the cell at =0, and every time you spend, extend the formula: =0+2000+3500+1800. That one cell always shows the running total for the month, so you never make a new row just because you bought groceries twice.

And if your tool keeps cell history the way Google Sheets does, you get a free audit trail, you can always look back at exactly what went into that number. If your tool supports it, use it.

On the fixed side, use the notes column. Jot how and when each one was paid: on the 1st, in cash, online transfer, which account. When a bill looks off three months later, that one note saves you the detective work.

The Cadence: Day, Week, Month

Different things get tracked at different rhythms.

Day to day, log the chunky variable spends. Anything over about 500 rupees, drop it in the moment it happens. It takes ten seconds. Skip the chewing gum. You are after the dinners, the fuel, the impulse buys, the things that actually add up.

Week to week, glance at the fixed side. Fixed costs barely change, so they need almost nothing. Once a week or once a month, confirm the rent, the bills, the subscriptions, and adjust anything that moved.

End of month, close the books. Put a recurring slot in your calendar, the last day of the month or the first of the next. Sit down for fifteen minutes and fill in the balance sheet (see below): what you started with, what came in, what went out, what you are left with. Then duplicate the sheet for next month and start again.

That is the trick that separates people who track from people who “mean to.” The daily habit is tiny, and the calendar carries the monthly one so your memory does not have to.

The Month-End Balance Sheet

At month end you are not just totaling costs, you are checking that your net worth moved the way you think it did. Net assets means everything you own that is liquid or close to it: cash, bank balance, savings, and investments. You want two numbers, what you were worth at the start of the month and what you are worth at the end.

Line	Amount
Start of Month Net Assets	420,000
Income (all sources)	+ 165,000
Total Expenses (fixed + variable)	– 146,500
Expected End Net Assets	438,500
Actual End Net Assets (counted)	425,000
Unlogged Spending (the leak)	13,500

Two things to understand here.

Investments are not expenses. Say 120,000 of your 425,000 net worth sits in stocks. If you moved another 15,000 in this month, your net assets did not drop by 15,000, the money just changed form, from cash to shares. Track investments as their own line so you can watch them grow, but never file them as a cost. A cost is money gone. An investment is money moved.

The gap is the leak. Add your starting net assets and your income, subtract what you logged, and you get what you should be worth. Then count what you actually are worth. The difference is money that left without a name on it. In this example that is 13,500 rupees that just evaporated. That number is almost always bigger than people expect, and shrinking it month over month is the clearest sign the habit is working. You do not chase it by logging every rupee, you catch it by closing the books.

Reading the Numbers: Trim, Earn, or Save

Two or three months in, the tracker answers the question you started with.

If your fixed costs are eating most of your income, the lever is trim. Renegotiate the rent, cut the dead subscriptions, drop the plan you never use.

If your spending is already lean and there is still nothing left at month end, the lever is not spending, it is earning. No budget fixes an income that is too low, and for most people early on, that is the real problem. Put your energy there.

And if you earn fine and spend fine but never build anything, the lever is discipline, deliberately moving money into savings and investments before you can spend it.

You cannot know which of the three is your fight until you have run the numbers. That is the entire point.

Track First, Then Fix

Everyone wants to skip to the fix. Save more, spend less, earn more. But a fix aimed at the wrong problem just burns the one thing you cannot get back, which is time.

So track first. Not to the last rupee, just honestly enough to see the shape of it. Run it like a business, a light P&L through the month and a real balance sheet at the end. Give it two or three months. It will tell you whether your problem is your spending, your savings, or your income, and once you know that, the fix is obvious.

Build it in whatever tool you already use. Log the chunky stuff daily. Close the books monthly. Watch the leak. Then go fix the right thing.

With or without my help – I wish you the best.

---

---