Template and method
K-1 summary spreadsheet: ten columns, and the one that makes it reviewable
A summary of a K-1 is only useful if somebody can check it against the paper. That takes one column most templates leave out: the page the figure came from. Everything else is organisation around that.
It works as a K-1 template, and the page covers where K-1 automation stops and where a person still has to decide.
Columns
Ten columns, and why each one earns its place
| Column | What belongs in each row | What breaks without it |
|---|---|---|
Partner | The entity or person the K-1 belongs to, spelled as the return spells it. | A name that differs from the client record splits the summary and hides one partner's boxes. |
PartnerEIN | The identifying number, kept as text. | A spreadsheet turning 12-3456789 into a number, or dropping a leading zero. |
TaxYear | The year the K-1 relates to. | A prior-year K-1 mixed into the current file, which is invisible once sorted by name. |
EntityType | Partnership or S corporation, and whether the K-1 is 1065 or 1120-S. | The two forms share box numbers with different meanings, so a mixed file is read wrong. |
Box | The box number as printed, or the part and item for the header sections. | Free text such as "box 1 (partnership)", which no filter can group. |
Code | The letter for a coded box: 11, 13, 14, or 20. | Codes collapsed into the description, so the code and the amount cannot be separated. |
Description | What the box or code is, in the form's own words. | A paraphrase that no longer matches the K-1 the reviewer is holding. |
Amount | The printed figure, signed, with brackets read as negative. | A loss that loses its sign; a STMT box written as zero. |
Page | The page of the K-1 the figure came from. | Left blank, which turns every later question back into a re-read of the document. |
Note | Anything a reviewer has to know: a statement attached, a figure accepted as printed, an amended K-1. | An empty note on an unusual row is the same as an unexplained one. |
Software, a spreadsheet, and automation are three different things
Tax software holds the return and decides what the numbers mean. A spreadsheet holds your working paper and proves the return was checked against the document. Automation is the part that reads the PDF, which is neither of the other two and is where the hours actually go.
Buying automation to replace the spreadsheet removes the working paper and keeps the entry. The useful split is the other way round: automate the reading, keep the spreadsheet as the record of what was read and where it came from. See what the professional packages ask for.
The three checks to keep whatever you use
- Every STMT box has a note. A box that says STMT and a row with no amount is either complete with an attachment or incomplete without one, and only a note tells you which.
- Every coded box has a code in the code column. Boxes 11, 13, 14 and 20 are meaningless without the letter.
- Every loss is negative. Scan the amount column for positive values in boxes that should only ever be negative, or the reverse.
Filling the template by hand is fine, briefly
For one K-1 a year, typing it is the correct answer and no tool will beat it. The arithmetic changes at volume: a fund with eleven partners, a firm with two hundred clients, a season where the same four boxes are read four hundred times. That is the point at which a reading error becomes likely and a page reference becomes worth having.
Plain answers
Questions about the worksheet
What columns does a K-1 summary spreadsheet need?
At minimum the partner, the box or code, the amount and the page it came from. Everything else is convenience. The page column is the one people leave out and the one that makes the difference between a summary that can be reviewed and a list of numbers that cannot.
Can I download a template?
Yes. The template on this page has ten columns and four example rows, including a coded box and a STMT box, so you can see how the awkward cases are recorded. It is a plain CSV and any spreadsheet will open it.
What does K-1 software automate, and what does it not?
Software reads the document and extracts the values, which is the slow part. It does not decide whether a code is relevant to this client, whether a statement attachment changes the figure, or whether the prior year is consistent. Those are the preparer's judgement and they stay with the preparer.
Is automation of K-1 data entry safe?
It is safer than retyping, on one condition: the output is checkable. A tool that shows the page each value came from lets a reviewer confirm in seconds. A tool that returns a clean-looking summary with no provenance has removed the evidence along with the work.
How should a STMT box be recorded?
As a row with no amount and a note saying the figure is on an attached statement, with the page of the attachment if you have it. Writing zero is the mistake that turns an incomplete K-1 into a wrong return.
Why keep the code in its own column?
Because box 13 and box 20 carry a letter as well as an amount, and a letter is the only thing that says what the amount is. Put the code into the description and you can no longer filter by it, sum it, or check it against the form.
Should the spreadsheet be the record of what was filed?
No. The tax return is the record. The spreadsheet is the working paper that lets someone else check the return against the K-1, and it should be kept with the return for as long as the firm keeps working papers.
Fill the worksheet from the PDF
K1 FastTax reads every box and code from a K-1 and writes a CSV in these columns, with the page each value came from.