If you want to import bank transactions using Excel CSV files in QuickBooks, here we are going to explain how you connect your bank account to QuickBooks automatically. If you cannot find your bank in QuickBooks Online and if you want to download your banking transactions. Then, you will require to import your banking transaction in the form excel format which is called CSV or QBO file. CSV is a simple file format used for tabulating, like a database or spreadsheet. And, it can be imported or exported from a program that stores data in a table.
The process to 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. Make sure you format your CSV files for import.
Follow the “#1 Connect to your bank” to get the transaction of the last 90 days if your bank doesn’t support CSV files but offers Quicken (QFX), QuickBooks Online (QBO), or Microsoft Money (OFX). And “#2 Import Bank Transactions with Excel CSV files” to get the transactions of even earlier.
#1 Connect to your bank
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. This will only get the transactions of the last 90 days if you want more than you have to import it from an Excel CSV file.
1. 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.
From the left menu bar, select Banking. Then to locate your bank, you can do one of the following-
- Type your bank name in the search box
- Or, select from the list of banks right below the search box
2. Log in to your bank account
Enter the user ID and password 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.
3. 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.
4. 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 transactions in QuickBooks using Excel CSV file.
5. 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.
#2 Import Bank Transactions with Excel CSV files:
- Open your Quickbooks App and select the left Banking menu and select Banking.
- Click on File upload.
- Click on Browse and select the file you downloaded from your bank. If you don’t have the downloaded CSV file yet, follow the on-screen instructions in the Upload file window to download your transactions and then select the file you downloaded.
- Now choose Open and, then hit Next.
- From the QuickBooks Account drop-down list, select the bank or credit card account then tap on Next.
- Choose a Date, date format, Description, and Account.
- Hit Next and select the checkboxes of the transactions to import
- Select next and finally hit yes.
- End by clicking on let’s go!
- The files will start importing and a notification will appear when the task is completed.
How to import bank transactions with CSV files with a Tool kit
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.
FAQ’s (frequently asked questions)
How to review the download of transactions and to report?
Answer: 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.
How to Export CSV files?
Answer: 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.
- First of all, open the customer/Vendor center.
- Select the excel dropdown.
- And then choose the function of the Export Customer/Vendor list. This is to export customer/vendor data such as names, balances, and contact information.
- Now choose the function of the Export Transactions list. This is to export transactions (either by name or transaction type).
- Now reach out 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.
In the end:
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 in case you have any issues you can call us on our toll-free QuickBooks Online support number +1-844-519-0042 to get instant help. We have a team of ProAdvisors and Experts with great experience to assist you 24*7. So, get in touch with us whenever required. You can also contact us if you have any other queries or issues related to Quickbooks.
Keep Sharing, Keep Smiling:)