Compare spending with your budget in Google Sheets using Gemini
Haroun Adamu at Android Police gave Gemini in Google Sheets a sample bank export with 42 October transactions. Gemini sorted them into his 10 categories, subtracted a return and built a tab showing $3,440.84 spent against a $2,830 budget.
Done with Valgfri agentModerate
This is a public report, not advice from Skatteetaten, NAV, Altinn or an accountant. Check figures, deadlines and decisions against the original.
What was done
Haroun Adamu at Android Police gave Gemini in Google Sheets a sample bank export with 42 October transactions. Gemini sorted them into his 10 categories, subtracted a return and built a tab showing $3,440.84 spent against a $2,830 budget. It also found two identical $24.99 gym charges four days apart, but the data was a sample, and the feature costs $20 a month. Check the original.
How to do it
- Paste the prompt into the tool, and replace the text in brackets with your own.
- Read the answer through. Do not send, delete or publish anything until you have seen it yourself.
- Check the original before you trust a figure, a name or a date.
Try it with Valgfri agent
Here is my bank statement for [month] as a CSV from [bank]. Sort every transaction into the categories [list], subtract returns and build a tab comparing my spending with my budget per category. Flag charges that look doubled and purchases you cannot place. Do not contact the bank or any shop. Show me the list of possible double charges before you change anything in the sheet. You are done when every transaction has a category or sits under Other.
Replace text in brackets with your own.
Done when. Every transaction has a category or sits under Other.
Android Police ·