So grateful for your clear illustrations and easy to understand explanations!
@HectorGarciaCPA
6 ай бұрын
Glad it was helpful!
@hanishchawla1236
Жыл бұрын
Bravo, exactly what i was looking for ! Thank you bro
@HectorGarciaCPA
6 ай бұрын
Great, glad you found it!
@hazelnutmilkeu
5 ай бұрын
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?
@HectorGarciaCPA
5 ай бұрын
Not specifically
@tinahargrave1454
2 жыл бұрын
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.
@HectorGarciaCPA
2 жыл бұрын
With Premier (Non-Accountant) no.. with “Premier Accountant” yes.
@user-jc9kw9sd4d
6 ай бұрын
Thank you so much Sir
@HectorGarciaCPA
6 ай бұрын
:)
@user-ru2cb6kw7b
10 ай бұрын
Thanks a lot for this
@HectorGarciaCPA
6 ай бұрын
You mean price?
@TheNarrowGate_Lwazi
3 жыл бұрын
Great video Hector!
@dianegill4868
8 жыл бұрын
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.
@edenpagani1243
5 жыл бұрын
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
@HectorGarciaCPA
5 жыл бұрын
Probably... can you give me the time stamp?
@tayyab7979
3 жыл бұрын
same thing was driving me crazy, probably was an unintentional mistake.
@WeexyAccounting
10 ай бұрын
My qb enterprise only copy it on the first cell. Anyone had this problem?
@HectorGarciaCPA
7 ай бұрын
Probably because your QuickBooks is Hosted. Doesnt work over the hosted environment
@mohamedraheem892
Жыл бұрын
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
@HectorGarciaCPA
5 ай бұрын
Not possible
@aquahealer
6 жыл бұрын
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.
@HectorGarciaCPA
6 жыл бұрын
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.
@marianamaximov7071
2 жыл бұрын
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.
@HectorGarciaCPA
2 жыл бұрын
Your only option is using Bank Feeds, and you need to covert a CSV file to a QBO file.
@marianamaximov2988
2 жыл бұрын
@@HectorGarciaCPA how do I convert CSV into QBO? Do I do it outside of QB or into Excel?
@marianamaximov2988
2 жыл бұрын
@@HectorGarciaCPA I appreciate very very much your help 🙏
@HectorGarciaCPA
2 жыл бұрын
@@marianamaximov2988 you need an app like MoneyThumbs CSV2QBO should be like $50
@marianamaximov2988
2 жыл бұрын
@@HectorGarciaCPA which one would you recommend from your experience and it is easier to work with MoneyThumbs or Propersoft?
@Faddi2611
5 жыл бұрын
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.
@HectorGarciaCPA
5 жыл бұрын
Would have to see it.. hard to trouble shoot like this
@carmenjchavezlozano6692
4 жыл бұрын
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!
@HectorGarciaCPA
4 жыл бұрын
If you import deposits, you can’t match it to invoices
@carmenjchavezlozano6692
4 жыл бұрын
@@HectorGarciaCPA What should I do then? invoices still apperaring as uncollected
@HectorGarciaCPA
4 жыл бұрын
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
@l.c.8959
5 жыл бұрын
Hey Hector, I am curious that did you use bootcamp to install windows into Mac? Thanks :)
@HectorGarciaCPA
5 жыл бұрын
Chang Liang I use VMWARE
@cappydonaldson6218
8 жыл бұрын
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.
@HectorGarciaCPA
8 жыл бұрын
+MCE Accounting you are trying to paste en the register? on in Batch Enter?
@synchrogrl18
2 жыл бұрын
@@HectorGarciaCPA I'm having the same exact issue. I'm trying to paste into Batch Enter like in your video.
@surajadvaney6090
4 жыл бұрын
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?
@HectorGarciaCPA
4 жыл бұрын
Are you working on QuickBooks remotely? It only works if QB and Excel are in the same computer.
@surajadvaney6090
4 жыл бұрын
Hector Garcia CPA I am using the desktop version 2019
@HectorGarciaCPA
4 жыл бұрын
I know that.. but is it installed in your computer? Or are you accessing it remotely?
@noelsoria6398
7 жыл бұрын
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.
@HectorGarciaCPA
7 жыл бұрын
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
@noelsoria6398
7 жыл бұрын
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.
@HectorGarciaCPA
7 жыл бұрын
Noel Soria is the cost of a workaround
@noelsoria6398
7 жыл бұрын
Yes, I agree.
@megancort8227
7 жыл бұрын
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!
Пікірлер: 62