How to import bank transactions into QuickBooks from Excel

How to import bank transactions into QuickBooks from Excel

QuickBooks accounting software is developed to grow small businesses. The implementation of the software to the business eases the tasks to create invoices, track expenses, smoothly import complete bank transactions from excel and many more.  Your entire bank transactions can be imported into QuickBooks from Excel by using a feature known as “Batch Entered Transactions”. Download all the bank information including debits, credits, deposits, withdrawals and all the banking activity. There may be huge number of transactions but it is very easy to bring up all the transactions in the minimum time using Excel. If you are not used to excel then here is the easy way of “How to import bank transactions into quickbooks from Excel” with nothing else required.

How to import bank transactions into QuickBooks from Excel?

Quickbooks support number for quickbooks queries

Here is how to import bank transaction into quickbooks from Excel. Incase you are not able to follow along and if you miss out on something then you can get in touch with us at our US/Canada helpline number.

  • Clean up the data: There is couple of useless things in the transactions that is not required. So you need to copy those things and clean it all properly by find and replace option. Easily clean-up bank the unnecessary bank transactions you have downloaded into a CSV or Excel format.
  • Separate/Split deposits from withdrawals or the debits from credits: You can edit multiple vendors and customers using the specific tool to add or edit Multiple List Entries tool. It is very simple process. Select and sort by the amount, which will give you the amount all in an order. Copy all the transactions of debit, then cut and paste in a new sheet sorting it with date wise. The dollar sign before the amounts needs to be removed as QuickBooks does not accept dollar sign.
  • Go to the Accountant menu and choose Batch Entry Transactions: Copy and paste the transactions from Excel into QuickBooks using the Batch entry transaction feature found only in QuickBooks Accountant version. Import Customers/vendors. Going to the excel check that the configuration of the columns as the spreadsheet should match with the QuickBooks.
  • Copy & Paste checks/debits: Copy and paste it in QuickBooks. Check that the column configuration matches excel. Customize columns in QuickBooks. Check for the negative symbol or dollar sign as QuickBooks do not understand these symbols. QB will have a quick check over the list of vendors that is better than manual entry. Save all the changes once done with the configuration of data into QuickBooks.
  • Finally Reconcile: After finishing the data entry and go through the reconciliation process put the actual ending balance from the statement. All imported data and transactions entered are automatically going to reconcile. Reconcile all the transaction in a single go within QuickBooks. No need of manual reconciliation because you have pushed 100% of the bank data into QuickBooks. Now you are sure that all the back information is in QuickBooks.
  • Reclassify Statements: You need to further classify the account into income and expenses. By using the Reclassify Transaction feature you can sort function quickly to assign transactions to their appropriate accounts in QuickBooks. This technique is useful to bring thousands of transactions in a minute. Now you have to choose client data review and reclassify transactions. This feature is exclusive in the Accountant edition of QuickBooks.

For e.g. the deposits under the income category can vendor’s refunds, capital from the owner etc. Sorting the income category by the particular name will help to classify properly.  It is a two-fold technique:  Print data into QB & use the batch reclassify to classify correctly.

Related articles:

Even after following the steps recommended for data import to QuickBooks from spreadsheet by Intuit, you are having any kind of technical or functional contact QuickBooks customer support immediately. The QuickBooks expert ProAdvisors will help you get every resolution possible, this will then help fix your issues. If you need to reach out to QuickBooks professionals then you can directly dial them. If you need to chat with them then support is also provided via chat support. Thus if you are still facing issues then wait no longer and get back in touch with QuikBooks proadvisors at now.

Though we have tried to answer your query to the fullest, if you are still facing issues with quickbooks then you can get it all sorted by using quickbooks pro support number for Canada and US at 1800-940-7442.


Report Your Issue

(Didn't find what you were looking for! Report your issue and get customized help from our QuickBooks experts.)

QuickBooks Version:
Edition Year:
No of User: Licence
HELP Needed:
Operating System:

What is Qbpro?

We are a Quickbooks and TurboTax consulting firm that takes care of all the issues that people might ever face within these programs. If you are using any of the above platforms and are continuously faced with bugs then we are here to help. You can connect with us for errors related to Quickbooks or TurboTax via any of the medium below:

What Our Clients Say...

Here is what people have to say about us.

Areas we serve:

We are proud to announce that we are covering entire Canada. Thus if you face any issues now, give us a call as our proadvisors work 24/7 to get your issues fixed.

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Me

Leave a Message

Disclaimer: is a reputable QuickBooks® Consulting firm that provides professional support services related to your accounting software. It is also a front-runner in providing 3rd party technical support services for quickbooks.


"Get QuickBooks Support, no matter where you are living in Canada. Just Call and get issues fixed."

Alberta British Columbia Manitoba New BrunswickNewfoundland and Labrador Northwest Territories Nova ScotiaNunavut Ontario Prince Edward Island Quebec Saskatchewan Yukon


Are you confused and not able to manage your books on QuickBooks…!

Dial us: ✆ +1800-940-7442

Still facing issues

Get Help For Your QuickBooks Accounting Software

Resolve your every issue on a
Free 30 minutes call

Enter your details to get a cheat sheet of 96 awesome tricks to use Quickbooks like a pro.

We hate SPAM and promise to keep your email address safe.

Get FREE 30 minutes, Resolve your issues now!

Call Now: 1-800-940-7442