Skip to content

Import bank transactions from Excel to QuickBooks

Import and export are more time-saving options! You can import items including accountant’s changes, bank transactions, basic journal entries & batch transactions. Also, you can import the vendors and customers manually into QuickBooks online. The below article is rounded with the guide to import the bank transactions from Excel to QuickBooks.

Why Import Bank Transactions From Excel to QuickBooks?

You download the transactions automatically into QuickBooks Online. However, in some scenarios there require manual entry of the banking transactions like when the bank failed to link with QuickBooks. In this case, there is a need to transfer the banking transactions with Excel or QuickBooks online file.

How to Import Bank Transactions From Excel to QuickBooks?

The only data you require to link the bank account to QuickBooks is the login credential to the bank website. Once you enter the login credentials the QuickBooks will stay connected and download transactions. Here is the list of steps:

  • Search your Bank
  • Following are the steps:
  • Choose Transactions tab
  • Click on the Banking option from the left menu bar of the QuickBooks online dashboard
  • Hit to Banking Center tab in QuickBooks Online
  • Choose the green button named Connect account to add the bank account
  • Now link your first bank account in QB online
  • Find the bank by writing either the bank’s website URL or the bank name
  • In case the bank is not listed then you need to import the bank transactions with QB Online file/through Excel via a CSV file
  • Proceed to the bank sign-in window
  • Once chosen the bank, hit the option named green Continue to redirect to the sign-in Window

You May Also Read: How do I Export from Quickbooks to Excel

Step 2- Log in to the Bank Account:

  • Open the new browser window
  • It will open the sign-in to the bank account
  • Once you sign in to the bank there might display a prompt asking you to confirm that you need to share the banking data and provide an informative summary.
  • Once agreed then hit the appropriate tab to the bank confirmation window

Step 3- Connect Bank Accounts to Chart of Accounts:

  • Once returned to QuickBooks you are re-directed to an account list you have linked with the bank
  • Choose Bank account tab
  • Select link to Chart of Accounts option
  • Choose all of the bank accounts you would link to connect to QuickBooks Online
  • Next, hit on the account
  • There will display a drop-down field with bank accounts in the Chart of Accounts
  • If the checking account is in the Chart of Accounts then click on it

Step 4- Create a new checking account in the Chart of Accounts:

  • If the drop-down field of Chart of Accounts failed to include the checking account then hit Add new option
  • Now add a new account to the Chart of Accounts in QB online
  • The Account must be bank & detail type must be Checking tab
  • You must give a name to the account and recommend the bank name plus “Checking Account”
  • In case there are multiple than one checking account linked with the same bank then there might contains the account number’s last four digits.
  • Once entered the required information then hit on the green option named Save and then click the Close tab
  • It will redirect to the prior Window with the new selected new account

Also Read: Convert QuickBooks File to Excel

Step 5- Choose the correct Date Range:

  • Once you assigned the bank account to an account from the Chart of Accounts then you need to decide the option to pull transactions
  • Click on the beginning date to let transferring bank transaction
  • The default start date is the beginning of the year

FAQ’s:

Can I delete the import transactions that are too old?

Yes, you require deleting them manually

How would I need to review the downloaded transactions?

Use the Banking center option and review button to check the transactions.

How can I check the no of imported transactions?

The orange number that appears in the upper left corner of the Banking center window specifies the no of imported.

Things That Can be Imported to QuickBooks from Various Ways

Payroll Data to QBD ↗

Import Payroll Data into QuickBooks from Excel

Excel into QB ↗

Import Excel into QuickBooks Desktop & Online

Payroll Data to QBO ↗

Import Payroll Data to QuickBooks Online from Excel

Bank Transactions ↗

Import Your Bank Transactions Data Into QuickBooks from Excel

Wells Fargo Payroll ↗

Import Wells Fargo Payroll Details to QuickBooks

CSV Payroll Files ↗

Import CSV Payroll Files into QuickBooks

Payroll ↗

Import Payroll into QuickBooks

Payroll QBD to QBO ↗

Import Payroll data from QuickBooks Desktop to Online

Accountant’s Changes ↗

Import Accountant’s Changes In QuickBooks

Payroll IIF File ↗

Import Payroll IIF file into QuickBooks

Payroll QBO to QBD ↗

Import payroll from QuickBooks Online to Desktop

Payroll from XML ↗

Import Payroll Data to from XML to QuickBooks

Square Payroll ↗

Import Square Payroll Data into QuickBooks

Payroll Data ↗

Import Payroll Data into QuickBooks

Payroll Files ↗

Import Payroll Files into QuickBooks

Payroll Hours ↗

Import Payroll Hours into QuickBooks

ADP Payroll ↗

Import ADP Payroll Into QuickBooks Online & Desktop

CSV File ↗

QuickBooks Import to CSV Files

Payroll Template ↗

Import Payroll Template into QuickBooks

Accounts Details ↗

Import Accounts Details into QuickBooks

.QBB File ↗

Import .QBB file into QuickBooks

Employee Data ↗

Import Employee Data into QuickBooks Payroll

Payroll Timesheets ↗

QuickBooks Payroll Timesheet Import

Gusto Payroll ↗

Import Gusto Payroll into QuickBooks

IIF File ↗

Import IIF File into QuickBooks

Credit Card Transactions ↗

Import Credit Card Transactions In Quickbooks Desktop

Voluntary Payroll Deductions ↗

Import voluntary payroll deductions into QuickBooks

Transactions ↗

Import Transactions into QuickBooks

Payroll Items List ↗

Import Payroll Item list into QuickBooks

Payroll Transactions ↗

Import Payroll Transactions into QuickBooks

PayPal Transactions ↗

Import PayPal Transactions into QuickBooks

Import Issue ↗

QuickBooks Import & Export – Issues & Guides

Import Data Not Responding ↗

QuickBooks Import & Export – Issues & Guides

Transaction Pro Importer Error Message ↗

QuickBooks Transaction Pro Importer Error Message

Import Error

QuickBooks Import Error

Import Excel or Spreadsheet Not Responding ↗

Quickbooks Import Excel or Spreadsheet Not Responding

IIF Import Error 3040

QuickBooks IIF Import Error 3040

Import Support ↗

QuickBooks Import & Exports Support

Was this worth your time?

This helps us sort answers on the page.

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Leave a Reply

Your email address will not be published.


Disclaimer : We are a third party agency working on providing authentic support and full fledged services for for accounting software QuickBooks 2018 version. It is one of… Read more

Phone

+1-347-967-4080