Loan tape CSV or XLSX · explicit mapping · calculation aid
Form 1098-VLI lender workpaper
Turn your loan tape into a per-loan Form 1098-VLI workpaper: Box 1 interest on the specified passenger vehicle loan (SPVL) part, Boxes 2a-2d, 3a/3b, 4, 6 and 7, the vehicle screen (type and GVWR class), the pro-rata split, the $600 test per loan and an exceptions list. Every figure is cited to its tape cell, NHTSA vPIC field or your confirmation. One workbook and JSON ZIP use one existing file unlock or credit; the free PDF allowance does not apply.
A calculation aid for the lender's records, not tax or legal advice. It does not decide personal use or certify eligibility. The lender files Form 1098-VLI. The rules applied are quoted, with sources, in the workbook's Read me sheet: the IRS Instructions for Form 1098-VLI (12/2026) and the final regulations (T.D. 10054, 26 CFR 1.163-16 and 1.6050AA-1).
No borrower names, addresses, tax ids or contact details are needed or accepted: a mapped column that looks like one is refused. Rows join back by loan id in your own system. VINs, and only VINs, are sent from your browser to NHTSA vPIC (vpic.nhtsa.dot.gov) for decoding; this site does not decode them. UTF-8 comma CSV or .xlsx, 4 MB and 5,000 loans.
Upload only files you may process. Originals are discarded; results expire after 1 hour. Keep your own copies.
3. Needs review
Preview: loans read, columns mapped, data-quality exceptions, one sample loan as read and mapping problems. Every status, box, screen, split, citation and exception is in the workbook and JSON ZIP.