For a single truck, Form 2290 is a short form. For a fleet, the form is not the hard part — the data entry is. Two hundred vehicles means two hundred 17-character VINs, each with a weight category, each with a logging or suspended flag, every one of them typed by hand.
That is where fleet filings go wrong. Not in the tax, in the transcription.
E-filing is mandatory at 25 vehicles
If you are reporting and paying tax on 25 or more vehicles on a single return, e-filing is required — it is not a preference.
One detail that catches people out: suspended category W vehicles do not count toward that 25, because no tax is being paid on them. A fleet with 20 taxable trucks and 10 suspended ones is at 20 for this purpose, not 30.
How bulk upload works
Rather than adding vehicles one at a time, you work from a spreadsheet:
- Download the Excel template. It comes with the column headers already set up, an Instructions sheet documenting every column with an example, and dropdowns on the fields that have fixed options — weight category, logging, suspended.
- Fill in one row per vehicle. Because the dropdowns are applied to the whole column up front, you can use Excel's fill handle or select-and-Ctrl+Enter to set the same weight category across fifty rows at once instead of picking it fifty times.
- Upload the file. Rows are validated on import and problems are reported per row, so a single bad VIN doesn't sink the whole file.
Up to 500 vehicles per file. The template is an .xlsx and uploads accept .xlsx or .xls.
It is not just for new filings
This is the part most fleet operators do not expect, and it is where the time actually goes. The same bulk import works for:
- Original filings — the full vehicle list for the period.
- VIN corrections — fixing multiple mistyped VINs at once rather than one correction at a time.
- Taxable gross weight increase amendments.
- Amended returns.
If a spreadsheet error put the same wrong character into a batch of VINs, correcting them one by one is the slow, error-prone path. Bulk correction handles the batch.
Getting the spreadsheet right
The import is only as good as the file. A few things worth checking before you upload:
- VIN length. A heavy vehicle VIN is 17 characters. Excel will happily hold 16 or 18.
- Excel dropping leading zeros or reformatting a VIN as a number or a date. Format VIN columns as Text before pasting.
- Look-alike characters: 8 and B, 0 and D, 5 and S, 2 and Z. VINs never contain I, O, or Q — if one appears, the row is wrong.
- The weight category must reflect taxable gross weight — the vehicle, its customary trailers, and the maximum load customarily carried — not the empty weight.
- Mark suspended vehicles as suspended. They still have to be reported and they still appear on your Schedule 1.
One Schedule 1 for the fleet
An accepted return produces a single stamped Schedule 1 listing every VIN on it — taxable and suspended alike. That one document is the proof of payment your registrations depend on, so it is worth checking the VIN list carefully before transmitting rather than discovering an error at the DMV counter.
For tax preparers
If you file on behalf of clients, the same import applies per business. Each business keeps its own vehicles, returns, and filing history, so last year's vehicle list is available as a starting point rather than something to retype every July.
Given the season is compressed into July and August, the difference between typing and importing is most of the work. See pricing by vehicle count for what a fleet return costs.
