Before you ask an AI about your spending, spend ten minutes preparing the data: one file, one date format, one currency and sensible categories. The questions are the easy part. Most of the value, and most of the mistakes, come from the preparation.
Step 1: pick the period and the accounts
Decide the window first. Three full months is a good start, because it shows patterns without drowning you. List every account that moved money in that window: everyday account, credit card, any account you use for a side income. If one account is missing, every total will be low and you will not know why.
Step 2: build one tidy table
Put every transaction in one table with these columns: date, merchant, amount in Australian dollars, account, category. Use the same date format throughout, for example 2026-03-14. Spending as positive numbers and refunds as negatives avoids confusion. If an export gives separate debit and credit columns, merge them into one amount column, with credits negative.
| Column | Example | Common mistake |
|---|---|---|
| Date | 2026-03-14 | Mixing day-first and month-first |
| Merchant | Corner Cafe | Same merchant under several spellings |
| Amount (A$) | -18.50 | Refunds shown as positive |
| Account | Credit card | Leaving it out so transfers double count |
| Category | Eating out | Different category names across months |
Step 3: ask a small, specific first question
Begin with a question whose answer you already roughly know: "What was my total spending in March in Australian dollars, and how many transactions is that?" Compare with your own sense. If it is wildly off, fix the data before asking anything else.
What questions come after that?
- Which three categories grew the most between January and March?
- What are all the recurring monthly charges, and what do they add up to?
- What was my average spend per week on groceries?
- Which single purchases were over A$300?
- How much did I spend on weekends compared with weekdays?
Take the grocery question. If March groceries were A$620 over 31 days, that is about A$20 a day, or about A$140 a week (620 ÷ 31 = 20, and 20 × 7 = 140). Asking for both the daily and weekly figures lets you notice if one week was unusual.
Step 4: verify before you act
Pick the one number that would change a decision and check it by hand. If the assistant says subscriptions come to A$96 a month, list them yourself: say A$18, A$14, A$22 and A$42. That adds to 18 + 14 + 22 + 42 = A$96. If it does not add up, ask the assistant to list the rows it used.
What to keep private
Do not include account numbers, card numbers, logins or any code sent to you for security. Trim names and addresses from descriptions where you can. Read how any service stores your data and whether it can be deleted. Do not rely on an assistant for the rules of any bank, tax office or government scheme; those belong with the official source.
Close the loop
Finish each session with a written decision and a date to review it. For example: "Cancel the A$22 subscription this week; check subscriptions again on 1 June." Questions without decisions are curiosity, which is fine, but it will not change the next statement.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


