How to Export Mint Transactions to QuickBooks (CSV to QBO)

What you can still move, and what is gone

Mint stopped working on March 23, 2024, and Intuit deleted the account data after that date. There is no live sync to pull from anymore. If you exported your data while Mint was still running, you have a file (usually named transactions.csv) that holds your full transaction history. That CSV is the only thing you can bring into QuickBooks.

Be clear about what carries over and what does not:

• Carries over: dates, descriptions, amounts, and the debit/credit direction of each transaction.
• Does not carry over cleanly: Mint categories, budgets, goals, bill reminders, and custom rules. Mint's category names rarely match your QuickBooks chart of accounts, so plan to categorize inside QuickBooks after import.

If you never exported before the shutdown, that data is gone and cannot be recovered. The rest of this guide assumes you have the CSV.

Find your Mint CSV export

The Mint export was a single CSV file. Inside Mint, the download lived under Settings (gear icon) > Mint Data > Export CSV, or by scrolling to the bottom of the Transactions list and clicking Export all transactions. The file is named transactions.csv by default.

Check your Downloads folder, email attachments, or any cloud backup from late 2023 or early 2024. If you migrated to Credit Karma, note that Credit Karma did not import your Mint transaction history, so the CSV you saved is still your source of truth.

Understand the Mint CSV columns

A standard Mint export has these columns:

• Date (formatted like 1/15/2024)
• Description (cleaned-up payee name)
• Original Description (raw bank text)
• Amount (always a positive number)
• Transaction Type (debit or credit)
• Category
• Account Name
• Labels and Notes

The detail that trips people up: Mint stores every amount as a positive number and puts the direction in the Transaction Type column. QuickBooks expects money out to be negative and money in to be positive. So a 45.00 row marked debit needs to become -45.00, and a 45.00 row marked credit stays positive. You can do this in a spreadsheet, or let the converter handle the sign mapping for you.

Split the file by account first

Mint kept every account in one CSV, with the bank or card shown in the Account Name column. QuickBooks imports one account at a time, so a single file mixing your checking, savings, and three credit cards will not import correctly.

Before converting, sort the CSV by Account Name and split it into one file per account. Open the CSV in Excel or Google Sheets, filter on Account Name, and copy each account's rows into its own file. Keep the header row in every file. Convert each account separately so each one lands in the right register in QuickBooks.

Convert the Mint CSV to a QBO file

QuickBooks Online and Desktop both import .QBO files (the Web Connect format) directly into the matching account. That is the cleanest target for old Mint data because QuickBooks treats it like a normal bank download.

Load your per-account CSV into the converter on this page, map the columns (Date, Description, Amount, and the debit/credit direction), and download a .QBO file. Everything runs in your browser, so the file you saved years ago is never uploaded anywhere.

1. Open the converter and drop in one account's CSV.
2. Map Date, Description, and Amount. Point the tool at the Transaction Type column so debits become negative.
3. Set the date format to match Mint (usually M/D/YYYY).
4. Download the .QBO file and repeat for each account.

If you use Quicken instead of QuickBooks, export to QFX. For other accounting apps that read the plain Open Financial Exchange format, use OFX.

Import the QBO file into QuickBooks

In QuickBooks Online, go to Transactions > Bank transactions, pick the account, click the dropdown by Link account, and choose Upload from file. Select your .QBO file and confirm the account. The transactions land in the For Review tab, where you categorize them against your chart of accounts.

In QuickBooks Desktop, go to File > Utilities > Import > Web Connect Files and select the .QBO file. Desktop matches it to an existing account or lets you create one.

For the full import walkthrough, including the date-range and duplicate notes, see importing into QuickBooks Online.

Categorize after import

Because Mint categories do not map to a QuickBooks chart of accounts, your imported transactions arrive uncategorized. Work through the For Review list and assign each transaction to an account. QuickBooks bank rules learn from your choices, so after the first few of each payee the rest auto-suggest.

One practical tip: import oldest to newest if you are rebuilding several years of history, and reconcile each account against an old Mint or bank statement so you catch any gaps before they compound. If a row looks like a transfer between two of your own accounts, mark it as a transfer rather than income or expense so it nets to zero.

Frequently asked questions

Related