Thursday, February 22, 2007

Converting my file from UK to US Money

I was asked recently about the conversion from UK to US Microsoft Money - something I did, but is not supported.

It seems useful to blog an edited and tidied up response I gave.

About the transfer

Firstly, it is difficult. The more accounts you have, the harder it is, and the more inter-currency transfers you have, the harder still.

On my FAQ site, the relevant article I used was the QIF route (http://moneymvps.org/faq/article/28.aspx), which is the mechanism I used for the basic account moves (using QIF export/import), but when doing the transfer, there is also the need to factor in the creation of scheduled bills, recreating the budget (if you use it) and planning data.

If you have a Pocket PC which you synchronize, then note there is no PPC program
for Money 2007 (at least from Microsoft).

How long it took

I had quite a lot of historical accounts which only linked between themselves, so in a sense they were easy as I did them before doing the main accounts that I use today. Similarly with investments. No idea how long that took, as in a sense, that was some of my dry-run data.

I didn't copy any planning data and I regenerated my bills/deposits from the existing data (I manage my accounts so that I have as few as these as possible, so there were no complex loans for example). Inventory I didn't care about.

Finally I took the plunge and did the main accounts (I had done dry runs before this). I then sorted out the tranfers which used different currencies, and it probably took a few hours in total

To help matters, it was done using Microsoft Virtual PC, so I could have both the US and UK versions open at the same time.

Comments


This is not something I would necessarily recommend, and you need to be committed to do it, otherwise you may waste a good few hours of your life. If you want to do it, then you may like to check out the trial version of US money first (http://moneymvps.org/downloads/trials/default.aspx and use that to perform dry runs and tests.

2 comments:

Ranerio said...

Hey, I think your site on Microsoft Money is the best I have ever seen on the topic.
I have a Money 99 BR file which I have been using for almost 5 years. I had tried to convert it to a newer version, but since Brazilian version was never upgraded after 99 I could never. I tried the QIF export but I have many accounts and things such as investment accounts, so there were problems . Do you know if there`s any other way to convert the BR file to a standard US file?

Glyn said...

Hi Ranerio

thanks for your kind words. I don't know how many Brazillian users are out there, but they've experienced the problem that most other country has now had, in that there are no later versions of Money for them to upgrade to.

Firstly, you've obviously seen the issue with converting from one country's version to another - namely it can't be done.

The next step is always the QIF export - very painful but can be done.

You've mentioned the accounts - I hope you've tried to import all of the accounts at the same time, as that should preserve transfers between accounts.

One tip is that you may consider creating empty accounts first, so that you don't need to do it during the import process. Additionally, I believe I read somewhere that doing the investment accounts on their own first (i think), can avoid certain issues too. If you rename the QIF exported files, they are imported in alphabetic order, so naming the investment files A1, A2 etc can help.

There are not really any other methods than QIF export. I suppose you could create reports and then export those reports as CSV, but at the end of the day, getting it back into Money needs the QIF file.

If the above provides any help, then great, otherwise, let me know and I'll see if I can respond to any specific errors you see.

Glyn