Monarch Money can't open a Quicken data file (.QDF) directly. To transfer Quicken data to Monarch Money, export each account's transactions from Quicken to a CSV file, make sure it has Date, Amount, and Account columns, then import it on the Monarch web app under Accounts > + Add Account > Import transaction & balance history. Your original Quicken file stays unchanged.
- In Quicken, open Reports > Banking > Transaction and filter it to one account.
- Export the report and save it as a CSV with Date, Amount, and Account columns, with spending as negative numbers.
- On the Monarch web app, go to Accounts > + Add Account > Import transaction & balance history.
- Upload the CSV, map columns and categories, choose Prioritize Monarch, and import.
- Repeat for each account.
If you're switching from Quicken to Monarch and want to transfer Quicken data to Monarch Money, the good news is that your years of transaction history don't have to stay behind. The process is manual. There's no one-click converter. But once you know the sequence, it's very manageable, even if you have a decade or more of records.
First, a reassurance. Exporting data from Quicken doesn't change, delete, or damage your Quicken file. You're only making copies. If anything goes wrong on the Monarch side, your original data is still safe in Quicken, and you can try again.
The basic approach has three parts. You export transactions from Quicken as a CSV file. You clean the file so Monarch can read it. Then you import it. Monarch lets you import a CSV into either a synced or a manual account. Balances on synced accounts stay as they are, while manual accounts let you adjust the balance.
Platform scope: These steps cover Quicken Classic for Windows and Quicken Classic for Mac. Importing into Monarch requires the Monarch web app.
Why Quicken Data Doesn't Move Over Automatically
Quicken stores everything in its own proprietary data file. Monarch Money is a cloud-based app that gets most of its data from bank connections. The two don't share a file format.
There's also a history gap. Even when you link your bank to Monarch, banks usually send only a limited window of recent history, and the length varies by bank and account type. Your older Quicken transaction history, which is often the reason you used Quicken for years, lives only in your Quicken file. That's why a CSV import is needed.
Before You Start: Migration Checklist
- Back up your Quicken file before you start.
- Export one account at a time from Quicken.
- Make sure the CSV has Date, Amount, and Account columns.
- Import the file on the Monarch web app (not the mobile app).
- Test with a small file first, then import the full history.
Step-by-Step: Transfer Quicken Data to Monarch Money
Step 1: Back Up Your Quicken Data File
Before anything else, make a fresh backup in Quicken. It takes a minute and gives you a clean restore point.
- Windows: Go to File > Copy or Backup File, choose a location, and click Back up Now.
- Mac: Go to File > Save a Backup, choose a location, and click Save.
For full instructions, see Quicken's official guide on How to Back Up or Restore Your Quicken Data.
Step 2: Decide How to Handle Overlapping Dates
This step is easy to skip, but it saves headaches later.
If you plan to connect your bank accounts to Monarch, it usually works best to connect them first. Monarch will pull in whatever recent history the bank provides. Then you import the older Quicken history to fill in the gap.
During import, Monarch will ask how to handle overlapping dates. We cover those options in Step 6.
Step 3: Export Quicken to CSV on Windows
The most reliable method in Quicken Classic for Windows is to export a report:
- Go to Reports > Banking > Transaction.
- Click Customize and choose one account only.
- Set the date range to cover all history (for example, from your first transaction to today).
- Make sure the report shows Date, Account, Payee, Category, Memo, and Amount. Add the Account column and set Subtotal by to Don't subtotal.
- Click Export Data > Export to Excel Workbook and save the file.
- Open the file in Excel and use Save As > CSV (Comma delimited).
If your version only shows Report to Excel compatible format, that option saves a tab-delimited .txt file. Open it in Excel, which will walk you through the text import, then save it as a CSV.
Another option is to export the account register. While in the register, use the Print function. Under Export to, choose tab-delimited (Excel compatible) disk file instead of a printer. Register exports use separate Payment and Deposit columns, which you'll combine in Step 5.
For other report types, see Quicken's official guide on How to Export Quicken Reports to Excel.
Step 4: Export Quicken to CSV on Mac
In Quicken Classic for Mac, open a Transaction report filtered to one account. Click Export below the report title and choose Export to CSV File. Newer Mac versions also let you export register transactions to CSV from the File > Export menu.
A few older Mac reports with graphics, such as Spending Over Time, can't be exported to CSV. Use a standard Transaction report instead.
Step 5: Clean Up the CSV File
This is where most import errors are prevented. Open your CSV in a spreadsheet and check the following:
Required columns. Monarch needs three headers in any order: Account, Amount, and Date. Columns like Category, Tags, and Notes are optional, and columns Monarch doesn't use are ignored.
One amount column. Transaction reports already use a single Amount column. If you exported from the register instead, combine the Payment and Deposit columns into one Amount column. Spending should have a minus sign or parentheses, such as -58.12 or (58.12), and deposits should be plain numbers.
Account name. If your export doesn't include an Account column, add one and fill every row with the account name you want in Monarch (for example, "Chase Checking").
Remove extras. Delete report titles, blank rows, subtotals, and grand totals that Quicken adds at the top or bottom.
Dates. Use a standard US date format such as 12/01/2024.
Transfers. Rows whose category shows a bracketed account name, such as [Savings], are transfers between your own accounts. Plan to map these to Monarch's Transfer category during import so they don't count as income or spending.
Split transactions. In Quicken for Windows transaction reports, each split line appears as its own row with its own category, so amounts aren't counted twice. You can keep split rows for accurate categories, or merge them into one row if you want one Monarch transaction per bank entry. Either way, check that the split rows add up to the amount on your bank statement.
Step 6: Import the Quicken CSV into Monarch Money
You can only complete a Monarch Money CSV import on the web. Importing isn't available in the mobile app.
Before you import: CSV imports can't be undone, and the Prioritize CSV option deletes existing Monarch transactions in the file's date range. Make sure your Quicken backup from Step 1 is complete, and test with a small file first.
- Log in to Monarch in a web browser.
- Go to Accounts and click + Add Account.
- Click Import transaction & balance history, then Import transactions.
- Upload your CSV file.
- Review the column mapping Monarch suggests and correct anything that's off. Make sure Quicken's Payee column is mapped to Monarch's Merchant field.
- Map categories and tags, which can be new or existing. Map transfer categories to Transfer.
- Assign the account name.
- Choose how to handle overlapping transactions:
- Prioritize Monarch keeps existing synced data and only adds missing earlier transactions. This is usually the safest choice if your bank is already connected.
- Prioritize CSV deletes existing Monarch transactions in that date range and replaces them with your file. Use this option with caution.
- Import all brings in everything, which can create duplicates.
- Ignore Use transaction IDs to match transactions. It only applies to files exported from Monarch.
- Review the summary and click Import transactions.
If you need to remove an import, you'd have to bulk-delete the transactions or delete the account and start over. That's why it's worth testing with a small file first, such as one month of data.
You can review Monarch's own instructions on the Monarch Help Center.
Step 7: Repeat for Each Account
Work through your accounts one at a time: checking, savings, credit cards, and so on. After each import, spot-check a few transactions against Quicken. Compare dates, amounts, and categories.
How to Import Quicken Balance History into Monarch
Transactions alone don't always rebuild an accurate net-worth chart. Monarch has a separate balance history import. Each file should cover one account and include date and balance columns.
To build a balance file from Quicken for Windows:
- Go to Reports > Net Worth & Balances > Account Balances.
- Click Customize, select one account, set the date range, and set the interval to Monthly.
- Export the report, keep only the Date and Balance columns, and save it as a CSV.
- In Monarch, go to Accounts > + Add Account > Import transaction & balance history, choose Import balances, and upload the file.
As an alternative, a register export may include a running balance column, depending on your Quicken version.
Monarch says balance imports are meant for past data and don't accept future-dated balances, so remove any scheduled or future entries first. See Monarch's guide to importing account balance history.
Investment Accounts
Monarch's CSV importer covers transactions and balances only. It doesn't import securities, lots, or cost basis. In many cases, the simplest route is to connect your brokerage directly in Monarch and import only the balance history for older years.
Fixing the "File Too Large" Error
If Monarch shows a "File too large" error, split your CSV into one file per account, then by year if needed, and import each file separately. See Monarch's guide to importing large CSV files.
If the import keeps failing, your numbers don't match after the transfer, or you're worried about getting it wrong with years of records, you can reach out to our team and we'll walk you through it step by step.
Get One-on-One HelpPrevention Tips for a Smooth Quicken to Monarch Migration
- Don't cancel Quicken right away. Keep it until you've confirmed every account's history in Monarch.
- Export with an end date of today. This avoids pulling in scheduled or future transactions.
- Keep a folder of your CSV exports. It serves as an extra archive of your financial history.
- Use consistent account names. Match the CSV name to the account name in Monarch to avoid creating extra accounts.
- Clean up categories before exporting. Merging old or unused Quicken categories first means less clean-up in Monarch.
- Reconcile a few months. Compare month-end totals in Quicken and Monarch for at least two or three months per account.
Frequently Asked Questions
Can Monarch Money open a Quicken .QDF file directly?
No. Monarch doesn't read Quicken data files. You need to export transactions to CSV first.
Will exporting from Quicken delete my data?
No. Exporting only creates a copy. Your Quicken file stays exactly as it was.
Can I import all my Quicken accounts in one file?
Monarch can handle multiple accounts in a single CSV if each row has an Account column. However, exporting and importing one account at a time is easier to check and troubleshoot.
Do my Quicken budgets transfer to Monarch?
No. Monarch doesn't support importing budgets or aggregate cash flow totals. You'll need to set up your budget again in Monarch.
What if I use Quicken Simplifi instead of Quicken Classic?
Simplifi exports transactions to CSV from its web app. Open Transactions, select the account and transactions, then click the download arrow. You can't filter the export to a custom date range, and split transactions aren't included by default. Format and import the file into Monarch the same way. See Simplifi's guide on how to export transactions.
Author: All Quick Solutions Editorial Team. We write practical, step-by-step guides on Quicken and personal finance software, focused on helping readers fix problems and move their data safely.
Disclaimer: All Quick Solutions is an independent resource and is not affiliated with, endorsed by, or sponsored by Quicken Inc. or Monarch Money. Product names and trademarks belong to their respective owners. Menu names and features can change between software versions, so always check the latest official documentation before making changes to your financial data.

