Importing Data


Maxim Money currently supports importing from OFX and QIF files.  These are the most common file formats when downloading statements from online banking.


There are three ways to import data into Maxim Money.  If you are starting a new data file, the easiest way is select Import... from the File menu, or to drag and drop an import file into the Accounts list.  This way you don't need to manually create any accounts; the import process will do this for you.



An alternative way to create a new account from imported data is to manually create an account, and import the data into that account.  To do this, click on the Add Account button in the Accounts list.  This will create a new account, with the Details tab selected.  Enter your account name and any other details about the account, then click on the Transactions tab.  You can then drag and drop an import file into the Transactions grid.  This will again create any other linked accounts found in any transfer transactions.  The advantage of dragging and dropping directly onto an account is that this makes it clear which account you wish to import to.  


If you attempt to import transactions and the account cannot be determined, Maxim Money will display the import dialog like so, where you can confirm which account you wish to import into.



NB. If the currency of the account differs from your system base currency, it's best to set this on the account before you import the data.  This will ensure any transfers between accounts pick up any exchange rates when assigning a value to the other account.


If you import data into an empty account, the status of each transaction will be set to Imported.  However, if transactions already exist in the account, the status will be set to Newly Imported.  This then allows you to reconcile the newly imported transactions against any that might already exist in the register.


Importing Portfolios

Maxim Money can import portfolio data from QIF files.  However, there are several stages to this.


  1. Create a new portfolio (right click in the Accounts List and select Add Portfolio)
  2. Give your portfolio a name, and select the currency for the portfolio.  Selecting the currency is important before you import data, because QIF format does not specify currency.  Therefore, all securities imported will default to the portfolio currency.
  3. Select the Holdings tab, and drag and drop your QIF file into the Holdings view.  This should import all the securities and transactions.
  4. MS Money does not export Stock Splits in QIF files (even though the file format supports this), so if any of your balances are incorrect, check to see whether there were any splits on your investments.  MS Money displays this by adding a lower case s after the price in the Investment Activities view.  To manually add the stock split, see Investment Portfolios.
  5. Maxim Money will create a currency cash account within the portfolio, which the transactions are linked to (invested from).
  6. Import any cash accounts for the Portfolio separately.
  7. Drag and drop the cash account in the Accounts list onto the Portfolio in the accounts list.  This will prompt you to merge the imported account with the created account.  Once done, the cash account total should match that from your previous application.