Convert K-1 PDF to Excel on Mac: Every Box, Every Partnership

To convert a Schedule K-1 PDF to Excel on a Mac, drag the K-1s into a tool that reads the page and ask for one row per amount: form, partnership name and EIN, box, code, printed description and amount, with parentheses turned into negative numbers and every “STMT” box filled from its statement page. Export to Excel, then run a second pass that returns one row per K-1 with the capital account and ownership percentages, and check both against the face pages. If your tax software already imports K-1s, or the partnership offers a tax-software download, use that first.

The Mac app for the reading part is ignitai. It reads each page with Apple’s on-device text recognition, and an AI builds the table your plain-English instruction describes, so one instruction covers a fund administrator’s long package, a two-page S corporation K-1 and a paper copy that came in the mail. The page images stay on your Mac; only the recognized text goes to ignitai’s servers, where the spreadsheet is built.

K-1s are the forms that hold up a return. Partnerships and S corporations file by March 15, or by September 15 on extension, and plenty of investors extend their own return to October 15 to wait for the last one. When they arrive there are often many: six private funds, a real estate syndication, the family S corporation, a trust. The numbers have to reach tax software, a basis tracker or a preparer’s review sheet, and the usual method is the PDF on one screen and typing on the other.

In this guide12 sections

What a K-1 holds, and what you need from it

Every K-1 has two halves.

The header items. The entity’s name and EIN, your name and identifying number, the Final K-1 and Amended K-1 checkboxes, and on the partnership form, item J (your share of profit, loss and capital), item K (your share of liabilities: nonrecourse, qualified nonrecourse financing and recourse) and item L (the capital account: beginning balance, capital contributed, current-year net income or loss, other increase or decrease, withdrawals and distributions, ending balance). Partnerships have reported item L on the tax basis since tax year 2020.
The boxes in Part III. On a Schedule K-1 (Form 1065), box 1 is ordinary business income, 2 is net rental real estate income, 4a to 4c are guaranteed payments, 5 is interest, 6a and 6b are dividends, 9a is net long-term capital gain, 11 and 13 hold other income and other deductions under letter codes, 14 is self-employment earnings, 19 is distributions and 20 is other information.

The same box number means something else on the other two K-1s. On the S corporation version (Form 1120-S), interest is box 4, distributions sit in box 16 under code D, and other information is box 17. On the estate and trust version (Form 1041), box 1 is interest income. A sheet that mixes them needs a form column, or a sum of “box 4” adds interest to guaranteed payments.

Then there are the statements. A box that holds more than a line or two prints “STMT” or “See statement”, and the figures live on supplemental pages further back: other income and deductions by code, Section 199A information, the detail behind box 20. Fund packages add a cover letter, state K-1s and often a Schedule K-3 for international items, so a single investor’s package can run to dozens of pages.

Why K-1s break PDF-to-Excel converters

Boxes, not a table. Part III is two columns of numbered boxes, several of them holding stacked code-and-amount pairs. A grid converter returns labels and amounts in reading order, so box 13’s three codes end up mixed with box 14’s single figure.
The amounts aren’t all on the face page. A converter that handles page one alone misses every figure behind a “STMT”, which on a fund K-1 is often most of them.
Losses print in parentheses. (12,450) is a loss of 12,450. Copied as text, it is neither negative nor a number.
Three forms, three numbering schemes. A template built for the 1065 misreads every 1120-S and 1041 in the stack, and the cover letters and state pages around them become rows too.

Convert K-1 PDFs to Excel on Mac with ignitai

Gather and trim the K-1s. Download each one from the investor portal or the preparer’s email. Many portal PDFs are password-protected; ignitai names a password-protected PDF rather than skipping it, so open that file in Preview with the password first. Then cut each package down to the federal K-1 and the statements for the boxes you need: in Preview, choose File ▸ Print, set the page range, and pick Save as PDF from the PDF menu. That copy usually comes without the password, and it spends fewer pages.
Drag the PDFs onto the ignitai window, open them with ⌘O, or right-click them in Finder and choose Open With. A paper K-1 can come in through File ▸ Import from iPhone or iPad, which scans it with your iPhone’s camera; for capture quality, see the scanned-PDF walkthrough for Mac.
Describe the rows. A prompt is required, so the Convert button stays disabled until you type one:

“One row per amount on each Schedule K-1. Columns: tax_year, form (1065, 1120-S or 1041), entity_name, entity_ein, box (as printed, such as 1, 6a or 20), code (the letter code, if any), description (the label printed for the box or the statement line), amount. Write amounts as plain numbers; an amount in parentheses is negative. When a box says STMT or See statement, take the figures from the attached statement instead, one row per statement line, under that box number. Skip empty boxes, cover letters, state K-1 pages and Schedule K-3.”

Save the instruction, and next year it’s one click away.
Check the page count, then Convert. Before the run starts, ignitai shows how many pages it will use and how many you have left. Each file shows its status as the batch runs, and a notification arrives when the spreadsheet is ready.
Check the table in ignitai. Rows are numbered, the amount column is totaled on screen, and selecting one K-1’s rows adds them up. Original Pages keeps every page a click away, so compare a K-1’s rows with its face page box by box. If a column came back empty, ignitai says so, which usually means a column name doesn’t match the form’s wording.
Export to Excel. Amounts are real numbers in the Excel file, losses included, so a sum works the moment it opens; the header is bold and the columns fit their content. Corrections happen in Excel or Numbers.

There is no filename column. Filenames never leave your Mac, so batch output can’t say which file a row came from. That’s why the instruction asks for the entity’s name and EIN: both are printed on every K-1, and the EIN stays unique when two funds have nearly identical names.

Page allowance. The plan includes 80 pages a week, up to 320 a month; unused weekly pages don’t carry over. Ten untrimmed fund packages of 40 pages each is 400 pages, so trim first, read the page count ignitai shows before the run, and buy extra pages while subscribed for the rest. Packs run from 5 pages to 1,050, and bought pages never expire. Prove the instruction on one K-1 of four pages or fewer before the full run.

Get ignitai on the App Store — free download; your first document (up to 4 pages) converts free with Sign in with Apple, and one subscription covers iPhone, iPad, Mac, and Vision Pro.

A second run: one row per K-1

Each run produces one table, and the header items have a different grain from the boxes. Run the face pages again with a second instruction:

“One row per Schedule K-1. Columns: tax_year, form, entity_name, entity_ein, final_k1 (yes or no), amended_k1 (yes or no), profit_pct_end, loss_pct_end, capital_pct_end, liabilities_nonrecourse, liabilities_qualified_nonrecourse, liabilities_recourse, capital_beginning, capital_contributed, current_year_net_income, other_increase_decrease, withdrawals_distributions, capital_ending. Percentages as numbers without the % sign. An amount in parentheses is negative, except withdrawals_distributions, which is always positive. Leave a cell empty when the form has no such item.”

S corporation and trust K-1s have no item L, so their capital columns stay empty. This run spends pages too, so give it only the face page of each K-1. The two tables join on entity_ein with XLOOKUP.

Check the sheet before it goes anywhere

K-1 count. The second table should have exactly one row per K-1 you collected.
The capital roll-forward. With the columns above in A to R, =M2+N2+O2+P2-Q2-R2 should return 0 for every partnership row: beginning, plus contributions, plus the year’s result, plus other changes, minus distributions, equals ending. A non-zero result is a misread figure or a sign error, and it points at the row to open.
Last year’s ending, this year’s beginning. If you kept last year’s sheet, each partnership’s ending capital should equal this year’s beginning capital. A gap means a restatement or a misread, and both deserve a question to the partnership.
Distributions. For partnerships, box 19 and item L’s withdrawals and distributions usually agree when the distributions were all cash. A difference is worth reading the statement for.
Signs. Filter the amount column for negatives and confirm each one printed in parentheses; check boxes 1 and 2 by eye on every K-1.
Statement coverage. Every box marked “STMT” on a face page should have statement rows under its box number. A box with no rows means the statement page wasn’t in the file.

What the sheet is for

Entering K-1s into tax software. Consumer and professional software both take K-1s box by box. Filter the sheet to one entity, sort by box and code, and the entry follows the rows in order, without hunting through statement pages.
Basis and at-risk tracking. The second table, kept year after year, is the capital and liability history you’ll need when a fund sends a final K-1.
Portfolio review. A PivotTable with entity_name as rows, box as columns and the sum of amount as values shows every partnership’s income, gains and distributions side by side.
Preparer intake. A client’s fifteen K-1s become one review sheet before anyone opens the return. 1099s are a separate batch with a prompt of their own, covered in the 1099 guide, and wages go through the W-2 workflow.
Lending. Underwriters who spread self-employed income read K-1 figures next to the personal return; the tax-return guide covers the 1040 side of that file.

Other ways to get K-1 data into Excel

Download the data instead of the print. Many publicly traded partnerships deliver K-1s through a tax-package website that offers a download for tax software, and some fund portals export K-1 data. Where that exists, it is exact and free.
Firm-scale K-1 tools. The big tax suites sell scan-and-populate modules, and services such as K1x and Additive specialize in K-1 data for accounting firms, priced for firm volume.
Excel for Mac’s Get Data. Power Query is under Data ▸ Get Data, but Excel for Mac has no From PDF connector; that one is Excel for Windows only. Even on Windows it imports grids, not boxes and statements.
Acrobat’s Export PDF to Excel. It keeps the layout, not the meaning: labels and amounts land wherever the page geometry puts them, and statements come out as separate fragments.

On iPhone and iPad

iPhone. Scan a paper K-1 with the camera in ignitai, tap the saved instruction, and follow progress on the Lock Screen and in the Dynamic Island.
iPad. K-1s downloaded to Files can be multi-selected in the picker or sent from Mail through the share sheet (there’s no external drag-and-drop into the app on iPad). Sort the finished table by any column, then select rows and copy them before you export.

One subscription covers iPhone, iPad, Mac and Vision Pro, and finished files open on your other devices after Sign in with Apple.

Identifying numbers on a K-1

A K-1 carries the entity’s EIN, your identifying number (sometimes truncated to the last four digits on your copy), your address and every figure on the form. In this workflow the page images stay on your Mac. The recognized text of every page goes to ignitai’s servers, where the AI builds the sheet, and that includes fields you leave out of the instruction: leaving a column out keeps it out of the spreadsheet, not out of the text. The finished file is stored in your ignitai account until you delete it, and any file, or the whole account, can be deleted from inside the app. If you prepare returns for clients, the data-security plan your practice already follows applies to this step too.

When not to use this

One or two simple K-1s. Type them into the software’s K-1 screens.
Your software or firm already imports them. A direct import from the partnership’s tax package beats reading the page.
Schedule K-3. Its international tables run long and go to the preparer as they are.

Bottom line

To convert K-1 PDFs to Excel on a Mac, trim each package to the federal K-1 and its statements, drag them into ignitai together, and ask for one row per amount, with parentheses as negatives and statement figures under their boxes. Run the face pages again for one row per K-1 with items J, K and L. Then check one row per K-1, a capital roll-forward that returns zero, signs that match the parentheses, and statement rows behind every “STMT”. Where a data download or a K-1 import exists, use it; for everything that arrives only as a PDF, read the page.

FAQ

How do I convert a K-1 PDF to Excel?

On a Mac, drag the K-1 PDFs into ignitai and ask for one row per amount, with the form, the partnership’s name and EIN, the box, the code, the printed description and the amount. Say that an amount in parentheses is negative, then convert to Excel. Before you use the sheet, compare one K-1’s rows with its face page.

Can I convert K-1s from partnerships, S corporations and trusts in one batch?

Yes. The instruction describes boxes and labels rather than positions on the page, so 1065, 1120-S and 1041 K-1s land in the same columns, with a form column to tell them apart. Box numbers mean different things on each form, so filter by form before you total a box.

What about amounts that say STMT or See statement?

Tell the instruction to take those figures from the attached statement, one row per statement line, under the box that points to it. Include the statement pages in the run and leave out the pages you don’t need, such as state K-1s and Schedule K-3, because every page counts against your page allowance.