Skip to content
TriedPrompts

More in Money, Bills & Taxes.

Sort 42 bank transactions into a budget with Gemini in Google Sheets

Beginner-friendlyNo logins, payments or coding needed. Low risk: paste the prompt and you should get something useful.

Copy the prompt below and paste it into the AI tool named on this page.

Prompt Recreated prompt

The source didn't share its exact prompt, so we wrote this from what it describes.

What the prompt labels mean

Sort these bank transactions into my budget categories. Then make a new tab showing total spending per category, compare it to my budget, and highlight anything over budget in red. Which categories are most over budget, and do I have any unusual transactions?

Try this in:

Sends the Recreated prompt shown above. ChatGPT and Grok open with it filled in, and ChatGPT may send it straight away. Gemini opens empty, so we copy the prompt for you to paste. Every button also copies it.

Opens in a new tab. We don't see what you send.

These links are only a shortcut. We're not affiliated with OpenAI, Google or xAI, and your results may not match the source.

Optional stronger version

Our rewrite with extra checks. The poster didn't test it.

Before you start, ask me 1–3 short questions about the details below and wait for my answers. Once I've answered, confirm the plan in one line and run the whole task start to finish.

Goal: Turn a month of raw bank transactions into a budget-vs-actual view and catch anything odd.

Questions to ask me first:
- Which months and accounts are in the export?
- What are your budget categories and the monthly amount for each?
- Is there anything that should always go in a certain category?

Inputs (fill in or confirm):
- Bank export (dates, descriptions, amounts): [TRANSACTIONS]
- Budget categories and amounts: [CATEGORIES / BUDGET]
- Known rules (e.g., Venmo rent goes to housing): [RULES]

Rules:
- Put each transaction in one category, treat returns as refunds, and use 'Other' rather than guessing.
- Build a summary with spending per category, budget, difference and over-budget items highlighted.
- Flag possible duplicate charges, unusual patterns and whether the data covers the whole month.
- Give a small budget to 'Other' so it isn't always shown as over budget.

Checkpoint: Show me the transactions you put in 'Other' and ask me where they belong before building the summary.

If you get stuck: If a description is unreadable, list it separately with the date and amount so I can look it up.

Verify before you finish: Check that category totals add up to total spending and that the date range is stated.

Output: A categorized transaction list, a budget-vs-actual summary and a short list of flagged items.

Done when: Every transaction has a category and I know which ones to double-check.

AI tool

Gemini

Outcome

Haroun Adamu gave Gemini in Google Sheets a sample bank export of 42 October transactions with raw entries like 'POS DEBIT KROGER #6948' and asked it to sort them into 10 existing categories. It placed most correctly, put hard ones like an Amazon purchase and a Venmo payment in 'Other' and treated a Target return as a refund. A new tab compared spending to budget and highlighted overages in red: $3,440.84 spent against a $2,830 budget, with groceries $177.36 over and household spending at more than double its $90 budget. Asked about unusual transactions, Gemini flagged two identical $24.99 Planet Fitness charges four days apart as a possible duplicate, noted four different grocery stores in 72 hours and pointed out that the data only ran through October 22, with more than a week of the month left.

Evidence: Article or interviewA newsletter, journalist or interview account of what happened.

Source

Posted
by Haroun Adamu (Android Police)
Last checked
Method:
How we verify

https://www.androidpolice.com/let-gemini-run-budget-in-google-sheets-saved-hours-of-manual-tracking/

Context: Adamu tested a sample bank export, not real accounts. Gemini in Sheets is a paid feature at about $20 a month, and an unbudgeted 'Other' category always shows as over budget.

More in Money, Bills & Taxes