Free Monthly Budget Template for Google Sheets

Budgeting & Saving

This free monthly budget template for Google Sheets tracks your income, fixed expenses, variable expenses, savings, and debt payments in one place, with planned and actual columns so you can see exactly what changed and what’s left over. Make your own copy, adjust the categories to match your life, and start filling it in for the current month.

What Is Included in the Monthly Budget Template?

The template covers a full month in one sheet: income, fixed expenses, variable expenses, savings, and debt payments, each with a planned amount and an actual amount side by side. At the bottom, it totals planned and actual income and expenses, then calculates the remaining cash flow for both. Every category name can be renamed, and the template is designed to be customized to match your own income and expenses.

How to Use the Monthly Budget Template in Google Sheets

1. Make Your Own Copy

Open the template link and follow the Google Sheets prompt to save an editable copy to your Google Drive. This creates a version you can edit freely; the original stays untouched so you can always start over from a clean copy if needed. Google’s own help center covers the same make-a-copy process in more detail if anything looks different on your device.

2. Enter Your Monthly Income

Use your take-home income, not your gross pay, since that’s the amount that actually reaches your bank account. Enter everything you expect for the month, and split it into separate rows if you get paid more than once, such as two paychecks plus a side income. If your income varies, use a conservative estimate for the planned column and update the actual column once the real numbers come in.

3. Add Your Fixed Expenses

Fixed or recurring expenses are the bills you expect each month, such as rent or mortgage, insurance, phone, internet, subscriptions, childcare, minimum debt payments, and utilities. Enter your planned amount for each, then fill in the actual amount as bills come due during the month.

4. Estimate Your Variable Expenses

Variable expenses change from month to month: groceries, gas or transportation, dining out, household spending, personal expenses, and entertainment. Estimate based on what you’ve actually spent in recent months rather than an ideal number, and refine the estimate as you track more months.

5. Add Savings and Debt Payments

Enter what you’re setting aside for savings and what you’re paying toward debt beyond any minimums already counted under fixed expenses. Keep this section practical: the template tracks the amounts, but it isn’t built around any particular savings or debt payoff framework.

6. Track Planned vs Actual Spending

The planned column is your estimate going into the month; the actual column is what really happened. Comparing the two after the month ends shows which categories were accurate and which need a better estimate next time. That comparison is usually more useful than the estimate alone.

7. Check Your Remaining Monthly Cash Flow

The template calculates remaining cash flow as actual income minus actual expenses. A positive number means you spent less than you earned that month. It is not automatically money to spend right away. You can save it, put it toward debt, carry it forward, or assign it according to your own plan.

Monthly Budget Example

Here’s one way a completed month could look. The numbers are an example only, not a recommended spending pattern for every household.

In this example, income came in slightly lower than planned and a few variable categories ran over, which brought remaining cash flow from a planned $800 down to an actual $680. Both numbers are still useful; the planned figure sets expectations, and the actual figure shows what really happened.

How to Customize the Google Sheets Budget Template

Rename the existing categories to match your own bills and spending. If you have more than one income source, add a row for each rather than combining them into one number. For future months, duplicate the sheet or create a new tab so each month has its own clean copy to work from.

How to Reuse the Template Every Month

1. Keep one clean master copy that you never edit directly.
2. Duplicate the tab or file for the new month.
3. Rename it with the current month.
4. Update expected income and any bills that changed.
5. Reset the actual spending fields to zero or blank.
6. Review last month’s planned-versus-actual differences before setting this month’s estimates.

Monthly Budget Template vs Paycheck Budgeting

This template organizes a full calendar month in one view. A different approach, how to budget your paycheck, organizes cash flow around each individual payday instead of the month as a whole. The two aren’t competing methods; plenty of people use this monthly template for the overall picture while assigning specific bills to specific paychecks underneath it.

Need Help Building the Budget First?

If you want the full process for building a budget from scratch before using this template, how to create a budget walks through that separately.

Common Monthly Budget Spreadsheet Mistakes

FAQ