06-16-2020 01:06 PM
06-16-2020 01:06 PM
I noticed off to the side on the Excel community board an invitation to download a new master template called "Money in Excel"
Downloaded it, got it running. Connected with one of my most active credit card accounts fine.
The product looks impressive. Much much better than the typical templates that are offered for budget and personal tracking of expenses, income (not that that's saying much).
But a couple of shortcomings, one of which is pretty major in my book.
So an appeal to Microsoft developers (or is it Plaid, the service through which you all make the connections to the financial institutions?): make Money in Excel useful by making it capable of handling dual factor authentication. I know it's possible (TurboTax manages)....
06-16-2020 01:52 PM
06-16-2020 02:15 PM
I don't mind. In fact, I'm glad you did it. I am curious about the connection between the MVP community and Money In Excel.
I had searched for a way to give the feedback directly (I really did think the Expense Categories" area was woefully deficient of creative thought on how such things could be organized for greater reporting utility. I have created my own, since the advent of Dynamic Arrays and their connection with Data Validation, categories and sub-categories that can grow when needed)....
Anyway, thank you!!
06-27-2020 06:37 AM - edited 06-27-2020 06:38 AM
Are you saying you have a work around to the Expense Category deficiencies in MIE?
That's one of my main problems. Let me know if you can help.
I had created my own budget and expense tracking spreadsheet, and in it I have categories and sub-categories. I take advantage of the newest version of Excel, with the Dynamic Array functions... notably UNIQUE, FILTER, SORT... I could make a copy of that sheet (it's on a tab of its own in my workbook). But I have no idea whether it would work with MIE. And I don't think it'd be all that easy to extend theirs. They just did a poor (as in short-sighted) job of coming up with that one aspect of what otherwise looks like a pretty useful app.
I do a lot of the same things they do; I just have to go download from my credit card and bank accounts rather than link directly through that service they use, but since my main account is with Fidelity and I have their dual-factor (Symantec) log-in, MIE is of no use to me anyway.