# Impact of "Money in Excel" feature on Tiller

**URL:** <https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356>\
**Category:** Microsoft Excel\
**Tags:** excel\
**Created:** [March 31, 2020, 1:23am UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356 "2020-03-31T01:23:53Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![mark.chien](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mark.chien/32/1267_2.png) [@mark.chien](https://community.tiller.com/u/mark.chien)\
**Post date:** [March 31, 2020, 1:23am UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/1 "2020-03-31T01:23:53Z")

</div>

Hi everyone,

I just got an email today about how Office 365 is being renamed to Microsoft 365 which comes with a new feature called “Money In Excel”… essentially an Excel plugin that auto connects to banks to download transaction data. Looks like instead of using Yodlee, they’re using a company called Plaid to do it. Can do a Google search for articles and you’ll see the announcements.

Looks eerily familiar to what Tiller has been doing. ☹

I know Tiller has been mainly focused on Google Sheets based solutions and Excel is still in beta. I personally would prefer Excel given the wealth of options the desktop client has and their web client generally has full parity.

Will this mean more urgency for Tiller to support Excel or another data point to further reduce investment?

Mark

---

<div class="post-metadata">

**Author:** ![Blake](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/blake/32/7052_2.png) [@Blake](https://community.tiller.com/u/Blake)\
**Post date:** [March 31, 2020, 4:38am UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/2 "2020-03-31T04:38:09Z")

</div>

Here is more information -

> **[Microsoft 365 brings work, life, and family together under one subscription](https://www.windowscentral.com/microsoft-365)**
>
> Microsoft has announced a new subscription aimed at consumers who are looking to keep their life organized between home, work, and family. The new subscription is largely a rebrand of Microsoft Office 365, but with several new benefits and features...

  

> **[What is Money in Excel?](https://support.office.com/en-gb/article/what-is-money-in-excel-0fb4710d-169e-45a7-ad60-ca98103d4e6a)**
>
> Money in Excel is a dynamic, smart template and add-in for Excel that can help you feel more in control of your money. It's the only template where you can securely connect your financial institutions to import and sync account and transaction...

  

> **[Money in Excel](https://templates.office.com/en-us/money-in-excel-tm77948210)**
>
> Seamlessly connect your financial accounts to Excel to view and manage all your finances in one place. Understand how you’re spending your money and receive personalized insights about your monthly spending so that you can achieve your financial...

  

> **[Microsoft Excel will soon let you analyze your money and spending - MSPoweruser](https://mspoweruser.com/microsoft-excel-money-in-excel/)**
>
> Microsoft today has announced a number of new features for Office 365 subscribers — one of them being Excel Money. Excel Money is a new feature that makes it easier for you to manage, track, and analyze your money and spending. All you have to do is...

1. Launches 04-21-20.
2. Cost is $6.99 or $9.99 per month.
3. Money in Excel is a Microsoft 365 exclusive feature with no free tier available. So if you want to take advantage of this, you’ll have to subscribe.
4. See the Money in Excel video half way down the page in the first link. It shows four tabs; Welcome, Snapshot, Categories, and Transactions.
5. The explanation says “It will automatically categorize spending habits into different groups so that you can easily see where your money is going every month.” Based on my experience with Copilot (which also uses Plaid), the transactions are indeed automatically categorized by Plaid.
6. Another example of anybody who wants to be somebody is getting into data aggregation.
7. Includes many templates to chose from to personalize your file.

Cheers,

Blake

---

<div class="post-metadata">

**Author:** ![peter](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/peter/32/27_2.png) [@peter](https://community.tiller.com/u/peter)\
**Post date:** [April 2, 2020, 4:12am UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/3 "2020-04-02T04:12:34Z")

</div>

Mark, thanks for the post.

This is a huge validation for the uninitiated that spreadsheets are an amazing way to manage money. Not a fringe solution, but with Microsoft’s endorsement it’s a very mainstream solution. (Of course you already knew spreadsheets were great - but many people still don’t.)

As you know, we offer Google Sheets (our longstanding solution) and Excel (in beta). We are getting great feedback on Excel. Our product focus this spring is improving our core feeds across Google Sheets and Excel, especially with banks that are using MFA. We just released our new Account Summary, and more is in the works. As that work completes, we’ll review feedback on the Excel beta, assess next steps with Excel, and share more about our plans.

I smile because my job working on Microsoft Money in 1994 was the seed crystal that started Tiller Money. By 2015 or so, I was wondering… “why hasn’t the state of the art for personal finance evolved much since Microsoft Money circa 1994?” With that we created Tiller Money. So, welcome back Microsoft!

Our team is fired up with the founding mission that got us here. We want to empower people with great personal finance solution in their spreadsheets, great templates, a dynamic community (you are a big part of that), and a business that promotes the privacy and security of our customers’ data. All of this is in service to giving our customers more control over their money, their lives, and their futures.

---

<div class="post-metadata">

**Author:** ![mark.chien](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mark.chien/32/1267_2.png) [@mark.chien](https://community.tiller.com/u/mark.chien)\
**Post date:** [April 4, 2020, 11:40pm UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/4 "2020-04-04T23:40:58Z")

</div>

Thank for the post Peter. I do worry that when a big company like MS steps in, there’s risk to the smaller startup. So knowing what are the key differentiators of Tiller would be great since just being a spreadsheet is no longer sufficient.

One area of differentiation that I can foresee is around privacy and security. I suspect that MS and Plaid like this solution because now they are one step closer to getting insight into their user’s financial data. This was the main reason why I stopped using Mint/Quicken because I just didn’t feel comfortable with them associating my user account with financial data.

I’m more comfortable with Tiller’s approach but think there’s value to further explain the security/privacy provisions you have in place. Or if there isn’t as much now, good opportunity to invest there. This is one of the benefits of old school MS Money (I loved that software). It was desktop software so you had assurance the data wasn’t in the cloud.

Mark

---

<div class="post-metadata">

**Author:** ![peter](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/peter/32/27_2.png) [@peter](https://community.tiller.com/u/peter)\
**Post date:** [April 14, 2020, 5:50pm UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/5 "2020-04-14T17:50:35Z")

</div>

Privacy is a core value for Tiller Money, and we’re unique among fintech services in that the humans at Tiller Money don’t have access to our customers transactions and balances. We will be talking more about this in 2020.

Beyond feeds in a spreadsheet, we want to be a home for anyone who wants to meaningfully engage in their finances while leveraging the power and flexibility of a spreadsheet. For us, this means continuing to invest in our community, Tiller Money Labs, great support, webinars, AutoCat, and our daily email. We are also improving the performance of the 21,000 financial sources we support today.

We’re excited about what’s ahead this year. We’ve never taken our position for granted, and we’re continuing to move fast to build on what’s working and add value to our customers.

---

<div class="post-metadata">

**Author:** ![DavidS](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/davids/32/3241_2.png) [@DavidS](https://community.tiller.com/u/DavidS)\
**Post date:** [April 24, 2020, 2:24pm UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/6 "2020-04-24T14:24:26Z")

</div>

I’m looking forward to trying MS’s offering but I’m not terribly optimistic based on my experience with Plaid. Of the 30 or so accounts I track with Tiller only 1 is not currently supported. With Plaid based services, there are about 10 accounts that either aren’t supported at all, or don’t reliably connect. Based on that I don’t think Tiller has too much to worry about at the moment.

---

<div class="post-metadata">

**Author:** ![ronnieK](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/ronniek/32/3354_2.png) [@ronnieK](https://community.tiller.com/u/ronnieK)\
**Post date:** [June 18, 2020, 5:59pm UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/7 "2020-06-18T17:59:30Z")

</div>

So i have been using the Tiller Excel addin. Today i downloaded the Money in Excel template to see how it compares. I have built out my Tiller Excel Spreadsheet using VBA so that it will autocat, breakdown my mortgage payment from a mortgage schedule. I have it working. I have found the data feed from Tiller to be reliable (in contrast with Quicken which was getting quite bad). I added accounts to the Money in Excel to see how it would work. I have Bank of America and Merrill Lynch which are owned by BofA. Well it downloaded the BofA data but so far has failed at downloading the Merrill data. It also had the Merrill Accounts under BofA which i suspect might have caused the downloading problem. So immediately i am encountering downloading problems. We will see where this goes. It also seems that Tiller kept their transactions and category sheets more customizable at first blush. I have to play around with that more. With Tiller I could make the transactions sheet a table and filter it easily which is really useful. Final judgement at this point, is that Tiller offers more flexibility. I wish Tiller had more template addons for Excel to work with.

---

<div class="post-metadata">

**Author:** ![nellsworth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/nellsworth/32/1122_2.png) [@nellsworth](https://community.tiller.com/u/nellsworth)\
**Post date:** [May 14, 2021, 9:47pm UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/8 "2021-05-14T21:47:09Z")

</div>

Hi @ronnieK, I know this is an old thread. But I just noticed you said you “have built out my Tiller Excel Spreadsheet using VBA so that it will autocat.” This sounds very intriguing. Would you be willing to share your VBA code with us? I would like to get auto categories working in Excel somehow, as it seems TillerHQ hasn’t made any movement towards adding this feature, and I am trying to minimize my use of Google in general. Thanks!

---

<div class="post-metadata">

**Author:** ![ronnieK](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/ronniek/32/3354_2.png) [@ronnieK](https://community.tiller.com/u/ronnieK)\
**Post date:** [June 11, 2021, 1:55pm UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/9 "2021-06-11T13:55:45Z")

</div>

Sorry, i have not been here in awhile. I will work on figuring out how i can make my Excel spreadsheet a template and not compromise my personal account information. Then i would be happy to share my sheets. They are certainly not perfect and i had to learn VBA syntax and environment to get this done. (I knew other programming languages.)

---

<div class="post-metadata">

**Author:** ![ronnieK](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/ronniek/32/3354_2.png) [@ronnieK](https://community.tiller.com/u/ronnieK)\
**Post date:** [June 11, 2021, 1:58pm UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/10 "2021-06-11T13:58:16Z")

</div>

Money in Excel is worthless if you have accounts at a brokerage that you use. It only works with banks. If all you have are bank accounts and credit cards, i suppose it will work for you. You will have to wait till MSFT updates Money in Excel to handle Investment accounts. It has been months now since release and they still have to addressed this. For example, all of my banking goes through a Cash Management Account at Merrill so Money in Excel will not pick up my spending.

---

<div class="post-metadata">

**Author:** ![nellsworth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/nellsworth/32/1122_2.png) [@nellsworth](https://community.tiller.com/u/nellsworth)\
**Post date:** [June 11, 2021, 8:19pm UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/11 "2021-06-11T20:19:43Z")

</div>

Thanks for being willing to share. I agree about VBA. It would be nice if there was a way to use Jinja templates or Python instead for building this autocat lookalike.

---

<div class="post-metadata">

**Author:** ![seffy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/seffy/32/11585_2.png) [@seffy](https://community.tiller.com/u/seffy)\
**Post date:** [January 9, 2023, 9:02pm UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/12 "2023-01-09T21:02:56Z")

</div>

"Effective June 30th 2023 Money in Excel will no longer be supported.’ They’re getting rid of this. They’re partnered with Tiller on a 60 day trial which is helpful, unless like me your bank doesn’t work with Yodlee (which Tiller uses for data) but does work with Plaid (which Money in Excel uses)

☹

---

<div class="post-metadata">

**Author:** ![jemmoa7](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jemmoa7/32/9022_2.png) [@jemmoa7](https://community.tiller.com/u/jemmoa7)\
**Post date:** [January 10, 2023, 2:33am UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/13 "2023-01-10T02:33:37Z")

</div>

I have been wanting Tiller to use both Yodlee and Plaid for a long time. Each one has outages for banks at different times, so If one of them had a long-term (many, many, weeks) you could possibly switch to the other one. I always wanted to try Money In Excel, but they only offered it to the USA, not Canada. I guess that’s OK, since they canceled it entirely.

---

<div class="post-metadata">

**Author:** ![richl](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/richl/32/888_2.png) [@richl](https://community.tiller.com/u/richl)\
**Post date:** [January 10, 2023, 2:58am UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/14 "2023-01-10T02:58:19Z")

</div>

Same. Here. I have brought this up several times

---

<div class="post-metadata">

**Author:** ![jemmoa7](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jemmoa7/32/9022_2.png) [@jemmoa7](https://community.tiller.com/u/jemmoa7)\
**Post date:** [January 12, 2023, 8:21pm UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/15 "2023-01-12T20:21:10Z")

</div>

Also, MX is a good integrator too.

---

<div class="post-metadata">

**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\
**Post date:** [January 12, 2023, 9:43pm UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/16 "2023-01-12T21:43:26Z")

</div>

We hope to offer multiple aggregators in the future, and something we’re considering for this year, but it’s not a small lift!!

---

<div class="post-metadata">

**Author:** ![seffy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/seffy/32/11585_2.png) [@seffy](https://community.tiller.com/u/seffy)\
**Post date:** [February 6, 2023, 5:41pm UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/17 "2023-02-06T17:41:42Z")

</div>

I am hopeful you and the team can do this! I had to cancel my sub as it’s been unable to sync my Bank feed for several months. Trying out competitors budgeting software that uses Plaid - sure the backend works but the software itself feels like working with one hand tied behind my back, and a boxing glove on the other hand ☹

I look forward to the day I can resub for a stable bank feed!

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [February 7, 2023, 12:50am UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/18 "2023-02-07T00:50:05Z")

</div>

Sorry to hear you’re trying other tools, @seffy. We are constantly improving our bank feeds and Yodlee is always addressing outages of supported institutions. The “multiple aggregator” solution is on the roadmap but a ways out.

---

<div class="post-metadata">

**Author:** ![richl](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/richl/32/888_2.png) [@richl](https://community.tiller.com/u/richl)\
**Post date:** [February 7, 2023, 2:13am UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/19 "2023-02-07T02:13:36Z")

</div>

@seffy , I agree that it sucks that Tiller did not work for you. Take a look at Monarch. Not a spreadsheet tool, but still pretty cool and really pretty. And uses Plaid.

---

<div class="post-metadata">

**Author:** ![seffy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/seffy/32/11585_2.png) [@seffy](https://community.tiller.com/u/seffy)\
**Post date:** [February 8, 2023, 8:45am UTC](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356/20 "2023-02-08T08:45:30Z")

</div>

@randy Unfortunately It’s been a recurring theme with my particular bank, I can’t recall a time it’s worked consistently for more than a couple of months in all the time I’ve been using Tiller(for 6 years!).

I did try manually importing, but the guide I followed to setup the import was not as straightforward as it appeared, and I couldn’t get the formulas to format the dates working. A more robust manual import would honestly be enough to keep me around as a fallback.

@richl I took a look at Monarch on your recommendation. Unfortunately my bank doesn’t show up on their list of institutions.

[Next page](https://community.tiller.com/t/impact-of-money-in-excel-feature-on-tiller/3356.md?page=2)
