I am so stuck. I was watching your video and following along when at: [Seventeen Minutes and 15 seconds: 17:15 into the video ] - I have QBS 2018 Accountant Edition. The Transaction Type I chose is Checks. I customized my columns to include the Date/Payee/Amount into the Batch Enter Transaction Window. My Batch Transaction window does not populate the fields with the data from my excel spreadsheet file. I followed your example step by step. I right-click on the Date field, remove the current date that is there, as you suggested in the video. For pasting, I tried multiple times to do this. I press CTRL+V and I even Right Click to Paste the data, but all the data from my spreadsheet just stays in the Date field. There is no automatically populating the data into the fields for me. I've tried so many ways I can think of to copy/paste. This is so frustrating! What's really crazy I'm very tech-savvy when it comes to navigating the computer. I would really hate to enter 300 somethings transactions one by one. I am new to QBS, but the video was easy and helpful, but entering multiple transactions into the Batch Enter Transactions window does not work for me. :(
Is quickbooks in a hosted (remote) platform? Or are you working on a Windows emulator inside of mac? Those two scenarios don’t allow a cross platform copy and paste.
@@HectorGarciaCPA Hi Hector, I have a windows 10 desktop pc. My QBS Accountant Edition is 18.0. I installed the software files. Thank you for responding. ❤️
Hello Hector, Thank you for your videos very interesting and helpful. I live in Curacao, our local currency is ANG. We are able to get this in QB. does the pdf2qbo Convert recognise our local currency ANG? is it able to convert (scanned) bank statements from any country or bank not situated in the USA? thank you
Hector, Is there a way to download transactions from Wells Fargo for 2021 into Quickbooks? According to WF and QB customer service this is not possible. Please tell me this is possible???
What’s the proper way to categorize the credit card payment transaction downloaded via the Credit Card bank feeds? Should it be coded I.e. Payee:Amex and Account: “Amex liability” or should it be Account: “BofA Checking”? This has me soo confused at times... please help me. Love your videos
Great info! Thank you. Unfortunately, I have QB Desktop Pro 2018. Not sure I want to spend $349 for the Accountant version now? Wish there was an upgrade just for importing from Excel for CC charges!
@@HectorGarciaCPA Excellent video. Thank you. I have QB Desktop Pro 2018. You mentioned some way to get us an Accountant update discount. Can you please let me know how I may do that? Thanks.
at 18:45 what account was the credit of $5000 and all the credits for that matter classified as? an income account? if it was a owner investment deposit would you classify it as equity like capital stock?
Good day Mr Hector. Thank you for the informative video regarding importing. I am a new user to Quick Books and wanted to capture bank statements in a easier and more effective way. I am using QB's Accountant version. However i have found that if i import the bank statements using Batch entry transactions, I am unable to post bank payments to accounts payable, as the program does not accept the suppliers/vendors I have entered under unsaved vendors/suppliers. Please assist me? Kind regards!
Hello Hector! Your videos are amazing and I really enjoy them. Do you recommend any software I could use to transcribe check images from the bank statements to csv. Thank you for your kind help!
hello, mr hector, i am using QB online and need to import a list of payments to knock off against the sales and purchases. Do you have a template that I can use to import ?
Hi, I have Quickbooks desptop version 2020 installed in two different computers. I have a client file called Glass Mirror Inc in both computers. The same exact file. I need to input bank transactions for twelve month and it is a lot of work. I want to know if in one computer I can input six months and in the other computer input the other six months and merge the data into one computer. Is that possible and how can I do that?
i have quick books for contractor 2018, which icon can i use for the same function of transferring transactions from the bank to quick books if i don't have the Accountant icon?
Thanks Hector ! your videos are very helpful . Unfortunately Im using QBO and I was expecting to download Bank info but as soon as I started to watch the video i notice you mentioned this feature is only on Desktop version right ? Do you have any suggestion in how can I download Bank info in QBO from previous years ? Or I for got to mention that the client havent give us access to his Bank Account . Just the actual Bank Statements documents . Thanks
Hi Hector, do you have a tutorial on how to convert an iif file to excel sheet/csv? I can't find anything that can convert iif file for me to import it to QBO. I tried other suggestions like going in excel, open the iif file and save it as csv/xls but it doesnt work. Would really appreciate if you could help me on this one. Thanks! Great Tutorial videos btw!
Janice, I watched another video and the guy just simply changed the file name from .txt to .iff on his desktop. He saved it in a .txt format to his desktop. Then renamed it on his desktop prior to opening. does that make sense? I would have to find the video but just look up importing IFF files into Quickbooks desktop.
Thank you for the tutorial. I'm running QB Desktop 2017 Premier Nonprofit. I have my file, separated Income vs Expenses. I paste the vendor vs customers BUT when I open customize columns there is no option for payee, amount etc. I only see very basic info i.e. name, address, email, terms, tax id etc. How can I customize to see Description, Amount, Postdate etc as shown in your example? Our Chase acct work perfect with QBO but our TD acct only has up to 60days of info so I need to import the transactions from Excel. Your assistance is much appreciated.
@@HectorGarciaCPA I am trying, but it will just paste the first vendor name from the list I copied. Also, tried copy/paste to the "Batch Enter Transactions" window and all the info gets pasted to the date cell instead of distributed along the columns specified.
Hi Hector,. I was wondering if there is anyways around converting scanned bank statements into pdf or excel. And then importing into quickbooks pro 2018? not gonna lie but I failed to do any research before purchasing quickbooks pro 2018 and now I'm super frustrated and don't know what I can do. I only have hard copies of a year's worth of bank statements. My client wants me to put their business' bank statements into quickbooks. Do you have any suggestions? Of what I should or could do? Lol. Sorry if I sound complicated. I am kind of rusty when it comes to bookkeeping and quickbooks, as it's been awhile since I took the course. And I'm sorta short on funds to purchase the accounting edition.
Absolutely fabulous Hector! Thank you, this webinar will be a great benefit to my practice!
Cheryl North Johnson cool!
This is very helpful! especially to someone who is not experienced with quickbooks.
Wonderful. I wanted to see more detail on categorizing and filling the trasnaction list. That is the critial screen.
THANK YOU SO MUCH. IT WORKS! TALK SOON.
Great!
Thank you for the info, Hector! Bought the Pro version for my business and the software worked like a charm (Have not tried the PDF utility yet).
awesome!! that is good to hear brother.
Most useful tutorial I've found. AWESOME JOB!
Thanks :)
Very nice explaining each process. Thank you.
Thank you for this tutorial. Great help. Thank you so much!
Pili Blue you welcome
Great videos Hector 😊 Thank you 🙏
I am so stuck. I was watching your video and following along when at: [Seventeen Minutes and 15 seconds: 17:15 into the video ] - I have QBS 2018 Accountant Edition. The Transaction Type I chose is Checks. I customized my columns to include the Date/Payee/Amount into the Batch Enter Transaction Window. My Batch Transaction window does not populate the fields with the data from my excel spreadsheet file. I followed your example step by step. I right-click on the Date field, remove the current date that is there, as you suggested in the video. For pasting, I tried multiple times to do this. I press CTRL+V and I even Right Click to Paste the data, but all the data from my spreadsheet just stays in the Date field. There is no automatically populating the data into the fields for me. I've tried so many ways I can think of to copy/paste. This is so frustrating! What's really crazy I'm very tech-savvy when it comes to navigating the computer. I would really hate to enter 300 somethings transactions one by one. I am new to QBS, but the video was easy and helpful, but entering multiple transactions into the Batch Enter Transactions window does not work for me. :(
Is quickbooks in a hosted (remote) platform? Or are you working on a Windows emulator inside of mac? Those two scenarios don’t allow a cross platform copy and paste.
@@HectorGarciaCPA Hi Hector, I have a windows 10 desktop pc. My QBS Accountant Edition is 18.0. I installed the software files. Thank you for responding. ❤️
@@romanticscents then i have no idea what’s happening... you are copying from Excel correct?
@@HectorGarciaCPA yes, maybe my version too old. I'm going to purchase the online version so I can finish your tutorial lol. Thank you. 💓
@@romanticscents ONLINE version doesn’t have that copy/paste experience
Hello Hector, Thank you for your videos very interesting and helpful. I live in Curacao, our local currency is ANG. We are able to get this in QB. does the pdf2qbo Convert recognise our local currency ANG? is it able to convert (scanned) bank statements from any country or bank not situated in the USA? thank you
It might not work... you can email ralph@moneythumb.com and ask him... he is the lead programmer there.
Thank You Mr Hector Garcia
KhadarBile you are welcome
THANK YOU Again MR Hector Garcia I request Important Short video About How to Active Advanced Inventory Settings I Confused
KhadarBile do you have Enterprise Platinum annual subscription?
No i don't Have Enterprice platinum Annual Subscription do You have link Send meTeacher Hector Garcia CPA
KhadarBile You Have to Buy it.. is $1000 per year for a 1 user.
Hector, Is there a way to download transactions from Wells Fargo for 2021 into Quickbooks? According to WF and QB customer service this is not possible. Please tell me this is possible???
Too far back
What’s the proper way to categorize the credit card payment transaction downloaded via the Credit Card bank feeds? Should it be coded I.e. Payee:Amex and Account: “Amex liability” or should it be Account: “BofA Checking”? This has me soo confused at times... please help me. Love your videos
I have a Advanced QBO Bank Feeds masterclass, that could help you. quickbooks.teachable.com/p/quickbooks-online-mastering-bank-feeds-advanced-content
Great info! Thank you. Unfortunately, I have QB Desktop Pro 2018. Not sure I want to spend $349 for the Accountant version now? Wish there was an upgrade just for importing from Excel for CC charges!
There isn’t.. but if you can convert the excel into .qbo format, you can.
Thanks, Hector. No idea how to do that but I will try to see if I can. My CC provider did not have that option, only CVS.@@HectorGarciaCPA
Pam VanOstaeyen use CSV2QBO converter: www.2quickbooks.com
@@HectorGarciaCPA Excellent video. Thank you. I have QB Desktop Pro 2018. You mentioned some way to get us an Accountant update discount. Can you please let me know how I may do that? Thanks.
Nasser Lukmani $450 for the upgrade
at 18:45 what account was the credit of $5000 and all the credits for that matter classified as? an income account? if it was a owner investment deposit would you classify it as equity like capital stock?
Owners deposit is like capital stock yes
Great webinar. Especially 2quickbooks part. Does a "scanned" PDF statement conversion work the same way a digital one does?
pupkin333 yes.. but it needs to be a SUPER clean scan
Bruh! this is gold
Hehe, thanks
2 👍🏻👍🏻 THUMB'S UP I ENJOY WATCHING 💞
Good day Mr Hector. Thank you for the informative video regarding importing. I am a new user to Quick Books and wanted to capture bank statements in a easier and more effective way. I am using QB's Accountant version. However i have found that if i import the bank statements using Batch entry transactions, I am unable to post bank payments to accounts payable, as the program does not accept the suppliers/vendors I have entered under unsaved vendors/suppliers. Please assist me? Kind regards!
Hello Hector! Your videos are amazing and I really enjoy them. Do you recommend any software I could use to transcribe check images from the bank statements to csv. Thank you for your kind help!
There is nothing, specially if the checks were written by hand.
@@HectorGarciaCPA thank you!
hello, mr hector, i am using QB online and need to import a list of payments to knock off against the sales and purchases. Do you have a template that I can use to import ?
To import transactions from excel into QuickBooks, you actually need to pay for a third-party app called transaction, pro importer, or SAASANT
thanks for reply. But there is the import function and templates given in QB ? @@HectorGarciaCPA
Hector, now that Quick books has shut down importing qbo and cvs files into 2018, what can be done to get around this interruptions.
I don’t know if one, you need to be on 2019-2021
T=10:41 how’d you shift delete there?
Is there a free plugin from QB for converting QBO to CSV? Just recently I am getting error on one of my accounts when trying to import the QBO
Not that I know of
Great man !
9:19 What you did to adjust all the columns simultaneously at once ? You selected all area of spreadsheet and ?
Anup Phineas double clicked between A and B
Hi, I have Quickbooks desptop version 2020 installed in two different computers. I have a client file called Glass Mirror Inc in both computers. The same exact file. I need to input bank transactions for twelve month and it is a lot of work. I want to know if in one computer I can input six months and in the other computer input the other six months and merge the data into one computer. Is that possible and how can I do that?
Axel Vladimir Rangel there is not easy way to do it
i have quick books for contractor 2018, which icon can i use for the same function of transferring transactions from the bank to quick books if i don't have the Accountant icon?
Premier Contractor does not have the Batch Enter Transactions function.
How do you import when you have quickbooks pro mac 2016? Under the list tab I do not see "edit/add multiple lists"? Thanks!
Mac doesn’t have this
Thanks Hector ! your videos are very helpful . Unfortunately Im using QBO and I was expecting to download Bank info but as soon as I started to watch the video i notice you mentioned this feature is only on Desktop version right ? Do you have any suggestion in how can I download Bank info in QBO from previous years ? Or I for got to mention that the client havent give us access to his Bank Account . Just the actual Bank Statements documents .
Thanks
+Peak Janitorial you need to get PDF2QBO or 2qbo Converter from www.2quickbooks.com
Thank you very much Hector
Hi Hector Garcia, i'm using the version of quickbooks premier 2018 so may you please tell me how to export my chart of account to excel?
Marco garcia file, utilities, Export, Lists to IIF, choose Chart of Accounts.. open it in excel. Watch my chart of accounts 1 Hour video
Hi Hector, do you have a tutorial on how to convert an iif file to excel sheet/csv? I can't find anything that can convert iif file for me to import it to QBO.
I tried other suggestions like going in excel, open the iif file and save it as csv/xls but it doesnt work. Would really appreciate if you could help me on this one.
Thanks! Great Tutorial videos btw!
You need an app called Zed Axis, is $199
Janice, I watched another video and the guy just simply changed the file name from .txt to .iff on his desktop. He saved it in a .txt format to his desktop. Then renamed it on his desktop prior to opening. does that make sense? I would have to find the video but just look up importing IFF files into Quickbooks desktop.
I'm running Quickbooks Pro 2017 and sounds like I really need the accountant version. How do I upgrade?
Phil Hecker is $499, I can give you a $50 discount. Email me your contact info, I’ll send you instructions on Monday hector@garciacpa.com
Thank you for the tutorial. I'm running QB Desktop 2017 Premier Nonprofit. I have my file, separated Income vs Expenses. I paste the vendor vs customers BUT when I open customize columns there is no option for payee, amount etc. I only see very basic info i.e. name, address, email, terms, tax id etc. How can I customize to see Description, Amount, Postdate etc as shown in your example? Our Chase acct work perfect with QBO but our TD acct only has up to 60days of info so I need to import the transactions from Excel. Your assistance is much appreciated.
Send screenshots
I just emailed the screenshot. Thanks.
HNA BishopM ok
I have QB Accountant 2016. Is it still possible to Add/Edit Multiple List Entries by copy/pasting from Excel?
Yes
@@HectorGarciaCPA I am trying, but it will just paste the first vendor name from the list I copied. Also, tried copy/paste to the "Batch Enter Transactions" window and all the info gets pasted to the date cell instead of distributed along the columns specified.
Are you working remotely or hosting QuickBooks?
@@HectorGarciaCPA I am working on a Mac, but in a virtual machine using VMware and Microsoft. My prior computer was a PC.
Liza Lugo it only works if Excel and QB are on the same machine...
De mucha ayuda son tus vídeos para mí 😀👍
Maritza Vidal :)
How would you use csv2qbo in South Africa it keeps giving an error . Is this only valid in USA
Not sure about ZA
Hi I am in Botswana and am failing to used the bank feed function. I if you manage to find a solution please let me know bmalunda@gmail.com
Hi Hector,.
I was wondering if there is anyways around converting scanned bank statements into pdf or excel. And then importing into quickbooks pro 2018? not gonna lie but I failed to do any research before purchasing quickbooks pro 2018 and now I'm super frustrated and don't know what I can do. I only have hard copies of a year's worth of bank statements. My client wants me to put their business' bank statements into quickbooks. Do you have any suggestions? Of what I should or could do? Lol. Sorry if I sound complicated. I am kind of rusty when it comes to bookkeeping and quickbooks, as it's been awhile since I took the course. And I'm sorta short on funds to purchase the accounting edition.
Darcia Gladue the software to convert scanned statements is expensive
you mean ScanWriter? :( i hope someone finds a solution for ppl in similar situations. Thanks for the fast reply.
Darcia Gladue yes
6:34 typo: MOST should be MUST
The Sqoou thanks... yes realized AFTER posting, Cannot really he changed.
Amazeballs
He he
T=23:13
I found this video after my boss asked me to enter more than a 100 transactions. But we're using premier edition. huhhu :(
You can upgrade.
Too much talking. Let's get to the point....
Socrates T you can fast forward... that’s the beauty of UA-cam...
I guess part of that same beauty is that any idiot can make a comment here.