4-Digit General Ledger Architecture & Free CSV Downloads
QuickBooks Chart of Accounts template for contractors and service businesses
Default QuickBooks Online templates lump field technician labor into overhead, lack payment clearing accounts for ServiceTitan, BuildOps, Housecall Pro, or Jobber, and omit ASC 606 WIP and retainage accounts. In our analysis of 1,275 bookkeeping and accounting job postings, 519 business owners needed urgent help redesigning a bloated or misclassified Chart of Accounts.
Download all 6 QuickBooks Online Chart of Accounts & diagnostic CSVs
Every CSV is formatted for direct QuickBooks Online import with 4-digit account numbers, account types, detail types, and subledger mapping notes. No email gate required.
QBO Import CSV
Residential & Commercial HVAC, Plumbing & Electrical
Includes residential replacement, demand service, commercial work, Account 2420 membership deferral, and 1150/1160/1170-1180 clearing accounts (1170 primary processor clearing; add 1180 for secondary financing/POS subledgers).
QBO Import CSV
Commercial Fire, Life-Safety & Mechanical Contractors
Includes NFPA inspection deferral (Account 2410), retainage receivable (1210), staged materials (1360), and ASC 606 WIP accounts (1350/2450).
QBO Import CSV
Core 20-Account Contractor Job-Costing & Clearing COA
Streamlined contractor Chart of Accounts with 1150/1160/1170-1180 clearing (1170 primary processor clearing), 5100 Direct Field Labor, 5150 Payroll Burden, and 5200 Materials.
QBO Import CSV
Restaurant, Hospitality & Multi-Unit POS Operators
Includes Toast/Square POS clearing (1170), DoorDash/UberEats clearing (1180), POS Tips Payable (2230), Gift Cards (2430), and prime cost.
QBO Import CSV
E-Commerce, Shopify & 3PL Inventory Brands
Includes Shopify/Stripe/Amazon gateway clearing (1170-1180), ASC 330 landed inventory (1310), and customer deposits/gift cards (2430).
QBO Import CSV
18-Check Day-1 QBO Diagnostic Workpaper
Complete 18-check reconciliation checklist covering bank feeds, clearing accounts (1150-1180), AR/AP aging tie-outs, and tax equity.
The 4-digit contractor & service business Chart of Accounts structure (1000-7990)
| Number Band | Financial Statement Section | Core Control Accounts Included |
|---|---|---|
| 1000 - 1190 | Cash, Operating Checking & 3-Account Clearing Architecture | 1010 Operating Checking, 1020 Payroll Checking, 1150 Inter-Account & CC Payment Clearing, 1160 Undeposited Funds / AR Remittance Hold, 1170-1180 Merchant Processor, POS & Delivery Subledger Clearing Series. |
| 1200 - 1390 | Receivables, Inventory & ASC 606 Contract Assets | 1200 Accounts Receivable (Trade), 1210 Retainage Receivable, 1310 Inventory Asset (Warehouse, Truck Stock & Food/Finished Goods Sub-Accounts), 1330 Prepaid Inventory Advances, 1350 Costs and Estimated Earnings in Excess of Billings (Underbillings), 1360 Uninstalled Staged Job Materials. |
| 2000 - 2490 | Payables, Accrued Payroll, Deferred Revenue & Overbillings | 2010 Accounts Payable (Trade), 2120 Accrued Unbilled Materials & Subcontractors, 2150 Short-Term PO Financing Liability, 2210 Accrued Payroll & Wages, 2220 Bona Fide Fringe Liability, 2230 POS Tips Payable (Hospitality), 2410 Unearned Inspection Liability (NFPA), 2420 Deferred Membership Liability, 2430 Customer Deposit & Gift Card Liability, 2450 Billings in Excess of Costs and Estimated Earnings (Overbillings). |
| 3000 - 3990 | Owner Equity, Distributions & Retained Earnings | 3000 Opening Balance Equity (Temporary Setup Account, Must Equal $0.00), 3010 Members' / Shareholders' Capital, 3100 Owner Draws & Distributions, 3200 Retained Earnings (tied to prior-year Form 1120-S / 1065 Schedule L). |
| 4000 - 4990 | Revenue by Service Line & Contra-Revenue Discounts | 4010-4100 Demand Service & Repair Revenue, 4200 Replacement & Install Revenue, 4300 Commercial Project Revenue, 4400 Recognized Maintenance Agreement Revenue, 4910 Financing Dealer Fee Discounts (Contra-Revenue). |
| 5000 - 5990 | Direct Cost of Goods Sold (Cost of Revenue) | 5100 Direct Field Labor, 5150 Field Payroll Taxes & Fringe Burden, 5200 Direct Materials COGS, 5300 Subcontractors, 5400 Job Permits, Dumpsters & Equipment Rentals. |
| 6000 - 6990 | Operating Overhead (SG&A) | 6100 Office & Dispatch Salaries, 6150 Unbilled Shop / Windshield Time, 6200 Fleet Fuel, Maintenance & Leases, 6250 Marketplace & Delivery Commissions, 6300 Rent & Utilities, 6350 Legal, CPA & Professional Fees, 6400 General Liability & Auto Insurance, 6500 Software & FSM Subscriptions, 6600 Marketing & Lead Generation. |
| 7000 - 7990 | Other Income, Interest & Tax Provision | 7100 Interest & Other Non-Operating Income, 7200 Gain / Loss on Equipment Disposal, 7300 Interest & Financing Expense, 7400 State & Local Income / Franchise Tax Provision. |
What will your QuickBooks catch-up take, and what is breaking inside your stack?
Select your operational stack and how many months need reconciliation. See an illustrative standalone cleanup fee range, modeled ongoing client credits, the top 3 subledger faults we check on Day 1, and download the matching QuickBooks Chart of Accounts CSV.
1. Standalone catch-up fee range
$5,200 to $7,500
Illustrative standalone quote for 3,150 total bank/card lines across 9 mos (4-7 wks turnaround, capped at 12 wks).
2. Net fee with 50% ongoing client credit
$2,600 to $3,750
Models the maximum 50% credit ($2,600 to $3,750) applied toward your catch-up when paired with an ongoing monthly bookkeeping & controller engagement.
3. Remaining catch-up balance after $300 Sprint credit
$2,300 to $3,450
Remaining catch-up balance (excluding the $300 Sprint fee already paid) when your $300 Sprint credit is applied once against the net catch-up fee.
The 3 QuickBooks faults we check first for HVAC, Plumbing & Electrical:
CHK-04 / Account 1160
Bank-feed deposits added directly to 4000 Revenue while synced payments sit in 1160
Clicking Add on processor batch deposits in QuickBooks Online while ServiceTitan, Housecall Pro, or Jobber invoices remain open in Account 1200 Trade AR or recorded customer receipts remain in Account 1160 Undeposited Funds double-counts top-line revenue and leaves stale balances on the Balance Sheet.
CHK-03 / Account 1150
Two-leg credit card and LOC transfer echoes in the bank feed
Deleting one side of a duplicate credit card payment in QBO un-matches the bank-feed line and pushes it back into For-Review. Routing both the checking withdrawal and card payment receipt through Account 1150 Inter-Account & CC Payment Clearing and verifying a $0.00 month-end clearing balance prevents duplicate transfer postings.
CHK-13 / Account 6150
All field tech payroll lumped into overhead instead of job-coded COGS vs unbilled time
Splitting the gross payroll register between Account 5100 Direct Field Labor, Account 5150 Field Payroll Taxes & Fringe Burden, and Account 6150 Unbilled Windshield/Shop Time tracks direct labor cost against our 47.7% field labor gross margin planning benchmark (published by Level and our affiliated benchmark publication, Trade Economy Index).
Free Import-Ready CSV Working Papers (No Email Gate)
Download your stack's numbered Chart of Accounts and our 18-check Day-1 Subledger Drift workpaper.
Direct 15-Minute Triage Call ($0) or $300 Flat-Fee 48-Hour Diagnostic Sprint (100% Credited)
Want a locked cleanup quote or our $300 Flat-Fee QuickBooks Fix Sprint?
Start with a free 15-minute phone triage call to review your calculator numbers and confirm scope. When you are ready for hands-on execution inside your QuickBooks file (Firm ID: 9341456933694243), our paid $300 Flat-Fee 48-Hour Diagnostic Sprint runs the 18-Check Forensic Outlier Scan, installs our 3-Account Clearing Architecture (Accounts 1150, 1160, 1170-1180) and trade Chart of Accounts, and completes one selected 48-hour execution track (reconciling 1 benchmark month, tying out tax-return Retained Earnings, mapping FSM items to GL, or testing 1 subledger/WIP/payroll bridge), credited 100% toward any multi-month catch-up cleanup, sell-side QoE prep, or ongoing monthly bookkeeping, controller, or CFO engagement started within 30 days.
Free 15-min triage · $300 Sprint is 100% credited within 30 days
Frequently asked questions
What is the best numbering system for a QuickBooks Chart of Accounts?
A standard 4-digit general ledger numbering structure prevents duplicate accounts and keeps financial statements organized: 1000-1990 for Assets, 2000-2990 for Liabilities, 3000-3990 for Equity, 4000-4990 for Revenue by division or job type, 5000-5990 for Cost of Goods Sold (direct field labor, burden, materials, subcontractors, permits/equipment), 6000-6990 for Operating Overhead (SG&A), and 7000-7990 for Other Income, Interest, and Taxes.
Why do contractors need clearing accounts (1150, 1160, 1170-1180) in their Chart of Accounts?
When your field service software (ServiceTitan, BuildOps, ServiceTrade, Housecall Pro, Jobber) pushes invoice payments into QuickBooks while bank feeds simultaneously import credit-card transfers and net batched merchant deposits from Stripe, Square, Shopify, Toast, or consumer financing, posting both directly to checking doubles revenue or expenses. Routing inter-account transfers and card payments through Account 1150 (Inter-Account & CC Payment Clearing), field invoice payments through Account 1160 (Undeposited Funds / AR Remittance Hold), and card/POS/financing settlements through Accounts 1170-1180 (Merchant Processor, POS & Delivery Subledger Clearing Series) eliminates duplicate revenue and surfaces exact merchant fees.
How many accounts should a contractor or service business have in QuickBooks?
A focused single-entity contractor Chart of Accounts should stay under 45 core accounts (or up to 65-95 accounts for multi-division commercial operators). Across 1,275 public bookkeeping job postings we analyzed, 519 businesses (40.7%) requested Chart of Accounts cleanup and class/job mapping because previous bookkeepers or unmapped software integrations had created 250 to 600+ redundant vendor-named expense accounts.
How do I import a Chart of Accounts CSV template into QuickBooks Online without losing history?
In QuickBooks Online, enable Account Numbers under Settings -> Account and Settings -> Advanced -> Chart of Accounts, upload the new numbered template via Settings -> Import Data -> Chart of Accounts, and then merge redundant legacy accounts into the target 4-digit accounts or remap your FSM pricebook items starting on your next month-end cutoff date.
Can Level install this Chart of Accounts and map my field software items for me?
Yes. Under Level's $300 Flat-Fee 48-Hour QuickBooks Diagnostic Sprint (credited 100% toward any multi-month catch-up cleanup, sell-side QoE prep, or ongoing monthly bookkeeping, controller, or CFO engagement started within 30 days), our team connects via QuickBooks Accountant (Firm ID: 9341456933694243), runs our 18-Check Forensic Outlier Scan, installs the 3-Account Clearing Architecture (1150/1160/1170-1180) and trade Chart of Accounts, and completes one selected 48-hour execution track.
Grow without losing control of the numbers
Drop your info and we’ll show your real margin across jobs, crews, products, and customers, where profit leaks to rework or hidden costs, and how much cash is sitting in unbilled work or inventory.
No commitment. Real numbers, not generic advice.