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-qu...
