Organize, Clean, and Import Chart of Accounts into QuickBooks Desktop

[@jeanettealastra4528]

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..

[@haroldspanier9185]

Absolute best explanation by far. Leaves other youtubers in the dust.

[@Lyrica-r8b]

Thank you so much for your help! There is nowhere to take desktop classes anymore, you've been a blessing. My problem is the person who set up the QuickBooks originally somehow has 2 accounts, the checking account and the cash account both linked to the bank and the checking account shows a negative balance and the cash account is what is actually in our bank. HELP how do I fix this? I'm still new to QuickBooks so I didn't want to mess it up. We don't have our QuickBooks attached to the actual bank.

[@mimimd9652]

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!

[@HectorGarciaCPA]

You welcome.

[@tolulopeadeliyi2648]

Hi Hector, how do I edit accounts with subaccounts on the chart of accounts pls?

[@muhammadasim828]

Hi Hector. How to do this in QB Online. Is there any vedio of you on this.

[@HectorGarciaCPA]

Its very different, no there is no video like this

[@muhammadasim828]

I am doing cleaning of chart accounts in QB Online one by one by i.e. manually.

[@HectorGarciaCPA]

@@muhammadasim828 thats the only way to do it

[@parvezahamed6601]

24:36 import chart of accounts

[@marciadementruhr7283]

How do these changes affect prior years?

[@HectorGarciaCPA]

They do

[@marciadementruhr7283]

Does this have a negative impact? What should we do prior to making those changes?

[@caseylinehan1629]

how to purchase ultimate COA download? could not see on option on KZbin posting

[@HectorGarciaCPA]

quickbooks-training.net/ultimate-chart-of-accounts-for-quickbooks-desktop/

[@terrilea5146]

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.

[@HectorGarciaCPA]

Terri Lea there are other videos that talk about the add/edit tool, but not this one

[@cabdiqaadirmaxamed7332]

where can i download this chart of accounts sir? thank you

[@HectorGarciaCPA]

All the links are in the Description

[@bpjunk9234]

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?

[@HectorGarciaCPA]

Correct.. you need to make backups for previous period audits... because you will lose the history for sure.

[@DT817tx]

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.

[@HectorGarciaCPA]

DJTHECON on QuickBooks Online, the auto populate feature will enter amounts as well, not sure I like it.

[@donackerman8286]

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.

[@HectorGarciaCPA]

That is not available… closest thing would be a P&L and BS

[@dollyp.8718]

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!

[@HectorGarciaCPA]

Adjust the whole thing against retained earnings, problem solved.

[@zahidmalik7970]

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

[@abieflorendo4111]

Is this also applicable in Quickbooks online? My client gave me a new set of COA that he wanted us to use. Thank you

[@conniegarrick2431]

Thank you so much. Your videos are amazing and so helpful!

[@HectorGarciaCPA]

You welcome

[@jessicachen2243]

This video is very helpful, thank you!

[@graciehomestay3134]

Can you customize your Account Numbers with more than 7 Numbers?

[@HectorGarciaCPA]

No

[@writer.abhishek11.offical]

Sir HOW to change company industry in QuickBooks

[@HectorGarciaCPA]

?

[@writer.abhishek11.offical]

@@HectorGarciaCPA sir how to change company industry in QuickBooks

[@huzaifahshah3841]

thanks sir.one quistion i have how i import quicksbooks point of sale inventory data into desktops quicksbooks.kindly give me some direction sir

[@HectorGarciaCPA]

Huzaifah Shah I don’t use POS, sorry

[@huzaifahshah3841]

thanks sir but how import data into quicksbooks inventory

[@HectorGarciaCPA]

There is a video on that search it

[@rebeccamclelland9499]

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]

Need to match the types to the parent s

[@rebeccamclelland9499]

@@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?

[@HectorGarciaCPA]

No, you need to correct it first

[@oranngzeb]

Dear, really enjoying your helpful videos. Can you please make video on how to prepare, filing and adjust ( bad debts adjustment) VAT. Thanks

[@HectorGarciaCPA]

I don’t do VAT... I am in US

[@tammybarstow292SOLD]

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]

QuickBooks can’t “open” excel files... so not sure what you mean

[@tammybarstow292SOLD]

@@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! =)

[@louisianaprepper]

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!

[@HafijSafi]

All Video verry helpfull

[@HectorGarciaCPA]

:)