How to Import Multiple Bank Accounts into QuickBooks
Convert a PDF bank statement to a QuickBooks file
Drop in a PDF statement and get a QBO (Web Connect) or IIF file you can import into QuickBooks Online or Desktop.
Short answer: You can load several bank accounts into QuickBooks by connecting each one to the bank feed, or by importing a separate file (QBO, QFX, or CSV) per account. The account is what matters: every import maps to one register in QuickBooks, so keep one file per bank account and import them one at a time into the matching account. For historical statements a live bank feed will not reach, convert each PDF statement to its own .qbo file and upload it to that account.
Two ways to bring multiple accounts into QuickBooks
Most businesses run more than one account: an operating checking account, a savings account, one or two credit cards, maybe a payroll account. QuickBooks handles all of them, but each account is imported separately. There are two supported paths. If your source files are spreadsheets rather than PDFs, running several account exports through one batch conversion saves repeating the process by hand for every account.
Direct bank connection (bank feed). In QuickBooks Online you go to Transactions, Bank transactions, then Link account, and sign in to each financial institution. Repeat for every account. QuickBooks pulls recent transactions automatically after that. This is the low-effort option for ongoing bookkeeping.
File upload, one account at a time. When the bank feed will not reach far enough back, or your bank is not supported, you upload a file per account. QuickBooks Online accepts a QBO (Web Connect) file, a QFX file, or a CSV. QuickBooks Desktop imports .qbo files under File, Utilities, Import, Web Connect Files. Either way, you pick the destination account first, then load the file for that account.
How do I import multiple bank accounts into QuickBooks Online?
Import multiple accounts by repeating the upload once per account. In QuickBooks Online go to Transactions, Bank transactions. If the account already exists, select its tile; if not, use Link account, then Upload from file. Choose the account you are importing into, upload that account's file, map the columns if prompted, and finish. Then start over for the next account. QuickBooks keeps each account's transactions in its own register.
One thing worth separating before you start: this page is about several accounts inside a single company file. If the accounts belong to different legal entities, they do not go in the same QuickBooks company at all, and the setup is a different one covered in our guide to bookkeeping for multiple businesses in QuickBooks Online.
The rule that keeps this clean: one file per account. Do not merge two accounts into a single import file. If checking and savings transactions land in the same register, your balances will never reconcile and untangling them is tedious. Keep the files separate and import each into its matching account.
Watch the QuickBooks Online upload limits
QuickBooks Online's manual upload has hard limits worth knowing before you start. An uploaded file must be 350 KB or smaller and contain no more than 1,000 lines, and the built-in PDF or image upload uses AI extraction with the same caps. For a business with a year of transactions across several accounts, those ceilings get hit fast. When a file is too big, QuickBooks tells you to shorten the date range and split the download into smaller batches.
A .qbo Web Connect file avoids the CSV column-mapping step and imports as clean, categorizable bank transactions. That is why converting each statement to .qbo is usually smoother than wrangling CSVs, especially across multiple accounts where every CSV might have a slightly different column layout.
Importing historical statements the bank feed cannot reach
Bank feeds typically only pull the last 90 days, sometimes up to a year for some banks. If you are catching up several months or several years across multiple accounts, the feed will not have that history. The reliable fix is to pull each account's PDF statements and convert them.
Run each account's statements through our PDF bank statement to QuickBooks converter to get a .qbo (or .iif for Desktop) file per account, then import each into its matching register. If you are onboarding a client or closing a full year across checking, savings, and cards, the batch statement converter processes a stack of statements at once so you are not converting them one by one. Credit card statements work the same way through our credit card statement to QuickBooks converter.
A clean order of operations for multiple accounts
- Set up the accounts first. Create each bank and credit card account in your chart of accounts before importing, so every import has a home.
- Decide feed vs file per account. Use the live bank feed for accounts you will keep syncing; use file upload for historical catch-up or unsupported banks.
- Convert historical statements per account. One statement set, one account, one .qbo file. Never combine accounts in a file.
- Import into the matching register. Select the destination account, then upload. Confirm the account name before you finish.
- Review, then categorize. Imported transactions land in For Review. Check them, then add or match them so each account reconciles cleanly.
Can I import checking and credit cards into the same QuickBooks file?
Yes. A single QuickBooks company file holds as many bank and credit card accounts as you need. Each one is a separate account in your chart of accounts with its own register. The same one-file-per-account rule applies when you import corporate card transactions from a Brex, Ramp, or Amex program. You import into each account individually, but they all live in the same company file and roll up into the same financial statements. The only thing to avoid is mixing transactions from two accounts into one import.
How do I keep the accounts from getting mixed up?
Name your import files by account before you start, and import to one account at a time. Confirm the destination account name in the upload dialog every time, because selecting the wrong account is the most common way transactions end up in the wrong register. If a batch does land in the wrong place, you can exclude and re-import it, though it is far easier to get it right the first time by keeping files and accounts strictly one-to-one. Money moved between two of your accounts needs its own care: record it once and match the other side so it is not counted twice, following how to record a transfer between bank accounts in QuickBooks.
Which import route fits each account
The right method depends less on the bank than on how far back you need to go and what the account actually is. This is the quick version.
| Account | Best route | Why |
|---|---|---|
| Main operating checking, current activity | Bank feed | Connects cleanly at most large banks and keeps itself current |
| Any account, months before you connected | Convert the PDF statement to QBO | The feed backfills a limited window and stops there |
| Business credit card | Feed, or convert the PDF statement | Card feeds often start later than the account did |
| Closed or switched account | Convert the PDF statement | A closed account cannot be connected at all |
| Treasury, sweep, or master concentration account | Convert the PDF statement | Usually a separate bank platform QuickBooks cannot connect to |
| Second entity in its own company file | Whichever route suits, per file | Accounts cannot be shared across company files |
How many bank accounts can you connect to QuickBooks Online?
There is no practical cap on how many bank and credit card accounts one QuickBooks Online company file can hold or connect. What limits you in practice is the bank side: each connection is made per financial institution login, so an owner with accounts at four banks makes four connections, and an account whose bank has no supported connection has to come in as a file instead. Add each account to the chart of accounts first, then connect or import into it.
Can I import two bank accounts at the same time?
No, and you should not want to. QuickBooks imports one file into one account per upload, and that constraint is what keeps the registers clean. Uploading a file that contains transactions from two accounts puts both sets of lines into whichever register you selected, which is tedious to unpick afterward. Convert and upload each account in turn; a stack of statements across several accounts still goes faster as a queue of single-account files than as one merged file you have to clean up.
Pooled cash, sweeps, and zero balance accounts
Companies with a treasury structure have an extra wrinkle: the operating account, a master concentration account, and one zero balance account per branch or entity all move money to each other automatically, every business day. Import them in the wrong order and the same dollars land in the books twice. Bring in the master or funding account first because it touches every other account, then import each subsidiary account and match the funding lines rather than adding them. The detail on that, including whether the sweep account belongs in your chart of accounts at all, is in the guide to recording bank sweep and zero balance account transfers.
After the import: matching and reconciling
Once every account is imported, QuickBooks shows the new transactions for review. Work through that queue deliberately rather than clicking Accept All; the walkthrough on reviewing imported bank transactions covers what to check on each line. Match them to existing entries where possible, categorize the rest (the monthly service charges and returned-item fees each account carries are covered in recording a bank fee or overdraft charge), and then reconcile each account against its statement ending balance. If an account's opening balance looks wrong after import, our guide on fixing a wrong opening balance after a QBO import walks through the fix. For a full month-end pass, see bank reconciliation from PDF bank statements.
If you would rather eyeball each account's transactions in a spreadsheet before importing, converting the statement into a clean workbook per account makes it easy to sort by amount and spot the transfers that appear on two statements at once.
The bottom line
Multiple accounts in QuickBooks is really the same task repeated once per account: connect the feed or upload a file, always one file per account, into the matching register. For history the feed cannot reach, convert each account's PDF statements to .qbo and import them. Keep the accounts strictly separate and reconciliation stays simple.
Skip the manual entry
Upload a PDF bank statement and get a QBO or IIF file ready to import into QuickBooks.
Convert a Statement Free