The One-Sitting Budget

What to gather

Your take-home pay for one paycheck and the date of a recent payday. A list of your bills with amounts and due days. This month’s bank and card transactions so far, or last month’s if you want practice. Any savings goals, each with a target amount and a date. If you want AI to draft your plan, two or three months of transactions.

If you aren’t sure which charges repeat, start with the subscription tracker. It finds recurring charges and annual renewals that are easy to miss when you list bills from memory.

Make your own copy

Enter your email and the copy link and printable PDF come straight to your inbox. Google asks you to save the copy to your own Drive, which needs a Google account. The copy is yours to edit, and the original stays blank for the next person.

The Sheet has four tabs: Start Here, This Month, Spending, and Bills & Savings. Start Here repeats these steps in short form. White cells are yours to type in. Pale-blue cells calculate.

Enter your pay

On This Month, type the first day of the month you’re budgeting in Month, like 11/01/2026. Then fill in the rows under it.

• Take-home paycheck: what lands in your account from one paycheck, after taxes and deductions.
• How often you’re paid: Weekly, Every 2 weeks, Twice a month or Monthly. Twice a month means two set dates, like the 1st and 15th.
• A recent payday: any past payday works. The Sheet counts forward from it, so a month with three paychecks every two weeks shows three.
• Other income: anything else you expect this month, like money from side work, as one total.

This month at a glance then shows how many paychecks land in the month and your income for it. If your pay changes from check to check, use an amount you can count on and add the extra under Other income once it’s in.

List your bills and savings goals

On Bills & Savings, list each bill once: name, category, amount and due day. For How often, pick Monthly, Every 3 months, Every 6 months or Yearly. Anything that isn’t monthly also needs a First due month, so the Sheet knows which months it lands in. Mark Autopay for the ones that pay themselves. Due date this month fills in for the month you picked, and a bill due on the 31st moves to the last day of a shorter month.

Under Savings goals, add each goal with a target, what you’ve saved so far and the date you need it by. The Sheet works out the months left and how much to set aside each month. That total becomes the Sinking Funds plan on This Month. To land on a target for a trip or holiday gifts first, the beach vacation budget and Christmas gift budget walkthroughs help you count the costs before you add the goal.

The budget shows when each bill is due. To check whether the money will be there that day, the bill calendar matches every bill to the payday that covers it and shows when the money needs to be available. If one bill keeps creeping up, the internet bill walkthrough shows how to ask the provider for a lower price.

Set your split and plan each category

Your 50/30/20 split starts at 50% of take-home pay for needs, 30% for wants and 20% for savings. Treat it as a starting point. If housing or childcare takes more than half, change the white percentages in the Guide column so they fit your month. They need to add up to 100%.

Then go down the category table and type an amount in Plan for each category. Needs covers costs like housing, utilities, groceries and debt payments. Wants covers subscriptions, hobbies, dining out, and fun and gifts. Savings holds Emergency Fund, Vacation Fund and Sinking Funds, and Sinking Funds fills in from your goals. Keep going until Left to plan reads $0.

Not sure what to type? Start from what you actually spent. Turn last month’s spending into next month’s plan shows two ways to get a first draft.

The split table compares your plan with each target. If needs or wants come out over their targets, or savings comes out under, the health check says by how much. You decide whether to trim a category or change the split.

Enter spending and fix the flags

On Spending, enter each transaction starting in row 6: date, description, amount, category from the dropdown, account and an optional note. Type amounts as plain numbers with no $ sign. Adding transactions once a week keeps the month from piling up.

• Refunds: a minus number in the category of the original purchase.
• Paychecks: category Income. They aren’t counted here, because your income comes from This Month.
• Credit card payments and money moved from savings back to checking: Transfer (not counted), so the same dollars aren’t counted twice.
• Money moved into savings: the savings category it’s for, so it counts toward that plan.
• Loan payments: spending, even when the statement calls them a transfer.

The Check column reads every row. A ✓ means the row is counted. Anything else tells you what to fix.

• Pick a category: the category is blank or Review / Not sure. The row isn’t counted until you choose one.
• Not on list: the category doesn’t match your list. The flag suggests the closest name.
• Possible duplicate: two rows share a date, description and amount. If both charges are real, type anything in Note.
• Other month, not counted: the date falls outside the month on This Month.
• Amount isn’t a number, Date isn’t a date or Header row: retype the cell, or delete a pasted header row.

Then read the health check on This Month. It says whether every dollar has a plan, whether the plan fits your split, which categories are over plan, which transactions still need attention, what’s due in bills this month and whether the category table is intact. Left to spend shows what remains of your plan after the spending that’s counted.

Start the next month

On This Month, change Month to the 1st of the new month and update Other income. On Bills & Savings, update each goal’s Saved so far. You don’t need to clear Spending, because rows from other months aren’t counted. Paycheck counts and bill due dates update with the month. Your plans stay as you typed them, so change any that should be different.

Want a blank budget instead? Make another copy from the link in your email. For a paper check alongside the Sheet, the Household Bills Check is a free two-page printable for reviewing bills, deposits and recurring charges each month.

Turn last month’s spending into next month’s plan

A plan built from what you really spend is easier to keep than one built from a guess. Here are two ways to get a first draft, then you adjust it.

Without AI. On This Month, set Month to the 1st of last month and enter last month’s transactions on Spending. The Spent column now shows what went to each category. Type those amounts into Plan, rounding up, then change Month to the month you’re planning. Your plans stay, and last month’s rows stop counting.

With AI. One month can be lopsided, so an AI chat assistant can look at two or three at once. Download those months from your bank and card accounts (CSV if you can), remove account numbers and your name, and send them with the prompt below. Fill in the parts in brackets first. If you’ve renamed or added categories, change the list to match your Sheet.

I'm planning next month's budget and want a starting plan based on what I actually spent. I've attached [2 or 3] months of transactions from my bank and card accounts, with account numbers and my name removed.

My take-home income for next month: $[amount]

Use only these categories, in this order.
Needs: Housing, Utilities, Phone & Internet, Insurance, Childcare & School, Medical, Groceries, Gas & Transport, Household & Personal, Kids & Pets, Debt Payments
Wants: Subscriptions, Hobbies, Dining Out, Fun & Gifts
Savings: Emergency Fund, Vacation Fund, Sinking Funds

Reading the transactions
- Accounts show money out differently. Some files use minus signs for spending, and card files often show charges as plain numbers. Work out which each file does and tell me.
- Don't count paychecks or other money coming in.
- Don't count credit card payments or money moved from savings back to checking. Those are transfers, and counting them would count the same dollars twice.
- Money moved from checking into savings counts toward Emergency Fund or Vacation Fund, whichever the description fits.
- Loan payments count as Debt Payments, even if the statement calls them a transfer.
- A refund comes off the category of the original purchase.
- If the same charge shows up twice with the same date and amount, count it once and tell me, so I can check whether both were real.
- If you can't tell what a charge was for, don't guess. Put it on the list for me to decide.

Building the plan
- For bills that come every month, use the most recent amount, since prices change.
- For spending that goes up and down, like groceries or gas, use the monthly average. Leave out one-time or seasonal purchases, like a car repair, a new appliance or holiday travel, and list them separately.
- Leave bills that come every 3, 6 or 12 months out of the monthly plan. List them separately so I can add them to my savings goals.
- Round each plan up to the nearest $5.
- Leave Sinking Funds blank. My sheet fills it in from my savings goals.
- Don't suggest cuts. If the plan comes to more than my income, show the gap and leave the choices to me.

What to give me back
1. A table, one row per category in the order above: Category, Average spent per month, Suggested plan, Why (one short line).
2. Bills that aren't monthly: Bill, Amount, How often, Last paid, Next due.
3. One-time or seasonal spending you left out: Date, Description, Amount, Category.
4. Not counted: each paycheck, transfer and card payment you skipped, with a total.
5. For me to decide: anything you weren't sure about, with the amount and the two most likely categories.
6. Totals: the suggested plan, my income and the difference. Then Needs, Wants and Savings as a share of my income, next to 50/30/20.
7. For each account and month, the total money out, so I can match it against my statements.

It comes back with a suggested Plan for each category and a short reason, the bills that come every few months, the one-time spending it left out and anything it wasn’t sure about. Add the every-few-months bills as savings goals on Bills & Savings, and they’ll fill in Sinking Funds. Expect to tweak both the prompt and the numbers: every assistant answers a little differently, and your months won’t look like anyone else’s.

Let AI sort your transactions

Typing transactions works fine. If you’d rather not, Start Here includes a prompt to use with an AI chat assistant. Download the month’s transactions from your bank and card accounts (CSV if you can), remove account numbers and your name, then attach the files or paste the text with the prompt.

The prompt asks for rows in Spending’s column order, using only your category names, with refunds, transfers and savings handled the way the Sheet expects. Anything the assistant isn’t sure about comes back as Review / Not sure. After the table, it lists each account’s total money out and money in, so you can match them against your statements before you paste. Paste the rows starting in row 6, or below your last row on later passes, then fix the Check column flags the same way.

Make the categories yours

The 18 categories are a starting list. Make changes on This Month. No formulas are needed.

• Add: right-click the row number of a category row inside the group you want (not the Needs, Wants or Savings row itself) and insert a row above or below. Type the name in Category and an amount in Plan. The totals, dropdowns, Check column and the prompt on Start Here pick it up.
• Rename: don’t type over the name. Use Edit > Find and replace with the old and new names, choose All sheets, tick Match case and Match entire cell contents, then click Replace all. That renames it on every tab at once.
• Delete: right-click the row number and delete the row. Its plan goes back to Left to plan. Spending rows that used it say Pick a category until you choose a new one, and bills that used it are tinted on Bills & Savings.

Give every category its own name, and don’t delete the Needs, Wants, Savings or Total rows. If one goes missing, undo right away or use File > Version history. If Sheets warns you before an edit, click Cancel unless you meant it. The last line of the health check confirms the table is intact.