Enter one partner’s contributions, share of income or loss, distributions and share of liabilities for up to five years, and the file builds the outside basis in order (increases, then distributions, then losses), applies the section 704(d) loss limit and carries the suspended loss forward, runs the section 731 test on money, keeps the tax capital beside the basis and reconciles the two. Five tabs, no macros.
The example is a member of the book’s fictional machining company. Russell Pratley contributes machines with an adjusted basis of $360,000 and personally guarantees the company’s $500,000 bank loan, so the whole loan sits in his basis: $360,000 + $500,000 = $860,000. His 2026 loss is $1,040,000; section 704(d) allows $860,000 and suspends $180,000. In 2027 his income of $450,300 and a cash distribution of $114,000 bring the suspended loss back, and his outside basis ends at $156,300 while his tax capital is -$343,700. The Checks tab confirms every figure against the book.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
PTH_Partnership_Basis_Calculator.xlsx (17 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This file is a simplified copy of the third of the five workbooks of The Partnership Tax Handbook, for one partner and with no links to the other workbooks. The book follows two fictional files over two years, from the engagement letter to the returns: a machining company formed by three members, one of whom contributes appreciated machines, and a flex building owned by two members and refinanced with a nonrecourse loan.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Five tabs. Blue cells on a light blue fill are inputs; black cells are formulas; a yellow cell beside a single input takes your own figure.
| Step (fictional member, 2026) | Value |
|---|---|
| Adjusted basis of the machines contributed on 2 January 2026 | $360,000 |
| Share of the bank loan he guarantees (section 752, recourse) | $500,000 |
| Basis before the loss | $360,000 + $500,000 = $860,000 |
| Loss allocated for 2026 | $1,040,000 |
| Loss allowed by section 704(d) | $860,000 |
| Loss suspended and carried forward | $1,040,000 - $860,000 = $180,000 |
| Outside basis at 31 December 2026 | $0 |
| Tax capital at 31 December 2026 | $360,000 - $1,040,000 = -$680,000 |
| Reconciliation | -$680,000 + $500,000 + $180,000 = $0 |
| Step (same member, 2027) | Value |
|---|---|
| Basis after the income of the year | $0 + $450,300 = $450,300 |
| Cash distributed on 31 December 2027 | $114,000 |
| Gain under section 731 | greater of zero and $114,000 - $450,300 = $0 |
| Basis after the distribution | $450,300 - $114,000 = $336,300 |
| 2026 suspended loss now allowed | $180,000 |
| Outside basis at 31 December 2027 | $336,300 - $180,000 = $156,300 |
| Tax capital at 31 December 2027 | -$680,000 + $450,300 - $114,000 = -$343,700 |
| Reconciliation | -$343,700 + $500,000 + $0 = $156,300 |
Read the two years together. In 2026 the loss is larger than the basis, so the basis stops at zero and $180,000 waits. In 2027 the income raises the basis first, the distribution of $114,000 comes out of it without any gain, and only then does the suspended loss use what is left. The tax capital goes negative because the loss was funded by the loan; the guaranteed loan in his basis is what makes the reconciliation tie.
The same member raises a question the calculator does not answer: he contributed property and received cash less than two years later. As read in November 2026, the regulations presume a sale when such transfers fall within two years, unless the facts clearly show otherwise, and presume that a distribution of operating cash flow is not part of a sale (26 CFR 1.707-3(c)(1) and 1.707-4(b)(1)). The book’s file records the distribution as a year-end distribution of the year’s profit, made by profit shares, a reading the CPA checks.
Every rule the calculator follows is a cell with the date it was read, so that you can replace it when it changes. As read in November 2026: the basis of an interest acquired by contribution is the money plus the adjusted basis of the property contributed (26 U.S.C. 722); it is increased by the distributive share of taxable and tax-exempt income and decreased, not below zero, by distributions and by the share of losses (section 705(a)); an increase in a partner’s share of partnership liabilities is treated as a contribution of money and a decrease as a distribution of money (section 752(a) and (b)); a loss is allowed only to the extent of the basis at the end of the year, and the excess is carried forward (section 704(d)). For that limit, the basis is first increased, then decreased for everything except the losses of the year and those carried forward (26 CFR 1.704-1(d)(2)), and the decreases of section 705(a)(2) include distributions, so a distribution of the year comes before the losses. A distribution of money is taxed only to the extent it exceeds the basis just before it (section 731(a)), and property distributed takes the partnership’s basis, limited to the partner’s basis left (section 732(a)). Advances or drawings against a partner’s share of income are treated as distributions made on the last day of the year (26 CFR 1.731-1(a)(1)(ii)). Check each rule on irs.gov before using the file.
An educational tool, not advice. The calculator computes; it does not decide how a partnership allocates, reports or elects, or whose basis a loan belongs in, and it promises no result. It stops at section 704(d): the at-risk, passive activity and excess business loss limits are applied afterwards, on the partner’s own return. The people and the figures are fictional teaching assumptions. For a real file, consult a qualified tax professional.
Yes. It is a companion file of a book. You enter an email address, the download opens at once, and you can leave the reader list in one click.
No. It stops at section 704(d). Those limits are applied after it, on the partner's own return, and the book explains where they sit; their order is not computed in this file.
No. It follows one partner who stays in the partnership: contributions, income or loss, distributions of money or property, and the share of liabilities. A sale of an interest and the buyer's adjustment are worked in the book's full workbooks.
A loss suspended by section 704(d) has already reduced the tax capital but not the basis, which cannot go below zero. Adding it back, with any section 731 gain and any property basis the partner could not take over, ties tax capital plus the share of liabilities to the outside basis.