Saltar al contenido

Plantilla gratis

Un plan de cuentas hecho para empresas de piscinas

Cincuenta y tres cuentas en el vocabulario que tu contable ya usa en QuickBooks Online — con las líneas de piscina que una plantilla genérica deja fuera: coste del vehículo de ruta, mano de obra del técnico, químicos, aperturas y cierres. Descarga el CSV e impórtalo en minutos.

Descargar el CSV

Gratis. Sin email. Formato de importación de Intuit: Account No., Account, Type, Detail type, Description.

53 cuentas

Ingresos, coste de los servicios, gastos, activos, pasivos y patrimonio: todo el libro que necesita una empresa de piscinas, nada de otros sectores.

Numeración de 5 dígitos

Bloques 10000–80000, la convención que QuickBooks usa en sus plantillas por sector, para que las cuentas se ordenen como espera un contable.

Subcuentas incluidas

Service Income dividida en Weekly Maintenance, Repairs, Equipment Installation, Openings & Closings y Extra & Emergency Visits, para que el P&L diga de dónde viene el dinero.

Por qué una plantilla genérica no basta para una empresa de piscinas

La mayoría de las plantillas ponen el combustible y las reparaciones de la furgoneta en Gastos. En un negocio de rutas, el vehículo es el servicio: el coste de llegar a la piscina pertenece al Coste de los Servicios, junto a los químicos y las horas del técnico, para que el beneficio bruto refleje lo que de verdad cuesta atender una cuenta.

Lo mismo con los ingresos. Una sola línea "Sales" no distingue el dólar del mantenimiento semanal del de una reparación o una apertura de temporada — y los tres tienen márgenes muy distintos.

Este es el plan que Pool Management System configura para cada empresa. Se publica aquí tal cual, para que tu contabilidad y tu operación de rutas hablen el mismo idioma.

Cómo importarlo en QuickBooks Online

  1. Descarga el CSV de arriba.
  2. En QuickBooks Online, abre Settings (el engranaje), luego Import data y Chart of accounts.
  3. Sube el archivo y confirma la asignación de columnas — las cabeceras ya coinciden, así que los valores por defecto son correctos.
  4. Revisa la vista previa e importa. Las subcuentas aparecen como Padre:Subcuenta y se crean bajo su cuenta padre.

Importar añade cuentas; no borra las que ya tienes. Si tu empresa ya tiene un plan, revisa duplicados antes de importar.

Cada cuenta, y para qué sirve

Nombres, tipos y detail types son los de QuickBooks — en inglés a propósito, porque es lo que tu contable coteja una a una.

Bank

N.º Cuenta Type Detail type Para qué sirve
10000 Checking Bank Checking Main operating bank account

Accounts receivable (A/R)

N.º Cuenta Type Detail type Para qué sirve
11000 Accounts Receivable (A/R) Accounts receivable (A/R) Accounts Receivable (A/R) Money customers owe for products and services

Other Current Assets

N.º Cuenta Type Detail type Para qué sirve
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

N.º Cuenta Type Detail type Para qué sirve
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)

N.º Cuenta Type Detail type Para qué sirve
20000 Accounts Payable (A/P) Accounts payable (A/P) Accounts Payable (A/P) Money owed to suppliers and vendors

Other Current Liabilities

N.º Cuenta Type Detail type Para qué sirve
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

N.º Cuenta Type Detail type Para qué sirve
25000 Vehicle Loans Long Term Liabilities Other Long Term Liabilities Loans on route trucks and other vehicles

Equity

N.º Cuenta Type Detail type Para qué sirve
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

N.º Cuenta Type Detail type Para qué sirve
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

N.º Cuenta Type Detail type Para qué sirve
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

N.º Cuenta Type Detail type Para qué sirve
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

N.º Cuenta Type Detail type Para qué sirve
70000 Other Income Other Income Other Miscellaneous Income Income outside the normal business operations

Other Expense

N.º Cuenta Type Detail type Para qué sirve
80000 Ask My Accountant Other Expense Other Miscellaneous Expense Transactions to be discussed with accountant, consultant, or tax preparer

El plan es gratis. El beneficio por cuenta es el producto.

Pool Management System ya viene con este plan y registra en él tus facturas, cobros y costes automáticamente — para que veas qué rutas y cuentas dan dinero, no solo el total.

Prueba gratis de 30 días. Tarjeta al registrarte, sin cargo hasta el final, cancelas cuando quieras.
An unhandled error has occurred. Reload 🗙