Keep it boring on purpose.
You’re not aiming for perfect tracking—you’re aiming for a clear plan and a quick way to notice when you’re drifting.
What you’ll build (and why it works)
You’ll create one sheet with three parts: (1) income, (2) category budgets, and (3) spending totals. The key is separating “plan” (budgeted) from “reality” (spent) so you can adjust mid-month without guesswork.
It’s closer to an envelope budget, but without extra apps.
Start a workbook and set up the layout
Create a new workbook in the Microsoft Excel app on Android. Rename the first sheet to Monthly Budget. In row 1, add a month label (for example: Jan 2026) so you can duplicate it later.
Use these columns (starting at row 3):
- A: Category
- B: Budgeted (your plan)
- C: Spent (what actually happened)
- D: Remaining (Budgeted − Spent)
- E: Notes (optional)
In A4 downward, list categories you actually use (examples below). Try 8–15 categories max so it stays usable on a small screen.
Choose categories that match real life (not ideal life)
If you’re unsure, start with a simple split: essentials, financial goals, and flexible spending. You can always rename categories later.
Common categories that work for most people:
- Rent/Mortgage
- Utilities
- Groceries
- Transport
- Insurance
- Debt payments
- Savings
- Eating out
- Subscriptions
- Personal / fun
One small tip: add a Buffer category. Real months are messy.
Add the formulas (copy/paste friendly on Android)
Now you’ll add three simple totals and the “remaining” calculation. This is the part that makes the sheet feel like a tool instead of a notebook.
1) In D4 (Remaining for the first category), enter:
=B4-C4
Then fill down for all category rows you use.
2) Add totals under your category list. If your last category is on row 15, then in A16 type Total. In B16:
=SUM(B4:B15)
In C16:
=SUM(C4:C15)
In D16:
=SUM(D4:D15)
3) Add an income box near the top (for example, A2: Income, B2: your monthly take-home). Then you can sanity-check your plan with:
Unassigned (for example in D2): =B2-B16
If Unassigned is negative, you’ve budgeted more than you earn. If it’s positive, you’ve got money not yet assigned to a category.
How to fill “Spent” without making this a second job
You have two realistic options on a phone: manual weekly entry or quick copy from your bank/app totals.
Most people do best with a weekly 5-minute update.
- Manual weekly entry: once a week, look at your transactions and add rough totals per category into the Spent column. You’re not itemizing—just totaling.
- Bank totals approach: if your banking app shows monthly totals by category, copy those totals into Spent and adjust any mis-categorized items.
If you’re tempted to track every coffee: stop and zoom out. The “Spent” column is for decisions, not self-judgment.
A quick mid-month check that prevents overspending
Do this check once per week (or at least at mid-month). It’s fast and it catches problems early.
- Look at Total Remaining (D16). If it’s shrinking faster than the month is progressing, slow down flexible categories.
- Scan for any category with Remaining below zero. Decide whether to reduce spending there or move money from another category.
- Check Unassigned. If it’s positive, assign it to Buffer, Savings, or an upcoming bill.
- Adjust only 1–3 categories at a time so the plan stays understandable.
Budgets fail when they become a daily negotiation. Keep changes limited and intentional.
Make it reusable: duplicate for next month
When the month ends, don’t rebuild. Duplicate the sheet and clear only the Spent column.
- Copy the sheet (or duplicate the workbook and rename it for the new month).
- Keep category names and Budgeted amounts as your starting point.
- Clear the Spent cells (not the formulas).
- Update the month label at the top.
If your numbers change often, that’s normal—your template is a baseline, not a contract.
Takeaway: a budget is a monthly decision tool
If you build only one thing, build the Budgeted / Spent / Remaining table and do a weekly check-in. That’s enough structure to catch drift early and make spending feel more deliberate—without turning your phone into an accounting project.