Thanks hector, your video is very helful and informative. You made bookkeeping much easier. God bless.
@HectorGarciaCPA2 жыл бұрын
Great
@graciehomestay31343 жыл бұрын
Thank you for this video, My Boss and I figured out why we cant import excel file to Quickbooks! We have done it after watching this. :)
@Jasper2009nc4 жыл бұрын
I did it! Imported the chart of accounts from Excel! Your directions were perfect!
@HectorGarciaCPA4 жыл бұрын
Linda Suszczynski awesome!
@optimizationsolutions45105 жыл бұрын
Wonderful communication, and love the arrows, it makes the video so easy to understand.
@HectorGarciaCPA5 жыл бұрын
Thanks
@johnlavigeriekizito992610 ай бұрын
Thank you Hector. I find this very helpful
@HectorGarciaCPA6 ай бұрын
:)
@lindanewhart23104 жыл бұрын
This is an excellent video! Thanks for taking the time to record it.
@HectorGarciaCPA4 жыл бұрын
You welcome
@tristanmilo85943 жыл бұрын
You probably dont care but does anybody know a way to log back into an instagram account?? I stupidly forgot the password. I would appreciate any assistance you can give me.
@reyjude72893 жыл бұрын
@Tristan Milo instablaster ;)
@tristanmilo85943 жыл бұрын
@Rey Jude i really appreciate your reply. I got to the site thru google and Im in the hacking process now. Looks like it's gonna take quite some time so I will get back to you later with my results.
@tristanmilo85943 жыл бұрын
@Rey Jude It did the trick and I actually got access to my account again. I'm so happy:D Thanks so much, you saved my account!
@samanthaifill44222 жыл бұрын
Thank you so much for this! Are you able to import accounts as a subaccount? Or can you only import main accounts?
@davidkorn76932 жыл бұрын
I would also be interested in seeing a response to this question. If I have time to figure it out on my own, I will let you know.
@jamimurphy88027 жыл бұрын
You are the TRUTH Hector! Gracias!!!
@HectorGarciaCPA4 жыл бұрын
Jami Murphy :(
@wintrykiss3 жыл бұрын
this is what i needed i think but is there something i have to do to qb before i start this process ???? what needs to be in qb first ? i feel like there was a video before this one maybe ?
@kellimack16667 жыл бұрын
This is EXACTLY what I was looking for!! Thank you!
@HectorGarciaCPA7 жыл бұрын
+Kelli Mack :)
@hailegilamichael2697 Жыл бұрын
Which Microsoft do you recommend for quick books online
@miktham2 жыл бұрын
You save my day
@HectorGarciaCPA2 жыл бұрын
Great
@Mymusicfmw335 жыл бұрын
I tried using .iif file. Which would not import. Struggled for over an hour trying. We changed all our accounts/added accounts. I’m going to try your method. Wish me luck, and thank you.
@HectorGarciaCPA5 жыл бұрын
MS Cellaneous good luck
@brendamaez78982 жыл бұрын
We've started a parts warehouse and would like to know if we can import parts from excel spreadsheets.
@annesfavourites15626 жыл бұрын
Thank you for posting this video - I found it very helpful
@HectorGarciaCPA6 жыл бұрын
Anne's Favourites you welcome
@karlonikkoalconera63804 жыл бұрын
Hi? Good day. I am new to Quickbooks. Can I ask you something? Is it possible to directly import files from Varstreet to Quickbook desktop? Thank you.
@sandramatchen50387 жыл бұрын
Everytime I try to enter the excel file name I get an error message
@shanquaharrison1069 Жыл бұрын
Hi Hector. I want to merge my clien's former membership company into its 501c3 company. Can I do it in parts, like customer data, and vendor data or is there an order I have to transfer the info, Do I have to transfer the COA first? Thanks for all of your videos!!!
@HectorGarciaCPA Жыл бұрын
There is no merging nechanism
@shanquaharrison1069 Жыл бұрын
@@HectorGarciaCPA Thanks for getting back to me so promptly. I would use excel to export and import but it’s so important, I want to hire a tech professional
@camauhel-joe75396 жыл бұрын
Thanks alot @Garcia ...Grazie tutto
@crashkahuna4 жыл бұрын
Here's a dumb question. How do I start off with a blank chart of accounts in QB? I want to import the spreadsheet but I don't want any of the default accounts QB puts in there when I do company setup. Really like your videos.
@HectorGarciaCPA4 жыл бұрын
You have to delete them but the default ones will stay
@crashkahuna4 жыл бұрын
@@HectorGarciaCPA thanks! So every time I create a new company and import my chart I will still have to delete the default ones ie no way to tell QB not to create accounts when create new company. Maybe there is a 'business type' that has the fewest accounts. Will experiment.
@sarahnabil92435 жыл бұрын
How i can connect my data in Microsoft Excel even if it was (sales invoice or purchase invoice ,or journals entries) with quickbooks online in one click, please?
@HectorGarciaCPA5 жыл бұрын
There is no one-click for this.
@justinsanislo76993 жыл бұрын
How do you import many transactions from a online virtual terminal for credit card processing from sales made?
@HectorGarciaCPA3 жыл бұрын
You might need a tool like Transaction Pro Importer
@AuntyFabulous235 жыл бұрын
Hector: Once the Chart of Accounts was imported, can 3 months worth of expenses be imported as well? How do I do that?
@HectorGarciaCPA5 жыл бұрын
In the US you can dowload transactions from a bank.
@jimenaestupinan30314 жыл бұрын
Thank you so much Hector.
@HectorGarciaCPA4 жыл бұрын
You welcome
@sirgonhovi4 жыл бұрын
Hello Hector I am new to QB online and I am an accountant. I am equipped with trial Balances for 4years for a client. I want to prepare a set of final accounts for each year. What is your advice?
@HectorGarciaCPA4 жыл бұрын
Journal Entry
@emilycao93163 жыл бұрын
Don't know why I follow all your steps but when I do the mapping it pop up a window with "Pls map Type, Name fields in the import data column."
@HectorGarciaCPA3 жыл бұрын
what did technical support tell you?
@farhankhalid5169 Жыл бұрын
same problem
@zhangyu18513 жыл бұрын
It's great help, thanks
@HectorGarciaCPA3 жыл бұрын
You welcome
@farazferoze89254 жыл бұрын
Hi Hector Need change names of COA(4k), is there a easy way to do this? without losing historical data
@HectorGarciaCPA4 жыл бұрын
Faraz Feroze there is no easy way :( You might want to try CDATA
@farazferoze89254 жыл бұрын
@@HectorGarciaCPA Thanks for super quick response, Whats the best way to contact you ? need to discuss a small project for you
@HectorGarciaCPA4 жыл бұрын
Faraz Feroze hector@garciacpa.com
@ricnud4 жыл бұрын
Hola, se puede exportar facturas desde excel a quickbook premier retail?
@HectorGarciaCPA4 жыл бұрын
Necesitas una aplicación de un tercero
@maxfactor78295 жыл бұрын
Hello Hector - great videos!! Can a new account be imported as a sub-account?
@HectorGarciaCPA5 жыл бұрын
Yes
@galinawexler2874 жыл бұрын
@@HectorGarciaCPA how do you import the sub-accounts?
@HectorGarciaCPA4 жыл бұрын
Galina Wexler same way.. doesn’t change the process
@galinawexler2874 жыл бұрын
@@HectorGarciaCPA how do you format it in excel so that it knows an account is a sub of another? do you have a video for that?
@contadormeraki40003 жыл бұрын
@@galinawexler287 You need to add the Mayor Account name before the sub-acct name, separated by a ":", for example, GENERAL EXPENSES:Office Supplies
@rk0007gmail4 жыл бұрын
Sir how to import the 3 level chartof account from excel...?
@HectorGarciaCPA4 жыл бұрын
Rabees Kasmani you use colons.. like this: Account:Level2:Level3
@rk0007gmail4 жыл бұрын
@@HectorGarciaCPA where and how...? Should I insert another column in excel sheet or how...? Plz can you eleborate a little more plz...? I will be very thankfull to you...?