LifeRemix.aiMake a little more possible.Join the good stuff ↗
Daily LifehackMy Agentic LifeThe Weekly Remix
remix with ai:Making & Managing Money

The Saturday Morning Budget Autopilot: Categorising Your Spending Safely with AI

Turn a cryptic wall of bank transactions into a neat, categorised spending plan without installing complicated third-party macros. Here is how to safely anonymise your spreadsheet and use a standard AI chat tool to do the administrative heavy lifting.

A man reviewing his household budget over breakfast on a balcony.
AI-generated illustrative photograph.

The Monthly Spreadsheet Ritual

There is a specific kind of Sunday morning dread reserved for the household budget. You download a fresh CSV file from your bank, pour a second cup of coffee, and stare at a wall of cryptic transaction descriptions. What, exactly, is POS W/D 12445 NYTIMES? And did that purchase at a generic-sounding pharmacy count as groceries, healthcare, or an emergency supply of chocolate?

According to the financial education team at Sorted, nearly four in 10 New Zealanders worry about money from pay to pay. A budget reduces that anxiety by showing you exactly where your money is actually going, allowing you to flow your cash towards the things you want before it quietly bails on you. But getting from a messy bank export to a clean, categorised summary is notoriously tedious.

While there are dozens of custom Excel add-ins and third-party banking macros available online that promise to automate this, they often require you to install code from the internet, generate developer API keys, or give a third-party startup direct access to your live bank feed. Worse, feeding your raw, unedited financial data into a public chatbot is a severe privacy risk.

The New Zealand Office of the Privacy Commissioner explicitly warns that generative AI tools can retain and disclose the information you feed them. Their recommended alternative is stripping your input data of anything that enables re-identification. By deliberately anonymising your bank data in an ordinary spreadsheet and using a standard conversational AI to do the tedious text-matching, you can build a highly practical household spending plan without compromising your privacy or installing a single piece of third-party software.

The Finish Line

A completed, private household budget categorisation process using an ordinary spreadsheet (Excel, Google Sheets, or Apple Numbers) and a free AI chat assistant, complete with arithmetic checks and a reusable prompt template.

  • Time: 30 minutes for the initial setup; 10 minutes for monthly maintenance.
  • Cost: Free.
  • Prerequisites: A standard spreadsheet application, a free account with an AI chat tool (like Google Gemini, Microsoft Copilot, or ChatGPT), and the ability to download a CSV file from your online banking portal.

Step 1: Define Your Envelopes

Before you introduce any data to an AI, you need a firm list of target categories. Sorted recommends a digital version of the classic "envelope" technique, where incoming money is divided into specific buckets. Keep your list small and manageable. If you have 40 categories, you will quickly go mad; aim for 10 to 15 broad buckets.

Open a blank spreadsheet and type your categories in a single column. A standard baseline includes:

  • Income: Salary, Side Hustle, Dividends. (Note: as Moneysmart advises, it is wise to check your payslip for hidden deductions like superannuation or health insurance, but for this specific cashflow exercise, we are tracking the exact amounts that actually hit your account).
  • Fixed Expenses: Rent/Mortgage, Power, Phone/Internet, Insurance. These are your non-negotiable baselines.
  • Irregular Expenses: Groceries, Petrol/Transport, Medical. These fluctuate but are still essential to living.
  • Non-Essential: Dining Out, Entertainment, Subscriptions.
  • Goals: Savings, Debt Repayment.

Step 2: The Data Scrub and Anonymisation

Log into your online banking and download your past month's transactions as a CSV (Comma Separated Values) file. Open this file in your spreadsheet app.

Now, we build the privacy shield. You must ruthlessly delete any column that identifies you or the people you interact with.

  1. Delete the Account Number and Account Name columns.
  2. Delete the Balance column (the AI absolutely does not need to know your total net worth to categorise a coffee).
  3. Delete the Payee Name or Reference columns if they contain personal names (e.g., "Transfer to John Smith" or "Childcare Invoice 443").

You should be left with exactly three columns: Date, Amount (with negative numbers for expenses and positive for income), and Description (the cryptic merchant text).

Step 3: The AI Categorisation Prompt

Highlight a batch of your anonymised transactions (start with exactly 50 rows to avoid overwhelming the AI's short-term memory) and copy them to your clipboard.

Open your chosen conversational AI tool and paste the following template, replacing the bracketed categories with your own list:

Copyable Prompt:
Act as a financial administrator. I am going to provide a list of anonymised bank transactions. Each line contains a Date, an Amount, and a Merchant Description.

Your task is to categorise each transaction using STRICTLY the following categories and no others: [Income, Rent, Power, Phone/Internet, Groceries, Transport, Medical, Dining Out, Entertainment, Subscriptions, Uncategorised].

If you are not at least 90% sure, use "Uncategorised". Do not invent new categories. Do not include any conversational greeting or explanation. Output the exact original Date, Amount, and Description, and append the Category as a fourth column. Format the output entirely as comma-separated values (CSV) in a plain text block.

Here is the data:
[Paste your 50 rows of spreadsheet data here]

Step 4: The Worked Example

Let’s look at a hypothetical scenario to see the process in action.

Your Input Data (Anonymised):

12/11/2026, -14.50, KDW*MCDONALDS AUCKLAND
14/11/2026, -98.00, MERK ENERGY LTD
15/11/2026, -22.50, NETFLIX.COM
16/11/2026, 1200.00, ACME CORP PAYROLL

The AI's CSV Output:

12/11/2026, -14.50, KDW*MCDONALDS AUCKLAND, Dining Out
14/11/2026, -98.00, MERK ENERGY LTD, Power
15/11/2026, -22.50, NETFLIX.COM, Subscriptions
16/11/2026, 1200.00, ACME CORP PAYROLL, Income

Step 5: Arithmetic Checks and Reassembly

Once the AI generates the text block, copy it and paste it back into a new tab in your spreadsheet.

Formatting Tip: If the data pastes into a single long cell instead of spreading neatly across columns, look for your spreadsheet’s "Text to Columns" feature (usually under the Data menu), choose "Delimited," and select "Comma."

AI tools are language models, not calculators. They can occasionally "hallucinate" by dropping a row or subtly altering a digit. You must perform a strict arithmetic check before making any financial decisions.

  1. The Total Check: At the bottom of your newly pasted Amount column (assuming you pasted 50 rows into B2 through B51), type =SUM(B2:B51).
  2. Check this total against the exact same rows in your original bank export. If the numbers match to the cent, the AI has perfectly preserved your data. If they do not match, the AI dropped a row or hallucinated a number. Discard the output and process the data in smaller batches (e.g., 25 rows).

Step 6: Summing Up Your Budget

Now that every row has a reliable category in Column D, and an amount in Column B, you can easily see where your money actually went.

Create a small summary table next to your data. List your categories down one column. Next to "Groceries", use the SUMIF formula to automatically add up all matching expenses.

Copyable Formula:
=SUMIF(D:D, "Groceries", B:B)

Repeat this for each category. You will instantly see your total spend for the month. Subtract your total expenses from your total income. If you have a surplus, as Sorted points out, you now have unassigned money you can consciously direct towards a specific goal, like an emergency fund or a high-interest savings account. If you are in a deficit, you now have the clear, categorical data you need to decide which non-essential spending to trim next month.

Common Failures and Recovery

The AI invented a category: Sometimes an AI will look at a hardware store purchase and categorise it as "Home Improvement" even though that was not on your list. If this happens, delete the AI's output, edit your prompt to add "DO NOT INVENT CATEGORIES" in all caps, and generate it again.

The dates flipped formatting: Generative AI often tries to default to US date formats (MM/DD/YYYY). If you notice your days and months have swapped, specifically instruct the AI in your prompt: "Preserve the exact original date string; do not reformat the dates."

Saving and Reuse

To make this a sustainable monthly habit, save your blank categorisation spreadsheet (with your categories and SUMIF formulas already set up) as a master template on your computer.

Then, copy your finalised, successful AI prompt into a basic text document or a digital notes app. Next month, instead of starting from scratch, you simply scrub your new bank export, paste the transactions into your saved prompt template, and drop the AI's categorised output right back into your spreadsheet. You get all the automation of an intelligent financial assistant, with none of the privacy risks of a third-party banking integration.


AI disclosure: AI systems assisted with research and writing. Gemini independently peer-reviewed and approved this article before publication. Images, where present, are illustrative AI-generated photographs.