Release Notes


Version 1.2


1.2.1 (2019.02.09)

  • Google ended support for the UiApp component, which was used to display several dialog windows in Mojito. This caused the following error: "UiApp has been deprecated. Please use HtmlService instead."   This release fixes the issue. Mojito now uses the HtmlService component.

1.2.0 (2018.06.30)

  • A few UI improvements to the spreadsheet and several bug fixes. You must download a new copy of Mojito to use this version.
  • Changed the license from CDDL to the fully open MIT license.
  • The MojitoLib source code is now available on GitHub. https://github.com/b3devs/MojitoLib

Version 1.1


1.1.6.3 (2017.07.19)

  • Minor updates for user requests.

1.1.6.2  (2016.12.12)

  • Minor update to handle change in Mint authentication header ("Cookie" --> "cookie").

1.1.6.1  (2016.09.02)

  • Mint URL update. "mint.com" changed to "mint.intuit.com".

1.1.6  (2016.06.26)

  • Mint changed its login process, which broke Mojito. You must now connect Mojito with an active Mint session, then copy HTTP headers from the Mint page over to Mojito's "Mint Authentication" window. It's damned unfortunate that Mint made this change...

1.1.5.2  (2016.01.21)

  • Accidentally deleted MojitoLib library for version 1.1.5.1. So I had to create a new version to get it back.

1.1.5.1  (2015.03.27)

  • Small bug fix on Reconcile sheet. Formula for showing sum of txns marked with 'R' was broken (seems to be a bug with the New Google Sheets upgrade). Used a different formula to workaround it.
  • When you are finished reconciling an account, Mojito will now highlight the newly reconciled txns in light blue so you can see the changes that you are about to upload to Mint.

1.1.5  (2014.12.23)

  • Fixed bug causing Mint login to fail ... an untimely change by the folks at Mint.com, just in time for the holidays. Meh. More information is available here. This fix requires you to download a new copy of Mojito. Sorry about that.
  • The time that Mojito waits for Mint to refresh its data from your financial institutions is now a configurable setting on the Settings sheet. Default is 3 minutes.
  • (2015-03-15) Mojito was automatically upgraded to the New Google Sheets (thanks Google!).

1.1.4.3  (2014.12.06)

  • Fixed bug in Budget sheet where inserting or deleting a budget row then recalculating your budgets would display an error: "Error: Unexpected error. The 'Everything else' item should be the last row in the 'BudgetItemsRange' named range!"  This was caused by a data caching problem. The problem would automatically resolve itself by waiting 10 minutes for the cached data to expire. This release fixes the bug. Waiting is no longer required.

1.1.4.2  (2014.11.19)

  • Fixed bug in Savings Goals sheet where the Carry Forward Balance was not being included.
  • User requested feature. Mint password can be saved (entered manually on the Settings sheet) so things like scheduled reports can be run, etc. The password is mangled and hidden within internal storage, but it is not encrypted for true security. This reason for this is that encryption requires a key (a.k.a. password); so Mojito would need a second password to encrypt the Mint password. This second password could be hidden somewhere in the code, but that wouldn't be anymore secure than just hiding the Mint password itself. Note that a hacker would have to get the password to your Google account before he/she could starting hacking on your Mojito spreadsheet to get your Mint password.
  • Minor performance improvement that should speed up the last step of the Reconcile operation when all of the transactions are marked with an 'R'.

1.1.4.1  (2014.11.02)

  • Fixed bug with the Reconcile Account feature, where saving your reconciled transactions to Mint caused the reconcile tracking transaction "** Reconciled: <account name>**" to be added over and over (potentially thousands of times!). That problem has now been fixed.

    1.1.4  (2014.10.23)

    • Added several 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.
    • User requested feature. When you check or uncheck the "Replace existing data" checkbox on the import dialog boxes ("Import transactions" and "Import account balances"), you are asked whether you would like to use that choice as the default for future imports.

    1.1.3  (2014.09.11)

    • Updated the Mojito code to no longer use Google's ScriptDb component, which is being discontinued soon on 2014-11-20. Also fixed a couple of bugs with the account balance import. Note: Upgrading an existing copy of Mojito to version 1.1.3 requires an extra step. See the blog post for details.

    1.1.2.7  (2014.09.04)

    • Minor bug fix. If one of your account names contained only numbers (e.g. "123456789"), then you would get an error when updating your budgets, savings goals, etc: "TypeError: Cannot find function  toLowerCase in object 123456789". This has been fixed.

    1.1.2.6  (2014.09.03)

    • User requested feature. You can now specify which column on the TxnData sheet to use for the "Amount" (normally the "E" column). This is useful if you want to create a custom "Amount" column to make transaction amount adjustments, such as currency conversions. The Budget, In/Out, and Savings Goals sheets will use this column for their calculations.

    1.1.2.5  (2014.08.18)

    • Fixed bug introduced in 1.1.2.3 that prevented Mojito messages from appearing, such as new version announcements. 

    1.1.2.4  (2014.06.18)

    • Changed the order that data is imported when you select the "Sync all with Mint" menu item. Mojito now imports account data before importing transaction data. Reason: When Mint syncs data from financial institutions, it appears that Mint then spends a few seconds updating the merchant field to be more human readable. Since Mojito was importing transaction data immediately after Mint sync'ed with the financial institutions, the merchant field update process often hadn't completed yet, and the imported transactions would still be in their "raw" form (e.g. merchant names in ALL CAPS). Changing the import order to retrieve the account data first gives Mint some time to finish updating the merchant field. If you still see your transactions getting imported in "raw" form, you can simply select "Sync all" from the menu again.

    1.1.2.3  (2014.05.27)

    • A bug fix for the previous bug fix. :-) Fixed account import for first time users. 

    1.1.2.2  (2014.05.25)

    • Minor bug fix for the account balance import. if you had added a custom column to the AccountData sheet, you would get an import error if that column had values/formulas in cells beyond the end of account data. This has been fixed.

    1.1.2.1  (2014.04.20)

    • A small enhancement to the account balance import. For accounts that have no balance history available, Mojito will import the current day's balance instead.

    1.1.2  (2014.04.08)

    • Minor bug fix related to account balance import.
    • Also, for "Sync all", the transaction import is prevented if any edited transactions failed to save to Mint.

    1.1.1  (2014.04.04)

    • Bug fix release that addresses changes in Mint's web services. Mojito can now sync data to / from Mint as before.

    1.1.0  (2014.02.25)

    • Added the ability to import account balances within a specified date range, similar to how the transaction import works. This should fix the error that some users were getting when importing account balances in Mojito 1.0.0.1.
    • Added code to auto-upgrade your copy of Mojito after you point it to a new MojitoLib version. This should work for for minor releases. Major releases might be too complex.

      Version 1.0


      1.0.0.1  (2014.01.29)

      • Bug fix related to "Check for Mojito updates" feature. Unfortunately, if you downloaded 1.0.0, you will need to re-download a new copy of Mojito. Sorry about that.

      1.0.0  (2014.01.26)

      • Many major changes and new features in this release
      • Added ability to edit transactions and upload changes to Mint
      • Added download of categories and tags from Mint, happens automatically when transactions are imported
      • Added ability to clear (acknowledge) transactions
      • Added ability to create, edit, and remove split items
      • Added ability to reconcile an account with dummy transaction added to track reconcile history
      • Added Savings Goal sheet with support
      • Added Budget support for different frequency periods: monthly (M), weekly (W), quarterly (Q), yearly (Y), or any number of days
      • Added "Sync all" menu
      • Added periodic check for new Mojito updates


      Version 0.9.x


      0.9.1 Beta  (2013.08.18)

      • Bug fixes
      • Re-organized code; created MojitoLib library to make rolling out bug fixes easier

      0.9.0 Beta  (2013.07.26)

      First Release
      • Implemented Mint login
      • Added ability to download transactions from Mint and import them into TxnData sheet
      • Added ability to download account balances and import them into AccountData sheet
      • Added Budget sheet with support for monthly budgets amounts and ability to match based on multiple categories and tags over any date range; ability to exclude specific accounts, categories, and tags also supported.
      • Added In/Out sheet showing income/expenses over any date range, with ability to exclude specific accounts, categories, and tags
      • Came up with name "Mojito" and created graphic for About sheet
      • Added Help sheet with links to Mojito Tutorial and FAQ

      Subscribe to: Posts (Atom)