1099 processing hits CPA firms from two directions: extracting data from 1099s received by clients, and preparing and filing 1099s on behalf of clients. Both sides scale painfully. A firm with 200 clients might process 2,000+ received 1099s during tax season and file 500+ 1099s for clients who paid contractors. Manual processing at either end creates a bottleneck that peaks exactly when the firm is already at capacity.
The extraction side is especially labor-intensive. Every 1099 variant has a different layout. A 1099-NEC has one box that matters. A 1099-DIV has thirteen boxes including qualified dividends, Section 199A dividends, and foreign tax paid. A consolidated brokerage 1099 from Schwab or Fidelity runs 30 to 50 pages, combining 1099-INT, 1099-DIV, 1099-B, and capital gains schedules into a single document. Keying this data manually across hundreds of clients is where tax season timelines collapse.
The filing side carries its own complexity: TIN verification, threshold tracking, state filing requirements, and IRS deadlines that do not move. Automating both sides of the 1099 workflow is the only way to run a multi-client practice without burning out staff every January through April. This guide covers both workflows step by step, with specific tools and techniques for each.
The extraction workflow applies to 1099s your clients receive, the forms that report income they need to include on their tax returns. Here is how to process them efficiently at scale.
Step 1: Gather 1099s from client document packages. Clients dump their tax documents into a portal, email them as attachments, or drop off physical folders. 1099s arrive mixed in with W-2s, K-1s, brokerage statements, and bank interest statements. The first task is sorting. Some firms ask clients to pre-sort, but most experienced tax managers know that clients rarely do this correctly. You need a process that handles mixed document batches.
Step 2: Upload to an extraction tool. This is where automation replaces manual data entry. AI-powered extraction tools can process 1099s without pre-built templates for each form variant. Lido auto-detects document types, so you can upload a mixed batch and it identifies which documents are 1099s and which variant. The tool extracts payer name, payer TIN, recipient information, and all box values into a structured spreadsheet. For a firm processing thousands of 1099s, this step alone eliminates hundreds of hours of manual keying.
Step 3: Handle consolidated brokerage 1099s. These are the hardest documents in any tax engagement. Schwab, Fidelity, Vanguard, and other custodians each send 20 to 50 page documents that combine 1099-INT, 1099-DIV, 1099-B, and capital gains schedules into a single PDF. Template-based OCR tools need a separate template for each brokerage, and those templates break every year when brokerages update their layouts. Lido reads the document structure regardless of brokerage layout. It extracts interest income, ordinary dividends, qualified dividends, capital gain distributions, and 1099-B transaction details from any custodian format. If your firm also processes K-1s, our step-by-step guide to automating K-1 processing covers the extraction workflow for partnership and fund K-1s.
Step 4: Review and reconcile. Automation does not eliminate review. It makes review faster. Match extracted 1099 data against prior year returns where available. If a client reported $12,000 in dividends from Vanguard last year and the extraction shows $1,200 this year, that discrepancy needs a human eye. Flag it for preparer review. Verify a sample of extractions against source documents, especially for new clients where you have no prior year baseline. A 10% sample check is standard practice for most firms.
Step 5: Import into tax returns. Format the extracted data to match your tax software's import template. Most professional tax software (UltraTax, Lacerte, ProSeries, Drake) accepts CSV imports for 1099 data. The extraction tool should output data in a format that maps directly to these import templates, so preparers paste rather than re-key. This final step closes the loop: documents come in, structured data goes into the return.
The filing workflow applies to 1099s your clients must issue, the forms they send to contractors, consultants, and other payees to report payments made. Dedicated 1099 filing software handles the compliance and delivery side, but you still need clean data to feed it.
Step 1: Identify 1099-reportable vendors. Pull accounts payable records for payments to contractors, consultants, attorneys, and other service providers exceeding the $600 threshold for 1099-NEC, or the applicable thresholds for 1099-MISC categories like rent ($600) and royalties ($10). For clients with hundreds of vendors, this means exporting a full AP detail report and filtering by vendor type and payment total. Do not rely on vendor classifications alone. Payments to LLCs taxed as sole proprietorships or partnerships are reportable even if the vendor name looks like a corporation.
Step 2: Verify W-9 information. Confirm TINs for all recipients before filing. Incorrect TINs trigger IRS CP2100 notices and potential B-notice penalties. Filing platforms like Tax1099 and Track1099 include TIN matching services that check names and TINs against IRS records before submission. For clients missing W-9s, start the collection process early. Chasing down W-9s in January is one of the most time-consuming parts of the filing workflow.
Step 3: Generate 1099 forms. Import payment data from the client's accounting system. QuickBooks Online, Xero, and NetSuite all support direct integrations with major filing platforms. For clients on other systems, export a CSV with payer information, recipient details, and payment amounts, then upload to the filing platform. The data mapping should include payer TIN, payer name and address, recipient TIN, recipient name and address, and amounts by box number.
Step 4: E-file with the IRS. File 1099-NEC by January 31. This deadline is firm and applies to both IRS filing and recipient delivery. File 1099-MISC by March 31 for electronic filing (February 28 for paper). State filing requirements vary: some states participate in the Combined Federal/State Filing Program, which forwards federal filings automatically, while others require separate state submissions. Track state requirements for each client based on where they operate and where their payees are located.
Step 5: Deliver to recipients. Recipients must receive their 1099 copies by the applicable deadline. Electronic delivery requires prior recipient consent under IRS regulations. For recipients who have not consented, you must mail physical copies. Most filing platforms handle both delivery methods and provide confirmation tracking so you can document compliance.
Consolidated brokerage 1099s deserve special attention because they represent the highest time investment per document in any tax engagement. A single consolidated 1099 from a major custodian can contain dozens of data points across multiple income categories: taxable interest, tax-exempt interest, ordinary dividends, qualified dividend income (QDI), capital gain distributions, Section 199A dividends, foreign tax paid, federal tax withheld, and detailed 1099-B transaction listings with proceeds, cost basis, wash sale adjustments, and holding period classifications. A client with investment accounts at three different brokerages sends three completely different 30-page documents. Each has its own formatting conventions and requires field-by-field extraction.
The challenge goes beyond simple OCR. Brokerage 1099s contain hierarchical data: summary totals at the top, detailed breakdowns by security or account below. Capital gains sections may run for pages, with each transaction on its own line. Some brokerages include adjusted cost basis with wash sale disallowance amounts on the same line as proceeds. Others report wash sale adjustments in a separate section. Foreign tax credits may appear as a line item under dividends, as a separate 1099 section, or both. Exempt-interest dividends from municipal bonds require state-by-state allocation that some brokerages provide and others do not. Template-based extraction tools struggle with this variability because each brokerage updates their format annually.
AI extraction handles consolidated brokerage 1099s differently. Instead of matching fields to fixed coordinates on a template, it reads the document structure (headings, tables, line items, subtotals) and maps values to the correct fields based on context. Lido can process a Schwab consolidated 1099 and a Fidelity consolidated 1099 using the same approach, without separate templates for each custodian. For CPA firms that process hundreds of brokerage 1099s every tax season, this eliminates the annual template maintenance cycle and reduces extraction errors from format changes.
Managing 1099 processing across 100 or more clients during tax season requires a deliberate workflow design. The natural instinct is sequential processing: open a client's file, extract their 1099s, enter the data, move to the next client. This approach feels organized but is actually slower when you have AI extraction available. Batch processing is faster. Collect all client 1099s as they arrive, process them in bulk through the extraction tool, then distribute the extracted data to preparers with each client's 1099 data already in spreadsheet format. You upload 500 1099s in one batch rather than making 500 individual uploads, and the extraction tool processes the entire batch while your team works on other tasks.
The batch approach also improves quality control. When all 1099 data flows through a single extraction pipeline, you can apply consistent validation rules across every client: check for missing TINs, flag unusually high or low amounts, and cross-reference payer names against known custodians. Firms that have adopted this batch workflow report major time savings during peak season, not just from faster extraction but from reduced context-switching. Preparers receive clean, structured data and spend their time on review and tax planning rather than data entry. The extraction bottleneck disappears, and the firm's capacity constraint shifts from document processing to higher-value advisory work.
The fastest approach combines AI document extraction with batch processing. Upload all received 1099s, including mixed document batches with W-2s and other forms, into an extraction tool that auto-detects document types and pulls structured data without templates. Process in large batches rather than one client at a time. For the filing side, use dedicated 1099 filing software with direct integrations to your clients' accounting systems. The extraction side typically saves more time because consolidated brokerage 1099s and high document volumes make manual data entry the biggest bottleneck.
Yes. AI extraction tools like Lido process consolidated brokerage 1099s from any custodian (Schwab, Fidelity, Vanguard, TD Ameritrade, Merrill Lynch, and others) without custodian-specific templates. The AI reads document structure rather than relying on fixed field positions, so it handles the variability in formatting across brokerages and across years when brokerages update their layouts. It extracts all income categories including taxable and exempt interest, ordinary and qualified dividends, capital gain distributions, 1099-B transaction details with cost basis and wash sale adjustments, and foreign tax paid.
1099 extraction refers to pulling data from 1099s that your clients receive, forms reporting income paid to them by banks, brokerages, clients, and other payers. This data goes into the client's tax return. 1099 filing refers to preparing and submitting 1099s that your clients must issue, forms reporting payments they made to contractors, consultants, and other vendors. Extraction requires document processing and OCR technology. Filing requires compliance software with IRS e-filing capability, TIN matching, and recipient delivery. Most CPA firms need both workflows automated to handle tax season volume efficiently.
Firms managing 1099 compliance across many clients typically centralize the workflow. On the extraction side, they batch-process all received 1099s through a single AI extraction pipeline, then distribute structured data to individual preparers. On the filing side, they use a filing platform that supports multiple payer accounts, so one administrator can manage 1099 preparation and e-filing for all clients from a single dashboard. TIN verification, deadline tracking, and state filing requirements are managed at the firm level rather than per client. This centralized approach scales linearly. Adding clients increases volume but does not increase workflow complexity.
%20(1).svg)
