To download bank transactions into QuickBooks Online, open Bank transactions, select Connect account, find your bank, sign in with your online banking login, pick the accounts and choose a start date. QuickBooks then pulls in new transactions automatically and lists them under For review, where you match, add or exclude each one.
Connecting a bank feed to QuickBooks Online
A bank feed is a live link between your bank account and QuickBooks Online, so transactions arrive without you uploading a file. You need your online banking sign-in, a phone or device for any security check your bank asks for, and a decision about the start date.
What you need before you start
Gather three things first:
- The online banking username and password you use on your bank's own website. If you cannot sign in there, QuickBooks cannot sign in either.
- Whatever your bank uses for a second check, such as a text code or an app prompt.
- A rough idea of the date your books should begin. The next section covers how to choose it.
Intuit's help page on connecting bank and credit card accounts adds a few limits worth knowing before you begin. QuickBooks Online Free and Lite have limited bank connection features. An accountant cannot make the connection for a client, so the business owner or an admin signs in themselves. And American Express Business accounts cannot be connected with this method.
The steps
- In QuickBooks Online, go to All apps, then Accounting, then Bank transactions.
- Select Connect account. If you already have one account connected, select Link account instead.
- Search for your bank by name and select it.
- Select Continue and sign in with your online banking credentials.
- Complete any extra security steps your bank asks for.
- Tick the accounts you want to connect, such as checking or savings.
- Choose a start date from the date range list.
- Select Connect, then Done.
If your bank is missing from the search but you can sign in on its website, the same page says to select Request a provider. That asks Intuit to add the bank. It does not connect anything today, so the later section on banks the feed cannot reach covers what to do in the meantime.
How often does the feed update?
After the first connection, QuickBooks keeps downloading on its own. According to Intuit's page on updating recent bank transactions, it downloads new transactions every night for most accounts, and some American Express accounts may update only two or three times a week. The nightly run normally starts around 10 PM Pacific, and if it fails, QuickBooks tries up to five more times over the next five hours. You cannot switch the automatic update off or choose which items it fetches.
To fetch sooner, open Bank transactions and select Update. Enter your multi-factor code if asked. The update can take a few minutes, and you can keep working while it runs.
What start date should the bank feed use?
Use the day after the last transaction already in QuickBooks for that account. That start date brings in everything new and nothing you have already entered. For a brand-new set of books, use the date your books begin, usually the first day of the year or the day the business opened the account.
Why the start date matters
The start date is the one choice in the setup that is hard to undo cleanly. If you pick a date too early, the feed downloads transactions you already entered by hand or imported earlier, and you then clear a pile of duplicates. If you pick a date too late, a stretch of history never arrives and your bank balance will not match QuickBooks.
The Intuit page says the available span varies by bank, from 90 days up to 24 months. A start date earlier than your bank allows does not fail; you simply receive what the bank supplies. So the date you type is a ceiling on how far back the feed goes, not a promise.
A worked example
These dates are examples only. Suppose a landscaping business has been keeping its checking account in QuickBooks Online by uploading files, and the last entry is 14 March. Connect the feed with a start date of 15 March. Everything from 15 March onward downloads once, and nothing before it does.
Now suppose the same owner is opening a new set of books for a new business, with the account opened on 2 January. Choose 2 January as the start date, and make sure the opening balance in QuickBooks matches the first line of the bank's January statement.
When the feed cannot reach back far enough
Sometimes you want history older than the feed can supply. Banks often limit how far back an automatic download reaches, so older months have to come from statements. The usual route is to turn the bank's statements into a file and upload it. How to import older bank transactions into QuickBooks Online covers that route. Do it before or right after connecting the feed, and keep the date ranges from overlapping.
Reviewing downloaded bank transactions: match, add or exclude
Every downloaded transaction waits in the For review tab until you decide what it is. You have three choices. Match links it to something you already recorded, Add records it as a new transaction, and Exclude hides it because it does not belong in these books. Nothing counts in your reports until you act.
Intuit's article on finding downloaded transactions puts it plainly: transactions won't appear on your books until they are categorized. The tabs are For review, Categorized and Excluded.
The decision table
| Choice | Use it when | Example |
|---|---|---|
| Match | You already entered this payment or deposit yourself | A $480.00 customer deposit on 6 March that you recorded when the invoice was paid |
| Add | The bank line is new to QuickBooks | A $38.40 payment to a software vendor you never entered |
| Exclude | It is personal, or it duplicates a line already in the books | A $62.15 grocery purchase made on the business card by mistake |
All figures are made up for illustration.
Matching in practice
Match is the choice that keeps your books clean when you record invoices and bills as they happen. QuickBooks suggests a match when an amount and date line up with an existing entry. Check the suggestion before accepting it. Two $480.00 deposits a week apart are different customers, and a wrong match quietly leaves one invoice open.
Adding in practice
When you add a transaction, you choose the category, and for expenses the payee. The category tells QuickBooks which account the money belongs to, such as software, fuel or sales. Anything you leave uncategorized lands in the Uncategorized Income or Uncategorized Expense account, which is where you look later if something seems to have vanished.
Excluding in practice
Exclude is for lines that should never reach the books. An excluded line moves to the Excluded tab and is not added to your accounts. If you exclude one by mistake, the same Intuit page says to select Undo and then categorize it from For review. Leave lines you want kept out sitting in the Excluded tab rather than deleting them.
A daily or weekly habit
Review the tab on a fixed schedule. A weekly pass keeps the list short enough to read line by line. A month-end pass means hundreds of lines at once, which is how wrong categories slip through.
Bank rules that categorise feed transactions for you
A bank rule is a saved instruction that sorts feed transactions automatically. You describe a pattern, such as a payee name containing a vendor, and tell QuickBooks which category to apply. The next time a matching line downloads, it arrives already categorized and waiting for you to confirm.
Which transactions suit a rule
Rules work best on lines that repeat with the same text and the same destination: monthly software charges, a fuel station, the payment processor's fee, a phone bill. They work badly on a payee that serves several purposes. A hardware store might be supplies one week and equipment the next.
Building a rule from a real line
Start from a transaction you have just reviewed. Choose the vendor text that stays the same each time, not the part that changes, such as an invoice number or a date. Set the category, and for a payee that always gets the same treatment, set the payee name too.
For example, if the bank prints "ACME HOSTING 0412" one month and "ACME HOSTING 0512" the next, the rule should look for "ACME HOSTING" and ignore the digits. A rule keyed to the full string would miss next month's line.
Keep rules under review
A rule that is wrong repeats its error every month. Check the Categorized tab after you create one, and look again after a few weeks. If a vendor changes how it labels charges, a rule can stop matching and the lines return to manual review, which is a harmless failure. The harmful failure is a rule that is too broad and files unrelated spending under the wrong account.
Is a bank feed connection safe to set up?
A bank feed asks you to sign in with your online banking login, and that deserves a careful answer. The sign-in goes through your bank's own security checks, so the extra steps you see, such as a text code, come from your bank. Beyond that, how Intuit stores and uses the connection is a question for Intuit's own security pages.
What you can check for yourself
Intuit's connection page says each bank has its own security features and that the sign-in may require extra steps. The consent window that asks you to tick accounts is described as being for security purposes only. Treat the practical checks as yours to do:
- Start the connection from inside QuickBooks Online, not from an email link.
- Use a banking password you use nowhere else, and keep multi-factor checks switched on at the bank.
- Connect only the accounts the books need. Leave a personal savings account out of a business file.
- Remove the connection when you close an account or a bookkeeper leaves.
Who can see the transactions
Anyone with access to the QuickBooks Online company file and the banking area can see downloaded transactions. That can include your bookkeeper and accountant. Give each person their own sign-in rather than sharing yours, and remove access when the work ends.
Where a feed fits against a file upload
Some owners prefer not to connect a feed at all. That is a legitimate choice. You can download statements from the bank and upload them as files instead, which gives you a fixed set of transactions to check before anything enters QuickBooks. QuickBooks import transactions compared sets the feed and the file upload side by side.
Banks the QuickBooks Online feed can't reach
If your bank does not appear in the search, QuickBooks cannot download from it directly. You still have options. You can ask Intuit to add the bank, upload a file of transactions, or enter the few missing items by hand. A missing bank is a setup choice, not a dead end for your books.
Step 1: request the bank
On the connection screen, search for your bank. If it is absent but you can sign in on its website, select Request a provider. This sends a request to Intuit. It does not set up a feed for you, so plan to use a file in the meantime.
Step 2: bring transactions in as a file
Intuit's page says that when a bank does not connect directly, uploading a downloaded file is the way in. QuickBooks Online takes CSV and QBO files for this. Most banks let you download one from the transactions screen on their website. If your bank gives you only a PDF statement, how to upload bank statements to QuickBooks Online covers the ways to bring it in.
SimpleBankConvert is being built to turn a PDF statement into a CSV or QBO file that QuickBooks Online can upload. Accounts are not open yet; join the list at Get started to hear when they are.
Step 3: decide whether manual entry is enough
For a very small number of transactions, typing them in is quicker than preparing a file. How to manually add a transaction in QuickBooks Online covers it. The break-even point is a handful of lines. Past that, a file saves time and avoids typos.
Accounts that cannot be connected
Some accounts never connect: American Express Business accounts, as Intuit's page notes, and accounts at institutions that offer no online access. For these, plan a regular file upload and keep a short checklist: download, upload, check the closing balance against the statement.
When the feed falls short
A feed is convenient until it stops, skips a week or starts at the wrong date. QuickBooks not downloading bank transactions explains how to diagnose a stalled feed. Downloading bank transactions into QuickBooks Desktop covers the other product, which uses different connection methods. Read the first before you need it.