How to Use AI to Make a Monthly Budget

by
Works withChatGPTClaudeGeminiGrokMicrosoft Copilot

Most people know they should have a budget. Far fewer have one, usually because setting it up feels like a chore. AI won’t magically fix your finances, but it is very good at the boring parts: sorting spending into categories, doing the maths and building a spreadsheet you can actually use.

In this guide you’ll create a simple monthly budget with an AI assistant, without sharing sensitive banking details.

Quick answer: List your monthly income and your spending from the last one to three months (amounts and descriptions only, no account numbers). Ask an AI chatbot to sort them into categories, total them, suggest limits using a method like 50/30/20, and build a spreadsheet template. Review the numbers yourself.

What you’ll need

  • Your take-home (after-tax) monthly income
  • Your bank or card transactions from the last 1–3 months, exported or copied (remove account numbers and personal details)
  • A list of regular bills: rent or mortgage, utilities, phone, subscriptions, debt repayments
  • An AI chatbot plus Google Sheets or Excel
  • About 30 minutes

Step-by-step: build a budget with AI

  1. Gather your numbers. Export transactions as a CSV from your banking app if you can, or simply jot down your main spending. Delete account numbers, card numbers and anything identifying before sharing.
  2. Categorise your spending. Paste the transactions into the AI and ask it to sort them into categories like housing, bills, groceries, transport, eating out, subscriptions and savings (prompt 1).
  3. See where it goes. Ask for monthly totals and percentages per category. This is often the eye-opening moment. Small, frequent spends add up.
  4. Choose a method. A popular starting point is the 50/30/20 rule: roughly 50% of take-home pay on needs, 30% on wants and 20% on savings and extra debt repayment. Treat it as a guideline. If your rent is high, adjust it.
  5. Set limits. Ask the AI to suggest realistic limits for each category based on your actual spending and your goals (prompt 2). Make small cuts rather than drastic ones.
  6. Build the spreadsheet. Ask for a template with formulas (prompt 3), then paste it into Google Sheets or Excel. Double-check the formulas add up correctly.
  7. Review weekly, adjust monthly. Spend five minutes a week updating spending. At month end, ask the AI to compare budget versus actual and suggest tweaks.

Copy-paste prompts

1. Sort my spending

Here are my transactions for the last [NUMBER] months (descriptions and amounts only):
[PASTE TRANSACTIONS]
Sort them into these categories: housing, utilities & bills, groceries, transport, eating out & takeaways, shopping, subscriptions, health, entertainment, debt repayments, savings, other.
Show a table with the monthly average per category and its percentage of my income of [MONTHLY TAKE-HOME INCOME]. List any recurring subscriptions separately.

2. Suggest a realistic budget

Based on this spending summary, suggest a monthly budget for me. My goals are: [E.G. SAVE 200 A MONTH, PAY OFF CREDIT CARD]. Use the 50/30/20 rule as a starting point but adjust it to my fixed costs. Suggest 3 specific, realistic cuts and explain the trade-off for each. Don't recommend specific financial products.

3. Create a spreadsheet template

Create a monthly budget spreadsheet layout for Google Sheets with columns: Category, Budgeted, Actual, Difference, Notes. Include rows for [YOUR CATEGORIES], a total income row, total spending and money left over. Give me the exact formulas for each calculated cell, with cell references.

Recommended tools

  • ChatGPT: can analyse uploaded CSV files and make tables.
  • Claude: clear explanations and careful analysis of pasted data.
  • Gemini in Google Sheets: help with formulas inside your spreadsheet.
  • Microsoft Copilot in Excel: the same for Excel users.

Tips and mistakes to avoid

  • Never share login details, full account or card numbers with any chatbot.
  • Check the maths. AI can make arithmetic mistakes, especially with long lists. Let the spreadsheet do the final calculations.
  • Include irregular costs. Car insurance, birthdays and annual subscriptions. Divide the yearly cost by 12 and budget for it monthly.
  • Don’t aim for perfection. A rough budget you stick to is better than a perfect one you abandon.
  • Get proper advice for big decisions. AI is fine for organising, but for debt problems, pensions or investments, speak to a qualified adviser or a free debt advice service.

FAQ

Is it safe to give AI my bank transactions?

Share only what’s needed: descriptions and amounts, with account numbers and personal details removed. Check your AI tool’s privacy settings, and turn off chat history or training if you prefer.

Can AI give me financial advice?

AI can explain concepts and help you organise money, but it isn’t a regulated financial adviser and can be wrong. Treat it as a helpful calculator and explainer, not an authority.

What’s the best budgeting method to use with AI?

50/30/20 is easy to start with. Zero-based budgeting, where every euro or pound gets a job, suits people who want more control. Ask the AI to set up either.

Try it yourself with Microsoft Copilot

Here are my transactions for the last [NUMBER] months (descriptions and amounts only):
[PASTE TRANSACTIONS]
Sort them into these categories: housing, utilities & bills, groceries, transport, eating out & takeaways, shopping, subscriptions, health, entertainment, debt repayments, savings, other.
Show a table with the monthly average per category and its percentage of my income of [MONTHLY TAKE-HOME INCOME]. List any recurring subscriptions separately.

Get one useful AI how-to a week

New guides and copy-paste prompts, straight to your inbox.

Free. No spam. Unsubscribe any time.

Related guides

Reference: MoneyHelper: Budget planner