Prototype: PrathanChorruangsak, Getty Images/iStockphoto

On June 15, 2020, Arjun Tomar, product marketing manager for Microsoft 365, appear the availability of a new costless template called Money in Excel. This new template will help users track their personal finances by electronically connecting their fiscal accounts (checking, investments, money markets, etc.) directly to Microsoft Excel.

For those of us old enough to be active PC users in the 1990s, the time-saving concepts suggested by Money in Excel are familiar. Microsoft Coin (1991-2009) had the aforementioned functionality and was relied on by many people until the application was unceremoniously discontinued in 2009.

Getting a functional and complimentary personal financial planning awarding sounds similar a keen idea. Unfortunately, Money in Excel availability is express to specific Microsoft 365 subscriptions. This article describes how Money in Excel works, who is eligible, and how to become it.

Encounter: Microsoft Build 2020 Highlights (TechRepublic Premium)

Money in Excel for Microsoft 365

Before you can utilise Money in Excel, you must get-go constitute online accounts with your banks, payment services, and financial institutions. Essentially, Money in Excel will electronically login to your accounts, download the appropriate transaction history, then load that transaction history into the Excel template. This process tin be done manually now, simply Money in Excel will automate those steps.

Once loaded into the template, users can cheque transactions, reconcile bank accounts, graph expenses, and create other activeness reports. In theory, Money in Excel will simplify personal fiscal organization, planning, and reporting. The template is customizable, and then you tin modify it to adjust your particular needs.

Microsoft uses Plaid as a data-retrieval partner. Plaid is a third-political party fintech vendor specializing in secure data retrieval from financial institutions. Microsoft stores your data using Azure cloud services, while Plaid also retains a copy of your information as part of its services.

While both companies emphasize encryption and privacy, it is of import to realize that you are sharing some sensitive personal information with both companies when yous apply Money in Excel. If you would like to review Plaid's security policies, check out its website.

Example Monthly Snapshot


Paradigm: Microsoft Corp.

Who is eligible, and how practise y'all get Money in Excel?

Money in Excel is only available to Microsoft 365 Personal and Family subscribers in the United States. Microsoft does not explicate why the availability is then limited, but there are probable regulatory complications with financial institutions and users operating and living outside the US.

There is also no ready explanation of why Money in Excel is not available to business subscribers of Microsoft 365. It is possible that Microsoft has plans for a business organization version of Money in Excel. Or perchance even another more avant-garde application specifically designed for businesses is in the works. Only fourth dimension will tell.

If you lot have an eligible Microsoft 365 Personal and Family unit subscription, you lot tin can download the gratuitous Money in Excel template from the Microsoft website. However, a word of warning: The quick cancellation of Microsoft Money services in 2009 left many individuals in a bind, leaving them to scramble for culling solutions. Dependency on automated systems for personal financial planning can exist efficient and about addictive, but it does have some major drawbacks.