QuickBooksImport bank transactions using Excel CSV files in QuickBooks

October 12, 2019by jsxCs5YWxv0

Want to know how to Import bank transactions using Excel CSV files in QuickBooks, But before going to the question, first of all, we should understand what are Excel CSV files, It is a simple file format used for tabulating, like a database or spreadsheet. If the file exists in CSV format, it can be imported or exported from a program that stores data in a table.

It is important to first disclose the following tips that I will discuss for importing invoices from CSV files to QuickBooks, only two versions of QuickBooks will work.

  1. QuickBooks Accountant 2014 to 2018
  2. QuickBooks Enterprise 2014 to 2018

If you have QB Pro, QB Premier, QB Mac that is irrelevant as this feature is not available in those versions.

The importance of connecting your bank account to QuickBooks

This is important because you can save a lot of time by downloading your banking transactions into QB instead of manually inserting each transaction. Most of the banks allow you to connect to QB quickly and easily.

How to import/ export CSV files

CSV files are simple files with tabular data, in this area, the file is separated from the next one or a single comma. Most spreadsheets support this format, although you can create and edit a CSV file with any text editor such as Notepad.

To import the CSV file in the CSV format firstly you need to install the QuickBooks Import Excel and CSV toolkits.

The CSV toolkit contains
  • Import from Excel and CSV Manual- means a PDF document with instructions for best practice and notes
  • CSV example folder-for sample CSV files, one for each type of list.
  • XLS example folder-a sample Excel file containing for worksheets, one for each type of list.
  • Allowed field-a reference guide explaining what fields are available for Excel and CSV import.

Steps to install the QuickBooks Import Excel and toolkit

  • First of all open the file download window for the toolkit
  • Select the save
  •  Then Go to your Windows Desktop, then select Save.
  • Double click on QuickBooks Import Excel and CSV.exe on your Windows desktop
  • To open the WinZip Self-Extractor window.
  • Select  the Browse
  • And then choose the folder where you want to install the toolkit (such as your Desktop), then OK.
  • To Select Unzip and to extract the contents,
  • And then click Close to close the WinZip Self-Extractor window.
  • Open QB import excels file.

How to Export CSV files?

If you do not have MS Excel installed on your computer, you can use the export list as a CSV file if you want to view and edit your data in a different format.

Customer and vendors
  1. First of all, open the customer/Vendor center
  2. Select the excel dropdown
  3. And then choose
Export Customer/Vendor list

The function of this list is to export customer/vendor data such as name, balances and contact information.

Export Transactions

The function of this list is to export transactions (either by name or transaction type).

  1. To choose Create a comma-separated values (.csv) file.In the Export window
  2. Go to Export.
  3. To Assign a filename, when you choose the location where you want to save the file.
  4. Locate, open, and edit the file as needed.
Items
  • Firstly go to the list menu then select the item list.
  • Select the excel Drop-down
  • Then choose the export all item.
  • In the export window, choose create a comma separated value(.csv files).
  • To select the export.
  • Assign a filename, then choose the location where you want to save the file
  • Locate, open, and edit the file as needed.

What is the process of Import bank transactions using Excel CSV files in QuickBooks?

You can use these given instructions to Import bank transactions using Excel CSV files in QuickBooks. This is important because it saves your time compared to working manually. In this event, you will need your online banking user ID and password to log in to your bank account. You will only need to enter this information, then the QB will be connected to your bank account for downloading transactions daily.

The following procedure is performed to import a bank transaction using an Excel CSV file in QB.

Locate your banks

To locate your bank, you can do one of the following steps. Type your bank name in the search box. Select from the bank list just below the search box.

Log in to your bank account

Enter the user ID then you normally use access to your bank account. It depends on your internet connection and the number of accounts you have. QB online takes a few minutes to connect to your bank account.

Select bank accounts

Your bank will list all the accounts that you have. And select only the business accounts you want to connect to QuickBooks.

  • Select each bank account you want to connect to the QB by clicking in the row of the bank account.
  • Enter the account holder’s name.
  • The following account setup window should then appear on your screen.
  • Complete the fields and type below to set up a bank account in QB.
To select the right date range

The maximum number of transactions that will download in 90 days.

If you need to download the banking transaction more than 90 days then you will need to IMPORT TRANSACTION  IN QB USING EXCEL CSV FILE.

Click connect

Before clicking the connect button, double-check to make sure that you have not selected an account from which you do not want to import transactions into QB

Review the download of the transaction.

How to report?

When you have any problem with import/export I will tell you how to report. Firstly go to the list menu then select the item list.

  • Select the Excel drop-down,
  • Go and choose Export all Items.
  • In the Export window, choose to Create a comma-separated values (.csv) file.
  • Select Export.
  • Assign a filename,
  • then choose the location where you want to save the file.
  • Locate, open, and edit the file as needed.

The above information for you. If you have a problem related to import bank transactions using Excel CSV files in QuickBooks then you can solve your problem by reading the above information. But I hope that if you read carefully then you will not face any problem related to this topic.

Leave a Reply

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

Call Now