Importing Bank Transactions from Excel / CSV to QuickBooks Desktop Accountant or Enterprise

QuickBooks 30-day free trial + 30% off for 12 months:



With QuickBooks Accountant and QuickBooks Enterprise 2013 and above, you can use BATCH ENTER TRANSACTIONS to copy/paste transactions from Excel. Import Transactions from Excel

00:00:00 – Intro (batch enter transactions)
00:01:18 – How to import invoices (2 types) (excel file) (example)
00:01:53 – QuickBooks Desktop (accountant tab, batch enter transactions, select invoices) (customize columns) (import invoice)
00:04:35 – Customer center, invoice (import) (example)
00:05:55 – QuickBooks Desktop (import checks; deposits) (CSV file)
00:07:16 – CSV file (data, filter, sort by)
00:09:08 – Customize columns (QuickBooks Desktop) (copy/paste from CSV file to QuickBooks) (payee column, select name type to add)
00:11:10 – Banking (use register) (checking)
00:11:40 – Import to QuickBooks (create vendors)

[hazelnutmilkeu]

Thanks alot, it helps me so much Do you have videos about the opening balance? May I know if the profit or loss/balance sheet would still be accurate or not without entering the opening balance provided in the bank statement?

[aquahealer]

How come all of your import examples don't have a "payment method" as part of the import? My clients want to import transactions from the POS system in our management software, but they need to know if it's cash, check or credit card.

[halinabilas]

Its excellent video. I have a problem copy and paste, it doesn't work for me. I'm using QuickBooks desktop pro 2021 . Please help

[WeexyAccounting]

My qb enterprise only copy it on the first cell. Anyone had this problem?

[hanishchawla]

Bravo, exactly what i was looking for !

Thank you bro

[edenpagani]

I am confused....When you did the deposits it still said "Checks" in QB....when you did checks it still said "checks". Did you misspeak? I am trying to do this right now and I was just wondering. Thank you

[mohamedraheem]

Hi sir
How to generate a Quickbook excel ledger report with SUB ACCOUNTS INFORMATION under account column
It's very urgent
Please let me know how to proceed with that

[tinahargrave]

Mr. Hector,
QB desktop Premier Accountant version 2022, help desk advised me to watch this and utilize with an overwhelming account that I am dealing with in order to reconcile. the old bank feeds are horrendous. He advised I create a new excel spreadsheet for all the banking and credit card accounts for this customer, then correct the errors or duplication or missing information on the excel sheet. "Batch entry"? then import to QB account and it should put me with a clear cleaned record in order to Reconcile. the above tutorial you stated it will not work with Priemer.

[Faddi]

Hello, I really Need you help. I'm importing Journal Entries which I have downloaded from QuickBook 2009 version in Excel Sheet and want to import transactions in QB 2017 Accountant version. I have tried through IIF format file but didn't get any solution. Please let me know how to fix this issue.

[dianegill]

I am batch entering a ton of client data into QB Accountant 2016 (thanks to your videos). I am wondering if Quickbooks will automatically match bank transfers (e.g., will it match a credit card payment from a bank account and post to both accounts, or will it match money transfers from one account to another)? There are hundreds of these transactions. Thanks for your time.

[patriciashook]

So grateful for your clear illustrations and easy to understand explanations!

[carmenjchavezlozano]

Hector, what needs to be done after the deposits are imported, go to Receive Payments?
If you enter that module to match deposits with invoices, then you have to go to Record Deposits, but would the bank entry be doubled? what should I do?? Please Help me!

[cappydonaldson]

I cannot get the excel spreadsheet to paste correctly. It all pastes into the date line. I have Enterprise so it should be working. I made sure all the columns had the same title. I downloaded the files from my bank in csv. What am I doing wrong? Thank you.

[surajadvaney]

I am not able to paste the cells copied off excel, it only pastes the first cell on QB batch entry. why is that the case?

[marianamaximov]

Hi Hector, do you have any video to show how to import bank statement excel format into QB Pro 2021, please, please help me to understand how to do it i have hard time Mapping the bank account. I will appreciate if you will suggest a video for me, to get the idea.

[l.c.]

Hey Hector, I am curious that did you use bootcamp to install windows into Mac? Thanks :)

[cleenton]

Why cant WF just have an option to export to Quickbooks directly!! 😠

[megancort]

Hello Hector,

I use quickbooks enterprise 2015. What software can I use if I want to batch enter multiple lines from different customers on one deposit?

Thank you!

[noelsoria]

Hello Hector: In Batch Enter Transactions, "Transaction Type/Checks", in the field "Bank Account", is there a way to designate a GL account that is "not" a Bank Account Type? "Say" a Other Current Liability account type? Thank you.

[noelsoria]

Hector, can this work on QB Desktop Enterprise solution 17.0? Thank you. -Noel