How to import bank transactions into QuickBooks Desktop

Your bank hands you a spreadsheet. QuickBooks Desktop won’t take it, and the menu gives you no clue why. Here’s the route in, and the one thing that blocks most people before they get started.

Why the spreadsheet bounces

Desktop pulls transactions in two ways, and both end in the same file format.

Direct Connect links QuickBooks straight to your bank. You enter the credentials your bank issues, and transactions arrive without you fetching anything. Not every bank offers it, and some charge for it.

Web Connect is the manual one. You download a file from your bank’s website and import it yourself.

Here’s the part that catches people. Web Connect only works with .qbo files. A QFX won’t go in. Neither will a QIF, and neither will the CSV or Excel file most banks hand out by default. Intuit says so plainly on the same page.

That’s the whole problem. Your bank gives you a spreadsheet, Desktop wants a bank file, and nothing on the import screen explains the gap.

How to import a bank file into QuickBooks Desktop

Seven steps, from Intuit’s own setup page. Back up your company file before you start.

1. Get the .QBO file. On your bank’s website, find the download option for the account. Look for QuickBooks, Web Connect or QBO. Every bank puts this somewhere different.
2. Set a date range if the bank offers one. Some do. If yours doesn’t, you get whatever it gives by default, which may be 30, 60 or 90 days.
3. Open the import screen. In QuickBooks, go to Banking, then Bank Feeds, then Import Web Connect Files.
4. Pick the file you just saved, and choose Open.
5. Tell it which account the money belongs to. Choose an existing QuickBooks account, or create a new one if this account isn’t in your books yet.
6. Choose Continue, then OK when it confirms the file has been read.
7. Open the Bank Feeds Center to review what came in. Nothing posts to your books until you add or match each transaction.

Step five is worth slowing down on. Match the account type to what your bank calls it. Checking, savings and money market all map to a Bank account in QuickBooks. A credit card maps to Credit card.

If your bank offers Direct Connect instead

Direct Connect skips the download. QuickBooks talks to the bank itself, so there’s no file to fetch and no import screen to find.

Setting it up runs through the Banking menu. Choose Bank Feeds, then Set up Bank Feeds for an account, and type your bank’s name. If this is your first time, the Enrollment Site link takes you to the bank to apply. Some banks have to approve you before it works. Once you’re enrolled, enter the user ID and password your bank issued, choose Connect, pick the account, and finish.

Have the account number and the nine digit routing number to hand. The routing number is on a check, and your bank will give you both if you can’t find them.

After that, pulling transactions is four clicks. Go to Banking, then Bank Feeds, then Bank Feeds Center. Pick the account, choose Download Transactions, then synchronize this account or every account at that bank. Enter your PIN when it asks.

The first pull takes as much history as the bank allows. Some give up to a year. Most give around 90 days, so don’t count on pulling a whole year of back records this way.

When your bank has no QuickBooks download

Plenty of banks dropped the QuickBooks format, or never offered it. You open the download menu and the only choices are CSV and Excel.

Retyping a month of transactions is one way through. The other is to turn the spreadsheet into the file Desktop actually wants.

That’s what FileInto does. It reads the CSV or Excel file your bank gave you and writes the .QBO. That file goes in through the same Import Web Connect Files screen as any bank’s own download. The conversion runs inside your browser tab, so the statement is never uploaded anywhere. Every converter previews every row at no charge, and files up to 25 transactions download without an account.

One thing to know before you go looking for a workaround: a .QFX is the Quicken version of the same file, and Desktop refuses it. If your bank offers QFX and nothing else, the QFX file explained covers what it is and why Quicken and QuickBooks each want their own.

What people hit next

You can’t import the same transactions twice. Desktop won’t download into the same company file more than once. Your bank may be able to reopen them on their side, so call them if you need a second pass.

Deleting downloaded transactions is final. Once you delete them from the Bank Feeds Center, you can’t download them again. That’s the behavior that stops duplicates, and it bites if you clear the list before reviewing it.

Forty accounts is the ceiling. One company file connects up to 40 bank and credit card accounts. Past that you split them across company files.

Check what you already have before importing. Overlapping date ranges are the usual reason a transaction shows up twice, so look at the last date in the account first.

Ask your bank what it charges. Some banks bill for Direct Connect and give Web Connect away. It’s worth knowing which before you set anything up.