Monzo 'Dashboard' - Add your own data

Here goes nothing… I can’t keep adding bits or trying to change things. Get things get shipped or whatever that motto is.

I’ve tried to make a template that is broad enough that it should give some form of insight into something. I hope so anyway.

Link - Please save a copy

First things first, you need to save this template as your own.

File > Make a Copy – Save it where you wish

You’ll need to get your data. You can either download the CSV and paste this in, or you can use the Google Sheets feed if you subscribe to Plus/Premium. To preserve the data as it comes, this only links to it. The sheet from Monzo will come named as “Monzo Transactions” I think, but if not, if you can name it as that, it will link correcntly.

Get the URL for the sheet and paste into C2 in the “Set Up” tab

Image 1

Below will automatically get the first date in your sheet. This is used to create the #MegaPulse that we’ll get to a bit later on.

If you have a pot you wish to see a Pulse style graph for too, then add the name and how many days view you’d like of that pot.

Also here is the section to correct merchant names. This won’t change any of your data but tidies it up a bit.

Image 2

I’ll go over a few tabs and what I’ve set up and how to understand what I’ve done.

Overview

This is a good place to see what’s going on across your account. There are two drop downs to select month and year.

Then from left to right;

Your current account balance and the balance of all pots your ever created. Along with the +/- in/out of that pot for that month. You may have a pot balance that is showing as minus. This is likely because you put money in, changed the name, then took it out.

Details of any incoming payments, this will include refunds etc. It’s basically anything that gives your account a +, along with a total and amount of transactions.

Same as above but for out-goings. This will include direct debits etc.

To the right is an overview of the overview. Money in and out of your account, if you subscribe to Plus/Premium, how much you’ve spent and how much interest you’ve received. How much you’ve put into pots this month and the totals for the key payment types. (I realise this don’t add up, I’ve just typed random numbers so it’s not my data)

This bit I’m calling SalarySorterPro. Sort your salary in advance by £ but also by %

Image 4

Add your expected salary into the grey box and then work out how much you want to add to each pot. The left side does it by £ and the right by %. Each will tell you what the other is, there’s probably a way I can make them counter each other and stop you trying to spend 147% of your salary, but that’ll be future polish!

Compare

One thing I complain about with Monzo is that it’s difficult to see what you’ve spent and compare it to other periods.

Select two months and you’ll see a list of merchants, your spend/transactions across both and the variance. I’ve set green as less spend, presuming that’s good, which it might not be in all situations, but I think that fits most.

Then the same for categories. The same as pots, this is a list of all categories you’ve used.

Image 5

You can also compare how you spent and if you set yourself a monthly total budget, how you did compared to that.

In the grey box, type your budget and it will plot the two months to the left for your cumulative spend vs budget. If you don’t have/want a budget, just delete/set to £0 and the red line will go away.

Below that are how much you spent each day.

Pot Goals

Pots are great, but sometimes when you’re saving for something, it’s great to know that you’re 50% there but are you halfway in time?

Image 6

Select the name of your pot, the start and end dates, the goal and how much you’re starting with. It will tell you how many days you have, how much you need to save per day and then a graph on the right to show if you’re ahead of behind your saving goal.

Merchant Check

Want to look at how many times you go to McDonalds? How your coffee habits have changed with a lockdown?

Select your merchant from the drop down and it will give you a list of the important info related to that transaction and plot it on a graph so you can have some #datavis

Graphs

This started off with just #MegaPulse and then I’ve added more and more until I’m not sure if they are of any use or not :shrug:

This shows your balance from day 1 of your Monzo account.

There’s a tracker for your chosen savings pot (The one you named in the set-up tab)

Spend per month

Card payments per month

On the compare tab, this is just a repeat of your comparative months.

Then the two graphs you’ve set for your Pot Goals.

And I think that’s about it. There’s various helper columns and helper cells dotted around, so if you see a cell with text in and it’s white, it’s probably helping with something else.

Please feel free to amend how you see fit and if there’s anything that you think it needs, I’ll see what I can do!

32 Likes

Fantastic effort there @Revels :clap::clap:

I’ll have a mess with this later :+1:

3 Likes

Looks amazing. Will definitely try this out after work, thanks @Revels!

This looks fantastic! Will have a play around later. Thanks for sharing.

:eyes: Image 2

7 Likes

This looks great! Can’t wait to try later

First quick go during lunch, with a .csv export from our Joint Account:

  • renamed the downloaded .csv file to Monzo Transactions.csv
  • uploaded to the root of GDrive (with conversion to Google sheets ON when uploading)
  • renamed the file to Monzo Transactions
  • copied the link & pasted into the Setup C2 cell, nothing happened,
  • looked at the second sheet (‘Monzo Transactions’) and saw cell A1 was red, hovered over it and:

Capture

Must be a formatting or naming convention thing.

Hmm, are they both in the same folder location?

If you replace “Setup!C2” with the URL of the data file, does that solve it?

As you’re uploading yourself, you could just copy and paste it from that file into A1 in that tab. A-P will be all you need.

Both files in same location (root). Replacing “Setup!C2” with “URL” resulted in a ‘loading…’ display in the cell but then ended with the same error as above (Cannot find range or sheet for imported range)

Will try a manual cut & paste!

EDIT: Manual Copy & Paste resulted in some data showing, but not all. Joint Account curse? I’ll try later with my Personal account…

Awesome stuff, have been looking forward this coming out :slight_smile:

Going to play with it this afternoon.

image
Which coincidentally someone looking at this image may say too.

9 Likes

I know! It’s annoying how eBay do that now…

2 Likes

I guess someone didn’t follow the instructions because it’s now marked private? :confused:

Try now…

1 Like

That’s better, thanks! :blush:

I only got part way through looking at it and it was jumping around all over the place. I even saw loads of transactions in there so someone is messing around with it.

Will look later many thanks looks interesting.

Monzo hero of the year I expect!

I’m ever so slightly sad/frustrated that this had to come from a user and not Monzo themselves as a paid user but hey ho this is amazing. Thank you.

We will keep your addiction to the “RSPCA” to ourselves. You selfless thing, you.

11 Likes

Weirdly I’ve just gone into my Monzo Transactions feed and it randomly stops in Mid December.

Can’t seem to get transactions beyond there!

I’m hoping they see that people like/use this and it prompts them to do it properly!

2 Likes

Nice to see a fellow animal lover donating to rspca @revels

7 Likes

Reinstall fixed it when that happened to me :crossed_fingers:

You have made a thing of true beauty. So much so, that I may have to sign up to Plus (again).

It’s really brilliant, and I’m going to learn so much about Google Sheets from it.

There is one tiny error, though. On the ‘Compare’ tab, you’ve misspelled Merchant as Marchant.

We can all stop now. The contributor of the year trophy has been won in February, folks!!

4 Likes