However, you can also create your own for more significant spending if you like. You can choose from a good selection of default categories that cover the most common types of spending. So if you would like to create more meaning and accuracy for your spending categories, click the arrow next to one and select another from the list. Even though categories are populated for all transactions, by default, they are “best guesses” and can include the “Uncategorized” category. Click an arrow in one of the column headers to sort or filter the column.Īll information on the “Transactions” tab is protected and thus non-editable except for the “Category” column. If you’re familiar with sorting and filtering in Microsoft Excel, the “Transactions” tab offers both of these for viewing specific transactions. So if you have more than one account connected, you can easily see what money came in and went out from where and when. You can also see the category, account, last digits of the account number, and the institution.

This tab consolidates transactions from all of your connected accounts in one spot. Just like a statement from your bank or credit card company, the “Transactions” tab lists the date, merchant, and amount for all incoming and outgoing money. You can see exactly how your money is spent at a glance and make sensible changes. You can see which merchants you most frequently paid, and then which merchants received the most money from you.Įach of these sections of the “Snapshot” tab serves a useful purpose. The two tables at the bottom show the merchants you’ve given your money to during the month. This also includes the previous month for a useful comparison. “Cumulative Spending Throughout the Month” is a helpful graph to see at which points of the month your spending increased. For example, you can quickly see if you spent more on entertainment than on groceries that month. “This Month’s Top Spending Categories” displays a pie chart showing where your money went in terms of category. Previous Month Spending” bar chart shows you the difference in your spending between the current month you selected at the top and the previous month. Then review the charts, graphs, and tables for a nice view of where your hard-earned cash goes. Start by selecting a month and year at the very top of the sheet. The “Snapshot” tab in the Money in Excel workbook is a great tool for a quick glance at your spending. Now that you’re signed in and have your latest transactions and details, it’s time to have a look! View the Snapshot Tab After a few moments, depending on your internet connection, your details should be refreshed and noted with the current date and time. You should then see your connected accounts in the “Money in Excel” pane. On the next screen in the pane, click “Sign In” and enter your Microsoft 365 username and password. If you don’t see the “Money in Excel” pane, go to the “Home” tab and click “Money in Excel” on the right side of the ribbon. So, open your Money in Excel file and click “Get Started” in the pane on the right. In addition, you’ll need to manually update it to receive your latest transactions and balances. So although you connect your accounts and save the file, you must sign in each time you open it. It doesn’t offer a direct internet connection that runs in the background. Microsoft Money in Excel consists of a template with an add-in. If you’ve already set up Money in Excel but haven’t spent much time with it yet, here’s how you can make the most of it. Please see their FAQ.īy connecting your bank, loan, and credit card accounts, you can budget your money easily using Money in Excel.

Important: As of June 30, 2023, Money in Excel will no longer be supported.

My money microsoft money