cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
michaelhw-talkta
Level 1

Has any academy school imported the new department for education chart of accounts into QB's

It is the 2020/21 chart of accounts that i would like to import into QB's - this is for a single form entry primary school which is a single and stand alone academy trust
1 REPLY 1
CharleneMaeF
QuickBooks Team

Has any academy school imported the new department for education chart of accounts into QB's

I'm here to help you import your accounts, michaelhw.

 

We can import your Chart of Accounts using an Excel CSV file in QuickBooks Online. However, the program uses a double-entry system. Therefore, we'll have to use another account that'll help you balance the transactions.

 

To import the data, I'd recommend following these steps:

 

  1. Sign in to QuickBooks Online.
  2. Go to the Gear icon and then select Import Data.
    Capture.PNG
  3. Select Chart of Accounts.
    Capture1.PNG
  4. To upload a file from your computer, select Browse and choose the file. 
  5. Click Open, then Next.
    Capture2.PNG
  6. Once done, review the accounts to ensure everything is added accurately.

 

I've added an article that'll help you ensure the format is correct: Import your Chart of Accounts to QuickBooks Online.

 

When tracking the transactions, we'll have to create a journal entry. If you're unsure what type of account to use to balance the debits and credits, I'd recommend consulting an accountant to help you out.

 

For visual reference of what the entry looks like, I've added a screenshot below.

Capture3.PNG

 

Additionally, I'll be sharing these articles to help you learn the different ways how to manage your imported accounts: 

 

 

Please let me know if you need additional assistance managing the list of your accounts. It's my priority to ensure the data are added successfully.

Need to get in touch?

Contact us