Money in Excel: Automated Budgeting and Personal Finance Template (Free for Microsoft 365 Subscribers)

It’s not the classic Microsoft Money application (which I’m still asked about periodically), but Microsoft 365 Personal or Family subscribers can now download “Money in Excel” (free) which promises to help you manage your personal finances using Excel tools and the automated import of your transactions. Thanks to reader Motti for the tip. From their official blog:

Money in Excel is a dynamic, smart template and add-in for Excel that allows you to securely connect your bank, credit card, investment, and loan accounts to Excel and automatically import your transaction and account information into an Excel spreadsheet.

The service uses Plaid, a third-party company (recently acquired by Visa) to synchronize with all of your various financial accounts. You will have to provide the username and passwords for those accounts. (If you haven’t already, use a password manager so that you can maintain unique, strong passwords for each of your bank or brokerage accounts.)

You can do things like track your monthly spending by category, add up your net worth instantly, or get notified of selected transactions like big purchases or bank fees. Here is a screenshot:

Money in Excel: Automated Budgeting and Personal Finance Template (Free for Microsoft 365 Subscribers)

Unfortunately, there doesn’t appear to be a way to access this premium template if you do not have a Microsoft 365 Personal or Family subscription ($70 to $100 annually). I am not a 365 subscriber myself, so I am unable to test this out further. I’d be interested to see if you are completely free to customize the Excel using all the imported data, for example can you make your own constantly-updated rebalancing template? If you try it, please let me know what you think in the comments or via Twitter @mymoneyblog.

“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: Automated Budgeting and Personal Finance Template (Free for Microsoft 365 Subscribers) from My Money Blog.


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

©

Related Posts

Money in Excel: Automated Budgeting and Personal Finance Template (Free for Microsoft 365 Subscribers)Money in Excel: Automated Budgeting and Personal Finance Template (Free for Microsoft 365 Subscribers)
Adorable Glass Ghosts by Masanaga Noike Cradle...
All images © Masanaga Noike Masanaga Noike, who’s behind the Nagano...
Read more
Money in Excel: Automated Budgeting and Personal Finance Template (Free for Microsoft 365 Subscribers)Money in Excel: Automated Budgeting and Personal Finance Template (Free for Microsoft 365 Subscribers)
USB-C compatible Campfire Audio Axion with built-in...
Kickstarting your audiophile journey is much more than finding the...
Read more
Changjiang Art Museum in Taiyuan, China by Vector Architects | YellowtraceChangjiang Art Museum in Taiyuan, China by Vector Architects | Yellowtrace
Changjiang Art Museum in Taiyuan, China by...
  Vector Architects have completed the Changjiang Art Museum, located in...
Read more
moderne woning glazen schuifpuien binnenplaatsmoderne woning glazen schuifpuien binnenplaats
House of Cross: ingetogen architectuur met een...
House of Cross in Beijing is een eigentijdse herinterpretatie van...
Read more
Money in Excel: Automated Budgeting and Personal Finance Template (Free for Microsoft 365 Subscribers)Money in Excel: Automated Budgeting and Personal Finance Template (Free for Microsoft 365 Subscribers)
Interactive piggy bank concept helps kids save...
Parents worldwide face a common challenge: teaching young children about...
Read more
a profile view of a carved wooden poodle sculpturea profile view of a carved wooden poodle sculpture
Puppy Dog Eyes and Playful Paws: Misato...
All images © Misato Sano, shared with permission From pudgy pugs...
Read more