Track Your Spending with Microsoft's New 'Money' Template for Excel (2024)

David Murphy

Track Your Spending with Microsoft's New 'Money' Template for Excel (1)

Credit: David Murphy - Microsoft

If you’re tired of using third-party services to track your spending—either because they aren’t as useful as you thought they would be or you’re concerned about giving third-party services access to your bank account and credit cards—you can now connect your various financial accounts directly to Microsoft Excel. All you need is Microsoft’s new “Money” template.

However, there are quite a few caveats that make Microsoft’s setup potentially less practical than services like Mint or YNAB. For starters, you have to pay Microsoft to use it. That shouldn’t be a huge deal if you’re already using YNAB, but users of free finance services like Mint might not be thrilled at the idea.

The “Money in Excel” feature comes in the form of a premium template you can download only if you’re a Microsoft 365 Family or Personal subscriber; those on Microsoft 365 Enterprise accounts can’t partake. Microsoft’s cheapest subscription plan, 365 Personal, will set you back $7/mo or $70/year, which isn’t that bad given what you get (access to all the Microsoft office apps), but is still more expensive than free. And the idea ofpaying money to manage my money always strikes me as strange, but that’s just me.

If you’re a Microsoft 365 subscriber, visit the website for Microsoft’s “Money in Excel” premium template. There, you’ll find two options: Edit in Browser, which launches the web-based version of Excel, and Download, which you can use within your desktop or laptop’s Excel app.

Once you launch the template, you’ll get a crude-looking landing page that explains the general point of the finance-tracking spreadsheet, with a series of tabs at the bottom you’ll want to click through sequentially.

Track Your Spending with Microsoft's New 'Money' Template for Excel (3)

Credit: David Murphy

Before you begin, make sure you click that ”Enable Editing” link at the top, which will reveal your regular Excel setup—as well as a “Do you trust this add-in?” prompt on your sidebar. Provided you downloaded your file from Microsoft directly, click the option to trust the add-in.

Track Your Spending with Microsoft's New 'Money' Template for Excel (4)

Credit: David Murphy

You’ll then be asked to sign in with your Microsoft 365 account (again), thus ensuring that you can’t use this spreadsheet/add-in even if a friend sent it to you, because that’s how Microsoft rolls. You’ll next need to connect your financial accounts to Excel—helped along by Plaid.

Naturally, my import didn’t work at all. Thanks, Capital One. (When I mentioned this to Lifehacker finance queen Lisa Rowan, she noted this issue can happen with a number of different third-party finance services. Double thanks, Capital One. Get it together.)

I had better luck with my credit card accounts, however, and was able to import the information for multiple cards via my provider. All of my transactions then showed up in my spreadsheet, like so:

Track Your Spending with Microsoft's New 'Money' Template for Excel (6)

Credit: David Murphy

I was a bit bummed to see that spreadsheet’s “Snapshot” tab wasn’t working for some reason—apparently it was having trouble pulling in the months of my transactions, as the drop-down menu didn’t have any to pick from. I assume this spreadsheet is incredibly useful for an at-a-glance look at your spending habits; I really wish it worked, so I could confirm that my daily Jamba Juice habit is, in fact, a financial risk. I hope you have better luck.

Track Your Spending with Microsoft's New 'Money' Template for Excel (7)

My monthly snapshot for financesCredit: David Murphy

Track Your Spending with Microsoft's New 'Money' Template for Excel (8)

Microsoft’s monthly snapshot for financesCredit: Microsoft

Microsoft also lets you add two extra templates to your spreadsheet if you want more information about your spending habits. You can quickly calculate your entire net worth across all of your accounts—useful if you’ve connected everything to Excel—and you can scan through your spending to flag recurring purchases in case your subscriptions are getting out of control.

How to Set Up a 50/20/30 BudgetRead More

While you can connect accounts to Excel that aren’t directly related to your spending, such as your 401k, there’s not much Excel can do with that data. You’ll see your account balance pop up on the sidebar, but none of the spreadsheet make use of this information. That’s a bit different than other financial-tracking services you might have used, which may give you more performance metrics about your finances regardless of type.

I have noticed a few people complaining that they can’t connect multiple accounts from the same provider—your account and your spouse’s account, for example—via Excel’s setup. I wasn’t able to test this myself, as none of my friends would loan me their bank account information for the day (sigh), but it’s something worth consideringbefore you move your financial tracking over to Excel.

Otherwise, if you’re already a Microsoft 365 subscriber, there’s no reason to not test out Microsoft’s Money setup for Excel. It’s not perfect—far from it—but I have always enjoyed the clutter-free experience of a spreadsheet versus a web app. If your financial-tracking needs aren’t great, it might be all you need (plus a pivot table or two) to get better control of your spending and budgeting.

Oh, yes, that; you’ll have to build budgets yourself in Excel’s spreadsheet, as the Money add-in strangely doesn’t include any budget-creating tools whatsoever. That seems like a pretty egregious omission to me, given that those who track their finances would probably also like some way to ensure that their spending matches up with what they planned to spend in a given month.

A budget shouldn’t be hard to set up manually (if your Snapshot tab works), but if you’re not Excel-inclined, it might feel overwhelming. I’m sure Microsoft will add the feature as it rounds out Money with new features, but it’s not there yet—and that’s kind of how I feel about the Money template in general. It’s helpful, but it’s not quite good enough to handle much analysis and tracking beyond the basics.

Track Your Spending with Microsoft's New 'Money' Template for Excel (2024)

FAQs

How do you create an Excel spreadsheet to track spending? ›

To enter your expenses in your Excel budgeting template, go to the "Expenses" sheet. Here, you'll see a table with categories such as "Rent/Mortgage," "Utilities," "Food," and so on. Again, just enter the appropriate amount for each category and add new expenses as needed.

Does Microsoft Excel have a budget template? ›

Creating a budgeting plan for your household can feel overwhelming and hard, but Excel can help you get organized and on track with a variety of free and premium budgeting templates.

What is the formula for tracking spending in Excel? ›

You would first create a list of all your income and expenses for the month in two separate columns. Then, you would use the SUM function to add up all the income and expense amounts in their respective columns. Finally, you would divide your total income by the number of days in your period to get your daily budget.

Does Excel have an expense template? ›

Microsoft Excel has lots of free, customizable budget templates available to pick from, so you're certain to find one that works for you. Let's open the Excel expense template that I got from the Microsoft Create and dive into a few ways to customize it for my small business.

How to create an expense tracker? ›

Create your summary tab

With your expenses input, you can begin to summarize them on one tab. Try using formulas like =SUMIFS() to sum all expenses in a given category over a given timeframe. From there you can create graphics to easily visualize where your money is being spent.

Is Microsoft Excel free? ›

Microsoft 365 for the web is a free version of Microsoft 365 that you can use in a web browser. All you need is to sign up for a Microsoft account with a new or existing email address. Use Word, Excel, PowerPoint and more for free on the web.

Top Articles
Latest Posts
Article information

Author: Horacio Brakus JD

Last Updated:

Views: 6044

Rating: 4 / 5 (71 voted)

Reviews: 86% of readers found this page helpful

Author information

Name: Horacio Brakus JD

Birthday: 1999-08-21

Address: Apt. 524 43384 Minnie Prairie, South Edda, MA 62804

Phone: +5931039998219

Job: Sales Strategist

Hobby: Sculling, Kitesurfing, Orienteering, Painting, Computer programming, Creative writing, Scuba diving

Introduction: My name is Horacio Brakus JD, I am a lively, splendid, jolly, vivacious, vast, cheerful, agreeable person who loves writing and wants to share my knowledge and understanding with you.