The end of Mint.com (and Mojito) is coming soon...

 Hi All,

I'm sure you have all heard by now that Intuit is shutting down Mint on January 1, 2024, and encouraging users to switch to Credit Karma (which is also owned by Intuit). Since Credit Karma almost certainly has different APIs (application programming interfaces) than Mint, this switch will effectively kill Mojito also. We had a good 10 year run with Mojito, but our luck has finally run out.

Personally, I haven't yet figured out what I'm going to do next to download and aggregate my financial data. I'm kind of hesitant to switch to Credit Karma because I'm fairly certain Intuit's business model will be to sell everything about me to their "partners" (just like they do with Mint) ... because free isn't really "free", right?

Under the hood, Credit Karma uses Plaid, which is a financial programming platform that provides APIs for accessing thousands of financial institutions. My initial thought was to use Plaid directly and copy, or customize, one of the existing solutions on GitHub to fetch my financial data: https://github.com/search?q=plaid+google+sheets&type=repositories. Unfortunately,  I discovered that I can't connect to my bank, credit card, or investment company using Plaid's Quickstart application, so that plan might not work out (or, at least, will take more time to sort out than I expected). However, you might have better luck. I highly recommend you check out that link. Maybe you'll find a solution that works for you!

IF I am able to come up with a solution that would be useful to others, I'll post a message here. Good luck to all of you. Thanks for being devoted Mojito users all these years!

-b3

Mojito is broken due to Mint UI overhaul

Hi All,

tl;dr
If you are wondering why Mojito no longer works, it's because of the new Mint user interface.

Details:
Around the beginning of 2022, Mint started automatically switching users over to a new user interface (UI). The new UI has a completely different programming interface (API) which effectively breaks Mojito. So any users that have the new Mint UI can no longer use Mojito to fetch and update their Mint data. My account was finally converted to the new UI a few weeks ago (I think I was one of the last?), so Mojito is broken for me, too.

My goal is to update Mojito so it will work with the new Mint UI, but I can't say with any confidence when that will be. My life and responsibilities are very different than they were when I originally created Mojito in 2013. Things are super busy for me right now. I'm sure many of you can relate to that overwhelming feeling where choosing to work on one thing means that something else is not getting done. That's my situation right now. Unfortunately, Mojito is not one of the projects where you can spend 15 minutes on it here and there. It requires several hours at a time, which is usually only possible late at night. And, I don't know about you, but I am already feeling pretty tired lately.

Again, I really do want to get Mojito working again, both for myself and for the handful of dedicated users out there. I just don't want to give you any false expectations about when that will happen.

Cheers,
-b3

Latest version of Chrome requires extra step to get Mint authentication info

Hi All,

It appears that Chrome moved the "Form Data" section to a separate tab within the DevTools / Network window. You now have to copy the data from the "Headers" tab (to get the cookies) and the "Payload" tab (to get the token).

Mojito Version 1.2.1 is available - fixes "UiApp has been deprecated" error

Hi All,

Around the end of January 2019, Mojito started displaying the following error when you tried to import transactions, import account data, or reconcile an account:

"UiApp has been deprecated. Please use HtmlService instead."

The reason for this error was that Google had ended support for the UiApp component, which Mojito was using to display several dialog windows. 

I have fixed this issue. Mojito now uses HtmlService (as the error message recommends). The new version is 1.2.1. As always, you can download a new copy, or you can upgrade your existing copy following the easy steps on the FAQ page.

-b3

Mojito 1.2.0 is now Available

Hi All,

Version 1.2.0 of Mojito is now available from the Download page. Changes in this version:

• A few UI improvements, like new buttons at the top of the TxnData, AccountData, and Reconcile sheets.
• Fixes to a few bugs.
• All of the source code for MojitoLib (the code that makes Mojito work) is now available on GitHub:  https://github.com/b3devs/MojitoLib
• For those who would like to modify the code to their liking, the development process is now easier (though still not "easy" exactly). Sparse instructions are provided on the GitHub page.

Because of the UI changes, you must download a new copy of Mojito to get this new version.

Cheers,

- b3

The Mojito Chrome plugin is not mine

Many of you probably already know this, but it has just come to my attention that there is a Chrome plugin called "Mojito" out there. It even has the same tag line: "mint with a kick"!? Go figure.

I haven't used this plugin, but from what I can tell it appears to be a "mint assistant" of sorts that modifies the mint.com web pages and adds new features.

The reason for this post is just to let you know that the Mojito Chrome plugin is in no way associated with the Mojito Google spreadsheet that I have created here. I do not know the developer of the plugin and have never communicated with him / her, so I cannot vouch for it in any way. Don't let that stop you from using it, though. :)

Cheers,
-b3

Mint change - get the authentication headers from "track.xevent" instead of "oauth2"

Hi All,

Just a quick post. Mint changed something and you can no longer get the required authentication headers by using the "oath2" request. You must now search for and copy all of the headers from the track.xevent request. (Also, fyi, I only see the track.xevent header when I view the "Overview" page on mint.com.)

I have updated the Mint Authentication Steps page with this new information (but I still need to updated the screenshot).

-b3

Minor update - version 1.1.6.2 - Mint made small change to authentication headers

Hi All,

Mint made a minor change to their http headers recently that broke Mojito.

I have updated Mojito to handle the change. The new version is 1.1.6.2. As always, you can download a new copy, or you can upgrade your existing copy following the easy steps on the FAQ page.

-b3

Mojito has been fixed - version 1.1.6.1 - mint.com changed to mint.intuit.com

Hi All,

If you haven't already noticed, Mojito stopped working because Mint changed the internet domain name from mint.com to mint.intuit.com.

I have updated Mojito to use the new domain name. The new version is 1.1.6.1. You can download a new copy, or you can upgrade your existing copy following the easy steps on the FAQ page.

Cheers,
-b3

Mojito Version 1.1.6 is available - Mint authentication is fixed, but somewhat painful

Hi All,

I have fixed the Mint authentication problem in Mojito. See the previous post for more details on the issue.

You must now connect Mojito to an active Mint session, which means you must log in to Mint in a separate window first, then copy the HTTP headers from the Mint page over to Mojito. I know this is not convenient, but this is the only solution I have gotten to work. If you are like me, you are desperate to get your account data from Mint so you can manage your finances better; and this somewhat cumbersome work-around is certainly better than having to scrap Mojito altogether. The details for the new authentication process are described on the Mint Authentication Steps page.

To upgrade your copy of Mojito, follow the easy steps on the FAQ page.

Cheers,

-b3

The bad news ... and then some good news (sort of)

Hi Mojito Users,

I have been working on the login problem for over a week now. The issue is that Mint changed their login process and now requires a second verification step when you login from a different computer or a new location. The verification is usually a code sent via email.

Other software programmers on the internet have figured out the underlying network requests that Mint requires. However, these individuals are running a script directly from their computers to download their accounts, etc., and Mint can't tell the difference between the script and a normal web browser running on their computer. Mojito is different. Mojito runs within Google Sheets directly from Google's servers, not from your home computer.

And that's the problem. No matter how I modify and tweak Mojito to send the new login requests to Mint, it always fails. Mint sees the network requests coming from Google's servers and rejects them. Logging into Mint directly from Mojito is simply no longer possible.

Having been a heavy Mojito user myself for over two years, I was desperate to find some way to get Mojito working again. I finally found one ... but it's not pretty. Some of you may decide that is just too "technical" and choose to stop using Mojito. I sincerely apologize if that is the case.

The work-around requires a few steps, which I will post once I have finished updating Mojito (hopefully in the next few days!). The gist is that you will have to log in to the Mint website directly, copy the Mint HTTP headers from Chrome's developer tools window, and paste the headers into Mojito (via a new Mint Authentication window). Like I said, it's not pretty ... but it works. The one nice thing about this change is that Mojito will not require re-authentication as long as you keep the Mint website active.

Stay tuned. I will post more detailed steps for the login work-around once Mojito is ready.

Thanks,
-b3

Recent Mint change has broken Mojito

Hi All,

It appears that Mint.com has made a change today (26-May-2016) that is causing Mojito to fail with the following error:

Unable to determine if Mint is ready. Error: <error><code>1</code><description>Session has expired.</description><name></name><type></type></error>

The cause of the problem is unknown at this point. Unfortunately, I am in the middle of a multi-week vacation, so my ability to debug and fix it is severely hampered. I'll see what I can do, but I can't make an promises as to when the issue will be fixed.

In the meantime, please use Mint.com directly. Sorry for the inconvenience.

-b3

Oops! Mojito 1.1.5.1 is Broken

Hi Mojito Users,

I was doing some maintenance to Mojito to address a change Google will be making to their "Apps Script" for Google Sheets. In the process of testing my changes, I accidentally deleted the version of MojitoLib (a code library) that Mojito 1.1.5.1 is using. It was as easy as clicking the mouse twice instead of once ... and it was gone, with no way to get it back (!!). Ugh ... thanks Google.

To remedy this mistake, I have released a new version of MojitoLib. However, you will either need to download a new copy of Mojito, or you can upgrade your copy of Mojito to version 1.1.5.2 (assuming you are using Mojito 1.1.5.1, which is the current version as of this writing).

To upgrade your copy of Mojito, follow the easy steps on the FAQ page.

I apologize for this accident and hope the inconvenience is minimal.

-b3

Mint login problem - Fixed

Several users have reported a Mint sync and login problem from Mojito. The initial login succeeds, but after a few seconds the login window appears again, repeating over and over.

I have been able to reproduce the problem but have not identified the root cause yet. I will continue to investigate as time allows (given the holidays and all).

Thanks,
-b3

Update (2014-12-21):

I have found the problem and am fixing it. Give me a day or so to update the Download page with the new version.

Unfortunately, the fix requires a small change in the login code, which I have always kept in the script attached to the spreadsheet (so you can see exactly what the code does); but each time I need to fix an issue in the login code, you (the users) are forced to download a new copy of Mojito. I think I'm going to finally move that code into the separate script library (MojitoLib)...

Update (2014-12-23):

I've posted release 1.1.5 with the Mint login fix. Thanks for your patience. The fix requires you to download a new copy of Mojito. Sorry about that ...

-b3

Mint taking a LONG time to retrieve data from financial institutions causing Mojito to time out

Hi All,

Starting a few days ago (around December 14, 2014), you may have noticed Mojito failing to sync data from Mint with this message: "Mint is taking too long to refresh your account data. Try again in a few minutes."

Here is what's happening. When you log in to your Mint account (either through their website or through Mojito), Mint goes and retrieves your latest transactions / data from your financial institutions (banks, lenders, investment companies, etc.). Mojito waits up to 60 seconds for Mint to complete this process before syncing your data (so it doesn't just fetch stale data that you probably already have). For me, Mint used to take between 30 to 50 seconds to refresh its data from financial institutions; but now it is taking almost 4 minutes. It seems that Mint's back end syncing process has become much slower for some reason. Unfortunately, there is nothing we can do to speed up Mint.

If you haven't figured it out already, the workaround is this:

In Mojito, start syncing your data. Go do something for a few minutes so Mint can finish its back end data refresh process. Then, come back to Mojito and start the sync again. The second time it should succeed.

In the meantime, I'll work on increasing the Mojito time out.

Update (2014-12-18):

I think this may have been a problem with my own accounts. I had a couple that needed "fixing" which was causing Mint to take a long time to refresh my financial data. However, let me know if you are regularly seeing the Mojito sync abort due to the 60 time out.

Mojito 1.1.4.1 is available -- Fix for bug in Reconcile Account feature

The bug mentioned in my previous blog post has now been fixed. If you are using Mojito 1.1.4, please upgrade your copy to version 1.1.4.1 now.

Do NOT use the Reconcile Account feature in version 1.1.4.

Thanks,
-b3

Heads up: Do NOT reconcile your accounts with Mojito 1.1.4 - Bug fix is coming

Hi All,

I just discovered a bug in Mojito 1.1.4 with the Reconcile Account feature. At the end of the reconcile process, Mojito adds a dummy transaction: "** Reconciled: <account name> **". This is so you can track each account statement you reconciled.

Mojito 1.1.4 has a bug that causes it to insert the dummy "Reconciled" transaction over and over again! You must close Mojito to stop it. Hopefully I am the only one who has encountered this bug. I now have a few thousand dummy transactions to delete ...

I will post a bug fix release as soon as I can.

Mojito 1.1.4 is now available

Version 1.1.4 adds a few new features. 

• There are new buttons on the About sheet so you can quickly click the operation you want to perform when you open Mojito.
• You can now make a copy of the Budget, Savings Goals, and In/Out sheets. This allows you to track your personal budget separate from your work budget, for example.
• When creating split items, you can now edit more than just the category. You can also edit the merchant and tags at the same time.

Note: These features required changes to the Mojito spreadsheet itself, not just the code behind the scenes. Because of this, there is no way to upgrade older versions of Mojoto to version 1.1.4. You must download a new copy of Mojito . Sorry for the inconvenience. If you don't care about the new features, then you can continue using version 1.1.3 without any problems.

Mojito 1.1.3 is now available

In version 1.1.3, I updated the Mojito code to no longer use Google's ScriptDb component, which is being discontinued soon (see previous blog post). I also fixed a couple of bugs with the account balance import.

You can download the new version from the download page; or, if you would like to update your existing copy of Mojito, follow the straight forward upgrade steps, as usual. But,there is one additional step. You must also update a script.

Here are the steps:
1. First, update your copy of Mojito to 1.1.3 by following the upgrade steps.
2. Then, go back into the script editor (Menu: Tools > Script editor ...)
3. Open the Functions.gs script by clicking it's tab on the left.
4. Replace the entire contents of that file with the contents of this one: Functions.gs_1.1.3
5. Save the file (Menu: File > Save)
6. Close the script editor window, then got back to the Mojito spreadsheet and select "Check for Mojito Updates" from the Mojito menu. This should complete the upgrade to 1.1.3.

If you downloaded Mojito in the past few days and saw a "ScriptDb" error ....

Hi All,

If you recently downloaded Mojito and saw a "ScriptDb" error after importing your Mint data, please download a new copy of Mojito. I have fixed the problem. It only affected recent downloads of Mojito. Existing users were not affected.

Some additional info:  Google is removing a component called ScriptDb on November 20th, 2014. Mojito currently uses this component, but I am in the process of removing that dependency from the Mojito code and hope to have a new version of Mojito available soon.

Thanks,
-b3