The upload is the whole job. Get your borrower data clean and the rest of 1098-VLI filing takes minutes: the platform builds the forms, checks the fields, and files them with the IRS. Here's exactly how to format your file and what happens after you hit upload.
- One row per loan, one clean header row, no merged cells or totals line.
- Set the VIN and TIN columns to text so Excel doesn't mangle them. This prevents most upload errors.
- Box 1 is interest only. No late fees, insurance, or add-ons.
- Nothing reaches the IRS until you review the forms and hit submit, so you can upload in batches.
If you handle compliance for a bank, a credit union, or a buy-here-pay-here lot, you don't need new software to file 1098-VLI. You need a clean spreadsheet. I set up this reporting for lenders, and almost every slow filing traces back to a messy file, not a hard rule. So this walkthrough starts with the spreadsheet, then shows the upload, review, and eFile steps that follow.
If you want the field-level definitions first, the IRS draft instructions for Form 1098-VLI spell out each one.
The data you need for each borrower
Each qualifying loan becomes one Form 1098-VLI, so you'll prepare one row of data per loan. Your own name, address, and TIN get entered once at the account level. You won't repeat them in every row.
| Field | What it is | How to enter it |
|---|---|---|
| Borrower name | The borrower's legal name | Match their tax record exactly, no nicknames |
| Borrower TIN | Social Security or employer ID number | 9 digits, formatted as text |
| Borrower address | Mailing address for the copy | Street, city, state, ZIP |
| Account number | Your internal loan identifier | One unique value per loan |
| Interest received (Box 1) | Total qualifying interest paid in the calendar year | Interest only, no fees or insurance |
| Vehicle year (Box 2a) | The model year | Four-digit year |
| Make (Box 2b) | The manufacturer | Full name, such as Ford or Toyota |
| Model (Box 2c) | The model name | Spell it out, such as F-150 or Camry |
| VIN (Box 2d) | The vehicle identification number | Exactly 17 characters, text format |
| Origination date (Box 3a) | Date the original loan was created | MM/DD/YYYY, January 1, 2025 or later to qualify |
| Acquisition date (Box 3b) | Date you bought a loan from another lender | Leave blank if you originated it |
| Outstanding principal (Box 4) | Balance at January 1 or at origination | Plain number |
| Refund of interest (Box 5) | Prior-year interest you refunded | Usually blank for 2025 and later loans |
Box 1 is the field the IRS watches most, so keep it to pure interest. Late fees, insurance, and add-ons don't belong there. A prepayment penalty does count as interest, so include it if a borrower paid off early.
How to format the Excel file
The platform reads a plain, flat spreadsheet. One header row, then one loan per row underneath. Skip the merged cells, the blank rows, and any totals line at the bottom.
Two data types cause almost every upload error. Both come from Excel trying to be helpful, so VINs and TINs need to stay as text.
- VINs. A VIN that looks like a number can flip into scientific notation and lose its shape. Format the column as text before you paste, so all 17 characters stay intact.
- TINs. A Social Security number that starts with a zero drops that zero the moment Excel reads it as a number. Set the column to text and the leading zero survives.
- Dates. Use a real date format like MM/DD/YYYY. A date typed as loose text can fail the origination-date check.
- Dollar amounts. Enter interest and principal as plain numbers, with no dollar signs or commas. Let the column hold the raw value.
A few errors show up again and again. The usual suspects are a 16-character VIN, a 2024 origination date that kills the deduction, and interest with late fees still baked in. Catch these in the spreadsheet and you save yourself a round of corrections later.
What happens after you upload
Uploading doesn't file anything with the IRS. It loads your data so you can review everything before anything is filed. The workflow runs in three steps.
Both the January 31 borrower deadline and the March 31 IRS eFile deadline still apply, so leave room before the 1098-VLI filing deadlines arrive.
Borrowers with two vehicles or a mid-year payoff
Two situations trip up first-time filers, and both come down to how you lay out the rows.
A borrower with two qualifying loans gets two forms. Give each loan its own row and its own account number, and the platform generates a separate Form 1098-VLI for each. One row per loan is the rule, even when the same person signs both.
A mid-year payoff is simpler than it feels. Box 1 holds all the interest that borrower paid from January 1 through the payoff date, and a prepayment penalty counts as interest too. Box 4 still reflects the principal at the start of the year or at origination. The loan closing early doesn't change how you report the interest they already paid.
For the field-by-field logic behind these calls, the Form 1098-VLI line-by-line guide walks through every box in order.
Common questions about the 1098-VLI Excel upload
Can I upload a partial file and add borrowers later?
Yes. Upload the borrowers you have ready, then add more rows and upload again before you eFile. You can work in batches across several sessions. Nothing reaches the IRS until you submit, so a partial file is just a saved draft.
What if I have errors in my data?
The platform checks your file and flags the rows that fail. Common flags include a short VIN, a bad TIN, a blank interest amount, or an origination date before 2025. Fix the flagged cells in your Excel file and upload the corrected version. The file has to pass those checks before it can be filed.
Do I use the Excel template or the official IRS form?
You use the Excel template and never touch the paper IRS form by hand. Drop your data into the template and upload it. The platform then generates the official Form 1098-VLI and files Copy A with the IRS for you.
Can I change a form after I file it?
Yes. Before you submit, just re-upload a corrected file. After the IRS accepts a form, you file a correction with the CORRECTED box checked, which the platform handles the same way as the original. Faster corrections keep you in a lower penalty tier.
Get your borrower data ready this week
Clean data is the difference between a five-minute filing and a February scramble. Pull your list of borrowers who paid $600 or more in qualifying interest, line up the fields above, and set the VIN and TIN columns to text before you paste anything in. Then upload and let the platform handle the forms and the IRS.
