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

QuickBooks 30-day free trial + 30% off for 12 months:
quickbooks.intuit.com/partner...
My ultimate Chart of Accounts for $48: qbkaccounting.com/ultimate-ch...
Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions [e-mail]
To setup a 30-day free trial of QuickBooks Online and then a 30% www.quickbooksoffer.com/?cid=i...

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

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

[@conniegarrick2431]

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

[@HectorGarciaCPA]

You welcome

[@jessicachen2243]

This video is very helpful, thank you!

[@orangzebkhan7153]

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

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

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

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

[@user-fp8dq8hk5v]

All Video verry helpfull

[@HectorGarciaCPA]

:)

[@tolulopeadeliyi2648]

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

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

[@parvezahamed6601]

24:36 import chart of accounts

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

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

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

[@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/

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

[@graciehomestay3134]

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

[@HectorGarciaCPA]

No

[@cabdiqaadirmaxamed7332]

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

[@HectorGarciaCPA]

All the links are in the Description

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

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

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

[@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!

[@writer.abhishek11.offical]

Sir HOW to change company industry in QuickBooks

[@HectorGarciaCPA]

?

[@writer.abhishek11.offical]

@@HectorGarciaCPA sir how to change company industry in QuickBooks