PCMag editors select and review productsindependently. If you buy through affiliate links, we may earn commissions, which help support ourtesting.

Microsoft Launches Money in Excel for Easier Personal Finance

Excel can securely connect to your bank and automatically import all your transaction information into a dynamic, smart template, assuming you trust Microsoft to keep your banking details secure.

ByMatthew Humphries

My Experience

I've been working at PCMag since November 2016, covering all areas of technology and video game news. Before that I spent nearly 15 years working at Geek.com as a writer and editor. I also spent the first six years after leaving university as a professional game designer working with Disney, Games Workshop, 20th Century Fox, and Vivendi.

Read Full Bio
(Image: Microsoft)

微软试图麦e managing personal finance easier forExcelusers by launching a dynamic, smart template and add-in calledMoney in Excel(Opens in a new window).

The idea behind Money in Excel, as Microsoft explains, is to "simplify the task ofmanaging your finances." Allowing Excel to do this, however, requires a huge amount of trust on the part of the user as Excel offers to securely connect to your "bank, credit card, investment, and loan accounts" automatically to pull down all the transactions and account information.

The add-in is available toMicrosoft 365Personal or Family subscribers in the US who simply need to download the Money in Excel template, open it in Excel, and follow the instructions that appear. The connection to your financial accounts is handled via a third-party plugin provided byPlaid(Opens in a new window), a company focused on connecting bank accounts to software/apps. By using Plaid, Microsoft automatically gains support for most major US financial institutions.

Once imported, Excel can keep track of your spending habits, offers instant breakdowns of where your money is being spent across "groceries, household items, rent, and more," as well as alerting you when "subscription fees, changes in bank and overdraft charges" increase or a big purchase is made. Allowing Excel to access your most recent financial data is as simple as clicking the Update button once the initial link to your accounts has been established.

As you'd expect from Excel, a number of charts and tables are available to summarize your spending, but users can create their own as well as setup unique spending categories or copy transaction information into new spreadsheets. It sounds like a nice extra feature for existing Excel users, as long as they decide to trust Microsoft and Plaid with their financial account login credentials.

What's New Now<\/strong> to get our top stories delivered to your inbox every morning.","first_published_at":"2021-09-30T21:30:40.000000Z","published_at":"2022-08-31T18:35:24.000000Z","last_published_at":"2022-08-31T18:35:20.000000Z","created_at":null,"updated_at":"2022-08-31T18:35:24.000000Z"})" x-show="showEmailSignUp()" class="rounded bg-gray-lightest text-center md:px-32 md:py-8 p-4 mt-8 container-xs">

Get Our Best Stories!

Sign up forWhat's New Nowto get our top stories delivered to your inbox every morning.

This newsletter may contain advertising, deals, or affiliate links. Subscribing to a newsletter indicates your consent to ourTerms of UseandPrivacy Policy. You may unsubscribe from the newsletters at any time.


Thanks for signing up!

Your subscription has been confirmed. Keep an eye on your inbox!

Sign up for other newsletters

PCMag Stories You’ll Like

About Matthew Humphries

Senior Editor

I've been working at PCMag since November 2016, covering all areas of technology and video game news. Before that I spent nearly 15 years working at Geek.com as a writer and editor. I also spent the first six years after leaving university as a professional game designer working with Disney, Games Workshop, 20th Century Fox, and Vivendi.

I hold two degrees: a Bachelor's degree in Computer Science and a Master's degree in Games Development. My first book,Make Your Own Pixel Art, is available from all good book shops.

Read Matthew's full bio

Read the latest from Matthew Humphries

Baidu
map