Thanks to generous assistance from a reader, I was able to spend some time poking around the new Money in Excel template for Microsoft 365 Personal or Family subscribers. Does it fulfill its promise of helping you “see all your financial accounts in one place, make a plan, and reach your financial goals”? Here’s my rundown of the features that were included and those that were missed.

Accounts Toolbar. After following the clear installation instructions, you can add your various financial accounts using the toolbar on the right-hand side. (I just connected a few secondary accounts for review purposes.) Plaid is used for account aggregation, where you provide your login and passwords and they use that to grab your account balances and transaction history. This data import feeds the rest of the Excel worksheet, but the panel itself is a useful at-a-glance snapshot of your finances. The feel is very similar to the “Overview” page on the Intuit Mint app.

Customized Categories. In the “Categories” worksheet, you can create and edit the names of custom categories used to organize your transactions. For example, I added “Charitable Giving”. You can’t edit the original, default categories.

Transactions. You then move onto the “Transactions” worksheet, where you can edit the categories assigned to each specific imported transaction. If you have a lot of transactions across different bank and credit card accounts, this provides a handy aggregate view of everything together.

Spending analysis. For the most part, this template is about budgeting and spending. Once have all your transactions imported and categories, it will generate some basic charts and provide some simple insights into your expenses. Here are some examples:

  • Spending breakdown by category
  • Current vs. previous month spending
  • Cumulative spending over the month
  • Net worth calculation (assets minus liabilities)
  • Top merchant: Where did you spend the most money?
  • Bank fees: How much are you paying in fees?
  • Subscriptions: Where are your recurring expenses?

This is all useful for someone trying to understand their spending and developing their own budgeting system, but it’s definitely not groundbreaking. Mint.com has providing this type of service for many years. The main differences are that there are no pesky advertisements inside your own Excel worksheet, while the Mint smartphone app may be more convenient.

Missing: Holdings, asset allocation, performance tracking. I am able to connect to an investment account, but it only shows me the total dollar balance. That’s it, as far as I can tell. There is no data on individual holdings, no asset allocation breakdown, no performance tracking.

Missing: Investment transaction list. I am not able to see historical buy/sell transactions on a simple view-only basis, like on the credit card side. It would be nice just to see the last 10 transactions, for example.

There are other portfolio spreadsheets where you can manually input ticker symbols and share counts and they’ll pull in market quotes, but that doesn’t adjust for events like dividends, stock splits, and dividend reinvestment. I was hoping to create a single portfolio spreadsheet using the imported data cells from my brokerage accounts, one that would provide a live view of all my investment accounts, but also allow me to manipulate those data in order to determine if/when to rebalance my portfolio.

For now, I will have to stick with my existing system using both Personal Capital and a custom Google Spreadsheet to track my investment holdings. The Personal Capital financial tracking app (free, my review) automatically logs into my accounts, adds up my balances, tracks my performance, and calculates my asset allocation. Then, I use my manual Google Spreadsheet (free, instructions) to help me calculate how much I need in each asset class to rebalance back towards my target asset allocation.

Bottom line. The “Money in Excel” template for Microsoft 365 Family and Personal subscribers is a free, basic template that imports your spending transactions across different bank and credit card accounts. It can help you with monthly budgeting, but not much beyond that. I hope that in the future they expand it to investment accounts and allow you to have more control over your data. It would also be nice if they made it free for everyone with access to Excel, not just Microsoft 365 Family and Personal subscribers.

“The editorial content here is not provided by any of the companies mentioned, and has not been reviewed, approved or otherwise endorsed by any of these entities. Opinions expressed here are the author’s alone. This email may contain links through which we are compensated when you click on or are approved for offers.”

Money in Excel Review – Good For Budget Tracking, Bad For Investments from My Money Blog.


Copyright © 2019 MyMoneyBlog.com. All Rights Reserved. Do not re-syndicate without permission.

©