Connect bank and credit card accounts to QuickBooks Online
SOLVED•by QuickBooks•6959•Updated 2 weeks ago
Learn how to connect your bank and credit card accounts to QuickBooks Online.
When you connect your online bank in QuickBooks, the transactions automatically download and categorize. This helps you to save time in updating your bank feeds. All you have to do is to review and approve them.
If you used bank feeds in QuickBooks Desktop, you'll need to connect your bank/credit card accounts again in QuickBooks Online for security reasons. If you plan to import your data from Desktop, follow these steps before you connect your bank:
Find your most recently categorized transaction in QuickBooks Desktop.
Make a note of the transaction date.
Follow these steps to import your Desktop data. Note: It's important to do this before you connect your bank. Otherwise, your Desktop data will replace any downloaded bank transactions in QuickBooks Online.
Your categorized transactions will copy from Desktop to Online. Uncategorized transactions won't copy over.
To connect your bank to QuickBooks Online, continue reading this article. To avoid adding duplicate transactions, make sure to only pull transactions after the date in Step 2. You can do this by changing the transaction pull date while you're connecting your bank:
If you miss that step and download duplicate transactions by mistake, don't worry. You can exclude them from your books during the review process.
To watch more how-to videos, visit our video section.
Step 1: Connect a bank or credit card account
Connect your bank or credit card account so you don’t have to manually enter your transactions. You can also connect multiple businesses and personal bank accounts to keep your business information up to date in QuickBooks.
Go to Transactions, then select Banktransactions (Take me there).
Select Link Account.
Enter the URL or name of your bank in the Search field, then select the bank. Note: If you can’t find your bank, you can manually upload transactions instead.
Enter your Sign info in the Login and Password fields, then select Continue.
Select the account that you want to connect and date to pull transactions from the dropdown ▼. Then, select Next. Note: Some banks let you download the last 90 days of transactions. Others can go back as far as 24 months.
Select your account type on the Account type ▼ dropdown, then select Next. Note: Choose the account type that matches your chart of accounts in QuickBooks. If you don’t see the correct account type, select +Add new.
For new bank accounts:
In the Account Type ▼ dropdown, select Bank.
In Detail Type, select Savings or Checking.
Give the account a name and then select Save and Close.
For new credit card accounts:
In the Account Type ▼ dropdown, select Credit Card.
Give the account a name and then select Save and Close.
Map the bank account in the Existing accounts ▼ dropdown, then select Next.
Select Connect, then select Done. Note: You can edit the account name in the New account name field or change it later.
Go to Settings ⚙, then select Chart of accounts (Take me there).
In the Action column, select the View register ▼ dropdown. Then select Connect bank.
Enter the URL or name of your bank in the Search field, then select the bank. Note: If you can’t find your bank, you can manually upload transactions instead.
Enter your Sign info in the Login and Password fields, then select Continue.
Select the account that you want to connect and date to pull transactions from the dropdown ▼. Then, select Next. Note: Some banks let you download the last 90 days of transactions. Others can go back as far as 24 months.
Select your account type on the Account type ▼ dropdown, then select Next. Note: Choose the account type that matches your chart of accounts in QuickBooks. If you don’t see the correct account type, select +Add new.
For new bank accounts:
In the Account Type ▼ dropdown, select Bank.
In Detail Type, select Savings or Checking.
Give the account a name and then select Save and Close.
For new credit card accounts:
In the Account Type ▼ dropdown, select Credit Card.
Give the account a name and then select Save and Close.
Map the bank account in the Existing accounts ▼ dropdown, then select Next.
Select Connect, then select Done. Note: You can edit the account name in the New account name field or change it later.
Go to Transactions, then select Banktransactions (Take me there).
In the Link account ▼ dropdown, select Manage connections.
Select the bank to expand, then toggle on the account you want to connect.
Review the prompt, then select Enable now. Select the account you want to connect to.
Select a date to pull transactions from the dropdown ▼, then select Next. Note: Some banks let you download the last 90 days of transactions. Others can go back as far as 24 months.
Select your account type on the Account type ▼ dropdown, then select Next. Note: Choose the account type that matches your chart of accounts in QuickBooks. If you don’t see the correct account type, select +Add new.
For new bank accounts:
In the Account Type ▼ dropdown, select Bank.
In Detail Type, select Savings or Checking.
Give the account a name and then select Save and Close.
For new credit card accounts:
In the Account Type ▼ dropdown, select Credit Card.
Give the account a name and then select Save and Close.
Map the bank account in the Existing accounts ▼ dropdown, then select Next.
Select Connect, then select Done. Note: You can edit the account name in the New account name field or change it later.
Step 2: Download recent transactions
Refresh your bank feed to automatically download your recent bank transactions.
Go to Transactions, then select Banktransactions (Take me there).