cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover the updated GST rates in QuickBooks Online Singapore Find out more
BSL_Ling
Level 3

How to import COA Template

In the accountants module, what is the template format for Import under COA Templates?  Is there a spreadsheet on the Detail Type for each Account Type?
1 Comment 1
AbegailS_
QuickBooks Team

How to import COA Template

Thanks for reaching out to us, @BSL_Ling. I'm here to help you answer your queries about importing your chart of accounts. 

 

For importing Chart of Accounts (COA) Templates in QuickBooks Online (QBO), the template format typically follows a CSV (Comma-Separated Values) file structure. However, a specific spreadsheet that lists the Detail Type for each Account Type in QuickBooks Online (QBO) is unavailable.

 

As a way around, you can look for a third-party app that lets you modify your chart of accounts. You can go to the Apps menu and browse for an app from there. Once you've found one, click it and select Get app now to link it to your QBOA account. 

 

Here’s a sample of how your spreadsheet should look.  

 

chart.JPG

 

 

Once you’re ready to import your chart of accounts, check out this link for the complete guidelines: Import your chart of accounts to QuickBooks Online 

 

Let me also share this resource you can read for future reference in reconciling your accounts effectively: Reconcile an account in QuickBooks Online.

 

 If there's anything else you need assistance with about your chart of accounts or with