If you are filing Form 1098-VLI through Vehicle Loan Interest, the hard part is almost never the IRS submit button. It is getting a clean spreadsheet. One row per loan, the right columns as text, Box 1 limited to interest — then upload, review the forms, and e-file. Nothing goes to the IRS until you submit.
Before you touch the file:
- One header row, one loan per row. No merged cells, blank spacer rows, or totals line at the bottom.
- Format VIN and TIN as text before you paste. That alone stops most upload failures.
- Box 1 is interest only — no late fees, insurance, or add-ons.
- You can upload in batches. Partial files are fine until you e-file.
Lender account setup and the Excel template are at sign up. Field meanings for every box: Form 1098-VLI line by line. Official backup: Instructions for Form 1098-VLI.
What goes in each row
Each qualifying loan is one Form 1098-VLI, so each loan is one row. Your lender name, address, and TIN live on the account — you do not repeat them on every line.
| Field | What it is | How to enter it |
|---|---|---|
| Borrower name | Legal name on the tax record | No nicknames |
| Borrower TIN | SSN or EIN | 9 digits, text |
| Borrower address | Mailing address for the borrower copy | Street, city, state, ZIP |
| Account number | Your loan ID | Unique per loan |
| Interest received (Box 1) | Qualifying SPVL interest received in the calendar year | Interest only |
| Vehicle year / make / model (Boxes 2a–2c) | Model year and descriptors | Four-digit year; spell make/model normally |
| VIN (Box 2d) | Vehicle identification number | Exactly 17 characters, text |
| Origination date (Box 3a) | Date the original loan was created | MM/DD/YYYY (SPVL rules generally need post–Dec 31, 2024) |
| Acquisition date (Box 3b) | Date you acquired the loan (if you are not the originator) | Blank if you originated it |
| Outstanding principal (Box 4) | Balance at Jan 1, or at origination/acquisition if mid-year | Plain number |
| Refund of interest (Box 5) | Prior-year interest you refunded/credited | Often blank |
| Original use (Box 6) | Original use began with this borrower | Per the form / instructions |
| U.S. final assembly (Box 7) | Final assembly in the United States | Per the form / instructions |
Box 1 is the number that gets the most attention. Keep fees out. A prepayment penalty that is interest under the instructions can go in. If a borrower has two qualifying loans, use two rows with two account numbers — one form per loan.
How Excel should look
Keep it flat. Header row, then data. Export from your loan system if you can, then map columns to the template rather than rebuilding by hand.
Watch these four:
- VINs. Excel likes to turn long “numbers” into scientific notation. Format the column as text first so all 17 characters stay put.
- TINs. Leading zeros disappear when Excel treats the cell as a number. Text format fixes it.
- Dates. Use a real date (MM/DD/YYYY). Loose text strings fail validation.
- Dollars. Interest and principal as plain numbers — no
$or commas in the cell.
Usual rejects: 16-character VIN, pre-2025 origination on a loan that cannot qualify, and Box 1 with fees still baked in. Fix those in the sheet before you upload.
After you upload
Upload only loads data for review. It does not file.
- Validate. Required fields are checked; bad rows get flagged (missing VIN, bad TIN, blank interest, origination date that fails the rules, and similar).
- Review. Numbers sit in the Form 1098-VLI layout so a wrong figure is easy to spot. Fix and re-upload if needed.
- eFile. Submit through IRIS and keep acceptance confirmations. Optional print-and-mail covers borrower copies.
January 31 (furnish) and March 31 (e-file for most lenders) still apply — leave time before the filing deadlines. Direct IRIS path if you file yourself: electronic filing guide.
Mid-year payoff
Report interest received from January 1 through payoff in Box 1. Box 4 still follows the principal rule for the start of the year (or origination/acquisition if the loan started mid-year). Early payoff does not erase interest already collected.
Quick answers
Partial file? Yes. Upload what you have, add rows later, re-upload before you e-file. Nothing hits the IRS until submit.
Errors? Fix the flagged cells in Excel and upload again. The batch has to pass checks before filing.
Template vs paper IRS form? Use the Excel template. The platform builds Form 1098-VLI and files Copy A; you do not hand-key the paper form.
Change after filing? Before submit, re-upload a corrected file. After IRS acceptance, file a correction with CORRECTED checked. Faster fixes keep you in a lower penalty tier.
Bottom line
Pull loans with $600 or more of qualifying interest, lock name/TIN/address, Box 1, VIN, dates, principal, and Boxes 6–7, set VIN and TIN columns to text, then upload. If your export is messy or columns do not map cleanly, contact us. Otherwise: sign up, grab the template, and run the review before you submit.
Educational information only, not legal or tax advice. Match fields to the current Form 1098-VLI instructions and your filing year.
