Importing from Microsoft Money

This is the complete guide to migrating your financial data from Microsoft Money to Monize.

There are two ways to do it:

1. Import your .mny file directly -- Monize reads the Microsoft Money file itself. This is the recommended method and the one you should use unless something prevents it.
2. Export QIF files from Microsoft Money and import those -- the older, manual method. Use it only if the direct import refuses your file.

For importing from other sources using CSV or OFX/QFX files, see Importing Transactions.

Overview#

Monize reads Microsoft Money .mny files directly -- not a QIF export of one, but the file itself, with its accounts, transactions, transfers, splits, securities, price history, exchange rates and scheduled bills intact. Nothing needs to be installed, Microsoft Money does not need to be on the machine, and the file never leaves your Monize server.

The older route is to export one QIF file per account from Microsoft Money and import those. Monize still supports it in full, but it asks considerably more of you and carries less information across.

Which Method to Use#

Use the direct .mny import. It reads every Money version from Money 97 to Money Plus Sunset. Fall back to QIF only if the direct import cannot read your file -- for example a damaged file that Money itself can still open and export.

Part 1: Direct .mny Import (Recommended)#

Before You Start#

Import into an empty profile. Version 1 does not merge. It creates what the file describes, and if an account of the same name already exists it adds transactions to it rather than working out which ones you already have. On a profile that already has data you will get duplicates.

If you have been trying Monize out and want to start over from Money, the review step offers Start fresh, which runs the same Delete My Data operation as Settings > Danger Zone before the import begins. It asks you to type a confirmation word and re-enter your password, and it cannot be undone.

Work from a copy. Monize never writes to the file, but a spare copy of three decades of finances costs nothing.

Money 97, 98 and 99 files import directly, with no conversion step, recurring bills included. A few things in them cannot come across exactly:

• A scheduled payment Money recorded with no account to pay from (Money 99 can leave a scheduled loan payment that way) cannot become a bill and is listed as skipped.
• An investment account's "Other income" and "Other expenses" arrive as ordinary categorized transactions in its cash account, and employee stock option grants, vesting and expiry are not imported.
• A CD, which Money 99 buys by amount, arrives as units worth 1 each.
• Money 99 keeps only the latest exchange rate for each currency, so a trade of a security quoted in another currency, made before that rate's date, is converted at the market exchange rate for its date instead, and listed so you can check it.

.mbf backup archives are not supported. Restore the backup in Money first and import the resulting .mny.

Check the file size limit if you self-host. The default ceiling is 300 MB, set by MNY_IMPORT_LIMIT_MB. See Troubleshooting the .mny Import if a large upload fails.

Read the Money file once. Monize refuses to import a file whose exact bytes it already imported into your account, so a second click cannot double your data. To import the same file again, use Start fresh.

Step by Step#

Navigate to Tools > Import Transactions to begin.

Step 1: Upload the file

Select or drag your .mny file onto the upload area. Import Microsoft Money files one at a time -- a .mny file holds a whole profile, so there is nothing to bulk-select. Monize reads the file on the server and shows a preview. Nothing is written yet.

If the file cannot be opened, the reason appears in red on the upload step (see Troubleshooting the .mny Import).

Step 2: Enter the password, if asked

Every Money file is encrypted, but most are encrypted with a blank password and open without asking. The prompt -- "This Money file needs a password" -- appears only when a real password is set. Enter it under Money file password and click Open file. The password is used once to read the file and is never stored. A wrong password says so specifically, so you can tell "this needs a password" apart from "that one was wrong". Money passwords are case sensitive.

Step 3: Review what will be imported

This step is worth the minute it takes.

• The file summary names the detected Money format (Money 97-99, Money 2001, Money 2002, or Money Plus / Sunset) and the base currency. If the Money version lacks a table Monize reads (Money 2001 has no scheduled bills, for example), a note says what is skipped because of it.
• Counts for transactions (with the number of transfers linked), payees, categories, tags from classifications, accounts, securities, investment transactions (with share transfers), price history, exchange rates and scheduled bills are each shown against the total in the file, so "40 of 500 payees" is visible before rather than after.
• Every account is listed with its type, currency, transaction count, opening balance and the final balance computed from the Money file itself. Compare a few against Money -- that same number is what the verification report reconciles against afterwards. A Money investment account appears as its two Monize halves, " - Cash" and " - Brokerage". An account Monize had to rename (two accounts sharing a name) shows its name in Money underneath, and closed, favourite and excluded-from-net-worth accounts are marked.
• Untick any account you do not want, or use Select all / Select none. Closed accounts are included by default and stay closed; they still hold history worth keeping.
• Override an account's currency with its dropdown if Money had it wrong.

• Scheduled bills appear as a checkbox list with each bill's account, frequency, next due date and amount, and whether it is a transfer or an investment. Money keeps one row per occurrence, so a long history holds thousands of rows for a handful of real bills; Monize detects the live series and pre-ticks those. An unticked bill is simply not created. A frequency Monize cannot express exactly is marked as the closest one, and bill series missing a template or a usable date are reported as skipped.

• Notes about this file collects anything ambiguous -- securities sharing a symbol, an action code Money did not document, a repeat interval with no exact equivalent. Where a note is about particular transactions, Show the n transactions lists them with their date, account, payee and amount, so you can find them in Money. Worth reading; none of it stops the import.

Step 4: Start the import

Choose the import options under the accounts, then click Start import. It runs on the server, so you can leave the page and come back. A large file takes a few minutes. The progress list shows which phase is running, with a row counter: preparing; accounts, categories and payees; transactions; investments; scheduled bills; prices and exchange rates; recalculating balances; verifying.

Only one import can run at a time for your account. If the server restarts mid-import, nothing is left half-written: Try again runs it again from the file you already uploaded, and Start over goes back to the upload step.

Step 5: Check the verification report

When the import finishes, the Balance verification table lists every account with the balance computed from your Money file, the balance it ended up with in Monize, and the difference. Holdings verification compares, for every investment account, the shares Monize now holds against Money's own open tax lots -- Money reconciles against those lots itself, so they are the number to trust. The counts above the tables say what was created.

A green run says every account reconciles; anything that does not is listed with the difference so you can look at it directly. Notes about this import repeats anything the import had to decide. The report downloads as JSON with Download report if you want to keep it; Done returns to the upload step.

Import Options#

Set on the review step, before you start the import.

With Start fresh ticked, Start import first opens Remove Existing Data. It lists what is removed -- every transaction and split; every scheduled transaction; every security, price, holding and investment transaction; every account, category and payee; every budget, custom report, tag and import mapping -- and warns that this cannot be undone, even if the import then fails. Type DELETE and your Password (an account that signs in through single sign-on confirms with its identity provider instead), then click Delete my data and import.

What Is Imported#

• Accounts of every type, with opening balances, currencies, and closed and favourite flags. A Money investment account becomes Monize's linked cash and brokerage pair, matching how Money itself stores them. Money's watch accounts ("Investments to Watch") are created excluded from net worth, since they track quotes rather than money you hold.
• Transactions, including splits, reference numbers, memos, and the cleared/reconciled status of each. Voided transactions are imported as voided rather than dropped.
• Transfers, using Money's own record of which two rows are the two sides. Nothing is matched by guesswork.
• Loan and mortgage payments, with the principal leg wired to the loan account as a transfer split. Where the payments make it unambiguous, the loan's funding account, payment amount and interest category are filled in too. Money's Pmt Num arrives in the loan register's reference number column.
• Securities and investment transactions: buys, sells, dividends, reinvestments, share transfers between accounts, and stock splits. Each trade puts exactly one row in one cash register, wherever Money put it: the account's own cash side for a trade paid out of it, the paying account for one funded from elsewhere.
• Price history and exchange rates, both additive -- importing on top of prices a quote provider already fetched converges rather than duplicating. Exchange rates are shared by everyone on your Monize server, so a rate from your file only fills a date Monize has no rate for; it never replaces one already stored.
• Scheduled bills you ticked, created active and set not to post automatically, so nothing lands in your accounts without you.
• Classifications, as tags. Money's two user-named classifications ("Classification 1" and "2", which you may have called Properties or Projects) become tags named Classification:Item, for example Properties:20 Spring Apartment. Every transaction, split and scheduled bill that carried the item in Money carries the tag in Monize. Only items a transaction actually uses are created.

What Is Not Imported#

Known Limitations#

No merge, no de-duplication. Version 1 targets a fresh profile. Monize refuses to import a file whose exact bytes it already imported into your account, and names the earlier import; to import it again, use Start fresh. A different save of the same Money file (whose bytes differ) is not recognised as the same file, and importing it creates the transactions a second time.

A failure after the data was saved says so. If an import fails after its records were written (a final check, for example), the wizard tells you the records are in your account and does not offer to try again: importing the same file again would duplicate them. Check your accounts before importing anything else.

Securities quoted in another currency than their account. Money records a trade in the account's currency. Monize stores the trade's price and total in the security's own currency, converted with the exchange rate your file holds for that date, and keeps the cash movement in the account's currency. If your file has no rate for that pair within 45 days before the trade, the market rate for the date is used, or failing that the trade is imported unconverted; either way the report lists it, so you can check the price.

Foreign-currency cost basis. Money stores a foreign holding's cost basis converted to your base currency at the historical rate, not in the security's own currency. Monize imports what the file says, so a holding bought in a currency other than your base one can show a cost basis that differs from what you paid in the original currency. The verification report flags these, and the share counts themselves are unaffected.

Two Money codes are still unconfirmed. Money's act 5 and 14 -- a reinvestment variant and a cash corporate action -- have never appeared in any file available to this project, so their handling is inferred. Any transaction mapped through one carries a note in the report rather than being silently accepted.

Securities sharing a symbol. Money allows two funds with the same ticker. Monize's symbols are unique per user, so the second gets a suffix (VOO-2) and a note in the report -- never collapsed into the first. A security with no symbol gets a generated placeholder and is excluded from automatic price updates.

After the Import#

The verification report does most of the checking for you, so the post-import work is short:

1. Read the report. Any account or holding that does not reconcile is named with the difference.
2. Review auto-created securities in Tools > Securities. A security that had no symbol in Money gets a generated placeholder symbol and is excluded from price updates until you give it a real symbol and exchange.
3. Recreate budgets and savings goals -- see Budgets.
4. Check your scheduled bills in Bills and Deposits. Imported bills are active but set not to post automatically; switch on auto-posting for the ones you want it on.
5. Check net worth on the Dashboard against your Money net worth report.

If the result is not what you wanted, see Starting Over -- or simply re-run the import with Start fresh ticked.

Troubleshooting the .mny Import#

Nothing is written unless the whole import succeeds, so a failure leaves your data as it was, and the uploaded file is kept for one more attempt.

Self-Hosting Failures#

Two failures look like the app is broken and are configuration:

• The upload is refused as too large. The frontend passes a Money file to the backend through its own upload route, which refuses anything over MNY_IMPORT_LIMIT_MB (default 300). The variable must be set on the frontend as well as the backend.
• The server is killed partway through every attempt. It is running out of memory. A Money file is held in memory while it is read, so the backend needs roughly twice the file size available. See helm/README.md for the sizing rules.

Part 2: The QIF Method (Alternative)#

Everything from here on describes the older QIF route: exporting one file per account from Microsoft Money and importing those. It is still fully supported, and the QIF import wizard handles:

• Regular banking transactions (chequing, savings, credit cards)
• Investment transactions (buy, sell, dividends, splits, reinvestments)
• Split transactions (multiple categories per transaction)
• Account-to-account transfers
• Category creation and mapping
• Security creation and mapping
• Multi-currency accounts

The process is designed for bulk operations -- you can import multiple QIF files at once, and the system coordinates between files to link transfers, reuse categories, and handle cross-references.

Prefer the direct .mny import. QIF carries no price history, no exchange rates and no scheduled bills, cannot export closed accounts without reopening them first, and matches transfers by inference rather than from Money's own records. Use QIF only when the direct import cannot read your file.

Part 3: Preparing Microsoft Money for Export#

Before exporting, take these preparatory steps in Microsoft Money to ensure a clean migration.

3.1 Note Your Account Details#

Create a spreadsheet or list with the following for each account:

Why this matters: The opening balance and date are critical. For imported accounts to show the correct current balance, the opening balance must be set to the balance as of the first transaction date in the QIF file. Microsoft Money often includes an "Opening Balance" transaction in the QIF export, which Monize detects automatically. However, having this information written down gives you a fallback if the auto-detection does not match.

3.2 Open Closed Accounts (if needed)#

If you have closed accounts in Microsoft Money that you want to import, you may need to temporarily reopen them -- Microsoft Money does not allow exporting closed accounts. The easiest way to do this is to go to Tools - Settings - Account settings (global) - Close or Reopen Accounts

The direct .mny import has no such restriction: closed accounts come across with their history and stay closed.

3.3 Make a List of All Accounts#

Microsoft Money exports one account at a time, so make a checklist:

[ ] Main Chequing (Regular)
[ ] Savings (Regular)
[ ] Visa Credit Card (Regular)
[ ] Emergency Fund (Regular)
[ ] RRSP Brokerage (Investment)
[ ] RRSP Brokerage (Regular - for cash transactions)
[ ] TFSA Brokerage (Investment)
[ ] TFSA Brokerage (Regular - for cash transactions)
[ ] Home (Asset)

Important for Investment Accounts: Each investment account requires TWO exports -- one as "Investment" type (for securities transactions) and one as "Regular" type (for cash transactions). Mark both on your checklist.

3.4 Create export folders#

Monize supports bulk-upload of .QIF files. We suggest you create the following folders to store your exported QIFs:

• 1-Assets
• 2-NativeAccounts
• 3-ForeignAccounts
• 4-Investments-Cash
• 5-Investments-Brokerage

This makes it easy to select all the files a certain type for bulk-import.

Part 4: Exporting from Microsoft Money#

Exporting Regular Accounts#

Follow these steps for each chequing, savings, credit card, cash, line of credit, and asset account:

Step 1: Open Microsoft Money and load your .mny file

Step 2: Go to File > Export

Step 3: In the export dialog, select Loose QIF format

Always choose "Loose QIF" -- it carries more information than "Strict QIF," including split transaction details and transfer references.

Step 4: Choose a save location (Desktop is easiest) and name the file after the account

Step 5: Select Regular as the account type

Step 6: Select the specific account to export from the account list

Step 7: Click Continue to export

Step 8: Check the account off your list and repeat for the next account

Exporting Investment Accounts#

Investment accounts in Microsoft Money contain two types of data:

• Investment transactions (buy, sell, dividend, etc.)
• Cash transactions (deposits, withdrawals, fees)

You must export each investment account twice.

Export 1: Investment Transactions#

1. Go to File > Export
2. Select Loose QIF
3. Name the file with the account name and "-Investment" suffix (e.g., RRSP-Investment.qif)
4. Select Investment as the account type
5. Select the specific investment account
6. Click Continue

Export 2: Cash Transactions#

1. Go to File > Export again
2. Select Loose QIF
3. Name the file with the account name and "-Regular" suffix (e.g., RRSP-Regular.qif)
4. Select Regular as the account type
5. Select the same investment account
6. Click Continue

File Naming Convention#

We recommend you give the files the same name as the source account. Monize attempts to auto-match QIF files to accounts by filename, so closer names mean less manual mapping during import.

Part 5: Recommended Import Order#

The order in which you import your QIF files matters. Monize handles transfers between accounts by matching pending transactions from previously imported files. Importing in the right order ensures transfers are linked correctly and reduces manual cleanup.

This ordering applies to the QIF method only. A direct .mny import brings every account across in one pass and links transfers from Money's own records, so there is no order to get right.

Recommended Order#

Import your accounts in this order:

1. Asset Accounts
      |
2. Bank, Credit Card and Line of Credit Accounts (Home Currency)
      |
3. Bank, Credit Card and Line of Credit Accounts (Foreign Currency)
      |
4. Investment Cash Accounts (-Regular exports)
      |
5. Investment Brokerage Accounts (-Investment exports)

Loan accounts can't be exported from Microsoft Money, but the transactions will be built via the payments made from the source accounts. The import process will recognize this and ask for confirmation.

Why This Order?#

Bulk Import#

Monize supports importing multiple QIF files in a single bulk operation. When you select multiple files:

1. Files are processed sequentially in the order listed
2. Categories, payees, and accounts created in file 1 are available for file 2, and so on
3. Transfer matching happens across all files in the batch

The best approach is to select ALL your QIF files at once and let Monize process them in order.

Part 6: Importing QIF Files into Monize Step by Step#

Navigate to Tools > Import Transactions to begin the import process.

Step 1: Upload QIF Files#

The upload step presents a drag-and-drop area where you can select your QIF files.

1. Click the upload area or drag your QIF files onto it
2. You can select multiple files at once for bulk import
3. Monize parses each file and extracts metadata:
   • Account type detected from the QIF header
   • Number of transactions
   • Date range of transactions
   • Categories found
   • Transfer accounts referenced
   • Securities found (for investment files)

After parsing, you advance to account selection.

Pre-Selection: If you start the import from a specific account (Accounts, edit the account, Import), that account is pre-selected. A blue banner shows "Importing to: [Account Name]", and for a single file the account selection step is skipped.

Step 2: Select Destination Account#

For each QIF file, you need to specify which Monize account the transactions should be imported into.

File Information#

A gray information box shows:

• File: The filename being imported
• Transactions: Number of transactions found
• Date Range: Earliest to latest transaction dates
• Detected Type: Account type identified from the QIF header (e.g., Chequing, Investment, Credit Card)

Selecting an Account#

Choose from the "Import into account" dropdown. The dropdown shows all compatible accounts:

• For investment QIF files (detected type: Investment), only brokerage accounts are shown
• For regular QIF files, all non-brokerage accounts are shown

Auto-Matching: Monize attempts to match QIF filenames to account names automatically. If a match is found, it is pre-selected in the dropdown. When you upload several files at once, every file gets its own dropdown; files matched by name are shown in green, and files Monize could only guess for (by account type) in amber.

Creating a New Account#

If the destination account does not exist yet:

1. Click + Create new account (+ Create new under a file in a bulk import)
2. Fill in:
   • Account name (e.g., "My Chequing")
   • Account type (Chequing, Savings, Credit Card, etc.)
   • Currency (USD, CAD, etc.)
3. Click Create

The new account is created immediately and auto-selected as the destination.

Investment accounts: When you create an Investment type account during import, both the brokerage and linked cash accounts are created automatically.

Date Format#

Monize detects the date format (MM/DD/YYYY, DD/MM/YYYY, YYYY-MM-DD or YYYY-DD-MM) from the dates in each file; the date range in the information box shows how they were read. There is no override on this step, so if the dates look swapped, check your Windows regional date setting and export again.

Step 3: Map Categories#

If the QIF file contains category references, you need to map them to Monize categories.

Understanding the Display#

Categories are displayed in three groups:

1. Needs attention (amber border) -- Categories that could not be auto-matched. These require your input.
2. Auto-matched to loan accounts (shown expanded) -- Categories that match loan or mortgage account names, indicating loan payments.
3. Auto-matched to categories (collapsed by default) -- Categories that Monize matched to existing categories. Click Show n auto-matched to categories to expand and verify.

Summary Line#

At the top of the list, a line summarizes the mapping status:

• "[X] need attention" (amber) -- categories requiring manual mapping
• "[X] matched to categories" (green) -- successfully auto-matched
• "[X] matched to loans" (blue) -- matched to loan accounts

Mapping a Category#

For each unmatched category, you can:

Option A: Map to an existing category

• Select from the dropdown of existing Monize categories

Option B: Create a new category

• Enter a new category name under Or create new
• Choose a Parent category, or + Create new parent... to name a new one
• The category is created during import

Option C: Skip the category

• Leave the dropdown at Skip (no category) to import transactions without a category
• You can categorize them later in the Transactions page

Loan Category Detection#

If a QIF category name matches an existing loan or mortgage account name, Monize detects it as a loan payment. These transactions are imported as transfers to the loan account rather than regular categorized transactions.

You can also tick This is a loan payment on any category yourself. Then pick the loan under Select existing loan, or create it with Or create new loan: its name, Loan type (Loan or Mortgage), Institution and Initial loan amount (the original principal).

Step 4: Map Securities#

This step appears only when importing investment QIF files that contain security references.

Security Lookup#

Monize can look up securities automatically:

• A lookup runs automatically for every unmatched security when you first reach this step ("Looking up securities...")
• Click Lookup next to any security to search again by what is in its symbol or name field; when several securities fit, you choose one from a list
• Lookup results fill in the security name, symbol, type, exchange and currency, trying your preferred exchanges (Settings > Preferences) first

Mapping a Security#

For each security, you can:

Option A: Map to an existing security

• Select from the "Map to existing" dropdown

Option B: Create a new security

• Enter the symbol under Or create new (symbol) (e.g., "AAPL")
• Enter the Security name (e.g., "Apple Inc.")
• Select the Security type (Stock, ETF, Mutual Fund, Bond, Option, GIC, Cryptocurrency, Cash/Money Market, Other)
• Choose the Exchange (e.g., "NYSE", "TSX") and the Currency; picking an exchange sets the currency it trades in

Row Status Indicators#

Each security row is colour-coded:

• Green border -- Ready to import (mapped to existing or new security details filled in)
• Amber border -- Needs attention (no mapping selected)

Step 5: Map Transfer Accounts#

This step appears when the QIF file references transfers to other accounts (e.g., [Savings Account] notation in QIF).

Note: This step is skipped for investment QIF files. Investment transfers are handled automatically through the linked cash account.

Mapping a Transfer Account#

For each referenced transfer account:

Option A: Map to an existing account

• Select from the "Map to existing" dropdown

Option B: Create a new account

• Enter the account name under Or create new
• Select the Account type
• Select the Currency

Tip: If you are importing all files in bulk, transfers between imported accounts are linked automatically. You only need to map accounts that are not part of the current import batch.

Step 6: Review and Import#

The review step shows a summary of everything that will happen during import.

Single File Import Summary#

• File: filename.qif
• Transactions to import: [count]
• Target account: [account name]

Bulk Import Summary#

• Files to Import: List of each file with transaction count and target account
• Total: [X] files, [Y] transactions

Entity Creation Summary#

• Categories: Total, mapped, new to create, mapped to loans, new loans to create
• Transfer Accounts: Total, mapped, new to create
• Securities: Total, mapped, new to create

Executing the Import#

Click Import Transactions to begin. The button shows a loading spinner while processing.

For bulk imports, files are processed sequentially. Entities created in earlier files (categories, accounts, payees, securities) are available for subsequent files.

Important: Each file is imported inside a database transaction. If the import of a file fails, none of its changes are kept. A single transaction that cannot be imported is counted as an error and the rest of the file still imports.

Step 7: Import Complete#

After successful import, the complete step shows detailed results.

Results Displayed#

Per-File Results (Bulk Import)#

For bulk imports, each file shows its individual results with success/error indicators:

• Green background for files with no errors
• Red background for files with errors, including the first 3 error messages

If the import created a loan or mortgage account without scheduled payments, a Set Up Recurring Payments box offers Set Up Payments for it.

Next Steps#

After import, you have two options:

• "View Investments" / "View Transactions" -- Go directly to see your imported data. These take you to the account(s) you just imported -- single, bulk, or multi-account QIF -- not whichever account you last happened to view; imports into closed accounts stay visible too.
• "Import More Files" -- Return to the upload step for additional imports

Part 7: Post-Import Steps#

These steps apply to the QIF method. After a direct .mny import, see After the Import instead -- the verification report covers most of this for you.

7.1 Verify Account Balances#

Compare each account's current balance in Monize against your Microsoft Money records. If balances do not match:

1. Check the opening balance -- it should match the balance as of the first transaction date
2. Look for missing or duplicate transactions
3. Check that transfers between accounts were matched correctly (not doubled)

7.2 Review Cross-Currency Transfers#

Cross-currency transfers from Microsoft Money may need manual adjustment because the QIF format does not include exchange rate information. Look for transactions with a memo containing "PENDING IMPORT" and update the amounts to reflect the actual exchange rates.

7.3 Verify Investment Holdings#

1. Navigate to Investments
2. Check that each holding shows the correct quantity and cost basis
3. Compare against your Microsoft Money portfolio summary
4. Check that the securities created during import have the right symbols and names

7.4 Check Security Price Updates#

Securities created during import use the symbol, exchange and type entered on the Map Securities step, and get price updates like any other. If one was created with a guessed symbol:

1. Navigate to Tools > Securities
2. Edit the security to correct its symbol, exchange, and type
3. Prices are fetched for the corrected symbol from then on

7.5 Review Categories#

Navigate to Tools > Categories and review the category hierarchy. Categories imported from Microsoft Money use the QIF naming convention (with / separating parent and child). You may want to reorganize or rename them.

7.6 Set Up Scheduled Transactions#

QIF export from Microsoft Money does not include scheduled/recurring transactions. You must recreate these manually:

1. Navigate to Bills & Deposits
2. Create each recurring bill and deposit
3. See Bills and Deposits for details

The direct .mny import brings scheduled bills across, so this step is not needed there.

7.7 Check for Uncategorized Transactions#

Run the Uncategorized Transactions report (Reports > Uncategorized Transactions) to find any transactions that were imported without a category. Assign categories as needed.

7.8 Verify Net Worth#

Navigate to the Dashboard and check the Net Worth chart. Monize automatically calculates monthly net worth snapshots after import. Compare the trend against your Microsoft Money net worth report.

Part 8: Starting Over#

If your import did not go as expected and you want to start fresh, you can delete all your financial data without losing your user account or settings.

1. Navigate to Settings
2. Scroll to the Danger Zone section
3. Click "Delete Data..."
4. Check all four optional boxes (Accounts, Categories, Payees, Currency preferences) for a completely clean slate
5. Enter your password to confirm

This removes all transactions, accounts, categories, securities, budgets, and other financial data. Your user account, preferences, and security settings (2FA, trusted devices) are preserved. You can then re-import your files.

If you are re-running a direct .mny import, you do not need to do this first -- tick Start fresh on the review step and the same operation runs as part of the import.

For more details, see Settings and Security > Danger Zone.

Part 9: Troubleshooting the QIF Import#

For .mny import problems, see Troubleshooting the .mny Import.

Common Issues#

"Account type mismatch" Error#

Cause: Trying to import an Investment QIF file into a non-brokerage account, or a Regular QIF file into a brokerage account.

Solution: Make sure you select the correct account type:

• Investment QIF files (-Investment) go into brokerage accounts
• Regular QIF files (-Regular or standard banking) go into non-brokerage accounts

Dates Appear Wrong#

Cause: The date format was detected incorrectly (e.g., MM/DD was interpreted as DD/MM).

Solution: The date format of a QIF file is detected from its dates, and there is no override in the wizard. Check the short date format in Windows' regional settings, export the file again from Microsoft Money, and import the new file. Or use the direct .mny import, which does not depend on a date format at all.

Duplicate Transactions After Import#

Cause: Importing the same file twice, or transfer transactions appearing in both accounts.

Solution:

• Monize skips the second side of a transfer that is already recorded when importing the other account
• If duplicates still appear, use the Duplicate Transaction Finder report to identify and remove them
• For future imports, always import all related files in a single bulk operation

Transfer Not Linked Between Accounts#

Cause: The transfer accounts were not mapped correctly, or the files were imported in separate sessions.

Solution:

• When possible, import all files at once using bulk import
• Check that account names in QIF match the Monize account names
• Manually link unmatched transfers by editing the transactions

Investment Securities Not Found#

Cause: Microsoft Money does not include a security master list in QIF exports.

Solution:

1. During the Map Securities step, use the Lookup button to search for each security
2. If lookup fails, manually enter the symbol, name, type, exchange and currency
3. After import, check the securities created in Tools > Securities

Opening Balance Incorrect#

Cause: Microsoft Money's opening balance transaction may not match the expected starting point.

Solution:

1. Navigate to Accounts
2. Edit the account
3. Adjust the opening balance and opening date to match your records
4. The current balance will be recalculated

Cross-Currency Transfer Amounts Wrong#

Cause: QIF files do not contain exchange rate information.

Solution:

1. Search transactions for "PENDING IMPORT" in the memo field
2. Edit each flagged transaction
3. Adjust the amount in the destination account to match the actual transfer amount
4. This correctly sets the effective exchange rate

Import Times Out#

Cause: Very large QIF files (near the 10 MB limit or files with thousands of transactions).

Solution:

• The import has a 5-minute timeout
• If a single file is too large, try splitting it into smaller date ranges in Microsoft Money

Part 10: What Cannot Be Imported via QIF#

The QIF format and Microsoft Money export have limitations. The following data must be recreated manually in Monize. Several of these limits do not apply to the direct .mny import -- the right-hand column says which.

Quick Reference Card#

Recommended: Direct .mny Import#

1. Work from a copy of the .mny file, into an empty Monize profile
2. Tools > Import Transactions, select the .mny file (one at a time)
3. Enter the file password if prompted
4. Review accounts, balances, options and scheduled bills -- untick what you do not want
5. Start import, then read the verification report

Alternative: Export from Microsoft Money as QIF#

1. File > Export > Loose QIF
2. One file per account
3. Investment accounts need two exports (Investment + Regular)
4. Name each file after its account

Importing QIF into Monize#

1. Tools > Import Transactions
2. Select all files at once for bulk import
3. Map accounts, categories, securities, and transfer accounts
4. Review and click "Import Transactions"

Recommended QIF Import Order#

1. Asset accounts
2. Home currency bank accounts
3. Foreign currency bank accounts
4. Credit card accounts
5. Investment cash accounts (-Regular files)
6. Investment brokerage accounts (-Investment files)
7. Line of credit / loan accounts

After a .mny Import Checklist#

[ ] Read the verification report -- every account should reconcile
[ ] Give auto-created securities a real symbol and exchange
[ ] Recreate budgets and savings goals
[ ] Check imported scheduled bills in Bills & Deposits
[ ] Check net worth trend on Dashboard

After a QIF Import Checklist#

[ ] Verify all account balances match Microsoft Money
[ ] Fix cross-currency transfer amounts ("PENDING IMPORT" memos)
[ ] Verify investment holdings and cost basis
[ ] Update auto-created securities with correct symbols
[ ] Recreate scheduled transactions (bills and deposits)
[ ] Run "Uncategorized Transactions" report and fix gaps
[ ] Review category hierarchy and reorganize if needed
[ ] Check net worth trend on Dashboard