Net Operating Loss Carryforward

This template is used to generate a carryforward schedule for IRC Sec. 172(b) net operating losses generated and applied and to track when the losses expire.

Entering Information

All of the information needed to produce the carryforward schedule is entered on the Input worksheet.  The yellow highlighted cells are calculated fields, and no data should be entered in these cells.  Gray cells are not calculated fields, but data should not be entered in these cells.
Use the two buttons at the top of the Input worksheet to select a carryforward schedule for a single net operating loss (NOL) or a combined schedule for multiple NOLS.

Enter the following information:

  • The tax year of the first NOL (This value is used to generate the input table.)
  • The amount of the NOL (Enter the NOL—or NOLs if the multiple loss option is selected—in the loss-generated column of the input table on the line that corresponds to the year the NOL occurred.)
  • The NOL utilized (Enter the NOLs utilized in the loss-utilized column of the input table on the line that corresponds to the year the loss is deducted for tax purposes.)
Net Operating Loss Carryforward