Forum Discussion
Problems With Money In Excel
Bruce_GilbertI have a similar problem with Money in Excel. The Plaid integration does not utilize two-factor authentication which I use with my bank logins.
Bruce_GilbertI have a similar problem with Money in Excel. The Plaid integration does not utilize two-factor authentication which I use with my bank logins.
- I wouldn't mind a prompt to put in a 2nd factor code. In fact, I like the idea of knowing when Plaid software is culling information from my accounts. But you can't sign up your institution in the first place because they don't support this type of Multi Factor Authentication. MFA.
Also, no one has ever responded to their other disappointing feature, "Categories" for spending. Besides rediculously broad categories for your spending like "Shopping" you are very limited in the number of custom categories you can create and you you also can't have sub-categories for spending like Insurance > sub category Auto >sub category Homeowners sub category Liability etc.I don't believe that you are limited in the number of categories and subcategories that you can create. The 'Categories' worksheet starts out with 100 formatted rows but if you happen to exceed that, you can just expand the table. The easiest way to do this is to go to the last, rightmost cell in the table and hover your mouse over the bottom right corner. Once your mouse pointer changes to the diagonal double arrow you can click and drag down to add rows. Note, you can't expand to the right which would add another column. The formulas wouldn't know what to do with that extra column and you will get an error saying that you can't resize a table that's adjacent to a hidden row or column.
Regarding your proposal for adding sub categories, I'm not sure what you mean. I was able to make sub categories exactly as you described.
I hope this helps.
- I keep getting a message that it can't save my category changes when I add subcategories? What can I do about that? do you have any tips for a newbie? I'm just starting to try and get this as my families budgeting/financial system.
Double underscore to what Bruce has said.
- If Plaid is not going to be able to support the dual-factor authentication that Fidelity (which is just one of the institutions they can't support currently), then MIE is not useful to me.
- Those budget categories, and the whole structure, are so poorly thought through. Not only should you be able to look at, say, Insurance collectively AND in sub-categories like Life, Auto, Health, Home... There's also real value in differentiating between high level expense categories like Fixed, Basic, and Discretionary.
Fortunately I'd recently developed my own income and expense tracking spreadsheet. What MIE offers that's nice (the foregoing limitation with Fidelity aside) is that automatic importing of data from one's financial institutions, but it ain't all that hard to go get the CSV or XLS files they now all provide, albeit in some pretty idiosyncratic forms.
I would love to see how you have formatted your income and expense spreadsheet for yourself and how your workflow works for downloading files from financial institutions. Is that possible?
