Skip to content

Free template

A chart of accounts built for pool service companies

Fifty-three accounts in the vocabulary your accountant already uses in QuickBooks Online — with the pool-specific lines a generic template leaves out: route vehicle costs, technician labor, chemicals, openings and closings. Download the CSV and import it in minutes.

Download the CSV

Free. No email required. Intuit import layout: Account No., Account, Type, Detail type, Description.

53 accounts

Income, cost of services, expenses, assets, liabilities and equity: the whole ledger a pool company needs, nothing from other trades.

5-digit numbering

10000–80000 blocks, the convention QuickBooks uses in its industry templates, so accounts sort in the order an accountant expects.

Sub-accounts included

Service Income split into Weekly Maintenance, Repairs, Equipment Installation, Openings & Closings and Extra & Emergency Visits, so the P&L tells you where the money comes from.

Why a generic template isn't enough for a pool company

Most templates put fuel and truck repairs under Expenses. For a route business the truck is the job: the cost of driving to the pool belongs in Cost of Goods Sold, next to chemicals and the technician's hours, so gross profit reflects what it actually costs to service an account.

The same goes for revenue. One "Sales" line can't tell a weekly-maintenance dollar from a repair dollar or a seasonal opening — and those three carry very different margins.

This is the chart Pool Management System sets up for every company. It is published here as-is, so your books and your route operation can speak the same language.

How to import it into QuickBooks Online

  1. Download the CSV above.
  2. In QuickBooks Online, open Settings (the gear icon), then Import data, then Chart of accounts.
  3. Upload the file and confirm the column mapping — the headers already match, so the defaults are right.
  4. Review the preview and import. Sub-accounts appear as Parent:Sub-account and are created under their parent.

Importing adds accounts; it doesn't delete the ones you already have. If your company already has a chart, review duplicates before you import.

Every account, and what it's for

Names, types and detail types are QuickBooks' own — in English on purpose, because that is what your accountant matches one by one.

Bank

No. Account Type Detail type What it's for
10000 Checking Bank Checking Main operating bank account

Accounts receivable (A/R)

No. Account Type Detail type What it's for
11000 Accounts Receivable (A/R) Accounts receivable (A/R) Accounts Receivable (A/R) Money customers owe for products and services

Other Current Assets

No. Account Type Detail type What it's for
10100 Undeposited Funds Other Current Assets Undeposited Funds Payments received but not yet deposited
12000 Inventory Asset Other Current Assets Inventory Chemicals, parts and equipment held for use or resale
12500 Prepaid Expenses Other Current Assets Prepaid Expenses Expenses paid in advance, such as insurance premiums

Fixed Assets

No. Account Type Detail type What it's for
15000 Pool Service Equipment Fixed Assets Machinery & Equipment Pumps, vacuums, testing kits and other service equipment with useful life exceeding one year
15500 Vehicles Fixed Assets Vehicles Route trucks and other business vehicles
15800 Furniture & Office Equipment Fixed Assets Furniture & Fixtures Furniture and office equipment with useful life exceeding one year
17000 Accumulated Depreciation Fixed Assets Accumulated Depreciation Accumulated depreciation on equipment and vehicles

Accounts payable (A/P)

No. Account Type Detail type What it's for
20000 Accounts Payable (A/P) Accounts payable (A/P) Accounts Payable (A/P) Money owed to suppliers and vendors

Other Current Liabilities

No. Account Type Detail type What it's for
21000 Partner Payable (C2C) Other Current Liabilities Other Current Liabilities Remittance owed to subcontractor partners for executed services
22000 Sales Tax Payable Other Current Liabilities Sales Tax Payable Sales tax collected from customers and not yet remitted
23000 Customer Prepayments Other Current Liabilities Other Current Liabilities Deposits and prepayments received before the service is delivered
24000 Payroll Liabilities Other Current Liabilities Payroll Tax Payable Unpaid payroll liabilities. Amounts withheld or accrued, but not yet paid

Long Term Liabilities

No. Account Type Detail type What it's for
25000 Vehicle Loans Long Term Liabilities Other Long Term Liabilities Loans on route trucks and other vehicles

Equity

No. Account Type Detail type What it's for
30000 Opening Balance Equity Equity Opening Balance Equity Opening balances during setup post to this account. The balance of this account should be zero after setup
31000 Owner's Equity Equity Owner's Equity Owner's investment in the business, net of draws
32000 Retained Earnings Equity Retained Earnings Undistributed earnings of the business

Income

No. Account Type Detail type What it's for
40000 Service Income Income Service/Fee Income Income from pool services rendered
40100 Service Income:Weekly Maintenance Income Service/Fee Income Recurring route maintenance
40200 Service Income:Repairs Income Service/Fee Income Repair services
40300 Service Income:Equipment Installation Income Service/Fee Income Installation of pumps, filters, heaters and other equipment
40400 Service Income:Openings & Closings Income Service/Fee Income Seasonal pool openings and closings
40500 Service Income:Extra & Emergency Visits Income Service/Fee Income Visits outside the contracted route
41000 Parts & Chemicals Sales Income Sales of Product Income Sales of chemicals, parts and equipment to customers
42000 Commission Income (C2C) Income Service/Fee Income Commission earned as agent on services executed by a partner
49000 Discounts & Refunds Given Income Discounts/Refunds Given Discounts and refunds given to customers

Cost of Goods Sold

No. Account Type Detail type What it's for
50000 Cost of Goods Sold Cost of Goods Sold Supplies & Materials - COGS Direct costs of delivering pool services
50100 Cost of Goods Sold:Chemicals Cost of Goods Sold Supplies & Materials - COGS Chemicals used on jobs
50200 Cost of Goods Sold:Parts & Equipment Cost of Goods Sold Supplies & Materials - COGS Parts and equipment used on jobs
51000 Cost of Goods Sold:Technician Labor Cost of Goods Sold Cost of labor - COS Direct labor of technicians on routes and jobs
52000 Cost of Goods Sold:Route Vehicle Costs Cost of Goods Sold Other Costs of Services - COS Fuel, maintenance and other costs of route vehicles
53000 Cost of Goods Sold:Subcontractor / Partner Remittance Cost of Goods Sold Cost of labor - COS Amounts remitted to subcontractor partners for executed services (C2C gross)

Expenses

No. Account Type Detail type What it's for
60000 Advertising & Marketing Expenses Advertising/Promotional Advertising, marketing, website and other promotional expenses
60100 Auto & Truck Expenses (non-route) Expenses Other Miscellaneous Service Cost Fuel, oil, repairs and other vehicle costs not tied to routes
60300 Bad Debt Expense Expenses Bad Debts Customer balances written off as uncollectible
60400 Bank Fees & Merchant Fees Expenses Other Business Expenses Bank service fees and card processing fees
61000 Business Licenses & Permits Expenses Taxes Paid Business licenses, permits and related fees
61700 Software & Internet Expenses Office/General Administrative Expenses Software subscriptions, online fees and internet
62400 Depreciation Expense Expenses Other Miscellaneous Service Cost Depreciation on equipment and vehicles
63300 Insurance Expenses Insurance Liability, vehicle and other insurance expenses
63400 Interest Paid Expenses Interest Paid Interest on business loans, credit cards and other debt
64900 Office Expenses Expenses Office/General Administrative Expenses Office supplies, postage and general administrative expenses
66000 Payroll Expenses Expenses Payroll Expenses Payroll expenses
66100 Payroll Expenses:Salaries & Wages Expenses Payroll Wage Expenses Gross wages and salaries
66200 Payroll Expenses:Payroll Taxes Expenses Payroll Tax Expenses Employer payroll taxes
66700 Legal & Professional Fees Expenses Legal & Professional Fees Payments to accounting professionals and attorneys
67100 Rent Expenses Rent or Lease of Buildings Rent paid for offices, warehouse or storage
67200 Repairs & Maintenance Expenses Repair & Maintenance Incidental repairs and maintenance of business assets
68100 Telephone Expenses Utilities Telephone and mobile charges
68600 Utilities Expenses Utilities Water, electricity, garbage and other basic utilities
69000 Overhead (uncategorized) Expenses Other Miscellaneous Service Cost Overhead not yet assigned to a specific expense account

Other Income

No. Account Type Detail type What it's for
70000 Other Income Other Income Other Miscellaneous Income Income outside the normal business operations

Other Expense

No. Account Type Detail type What it's for
80000 Ask My Accountant Other Expense Other Miscellaneous Expense Transactions to be discussed with accountant, consultant, or tax preparer

The chart is free. The profit per account is the product.

Pool Management System ships with this chart built in and posts your invoices, payments and costs to it automatically — so you see which routes and accounts make money, not just the total.

30-day free trial. Card on file, nothing charged until it ends, cancel any time.
An unhandled error has occurred. Reload 🗙