Simplifi Import Transactions: The CSV Route Explained

Quick Answer: Yes, Quicken Simplifi can import transactions from a file, and that file must be a CSV. On the web app, open Transactions, pick the account, click the three-dot menu beside Filter, choose Import transactions, then drop in your CSV and click Import. The columns are Date, Payee, Amount, Category, Tags, Notes and Check_No, with dates written M/D/YY and expenses carrying a minus sign.

Simplifi imports transactions from a CSV file, one account at a time, in the web app only. Date, Payee and Amount are the minimum fields; dates follow M/D/YY and spending is negative. Each file can be imported once. To backfill months your bank's 90-day download no longer reaches, turn the old statement PDFs into a CSV and reshape it to Simplifi's columns.

What does Simplifi actually accept?

Quicken's own support article, How to manually import transactions in Quicken Simplifi (read on 26 October 2026), is the reference here, and it is narrower than many people expect. Simplifi is not Quicken Classic. Classic for Windows and Mac has its own import paths for QFX and other files, covered in our guide to importing bank statements into Quicken. Simplifi's manual import takes CSV, and the support page names no other file type for a general bank import.

The page also lists dedicated import options for Mint and for Personal Capital (now Empower). Those are for files exported by those apps. Quicken's instruction for Mint is to use the Mint option and not to edit the Mint file before importing, and it notes a 10,000-transaction limit per Mint import. Everything else, including a bank's own export or a file you built yourself, goes through the generic CSV path.

So if you were hoping to hand Simplifi a QFX, OFX or QIF file, the support article gives you no route for that. Plan on CSV.

The column layout Simplifi expects

Simplifi reads columns by name. Quicken offers a downloadable CSV template on the support page, and using it is the safest way to get the header row exactly right. The columns are:

Three details trip people up most often.

• The date format is strict. Quicken's example is 1/1/22: month, then day, then a two-digit year. A file straight from a UK, Indian or Australian bank usually writes day first, and 03/04/26 would land on 4 March rather than 3 April. Reformat the column before importing.
• The sign convention matters. Simplifi wants spending negative. Some bank exports split money in and money out into two columns, or print every amount as positive with a separate debit/credit flag. Combine them into one signed Amount column.
• Categories are matched, not created. If your file says "Coffee shops" and Simplifi has no category by that exact name, the category is not brought in. Either create the categories first or leave the column blank and categorise afterwards.

How do you import a CSV into Simplifi step by step?

These steps follow Quicken's article. They work only in the Simplifi web app; the support page says import is not available from the mobile app.

1. Sign in to Simplifi on the web and open Transactions from the left-hand panel.
2. Select the account the transactions belong to. Import works on a single account at a time.
3. Click the three-dot menu next to the Filter button.
4. Choose Import transactions.
5. Pick the import source (the generic CSV option for a bank file, or Mint or Personal Capital if that is where the file came from).
6. Check that the account named on screen is the right one.
7. Choose the CSV, or drag it onto the window, and click Import.

If you have three accounts to backfill, you will run this three times with three separate files. Mixing accounts in one CSV is not something the support article describes.

Why you only get one shot per file

The part of Quicken's page worth reading twice is the warning about repeats. Each set of transactions can be imported only once, and if you delete imported transactions, importing the same file into the same account again will not bring them back.

That changes how you should work. Before the real import:

• Open the CSV in a spreadsheet and sort by date. Look for the first and last rows and confirm they match the period you meant to load.
• Check whether those dates overlap with transactions Simplifi already downloaded from the bank connection. Overlap gives you duplicates to clean up by hand.
• Test the layout with a short file first, ideally a handful of rows from a period you do not otherwise need, so a formatting mistake costs you nothing.

Trim the overlap in the spreadsheet rather than in Simplifi. Deleting rows from a CSV is easy; deleting duplicates inside the app is slow, and once deleted they cannot be restored by re-importing.

Why can't you just download older history from the bank?

Quicken's article notes that, depending on your financial institution, you may only be able to download a CSV covering up to 90 days of history. That is the gap most people searching "simplifi import transactions" are trying to close: they joined Simplifi in the spring and want last year in it too, or their bank connection broke and left a hole.

Your options, roughly in order of effort:

1. Check the bank's own export first. Many banks let you pick a custom date range for a CSV download. If yours reaches back far enough, that file is the cleanest source, and you only need to rename columns and fix the date format.
2. Use the statement PDFs. Banks keep monthly statements far longer than they keep downloadable transaction history. Those PDFs hold every transaction, but as a printed table rather than data.
3. Type it in. For a few dozen transactions, manual entry in Simplifi is honestly quicker than any conversion.

Backfilling from statement PDFs

A statement PDF has the right information in the wrong shape. To get it into Simplifi you need a CSV with one row per transaction, then a few minutes of column work.

You can extract the table with Excel's Get Data from PDF, with Adobe Acrobat's export to spreadsheet, or with a converter. QuickBankConvert is one such converter: you download the statement from your bank, upload the PDF, and get rows with date, description, category and a signed amount, where money out is already negative. The file is uploaded and parsed on our servers, so read the privacy policy if that matters for your records. A free account gives CSV downloads for a few statements a month; for a longer backfill, the limits are on the pricing page.

Whichever tool you use, finish the file in a spreadsheet before importing:

1. Rename the description column to Payee and the date column to Date.
2. Make sure there is a single Amount column with expenses negative.
3. Convert the dates to M/D/YY. In Excel or Google Sheets, a custom number format of m/d/yy does this for a column that holds real dates; if the dates came in as text, convert them first.
4. Add empty Category, Tags, Notes and Check_No columns, or copy the header row from Quicken's template so nothing is misspelled.
5. Delete the balance column and any opening-balance or "brought forward" row; those are not transactions.
6. Save as CSV, not as an Excel workbook.

Do one statement month first, import it, and look at the register. When the payees, signs and dates look right, stitch the remaining months together for that account and import the rest in one go. Our PDF to CSV page covers what to expect from a converted statement and where scanned PDFs need extra checking.

When this is not the right tool

If you use Quicken Classic rather than Simplifi, the CSV route described here is not the best one; Classic has its own importers, and our Quicken integration page covers the QFX side. If your bank connection in Simplifi is working and you only need the last few weeks, there is nothing to import at all. And if you need to bring years of history across many accounts, consider whether that history needs to live in a budgeting app, or whether a spreadsheet archive of the converted statements serves you better.

Related guides

• Import bank statements into Quicken (Classic)
• Convert PDF bank statements to CSV
• Quicken file formats and QuickBankConvert
• Free bank statement converter options