All your videos are really helpful and informative. I cant help but, play, pause, rewind, fast forward and try it in my own! Thank you very much Hector! Your are such a brilliant QB person... Keep it up always..
Wow, I've been using QB for about 22 years. I wish there had been videos like this available when I started! I've been working on cleaning up my goofs as I've found time and I'll be checking back with you for more help. Thanks for the info!
Hi Hector, just in time for me to need an updated COA for a client! Thank you!! Did you not teach about the Paste from Excel in the Items window because some people do not have access? Just wondering. I can't imagine every opening each item one at a time to change the account anymore.
Thanks for the helpful information. If one changes account names, merges accounts, etc, I assume that if you run reports for prior periods the new Chart of Accounts would be reflected in the reports. Is that right? Does that cause issues with audits (tax and otherwise) if previously printed reports or tax returns can no longer be traced back to an original source entry?
Hi Hector Garcia Hope your doing well. I have deleted some fixed assets which i was wrongly created with balance in quickbook online. They removed from chart of accounts but they are still showing in Reports of journal. How i can remove them from reports. Thanks
Hi Hector! Is there a video explaining how to clean the 'Owner Draw' account? My owner draw account has this HUGE negative number that has built up over years (not just from this current year) I don't know how to fix this, I can't find any help online. I am currently using QB's Online. Thank you so much!
can you do a video on how to auto populate expenses. For example if i am entering a bill in quickbooks online, once i put the vendor in, the account it supposed to go to will auto populate.
How do I print or view a Chart of Accounts that shows the sub-accounts listed underneath the main account? I printed one in October 2020, but now I'm not seeing the same thing. The Account List that prints shows the accounts numerically and not with the sub-accounts indented.
Hello, When I uploaded my COA some of them where the wrong Account Type. But I have Parent accounts on most of them. How can I fix this without starting over?
@@HectorGarciaCPA I tried to change one of the parent accounts and it said I can't change and account with subaccounts. is there a way to make all the changes at once on a spreadsheet and then re-import them?
Hi Hector... it is not opening as an excel file... it keeps telling me that Only QuickBooks company files. It is not giving me an option to open as an excel. What part am I missing?
@@HectorGarciaCPA I tried opening the iff file to remove the top portion as you showed in your video. Did you open your file within QB? Thank you in advance for your help! =)
In another video, Hector opened a blank excel file, then dragged and dropped the iff file into the open spreadsheet. I believe he said in this video to delete the .txt extension after you save the file. Might be worth a try. Good luck!
All your videos are really helpful and informative. I cant help but, play, pause, rewind, fast forward and try it in my own! Thank you very much Hector! Your are such a brilliant QB person... Keep it up always..
Absolute best explanation by far. Leaves other youtubers in the dust.
Wow, I've been using QB for about 22 years. I wish there had been videos like this available when I started! I've been working on cleaning up my goofs as I've found time and I'll be checking back with you for more help. Thanks for the info!
You welcome.
Dear, really enjoying your helpful videos. Can you please make video on how to prepare, filing and adjust ( bad debts adjustment) VAT. Thanks
I don’t do VAT... I am in US
Hi Hector, just in time for me to need an updated COA for a client! Thank you!! Did you not teach about the Paste from Excel in the Items window because some people do not have access? Just wondering. I can't imagine every opening each item one at a time to change the account anymore.
Terri Lea there are other videos that talk about the add/edit tool, but not this one
Thanks for the helpful information. If one changes account names, merges accounts, etc, I assume that if you run reports for prior periods the new Chart of Accounts would be reflected in the reports. Is that right? Does that cause issues with audits (tax and otherwise) if previously printed reports or tax returns can no longer be traced back to an original source entry?
Correct.. you need to make backups for previous period audits... because you will lose the history for sure.
Hi Hector Garcia Hope your doing well. I have deleted some fixed assets which i was wrongly created with balance in quickbook online. They removed from chart of accounts but they are still showing in Reports of journal. How i can remove them from reports.
Thanks
Is this also applicable in Quickbooks online? My client gave me a new set of COA that he wanted us to use. Thank you
Hi Hector, how do I edit accounts with subaccounts on the chart of accounts pls?
Hi Hector! Is there a video explaining how to clean the 'Owner Draw' account? My owner draw account has this HUGE negative number that has built up over years (not just from this current year) I don't know how to fix this, I can't find any help online. I am currently using QB's Online. Thank you so much!
Adjust the whole thing against retained earnings, problem solved.
Thank you so much. Your videos are amazing and so helpful!
You welcome
can you do a video on how to auto populate expenses. For example if i am entering a bill in quickbooks online, once i put the vendor in, the account it supposed to go to will auto populate.
DJTHECON on QuickBooks Online, the auto populate feature will enter amounts as well, not sure I like it.
This video is very helpful, thank you!
How do I print or view a Chart of Accounts that shows the sub-accounts listed underneath the main account? I printed one in October 2020, but now I'm not seeing the same thing. The Account List that prints shows the accounts numerically and not with the sub-accounts indented.
That is not available… closest thing would be a P&L and BS
Hi Hector. How to do this in QB Online. Is there any vedio of you on this.
Its very different, no there is no video like this
I am doing cleaning of chart accounts in QB Online one by one by i.e. manually.
@@muhammadasim828 thats the only way to do it
All Video verry helpfull
:)
how to purchase ultimate COA download? could not see on option on RUclips posting
quickbooks-training.net/ultimate-chart-of-accounts-for-quickbooks-desktop/
How do these changes affect prior years?
They do
Does this have a negative impact? What should we do prior to making those changes?
where can i download this chart of accounts sir? thank you
All the links are in the Description
Hello, When I uploaded my COA some of them where the wrong Account Type. But I have Parent accounts on most of them. How can I fix this without starting over?
Need to match the types to the parent s
@@HectorGarciaCPA I tried to change one of the parent accounts and it said I can't change and account with subaccounts. is there a way to make all the changes at once on a spreadsheet and then re-import them?
No, you need to correct it first
24:36 import chart of accounts
thanks sir.one quistion i have how i import quicksbooks point of sale inventory data into desktops quicksbooks.kindly give me some direction sir
Huzaifah Shah I don’t use POS, sorry
thanks sir but how import data into quicksbooks inventory
There is a video on that search it
Can you customize your Account Numbers with more than 7 Numbers?
No
Hi Hector... it is not opening as an excel file... it keeps telling me that Only QuickBooks company files. It is not giving me an option to open as an excel. What part am I missing?
QuickBooks can’t “open” excel files... so not sure what you mean
@@HectorGarciaCPA I tried opening the iff file to remove the top portion as you showed in your video. Did you open your file within QB? Thank you in advance for your help! =)
In another video, Hector opened a blank excel file, then dragged and dropped the iff file into the open spreadsheet. I believe he said in this video to delete the .txt extension after you save the file. Might be worth a try. Good luck!
Sir HOW to change company industry in QuickBooks
?
@@HectorGarciaCPA sir how to change company industry in QuickBooks