I have just done a CSV export from our joint account, and I can’t see a way to identify who did a card transaction. (me or my wife). Is there a way to identify this, or could a column be added with the last 4 digits of the card or some other identifier. This would help when analysing who is spending what! Our RBS joint account has last 4 digits of the card in their CSV export.
I hope someone at Monzo takes a look at this, as lack of this information makes the exported data useless in some cases. For example, I wanted to check how much I spend on TFL tickets on average in a month but there’s no way to do distinguish my charges.
Well thats not really a accurate statement, the transaction shows the image of who spent on the app - the export (bizarrely) does not give this info - making reconciling time consuming.
The answer was there. Maybe an extra clarification is needed?:
There is an identifier for the user who was involved in the transaction in the app (icon on merchant logo: no icon = you spent it, Icon with initial of other person’s name visible = they spent it)
But this user-spend-identifier is not included in the exported data from the app, so you are unable to reconcile quickly as you wish to, using said as-yet-unavailable identifier.
The .csv and the .pdf exports don’t have it. I’m sure the .qif file doesn’t either, but I haven’t tried that.
EDIT: Looks like the Emoji column in the .csv export has it, mixed up with others. The same ‘emoji’ is shown against transactions made by MrsW (card / phone transactions) and a slightly different ‘emoji’ is shown against transactions made by me (card / phone transactions). Although there are also ‘emoji’ entries that start with the same ‘emoji’ but have extra characters too.
Quite how you translate these ‘emoji’ into a meaningful id for searching/grouping is anyones guess.