Posts Tagged ofx downloads

Windows 8 (64-bit version) compatibility with Sunset Money

[UPDATED 12/12/2013 & amended 4/20/2014, 8/8/2015]

Windows 8.1 is reported to be compatible with Microsoft Money “Sunset”, but the patch available below is recommended regardless.  When upgrading to Windows 10 you will again encounter the crash issue if you haven’t fixed the dll.  In order to find the dll file, you’ll have to not only show hidden files, but you’ll have to unhide system files as well and have administrative privileges.  The dll file can then be found in c: /Program Files (x86)/Microsoft Money Plus/MNYcoreFiles.

So here are the steps for Windows 8.x (also Windows 10)  😉 after you have downloaded the appropriate patched dll file as discussed in this blog article:

  1. Enable Show Hidden Files in Folder Options:
  • Click radio button to turn on “Show hidden Files, folders, and drives”
  • Turn off “Hide Protected operating system files” (Recommended)

file options

2. Backup the original “MNYOB99.DLL” by renaming it to “MNYOB99.DLL.OLD” in
C:\Program Files (x86)\Microsoft Money Plus\MNYCoreFiles

3. Copy Download Patched “MNYOB99.DLL” to
“C:\Program Files (x86)\Microsoft Money Plus\MNYCoreFiles\” to replace the original file

[UPDATED 3/20/2013]

Apparently Windows 8 “Update” should now fix the crash issues with Microsoft Money during imports of account transactions or when changing a payee of a downloaded transaction.    As of  12/12/2012 though, the same OS updates (KB2758857 specifically) that Microsoft published actually introduces the same crashes for Windows XP users.   I’m not sure which files their updates actually effect, or what methodology they use to “fix” the issues, but I’m so glad I don’t allow automatic updates!

Raymond Chen has reverse-engineered his own patch to fix some bugs in the Version 17 file mnyob99.dll which you can read about and perform yourself with a hex editor and seems to be more reliable across all OS’s.    By his description of the bugs, it is surprising that Money has worked consistently with the older OS’s all these years.   Thanks to John who has provided me with the patched file for the Plus Deluxe version of Sunset Money, I am making it available for you to download it  here.    If you are using the Plus – Home & Business version of Sunset Money, download the patched dll file specific to that program here.

OR you can manually edit your dll file yourself, using Raymond Chen’s great patch blog instructions (summarized here):

  • File offset 003FACE8: Change 85 to 8D
  • File offset 003FACED: Change 50 to 51
  • File offset 003FACF0: Change FF to 85
  • File offset 003FACF6: Change E8 to B9

Even though I wasn’t having a problem with XP (I don’t do OS updates very often), I’ve replaced the dll file on my system with no hiccups.

Another error that was reported…

MS Money was crashing after sign in while trying to import data. It was reporting that UTLSRF08.DLL was the faulting module.

was also fixed by replacing the faulty dll file.

[UPDATED 12/17/2012]

Cal Learner has verified that the only changes to the dll file that I’ve posted are as discussed above.   Thank you Cal

trp2525 also reported today that the recent XP Security Update that caused problems is fixed by installing the patched dll file.

The mnyob99.dll is located at C:/Program Files/Microsoft Money Plus/MNYCoreFiles for my version of Money.

After replacing the dll file I installed update KB2758857 and then restarted my computer.  I then tried updates from 3 different banking sites that included OFX and QIF downloads and my program worked perfectly with no crashes!  These were the same downloads that had crashed my program (with update KB2758857 installed) prior to the replacement of the dll file.

Hopefully, we’ll be able to use this fantastic program for many years yet!

[UPDATED 2/23/2013, 3/20/2013 & 12/18/2015]

Cal Learner has stated in the past that there are slight differences in the patch depending on the version of the Money program.  Other readers have confirmed that the Sunset Deluxe patch seems to work on other versions (including 2005 International), but technically he recommends that the other versions be patched using his Python script to  fix the dll file for versions of Money other than Plus Deluxe & Sunset Plus Deluxe.  See his post and (read the comments for more info) here.

When he first published his scripts, I was one of the few that had used this routine, and I was happy to report that I’d fixed my dll for the Home and Business version of Sunset Money and all went well (although the downloaded dll mentioned above also worked for me as well 🙂 ) and you can download the patched dll file for the Sunset Home & Business version here.

-ameridan

Advertisements

Comments (207)

UK Banks & OFX downloads

Money and UK Banks

Availability of OFX connection is quite common in the US, but seems to be very rare in Europe, even for business accounts and since there seems to be many questions regarding downloading UK Bank data, I thought I would start this thread that I’d be happy to keep up-to-date with feedback from my Blog readers.

Read the rest of this entry »

Comments (21)

Java apps (not Python) to update quotes into Money

For those that only need to update quotes (no Account Statement updates) and don’t wish to install Python scripting, Hung Le had written a Java app a year ago.   It has recently been updated (thank you Mike V. for debugging) and the link in the original  Blog page  has been updated with the new version that Mike V. has tested.   [NOTE] Keep in mind though that the Yahoo interface is a “work around” intended solely for tracking things that aren’t held in an OFX-enabled account.  If your investments are held in accounts for which you have an OFX download option, that is the prefered method. 

Thank you Hung Le for updating the app!

-ameridan

Comments off

PocketSense appVER upgrade

 From Quicken’s site, I found the following:   On April 30, of each year, Quicken discontinues its support for any of its versions more than 2 years old. As of April 30, 2011, Quicken will no longer support Quicken 2008,  which implies that we may have to upgrade the default in PocketSense at that time since Quicken forces financial institutions to promote Quicken upgrades by not allowing “obsolete” versions to communicate with their servers.  

I’ve observed that Moneydance is already using version 1900 (Quicken 2011), rather than version 1700 (Quicken 2008) that we’ve been using, so I’m hoping some of you will help test this prior to my requesting that Bobby incorporate this into his next version of PocketSense.

[Update 12/26/2010 – Turns out that the default Quicken version is 1800, so the change isn’t so imminent.  I’ve manually changed the setting to 1900 in site_cfg.py and everything seems to be fine 🙂 ]

For further clarification on appVER, see my Blogpage on the subject.

-ameridan

Comments (1)

Microsoft is cutting the cord early on Yodlee feeds

There are quite a few Money users who have paid to extend their services through January 2011 that will be upset to learn that the data feeds through a 3rd -party (namely Yodlee) will be discontinued as of October 1st.  If you get the following message when you sign up for online services with your financial institution:

* This service is provided by a third party provider, not your financial institution. It is only available if you have Microsoft Money 2005 or later. You will need to use Microsoft .NET Passport in order to access your account information.
Your financial institution may offer an alternative means of downloading statements and transactions from their web site into Microsoft Money 2004 and earlier.

then you may want to check out one of the Offline solutions covered in this blog.


[UPDATE 2/13/2017]
I read a review on Personal Capital (I see Yodlee is still in business):

an online financial website and app that links all of your accounts to track your spending, investments, and net worth. You provide your login information, and they pull in the information for you automatically so you don’t have to type in your passwords every day on 7 different websites (similar to Mint). Investment-specific features include tracking portfolio performance, benchmarking, and asset allocation analysis.

and my response…

I still prefer to use Microsoft Money (a FREE, private desktop PC program) for  tracking my spending, investments, and net worth.  Used in conjunction with Pocketsense (also FREE and runs from your PC), which are a set of Python scripts that perform the same online functions, it pulls in the information from all of your accounts for you automatically from the same OFX servers on a daily basis, and no one else in the cloud sees your passwords or data.

Comments (3)

Fidelity brokerage OFX downloads

Once your Microsoft Money program is offline (online services are no longer active),  there may be no way to import your transactions and statements (as well as the update of your quote data on all of your investments) from your Fidelity brokerage account(s)  into Money other than via using Python scripts.   Unlike the websites of many financial institutions that at least let you initiate a download of your transactions in either QIF or OFX format, it has been reported that there is no such option at Fidelity.

In hopes of assisting others in the same boat as MikeV99, I am posting this setup data for  PocketSense  hoping that someone will verify that it worksAs I learn more regarding the outcome, I will update this Blog.   Mike has verified the correct settings and I have updated the blog accordingly. Thanks Mike 🙂   

Read the rest of this entry »

Comments (45)

OFFLINE intro

If you agree with me that Microsoft Money is the BEST personal (and small business) financial management software package available, then you’ve come to the right place for improving Money’s OFFLINE capabilities.

  • Even though Microsoft has elected to divorce the program from the MSN Money servers as of January 31st, 2011 (which did much more than just grab statement downloads, including independent stock and fund quotes for ALL of your investments, passing through third-party web-scrapes of your data, supporting Online banking, investment news, tax and exchange rates, LiveID password authentication, etc.), they have made available a **FREE**  legal copy (the SUNSET edition) of the latest updated  OFFLINE  version of  Microsoft Money Plus Deluxe that you can download, even if you’ve never used Money before!  On its own, it will only update via OFX statement files that you download through the websites of your financial institutions.
  • Now by installing Python and downloading Bobby’s PocketSense script package that runs on Python, you will be able to essentially mimic those Online functions that Microsoft will no longer be providing.
  • For those that only need to update quotes (no Account Statement updates) and don’t wish to install Python scripting, Hung Le had written a Java app a year ago that has been recently updated and the link in the original Blog page has been updated with this new version.
  • Another new program is now available for updating quotes from MSN in a very similar fashion to Money’s original online updates.  It is called MSMoneyQuotes and you’ll find links to it in this blog post.
  • I have developed Ameridan’s addon package to PocketSense that allows you to run these scripts (and review your Online investment data) from within your Money program.
Make sure you check out the Look Up Your OFX Settings Blogpage with links to all of the sources of OFX settings that I am aware of.  All of the known working sites.dat settings that I am aware of are listed (and continuously kept updated) in this blog page.

IMPORTANT!! (Courtesy of Cal Learner)

People using LiveID (Passport) in Microsoft Money should turn that off by logging in offline.   You may have to do this to accomplish that:

Disconnect from the Internet. If using Money Plus, change the date on your computer to a date in January, such as 2011 Jan 15.   Start Money, and log in offline.    Remove your LiveID.   Do not attempt to change your LiveID.

To remove the Live ID, go to File-PasswordManager, and choose to remove your LiveID.   To remove or add a conventional password, also see File->PasswordManager.

If you get a warning that you cannot remove the LiveID, turn off Tools->Settings->ReceiveAccountUpdatesFromMsnMoneyMyAccounts if you set that, even if you leave on Live ID to work with Ultrasoft Money.

SITE NAVIGATION IMPROVEMENTS:
I’ve recently optimized the Blog widget settings to make navigating within this Blog as easy as possible. I hope you find it a little easier to find things – I pledge to continue doing my best to keep it up-to-date as a resource of helpful material for Microsoft Money users as well.

Other helpful information courtesy of Cal Learner…

US Money Sunset (Works with US and Canadian Files only; others see below)

Self-contained installation files for use (including if the original disk requires activation).   No direct online access works with the Sunset versions. See http://support.microsoft.com/kb/2118008 for an explanation of the Sunset versions

US Money Plus Deluxe Sunset

Downloadable from http://download.microsoft.com/download/2/5/5/2557D51B-AF4C-4123-8198-563ABA07337B/USMoneyDlxSunset.exe  [static link]
or use http://www.microsoft.com/en-us/download/details.aspx?id=20738

US Money Plus Home and Business Sunset
Downloadable from http://download.microsoft.com/download/C/1/B/C1BA4FFE-E119-4C19-8BD3-442F0E7E98A0/USMoneyBizSunset.exe  [static link]
or use http://www.microsoft.com/en-us/download/details.aspx?id=7564

Notes for North America:
1. US and Canadian Money 2005 and Essentials users — as well as other US and usually Canadian users — can use Money Plus Deluxe Sunset if they have to reinstall at some point. See http://support.microsoft.com/kb/2118008  for information.
2. Some US users of older versions of Money (Money 98 through Money 2003)  may have to use an additional step, described in http://support.microsoft.com/kb/919524/en-us  , of first installing a verson of US Money 2004 or 2005 to perform a file conversion before installing Money Plus Sunset. Here is a link to a minimally functional version of US Money 2005 (filename webinst.exe) that can be used for conversions: http://download.microsoft.com/download/D/B/7/DB72D4E0-FBD1-4B76-BFA0-1FF20F6AEC8D/M12USWEB.exe

Money 2005 UK – QFE2
Self-contained UK Money 2005 file including all available patches. Replaces all MS Money UK 2005 installation discs. Usually solves “Money cannot locate the file because it’s a read only file or you do not have permission to change it” error message.
Download from http://download.microsoft.com/download/8/5/8/858EDC2F-1806-4D2D-85E3-0FBB08CB720A/Money2005-UK-QFE2.exe.exe

Money 2005 International English QFE2
Self-contained Money 2005 International English installation file from Microsoft, including all updates (For Australia, New Zealand, Hong Kong and all other English versions other than for US, Canada, UK).
Download from http://download.microsoft.com/download/D/7/4/D7406013-4064-49BB-9AA8-7608655EF70C/Money2005-IntlEngl-QFE2.exe.exe

Money 2005 French – QFE3
Self-contained French Money 2005 file including all available patches. Replaces all MS Money French 2005 installation disks.
Download from http://download.microsoft.com/download/B/3/1/B31D6140-59FE-4D17-AF82-A2E77D0FCFFF/Money2005-FR-QFE3.exe.exe

Notes for all versions…

It is suggested that all Money users keep a good copy of the installation file, even if the need is not immediate. It will be needed if you reinstall Money in the future. Those links can change, so do a search if you don’t find the file you need. Since we don’t know how long these files will be available, it is best to keep a copy of your appropriate installation file in a safe place.

Regional versions

Money data files are in a different format for each region. The correct regional version of Money must be used or the data file will not open.

It is possible to convert from one region to another only by exporting data as loose qif and importing to the new regional version of Money. See http://support.microsoft.com/kb/304254  and  http://support.microsoft.com/kb/178830  .

Old Money versions will run only under 32-bit Windows

Old versions (Money 2000 and earlier) include 16-bit code so can run only under 32-bit Windows (XP, Vista, 7 and 8).

To be able to use data files from these older versions on a new PC with Sunset:

  • Download m12usweb.exe to the new computer.
    MD5 is 1c62413858e2184eb39862f1b2afba44See https://support.microsoft.com/en-us/kb/913108
  • Put the latest *.mny and *.mbf files into the Documents folder of the new computer
  • Temporarily uninstall Sunset if you had already installed on new computer
  • Disconnect from the Internet (may not be needed, but recommended)
  • Set the computer date to 2004/1/1 (or there about)
  • Install trial Money 2004 by running  m12usweb.exe
  • Let that convert your *.mny file. Check that it seems to work. Save the converted file. Maybe change the name so that you can distinguish the converted file. Close Money 2004
  • Set the date right. Install/reinstall Money Plus Sunset. Let it uninstall Money 2004. Let Sunset convert the Money 2004 *.mbf file to Sunset
  • Make extra copies of Sunset install and data files onto other media

There are continuing changes to the way Windows works. There is no certainty that newer 32-bit Windows will continue to run Money well or at all.

64-bit Windows

The U.S. Sunset versions of Money, downloadable above, run great in 64-bit versions of Windows 8 and 10.   However because of a bug in the file mnyob99.dll, there may be issues with with certain OS updates.   It is recommended that a patched version of this file be used to resolve these issues and insure compatibility.  Read more (and find a link to the patch) here.

Internet Explorer

Money uses Internet Explorer as the GUI, so do not delete the program from your PC.

Money version downloads

The latest versions are free for anyone to use, but are not supported by Microsoft. The download links above might become unusable at any time.

Remember to keep a secure copy of the downloaded installation file for when you need to re-install. Your data will be inaccessible if your Money program becomes corrupted and you cannot reinstall Money or if you procure a new PC and cannot install Money.

-ameridan

Comments off

Older Posts »