QuickBooks HelpQuickBooksHelpIntuit

Create a chart of accounts from a template in QuickBooks Online Accountant

SOLVEDby QuickBooks1Updated January 08, 2024

Accountants and bookkeepers can use templates to quickly set up a chart of accounts for new or existing clients. With this organised list, you can focus on getting helpful insights and accurate reports from the start. 

In this article, you'll learn how to do the following tasks in QuickBooks Online Accountant:

  1. Find the chart of accounts templates
  2. Create a chart of accounts template
  3. Apply a chart of accounts template
  4. Edit a chart of accounts template

Where are the templates:

  1. Sign in to QuickBooks Online Accountant.
  2. Select Accountant Tools, then COA templates from Tools.

The pre-made product and service-based templates will be set up for you to apply or modify.

Chart of Accounts template screen

Create a template

  1. Select +Add new template.
  2. Select the type of template you want to create:  
    • Product-based business.
    • Service-based business.
    • Create template from scratch. 
  3. Select Next.
  4. Once you are satisfied with your chart of accounts setup, enter a template name and select Save

Notes:

  • Product-based and Service-based business templates have the most common parent accounts.
  • A Template from scratch displays only the available account types with the name and details blank for you to fill in. 
  • You can change the name, type, and details to fit your business.
  • You can +Add sub accounts, + Add new parent accounts, or even remove existing accounts.

Your new template will display under the chart of accounts templates page. Note: Accounts created from a template don’t apply to usage limits. 

All existing accounts will remain after you apply a template, including default accounts like Accounts Receivable (A/R) and Accounts Payable (A/P). Default accounts are also available in COA templates, but only add them to your template if you need a duplicate account.

Apply a template

After you have your template set up, you can apply it to any of your clients. To do so:

  1. Find the template you want to use from the list of chart of accounts templates, then select Apply template.
  2. Use Select a client to find and select your client. 
  3. Select Save and you’ll get the message that the template was successfully applied to your client.

If you have multiple instances or firms for QuickBooks Online Accountant, you won’t be able to export or share between them. But, all users can access and apply the same set of templates within the same QuickBooks Online Accountant firm instance.

That depends on a few different factors. Accounts won’t duplicate if:

Accounts with the same name and a different type/detail type will still duplicate. Those duplicate accounts will have an “-1” at the end. This repeats depending on how many duplicate accounts with the same name are added (-1, -2, and so on).

Edit a template

If you need to make changes, duplicate, or even delete a template:

  1. Find the template you want to use from the list of chart of accounts templates, then select the dropdown from Apply template.
    Edit menu for chart of accounts template.
  1. Select Edit.
    Note: this won’t change any chart of accounts that you’ve already applied.
  2. Make any changes you need to, then select Save when you’re done.

You can also select Delete to remove the template entirely or Duplicate to start another, similar template. 
Note: Once you delete a template, it’s no longer stored and can’t be reactivated.

Was this helpful?

You must sign in to vote, reply, or post

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this