Key Takeaways

  • An S corp shareholder’s basis must be tracked annually to determine taxability of distributions and losses.
  • Basis includes both stock basis and debt basis; the latter applies when a shareholder personally lends money to the corporation.
  • The shareholder's basis is affected by contributions, income, distributions, deductions, and losses.
  • A shareholder cannot deduct losses exceeding their basis and must carry them forward until they have sufficient basis.
  • Excel worksheets help track basis changes, using inputs from Schedule K-1 and Form 1120S.

An S corp basis worksheet is used to compute a shareholder's basis in an S corporation. 

Shareholders who have ownership in an S corporation must make a point to have a general understanding of basis. The amount that the property's owner has invested into the property is considered the basis. This basis fluctuates with changes in the company. 

According to the IRS, basis is the amount of the shareholder's investment in the business for tax purposes. Initially, the basis is the cost of the property, but in an S corporation, the basis can change as a shareholder's investment changes. While a C corporation stock basis stays the same each year, an S corporation basis can change due to annual income, distributions, and loans.

Upon the filing of the S corporation's tax return (1120S), shareholders will receive a K-1 form providing their allocated profits, losses, and deductions. The taxable amount of the distribution is not included on the K-1 form because it is dependent on the stock basis.

The primary reason for basis is to determine the taxability and deductibility of distributions and losses. Annually, a shareholder's basis is individually calculated and must be followed from the start of ownership.

Importance of Basis

In order to report pass-through losses or deductions, shareholders must first verify that they have enough basis in the S corporation. If distributions received are fully covered by shareholders' basis, then they do not have to report the distribution as taxable income. Losses are permitted to be deducted in the current tax year if the shareholder has enough basis to cover the amount of the loss.

Basis is also used in determining the gain or loss on a shareholder's disposal of stock. Additionally, basis is taken into account when the company has a change in ownership.

Two Types of Basis

There are two types of basis numbers that must be followed: 

  • Stock basis
  • Debt basis

A debt basis is acquired if the shareholder makes a direct loan to the corporation. In doing so, the shareholder takes on a certain level of risk.

Loan basis begins with a loan that is supported by documentation provided by the shareholder to the S corporation. This documentation includes a standard written note with a fair interest rate. Third-party loans are not included.

How Basis Is Calculated

It is important that the shareholder's basis in the S corporation be calculated accurately because it is used to determine the amount the shareholder can withdraw or receive from the company without being required to recognize income. This basis ought to mirror the shareholder's investment in the corporation.

It can be helpful to look at basis as a checking account. A deposit of income causes the basis to go up based on the shareholder's percentage of ownership. An expense causes the basis to decrease. If a shareholder gives money to the corporation, the basis goes up, and if a shareholder withdraws money, the basis goes down.

The following activities can also cause a decrease in the basis:

  • Section 179 deductions on assets
  • Penalties paid by the company
  • Non-deductible amounts of meals and entertainment

Basis begins at zero in the first year. The ending basis of that year is determined by the business activity throughout that year. The basis at the end of year one provides shareholders with a beginning basis for year two. 

Any adjustments to the basis should be made at the end of each taxable year, making sure to correctly include the following:

  • Income
  • Distributions
  • Deductions
  • Losses

Shareholders or partners can claim a deduction of company losses on their tax returns to the degree of their current basis. If the individual does not have a basis, those losses will either be suspended or carried forward to balance out future income or basis. If shareholders are uncertain of or incorrectly recorded their basis, they could unintentionally deduct inaccurate losses. 

It is important to note that credits are not limited to basis, so while shareholders cannot benefit from a loss without basis, they can take advantage of a credit. Occasionally, credits can affect basis, so it is critical that shareholders thoroughly study the rules concerning credits.

Using an S Corp Shareholder Basis Worksheet in Excel

An S corp shareholder basis worksheet Excel tool is an essential resource for accurately tracking a shareholder’s investment in the corporation. These worksheets are particularly helpful because the IRS does not calculate basis on a shareholder’s behalf, and basis is not reflected on the Schedule K-1. Therefore, it is the responsibility of each shareholder to maintain their own records using worksheets or spreadsheets, such as those in Excel.

A typical Excel worksheet should allow for the following entries:

  • Initial investment amount
  • Yearly contributions or loans to the corporation
  • Income items reported on Schedule K-1 (e.g., ordinary business income, interest, dividends)
  • Deductions and losses (e.g., Section 179, non-deductible expenses)
  • Distributions received
  • Loan repayments (if applicable)

At the end of each year, the worksheet should recalculate the ending basis by following this formula:

Beginning basis+ Income items+ Additional contributions– Deductions and losses– Distributions= Ending basis

For debt basis, the worksheet should include a separate section where the shareholder enters any direct loans made to the corporation. It's important to maintain proper documentation, including promissory notes and interest terms, to ensure IRS compliance.

Having a structured and updated worksheet not only ensures accurate tax reporting but also helps shareholders understand their ability to deduct losses and receive distributions without triggering additional taxes.

Common Errors in Tracking Basis and How to Avoid Them

Many shareholders make the mistake of assuming that the IRS or tax software automatically tracks their basis. However, failing to maintain accurate records can result in:

  • Disallowed loss deductions due to insufficient basis.
  • Overstated basis leading to improper tax-free distributions.
  • Failure to track loan repayments, which affects debt basis accuracy.

To avoid these issues:

  • Update the Excel worksheet annually when receiving the K-1.
  • Ensure all capital contributions and loans are documented.
  • Distinguish clearly between stock basis and debt basis.
  • Don’t use third-party loans to establish debt basis—only direct shareholder loans qualify.

Professional tax software or the help of a CPA can assist, but maintaining your own worksheet ensures compliance and preparedness for audits.

Frequently Asked Questions

1. What is a shareholder basis worksheet?It’s a tool used to track a shareholder's investment in an S corporation, including changes due to income, losses, contributions, and distributions.

2. Can I deduct losses if I have no basis?No. Losses can only be deducted up to the amount of your basis. Excess losses are suspended and carried forward.

3. What qualifies for debt basis in an S corp?Only direct loans from the shareholder to the S corp qualify. Third-party or guaranteed loans do not.

4. Does the IRS provide a shareholder basis worksheet?No. Shareholders are responsible for calculating and maintaining their own basis. Many use customized Excel spreadsheets.

5. Where can I find a sample Excel worksheet for S corp basis tracking?Several tax software providers and accounting firms offer downloadable templates, or you can create a custom worksheet using the IRS basis tracking formula.

If you need help with an S corporation basis worksheet, you can post your legal need on UpCounsel's marketplace. UpCounsel accepts only the top 5 percent of lawyers to its site. Lawyers on UpCounsel come from law schools such as Harvard Law and Yale Law and average 14 years of legal experience, including work with or on behalf of companies like Google, Menlo Ventures, and Airbnb.