Yes, you can import a checking account into Quicken, but the method depends on your bank and which version of Quicken you use

Quicken supports checking account imports through three main routes: direct connection to your bank (called Quicken Connect or One Step Update, depending on your version), manual CSV file import, and OFX file import. Not every bank works with every method, and some banks have stopped supporting direct connections entirely. The fastest route is usually direct connection if your bank participates, but you should verify this before you start.

The process itself is straightforward once you know which method your bank supports. You'll need your online banking login credentials, and in some cases you'll need to authorize Quicken to access your account through your bank's security settings. The import pulls transaction history and your current balance, then matches those transactions to entries you've already made in Quicken if you've been tracking manually.

Key Takeaways

  • Direct bank connection is fastest if your bank supports it, but you must verify this before starting because many banks have discontinued this service.
  • If your bank doesn't support direct connection, you can export transactions as a CSV or OFX file from your online banking portal and import that file into Quicken instead.
  • You will need your online banking username and password, and some banks require you to authorize third-party access through a separate security step.
  • Quicken can match imported transactions to ones you've already entered manually, but you should review the matches before confirming to catch errors.
  • The import brings in transaction history and your current balance, but the amount of history available depends on what your bank's online portal shows you.

How direct bank connection works in Quicken

When you set up a direct connection, Quicken communicates with your bank's servers to pull your transactions automatically. In older versions of Quicken (Desktop 2018 and earlier), this was called One Step Update. In newer versions and Quicken Online, it's called Quicken Connect. The names changed, but the concept is the same: you authorize Quicken once, and it retrieves your data without you having to manually read anything.

To set this up, you'll go to the account setup screen in Quicken, select your bank from the list, and enter your online banking credentials. Quicken then tests the connection and, if successful, begins pulling transactions. Some banks ask you to complete an additional authorization step through your bank's website or app—this is a security measure and is normal. Once authorized, Quicken can update your account on a schedule you set, usually daily or weekly.

The catch: many banks have stopped supporting this connection method. Chase, Bank of America, Wells Fargo, and several others discontinued direct connections to Quicken between 2018 and 2023. If your bank is one of them, you'll see an error message when you try to connect, and you'll need to use one of the file-based methods instead.

Importing transactions using CSV or OFX files

If your bank doesn't support direct connection, you can read your transactions as a file and import them manually. Most banks offer two formats: CSV (comma-separated values, which opens in Excel) and OFX (Open Financial Exchange, which is Quicken's native format). OFX is usually the better choice because Quicken reads it without conversion, but not all banks offer it.

To do this, log into your online banking portal, find the read or export option (usually under "Transactions" or "Account History"), and select the date range you want. read the file to your computer. Then open Quicken, go to File > Import, select the file, and follow the import wizard. Quicken will show you a preview of the transactions before you confirm, so you can catch any formatting issues.

The main limitation is that most banks only let you read 90 days of history through their online portal. If you need older transactions, you may have to contact your bank directly or request a statement. Some banks allow you to read up to a year if you ask, but this varies.

What happens when Quicken matches imported transactions to existing entries

If you've been entering transactions manually in Quicken before importing, Quicken will try to match the imported data to what you've already recorded. It does this by looking at the date, amount, and payee name. When it finds a match, it marks that transaction as "cleared" and links it to the imported data.

This matching is usually accurate, but you should review the matches before confirming the import. Quicken sometimes matches transactions incorrectly if you have duplicate amounts on the same day or if you've entered a payee name differently than the bank shows it. You can manually adjust matches or mark transactions as unmatched if Quicken got it wrong. Once you confirm, the matched transactions won't be duplicated in your account.

Checking account balance and transaction history after import

After a successful import, your Quicken account will show your current balance as of the import date and all transactions from the date range you imported. The balance should match what you see in your online banking portal. If it doesn't, check that you imported the correct date range and that you haven't missed any pending transactions.

Quicken will also show you which transactions have cleared (matched to your bank's records) and which are still pending. Pending transactions are ones you've entered but haven't been imported yet, usually because they haven't posted to your bank account. As your bank processes them, you can update Quicken to mark them as cleared.

Troubleshooting common import problems

If your import fails or shows an error, the most common causes are incorrect login credentials, a bank that no longer supports the connection method, or a file format that Quicken doesn't recognize. Start by verifying your username and password in your online banking portal—sometimes banks require you to update your password before allowing third-party access.

If you're using a file-based import and the file won't open, check that you downloaded the correct format. Some banks label their files confusingly; a file named "transactions.txt" might actually be a CSV file. You can open it in a text editor to see the structure. If the first row shows column headers separated by commas, it's a CSV. If it contains XML-style tags, it's likely an OFX file.

If Quicken shows a message that your bank is no longer supported, contact your bank's customer service to confirm. Some banks have moved to a different service provider, and Quicken may regain support later. In the meantime, the CSV or OFX read method will work.

Frequently Asked Questions

Can I import multiple checking accounts at once?

Yes. You can set up direct connections or import files for as many accounts as you have. Quicken will create a separate account record for each one. If you're importing files, you'll do this one account at a time, but the process is the same for each.

Will importing overwrite transactions I've already entered manually?

No. Quicken matches imported transactions to existing ones and marks them as cleared rather than creating duplicates. If Quicken can't find a match, it adds the imported transaction as a new entry. You can review and adjust matches before confirming the import.

How far back can I import transaction history?

Most banks let you read 90 days through their online portal. Some allow up to one year if you request it. For older history, contact your bank directly. Quicken itself has no limit on how far back you can import once you have the file.

Do I need to keep my online banking password in Quicken?

For direct connections, Quicken stores your credentials securely and uses them to update automatically. For file-based imports, you don't store your password in Quicken at all—you log into your bank separately, read the file, and import it. You can delete stored credentials at any time if you want to stop automatic updates.

What if my bank changed and I want to import from the old bank's account?

You can import from closed accounts if you still have access to the online portal. Some banks keep closed accounts accessible for a limited time. If your old bank's portal is no longer available, you can request transaction history directly from the bank and import it as a CSV file.