Building Your First Monthly Budget from a Blank Spreadsheet

Open your spreadsheet application and create a new blank file. Name it something clear, like Monthly Budget — [Month] [Year]. Set up three columns: Category, Budgeted Amount, and Actual Amount. Leave several rows between your income section and your expense section — you'll fill these in as you go.

In the first section, label a row Total Monthly Income. Enter your net income — the amount that actually lands in your bank account after taxes and any payroll deductions. If your income varies month to month (freelance, hourly, or gig work), use a conservative estimate based on your lowest recent month. If you have multiple income streams, list each one separately, then create a SUM formula to total them.

Fixed expenses are costs that stay the same each month regardless of your behavior — rent or mortgage, car payment, insurance premiums, and minimum loan payments. List each one in your Category column and enter the exact monthly amount. Because these don't change, they're the easiest to budget for and should always be covered first.

Variable expenses fluctuate month to month: groceries, gas, dining out, entertainment, clothing, and personal care. Use your bank statements to calculate a realistic average for each category over the past two or three months. Common categories to include:

• Groceries
• Dining and takeout
• Transportation (gas, transit, parking)
• Utilities (electric, water, internet)
• Personal care and health
• Entertainment and subscriptions
• Miscellaneous / unexpected

Always include a small Miscellaneous buffer — even $20–$50 — because unexpected small costs arise every month.

Treat savings as a non-negotiable expense, not whatever is left over at month's end. Add a Savings line in your expense section and assign a specific dollar amount — even $25 or $50 to start. This reinforces the habit of paying yourself first. A common starting framework is the 50/30/20 rule: roughly 50% of net income toward needs, 30% toward wants, and 20% toward savings and debt repayment. Adjust the percentages to fit your real situation — they are guidelines, not rigid rules. Once you've built your initial savings habit, you can work toward your first $1,000 safety net.

Create a final row: Budget Balance = Total Income − Total Expenses (including savings). Use a SUM formula to automate this. If the result is zero or positive, your budget is balanced. If it's negative, you're planning to spend more than you earn — a common first-draft result. Review your variable expense estimates and look for categories where you can reduce the budgeted amount. Do not reduce your savings line first; instead, look at discretionary spending like dining and entertainment. If your income genuinely doesn't cover essentials, that signals a more structural issue worth exploring further.

As the month progresses, fill in the Actual Amount column with what you truly spent in each category. At month's end, compare budgeted versus actual figures. Categories where you consistently overspend need a higher budget allocation or a deliberate behavior change. Categories where you consistently underspend can be redirected toward savings or debt. For ongoing guidance, our article on tracking spending without losing your mind covers sustainable tracking methods in detail.