There’s a couple of threads about the data export - but loads of people (myself included) willing to help out.
There’s also this thread: IFTTT + Google Sheets + Monzo = Then what?
Has lots of other useful bits of data integration and a few Pointers. @lewisp has posted a helpful template too for getting started.
For your questions:
-
in a pivot table, you can do this with cell formatting - basically force the negatives to show as positive. Let me find an example and come back.
-
split transactions - it is theoretically possible - it needs a “script” to do, which I haven’t seen anyone attempt yet. It’s on my list to try and work out. If I work it out I’ll let you know!