IFTTT + Google Sheets + Monzo = Then what?

Alright there’s definitely something strange going on. Lots of transactions decided to show up overnight, but some are still missing and lots of them are in the wrong order on the sheet (no sorts/filters applied).

1 Like

For anyone interested, I spoke to Monzo about this and they’re aware of the issue. It’s down to some internal work they’re doing and it’s likely to be delayed for the rest of the day. Really informative response from the team too which is great to see :raised_hands:t5:

6 Likes

Another chart (that I probably don’t need)

My savings have taken a bit of a battering lately (holiday/home improvements) so now I want to just get back ahead of 2020!

3 Likes

Inspired by this…

I can tell you that mine is not £9.54! George needs to go outside.

Something else to track anyway.

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.

Considering the other topics have been auto-closed, this is probably the most appropriate place for this.

Has anyone found a way to automatically pull Amex transactions into Google Sheets when you use iOS yet?
I was previously using the Android method, but for reasons I won’t go into here, I’m now on iOS and in making the switch I’ve lost my automatically updated balance and combined Monzo and American Express transaction data in Google Sheets.

I was going down the path of using the weekly statement balance email American Express can send you if you opt in to compare my card balance to my pot balance and then move the appropriate amount each week. I did all the groundwork, but then realised that you can’t automatically forward emails to IFTTT without a verification email being sent to the forwarding address that can’t be retrieved.

So now I’m looking at alternatives. I’m wondering if getting hold of a Raspberry Pi and running Android on that could work? Maybe I should just get hold of a cheap android phone or tablet and leave that running? Or are there services out there that plug into the Open Banking data Amex make available and could potentially be used to bring transactions over to Google Sheets?

3 Likes

Can someone help with a formula please :pray:

I want to monitor (with the aim of cutting down) spending on lunches and things when at work.

Could someone help with a formula that will get the total spend from ‘Eating Out’ each day into a format like the below:

This Week Last Week 2 weeks ago 3 weeks ago 4 weeks ago 5 weeks ago 6 weeks ago 7 weeks ago 8 weeks ago
Monday £0.00 Monday £0.00 Monday £0.00 Monday £0.00 Monday £0.00 Monday £0.00 Monday £0.00 Monday £0.00 Monday £0.00
Tuesday £0.00 Tuesday £0.00 Tuesday £0.00 Tuesday £0.00 Tuesday £0.00 Tuesday £0.00 Tuesday £0.00 Tuesday £0.00 Tuesday £0.00
Wednesday £0.00 Wednesday £0.00 Wednesday £0.00 Wednesday £0.00 Wednesday £0.00 Wednesday £0.00 Wednesday £0.00 Wednesday £0.00 Wednesday £0.00
Thursday £0.00 Thursday £0.00 Thursday £0.00 Thursday £0.00 Thursday £0.00 Thursday £0.00 Thursday £0.00 Thursday £0.00 Thursday £0.00
Friday £0.00 Friday £0.00 Friday £0.00 Friday £0.00 Friday £0.00 Friday £0.00 Friday £0.00 Friday £0.00 Friday £0.00
Saturday £0.00 Saturday £0.00 Saturday £0.00 Saturday £0.00 Saturday £0.00 Saturday £0.00 Saturday £0.00 Saturday £0.00 Saturday £0.00
Sunday £0.00 Sunday £0.00 Sunday £0.00 Sunday £0.00 Sunday £0.00 Sunday £0.00 Sunday £0.00 Sunday £0.00 Sunday £0.00

Super bonus points (if possible) to change the colour of the cell if it is lower on that day compared to the same day on the previous week.

1 Like

Like this?

I’ve added it to a tab on the dashboard called “Lunches” but you can use it to monitor your RSPCA spend…

Change the date at the top along with your chosen category and then the graphs will self populate. You’ll have to change the date weekly so it’s the most recent Monday. There will be a formula for it so you can do the Monday automatically, I’ll have a look later on.

4 Likes

OMG you legend :bowing_man:

I already had the formula for this, so here you go:

I’ve copied it all over, matched the name of my “master sheet” but I think my columns must be a bit different to yours.

What are the column names in this formula please so I can alter it to match:

J = Local amount
G = Category
B = Date

They should be standard ones

1 Like

Perfect, thanks! All working and looking good :heart:

No more spending a small fortune on meal deals + extras with the odd Just Eat thrown in there :speak_no_evil:

2 Likes

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! :smiley: 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!

1 Like

This what I want this sheet to kick me into doing.

I’ve also been skipping breakfast so by lunchtime I’m starving so I buy half of Tesco!

3 Likes

If you’re really keen you can map time and value of your lunches and track weekly work lunch expenses;

1 Like

There isn’t much correlation between later and a higher spend over a traditional lunch time. But if you go early, you’re a cheap date! Is that just a breakfast snack?

It was typically lunch for two, but if I was grabbing lunch earlier then it was probably just for myself. The other weird times are at airports or in different timezones.

There are two main pink clusters of around £14 at 12:15 and at 13:15. Subway was a 15 minute walk from work back in pre-pandemic days.

Thankfully we’re both now working from home most of week, but that lunch expense was just added to our grocery spend;

The spike last month was going to a fancy restaurant as a treat and blowing nearly all of our monthly food budget haha.

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’ :grimacing:

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.

1 Like

To fix, you could search for Tesco <£x and that would at least show you the ones you need to change.

1 Like