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?
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
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.
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.
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.
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
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!
Carmen Jhoanne Chavez Lozano hard to diagnose through here. But I would say that you should delete the deposits you entered first. The do the receive payments properly
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.
No.. you can only batch enter in a bank or credit card account :( However, he comes a JEDI TRICK... use a credit card account to batch enter, then change the account type.. BOOM
Hector: Thanks for your prompt reply. I like your JEDI TRICK, tho!! The hiccups of changing the "account type" every now and then from "credit card type" to "other types" is kinda burdensome, isn't it? Especially if the reports are generated monthly.
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.
aquahealer this method is not optimal for importing sales receipts which would include payment methods... this is for importing Invoices that get paid later on and individually. This is not designed for POS systems.
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.
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!
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.
So grateful for your clear illustrations and easy to understand explanations!
Glad it was helpful!
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?
Not specifically
Bravo, exactly what i was looking for !
Thank you bro
Great, glad you found it!
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
Pro doesn’t have that
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
Probably... can you give me the time stamp?
same thing was driving me crazy, probably was an unintentional mistake.
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.
With Premier (Non-Accountant) no.. with “Premier Accountant” yes.
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.
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.
Your only option is using Bank Feeds, and you need to covert a CSV file to a QBO file.
@@HectorGarciaCPA how do I convert CSV into QBO? Do I do it outside of QB or into Excel?
@@HectorGarciaCPA I appreciate very very much your help 🙏
@@marianamaximov2988 you need an app like MoneyThumbs CSV2QBO should be like $50
@@HectorGarciaCPA which one would you recommend from your experience and it is easier to work with
MoneyThumbs or Propersoft?
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
Not possible
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!
If you import deposits, you can’t match it to invoices
@@HectorGarciaCPA What should I do then? invoices still apperaring as
uncollected
Carmen Jhoanne Chavez Lozano hard to diagnose through here.
But I would say that you should delete the deposits you entered first. The do the receive payments properly
Great video Hector!
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?
Are you working on QuickBooks remotely? It only works if QB and Excel are in the same computer.
Hector Garcia CPA I am using the desktop version 2019
I know that.. but is it installed in your computer? Or are you accessing it remotely?
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.
No.. you can only batch enter in a bank or credit card account :(
However, he comes a JEDI TRICK... use a credit card account to batch enter, then change the account type.. BOOM
Hector: Thanks for your prompt reply. I like your JEDI TRICK, tho!! The hiccups of changing the "account type" every now and then from "credit card type" to "other types" is kinda burdensome, isn't it? Especially if the reports are generated monthly.
Noel Soria is the cost of a workaround
Yes, I agree.
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.
aquahealer this method is not optimal for importing sales receipts which would include payment methods... this is for importing Invoices that get paid later on and individually. This is not designed for POS systems.
My qb enterprise only copy it on the first cell. Anyone had this problem?
Probably because your QuickBooks is Hosted. Doesnt work over the hosted environment
Hey Hector, I am curious that did you use bootcamp to install windows into Mac? Thanks :)
Chang Liang I use VMWARE
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.
+MCE Accounting you are trying to paste en the register? on in Batch Enter?
@@HectorGarciaCPA I'm having the same exact issue. I'm trying to paste into Batch Enter like in your video.
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!
Megan Cort TPI www.transactionpro.com/products.htm?affiliate=qbk
+Megan Cort TPI
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.
Would have to see it.. hard to trouble shoot like this
Hector, can this work on QB Desktop Enterprise solution 17.0? Thank you. -Noel
+Noel Soria yes
Yep, I found it after watching your video. Thanks. It's in "Company/Batch Enter Transactions".
Thanks a lot for this
You mean price?
how get copy of the video
what you mean? you can watch it in TH-cam
Thank you so much Sir
:)
Why cant WF just have an option to export to Quickbooks directly!! 😠
thanks for the video though!
You can export to a .QBO file and import via Bank feeds
@@HectorGarciaCPA in WF i dont see the option for .QBO just CSV and quicken
@@cleenton9578 thats because is a personal account. Only business accounts give you the CSV option