Get started with Money in Excel

Money in Excel is a dynamic template where you can securely connect your financial institutions to import and sync your account and transaction information. Track all your finances in one place, customize your workbook, and receive personalized tips without leaving Excel.

Note: Money in Excel is a premium template available as part of your Microsoft 365 Personal or Family subscription. For the best experience, use the latest versions of Windows or macOS, and Edge, Chrome or Safari browsers. 

How to get Money in Excel

  1. You can download or open the Money in Excel template from the following locations if you’re logged in with your Microsoft 365 Personal or Family subscription.

    • In the Excel desktop app, go to File > New > select Money in Excel > Create.

    • In Excel for the web, go to excel.office.com and select Money in Excel from under New.

    • Go to Money in Excel on Templates.office.com and select Download to use in the Excel desktop app or Edit in Browser to use in Excel for the web.

    Select the Money in Excel template under File > New.

  2. To make sure your Money in Excel workbook saves automatically, and for an added layer of security, please save the file in your OneDrive Personal Vault. OneDrive Personal Vault features identity verification options such as facial recognition, and automatically locks after a short period of inactivity.

  3. Once you open the Money in Excel template, the Money in Excel pane will open on the right.

    Select Trust this add-in in the Money in Excel pane.

    Select Trust this add-in

  4. In the Money in Excel pane, select Get started.

    Then select Sign in and follow prompts to sign in with your Microsoft account and grant permissions. Your privacy, security, and peace of mind are important to us. That’s why you're asked to sign in again, so we can verify that it's you.

    Select Sign in to sign in with your Microsoft 365 Family or Personal subscription.

Set up financial accounts in Money in Excel

Now it’s time to add your financial accounts. You can add multiple financial institutions.

Tips: If you accidentally closed the Money in Excel pane and don't see the Money in Excel icon in the ribbon, you can open the pane again from My Add-ins. Once you've completed set up, you'll always see the Money in Excel icon in the ribbon.

  • In the Excel app, go to Insert > My Add-ins > select Money in Excel.

  • In Excel for the web, go to Insert > Add-ins >My Add-ins > select Money in Excel

  1. Once signed in with your Microsoft 365 subscription, Money in Excel will ask you to link your financial accounts. Select  Next. Review privacy information and select  Continue.

  2. Now it's time to add a financial institution. You can always add more later.

    Select a financial institution to link to Money in Excel.

    Select your financial institution from the list.

  3. Enter the login credentials that you use for that financial institution and select Submit.

    Microsoft will not have access to your login credentials. If your financial institution requires two-factor authentication, you may be asked to choose whether to verify with a Text, Phone, or Email. When you receive your verification code, enter it and select Submit.

    Enter your login credentials for this financial institution.

  4. Select the accounts you want to link. Money in Excel is most helpful when you add all your financial accounts. Select Continue.

    Note: Your data may take a few moments to load. When loading is complete you will see your recent transactions in your worksheet and an overview of your accounts in the Money in Excel pane.

    Select the account or accounts you want to add.

  5. If you have other financial institutions to add, such as investment, loan, credit card, or bank accounts, select Add more accounts in the Accounts tab.

The Money in Excel pane needs to be open in order to update transactions in your workbook, capture changes you make to your spreadsheets, and provide you access to Money in Excel’s features.

Check out the next section to see how you can get the most out of your Money in Excel workbook.

The Money in Excel pane

Make Money in Excel work for you

Select an expander below for detailed steps on how to optimize Money in Excel.

The Transactions sheet in Money in Excel.

  • Transactions imported into the spreadsheet are from financial accounts you have connected. Money in Excel will add new transactions here when you update your workbook.

  • All transactions have been categorized for you, but you can change the category by selecting the dropdown.

    Select a category to change it.

  • You may add custom categories in the Categories sheet. Expand the Organize your spending categories section below to learn how.

  • You may edit Merchant names by selecting cells and entering a new name.

  • The rest of the Transactions sheet is locked to ensure that your workbook functions correctly. Do not delete your Transactions sheet as it will cause an error for the rest of your spreadsheets.

Money in Excel categorizes your spending for you, but it may not always be right. It’s important that you assign your transactions to categories that make sense for you. This will ensure that the rest of your Money in Excel workbook is as accurate and helpful as possible. We'll show you below how to add new categories.

Add a custom category

In the Categories sheet of Money in Excel, you'll see a list of Default Categories. These can't be changed or deleted. If you want to create your own categories, you can do so in the Custom Categories section of this spreadsheet.

  1. In Money in Excel, go to the Categories spreadsheet.

  2. In the Custom Categories area (starting at D25), enter a name for your category and press Enter.

  3. In the next column, select whether this category should be considered Income, Transfer, or Expense.

  4. Now you can apply this category to your transactions. See below to learn how to use text filters to quickly set categories for multiple transactions.

Note: If you edit or delete a custom category, it will not apply to transactions you have already assigned to that custom category. You will need to re-categorize those transactions in your Transactions sheet if you wish to update them.

The Categories sheet for Money in Excel.

In this example, we've created a new category for "Pet Care" and set it as an Expense.

Use filters to organize and set categories

In the Transactions sheet of Money in Excel, you'll see all the transactions from all the accounts you've added. Follow these instructions to learn how to use a Text Filter to find transactions for a specific merchant and then apply a custom category. For detailed help on sort and filter, see Sort data in a table and Filter data in a range or table.

  1. In Money in Excel, go to the Transactions spreadsheet and select the down arrow for the column you want to filter by. We'll filter by Merchant for this example.

  2. You can filter in multiple ways:

    • From the down arrow to the right of Merchant, you'll get a list of everything in that column. Deselect items in the list to hide them from your view. If the list is very long, you'll want to use Text Filters instead.

    • Select Text Filters > choose how you want to filter > enter the text you want to filter with.

  3. Now that your transactions have been filtered, it's time to apply the new category. Select the category of the first transaction > select the arrow that appears > select the new category that you created.

    Tip: You can easily select the + that displays in the corner of the cell and drag a cell to copy the new category to all of the filtered results.

  4. When you're done, you can select Sort & Filter in the ribbon > Clear to remove all the filters.

Continuing with our example, we want to categorize all transactions from Muddy Paws as Pet Care.

Select the down arrow next to Merchant > Text Filters > Equals.

Enter Muddy Paws to filter to transactions that include "Muddy Paws".

We selected the Sort & Filter icon next to Merchant > Text Filters > Equals > entered "Muddy Paws" as the text. Then we changed the category to "Pet Care" for all of transactions from Muddy Paws.

Pet Care set as the category.

You'll use similar steps to these to sort or filter in other columns. For example, you might want to sort your transactions to see your highest spending. In this case, you would select the icon next to Amount $ and then select Sort Ascending.

Go to the Snapshot sheet to learn more about your monthly spending trends. Your snapshot includes customized charts and graphs to help you understand your month-over-month spending, top spending by category, and more. You may also add your own charts by leveraging Excel’s rich features.

The Snapshot sheet in Money in Excel.

You can add new Templates to get more value out of your Money in Excel experience.

  1. In the Money in Excel pane, select Templates.

  2. Select the template you want to add and read through the descriptions and instructions.

  3. Select Add to workbook when you're ready.

Continue to check this tab for more template options coming soon!

The Templates tab in Money in Excel.

Need help with Money in Excel?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×