Cheers for this, been searching for "quickbooks online bookkeeper" for a while now, and I think this has helped. Ever heard of - Aleacob Marvelous Ascendancy - (search on google ) ? It is a smashing one off guide for discovering how to master quickbooks minus the hard work. Ive heard some incredible things about it and my co-worker got cool success with it.
Very informative and detailed video...Thanks Hector sir for providing us details with optimal pace and details....Appreciate if you come up with more videos explaining such narrowly focused topics with comprehensive details and explanation....Clarity and crispiness was another hallmark of this video...Commendable efforts sir!!
Very thankful to you dear for sharing this.... i am using quickbook too in my company and i got answer of few questions which was in my mind.. May Allah bless you
Hector-Your video was excellent! Your section on how to merge accounts was especially helpful. I would like to see a comprehensive video on all the standard reports.
We need a video on carrying forward closing balance to opening balance. How to do that? When starting a new financial year, how to start it on QuickBooks. It is confusing of opening balance equity. Need ur help
The previous treasurer I took over from was using Quickbooks Desktop Pro 2016, and until I upgrade to the online version I am using this older version. He has several memorized reports already set up. I have added a couple new accounts to the chart of accounts, and have added sub accounts to already existing accounts. Everything seems great in the chart of accounts. I thought these new accounts would show up in the memorized P&L Budget performance, but they do not. I've been trying to figure out how to get them added to the memorized report but am lost. Is there a way?
Hello Hector Can you Help me what will be category for Cleaning service or business, for example I have my business Cleaning Service I am charging customer $2 a ft. and wholesale my vendor cleaner charging me $1 a ft. what should be this $1 category what should be $1 my profit and also what should be $1 I'm paying my vendor or servicing company, basically I'm a middleman I'm making profit $1 in the middle when I enter Item Service Expense or COGS ?? Thank you
Hector sorry to bother you, I know you posted this video long time ago however I am trying to use it now to learn how to use quickbooks. I am not an accountant, and I am trying to do the same thing that you did to import excel files but I got this error Please map Type, name fields in the import data column. Do you know how I can fix it?
Its very hard to walk you through it via text like this. If you contact my office, you can schedule a one on one training/consultation with a person from my team
Hector how to I make sure my sales team is not selling below markup. I have noticed that when invoicingthey are able to change the price how do I stop that
I learned a lot from your video. Thanks. I would like to make my Chart of Account more simple by using item list item and sub item instead of sub account in my Chart of account Expenses (which is where I record my expenses now). I can create new items in item list and use them at of the date of my new fiscal year but is there a way to import the existing transactions already posted in the existing accounts from the chart of account? Thanks.
it would be great if all learning videos would be in a sequence form i.e., step by step videos for all the beginners who never worked before in Quickbooks like Lesson Number 1 (Putting hands on Quickbook) or Quickbook basics then slowly and gradually upward and getting mastering in Quickbooks.
Thanks for this video my question is, is it available to replace all default accounts on QB new company file with a chart of accounts using excel file with mentioned format or i only have the option to add new accounts
I have accountant version quick books 2015 and am very intimidated to use. I have a small business very small, rental properties, ebay store, vacation rentals, and I thought quickbooks would be my savior to maintain my tax nightmares, however I do not have separate cc cards for each of these so one main card does multiple charges. I have created chart of accounts for my personal life, and chart of accounts for business. However when statement comes in i want to be able to switch between accounts to enter transactions easily, but I use to have all pulled up as multiple tabs in bottom so i could do so but I do not know how to now. Is it possible?
Hector, I don’t understand why a vendor refund is categorized as income. Shouldn’t we just reverse payment on account that was debited??? Income can potentially be taxed, so why would we risk raising our income?
Vendor refunds are not income… are a reversal of the original expenditure. Customer refund is income (well contra-income) reversing the effect of income
Hi Hector, If our accountant updates stuff in the Chart of Accounts and in the "Accounting" tab, does the transaction move out of "For Review" from the "banking tab"?
Hey Hector, thank you for the great video: I run a small computer repair business and I purchase items as a need to use basis for example a customers screen needs replaced so i go to a seller on ebay or even amazon and purchase it ( what do i list that expense under?)
Can I use item list to divide some Expenses from the Expenses accounts in Chart of account. Ex if I have Vehicule Expense and gaz as a subdivision in Chart of account , can I use the item list to separate the gaz bought for each vehicule? If yes which item category should I use?
@@HectorGarciaCPA But I would like to book and track those orders separately as say Channel Income. I guess the question boils down to how can I find a way to create Types of Income. I will have Online vs Direct Sale channels, so I want to be able to track them closely. Even down to Landing Pages and Ads that were utilized to capture those customer.
how can we enter the opening balances for each account or is it possible to prepare a chart of accounts in excel with opening balances and export then to Quickbook enterprise or not and what would be the format of the excel file to be easily uploaded to the Quickbook Enterprise?
Javed Shakir you can’t import it with built in tools, you need to use an Importing app to bring a journal entry... www.transactionproimporter.com is about $200
Thanks for this helpful video. Just wondering how do you import a chart of accounts with sub accounts? Is it just a matter of adding a sub account field in the mapping? Thanks Hector
I never used Accounting Software before. i have one Question which Account does Purchase Return or Sales Return Come under in Quickbook Destop Pls anybody can help.
The most important thing for any business is.. ACCOUNT RECEIVABLE. My former long-term boss always stressed that.. and CASH FLOW. Where a new, part-time bookkeeping person needs to know.. in term of Quick Books... is HOW to enter invoices properly.. and to track payments to be credited toward those invoices. Nothing is an important as this.
Very informative. Explains material really well. I appreciate your pace... NOT slow and drawn out. Quick and to the point. Thank you!
Thank you hector, I appreciate the way you teaching demo is very Clear. Your awesome thank you all the way from the Phillipines
I love Hector Garcia's QuickBooks instructions.
+Shirl Matz thank you.. I am glad you find them
helpful
Cheers for this, been searching for "quickbooks online bookkeeper" for a while now, and I think this has helped. Ever heard of - Aleacob Marvelous Ascendancy - (search on google ) ? It is a smashing one off guide for discovering how to master quickbooks minus the hard work. Ive heard some incredible things about it and my co-worker got cool success with it.
chart of accounts spreadsheet: www.quickbooks-training.net/chart-accounts-complete-list-descriptions/
Thank you very much! This is exactly what I have been looking for. You are AMAZING!!!!!! :)
Incredibly informative, thank you for taking the time to do this!
Kelly M you are welcome
I like this video. The explanation was very clear and made sense based on the perspective of the accounting view setup. Thanks a lot!
Very informative and detailed video...Thanks Hector sir for providing us details with optimal pace and details....Appreciate if you come up with more videos explaining such narrowly focused topics with comprehensive details and explanation....Clarity and crispiness was another hallmark of this video...Commendable efforts sir!!
:)
Very Helpful. I am learning more from your channel then I ever did on Intuit. Thank you so much!
oh wow.. that is high praise.. thanks.
Thank you, Hector! It's very helpful!
You are welcome!
I really enjoy your tutorial videos. They are very helpful for my learning Thank
Tanks for doing this. I am new to quickbooks and it is helping me so much, thanks!!
Great tip! I had thousands to inactivate.....took about 10 minutes of effort!
Cool
Hector awesome as always! I always get so much from your videos.
i like how you teach. very helpful and easy to inderstand.
Great! You welcome
Very thankful to you dear for sharing this....
i am using quickbook too in my company
and i got answer of few questions which was in my mind..
May Allah bless you
Just fabulous!!!! I am a new subscriber and I am super excited to go thru your content :) Thank you for all of your hard work and sharing!
I really enjoy your tutorial videos. They are very helpful and thorough.
Hector-Your video was excellent! Your section on how to merge accounts was especially helpful. I would like to see a comprehensive video on all the standard reports.
There are a few on “custom reports” check them out
Thank you.
Thanks for all the COA explainations. Very useful to get around the accounts.
Wil Gong glad you liked it
Best video yet! Thanks for the valuable info.
+FOL TREASURER :)
The best video how to understand chart of accounts. Many Thanks
Orangzeb Malik thanks you!
This was fantastic and helpfull. Am impressed
Great videos man. You rock. I got a lot of conceptual stuff sorted out after viewing this. Thanks.
Thank you; glad you liked it
This was extremely helpful!
Awesome!
Thank you so much! I learn a lot from your videos
Thank you this is helpful and clear.
I love your teaching, very excellent ! Thank you Hector Garcia's. I have taken QuickBook Enterprise :)
Radha Luitel good glad you liked it
I've been looking for your series on QB desktop certification tutorials which you referred to in another video. This video was great too.
Hectorgarcia.teachable.com
i joined one of your tutorials , i found this one many thanks excellent teaching !
great
Thank you so much..
I am really like it thanks, it's very helpful
:)
you should make more those youtube !!!@@HectorGarciaCPA
Thanks sir❤
You're welcome!
@12:14 Is merging accounts case sensitive? (Upper and lower case)
e.g.
Income 1 and income 1
will they be merged?
No
Very helpful. Thank you so much
We need a video on carrying forward closing balance to opening balance.
How to do that? When starting a new financial year, how to start it on QuickBooks.
It is confusing of opening balance equity.
Need ur help
Very informative and easy to follow
Michael Alexander glad you liked it
I like how clear you present the tutorial. How do I create COA for non profit org?
thank you sir. please make more videos. thank you again
many thanks i bought your udemy course a long time ago
+ndelpurg great...
Appreciate the video. Extremely helpful!
You welcome
Hi, Thanks for this video. I was wondering if you provide any classes to teach quickbooks?
We do. Private 1on1 and pre-recorded
@@HectorGarciaCPA Thanks for your reply. Where can I apply?
@@kirtidhiman5397 call my office MF 9-5 EST 954-414-1524. Cost starts at $375 USD
@@HectorGarciaCPA Thank you so much
Great video, thank you for the information. Very helpful.
Thank you for this video. Very helpful!
Inkyu Yu :)
+Inkyu Yu :)
Is it possible to restructure the account codes in QuickBooks without affecting historical data?
Always affects historical
Very helpful thank you
Thank you very much for this very valuable information!
You welcome
I'D LIKE TO SEE A VIDEO FOR ENTERING PRIOR YEAR'S A/R AND A/P BALANCEW WHEN CREATING A START UP CHART OF ACCOUNTS FOR A WUBWE1UENT YEAR?
How do you change an existing account type when it is in a sub account or the parent of a sub account?
Good stuff. Thank you Hector.
thanks
Very interesting and helpful, Thanks
E MULTI SERVICES LLC welcome
I like the content
lovely tutorial
Thanks
The previous treasurer I took over from was using Quickbooks Desktop Pro 2016, and until I upgrade to the online version I am using this older version. He has several memorized reports already set up. I have added a couple new accounts to the chart of accounts, and have added sub accounts to already existing accounts. Everything seems great in the chart of accounts. I thought these new accounts would show up in the memorized P&L Budget performance, but they do not. I've been trying to figure out how to get them added to the memorized report but am lost. Is there a way?
If the accounts dont have data; they wont show up
Hello Hector
Can you Help me what will be category for Cleaning service or business, for example I have my business Cleaning Service I am charging customer $2 a ft. and wholesale my vendor cleaner charging me $1 a ft. what should be this $1 category what should be $1 my profit and also what should be $1 I'm paying my vendor or servicing company, basically I'm a middleman I'm making profit $1 in the middle when I enter Item Service Expense or COGS ??
Thank you
Again...Legend!
Haha.. thanks
Hector sorry to bother you, I know you posted this video long time ago however I am trying to use it now to learn how to use quickbooks. I am not an accountant, and I am trying to do the same thing that you did to import excel files but I got this error Please map Type, name fields in the import data column. Do you know how I can fix it?
Its very hard to walk you through it via text like this. If you contact my office, you can schedule a one on one training/consultation with a person from my team
Where do i find that list of reccomended chart of accts for different industries?
The link is in the description section
Loved the video. I am new to utube lol so can you tell me were to do the link for example chart of accounts please
Link is in the description
quickbooks-training.net/chart-accounts-complete-list-descriptions/
Quite educative
Ugbede Den thanks
Hector, how do I pay my credit card bill through chart of accounts?
Hector how to I make sure my sales team is not selling below markup. I have noticed that when invoicingthey are able to change the price how do I stop that
There is no way to stop it
@@HectorGarciaCPA Thankyou
Hi Hector how are you, i have a challenge how may I add an account to work as a sub account but in two different groups
Cannot
I learned a lot from your video. Thanks. I would like to make my Chart of Account more simple by using item list item and sub item instead of sub account in my Chart of account Expenses (which is where I record my expenses now). I can create new items in item list and use them at of the date of my new fiscal year but is there a way to import the existing transactions already posted in the existing accounts from the chart of account?
Thanks.
Louise Seguin you would have to reclassify all those
Can you explain a bit more? How do I do that?
search "quickbooks accountant reclassify transactions"
it would be great if all learning videos would be in a sequence form i.e., step by step videos for all the beginners who never worked before in Quickbooks like Lesson Number 1 (Putting hands on Quickbook) or Quickbook basics then slowly and gradually upward and getting mastering in Quickbooks.
Javed Shakir well for that, you take the course: www.quickbooksacademy.com $57
Hector Garcia CPA Let me go through the Quickbooks and I will be giving all that for free on UA-cam
When we recorded income crediting income but the contra account is not showing what has debited? to please advise in detail. thanks
Sorry not enough context to answer this question
Hi
can we add picture with inventory item at desktop version ?
In enterprise
I do not see accountant tab in my Quickbook, how can I add the Accountant tap to be able to use Reclassify function?
Emily Cao you need to upgrade to the Accountant edition it’s about $500 more
Thanks for this video
my question is, is it available to replace all default accounts on QB new company file with a chart of accounts using excel file with mentioned format or i only have the option to add new accounts
Mahmoud Elbakhshwan is an option
Thanks
Really appreciate
I have accountant version quick books 2015 and am very intimidated to use. I have a small business very small, rental properties, ebay store, vacation rentals, and I thought quickbooks would be my savior to maintain my tax nightmares, however I do not have separate cc cards for each of these so one main card does multiple charges. I have created chart of accounts for my personal life, and chart of accounts for business. However when statement comes in i want to be able to switch between accounts to enter transactions easily, but I use to have all pulled up as multiple tabs in bottom so i could do so but I do not know how to now. Is it possible?
You can open up to two QB files at the time with QB Desktop accountant
New tires for my truck what would I chart that under?
Repairs and maintenance
My opening balance equity(balancing account) not showing zero how can I correct it and how can I change the item which is already entered
Undo the reconciliations
Hector, I don’t understand why a vendor refund is categorized as income. Shouldn’t we just reverse payment on account that was debited??? Income can potentially be taxed, so why would we risk raising our income?
Vendor refunds are not income… are a reversal of the original expenditure.
Customer refund is income (well contra-income) reversing the effect of income
i love this
Thanks; I am glad you liked it.
Hi Hector, If our accountant updates stuff in the Chart of Accounts and in the "Accounting" tab, does the transaction move out of "For Review" from the "banking tab"?
It should
cool, thanks for answering so fast. really appreciate all your help!
Hey Hector, thank you for the great video:
I run a small computer repair business and I purchase items as a need to
use basis for example a customers screen needs replaced so i go to a
seller on ebay or even amazon and purchase it ( what do i list that
expense under?)
Catalina Gardner a cost of goods sold account called “parts” or “materials”
Can I use item list to divide some Expenses from the Expenses accounts in Chart of account. Ex if I have Vehicule Expense and gaz as a subdivision in Chart of account , can I use the item list to separate the gaz bought for each vehicule? If yes which item category should I use?
Louise Seguin yes use subaccounts
Hector, how can I track the income from a customer who has been sold through a Reseller!? What do I set up for the Reseller in Chart of Accounts? TY
I don’t think that the type of customers you have affects your chart of accounts
@@HectorGarciaCPA But I would like to book and track those orders separately as say Channel Income. I guess the question boils down to how can I find a way to create Types of Income. I will have Online vs Direct Sale channels, so I want to be able to track them closely. Even down to Landing Pages and Ads that were utilized to capture those customer.
how can we enter the opening balances for each account or is it possible to prepare a chart of accounts in excel with opening balances and export then to Quickbook enterprise or not and what would be the format of the excel file to be easily uploaded to the Quickbook Enterprise?
Javed Shakir you can’t import it with built in tools, you need to use an Importing app to bring a journal entry... www.transactionproimporter.com is about $200
Does anyone know how to find the record count for quickbooks desktop {chart of accounts}?
Hit CTRL 1 on the keyboard
hello we can activate number in chart of account
Yes, you can turn on the preference
Thanks for this helpful video. Just wondering how do you import a chart of accounts with sub accounts? Is it just a matter of adding a sub account field in the mapping? Thanks Hector
Kwkiwi just add it with a colon
thkz for your sacrifice of us but I need helping for written chart accounting to establishe my company system accounting
salli Calee :)
Quickbooks support in jeddah 0126280424
Why other accounts like expanse account Balance Total is not visible????
Only balance sheet accounts (assets, liabilities, equity) have balances
Payroll?
HOW I CREAT HOUSE ACCOUNT FOR CUSTOMERS I USE PREMIER 2020 THANK YOU
Describe “house account”
@@HectorGarciaCPA customers paying items and pay end of the month or week
my business is grocery store
I never used Accounting Software before. i have one Question which Account does Purchase Return or Sales Return Come under in Quickbook Destop Pls anybody can help.
Purchase return will likely be Cost Of Goods Sold
@@HectorGarciaCPAthank u so much
The most important thing for any business is.. ACCOUNT RECEIVABLE. My former long-term boss always stressed that.. and CASH FLOW. Where a new, part-time bookkeeping person needs to know.. in term of Quick Books... is HOW to enter invoices properly.. and to track payments to be credited toward those invoices. Nothing is an important as this.
Very true.
great video, but you need a better mic
Krisp 868 this is old... I have upgraded even since
Mr Motha fuckin bean
Yes... I am a bean counter.
your sound is horrible
There are some issues, yes. Sorry