Use a Chart of Accounts Not Included in QuickBooks

September 29, 2023

You may wish to use a Chart of Accounts that is not included in QuickBooks, such as the client below who asked about importing the National Association of Home Builders’ Chart of Accounts.

Q: How do I use the NAHB chart of accounts instead of using the one included with QuickBooks?

A: When creating a new company, select Other/None as the industry type.

To use the NAHB chart of accounts, either add each account manually or import them from an Excel file.

To import from an Excel file, open the File Menu and highlight Utilities. Select Import and Excel Files…

Make sure your Excel file identifies at least Account Type and Account Name. Refer to QuickBooks Help for other file specifications.

Click Advanced Import. The screen below appears.

Select the file and set up data mapping. Click Import.

Once you have imported the Chart of Accounts, press Ctrl + A to view the imported accounts. Make changes as necessary.

Gita Faust

About the Author

Gita Faust has over 30 years of accounting experience in the real estate and property management industry, Gita Faust is more than just a real estate investor; she is also popular for her work as an accountant, consultant, mentor, speaker, QuickBooks Top ProAdvisor, QuickBooks Solution Provider, member of Intuit’s Trainer/Writer Network, and, of course, author. Gita is well-known for her exemplary leadership and advisory skills. In fact, she even helped pioneer the adaptation of QuickBooks to suit the needs of professionals in real estate and property management. To share her knowledge she has written a series of courses titled Simplified Accounting Solution, which provides step-by-step guidance for those working with QuickBooks.

For Real Estate Investors

For Real Estate Investors

For Property Managers

For Real Estate Investors

For Real Estate Professionals

QuickBooks App

QuickBooks Software

Apps we use