How to Make a Budget Spreadsheet on Google Docs

Quick Answer

To make a budget spreadsheet on Google Docs, use Google Sheets (not the word processor) and set up columns for Date, Description, Amount, and Category. Add a row for each transaction as it happens, format the currency column, and use =SUMIF() formulas at the bottom to total spending by category. Compare each category total to a budget you assign at the start of the month to see how much remains unspent.

Why People Choose Spreadsheets

A spreadsheet lives where you already work—Google Drive, accessible from any device. It costs nothing. You own the file outright and never hand your bank login to a third party. Many people who left apps like YNAB, Mint, Monarch, Rocket Money, or EveryDollar chose a spreadsheet because they wanted their financial data under their own control and kept private.

The clear tradeoff: spreadsheets do not automatically fetch transactions from your bank. You enter spending manually as it happens, or you export a monthly statement from your bank as a CSV file and paste the transactions in. That manual step is often the whole point—it forces you to notice what you're spending instead of discovering it in a summary at month's end.

Setting Up Column Headers and Basic Structure

Open a new Google Sheet and create headers in row 1. The five core columns are:

Format the Amount column as currency. Select the column, click Format, choose Number, then Currency. Freeze row 1 so headers stay visible when you scroll: click View, then Freeze, then 1 row.

Two Layout Approaches: Which One to Choose

Envelope-Style Layout (Categories as Columns). Create one column per spending category: Groceries, Gas, Restaurants, Utilities, Subscriptions, Entertainment, Other. Each transaction row has the amount entered only in its category column. Use SUBTOTAL rows at the bottom with =SUM(Groceries_column) to show total spending per category. This mimics the physical envelope method where you mentally fill each category with a fixed amount at the start of the month.

Transaction Log Layout (Most Common). Keep Date, Description, Amount, and Category as regular columns. Every transaction is one row, the amount goes in the Amount column, and you note the category. At the bottom of the sheet, list all categories and use =SUMIF() formulas to calculate totals. For example, =SUMIF(D:D,"Groceries",C:C) sums all amounts in column C where the category in column D equals Groceries. This layout is easier to maintain if categories change or if you realize you need a new one mid-month. Most people find this more forgiving.

Start with the transaction log. It adapts as your life does.

Setting Up Your Monthly Budget Assignments

Before you spend anything, decide how much each category gets. Create a budget section at the top of your sheet (or on a separate sheet) with two columns: Category and Monthly Budget. Examples:

• Groceries: $400
• Gas: $200
• Restaurants: $150
• Utilities: $180
• Subscriptions: $50
• Other: $200

Total that up (=SUM of all budgets) to see your total planned spending. This is zero-based budgeting: every dollar gets a job before the month starts. As you log transactions, your formulas will show how much of each budget remains.

Below each transaction total, add a Remaining row: =Budget_amount - Actual_total. When Remaining hits zero, that category is done for the month. If Remaining goes negative (you overspent), the formula shows a negative number so you see it immediately.

Importing Transactions from Your Bank or Switching Apps

Export a CSV file from your bank's website or download transactions from the app you're leaving. Most banks offer this under "Download Transactions" or "Export Statement." CSV is a plain text format with rows and columns separated by commas.

Open the CSV file in Google Sheets (File > Open, or drag it into Google Drive). The transactions appear as rows. Copy the columns for Date, Description, and Amount, and paste them into your budget sheet starting at row 2. Then manually fill in the Category column, or if you exported from another budgeting app, copy the categories too.

If you're moving from YNAB, Mint, Monarch, Rocket Money, or Copilot, each has a specific export format. Look up the export option in that app's help menu. This saves you from typing everything by hand and ensures dates and amounts are exact.

Tracking Subscriptions and Recurring Charges

Add a second sheet called "Subscriptions" with these columns: Name, Monthly Cost, Annual Cost, Renewal Date, Notes.

• Netflix: $9.99/month, $119.88/year, renews Oct 20
• Gym membership: $50/month, $600/year, renews Oct 1
• Cloud storage: $2.99/month, $35.88/year, renews Oct 15

Use a formula for Annual Cost: =Monthly_Cost * 12. Review this sheet once a month and verify that upcoming renewals are accounted for in your Categories. Sometimes subscriptions raise their price without notifying you, so checking renewal dates catches surprise increases.

Common Spreadsheet Pitfalls and Solutions

Formulas Break When You Rearrange Rows. If you use =SUM(C2:C20) and add new categories, the formula still only sums C2 to C20 and misses new rows below. Use entire column references instead: =SUM(C:C) or =SUMIF(D:D,"Groceries",C:C). The formula adapts automatically when you add rows.

Category Creep. Five categories feels simple until you have twenty and lose track of what belongs where. Decide early: does "Coffee" go under Groceries or Restaurants? Is a Target trip Household Supplies or Other? Decide once and document it. A categories reference list in your notes prevents confusion later.

Forgetting to Log Transactions. A spreadsheet has no notifications. A purchase from three days ago slips your mind. Log transactions the day they happen, or collect receipts in a folder and batch-enter them on Sunday evening. Set a calendar reminder to review your spending weekly.

Pending Transactions Don't Show on Exports. If you export your bank statement on October 3, pending charges from October 2 or 3 may not appear until they clear days later. Manually add expected charges (paycheck, rent) to your sheet so your available balance is realistic. When the transaction actually clears, update the status to cleared.

Formulas Slow Down With Large Data. After six months of daily entries, your sheet has 5,000+ rows. Google Sheets handles it, but recalculation slows. Create one sheet per month instead of one sheet for the whole year. Link summaries on a yearly sheet that pulls totals from each month. This keeps each sheet fast.

When Spreadsheets Become Cumbersome

A spreadsheet works well if you enjoy the manual entry and stay disciplined. If entering transactions becomes a chore you skip, or if you forget transactions and realize days later you're out of sync with your budget, that's feedback that the tool isn't serving you anymore. Some people find that after three or four months, 15 minutes a week of manual logging feels like overhead instead of insight.

If you want the privacy and control of a spreadsheet but dislike the data-entry burden, alternatives exist. Some apps offer CSV import but no bank sync—YNAB, Mint, Monarch and Rocket Money users can export to switch without re-entering history. This approach keeps your bank credentials private while eliminating ongoing manual logging.

Building Your First Month: Step-by-Step

1. Create a new Google Sheet and name it "October 2026 Budget" or whatever month you're on.
2. In the top section, list all spending categories and assign a budget amount to each.
3. Add a row with a formula that sums all budgets, so you see total planned spending.
4. Below that, add your transaction headers: Date, Description, Amount, Category, Account.
5. Export transactions from your bank as a CSV file.
6. Open the CSV in Google Sheets, copy the Date, Description, and Amount columns, and paste them into your budget sheet starting at row 2.
7. Fill in the Category column for each transaction.
8. At the bottom, add one row per category with a formula to sum that category: =SUMIF(D:D,"Groceries",C:C).
9. Add a Remaining row for each category: =Budget - Actual_spent.
10. Format the currency columns. Freeze row 1.
11. Share with a partner if you budget together, or keep it private in your own drive.

FAQ

Can I use Google Docs instead of Google Sheets for a budget?

Google Docs is a word processor; it can hold a table but does not support formulas or calculations. Google Sheets is the spreadsheet tool and does everything you need. It's free and integrates with Google Drive just like Docs does.

How do I password-protect a budget spreadsheet?

Google Sheets does not have built-in password protection, but you can restrict who can view it by changing share permissions. Click Share, choose Restricted, and add only the email addresses of people you trust. Alternatively, download the sheet as an Excel file and password-protect that file on your computer, though you lose the automatic formula updates if you edit it offline.

Should I make one sheet for the whole year or a separate sheet per month?

Start with one sheet per month. When one sheet has more than a few thousand transaction rows, formulas and scrolling slow down. Create a second sheet called "Summary" that pulls yearly totals from each month. Use =SUM(January!C2:C500) to reference totals from your January sheet. This keeps work fast and organized.

How do I handle splitting expenses with a partner?

Add a "Split" column and note the percentage or dollar amount each person owes. If a $100 grocery trip is 60/40 split, mark 60 in one row and 40 in another, or use a note in the Description column. Create a second sheet that tracks who owes whom and settle up weekly or monthly. This prevents resentment and keeps the main budget clear.