How I Track My Apartment Spending Every Month With a Simple System

By Peter Roy

Published on:

For most of 2022 I had no real idea where my money was going. I knew rent left my account. I knew I was buying food. But the middle of the month would come and I would check my balance and feel confused about why there was less there than I expected. In early 2023 I built a simple tracking system that took about 20 minutes to set up and has not changed much since. This post is exactly what that system looks like, why it works for me, and how you can copy it without buying any app or spending any money.

For six months after I got my first real job, I had no budget.

Not a bad budget. Not a loose budget. No budget at all. Money came in on the 15th and the last day of each month and I spent it on things I needed and some things I did not need and by the end of the month there was usually something left but sometimes not much and I never really knew which way it was going to go until I checked.

That is not a plan. That is just hoping.

The problem was I did not feel like I was spending recklessly. I was paying rent on time. I was buying groceries. I was not going out every night or buying expensive things. So why did some months end with almost nothing left? I genuinely did not know. That confusion sat with me for most of 2022 and into early 2023 until I finally got frustrated enough to actually look.

What Made Me Finally Start Tracking

February 2023. I opened my bank app to check my balance and I had $94 left until my next paycheck in eight days.

Rent was paid. Utilities were paid. I was not behind on anything. But $94 for eight days felt wrong. I made a real salary. How was I this close to the edge?

I sat down that evening and went through my last 30 days of bank and card transactions line by line. This took about 45 minutes and it was genuinely uncomfortable to do because the numbers told a story I had not been paying attention to.

Eating out: $287. I thought I ate out maybe twice a week. It was closer to five times a week when I counted every coffee, every lunch near the office, every evening I ordered delivery because I was tired.

Subscriptions: $83. I knew I had some but I had not counted them all together in a while. There were six of them. Two I barely used.

Random buying: $140. Things I bought online without thinking much. A phone case. A book I had not read yet. Some kitchen thing I saw and thought would be useful. A pair of shorts.

None of those individual purchases felt like a big deal when I made them. Together in one month they added up to $510 that I had not planned for and could not clearly account for. That was the moment I understood why the balance kept surprising me.

The System I Built

I wanted something simple. Not an app with 14 categories and graphs and a monthly subscription fee. Just a clear picture of where the money goes.

I use a Google Sheet. Free, lives in my Google Drive, works on my phone and my laptop. I set it up once and update it for maybe ten minutes at the end of each month.

Here is exactly how it is structured.

At the top I put my take-home pay for that month. Not my salary before tax. The actual number that hits my bank account.

Below that I have two sections. Fixed costs and variable costs.

Fixed costs are things that are the same or nearly the same every month. Rent, internet, renters insurance, any subscriptions I have decided to keep. These do not change much so I can fill them in quickly.

Variable costs are everything else. Groceries, eating out, transport, clothes, fun spending, random buying. These change every month and are the ones worth tracking closely.

At the bottom I calculate what is left after everything. If the number is positive and close to what I planned to save, good month. If the number is smaller than I wanted, I look at which variable category ran high and think about why.

That is the whole system. One sheet, two sections, ten minutes at the end of the month.

The Categories I Track and Why These Ones

I tried tracking too many categories at first and it made me stop doing it because it felt like too much work. I now use eight categories and they cover everything without being overwhelming.

CategoryWhat goes in it
RentMonthly rent payment
UtilitiesElectricity, internet, water if separate
InsuranceRenters insurance
SubscriptionsEverything on auto-pay
GroceriesEverything from the grocery store
Eating outRestaurants, delivery, coffee, work lunches
TransportRideshare, bus, any car costs
Everything elseClothes, random buying, fun, anything that does not fit above

The everything else category is important. When I tried to split random spending into five sub-categories I spent more time deciding which box something went in than I did actually learning anything from it. One catch-all box tells me clearly how much I spent on things that were not planned. If that number is high, I know to look closer.

How I Fill It In Without It Feeling Like a Chore

The key for me was not doing it daily. I tried tracking every purchase as it happened and I lasted about four days before I stopped.

Once a month works because it is fast and the picture you get is complete. I sit down on the last day of the month or the first day of the next one, open my bank statement and my credit card statement side by side, and go through every transaction. I put each one into the right category in my sheet. Most months this takes between ten and fifteen minutes.

The only rule I have is that I actually do it every month without skipping. One skipped month is fine. Two in a row and the habit breaks and I am back to not knowing where my money went.

The Consumer Financial Protection Bureau has a simple free budgeting worksheet at consumerfinance.gov/consumer-tools/budget that is a good starting point if you want something already formatted before you build your own version.

What I Learned in the First Three Months of Tracking

The first month I tracked properly, February 2023, I found the $510 problem I mentioned earlier. That was the eating out, subscriptions, and random buying sitting together in one place where I could actually see them.

The second month I watched those numbers. Eating out dropped from $287 to $198. Not because I forced myself to stop eating out but because seeing $287 in black and white made me make slightly different choices without even trying that hard. Just knowing the number was being watched changed my behavior a little.

The third month I felt something shift. I stopped being confused at the end of the month. I knew roughly what the number would be before I even opened the sheet because I had started noticing my spending in a different way during the month. Not obsessively checking. Just being more aware.

That awareness is the real thing tracking gives you. Not the spreadsheet. Not the categories. Just the knowledge of what you actually do with your money versus what you thought you were doing with it.

If you want to see how this kind of tracking played out across a full year and how my budget compared in different years, my post on my renter budget in 2022 vs 2026 shows the real numbers from both periods.

The Subscriptions Problem That Tracking Exposed

I mentioned I found six subscriptions adding up to $83 a month when I finally looked. Let me be specific because I think a lot of people have the same thing happening quietly.

I had a streaming service I was actively using, $15. A music app I had upgraded to paid when the free version would have been fine, $10. A cloud storage plan I had upgraded for a project and never downgraded, $3. A fitness app I had signed up for in January and used for maybe two weeks, $15. A news site subscription I had started during a free trial and forgotten to cancel, $12. And a meal kit delivery service I had paused but not fully canceled, $28 sitting there waiting to charge me again.

That last one had been paused for three months and I had completely forgotten it existed. I canceled it immediately.

Total subscriptions after cleanup: $25 for the two things I actually used. Saving $58 a month, $696 a year, just from looking at a list.

I wrote about this kind of quiet spending in more detail in my post on what first-time renters waste money on, where subscriptions came up as one of the biggest silent drains that most people do not notice until they actually count.

What Tracking Did Not Fix

I want to be honest about this because I think some budgeting advice oversells what tracking can do.

Tracking showed me where my money was going. It did not automatically make me stop spending on things I wanted to spend on. Eating out is still my biggest variable expense. I know exactly how much I spend on it every month. I still spend more than I should most months.

The difference is I now choose to spend that money with open eyes rather than spending it and being confused later. That feels meaningfully different even when the number is higher than I would like.

Mint, which was one of the most popular free budgeting apps for a long time, shut down in 2024. NerdWallet, which absorbed some of Mint’s features, has a good breakdown of free budgeting tools that still work at nerdwallet.com/article/finance/budget-apps. If you prefer an app over a spreadsheet, that list is worth looking at.

Tracking also did not fix the months where a big unexpected cost hit. A medical bill, a broken thing, a flight home. For those months I just watched the number go negative and dealt with it. Having an emergency fund handles those moments better than any tracking system can. My post on building an emergency fund when rent takes most of your paycheck covers how I built that alongside the tracking habit.

The Ten Minute Monthly Routine That Changed How I Feel About Money

Last day of the month. Open the bank statement. Open the card statement. Go through every line. Put each one in a category. Add them up. Look at the total. Compare to last month.

Ten minutes. Sometimes fifteen if it was a busy month with a lot of transactions.

That is it. No daily logging. No complicated app. No real-time alerts. Just one honest look at the whole month once it is done.

The clarity that comes from that ten minutes lasts all month. I do not feel confused about my money anymore. I do not end months wondering where everything went. I know exactly where it went because I looked.

If you want to figure out the right split between rent and the rest of your budget before you even start tracking, my post on how much income should go to rent gives you the ratio to aim for and shows what happens to the rest of your budget when rent takes too big a slice.

FAQ

Do I need a special app to track my apartment spending?

No. A free Google Sheet works perfectly. The most important thing is that you actually do it every month, not which tool you use to do it. A simple sheet you open once a month beats a fancy app you stop using after two weeks.

How many spending categories should I track?

Six to eight is enough for most people. Too few and you cannot see where things are going. Too many and it becomes a chore to sort every transaction and you stop doing it. Eight categories covers almost everything without making the process feel heavy.

What is the single most useful thing tracking shows you?

The gap between what you thought you were spending and what you actually spent. Most people who start tracking are surprised by at least one category. For me it was eating out. For a lot of people it is subscriptions or random online buying. You cannot fix a leak you cannot see.

How long does it actually take to do this each month?

Ten to fifteen minutes if you do it once a month at the end. It feels longer the first time because you are setting up the sheet and figuring out your categories. After that it is fast because the structure is already there and you are just filling in numbers.

What should I do if my tracking shows I am spending more than I earn?

Look at which variable category is highest and ask honestly whether you can bring it down. Eating out and subscriptions are usually the easiest to cut without feeling deprived. Then look at whether your fixed costs, especially rent, are taking too large a share of your income. My post on how much income should go to rent helps you figure out if rent is the root of the problem.

Is it worth tracking if I am already pretty careful with money?

Yes, because careful is not the same as informed. A lot of people who feel careful with money are surprised when they actually look at the numbers. Tracking does not just help people who overspend. It confirms for careful spenders that their habits are as good as they think, or shows them one or two areas where they were not as careful as they felt.

What is the hardest part of keeping a tracking habit going?

Not skipping months. One skipped month is recoverable. Two in a row and the habit tends to fall apart because you lose the month-to-month comparison that makes tracking meaningful. Set a reminder on the last day of each month. Even if you only have five minutes, do a rough version. A rough look is worth more than no look.

Leave a Comment