Money in Excel imports your live banking data into a spreadsheet

Microsoft has started rolling out “Money in Excel”, a one-stop dashboard in Microsoft Excel for viewing your daily finances, including your banking and credit card transactions.

Microsoft announced Money in Excel in April as part of a broader rollout of consumer attitudes toward Microsoft Teams, as well as renaming the overall Office 365 branding to Microsoft 365. Currently, Money Excel printing is being provided as Downloadable template for the Excel desktop app or for the online version of Excel, although you’ll need to sign up for a Microsoft 365 Personal or Family plan to use it. (ZDNet’s Mary Jo Foley found that that the template is currently active for download.) You will also be able to open the template in the Excel mobile app, but most of the live functionality will be missing.

Microsoft recommends that users store the Money spreadsheet in Excel in their OneDrive Personal Vault, which adds two-factor authentication if it’s not already enabled and a significantly reduced timeout applies.

Microsoft Excel Money Microsoft

Money in Microsoft Excel pulls data from your bank and other financial sources.

Money in Excel is Not Microsoft Money, although the two products certainly seem very similar. Microsoft has discontinued Microsoft Money provided by competing banks. “With banks, brokers and websites now offering more options for personal finance management, consumer demand for Microsoft Money Plus has changed,” the company said.

Money in Excel aggregates your accounts from different services: your credit card provider, your bank, as well as any investments and retirement accounts you might own. For example, that data is stored and tracked in Excel, using analytics to measure changes in your overall spend, or to track recurring expenses as Netflix moves from month to month. . (Money in Excel will also warn you if these changes, Microsoft said.)

Microsoft Excel Microsoft

Money in Excel also uses the dashboard to provide an overview of your spending.

Connections between financial institutions like your bank will be managed by Plaid, which indicates that it has created connections with 10,000 institutions across the United States. After granting Plaid permission to connect a financial account with Money in Excel, Plaid will have access to account balances, transaction history and related account information, such as name and address of owner. owns, but is not your proof of, your Microsoft 365 sign-in, according to Microsoft support documentation.

Money in Excel splits the worksheet into multiple tabs: the Welcome tab, the Tutorial tab, and then separates the tabs for an overview of the Snapshot, Categories, Individual Transactions, and Recurring Expenses.

money in excel 3 microsoft Microsoft

Money in Excel will track expenses periodically.

To add an account, you need to go to the Account tab and click Add an account. Transactions won’t automatically update the spreadsheet, though the template will constantly keep track of new additions, according to Microsoft. The “Update” button will appear if there are new transactions and clicking on it will update the spreadsheet.

Leave a Comment