Just wanted to say thanks for this wonderful video and to let you know that it is still helping people after 6 years! This is one of the best tutorial videos I have ever watched on UA-cam. Thanks again!
This is the best thing that has ever happened to me. I just got a client where I have to catch up 3 years of work, and they have excel sheets of their bank accounts. You have saved me a ton of hours, thanx
Hector, Thank you for offering your knowledge on Quickbooks. I just wanted to let everyone know that I was able to use these steps in Quickbooks Small Business 2016 on Mac. There are some things you have to figure out how to transfer but your video pretty much helped me step by step using another version of Quickbooks!
Wow Hector ! You rock and roll here brother ! Thank you so much ! I am first year in business and it is a tax season ! BOOOM !!! I am scared ! Never used quickboocks and never knew how to use PDF statements with Excel ..... ough.... Just learning. Your video is a step 2 into my learning and it seems that it should work. Maaan, would I ever think that I will need to deal with such stuff :-D I am freaking out here bro....
Excellent video. I was doing a lot of the same things in excel, but I don't yet have the accountant version. I will certainly get that now. Thank you for the video!
Hi Hector: When you made this 2/6/15 video, the best of us did as you expertly show. However, I trust you know bank statement converters & custom transferrable QB Online machine learning rules made it unnecessary (for any QBO). QBO ACCOUNTANT users also can give QBO users Accountant Toolbox with Reclassify Transactions.
That is a very good observation Hector. Yes, I do like QBO better for most clients. However, there is no reason that QBO bank statement converter output could not go to Excel, where I could automate all the conversions.
thanks so much, so used to paste another accounting software.some one called if i can help to import to quick books been battling with it for hours came across this and so useful, i thought i will need to export the template on excel and fill it up to import,but i saw your previous video which indicate i need to do mapping,cos have tried importing it using the first steps shown on the screen when trying to import but the response i got was the excel type is not the same with the quick book.
These videos have really helped me out tremendously. Question, I am using qbo for the first time with my business and I am adding 3 years of info and 2 different accounts, one closed and the second one active. Do I add the transactions from the closed account under the current open account? Of add the closed account as a separate account? Thanks
Hector this is informative and I thank you for sharing your knowledge. However, I think it is time we come up with a better system. QuickBooks whether it is Desktop or Online is an antiquated system who's backbone and framework appear to be out of MS-DOS. I haven't had a system restrict me in the number of characters of information I can write into a transaction in years with any other piece of software, but QuickBooks. In addition, If we have to do that much clean up to our files to import them into a software, then the problem is the software. Thank you for listening to my rant. As you can see I am really frustrated with QuickBooks.
Excellent Video. However please note QuickBooks 2014 & 2015 Accountant Edition and QuickBooks Enterprise Solutions 14.0 & 15.0 Accountant editions allow batch entry of transactions. I have 2013 Pro and had to stop in the middle as there was no accountant menu. Is there a work around?
Is there a easy way to split transactions under cheques or deposits between multiple classes, for eg. I need to split bank charges or agent fees between 'n number of classes
That was awesome!!! I love it. I just tried it with one bank account and loved it. However I do have one question.....when you have a client with multiple checking accounts, and they transfer funds from one account to the other, how will the batch entry catch the duplicate transactions, or will it???? Or do I need to catch it before I import? Thanks in advance!!!
it wont catch it! you have to delete them from the other side before importing them... or send all transfers to a bank account called "transfers" which will just zero out when you are done
Hector, is there a way to merge data from an old company file into a new company file. We have records in 2008 thats needs to be placed into the new file that is running starting into 2009
Hi Hector. Great videos! I work AP and use QB Desktop. When I "Enter Bills," is it possible to paste multiple lines of data at once in the Memo section? I can only seem to paste one line at a time. Thanks for any feedback. 😁
I use notepad++ when downloading my bank information to cleanup and separate the info into usable columns. I download into a Text file and use the con/alt and Control arrows to quickly align everything and then copy and past each column into excel, access or quick books which I am having to learn.
Hector, awesome video. I was able to do this until I hit the "batch transactions" which you say is not available in QB Pro 2016 Desktop, only the accountant version. Am I stuck at this point? I have my tabs in my excel spreadsheet organized exactly as yours except I don't have a memo column, only payee. My bank does not support QBO downloads.
Thank you for an excellent tutorial. I do have a question, once all the data is loaded, can I change the Transaction type? FOr example for Checks to Credit card charges, etc?
Hello Hector. Great video. I prepared my excel spreadsheet per your instructions. However, I do not have the accountant version. Is there a way to give my excel data to my accountant to be entered into quickbooks and then transferred into my quickbooks. I have Quickbooks Pro 2016? Thank you your response is greatly appreciated.
TrishSellsFloridaHomes.com yes is possible... and if your accountant cannot do it, we can do it for you and you can send you QB completed to your Accountant for tax prep... office email me.
Hector is a awesome presentation, thank you for sharing! Indeed I have a question, because I am struggling with an issue, I want to import invoices from a program called Magaya, to quickbooks, and I have my excel data, but obviously when i imported the data the amounts in accounts receivable will be open, how can match the payments from the data bank vs the accounts receivable? is possible in an automatic way? thank you in advance
i have the QB Accountant 2012 version. Is there a way to perfomed batch entries in this version? If not, what is the best version to adquired. I have a significant amount of batch transactions to do on a daily basis....
Hi~ Hector. Thanks for giving me a good information. I have a question. My colleague imports bank transactions(excel file) to QuickBooks using the IFF Creator feature, but occurs errors while importing data (finally completes though). What is different your method and IFF creator(besides expenses). I mean what are the drawbacks using your method. Thanks in advance.
Hector, do you know if I convert file from qxf to qbo (money thumb tool) when I import the transactions would it import something if any part of the transaction is already on my register to avoid duplicate entry?Thanks
Hector-i love your videos. I watched this multiple times, and worked 8 hours straight downloading CSV files to my desktop. I formatted all of the CSV data as you formatted yours, manually added transactions from PDFs and saved. I thought I would import them into QB tomorrow. Aghhhhh-when I went to open the CSV file, ALL the formatting was gone and any new worksheets I had created in the excel workbooks were gone. I think I was suppose to save the data as an xl workbook and not csv😩 I think I have to start over. Any suggestions?
Hector can I hire you to teach me to import and get my data into QB Pro for 2016? I;am in a class now, but need help importing and sorting my data to prepare for a meeting with the IRS
For all the Expenses, do you still need to create a bill and for all the credits (in my case customer payments), do you still need to create an invoice?
Great video, I have a question. I tried pasting the data however when pasting into QB Accountant 2015 it pastes into one box not everything.. is there a setting in excel perhaps I'm missing?
+Garcia Business Solutions, Inc | Bookkeeping Services in Los Angeles are you pasting in the Batch Enter window? you cant just paste in an invoice or bill like this
Hi Hector, I must have misunderstood something. I basically followed step by step what your video shows. Entered the data into Excel, divided by Payee, Date, etc.. If I'm not mistaken you copied and pasted into the QB Batch section in the Accountant Version..
Capital contribution from the owner and bank cheques ? Also the export data from the bank is miss formatted. it is sometimes dd/m/yyyy, dd/mm/yyyy. Would the ? correct for this ? I have a sort method, but its time consuming.
+Hector Garcia (CPA) i need a clue, am used to sage pastel evolution,and i thought it the same procedure to import, i just a need a clue, am just helping some one out.
Shakur, if he dumbs it down for the slowest kid in the class, the entire group suffers... . Double or triple or quadruple tap the left side of the youtube video and it will rewind for you so you can listen again... Also, there is a setting that lets you slllloooooowww it doooown. If you need it.
Just wanted to say thanks for this wonderful video and to let you know that it is still helping people after 6 years! This is one of the best tutorial videos I have ever watched on UA-cam. Thanks again!
This is the best thing that has ever happened to me. I just got a client where I have to catch up 3 years of work, and they have excel sheets of their bank accounts. You have saved me a ton of hours, thanx
Elaine Swart great... feel free to send royalty checks
Hector, Thank you for offering your knowledge on Quickbooks. I just wanted to let everyone know that I was able to use these steps in Quickbooks Small Business 2016 on Mac. There are some things you have to figure out how to transfer but your video pretty much helped me step by step using another version of Quickbooks!
+Dave Ward nice.. yea MAC has some of these features, but very different style
Hector.. I searched high and low on the Net for exactly what you have deivered here. Muchas gracias
Shaw Ali good
Check out this video as well,
Batch Enter vs. Bank Feeds:
ua-cam.com/video/rNkOqvGZiZQ/v-deo.html
This is a great video. This is absolutely a reason to get QuickBooks Accountant. Hector does a great job of explaining this time saving technique!!!
yes for sure!
Thank you for this information! It's exactly what I've been looking for (for years)!!
Great
Wow Hector ! You rock and roll here brother ! Thank you so much ! I am first year in business and it is a tax season ! BOOOM !!! I am scared ! Never used quickboocks and never knew how to use PDF statements with Excel ..... ough....
Just learning. Your video is a step 2 into my learning and it seems that it should work. Maaan, would I ever think that I will need to deal with such stuff :-D
I am freaking out here bro....
Thank you, this is just what I was looking for. Your video was informative and very easy to follow and understand. Thank you again.
This video is just great_ truly.
I feel like I could even conquer the financials from an enterprise in just a short time😮
:)
Thank you Hector for taking the time to do this
+Nimesh Vakharia :)
Great video Hector! Definitely helped me to deal with a large number of transactions that needed to be imported! Thanks!
Great presentation!
Thanks
Sir Hector Garcia is a great Man, This is a million dollars video.
Thanks.
Dilbar Chohan hehe: you welcome.
I was looking that for days.
Great presentation.
Thanks for your collaboration.
glad you liked it!
Excellent video. I was doing a lot of the same things in excel, but I don't yet have the accountant version. I will certainly get that now. Thank you for the video!
thats right.. love that accountant edition!
Hi Hector: When you made this 2/6/15 video, the best of us did as you expertly show. However, I trust you know bank statement converters & custom transferrable QB Online machine learning rules made it unnecessary (for any QBO). QBO ACCOUNTANT users also can give QBO users Accountant Toolbox with Reclassify Transactions.
I guess you like QBO better?
That is a very good observation Hector. Yes, I do like QBO better for most clients. However, there is no reason that QBO bank statement converter output could not go to Excel, where I could automate all the conversions.
This is a real informative video. Thanks for posing it.
:)
Good job!! A great video and very helpful!
thanks so much, so used to paste another accounting software.some one called if i can help to import to quick books been battling with it for hours came across this and so useful, i thought i will need to export the template on excel and fill it up to import,but i saw your previous video which indicate i need to do mapping,cos have tried importing it using the first steps shown on the screen when trying to import but the response i got was the excel type is not the same with the quick book.
Thanks boss I have learnt alot !
You welcome
very informative. you solved my problem. Thanks Hector Garcia
Hector you are doing great thanks a lot for posting such vedios
Thank you
Great video. Is there a way to do this without the accountant version and just the Pro version?
Thank you !! Very informative, direct, and useful.
Jodie Larson great
Wow. This video saved me hours. Thank you, Hector.
Max Chung you welcome
I actually showed MY accountant how to do this using your video as my learning guide. Him and I owe you some beer, can you send an address?
+Dave Ward haha, not a problem... i am glad it helped you
Nice work. Thank you for sharing your expertise
Thank you, it was very helpful!
:)
These videos have really helped me out tremendously. Question, I am using qbo for the first time with my business and I am adding 3 years of info and 2 different accounts, one closed and the second one active. Do I add the transactions from the closed account under the current open account? Of add the closed account as a separate account? Thanks
Hi Hector is there a way to import Bank data using Quickbooks Premiere , this is a very good video btw
No
Thanks for sharing your knowledge, I really Appreciate this!!!!!!!
+P Trevino no problem
amazing what happens if already you have existing vendors and suppliers in qb
Use those instead or it might duplicate them
VERY helpful! Great instruction
Hector this is informative and I thank you for sharing your knowledge.
However, I think it is time we come up with a better system. QuickBooks whether it is Desktop or Online is an antiquated system who's backbone and framework appear to be out of MS-DOS. I haven't had a system restrict me in the number of characters of information I can write into a transaction in years with any other piece of software, but QuickBooks. In addition, If we have to do that much clean up to our files to import them into a software, then the problem is the software. Thank you for listening to my rant. As you can see I am really frustrated with QuickBooks.
Fish Sleep Relax what’s better?? I’m always open to alternatives
Hector Garcia CPA Good reply sir. I’d love to provide the answer. I’m working on a solution. Keep you posted.
great video! testing it out today
+Julianne Autry great!
Hector
Thanks so much.
What an awesome video.
+Audrey Neamtan glad you liked it
good excel tips and import to qb
Hello, could I use the same steps to import credit card transactions??
Excellent Video. However please note QuickBooks 2014 & 2015 Accountant Edition and QuickBooks Enterprise Solutions 14.0 & 15.0 Accountant editions allow batch entry of transactions. I have 2013 Pro and had to stop in the middle as there was no accountant menu. Is there a work around?
2013 accountant can do it too
+Tajinder Singh Can we import invoices
thank you so much for your time and knowledge...
Is there a easy way to split transactions under cheques or deposits between multiple classes, for eg. I need to split bank charges or agent fees between 'n number of classes
My qb enterprise only copy it on the first cell.
Is you enterprise on a remote computer? Or doesn’t work remotely
Your videos are great! Do you have any videos on how I can import an xcel spreadsheet with credit card charges into my quickbooks online version?
Elizabeth.. you can use an app called CSV2QBO to convert the excel file into a .QBO file that will import into QuickBooks Online
bit.ly/CSV2QuickBooks
+Elizabeth McCord also look at this video ua-cam.com/video/a7z-fS60ihY/v-deo.html
Thank you Accountant from Nairobi
you welcome
Thanks so much. Very helpful. 😊 gracias
That was awesome!!! I love it. I just tried it with one bank account and loved it. However I do have one question.....when you have a client with multiple checking accounts, and they transfer funds from one account to the other, how will the batch entry catch the duplicate transactions, or will it???? Or do I need to catch it before I import? Thanks in advance!!!
it wont catch it! you have to delete them from the other side before importing them... or send all transfers to a bank account called "transfers" which will just zero out when you are done
Hey, thanks for video. How can we see the excel shortcuts on the screen like your excel?
Hector, is there a way to merge data from an old company file into a new company file. We have records in 2008 thats needs to be placed into the new file that is running starting into 2009
What a great video, thank you very much.
+Rick Duval you are welcome
Great video, very helpful
Souleymane Baldé glad you liked it....
Following your instructions to transfer from excel to QB I find that QB 2020 does not have the accountant tab.
if anyone can help me, I appreciate it.
You need to have the Accountant’s edition. You probably have Pro or Premier
Hi Hector. Great videos! I work AP and use QB Desktop. When I "Enter Bills," is it possible to paste multiple lines of data at once in the Memo section? I can only seem to paste one line at a time. Thanks for any feedback. 😁
Unfortunately not, just one line
Awesome. Total fan!
Linda Florence cool!
Hi Hector, given all of the importing tools for QB which do you believe are the best and why?
I use notepad++ when downloading my bank information to cleanup and separate the info into usable columns. I download into a Text file and use the con/alt and Control arrows to quickly align everything and then copy and past each column into excel, access or quick books which I am having to learn.
Can I classify transactions to the appropriate account and then paste into QB?
Your video are very helpful. When you enter things into the register, do you still have to enter them anywhere else in QB?
no.
Can you do a video on importing paypal transactions?
yes.. search it in the channel
Thanks for the tips!!!
you are welcome
+Ngan Menegay no problem
Hector, awesome video. I was able to do this until I hit the "batch transactions" which you say is not available in QB Pro 2016 Desktop, only the accountant version. Am I stuck at this point? I have my tabs in my excel spreadsheet organized exactly as yours except I don't have a memo column, only payee. My bank does not support QBO downloads.
Sal Livreri you need to upgrade to QB Accountant Edition 2018 is $450
Thank you for an excellent tutorial. I do have a question, once all the data is loaded, can I change the Transaction type? FOr example for Checks to Credit card charges, etc?
No, you can only import one transaction type at the time.. and cannot be changed
not possible to change transaction typr
Hello Hector. Great video. I prepared my excel spreadsheet per your instructions. However, I do not have the accountant version. Is there a way to give my excel data to my accountant to be entered into quickbooks and then transferred into my quickbooks. I have Quickbooks Pro 2016? Thank you your response is greatly appreciated.
TrishSellsFloridaHomes.com yes is possible... and if your accountant cannot do it, we can do it for you and you can send you QB completed to your Accountant for tax prep... office email me.
Hi thanks Hector for the useful tutorials,i just want to know how i can transfer bank transactions manually to quick books premier?
You would need an importing tool like TPI for $200
Can you reclassify transactions as a batch on premier as well or do you need third party tool like Zed Axis as well?
not in premier..
Zed Axis can't do reclassification of transactions?
Hector is a awesome presentation, thank you for sharing!
Indeed I have a question, because I am struggling with an issue, I want to import invoices from a program called Magaya, to quickbooks, and I have my excel data, but obviously when i imported the data the amounts in accounts receivable will be open, how can match the payments from the data bank vs the accounts receivable? is possible in an automatic way? thank you in advance
you would have to import the payments as well
Can you do that through Zed Axis?
great job!!!! thank you
Welcome
i have the QB Accountant 2012 version. Is there a way to perfomed batch entries in this version? If not, what is the best version to adquired. I have a significant amount of batch transactions to do on a daily basis....
nope.. you need to upgrade to 2016, need a price quote?
+Hector Garcia (CPA) Sure! Tks.
+Michelle Herger email me hector@garciacpa.com
Can Import Copy /Paste bank transaction into QuickBooks from CSV or Excel Premier Pro 2021
No… Accountant only
Hi~ Hector. Thanks for giving me a good information. I have a question. My colleague imports bank transactions(excel file) to QuickBooks using the IFF Creator feature, but occurs errors while importing data (finally completes though). What is different your method and IFF creator(besides expenses). I mean what are the drawbacks using your method. Thanks in advance.
There are pros and cons to many options
Hector, do you know if I convert file from qxf to qbo (money thumb tool) when I import the transactions would it import something if any part of the transaction is already on my register to avoid duplicate entry?Thanks
A P if you bring in through bank feeds, it will identify the match on any unreconciled transaction.
Hector-i love your videos. I watched this multiple times, and worked 8 hours straight downloading CSV files to my desktop. I formatted all of the CSV data as you formatted yours, manually added transactions from PDFs and saved. I thought I would import them into QB tomorrow. Aghhhhh-when I went to open the CSV file, ALL the formatting was gone and any new worksheets I had created in the excel workbooks were gone. I think I was suppose to save the data as an xl workbook and not csv😩 I think I have to start over. Any suggestions?
CSV's dont save formating
you need to save it as an EXCEL document
Hector can I hire you to teach me to import and get my data into QB Pro for 2016? I;am in a class now, but need help importing and sorting my data to prepare for a meeting with the IRS
Mark Deaton yes, call 954-414-1524
Can we import Bank transactions from Excel to Quickbook pro premier?
No.
Thanks alot
That was amazing!
glad it was helpful
Hi.. Hector, can you email me the Quickbooks setup? I can't find any free version
My email is : jasonsukasuka@gmail.com, thank's
Can you do this with Quickbook Pro 2015 or do you need the Accountant version?
SSiter2 Only Accountant Edition.
For all the Expenses, do you still need to create a bill and for all the credits (in my case customer payments), do you still need to create an invoice?
Seria bueno tenerlo en Español
This screws up your vendor and customer lists though
It adds stuff to it.. but doesn’t screw it up, if that is what you want to bring
Great video, I have a question. I tried pasting the data however when pasting into QB Accountant 2015 it pastes into one box not everything.. is there a setting in excel perhaps I'm missing?
+Garcia Business Solutions, Inc | Bookkeeping Services in Los Angeles are you pasting in the Batch Enter window? you cant just paste in an invoice or bill like this
Hi Hector, I must have misunderstood something. I basically followed step by step what your video shows. Entered the data into Excel, divided by Payee, Date, etc.. If I'm not mistaken you copied and pasted into the QB Batch section in the Accountant Version..
+Garcia Business Solutions, Inc | Bookkeeping Services in Los Angeles that is right
`how to over come the two problem areas you pointed out ?
Travismcdee353 which ones..
Capital contribution from the owner and bank cheques ? Also the export data from the bank is miss formatted. it is sometimes dd/m/yyyy, dd/mm/yyyy. Would the ? correct for this ? I have a sort method, but its time consuming.
Hi Hector?
do you know how to import lockbox file into QB desktop?
Rechel Puerto I don’t know what I lockbox file is...
Hector, is it possible to batch import with QB 2012? I cannot find that option.Thanks.
+Leigha Anthony no
I have QB pro 2015 , Is not possible to do a batch transaction right?
need to upgrade to QuickBooks Accountant, email me for quote.
hello Hector i tried what you just did not working.thought gotten a solution, but ..........................................................
email me if you want to setup a private training.
+Hector Garcia (CPA) i need a clue, am used to sage pastel evolution,and i thought it the same procedure to import, i just a need a clue, am just helping some one out.
Does it work on QuickBooks online..?
No
Hola Hector, por favor necesito contactar contigo, para unos trabajos en Quicbooks? como podemos conversar?
Llama a la oficina para hacer cita 954-414-1524
When can I find the items I matched?
+Awilda Ramirez there is no MATCHING mechanism with Batch Enter Transactions
This method does not take into account outstanding checks
you have to enter those manually
genius
BHT HARD
?
Sorry Hector - at about 8:19 I couldnt' take any more - it looks like a complete mess on steroids.
Yeah, its def. Not a simple as must people imagine it
i love you
:)
Do a better job with correcting yourself when you use terminology, you’ll say deposits” I mean debits” it’s just confusing be precise and concise
Shakur Morrow please show me your videos that I can learn from....
Shakur, if he dumbs it down for the slowest kid in the class, the entire group suffers... . Double or triple or quadruple tap the left side of the youtube video and it will rewind for you so you can listen again... Also, there is a setting that lets you slllloooooowww it doooown. If you need it.
Is there a way to quickly clean up/merge those vendor names?
no.. I wish..