Skip to main content

Chart of Accounts

The chart of accounts (COA) is the foundation of your general ledger. It defines every account where financial transactions are recorded. Books comes with a pre-configured COA optimized for MSP businesses, and you can customize it to match your needs.

Account Types

Every account belongs to one of these types:

TypeNormal BalanceDescription
AssetDebitThings you own (cash, receivables, equipment)
LiabilityCreditThings you owe (payables, loans, deferred revenue)
EquityCreditOwner's investment and retained earnings
RevenueCreditIncome from services and products
ExpenseDebitCosts of running the business
COGSDebitDirect costs of service delivery
Other IncomeCreditNon-operating income (interest, gains)
Other ExpenseDebitNon-operating expenses (interest, losses)

Account Subtypes

Each account type has more specific subtypes for detailed classification:

TypeSubtypes
AssetBank, Cash, Accounts Receivable, Other Current Asset, Fixed Asset, Accumulated Depreciation, Other Asset
LiabilityAccounts Payable, Credit Card, Current Liability, Long-Term Liability, Other Liability
EquityEquity, Retained Earnings, Owner's Equity, Common Stock, Paid-in Capital
RevenueRevenue, Sales Revenue, Service Revenue, Other Revenue
ExpenseOperating Expense, Payroll Expense, Depreciation Expense, Other Expense
COGSCost of Goods Sold

Default MSP Chart of Accounts

Books pre-configures these accounts for MSP businesses:

Assets (1000-1999)

  • 1000 — Cash (bank)
  • 1010 — Operating Checking (bank)
  • 1020 — Savings (bank)
  • 1100 — Accounts Receivable
  • 1200 — Undeposited Funds
  • 1300 — Prepaid Expenses
  • 1500 — Computer Equipment (fixed asset)
  • 1510 — Office Equipment (fixed asset)
  • 1600 — Accumulated Depreciation

Liabilities (2000-2999)

  • 2000 — Accounts Payable
  • 2100 — Credit Card
  • 2200 — Sales Tax Payable
  • 2300 — Payroll Liabilities
  • 2400 — Deferred Revenue
  • 2500 — Line of Credit

Equity (3000-3999)

  • 3000 — Owner's Equity
  • 3100 — Retained Earnings
  • 3200 — Owner's Draw

Revenue (4000-4999)

  • 4000 — Managed Services Revenue
  • 4100 — Project Revenue
  • 4200 — Product Sales
  • 4300 — Consulting Revenue
  • 4400 — Cloud Services Revenue
  • 4900 — Other Income

COGS (5000-5999)

  • 5000 — Cost of Goods Sold
  • 5100 — Software Licenses
  • 5200 — Hardware Costs
  • 5300 — Subcontractor Costs
  • 5400 — Cloud Infrastructure Costs

Expenses (6000-6999)

  • 6000 — Operating Expenses
  • 6100 — Payroll Expense
  • 6200 — Rent
  • 6300 — Utilities
  • 6400 — Insurance
  • 6500 — Marketing & Advertising
  • 6600 — Professional Services
  • 6700 — Travel & Entertainment
  • 6800 — Office Supplies
  • 6900 — Depreciation Expense

Adding Custom Accounts

  1. Navigate to Chart of Accounts
  2. Click New Account
  3. Select the account type and subtype
  4. Enter an account number following the numbering convention (see below)
  5. Enter a name and optional description
  6. Set the normal balance (auto-populated based on type)
  7. Optionally link it as a bank account
  8. Click Save

Account Numbering Conventions

Books follows standard accounting numbering:

RangeType
1000-1999Assets
2000-2999Liabilities
3000-3999Equity
4000-4999Revenue
5000-5999COGS
6000-6999Expenses
7000-7999Other Income
8000-8999Other Expense
💡Leave gaps between account numbers (e.g., 1000, 1010, 1020) so you can insert new accounts later without renumbering.

Hierarchical Accounts

Accounts can have a parent account for grouping. For example:

  • 6700 — Travel & Entertainment (parent)
    • 6710 — Airfare
    • 6720 — Hotels
    • 6730 — Meals

Set the parent_id when creating a sub-account. Reports will show both the detail and rolled-up parent totals.

Archiving Accounts

You cannot delete an account that has posted transactions. Instead, archive it:

  1. Open the account
  2. Click Archive
  3. The account no longer appears in dropdowns but its historical data is preserved

Importing from QuickBooks or Xero

To migrate your existing chart of accounts:

  1. Export your COA from QuickBooks or Xero as CSV
  2. Navigate to Data Import
  3. Select Chart of Accounts as the import type
  4. Upload the CSV file
  5. Map columns to Books fields (account number, name, type, subtype)
  6. Review the preview and click Import
⚠️Import creates new accounts — it does not merge with existing ones. Review the preview carefully to avoid duplicates. You can archive any duplicates after import.

System Accounts

Some accounts are marked as system accounts and cannot be edited or archived. These are required for Books to function:

  • Accounts Receivable
  • Accounts Payable
  • Undeposited Funds
  • Retained Earnings

Next Steps