Investment & Investing

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.