Skip to content
ignitai Get the app
← Back to blog · · 13 min read

Convert 1099 PDF to Excel on Mac (2026 tax-prep guide)

Consolidate a folder of 1099-NEC, 1099-MISC, 1099-K, and 1099-INT PDFs into one Excel workbook on Mac — on-device on macOS 14.4+, Schedule C-ready.

guides tax-forms mac bookkeeping

It’s late March. The accountant emailed: “send me everything in one spreadsheet by Friday.” The desktop folder is ~/Documents/Taxes/2025/1099s/. Inside, there are eighteen PDFs: nine 1099-NECs from various clients who paid through Stripe, ACH, or wire; three 1099-MISCs from a board-advisor role and a royalty payer and a state grant; two 1099-Ks from PayPal and Stripe that overlap partially with the NECs; three 1099-INTs from brokerage and bank accounts; one 1099-DIV from the index fund. Eighteen forms, six different layouts, one Schedule C that needs total non-employee compensation in box 1 — net of the 1099-K overlap with the NEC reporting.

The Mac is, for this specific job, the right tool. The keyboard makes spot-checking eighteen forms fast. The 27-inch display shows the form PDF and the extracted row side by side. And on macOS 14.4+ on Apple Silicon, on-device AI can read all eighteen 1099 PDFs and write one consolidated XLSX without sending a single SSN or EIN to a cloud service.

This guide is the workflow that gets you from “a folder of 1099 PDFs from a dozen different payers” to “one Excel workbook on its way to the CPA” without re-typing a payer EIN, without uploading the entire 2025 income picture to a web converter, and without paying for the consumer tax-prep software’s $80 “import documents” tier that only handles three of the eighteen forms anyway.

Why Mac (not iPad, not iPhone) for 1099 consolidation

1099 consolidation is an annual job that happens under deadline, with multiple form types, feeding a single accountant handoff. Three reasons the Mac is the right device:

  • Tax-prep work is desk work. 1099 season is February through April. Forms arrive scattered: some by email, some photographed from mail, some downloaded from a payer’s portal. They land on the Mac because the Mac is where the rest of the tax documentation lives — receipts, deductions, prior-year returns, the Schedule C draft. Consolidating in one pass on the Mac is the only workflow that survives the April pressure.
  • Per-form layouts demand the big screen. A 1099-NEC has effectively one box. A 1099-MISC has eighteen numbered boxes across two columns. A 1099-K has Box 1a (gross), 1b (card not present), 2 (merchant category code), and a per-month grid. Spot-checking that the extraction read Box 7 on the MISC correctly — not Box 8 — wants the PDF and the spreadsheet side by side.
  • Excel for Mac is the accountant’s format. Every CPA in the US opens .xlsx. Sending .numbers forces a manual export. Sending CSV strips cell types — and 1099 data has both string fields (EIN, payer name) and numeric fields (box amounts) that import macros expect typed correctly. XLSX is the universal handoff.

Why 1099 extraction is harder than receipts or invoices

A receipt batch is forgiving — get the date, vendor, and total right and the row is useful. A 1099 batch is the opposite: every box has IRS-defined semantics, and the wrong amount in the wrong box on Schedule C is a misfile. The failure modes:

  1. Six form layouts in one folder. A 1099-NEC, a 1099-MISC, a 1099-K, a 1099-INT, a 1099-DIV, and a 1099-B all live in the same folder for a freelancer with side investments. Each has different boxes, different total fields, different IRS reporting destinations. A batch tool that only handles one form type means six passes and six spreadsheets to merge by hand.
  2. Payer and payee TIN both matter. Every 1099 has the payer’s TIN (their EIN) and the payee’s TIN (your SSN or your LLC’s EIN). The CPA reconciles against IRS records using payer EIN; you reconcile your records using your TIN. Both fields have to come through intact.
  3. 1099-K overlap with 1099-NEC. A payment platform like Stripe issues a 1099-K for the gross processed; the client who used Stripe to pay you might also issue a 1099-NEC for the same compensation. Reporting both as separate income on Schedule C double-counts. The consolidation has to flag overlap candidates — same payer, same period, same approximate amount — so the human reviewer can mark which to exclude.
  4. Box numbering changed between years. The IRS reshuffles 1099-MISC and 1099-NEC box layouts every few years. The 1099-NEC was split out of 1099-MISC in 2020; 1099-K thresholds changed in 2023 and 2024. An extractor that treats every form as the current year’s template will misread older corrected forms.

A tool that handles the 1099-NEC case but trips on the 1099-K box grid is the gap most users fall into. The whole point of the consolidation is one workbook covering every form type, with the right amounts in the right columns, ready to import into the CPA’s worksheet.

Method 1: ignitai folder batch on macOS (the main path)

ignitai handles a 1099 batch the same way it handles an invoice batch — drag the folder, write the prompt once, get one consolidated workbook. The Mac flow:

  1. Stage the folder. Create ~/Documents/Taxes/2025/1099s/. Drop every 1099 PDF, photograph, or scan into it. If a form arrived by mail and got photographed with the iPhone, that HEIC or JPEG is fine input; the on-device model reads scanned tax forms about as well as native PDFs. Rename files to a convention that survives the spot-check: 1099-NEC-acme-corp.pdf, 1099-K-stripe.pdf, 1099-INT-fidelity.pdf. The filename becomes the source_file column and the audit trail.

  2. Open ignitai. Drag the folder onto the window. macOS 14.4+ on Apple Silicon (M1 onward) runs the on-device model — no SSN or EIN data leaves the Mac. Intel-era Macs fall back to a hosted pipeline with documented zero retention.

  3. Describe what to extract, in plain English. For a freelancer’s annual 1099 consolidation:

    “For each 1099 PDF, identify the form_type (one of: 1099-NEC, 1099-MISC, 1099-K, 1099-INT, 1099-DIV, 1099-B, 1099-R, 1099-G, 1099-OID, 1099-SA, 1099-S — return the exact form variant). Then return: tax_year, payer_name, payer_tin, payer_address, recipient_name, recipient_tin, account_number (if present), corrected (true/false based on the ‘Corrected’ checkbox), and source_file. For the box data: return every populated numbered box as a separate row in a long-format box_data sheet with columns box_number, box_label (the IRS label printed on the form, e.g. ‘Nonemployee compensation’ for 1099-NEC Box 1), box_amount, and form_id (a synthetic identifier linking back to the header row). If a state filing block is populated, return state, state_payer_id, state_income, and state_tax_withheld as additional box-data rows. Flag a potential_overlap = true on any 1099-K row where the gross amount within ±5% matches the sum of 1099-NEC Box 1 amounts from the same payer in the same tax year — these are likely the same income reported twice.”

    Save the prompt as a preset called “Annual 1099 consolidation.” Next year it’s one tap.

  4. Pick XLSX as the output format. Three-sheet workbook: forms for one row per form (header fields plus form_type), box_data for the long-format box rows, summary for a Schedule C-ready pivot. The CPA opens it and immediately sees totals; the box_data sheet is the audit trail.

  5. Hit Extract. A folder of eighteen 1099s on an M2 Mac processes in two to three minutes. Each form runs through the on-device model in 6–12 seconds. The progress bar shows file-by-file completion.

  6. Spot-check in Excel for Mac. Open the output 2025-1099s.xlsx. The forms sheet has eighteen rows; the box_data sheet has roughly sixty rows depending on form mix. Run the five reconciliation checks below before sending to the CPA.

End to end on a year’s worth of 1099 forms: under thirty minutes of human time, most of it the spot-check phase.

Why a multi-sheet XLSX (not one flat CSV)

For bank-statement imports into QuickBooks the right output is flat CSV. For 1099 consolidation, the data is fundamentally one-to-many — each form has one header (payer, recipient, year) and many populated boxes — so a flat CSV breaks down on the third row. Three reasons the multi-sheet XLSX is the right shape:

  1. Different forms have different box counts. A 1099-NEC has one numeric box; a 1099-MISC has up to eighteen; a 1099-K has a per-month grid plus annual totals. Flattening all forms into one CSV creates an eighty-column wide-format file with most cells empty, or loses data. Long-format box_data is the only shape that scales.
  2. Pivot-table totals for Schedule C. The summary sheet can SUMIFS against box_data filtered to form_type = 1099-NEC AND box_number = 1 for the Schedule C box-1 total instantly. The CPA gets the line ready to type, not a stack of forms to add up.
  3. The corrected-form audit trail. If a payer reissues a 1099 with the “Corrected” checkbox marked, both the original and the corrected form land in the folder. The corrected field on the forms sheet makes it possible to filter and supersede; a flat CSV loses the form-level status.

If your CPA wants one flat row per form, output that with a different prompt (one box per column, wide format). For everything else, the long-format multi-sheet structure is right.

Method 2: IRS Get Transcript (and why it’s not enough alone)

The IRS lets you download a Wage and Income Transcript from irs.gov/individuals/get-transcript. It lists every 1099 the IRS received for your TIN, with payer name and amount. Two reasons it’s a useful cross-check but not a replacement:

  1. Transcripts lag. A 1099 issued in late January often doesn’t show on the transcript until June or July, well after the April filing deadline. For April tax prep, the transcripts cover at best 60% of the actual forms you need to file. The PDFs in your folder are the source of truth.
  2. The transcript is summary-only. It shows payer name, TIN, and gross amount. It does not break out 1099-MISC boxes (rent vs royalties vs prizes), does not give you state income for the state return, does not surface the corrected-form chain. For the actual Schedule C and state filing, the PDFs hold the structured detail.

Pull the Wage and Income Transcript anyway as a final reconciliation step — after the consolidation is done, compare your forms sheet against the transcript line by line. Anything on the transcript but missing from your folder is a 1099 a payer issued without sending you a copy, and the IRS will expect to see it on the return.

Method 3: TurboTax / H&R Block document import

TurboTax Premium, H&R Block, and other consumer tax-prep tools advertise “import your 1099s.” Direct import works only for a small list of payers — brokerages (Fidelity, Schwab, E*TRADE), some banks for 1099-INT, and a handful of payroll-card platforms. Stripe-issued 1099-Ks, board-advisor 1099-MISCs from small companies, ad-hoc grants — those don’t have an import path; you type them in by hand. Even where direct import works, it uses your brokerage credentials to pull data through the tax-prep vendor’s servers, where the return is then stored. The on-device path produces the spreadsheet that feeds the consumer tax-prep tool’s interview screen; it doesn’t replace the tax-prep tool itself.

Method 4: web “PDF to Excel” converters (and why never for 1099s)

The cardinal rule of tax-form privacy: a 1099 PDF contains a TIN, in plain text, that uniquely identifies you to the IRS. Uploading it to a free-tier web converter — whose terms typically allow processing or retaining submissions — is a category of mistake unto itself. Web converters also have no form-type awareness; the 1099-K monthly grid comes through as a tangle of unlabeled columns and the post-processing to recover box meaning is the slow part. Free-tier file caps (three to five per month) don’t survive a real 1099 batch either. For a sample 1099 from an IRS instructions PDF, fine. For your actual 2025 income forms, no.

The five reconciliation checks for the 1099 batch

Once the XLSX is written, five checks separate “I have a file” from “I have a Schedule C input I can trust”:

  1. Form count vs folder count. The forms sheet should have one row per PDF in the source folder, minus any corrected pairs (where the corrected version supersedes the original). Sort by source_file. If you started with eighteen PDFs and the sheet has seventeen rows, one didn’t extract — usually a scan with low contrast that needs a re-pass.
  2. TIN format sanity. Every TIN should match one of two formats: XX-XXXXXXX (EIN) or XXX-XX-XXXX (SSN). If a payer_tin came through as letters or a partial string, the extraction misread the field — common when the box was handwritten over a printed template. Hand-correct.
  3. Box-1 totals per form type. Pivot box_data by form_type, summing box_amount filtered to the relevant box (Box 1 for 1099-NEC, Box 1a for 1099-K, Box 1 for 1099-INT). The totals should match your own bookkeeping records’ income figures within rounding. Big divergence means either a missed form or a misread amount.
  4. 1099-K overlap resolution. Filter forms to potential_overlap = true. For each flagged row, decide: is this 1099-K reporting the same income as a 1099-NEC from a client who paid through that platform? Mark the duplicate. Add a column on the summary sheet for excluded_due_to_overlap so the Schedule C box 1 calculation excludes the overlap.
  5. State-income reconciliation. Filter box_data to state-related rows. Group by state. Each state where you owe a state return should have a coherent total. A missing state row on a form that lists state filing means the extractor didn’t pick up the state block — manual fix.

Skip these five and the Schedule C is wrong in subtle ways — a missed 1099-NEC under-reports income (and the IRS notices when their transcript arrives), a 1099-K overlap over-reports income (and you overpay tax), a misread Box 4 federal withholding under-claims credits.

A worked example: freelance consultant filing for 2025

A single-member LLC consultant with nine 1099-NECs from direct clients, three 1099-MISCs (royalty, sublet rent, competition prize), one 1099-K from Stripe, two 1099-INTs, one 1099-DIV, and two 1099-Bs. Eighteen forms. Mac flow:

  1. Open ~/Documents/Taxes/2025/1099s/. Eighteen PDFs, clean names.
  2. Drag the folder into ignitai. The on-device model on M3 MacBook Pro processes in two and a half minutes.
  3. Apply the “Annual 1099 consolidation” preset. Pick XLSX. Extract.
  4. Open 2025-1099s.xlsx. 18 form rows, 64 box-data rows.
  5. Run the five reconciliation checks. One 1099-MISC came through with payer_tin as 99-99-9999 because of an older template’s TIN placement — hand-fix. One 1099-K Box 1a flagged potential_overlap = true against four 1099-NEC rows from Stripe-routed clients — confirm, mark as excluded_due_to_overlap.
  6. Build the summary sheet. Schedule C Box 1: sum of 1099-NEC Box 1 + non-excluded 1099-K Box 1a + 1099-MISC Box 1 from the sublet. Schedule B interest: sum of 1099-INT Box 1. Schedule B dividends: sum of 1099-DIV Box 1a. Schedule D: sum of 1099-B Box 1d minus Box 1e.
  7. Email to the CPA. Total time: about forty-five minutes.

Compare to typing every box into a CPA-supplied intake spreadsheet by hand: a Sunday afternoon plus an inevitable round of corrections when the CPA spots a transposed TIN.

When the Mac 1099 batch isn’t the right tool

Honest edge cases:

  • One W-2 and three 1099s, total. Don’t fire up the batch for four documents. Type them into TurboTax’s interview or hand them to the CPA. The batch path earns its keep at ten-plus forms.
  • K-1s, not 1099s. Schedule K-1 from a partnership or S-corp is a different document with different boxes. The batch prompt above won’t handle K-1s; use a separate run with a K-1-specific prompt, or pass K-1s straight to the CPA as PDFs.
  • Corrected forms after filing. If a payer issues a corrected 1099 after April, the right answer is an amended return (1040-X), not a re-run of the consolidation. Keep the corrected PDF for next year’s audit trail.
  • High-volume traders with hundreds of 1099-B rows. A 1099-B from an active trading account can run twenty pages. Use the brokerage’s own CSV export instead — every major broker offers one. Reserve the PDF batch for the consolidated 1099-B summary, not line-level transactions.

Bottom line

For a Mac user staring down a folder of fifteen or more 1099 PDFs from various payers that need to become one Excel workbook for the CPA: stage them in a folder, drag it into ignitai, apply the saved preset, pick XLSX, run the five reconciliation checks. For three or four forms and a willing afternoon, manual entry into the tax-prep tool’s interview works. For the W-2-only filer, none of this applies — type it into TurboTax and be done.

The same app handles the Mac invoice batch for the client-side accounts-payable view, the Mac credit card consolidation for the deductible-spending review, bank statement extraction for the income-side reconciliation, and the generic Mac batch path for anything else the CPA asks for. Presets sync via iCloud, so the 1099 prompt written once on Mac is the same one available next year — and the Schedule C box-1 calculation runs the same way on every year’s batch.

Get ignitai on the App Store — free download, $19.99/mo unlocks unlimited extractions after the 3-day trial.