Free Excel templates

A free partnership basis calculator in Excel, with a worked case

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.

Get the calculator

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.

The book behind this calculator

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

What is in the file

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.

Read me
What the file does, how to replace the example with a real partner, the limits of the tool, the example, and what it does not decide.
Inputs
The opening basis, tax capital, share of liabilities and suspended losses; then, for each year, money and the adjusted basis of property contributed, the share of taxable income or loss, of tax-exempt income and of nondeductible expenses, money and the basis of property distributed, and the share of liabilities at the end of the year; then the rules, each with the date it was read.
Basis
Year by year: the basis at the start, the change in the share of liabilities, the basis after the increases, money distributed (a decrease in the share of liabilities counts as money), the section 731 gain, the basis of property distributed, the losses to apply with those suspended earlier, the loss allowed by section 704(d), the loss suspended and carried forward, and the outside basis at the end of the year.
Capital
The tax capital beside the basis (contributions at the adjusted basis of the property, the full share of income or loss, distributions at the partnership’s basis), then the reconciliation: tax capital + share of liabilities + suspended losses + section 731 gains + property basis not taken over = outside basis, with a difference line that must read zero.
Checks
Each output set against the figure printed in the book, then structural checks. A result goes to a client file only when the tab reads ALL CHECKS OK.

What the worked case shows

Fictional case. The loss includes a special allocation of additional first-year depreciation that the book tests in chapter 6.
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
Fictional case. The distribution is tested after the income of the year and before the losses, in the order of the rule cells.
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 731greater 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.

The rules and their dates

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.

How to use it on a real partner

  1. On Inputs, type the opening figures: the basis, the tax capital, the share of liabilities and any suspended loss at the start of the first year.
  2. For each year, type the figures from the partner’s Schedule K-1 and the partnership’s records, with a loss as a negative figure.
  3. Type the share of liabilities at the end of every year you use. A year left empty keeps the share it starts with, so an unused year adds no distribution and no gain.
  4. Read Basis and Capital, and keep the Checks tab: once you change an input the comparison with the book stops matching, which is expected; the structural checks still have to pass.

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.

Questions people ask about it

Is this partnership basis calculator really free?

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.

Does it apply the at-risk, passive activity and excess business loss limits?

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.

Can it handle the sale of an interest or a section 743(b) adjustment?

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.

Why does the reconciliation add suspended losses?

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.

Related reading