CSV export for joint accounts - identify cardholder

Hi,

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.

Thanks,
Martin

3 Likes

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.

Was this ever fixed ? Was just about to rec back spend vs salary for joint but can’t do it (easily) without knowing who spent.

No, there’s no identifier for who spent.

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.

It’s 100% accurate. The question is about the export.

1 Like

And my point is that we’ve moved 5 years and still can’t identify … pretty ropey service if you ask me…

As per usual you reply in a sassy and unnecessary manner…

My apologies for answering your question.

1 Like

You did not answer it.

You replied saying their is no identifier… there is.

:exploding_head:

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.

1 Like

should change the username to Pedant - you know exactly what I meant and seem to get kicks out of winding people up.

1 Like