Free AI Built My Budget Spreadsheet (+ the $412 Check)

0:00This is a completely blank spreadsheet. In a few minutes, it'll be a working [snorts] monthly budget, and I won't type a single formula myself. But, there's one hidden error that can make a budget lie to you. In my sample data, it hid $412, [music] and it hid the fact that I'd blown my grocery budget. In step five, I'll show

0:19you the 10-second check that catches it. Quick note, the numbers are sample data. [music] The voice you're hearing is AI, and this is education, not financial advice. [music] You need two free things: a spreadsheet like Google Sheets or Excel, and any free AI chat. Claude, ChatGPT, or Gemini all work. I use Claude for several projects like this because it makes maintaining sheets and data simple, even with little spreadsheet experience. But, the prompt works the same in any of them. Five steps: prompt, paste, summarize, chart, and check. The fifth one is the step that saves you. Step one is the prompt, and this is where most people go wrong. They type, "Make me a

1:01budget," [music] and get a vague, ugly table. Instead, tell the AI what it is, what columns you need, and what format to [music] send back. Mine says, "Act as a spreadsheet builder. Make a monthly budget transactions tab with date, [music] description, category, and amount. Use these 12 categories, and add sample [music] rows. Then return it as tab-separated text I can paste straight into a sheet." Notice the last [music] line. Tab-separated is the trick. It

1:28pastes cleanly with no broken columns. One safety tip, if you ever paste real bank data into an [music] AI, delete names and account numbers first. Copy it, click cell A1, [music] and paste. And there it is. Headers, categories, and sample rows, all [music] in the right columns. First tiny fix, select the amount column and [music] set it to currency. That's format, number, currency. Before I lock anything down, I'll add one purchase by hand, a

1:56warehouse club run for $412. Groceries. Now the category column. Select it, then insert drop down in Google Sheets or data validation in Excel and add your 12 categories. Every new entry is now one click and typos can't sneak in. [music] Hold that thought because typos are exactly what causes the hidden error. Step three, ask the AI for the summary [music] tab. One sentence and it writes the formulas for you. Paste it into a

2:26called summary. [music] The key formula is sumif. It says, "Add up the amounts in this column, but only where the category equals [music] this name." That's your whole budget engine. Watch what happens when I add a grocery receipt. Actual goes up, remaining goes down instantly. That's the moment a spreadsheet [music] starts feeling like an app. One more request. Make remaining turn red when it's negative. That's one sentence to the AI and now you can see overspending at a glance. Step four, the chart. Ask the AI which chart fits, then insert a chart. I'm going with a bar chart because with 12 categories, a pie chart is unreadable. Sorted biggest to

3:05smallest. Now add monthly income and what's left after spending at the bottom. [music] Blank sheet to dashboard in about 5 minutes. And now the check. Here's the habit. Add a reconciliation row. The total of every transaction minus the total of the summary. It should always equal zero. If it doesn't, something is falling through the cracks.

3:27And mine says $412. Same data, two different answers. [music] So what happened? Remember that little red triangle on the warehouse club row? I typed that row by hand before adding the drop down and I left a trailing space after groceries on purpose because it's one of the most common ways real budgets break. Sumif treats groceries with a space as a different category, so the summary silently skipped it. The formulas were fine. The data wasn't. The fix takes 10 seconds. Pick groceries from the drop-down. Back on the summary, the check drops to zero. You can even ask the AI to make that cell turn green at zero and red otherwise. Now, the [music]

4:08sheet audits itself. And look at groceries. The hidden row was hiding the fact that I'd gone $65 over budget. That's why the check matters. [music] Quick math you can plug in. A popular rule of thumb is 50 30 20. 50% needs, 30% wants, and 20% savings or debt. It's a starting framework, not a rule you have to follow. Ask the AI for a percent of income column, [music] and you can see where you land. What you change is up to you. I'm just showing you the math. Next week, the AI builds a holiday budget for [music] gifts, travel, and food. If you'd rather skip the setup, this exact template with the

4:46check built in is free in the description. [music] Make a copy and drop in your own numbers. Recap. Write a specific prompt. [music] Paste tab separated. Ask for the summary. Chart it. And always run the check. If this saved you time, subscribe. [music] And tell me in the comments which category blows up your budget first. See

5:05you next week. [music]