Contact Quickbooks Consulting and Know How to Import Bank Transactions using Excel CSV files

In this article you will learn how to import bank transactions using Excel CSV files in Quickbooks. To know more contact Quickbooks consulting. 

Using Excel CSV (comma-separated values) files you can import bank transactions to QuickBooks Online.

Make sure your file doesn't break any of the following formatting restrictions, if you feel any issues while importing your CSV file:

• Correct that transactions, displaying the amount in the Description column

• If the word amount appears in the name of the Credit or Debit column remove it(Credit amount and Debit amount are not correct)

• The file should be saved as a Windows CSV file by MAC users.

• Standardize and correct the Date format into a single format 

• The day of the week included in the date column is provided by some banks. This format is not an acceptable format. Split the date and the day of the week to correct this into two separate columns.

• Highlight the column containing the date.

• Now, go to Data and then choose Text to Columns.

Choose the options given below follow the Convert Text to Columns Wizard:

• Original data type: Delimited

• Delimiters: Space

• Column data format: General

• Click on Finish.

How to import transactions from a CSV file?

Follow these steps to import transactions from a CSV file:

• Select Banking from the Left menu 

• Select Banking.

• Select File upload from the Update drop-down menu

• You can select Upload transactions manually if you’ve never connected an account.

• From the Import Data page, you can begin your upload (click on the Gear icon in Tools, choose Import Data, and then click on Bank Data).

• Click on Browse and then select the file that you have downloaded from your bank.

• Click on Next.

• Follow the on-screen instructions in the Upload file window if you haven't downloaded your CSV file yet and download your transactions. After you download, select the file you downloaded.

• Select the appropriate bank or credit card account from the QuickBooks Account drop-down list and click on Next.

• According to your CSV file format,map the statement fields and then click on Next.

• Click on the check boxes of the transactions that you need to import and then click on Next.

• Select Yes when asked whether you want to import now

• Click on Let’s go while importing the Completed notification appears.

• You are directed to the Downloaded Transactions window once the import is finished. The imported transactions will be displayed on the For Review tab so that you can review, add, or match.

To know more on how to import bank transactions using Excel CSV files in Quickbooks call Quickbooks consulting phone number 1 (855) 441 4436. Also, you can write us at support@quickbookconsulting.net. Feel free to reach us anytime; our team of executives is 24/7 available at your service.  For more information visit, www.quickbookconsulting.net.