Useful uses for Monzo Plus Live Data Export? Share your tips!

Hi guys, does any of you have figured out how to get transactions from shared tabs into the spreadsheet?

Context: my gf and I mainly use shared tabs and that basically destroys the usability of trends for me.

The quick and not really scalable solutions I’ve found is to tag the transactions I make and then build a formula that divides the transaction by 2. Not bad but still two main challenges for me:

  1. All transactions that she makes do not appear anywhere and I have to manually input them into the spreadsheet

  2. Split is not always 50/50 and I can’t find a way to retrieve this information (beyond taking a look at each transaction)

A bit hopeless here but happy to hear your thoughts.