Company File Setup and Chart of Accounts

Why the Company File and Chart of Accounts Matter

Every set of books lives inside a company file. In QuickBooks Online (QBO), the company file stores your client's identity, accounting preferences, and every transaction you will ever record. Getting these settings right at the start saves hours of corrections later. The Chart of Accounts (COA) is the backbone of that file: it is the master list of every account used to categorize money coming in, money going out, what the business owns, and what it owes. Employers and creditors rely on reports built from the COA, so accurate setup is a professional obligation, not just a classroom exercise.

Setting Up a New QBO Company File

When you first create a company file, QBO walks you through a setup wizard. You will enter:

• Company name – must match the legal or trade name exactly as the business uses it on tax documents.
• Industry – QBO uses this to suggest a starter COA; you will customize it afterward.
• Tax form – tells QBO which form the entity files (for example, Schedule C for a sole proprietor, Form 1120-S for an S-corporation). Choosing the wrong form can misclassify equity accounts.
• Fiscal year start month – most small businesses use January, but some use a different month; the setting controls period-end reports.
• Opening (start) date – the date from which QBO will track transactions. Entering opening balances on the correct date keeps your balance sheet accurate from day one.

After the wizard, QBO lands you on the dashboard. Before entering any transactions, verify these settings in Account and Settings (gear icon). Screenshot each screen as you work — this creates an audit trail and is required in today's lab.

Understanding the Chart of Accounts Structure

Every account in QBO belongs to one of five account types, which map directly to the two core financial statements:

| Account Type | Financial Statement | Examples |

|---|---|---|

| Asset | Balance Sheet | Checking, Accounts Receivable, Equipment |

| Liability | Balance Sheet | Accounts Payable, Credit Card, Loans Payable |

| Equity | Balance Sheet | Owner's Equity, Retained Earnings |

| Income (Revenue) | Profit & Loss | Sales of Product Income, Service/Fee Income |

| Expense | Profit & Loss | Rent, Utilities, Payroll Expenses |

Within each account type, QBO also asks for a detail type. The detail type gives QBO (and the IRS) finer information. For example, under the Asset type you might choose Checking or Savings as the detail type. Choosing the wrong detail type can cause accounts to appear in the wrong section of a report, so always match it carefully to the account's real purpose.

Account Numbering Best Practice

Most professional bookkeepers assign account numbers so accounts sort predictably:

• 1000–1999 – Assets
• 2000–2999 – Liabilities
• 3000–3999 – Equity
• 4000–4999 – Income
• 5000–5999 – Cost of Goods Sold
• 6000–6999 – Expenses

QBO does not require numbers, but turning them on (in Account and Settings → Advanced) makes reports easier to read and satisfies most clients.

Importing and Adding Accounts

QBO allows you to import accounts from a CSV file. The CSV must contain at least these columns: Name, Type, Detail Type, and optionally Number and Description. Column headers must match QBO's expected labels exactly — a single typo will cause the import to fail or mismatch. After import, verify every account in the COA list before adding manual accounts.

To add an account manually: go to Accounting → Chart of Accounts → New, fill in Type, Detail Type, Name, and Number, then save. Always double-check type and detail type before clicking Save — editing after transactions are posted can distort historical reports.

Exporting to Excel and Formatting

Once your COA is complete, export it: Accounting → Chart of Accounts → Run Report → Export (spreadsheet icon) → Export to Excel. In Excel:

1. Freeze panes on the header row (View → Freeze Panes → Freeze Top Row) so column labels stay visible when scrolling.

2. Auto-filter the header row (Data → Filter) so you or your instructor can sort and filter by account type quickly.

3. Widen columns so no text is cut off, then print to a PDF or paper.

Formatted exports are what you hand to a client or a CPA — sloppy formatting signals careless bookkeeping.

Data Security and Safe Practices

Company files contain confidential financial data. Follow these rules every session:

• Never share your QBO login credentials. Each student uses an individual Education trial account.
• Log out of QBO completely when stepping away from your workstation; do not leave a client file open on an unattended screen.
• Save your Excel export to a designated class folder, not a shared public drive, and do not email company data to personal accounts.
• Although this is a training environment, practice the same data-handling habits you will use with real clients. Mishandling client financial data can violate privacy agreements and damage your professional reputation.