Because I’m a nerd, I’ve made something to review how your last the 365 days between 1st Jan and 31st have been for you. This is definitely not YearInMonzo. It’s very different.
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. I will not see any of your data. It doesn’t have to be just 2021 data, the formulas will sort that out.
In the Data Input tab, in between the first " ", add your URL or copy and paste the old school way.
The next tab is “Merchant Replacements” if you want to tidy your data up a bit, you can do this here.
There is some data that I can’t get, contactless vs card, in person vs online etc. But this is what I’ve come up with… (I’ve edited out some of my data)
Across the top are your top 10s. Categories, merchants, transactions and emoji. How much you’ve spent in all these areas in 2021. Then your top 10 pots. Some other very important facts.
Graphs on the right show your monthly net, above the line shows you spent more than you saved. Ooops.
The coral tables are your categories, you can use the selection box and choose any of your two categories and compare them.
The pie chart of all your categories is mainly so that I can see what a mess it looks like for @Alexxxxx
At the bottom is card use. Which days did you spend on your card the most? Are you a Saturday spender and resting on Sunday? How many times you used your card on each day of 2021 and then a split of days used vs not used.
Then the best part!
Put two merchants against each other. Press the “New Challengers” button and it will generate at random two new merchants to compete against each other.
(I’m not 100% sure the macro will work for everyone else, so if it doesn’t, you can just press backspace/delete in any empty cell and that will refresh it)
There will be a prize for the best two merchants against each that are in no way related but the graph shows differently.