Drop in any K-1 PDF — Form 1065 partnership K-1, Form 1120-S S-corp K-1, or Form 1041 trust/estate K-1 — and get a clean Excel file with partner/shareholder name, EIN, ownership percentage, every box amount, and supplemental footnote disclosures as separate fields.
Partnership K-1s (Form 1065) and S-corp K-1s (Form 1120-S) have 20+ box positions — Box 1 ordinary income, Box 2 net rental real estate, Box 3 other rental, all the way through Box 14 self-employment earnings, Box 17 alternative minimum tax items, Box 19 distributions, Box 20 other information. Plus supplemental statements with footnoted disclosures (Section 199A QBI calculation, foreign-tax detail, capital account reconciliation) that don't fit on the main form.
Tax preparers handling family-office returns or LP investor packets see dozens of K-1s per client. Each one comes from a different fund administrator with slightly different supplemental detail. Tax software import only works when the issuer provides a clean K-1 export; client-handed PDFs don't import. So preparers type box amounts and footnote details into Lacerte / ProSeries / Drake / UltraTax for hours per client.
PDFExcel reads partnership K-1s, S-corp K-1s, and trust/estate K-1s. Each K-1 becomes one row with partnership name, partnership EIN, partner name, partner SSN/EIN, beginning/ending capital account, ownership percentage at start and end of year, and every Box 1 through Box 21 amount as a separate column. Supplemental statements (Section 199A passthrough disclosures, foreign-tax statements, capital account roll-forward) come through as a separate field for review.
Mix multiple K-1s for the same client in one upload — one workbook back with each K-1 as a row. Built-in OCR handles client-provided scans. Drop the export into your tax software's K-1 entry screen column-by-column, or use as a prep checklist before starting the return.
The model knows the difference between Form 1065 K-1 box numbering and Form 1120-S K-1 box numbering — they look almost identical but the meaning of each box differs. Trained on real K-1s including family-office LP packets and operating partnerships.
K-1s are the form preparers spend the most time on per dollar of fee. Most tax-document tools either need a fund-admin integration or charge per-form. PDFExcel reads any K-1 PDF on the first upload.
Mixed 1065 + 1120-S K-1s in one upload. One row per K-1 with key boxes and ownership percentages.
| # | Form | Year | Partnership / S-corp | Partner | Ownership % | Box 1 | Box 19 Dist. |
|---|---|---|---|---|---|---|---|
| 1 | 1065 | 2024 | Ridgeway Partners L.P. | Smith Family Trust | 12.50% | $184,200.00 | $120,000.00 |
| 2 | 1065 | 2024 | Coastal Real Estate Fund III | S. Patel IRA | 0.85% | $8,420.00 | $5,200.00 |
| 3 | 1065 | 2024 | Bay Area Venture Partners IX | Smith Family Trust | 1.20% | ($14,800.00) | $0.00 |
| 4 | 1120-S | 2024 | Patel Holdings, Inc. | S. Patel | 100.00% | $248,400.00 | $80,000.00 |
| 5 | 1041 | 2024 | Smith Family Bypass Trust | Smith Family Trust Bene | 100.00% | $22,840.00 | $22,840.00 |
CPAs filing 1040s for high-net-worth clients with LP investments, family-office tax preparers, fund administrators preparing K-1 packets, EAs handling small S-corp returns.
Client invests across 25 LP funds. Each fund administrator sends a K-1 between March and September. Convert each K-1 as it arrives, build the running schedule. Final return prep takes 2 hours instead of 2 days.
30 partner entities × 50 LP positions each. K-1 season runs through summer. PDFExcel batch-converts each entity's K-1 packet into a single workbook for the team's prep checklist.
Files 80 S-corp returns with associated 1120-S K-1s for shareholders. Convert all K-1s in one session, copy into Drake. Prep time drops from 30 minutes per K-1 to under 10.
Yes — both, plus Form 1041 trust/estate K-1s. The model knows the boxes have different meanings between 1065 and 1120-S even though they look similar, and adapts the column mapping accordingly.
Yes. The supplemental Section 199A statement on partnership K-1s extracts as a separate field with QBI amount, W-2 wages component, UBIA component, REIT/PTP income, and SSTB classification when present. Useful for downstream QBI deduction calculation.
Yes. Foreign-tax detail, capital account roll-forward, and other supplemental statements come through as separate text fields. The model preserves the structure but doesn't 'interpret' the disclosures — preparers should review footnoted detail before filing.
10 documents per month, free, forever. Most family-office and HNW tax preparers scale up during K-1 season (March-September) — Pro at $199/month for 200 documents covers most boutique practices. Pause/resume monthly.
We export CSVs that those systems' K-1 entry screens accept via copy-paste. Most preparers paste column-by-column into the form-entry workflow. We don't have a direct API integration — by design, keeps the tool simple.