Looking at mine, it looks quite good when it looks like three weeks ago/six weeks ago were £0 on lunches, and probably only a meal deal in weeks four/five.
Until you realise those are the only days I’ve been in the office! Any day at zero is because I’ve been at home. I used to be so much better about prepping for the week but now I go in probably once a week, it feels easier to buy something. Must. Stop!
Limiting it to the last couple of months was bad enough, never mind if I saw all time. That’s a really cool and useful graph though!
I kind of messed it up a bit though and it I had to manually go back through loads of transactions.
The Tesco near work where I get lunch and the Tesco near home where I get petrol all got categorised the same. I made the mistake of selecting ‘all past and future’ transactions when categorising so everything went to ‘eating out’
Ouch! Pre-pandemic I was in the habit of tagging lunch transactions with #lunch while eating my sandwich which made it relatively straight forward to identify lunch spends. I’ve not been doing it so much anymore so its not as useful, unless I go back through all my transactions and tag the lunches.
Another way that you could approach the same problem would be to just sum all transactions that occur during your typical lunch break by filtering the time column.
Just want to revive this topic, partially because its one of the last remaining open google sheets thread, but also to re-raise the issue/bug of missing interest payments in the google sheet export.
This was not a major issue when the auto-export was first set up, but that was over a year ago and saving rates are a little healthier now. Missing interest payments from the CSV export means that the live google sheet feed cannot be used to accurately determine account balance. Which is frustrating as its a paid-for feature.
Can I pretty please ask for someone at monzo to take on a mini project in the new year to add interest payments to the CSV google sheets export (including the live export)? Even if its needs to be its own column to avoid messing anything up, that would be perfectly fine.
You’ve got me doubting myself now, but my understanding is that no interest payments appear in the Google sheets exports at all. Including plus/premium interest payments as well as payments from interest bearing savings pots.
Increasing interest rates on savings pots is awesome, but interest still doesn’t show up in the automatic Google sheets export (a paid-for feature of plus and premium) or the regular Google sheets export.
I haven’t seen this being mentioned anywhere, but I would love it if the Google Sheet could have a second spreadsheet on the same file that JUST has the balance of each connected account. I would love to automate all my finances further if this was possible.
Also, If anyone has any cool spreadsheets, dashboards, ideas, IFTTT uses and even ChatGPT uses, please share.