-
My original thought was to use OpenBanking on something like Monzo/Revolut and see what options there were to export from there. Alternative is to capture phone notifications and use Tasker to upload details to a Google Sheet or similar but I'd need to spend some time working out how standard the various notifications are so seems a hassle.
Moneyhub looks interesting though, may give it a try.
aggi-
I made a Google sheet which gives me a dashboard.
Every account has its own tab. For credit cards, current accounts and savings accounts, the tab has 2 areas, a “summary” and an area I can just dump the export from the app or website as most do a csv export. Summary area just has Starting Balance (at start of tax year) and current balance, which is calculated from the data dumped in. Each bank has its own export format but most give you a money in/out column so it’s easy to calculate balance. I also have extra columns for spending categories, some accounts I add that manually but some like Monzo do it in the app and the export data contains that field.
Investment accounts and pensions have summary area with starting balance/current balance, then a row per month with monthly balance (I update once a month on pay day). Some accounts I also have a split between bonds/funds/stocks/other.
I then have a dashboard tab which summarises all the accounts into one table to show total balance per account type. It also has payslip info so I can see tax paid etc.
I have another tab which shows spending per category over all accounts, basically by doing a pivot table over current account and credit card sheets.
Sounds complicated but only took a couple hours to set up and takes me about half an hour per month to update. I looked into more automated methods but not all accounts support stuff like that so it didn’t seem worth the effort. I think Monzo allows automatic exports into Google sheets but it might be a premium feature.
Pantsmaster
Old post, sorry, but thought it might be useful
You need to be licensed to use Open Banking IIRC so it's a no go for an individual. I've not found anything as good as Money Dashboard. I have a spreadsheet but I don't update it frequently enough and it doesn't show me transactions obviously.
I used Emma for a bit but it really pushy about upgrading to a subscription and made me jump through hoops to delete my account.
There's Moneyhub but I haven't tried it yet: https://www.moneyhub.com/app