1099 OCR reads each 1099 a client sends, works out which variant it is, and pulls every box into a spreadsheet so nobody retypes the amounts. Doing it well means recognizing each form type, splitting consolidated brokerage statements into their sections, reading substitute layouts by label, and keeping only the latest corrected copy.
The 1099 variants 1099 OCR has to recognize
A 1099 OCR tool has to tell the variants apart before it reads a single amount, because box 1 means something different on every form. Box 1 on a 1099-INT is interest income; box 1 on a 1099-MISC is rents. The form number printed on the page decides which column every figure lands in.
Most individual clients bring some mix of nine variants. The table below lists the boxes a firm usually wants captured from each, with the revision of the IRS instructions each row was checked against. Labels change: the 1099-NEC put nonemployee compensation in box 1a in its December 2026 revision, and the 1099-R added boxes 7c and 7d for 2026. Check the revision before you build a template around a box number.
| Variant | Instructions checked | Boxes worth capturing |
|---|---|---|
| 1099-INT | Instructions for Forms 1099-INT and 1099-OID (01/2024) | Interest, withholding, foreign tax, tax-exempt and bond premium boxes; listed box by box in the 1099-INT and 1099-DIV comparison |
| 1099-DIV | Instructions for Form 1099-DIV (01/2024) | Ordinary, qualified, capital gain, nondividend, withholding and exempt-interest boxes; listed in the same comparison |
| 1099-B | Instructions for Form 1099-B (2026) | 1a to 1g for each sale, 2 type of gain or loss, 5 noncovered security, 12 basis reported to IRS |
| 1099-NEC | Instructions for Forms 1099-MISC and 1099-NEC (Rev. 12/2026) | 1a nonemployee compensation, 4 withholding, state boxes |
| 1099-MISC | Same instructions (Rev. 12/2026) | 1 rents, 2 royalties, 3 other income, 4 withholding, 8 substitute payments, 10 gross proceeds paid to an attorney |
| 1099-R | Instructions for Forms 1099-R and 5498 (2026) | 1 gross distribution, 2a taxable amount, 2b checkboxes, 4 withholding, 7a distribution codes |
| 1099-G | Instructions for Form 1099-G (Rev. 12/2026) | 1 unemployment compensation, 2 state or local refunds, 3 the year box 2 is for, 4 withholding |
| 1099-SA | Instructions for Forms 1099-SA and 5498-SA (Rev. 12/2026) | 1 gross distribution, 2 earnings on excess contributions, 3 distribution code, 5 HSA or MSA checkbox |
| 1099-K | Instructions for Form 1099-K (Rev. 12/2026) | 1a gross amount, 3 number of transactions, 4 withholding, 5a to 5l monthly amounts |
The sources for each row are the IRS pages themselves: the Instructions for Forms 1099-INT and 1099-OID, the Instructions for Form 1099-DIV, the Instructions for Form 1099-B, the Instructions for Forms 1099-MISC and 1099-NEC, the Instructions for Forms 1099-R and 5498, the Instructions for Form 1099-G, the Instructions for Forms 1099-SA and 5498-SA and the Instructions for Form 1099-K.
Codes need their own column. A 1099-R box 7a is labelled "Distribution Code(s)" and can carry codes such as 7 or G, and a 1099-SA box 3 holds a single code from 1 to 6. Store the code as text next to the amount. A code read as a number loses meaning, and a blank code is a reason to look at the page again.
Interest and dividends are the pair most often confused. The difference between the two forms, and where money market payments land, is covered in what a 1099-INT reports and what a 1099-DIV reports. K-1s often sit in the same folder but follow a different structure, with codes and attached statements; K-1 data extraction covers that work.
Consolidated 1099 data extraction from brokerage statements
A consolidated 1099 is one document from a broker that combines several 1099 forms for the same account. Consolidated 1099 data extraction means splitting that document into its blocks, reading each block as the form it represents, and ignoring the pages that are not part of any form.
IRS Publication 1179 calls this a composite statement. The Publication 1179 (Rev. 07-2026) rules allow one payer to combine Forms 1099-B, 1099-DA, 1099-DIV, 1099-INT, 1099-OID, 1099-PATR, and 1099-MISC (only for royalties or substitute payments) on one statement. Two of its rules make extraction possible. Each payment type must be "located and blocked together" and kept apart from the others. Each block must show the official form number and name at its start.
Those rules tell you how to read one. Find each block heading, such as "Form 1099-DIV" or "Form 1099-B", and treat everything under it as that form until the next heading. Information shared across blocks, such as the payer's name, may appear only once in the first block, so carry it forward to every row you extract.
What to pull from each section
A typical consolidated statement, in no fixed order, holds these parts:
- Summary page. Totals for each form. Capture them as control totals, not as data.
- 1099-DIV block. Each box, with the same labels as the standalone form.
- 1099-INT block. Interest from cash sweeps and bonds, plus bond premium boxes.
- 1099-MISC block. Box 8 substitute payments or box 2 royalties, when the account had them.
- 1099-B block. Sale lines grouped by term and by whether basis was reported to the IRS.
- Supplemental pages. Details the broker adds that are not part of any form.
The 1099-B block is the long one. Each sale is a row, and a client with an active account can have hundreds. How to enter those lines, and which fields each needs, is covered in 1099-B data entry.
Consolidated statements arrive later than most forms. The General Instructions for Certain Information Returns (2025) set February 17, 2026 as the date for furnishing 2025 Forms 1099-B to recipients, including statements furnished as part of a consolidated reporting statement. A brokerage folder that looks thin in early February may simply not be due yet.
How do you read a substitute 1099?
A substitute 1099 is any recipient statement that is not the official IRS Copy B. The General Instructions say "a substitute is any statement other than Copy B of the official form," and that substitutes must meet the rules in Publication 1179. A bank or broker statement in its own layout is a substitute.
Read a substitute by its labels, not by where things sit on the page. On the official form, box 1 is always in the same corner. On a substitute it may be a table row reading "Interest income (Box 1)" halfway down a letter-sized page. Build the mapping from label to box number, then check that every amount found has a box.
Watch for these patterns:
- Rows without box numbers. Some statements print only the label. Match it to the box label in the official instructions for that form.
- Zero rows. Some substitutes list every box, including those with $0.00. Capture them as zero or skip them, but do it the same way every time.
- Multiple accounts. One bank may send one statement listing several accounts. Each account is its own form for tracking purposes.
- Year-end letters. A bank's annual summary letter can show interest paid without being a 1099 at all. Look for the form number before treating it as one.
Publication 1179 sets a test that helps here. A composite statement is acceptable only if the type of payment is "as clear as if each required statement were furnished separately on an official form." If you cannot tell which form a block represents, the client should ask the payer for a clearer copy rather than you guessing.
1099 to Excel: one sheet per form type or one for all?
A 1099 to Excel layout works best as one long sheet for all box amounts, with one row per box, plus a separate sheet for 1099-B sale lines. One sheet per form type looks tidy until a client has seven types; then every total needs seven formulas, and a new variant breaks the workbook.
The combined sheet uses the same columns for every variant. The form type and box number say what the amount is, so a 1099-G and a 1099-INT sit together without clashing. Filtering by form type gives the per-form view whenever someone wants it.
A combined 1099 to Excel column layout
These rows are examples for a fictional client, Dana Whitfield, prepared by a fictional firm, Larchmont Tax Partners.
| Client | Form | Tax year | Payer | Account | Box | Label | Amount | Corrected | Source page |
|---|---|---|---|---|---|---|---|---|---|
| Whitfield | 1099-INT | 2025 | Harbor Federal Credit Union | XXXX-4821 | 1 | Interest income | 412.37 | No | uploads/harbor.pdf p1 |
| Whitfield | 1099-DIV | 2025 | Ridgeline Brokerage | XXXX-7310 | 1a | Total ordinary dividends | 1,880.12 | No | uploads/ridgeline.pdf p3 |
| Whitfield | 1099-DIV | 2025 | Ridgeline Brokerage | XXXX-7310 | 1b | Qualified dividends | 1,512.40 | No | uploads/ridgeline.pdf p3 |
| Whitfield | 1099-G | 2025 | State of Example | 2 | State or local refund | 286.00 | No | uploads/state.pdf p1 | |
| Whitfield | 1099-R | 2025 | Example Pension Trust | XXXX-0912 | 7a | Distribution code | 7 | No | uploads/pension.pdf p1 |
The source page column is the one people skip and later miss. When a reviewer questions an amount, the page reference sends them straight to the image. The corrected column is covered in the next section.
The 1099-B sheet has its own columns: description, dates, proceeds, basis, adjustment, code, term and whether basis was reported. Keep a link back to the main sheet through payer and account, so the B lines and the DIV boxes from one consolidated statement stay tied together.
Schema CPA reads the 1099 series alongside the rest of a client's folder, labels each page by form type, issuer and period, and exports the results to Excel or CSV for the firm to work from. The document categories on the homepage list what it reads.
1099 OCR pitfalls with corrected and late 1099s
The most common 1099 OCR pitfall is keeping both the original and the corrected version of the same form, so the amounts count twice or the wrong figures stay in. A corrected 1099 replaces the original's figures for that payer, account and year. It does not add to them.
The General Instructions say to "Enter an 'X' in the 'CORRECTED' checkbox only when correcting a form previously filed." That checkbox is the signal to read. Capture it as its own field on every row, then apply one rule: for each payer, account, form type and tax year, the latest corrected copy is the live one and the original is marked superseded.
Brokers often reissue a whole consolidated statement rather than one block. The reissued file may carry a corrected 1099-B block next to an unchanged 1099-DIV block. Compare block by block, so an unchanged DIV is not flagged as new income and a changed B is not missed.
Other traps:
- The same form sent twice. A client forwards the PDF and then a phone photo. Same payer, account, year and amounts means a duplicate, not a second form.
- Late forms after the sheet is built. A form that arrives in March needs to land in the same sheet with a date received, so the change is visible.
- A corrected form without the box checked. Some clients send an updated statement with no mark on it. If amounts differ from the first copy, stop and ask which is current.
What a preparer does when a corrected form arrives after the return has gone in is a separate question, covered in corrected 1099 after filing.