Why Your Income Disappears Before Month-End — and How to Fix It for Good
You reach the 20th of the month and your account is already maxed out. You know you’ve received your paycheck, paid bills, but can’t quite pinpoint where the money went. This feeling is more common than it seems: according to research by the Credit Protection Service (SPC Brasil) and the National Confederation of Store Managers (CNDL), a significant portion of Brazilians end the month without being able to detail their own expenses. The problem is rarely the lack of money itself — it’s the lack of visibility over it.
The good news is that there is a simple, free, and powerful tool to change this scenario: the monthly expense spreadsheet. It doesn’t require advanced financial knowledge, doesn’t depend on any paid app, and can be adapted to anyone’s reality — whether a salaried worker, a freelancer with variable income, or a family with multiple income sources.
In this article, you will learn, step by step, how to create your own spreadsheet from scratch, what categories to include, how to maintain the habit of recording, and how to use the data to make more informed financial decisions. Let’s get started.
What is a Monthly Expense Spreadsheet and What is it For
A monthly expense spreadsheet is an organized record of everything that enters and exits your budget in a given month. It acts as a mirror of your financial life: showing how much you earn, how much you spend, where you spend, and how much (if any) is left over.
Unlike a bank app, which only records account transactions, the spreadsheet allows you to:
- Include cash expenses, which apps don’t capture
- Categorize expenses in a way that makes the most sense for your life
- Make projections and future plans
- Compare different months and identify patterns
It doesn’t solve your financial problems automatically — but it gives you the information needed to solve them. Without data, any financial decision is a guess.
Before Creating: Understand the Three Pillars of Budgeting
Before opening any spreadsheet, it is important to understand the basic structure of a personal budget. It is organized into three major blocks:
1. Income
Everything that comes in: net salary (already deducted IR and INSS), extra income, freelances, received rents, pensions, benefits. The critical point here is to always use the net value, that is, what actually lands in your account.
2. Fixed Expenses
Expenses that repeat every month with the same or very similar value: rent, financing installment, school fees, health plan, streaming subscriptions, internet, gym. They are easier to predict.
3. Variable Expenses
Expenses that fluctuate from month to month: groceries, fuel, leisure, restaurants, clothing, pharmacy. These are the ones that surprise people the most — and the ones the spreadsheet helps control more effectively.
Some experts add a fourth block: irregular or seasonal expenses, like property taxes, vehicle taxes, school supplies, and year-end gifts. Including them in annual planning avoids surprises.
Step by Step: How to Create Your Spreadsheet from Scratch
You can use Google Sheets (free, accessible via browser or mobile) or Microsoft Excel. The format is the same.
1. Create a new file and name it with the month and year e.g., “Budget – January 2026”. Having one file per month facilitates future comparisons.
2. Create the income tab In the first section, list all your income sources with the expected value and the actual value received. Two side-by-side columns allow you to compare planned with actual.
| Income Source | Expected Value | Received Value |
|---|---|---|
| Net Salary | $3,500.00 | $3,500.00 |
| Design Freelance | $800.00 | $600.00 |
| Total | $4,300.00 | $4,100.00 |
3. Create the fixed expenses section List each fixed expense with its monthly value. Include even the small ones: a $29.90 subscription you forgot may seem little, but in 12 months it’s almost $360.
4. Create the variable expenses section by category Separate into clear categories:
- Food (groceries + markets)
- Dining out
- Transport (fuel, Uber, public transport)
- Health (pharmacy, consultations not covered by the plan)
- Leisure and entertainment
- Clothing
- Personal care (salon, hygiene)
- Pets
- Others / unforeseen
5. Calculate the balance At the end: Balance = Total income – Total expenses. If the balance is negative, you are spending more than you earn. If positive, this is the amount available to save or invest.
6. Add a “planned vs. actual” column For each category, set a value you intend to spend and, throughout the month, fill in what you actually spent. This comparison is where the magic happens: you start to see, in real-time, if you are within or outside the plan.
7. Include a line for savings or reserve Treat savings as a fixed expense — that is, set aside the amount at the beginning of the month before spending. This is the logic of the “pay yourself first” concept, widely recommended in financial education.
Categories People Forget (and That Make a Difference)
Some expenses go unnoticed because they are sporadic or automatic. Pay attention to:
- Digital subscriptions: Netflix, Spotify, Adobe, cloud storage — add everything before listing
- Bank fees: many traditional banks still charge monthly fees; check your statement
- Installment interest: when you split payments on a credit card, the real cost of the product is higher; record the installment value, not the total
- Children’s expenses: school supplies, extracurricular activities, tickets
- Home maintenance: cleaning products, small repairs, disposable items
If you have variable income — like freelancers and self-employed individuals — organizing the spreadsheet requires additional care. I recommend reading our article Freelancer Finances: How to Organize Without a Fixed Salary, which offers specific strategies for those without a fixed monthly income.
How to Maintain the Habit: Practical Tips to Not Abandon the Spreadsheet
Creating the spreadsheet is the easy part. The challenge is keeping it updated. Here’s what works in practice:
- Set aside 5 minutes a day to record the day’s expenses. It’s easier than trying to reconstruct an entire week’s memory at the end of the month.
- Keep receipts and invoices in a folder on your phone or a physical envelope. Discard them after recording.
- Use your card and bank statements as a checklist: compare with what you’ve recorded to ensure nothing is missing.
- Conduct a monthly review: on the last day of the month or the first of the next, analyze what happened. Where did you spend more than planned? What can improve?
- Don’t punish yourself for mistakes: the spreadsheet is not a tool for guilt — it’s a tool for learning. Bad months are part of the process.
How to Use the Data to Make Better Decisions
After two or three months of records, you will have something valuable: patterns. And patterns reveal opportunities.
Questions that the spreadsheet data can answer:
- In which categories am I spending more than I imagine?
- Which month of the year tends to be financially heavier?
- Do I have room to increase my emergency reserve?
- Am I paying interest on installments that I could pay off?
- If I reduce X, can I save Y per month?
The emergency reserve, for example, is often cited as the number one priority before any investment. The recommended amount varies according to the profile — between 3 and 12 months of expenses — and the spreadsheet is the tool that will tell you exactly how much you need to save to get there.
If you have experienced financial difficulties and are rebuilding your credit history, the spreadsheet is also an ally. Organizing expenses prevents new delays and defaults. See more in the article How to Recover Credit with a Clean Name for Good.
Advantages and Limitations of the Spreadsheet: A Balanced View
Like any tool, the spreadsheet has strengths and points of attention:
| Advantages | Limitations |
|---|---|
| Free and customizable | Requires discipline and consistency |
| Works offline | Does not automate expense recording |
| Provides a complete view of the budget | Can be laborious at first |
| Facilitates monthly comparisons | Manual entry errors can distort data |
| Adaptable to any income | Does not replace tax or retirement planning |
The spreadsheet is a starting point — and a very efficient one. For more complex needs (retirement planning, investment taxation, estate succession), it is ideal to seek guidance from a specialized professional.
Conclusion: Start Today, Even If Imperfect
The perfect spreadsheet doesn’t exist. There is the spreadsheet that you will actually use. Start with the basics — income, fixed and variable expenses — and refine over time. The most important thing is to develop the habit of regularly looking at the numbers.
You don’t need a high salary to have financial health. You need clarity about what comes in, what goes out, and what remains. The monthly expense spreadsheet is probably the most concrete first step anyone can take toward financial control — and it costs nothing but some time and attention.
Open Google Sheets now. Create the columns. Fill in the first month. The rest comes with practice.
This content is for educational and informational purposes only. It does not constitute investment advice, personalized financial planning, or financial advisory. For decisions related to investments, credit, or estate planning, consult a qualified professional or investment advisor registered with the Securities and Exchange Commission (CVM).
