Skip to main content
L
Les9
May 13, 2020
Solved

Import bank transactions from Excel to QuickBooks

  • May 13, 2020
  • 3 replies
  • 0 views

Can I import bank transactions from excel files .CSV  to Quickbooks Accountant Desktop 2020?

Best answer by JasroV

Thanks for your response.

 

When I go to File > Utilities > Import > Excel Files

"Add or edit multiple list entries" - Manage your customer, vendor, and item lists all in one place. Paste from excel to quickly add new or edit existing entries. Choose :Lists > Add/edit multiple list entries to begin making multiple entries. If you'd like QuickBooks to take you there now, click Yes

 

I click no and I go to the screen called: "Add your excel data to QuickBooks". When I add my excel file, it says that "The excel file you're trying to import is not a QB supplier templated. The templates that you sent in your first response was for account list, vendor list, customer list and item list. My excel file is not any of those lists, the excel file that I want to import has information about bank transactions, in 3 columns:

| Date | Description | Amount  |

For example:

| 05/01/2019  | Starbucks store | 10.45  |

 

Which template should I use?.

 

Thanks

 


Thanks for the clarification, @Les9.

 

You'll want to import your bank transactions using the .QBO format. Importing bank transactions to QuickBooks Desktop (QBDT) using the .CSV file is not available. Let me guide you how to do it.

  1. Sign in to your bank and download the transaction as .QBO file.
  2. Then, in your QBDT. Go to the File menu
  3. Select Utilities then Import and then click Web Connect Files.
  4. Click the .QBO file you saved, then select Open.
  5. Select your bank account.
  6. Click Continue. 
  7. You should see a dialogue box telling you that the data has been successfully read into QuickBooks and select OK.
  8. Then, go to the Bank Feeds Center.

Furthermore, here's an article you can read for more details: Import web connect (.qbo) files.

 
Additionally, I got you this article that can guide you in reconciling your accounts accurately: Reconcile an account in QuickBooks Desktop.

 

You can always get back to me whenever you have other concerns. I'm always here to help you anytime. Keep safe!

3 replies

S
Steve_C
May 13, 2020

Hi Les9. Importing CSV files is possible in QuickBooks Desktop, however, you will need to download the QuickBooks Import Excel and CSV toolkit. This contains the PDF instructions and guidelines as well as a few samples to show the proper formatting. 

 

If you'd like to learn more about importing and exporting data in QBDT check out these articles as well:

As you may have noticed, there are quite a few options available for importing data into QuickBooks Desktop. I recommend you check through them all before you decide which one you'd like to use.

 

If you need anything else though, please leave a reply below so I can get back with you. Enjoy the rest of your day. 

    L
    Les9Author
    May 14, 2020

    Hi Steve,

    Thank you for your answer. 

    As far as I understand, I can only import account list, vendor list, customer list and item list from Excel to QuickBooks but what about bank transactions?.  I know I can import bank transactions from QBO file, but I want to import bank transactions from Excel file (.CSV). Is that possible?

    Thank you for your help!

     

    BigRedConsulting
    BigRedConsulting
    May 14, 2020

    RE: As far as I understand, I can only import account list, vendor list, customer list and item list from Excel to QuickBooks

    That is not correct.

     

    RE: what about bank transactions?

    When using the IIF Transaction Creator you can import most types of financial transactions.

     

    RE: I want to import bank transactions from Excel file (.CSV). Is that possible?

    You can start with a CSV file, but the data needs to be converted to an IIF file first.

    BigRedConsulting
    BigRedConsulting
    May 13, 2020

    If you don't want to learn IIF files yourself, you also can quickly convert a CSV file opened in Excel to an IIF file using our BRC IIF Transaction Creator 

     

      L
      Les9Author
      May 14, 2020

      Thanks. Good to know.

      Candice C
      Candice C
      May 14, 2020

      Good Morning, @Les9. 

       

      Thanks for reaching back out to the Community. Depending on your bank, you should be able to go to their website and log into your online banking and download transactions into an Excel CSV file. Afterward, you can import the Excel CSV file into QuickBooks Desktop. If you run into any trouble, just let me know. I want to make sure that all of your concerns are addressed. 

       

      I'm always here to lend a helping hand. Have a great day!

      C
      cb12345
      January 30, 2021

      Hello, I do not have my banking information in Excel. My more recent bank transactions were imported. Is there a way to transfer the earlier transactions similarly? Thanks! 

      Angelyn_T
      Angelyn_T
      January 30, 2021

      Hi there, @cb12345.

       

      Thank you for joining the thread. I can share with you some insights about how online banking connection works with QuickBooks.

       

      Yes, once your account is connected for an online banking connection, the system automatically downloads the recent transaction available from your bank. For 90 days old and older transactions, you need to prepare an Excel .QBO file for them as suggested above, then manually import the file to QuickBooks.

       

      Here's how:

       

       

      1. From the Banking menu, select Bank Feeds, then Import Web Connect Files.
      2. Locate the QBO file you saved, then select Open.
      3. When prompted to Select Bank Account, select:
        • Use an existing QuickBooks account if the account you're importing transactions into is already set up in QuickBooks.
        • Create a new QuickBooks account if the account you're importing transactions into isn't in QuickBooks yet. Learn how to create an account.
      4. Tap Continue. You'll see a dialogue box telling you that the data has been successfully read into QuickBooks.
      5. Hit OK.
      6. Go to the Bank Feeds Center to review your transactions.

       

      To learn more about importing bank transactions with Web Connect files, I recommend checking out these articles:

       

       

      For more tips about banking or reconciliation, you can also open the topics from this link: Find help with bank feeds and reconciling accounts for QBDT.

       

      Please let me know how else I can help you with your banking transactions. I'm more than happy to help. Have a good one!

      Terms & ConditionsAccessibility statement