Skip to main content
A
arkvalleyinfo
December 11, 2018
Question

How to import bank transactions using excel.

  • December 11, 2018
  • 12 replies
  • 0 views
I am trying to import bank transactions from a bank that does not support Web Connect.

- My bank only allows downloads for Excel, Comma Separated Values, Micrsoft Money, and Quicken. My quickbooks only allows import for IIF File, Quicken, and Web Connect, none of which I have.

I don't not have Quicken or IIF. I only have Excel and Numbers(almost identical program).

Is there any way to download or convert the Excel file so I can import in quickbooks.

I have been at this for MONTHS!! HELP!!!!!!!!!!!

Many thanks,
Shelby

    12 replies

    Show previous replies
    T
    Thomache
    November 5, 2022

    Yep - I just found out Discover card no longer will create quickbook files.  This is a big issue for me

    G
    GlinetteC
    November 5, 2022

    I can see how upsetting this can be when something doesn't no longer work,  thomache1.

     

    If you haven't tried, you can try the recommended solutions in this thread.

     

    You may want to look for a third-party application that lets you do the tasks to work seamlessly. You can check our QuickBooks App Center to find one.

     

    If you have other queries, you can post them any time in the Community. We're always ready to help.

    K
    Keep It Simple
    December 29, 2023

    Please suggest the https://desktop.apps.com/home page have intuitive search engines added OR better descriptive lines to eliminate the tedious click >read>click>read to locate the application you are looking for ie: excel to quickbooks desktop should bring up only programs that provide that transaction. the current search engine provides any program that uses Excel for time tracking, etc. 

    L
    LydiaMAC
    November 7, 2022

    Hello! I wanted to reply in this chain because I found what I was looking for somewhere else and I believe that this will help in importing bank transactions using excel & Batch transactions.

    In my case, I had put a bunch of transactions in a wrong account and was going to have to reenter them all. That was too daunting of a task so I started looking to find out how to import transactions from a CSV file. Some even recommended creating an IIF (from their software that you have to purchase) or converting from IIF to QBO. All not needed.

    It didn't make sense to me that we couldn't just import line items into QuickBooks--however I wasn't looking at it the right way. What I needed to do was get the things in the columns of the spreadsheet into QuickBooks not necessarily the transactions as a whole themselves. (so you do have to have some understanding of Excel and the ability to move columns around to do this--so the xls info matches  QuickBooks colums)

     The only thing that this solution doesn't provide for is any scanned attachments that you might have. What I ended up doing was getting the transactions in there and then individually deleting the old ones as I found the attached documents in the document center to re add into the new transaction. (if this is a brand new set of transactions this won’t apply to you)  While it was still a bit daunting it was way less than having to manually enter all of every element of these transactions individually.

    I use QBDT, and found this link for just copying from the Excel sheet into a transaction table. The link discusses using the Accounting Version (not necessary). I found the same thing under

    “Company” > Batch Enter Transactions. The table comes up, you paste and move on.

    The only Gotcha: (other than reassigning the attachments through Document Center)

    Make sure your data in the column for Accounts exactly matches the ones in QBDT (I had some sub accounts and it has to be exact, even to match the spaces—Automobile Expense:Repair  instead of Automobile Expense: Repair)

    If you paste your information in and get errors, it is not the end of the world, see what needs changing, clear the Batch Enter table, change it in the spreadsheet, and paste again! When happy with the results, enter the transactions!

    Here is a help article that is more geared toward Accountants, my description above is not in an Accounting version.

    https://quickbooks.intuit.com/learn-support/en-us/help-article/invoicing/enter-transactions-batch-quickbooks-desktop/L5eBO2ypV_US_en_US

     

     

    Terms & ConditionsAccessibility statement