You could try downloading the whole lot and use a pivot table to filter by category
I appreciate this is going to have to be an ever evolving item as and when new features/products are added to the offering, but is this feature ever going to make it out of labs?
I haven’t seen anything happen with this for ages.
I would imagine moving it out of labs means they’ll need an actual “button” or something, and what with the new UI it’s probably best to wait for all that to be finalised before adding new functionality (because otherwise you might need to move it as soon as it’s been added).
Fun to note this works for USA accounts but only gave me chat and SMS history (and SMS history is blank even though i’ve received two for Apple Pay).
I managed to get an export on android. I was initially confused about where to look after enabling the option in Labs. However I eventually saw the information in the transaction list.
I’m mostly interested in my bank statement to use in accounting programs for tax/analysis purposes. The current export falls short in 2 ways for me at the moment:
- html is not an easy to work with format. CSV would be ideal
- Category information is missing.
If Monzo addressed this then it would make such a difference to my experience of having to import and categorise all transactions before being able to work with the data. Being able to get complete transaction history with categories is a feature I would change accounts/banks for
I have the option to export data as CSV. This export includes category and description info for every transaction
I don’t have this option on android, or at least its not obvious where to find it. This is all that comes up:
Followed by this email:
Which contains a link to a zip file with my transactions in html (and other information like chats, etc).
I can’t see where to do this. I wonder if this didn’t make it into the new nav?
(edit) nevermind, I think I’ve found it on the summary screen
(edit) or is that a different export?
At the very bottom of your summary page the other statement options are available
Continuing the conversation here.
In short, I take the raw CSV data and sum the transactions up until a given date to calculate the balance. I’ve created a watered down version of my spreadsheet here. You should be able to download this, paste your CSV data in and the balance sheet should update. Any issues let me know
Ah I wondered if you may have been able to automate it. I assume that would require some scripting with the api
I think IFTTT can add an entry to a spreadsheet everytime there’s a transaction. But I haven’t looked in to it, and it would only work for personal account and not joint account.
This is good to know.
It would be nice to see some spending graph comparison in the app, I know Barclays does this. But I might play around with IFTTT and see what it does.