round button
Leave a message
Skip to content

How to Import Banking transactions in QuickBooks using Excel File?

QuickBooks is a widely used application among small and medium-sized businesses for accounting and related business processes. It provides technically advanced and innovative solutions for accounting related processes. If you use QuickBooks to manage your company accounts, then you need to enter all your banking transactions in it. You can import banking transactions in QuickBooks using Excel CSV file provided by your bank. Through this article, we will provide you with a detailed guide to import CSV file into QuickBooks.

“If you continue to face issues in importing banking transactions in QuickBooks, then contact us at our 1-(855)-542-9309 and talk to Pro Advisor Solutions’ Support Team for resolution”

You may also see: QuickBooks Error 590

Prepare CSV File to Import into QuickBooks Online

Before initiating the process to import into QuickBooks Online, you should prepare your CSV file. The CSV file needs to be in perfect order so that the QuickBooks application can read and process it smoothly. There are a few key points that you should take care of so that the data transfer is smooth and error-free. These points have been mentioned below for you:

  1. QuickBooks
    application has three different fields for banking transactions, namely Date,
    Description, and Amount. Ensure that you have your transactions maintained in
    this order. You should remove any other fields from your CSV file to avoid any
    issues.
  • It is mandatory
    that the amount is properly filled. If there is a transaction with nil amount,
    then put ‘0’ in it. Do not leave any Amount field with no value. This issue
    normally occurs if you have a 4-column CSV file, so carefully check your file.
  • No symbol is
    permitted in the Amount field, whether it be of currency or other signs such as
    a comma. Eliminate these signs before you proceed to export the file into
    QuickBooks.
Save Transaction Data as CSV
  • If the Amount field
    is in one column in your CSV file, then the minus (-) sign should be used to
    show the transactions for money going out instead of brackets {}.
  • Exclude the details
    that are not related to transactions from the CSV file. Information such as the
    account number, Opening and Closing balances should be removed to prepare your
    file for import.
  • Make sure that you
    save the file after making these changes and then proceed for data transfer.

After performing these steps, you are ready to import banking transaction in QuickBooks using Excel CSV file.

Steps to Import Transactions into QuickBooks from Excel

Now that you have prepared your CSV file according to the requirements of QuickBooks. Follow the steps as provided below in your QuickBooks application to Import transactions into QuickBooks from Excel.

  1. Open QuickBooks
    Online and then sign in with your login credentials.
  2. Go to the ‘Banking
    section and click on the ‘File Upload’ option.
  3. Click on the ‘Browse
    option in the dialogue box that appears.
  4. Choose the CSV file
    that you have prepared for import, from the given options.
  5. Click on the ‘Open
    option and then press the ‘Next’ button.
QuickBooks Map CSV Columns
  • You would be
    required to select a ‘Date’ and also a ‘Date format’.
  • Select the fields
    of ‘Description’ and ‘Amount’.
  • Click on the ‘Next
    button after the process.
  • You would be able
    to see all the transactions in your CSV file.
  • To remove a
    transaction, click on the check-box beside the transaction to unmark it.
  • Click on the ‘Next
    button and then click on ‘Yes’ to confirm.
  • Click on the ‘Let’s
    go
    ’ button and the import process will begin.

You will be notified when the process completes. You should check the entries again if the data has been imported correctly. If you observe any issues, you can perform the process again with the required transaction.

Errors when you Import Bank Transactions into QuickBooks Online

There are various issues that you can come across while import banking transaction in QuickBooks Online. These issues will either restrict you from importing the transactions or would import erroneous data. The issues and the respective methods to rectify them has been provided below for you:

Incorrect Mapping while importing CSV to QBO

Incorrect mapping of your CSV file will restrict QuickBooks from reading your data properly so you should make sure that you have selected the correct columns in the mapping stage. While importing CSV to QBO, delete the columns that are not required by QuickBooks besides that of Date, Description, and Amount to avoid any confusion. The names of columns in the CSV file should be the same as that in QuickBooks. It is suggested to rename the column names if they differ even slightly.

Formatting Issues while QuickBooks Online Import Invoices CSV

Different bank and financial institutions may create their CSV files differently that are used for QuickBooks Online Import invoices CSV. These formatting differences may create issues when you try to import. Some general methods to avoid formatting differences are as follows:

  • Keep
    the ‘Amount’ column as simple as possible. No symbols or commas should
    be used. You can edit it through right-click of your mouse and then pressing
    the ‘Format Cells’ option. You need to change this to ‘General
    if it is set to ‘Currency’.
  • If
    you have used special characters in the ‘Description’ column, then it
    can prevent you from importing the file. You should look for them and remove
    them to avoid any further issues. The special characters can be spotted easily
    by pressing the ‘Ctrl + H’ keys.
  • The
    date format should be consistent from the mapping stage. You should ensure that
    it’s correct. Highlight the date column, go to the ‘Number’ dropdown at
    the top of the screen. Click on the ‘Date’ option and then choose the ‘Short
    Date
    ’ option.
Fix CSV File Formatting Issues

You can copy the contents of your CSV file to a blank spreadsheet. This would reveal the data differently, which can then be spotted easily and corrected to import the file.

You may also read: QuickBooks XML Error

Through this article, we discussed the detailed steps to Import banking transactions in QuickBooks using CSV file. You should be able to import your banking transactions in QuickBooks easily through the steps provided above. If you are still struggling to perform these steps, then Pro Advisor Solutions’ Support at Toll-free Number 1-(855)-542-9309 and get assistance from our experts.

a