Importing Your Chart of Accounts into QuickBooks Online with the Excel Template
How the Excel import template fills a new QuickBooks Online chart of accounts in one pass, and the errors that flag rows red at review.
New QuickBooks Online company files in Australia tend to hit the same wall early on: the chart of accounts. The list starts almost empty, and it sits beneath every report, every GST line and every transaction you post. Adding accounts one at a time is fine for a handful. For a business arriving with years of history, the built-in Excel import is the faster road, and it rewards a little preparation before you touch the spreadsheet.
Where do new setups stall?
The chart of accounts is the complete list of accounts a company uses and the balances held in each one. QuickBooks Online can create accounts individually from the Chart of accounts screen, but an established business rarely starts with three or four. It starts with dozens of income and expense categories, often with a numbering scheme attached.
Timing matters as much as method. The best moment to build the list is before any bank or card account is connected. Once feeds run, transactions land in whatever account the feed uses, and reshuffling the structure later means tidying history as well as the list.
GST adds a third constraint for Australian files. If you need the accounts to show and track GST rates, set up GST in QuickBooks before you import. Getting that order right spares you a second pass through the finished list.
The import path
Start in the Bookkeeping menu and open Chart of accounts. Click the dropdown arrow beside New and choose Import, then download the sample file. That spreadsheet becomes your working document: fill it with your accounts, save it as .xlsx or .csv, and take it back through the same import screen.
Nothing is written to your company file straight away. The import passes through a review step where problems are shown in red, and that review is where a first attempt usually succeeds or stalls.
Inside the Excel template
The template is built to cut typing errors, not just typing time. Most columns use dropdown menus, so an entry is either valid or visibly not. The detail type column deserves particular attention: the options it offers depend on the account type you choose beside it. Set the account type first, then pick the detail type from the filtered list.
Two habits cause avoidable rework. Renaming the file is fine, and saving as .xlsx or .csv is expected, but altering the sheet’s internal formatting, editing the headers in row one, or leaving a green required column blank will break the import. Keep a blank copy of the original template on hand as well, and hold onto the completed version once the import succeeds; it gives you a readable backup of the structure outside QuickBooks.
Setting up header and sub-accounts
The hierarchy is built inside the name column itself. Enter the header account on its own row. In the row directly below, type the header’s name again, add a colon, and put the sub-account’s name straight after it. A generic example: Motor expenses on one row, then Motor expenses:Fuel beneath it, files Fuel as a sub-account.
Both rows must carry the same account type. That match is what ties the hierarchy together, so check it before you import rather than after.
Why does the import flag rows in red?
Three errors account for most of the red flags at the review step. Duplicate account numbers: each account needs a number no other account uses. Duplicate names: two accounts cannot share the same wording. Types entered outside the preset lists: both the account type and detail type must come from the options the file provides, not text typed over the dropdown.
All three are marked in red before anything is committed. Correct the flagged values in the spreadsheet, save, and take the file through the import again.
A note on accountant-managed files
There is a second route worth knowing about. QuickBooks Online includes a templates capability on the accountant side that can generate a chart of accounts automatically. If someone else builds or maintains your list, check which method is in play before adding accounts by hand, so the chart is created once rather than twice.
The short version
Plan your numbering and names before opening the spreadsheet. Set up GST first where it applies, and import before bank feeds connect. Let the template’s dropdowns do the work, and treat the red-flag review as part of the job rather than a sign of failure. Done in that order, the whole chart lands in a single pass.