Monzo Plus: export to Google Sheets - feedback and thoughts after a couple of weeks of use

Best suited for another topic for sure, but I’ll be brief. It’s hard to pin point what exactly is the delight factor, but I think ultimately it comes down to elegance and simplicity in design and execution. Monzo’s features are nice, but their approach is rarely elegant, or as simple as it could be.

1 Like

That’s a fair take: we started with a simple implementation that was pretty much a self-updating version of the csv export feature. We were also confident that users were going to come up with great ideas on how to use it (and it is happening :slight_smile: ). There wasn’t that much time to plan for anything else (initially we had to finish this by end of Jan).

I think we never imagined Joint Accounts transactions going into the same sheet as Personal Account’s ones, they would go into a different sheet, possibly even a different spreadsheet.

(I never had a Savings pot :see_no_evil:) are interests deposited directly into the pots or into the current account?

I think when we built this we didn’t have virtual cards yet :grimacing:, but it’s a fair point. It would also be required for Joint/Business accounts with multiple cards.

That update is not trivial for how things work behind the scenes. I don’t work in the team owning the feature anymore, but I’m afraid it is possible that this will not get addressed in the short term :disappointed_relieved: .

A workaround could be doing a new full export (resetting the integration) whenever you change a custom category name, eventually manually copying over all of your formulas from your old spreadsheet :disappointed_relieved: .

I’d love that too, maybe a read-only spreadsheet with some fake transactions and a lot of sheets with different graphs/data aggregations.

7 Likes

Which would be just as good if they actually iterated. At times if feels like dumping the minimum required and losing interest (managing payees for example).

2 Likes

There’s also value in knowing whether you used Google Pay or your card (or even which card) - both in the app and in the export, too.

1 Like

Thanks for replying! Obviously I love the fact this export exists - I just want it to be nearly bulletproof!

I can see the logic either way - because of the way I use my accounts, I’d quite like to see both represented in the same data set. One big ol’ data dump that is then infinitlely filterable. I just sense that that approach would be more straightforward to deal with at the user end than having to merge together data sets to do combined analysis (or, have the option for both!)

And I say that coming from a place where I hope my Connected cards data would make it into that set - I’d rather have 1 feed than 5/6 workbooks. But again, either approach brings problems so I appreciate it’s not all straightforward.

They are directly to the pot - so those transactions are skipped. Also brings about a problem of how you could display this - right now if you sum the entire balance column you get your up to date Main account balance. So bringing this in (and any other accounts to my previous point) makes that harder to do without extra filtering.

YNAB solve this is a nice way - they have an “inflow” and “outflow” column. A balance-to-pot transfer, to YNAB, would see two lines in the register - one inflow to the pot, and one outflow from the main account. That way would allow interest to be added to the pot directly, with no issue with balances. (And the Sum of the inflow + outflow column becomes the total account balance).

Expected that would be the case :’( On the plus side though, you could use that as a way to have year-specific categories. If I had “Christmas 2020” for all my this year spending, I can change it to “2021” next year and past transactions arent affected. (Though that would defeat the purpose for graphing/pivoting I think, but I’m sure there’s a way that can be useful!)

3 Likes

Great post, thanks

Another vote for this. I clicked the “Get Monzo Plus” button hoping to see something a bit more tangible [can something be virtually tangible?] but there was nothing like it to be seen, so I backed out.

I have since had an in-app message asking if I’d like to speak to someone about M+. Once I’d recovered from the shock of my visit being noticed, and impressed with the AI that responded - I said yes. I will report back on what happens. If you don’t hear anything … R-

1 Like

This is the key feature for me and I’ll probably type up some more thoughts when I’m at a proper keyboard, but my first thought is that really at the moment it’s only good for those who know how to work a spreadsheet.

People on here are a very small (probably geekier) subset and I can use a spreadsheet and lots of others on here are far smarter than I am. So it’s to be expected that we can use some formula for our sheets and make it do most of what we want.

But what about those don’t know what a SUMIF is? Or even the people that would like a bit of help/guidance with what can be done.

I think there should be a second sheet that basically gives an overview, “Your Monzo Life”

Your top merchants, spent money per year, a few other facts and then people will realise what they can do with it.

But to just see a big list must be quite intimidating for people. “Where do I start?”

5 Likes

For me, this makes the data export almost useless for me, the most basic things I want to do is be able to plot/calculate totals for pots and see all transactions within a pot over a certain time period. This would be so easy if transactions with split categories were listed as separate rows for each split but as it is the data is basically useless. I’m someone who does have the knowledge to write a script to fix it but honestly I don’t want to spend my time & energy fixing something that should have been thought about at the monzo end

2 Likes

I was today years old when I found out about this:

2 Likes

So some time ago in a sale frenzy I bought Emma Pro for a year (I think it was 70% off at the time). - and just went back to look if they have a data export.

Turns out they do - and it captures all accounts you connect to as one stream. It’s not live, which is a shame, and Pots aren’t handled in the best way possible - but this would be a good version of what one “omni stream” looks like. I may at least use this as a source for my other connected account data in my Dashboard, at least until my subscription at Emma ends.

If you could merge the best bits of Emma’s and the best bits of Monzo, it would be one super tool.

2 Likes

@edo1493 Time to buy Monzo :+1:

1 Like

LoL.

We should be able to add export to Google Sheets. :wink:

ps: we have also added Accurate Net Worth + the fastest category editing you have ever seen over the weekend (in Emma Pro).

2 Likes

Seems there are many budgeting apps that will export a CSV file - MDB, who I currently use for instance. The problem there is the L1 and L2 tags [categories of transaction type according to MDB] that they assign to each transaction have to be edited - or added. Then the CSV data needs to be imported to the spreadsheet app of your choice. This used to be my process each month. I gave up. I am waiting for Money in Excel to come to the UK :weary:

Download CSV for the last month from MDB
Import into Numbers [usually, I have used Sheets and Excel - the process is similar]
Adjust the supplied categories to match your expectations
Delete - or hide - the ones you know you will never use
DIscover that one or two are incorrect and adjust again
Discover that you have far too many categories to make sense of your Spending
Create new category to capture little things - perhaps House
Create another new category to capture one-offs - perhaps Garden
Merge others so that your spreadsheet is not 2 yards long
Manually input that data into another spreadsheet that captures annual figures
Realise that none of it makes sense anymore - give up.
Get glass, ice, Gin, lemon & tonic

R-

3 Likes

A very interesting thread. As a Product Manager (albeit in a different industry), there’s a useful warning about a “partially agile” approach. If you don’t iterate then all you’ll ever have is an uncompetitive Minimum Viable Product.

As a Monzo user, Monzo Plus seems either like a way of creating a lot of work for yourself or a way to save £5 a month.

I shall watch with interest to see how Plus develops.

1 Like

I’ve been busy manipulating the data from my Google sheet into this dashboard in excel. It’s a shame I have had to do this in the first place and (like others) I wish Monzo could do all this stuff in app to allow users to really track their finances month by month. Some of the stuff I’ve made on here (like the left to spend tile) is available in Monzo but is completely useless to me because I do most of my spending on Amex and you can’t currently connect Amex to Monzo and even if you could you can’t categorise those transactions. However, I’ve set up IFTTT to transfer Amex transactions into a pot which then shows up on my Google sheet and voila! I am dreading the day that Google sheet gets changed by Monzo and breaks my dashboard.

4 Likes

Truly a thing of beauty. :two_hearts:

1 Like

How did you make it look so good!

Can you guide us how to do this ?

2 Likes

Stunning. Wow!

1 Like