Bank Not Listed in QuickBooks Online? Your Options

When your bank is not listed in QuickBooks Online, search again with a shorter name or the bank's web address, then try its parent bank. If it still does not appear, use Request a provider and keep the account current with file uploads: a CSV or QBO file from the bank, or one made from the statement PDF.

Is the bank really missing, or is the search too narrow?

A bank that seems missing from the QuickBooks Online search is often there under a slightly different name. The search matches the provider list, not your statement letterhead, so a long or exact name can miss. Search with fewer words first, then try the alternatives below before deciding the bank is truly absent.

Search habits that find more banks:

• Use one distinctive word. "Summit" finds more than "Summit Community Bank, N.A."
• Leave out generic words. Bank, credit union, savings, federal, N.A. and Inc appear in thousands of names and add little.
• Try abbreviations both ways. "FCU" and "Federal Credit Union", or "First National" and "FNB".
• Try the web address. Intuit's help on bank errors when downloading transactions tells you to find and select your bank, or copy the listed URL. The URL shown under each result is a quick way to pick the right one.
• Check the result's web address before you sign in. Several banks can share a name in different states. The address should match the site where you sign in to online banking.

If you find the bank but the account you want is not offered after you sign in, the bank is listed and only that account type is not shared. That is a different problem from a missing bank, and the answer is usually a file upload for that one account.

Banks that connect under a different name or web address

Some banks connect to QuickBooks Online under a name that is not on your card or statement. Regional brands, merged banks and online banks run by a larger partner bank are the usual cases. If the brand name fails, search for the parent company or for the domain of the online banking site where you sign in.

Places to look for the name the search might know:

1. The small print on your statement. It often names the legal bank behind a brand, for example "Banking services provided by" a partner bank.
2. The address bar when you sign in. A sign-in page on a different domain from the bank's marketing site points to the platform the bank uses.
3. The bank's help pages. Many list "QuickBooks" or "accounting software" with the exact name to search for.
4. A recent merger notice. After a merger, the old name may vanish from the list before your logins change, or the new name may appear before your accounts move.

Credit unions and very small banks are the most likely to be missing for real. They also tend to offer a CSV or QBO download on their own site, which covers the gap well.

Does Request a provider connect your bank?

Request a provider does not connect anything. It asks Intuit to consider adding your bank to the list. Intuit's page on connecting bank and credit card accounts says to use it when you cannot find your bank but can sign in to its website. It gives no timeline and no promise that the bank will be added.

So send the request, then plan as if the answer will be no. Books need to stay current in the meantime, and a request can take months or never succeed, because adding a bank depends on the bank sharing data.

Two details from the same Intuit page are worth checking while you wait:

• QuickBooks Online Free and Lite have limited bank connection features. If you are on one of those, ask Intuit whether your plan is the reason before you assume the bank is missing.
• An accountant cannot connect a bank for a client. If someone else set up your file, the owner or an admin has to sign in for the connection.

A decision checklist from search to upload

Work through these in order and stop at the first one that works:

1. Search with one distinctive word from the bank's name.
2. Search with the bank's web address or the parent bank's name.
3. Sign in and confirm the account you need is offered, not only other accounts at the same bank.
4. Send Request a provider, once.
5. Check whether the bank's website offers a QBO, QFX or CSV download, and how many months it covers.
6. If it offers only PDFs, plan to convert each statement.
7. Set a monthly date for the upload and the reconciliation, and keep to it.

Steps 1 to 3 take a few minutes. Steps 5 to 7 are what keep the books current for as long as the bank stays off the list.

Uploading bank files when the bank is not listed

Uploading files is the standard route when the bank is not listed. On the Bank transactions page, open the Link account dropdown, choose Upload from file, pick the file and the QuickBooks account, then follow the screens. Intuit suggests a QBO file and also accepts QFX, CSV, OFX and TXT files.

Intuit's page on manually uploading transactions sets the limits:

If a year of transactions breaks the size or row limit, download in smaller date ranges, such as a quarter at a time.

Each uploaded line brings the file's description text with it, separate from the payee you choose. Bank Detail in QuickBooks Online explains where that original text is shown and why it helps when you match lines later.

A monthly routine keeps an unlisted account no harder than a connected one:

1. On the first working day of the month, download last month's file from the bank.
2. Upload it to the same account in QuickBooks.
3. Review the lines in For review, as you would for a feed.
4. Reconcile against the statement.

Turning statement PDFs into an upload file for an unlisted bank

When an unlisted bank offers only PDF statements, the PDF has to become a CSV or QBO file before the standard upload will take it. You can retype the lines into a spreadsheet, convert the PDF with a tool, or try any statement upload option QuickBooks offers in your account.

Intuit's upload page also describes adding a statement as a PDF or image file, such as JPG, PNG or HEIC. If that option appears in your account, check every line it reads against the statement before you accept it, and compare the closing balance.

Retyping works for a few lines a month. For a busy account, check these points whatever method you use:

• Dates are in one consistent format, with the right year.
• Withdrawals and deposits have the right signs.
• The file's total change equals the statement's closing balance minus its opening balance.

SimpleBankConvert is being built for exactly this case: it reads the PDF statement and gives back a CSV or QBO file for the QuickBooks Online upload, with dates in one format and money going out shown as a minus.

If you have been keeping the books in a spreadsheet because the bank would not connect, the move into QuickBooks is a project of its own. Switching from Excel bookkeeping to QuickBooks covers choosing a start date and bringing balances across.

An unlisted bank account set up twice by mistake

The most common mistake with an unlisted bank is creating a new QuickBooks account on each upload, or a second one when the bank is finally listed and connected. Every upload and every connection should point at the same existing account in your chart of accounts. Two accounts split one bank's history in half.

How it happens:

• On the upload screen, someone picks the option to add a new account instead of choosing the existing one.
• Months later the bank joins the list, and the connection screen offers a new account instead of the one fed by uploads.
• A second person uploads to an account with a similar name, such as "Checking" and "Business Checking".

How to prevent it:

1. Give the account a clear name with the last four digits, such as "Summit Checking 7721" (an example).
2. On every upload and connection, pick that account from the list rather than adding one.
3. When the bank does become available, choose a feed start date the day after your last uploaded transaction.

If two accounts already exist, stop using one, move its transactions to the other and make the extra one inactive. The same care applies when an account has to go to a different company file; moving a bank feed to a new QuickBooks company walks through linking to the right account and choosing a start date with no overlap.

Keep the statement PDFs either way. QuickBooks does not collect them from the bank for you, as getting bank statements from QuickBooks Online explains, and for an unlisted bank they are the only full record you have.