How to Convert a 1099-INT PDF to CSV or Excel
Convert 1099-INT interest income tax forms from PDF to CSV or Excel. AI-powered extraction captures all boxes for easy tax preparation.
Banks and financial institutions send 1099-INT forms to report interest income earned during the tax year. If you have savings accounts, CDs, bonds, or other interest-bearing instruments at multiple institutions, you may receive several 1099-INT forms — each as a separate PDF. Converting them to CSV or Excel format lets you consolidate interest income across all accounts, prepare your tax return efficiently, and maintain clean financial records.
Quick Summary: Upload your 1099-INT PDF to StubToCSV for instant AI extraction. All boxes — interest income, early withdrawal penalties, tax-exempt interest, and more — are extracted and verified. Download CSV or Excel in under 30 seconds.
1099-INT Form Fields Explained
The 1099-INT reports various types of interest income and related information. Understanding the boxes helps you verify your converted data.
| Box | Field | Tax Reporting Line |
|---|---|---|
| Box 1 | Interest income | Schedule B if over $1,500 |
| Box 2 | Early withdrawal penalty | Schedule 1, Line 18 (deduction) |
| Box 3 | Interest on U.S. Savings Bonds and Treasury obligations | May be state tax exempt |
| Box 4 | Federal income tax withheld | Backup withholding credit |
| Box 5 | Investment expenses | Limited deductibility |
| Box 6 | Foreign tax paid | Foreign tax credit eligible |
| Box 8 | Tax-exempt interest | Reported but not taxed federally |
| Box 9 | Specified private activity bond interest | May trigger AMT |
| Box 10 | Market discount | Reported as ordinary income |
| Box 11 | Bond premium | Amortization adjustment |
| Box 13 | Bond premium on tax-exempt bond | Reduces tax-exempt interest |
Note: Most people will only see amounts in Box 1 (and sometimes Box 3 if they hold Treasury securities). The other boxes apply to specific investment situations.
How to Convert Your 1099-INT
-
Download your 1099-INT PDFs. These typically come from your bank’s online portal, brokerage account, or are mailed as part of your tax document package. Download all of them for the tax year.
-
Upload to StubToCSV. Go to the converter and upload your 1099-INT PDF.
-
AI extracts and verifies. Dual-AI processing reads every box on the form and cross-verifies the data. Under 30 seconds.
-
Download your data. Get CSV or Excel output with all fields structured and labeled.
-
Consolidate multiple forms. Convert each 1099-INT and add the data to a master spreadsheet.
Why You Need a Spreadsheet for Interest Income
If you have accounts at multiple banks, the value of consolidation becomes obvious quickly.
| Scenario | Number of 1099-INTs | Manual Effort | With Spreadsheet |
|---|---|---|---|
| One savings account | 1 | Minimal — enter directly | Quick verification |
| Savings + CDs at one bank | 1-2 | Easy enough manually | Slight advantage |
| Multiple banks and brokerages | 3-8 | Tedious and error-prone | Major time savings |
| Active investor with many accounts | 10+ | Hours of manual work | Essential |
When your total interest income exceeds $1,500, the IRS requires you to file Schedule B, which lists each payer and their interest amount. A consolidated spreadsheet gives you this data instantly.
Tip: High-yield savings accounts have made interest income significant again for many taxpayers. If you moved money between several banks chasing rates during the year, you will receive a 1099-INT from each one. Converting and consolidating them prevents you from accidentally omitting one on your return.
Consolidating Multiple 1099-INTs
Here is the recommended workflow for handling multiple forms:
- Convert each 1099-INT to CSV or Excel through StubToCSV
- Create a master spreadsheet with columns: Payer Name, Payer TIN, Box 1 (Interest), Box 2 (Penalty), Box 3 (Treasury), Box 4 (Tax Withheld), Box 8 (Tax-Exempt)
- Add each form as a row
- Create a totals row summing each column
- Use Box 1 total for Schedule B / Form 1040 Line 2b
- Use Box 8 total for Form 1040 Line 2a (tax-exempt interest)
- Use Box 2 total for Schedule 1 Line 18 (early withdrawal penalty deduction)
Pro Tip: If you hold both taxable and tax-exempt bonds, keeping these separate in your spreadsheet is critical. Box 1 interest is taxable, but Box 8 interest is federally tax-exempt. Mixing them up on your return either overpays your taxes or triggers an IRS notice.
Common Issues
Missing 1099-INTs. Banks are not required to issue a 1099-INT if your interest earned is less than $10. However, you are still required to report this interest income. Check your bank statements for small interest amounts that may not generate a form.
Consolidated 1099s. Some brokerages issue a consolidated 1099 that combines 1099-INT, 1099-DIV, and 1099-B data into one document. StubToCSV can extract the 1099-INT section from these consolidated forms.
Accrued interest from bond purchases. If you purchased bonds between interest payment dates, you may have paid accrued interest to the seller. This amount should offset your reported interest income. Track it separately in your spreadsheet.
Get Started
Convert your 1099-INT forms to CSV or Excel with StubToCSV. Whether you have one form or dozens, AI-powered dual extraction delivers accurate, structured data in seconds. Try it free — pricing plans available for tax season volume.