
Preview: 16 accounts made for trucking companies
On top of the standard core accounts every business needs (bank, payroll, taxes, equity).
| # | Account | QBO type | Detail type |
|---|---|---|---|
| 1150 | Factoring Reserve Receivable | Other Current Assets | Other Current Assets |
| 1540 | Tractors & Trucks | Fixed Assets | Vehicles |
| 1545 | Trailers | Fixed Assets | Vehicles |
| 2715 | Equipment Loans | Long Term Liabilities | Notes Payable |
| 4000 | Freight Revenue | Income | Service/Fee Income |
| 4010 | Fuel Surcharge Revenue | Income | Service/Fee Income |
| 4020 | Accessorial Revenue | Income | Service/Fee Income |
| 5000 | Fuel | Cost of Goods Sold | Other Costs of Services - COS |
| 5100 | Driver Wages | Cost of Goods Sold | Cost of labor - COS |
| 5110 | Owner-Operator Settlements | Cost of Goods Sold | Cost of labor - COS |
| 5200 | Tolls & Scales | Cost of Goods Sold | Other Costs of Services - COS |
| 5300 | Factoring Fees | Cost of Goods Sold | Other Costs of Services - COS |
| 5400 | Truck Repairs & Tires | Cost of Goods Sold | Other Costs of Services - COS |
| 6125 | Insurance - Cargo & Auto Liability | Expenses | Insurance |
| 6715 | IFTA, IRP & Heavy Use Tax | Expenses | Taxes Paid |
| 6720 | ELD & Load Board Subscriptions | Expenses | Dues & subscriptions |
Setup tips included
Recommended tracking: Use Classes for each truck (unit number) to see profit per truck
- Give every truck its own Class to calculate cost per mile and profit per truck.
- If you factor invoices, record the full invoice as revenue and factoring fees as a cost.
- Keep fuel receipts by state for IFTA reporting.
How it works
Buy securely. Checkout is handled by Stripe.
Download. Your link arrives by email right after payment.
Import. In QuickBooks Online go to Settings > Import data > Accounts and upload the CSV.
Report. Enter balances in the workbook and your statements are done.
Questions
Can I import this chart of accounts into QuickBooks Online?
Yes. Upload the included CSV in QuickBooks Online under Settings, Import data, Accounts. Every account already has a valid QuickBooks Online account type and detail type.
Does it include financial statements?
Yes. The pack includes a fill-in workbook: type your balances once and the Income Statement, Balance Sheet, Cash Flow Statement and key ratios build themselves, with balance checks.
Will it overwrite my existing accounts?
No. Importing adds accounts. Review the list in Excel first and delete any rows you do not need before you upload.
How do I get the files?
Checkout is handled by Stripe. Your download link arrives by email right after payment.
Other industries
Need it set up for you? Book a QuickBooks Advisory session.
Independent templates by Stephennohga. Not affiliated with, endorsed or sponsored by Intuit Inc. QuickBooks and QuickBooks Online are trademarks of Intuit Inc. General bookkeeping guidance, not tax, legal or audit advice.