SMART Support Guide for Winter IPEDS 2026-2027

Creation date: 8/24/2026 9:58 AM    Updated: 10/26/2026 8:42 AM

IPEDS Winter Reporting Guide (2026-2027)

Use this guide to review, validate, and audit the OnlineSMART reports used for Winter IPEDS reporting.

Reporting Information

Reporting Opens:
December 9, 2026

Reporting Deadline:
February 10, 2027 (Keyholders)
February 24, 2027 (Coordinators)

Location:
Reports (Standard) → Annual → IPEDS → 2026-2027 → Winter


OnlineSMART Generates Data For:
  • Student Financial Aid
  • Cost Section II
  • Graduation Rates
  • 200% Graduation Rates

Important Notes
  • Admissions information must be completed outside of OnlineSMART.
  • Most schools will not utilize Outcome Measures. If required, SMART Support may be able to assist depending on individual school processes.
  • Ensure all qualifying courses have a valid CIP Code entered under:

    Administration → Courses

IPEDS Exclusions

The following students are excluded from IPEDS reporting:
  • Students enrolled in courses without a CIP Code.
  • Students who withdraw:
    • Within 4 Days of enrollment in courses under 900 Hours
    • Within 14 Days of enrollment in courses 900+ Hours
If a CIP Code is required, enter the appropriate code under:

Administration → Courses → CIP Code

If the course should not have a CIP Code, enter:

0


Student Financial Aid

What This Report Measures

The Student Financial Aid reports evaluate information entered on each student's Financial Aid tab.

These reports do not use ledger balances because students may be awarded financial aid that is never ultimately applied against their account balance.

Verification Setup
  1. Export the 07 - SFA & Cost Student List to Excel.
  2. Click inside Cell A1.
  3. Select:

    Home → Sort & Filter → Filter


01 - Financial Aid Part A

Report Purpose

This section focuses on identifying qualifying students and determining whether they received various forms of financial aid during the reporting period.

Lines 02 - 03

  • Filter Early Withdrawal (Column I) for N.

Line 05

  • Keep the filters from Lines 02-03.
  • Filter Grade Level (Column D) for First Year, Never Attended.
  • Filter Enrollment Type (Column C) for FULL.
  • If your institution considers HALF or 3/4 enrollment as Full-Time, include those values as well.
  • Filter Original Start Date (Column H) for:
    • July - December 2025
    • January - June 2026

Line 06

  • Keep the filters from Line 05.
  • Filter AY1 Title IV (Column N) to exclude 0.
  • Record the student count.
  • Clear the filter.
  • Repeat for:
    • Column O
    • Column P
    • Column Q
    • Column R
    • Column S
    • Column T
    • Column U
  • Add the counts together to determine the Line 06 total.
Important

Students appearing in multiple Title IV columns will be counted more than once.

Review and remove duplicate students before calculating the final total.

SMART Support can provide assistance with identifying and removing duplicate records.


Line 07

  • Keep the filters from Line 05.
  • Filter the following columns individually to exclude 0:
    • Column N
    • Column O
    • Column P
    • Column R
  • Record the student count from each column.
  • Add the counts together to determine the Line 07 total.
Important

Students appearing in multiple aid columns will be counted more than once.

Review and remove duplicate students before calculating the final total.

SMART Support can provide assistance with identifying and removing duplicate records.


02 - Financial Aid Part BCD

Before You Begin

Generate a new 07 - SFA & Cost Student List or clear all filters from the worksheet used for Part A.

Line 01 - Grant and Scholarship Aid from the Federal Government, State/Local Government, or the Institution

  • Filter Total Grants or Scholarship Aid (Column AI) to exclude 0.
  • The remaining student count equals Number of Students Awarded Aid.
  • The sum of Column AI equals Total Amount Awarded.

Line 01a - Federal, State/Local, and Institutional Grants or Scholarships

  • Clear all filters.
  • Filter PELL (Column X) to exclude 0.
  • Record:
    • Student Count
    • Total Dollars Awarded
  • Repeat for:
    • Column Y
    • Column AC
    • Column AD
    • Column AE
Important

Students appearing in multiple aid columns will be counted more than once.

Remove duplicate students when calculating the total student count.

Dollar amounts should not be de-duplicated.


Line 01b - Grants and Scholarships from Other Sources

  • Clear all filters.
  • Filter Agencies (Column S) to exclude 0.
  • Record:
    • Student Count
    • Total Dollars Awarded
  • Repeat for:
    • Column T
    • Column U
Important

Students appearing in multiple aid columns will be counted more than once.

Remove duplicate students when calculating the total student count.

Dollar amounts should not be de-duplicated.


Line 02 - Federal Grants and Scholarship Aid

  • Filter PELL (Column X) to exclude 0.
  • Record student count and total dollars awarded.
  • Repeat for:
    • Column Y
    • Column AC
Important

Students appearing in multiple aid columns will be counted more than once.

Remove duplicate students when calculating the total student count.

Dollar amounts should not be de-duplicated.


Line 02a - Federal Pell Grants

  • Clear all filters.
  • Filter Pell Total (Column X) to exclude 0.
  • The remaining student count equals Number of Students Awarded Aid.
  • The column total equals Total Amount Awarded.

Line 02b - Other Federal Grants and Scholarship Aid

  • Filter FSEOG (Column Y) to exclude 0.
  • Repeat for:
    • Column AD
Important

Students appearing in multiple aid columns will be counted more than once.

Remove duplicate students when calculating the total student count.

Dollar amounts should not be de-duplicated.


Line 03 - State / Local Government Grant or Scholarship Aid

  • Clear all filters.
  • Filter State / Local Grants (Column AC) to exclude 0.
  • The remaining student count equals Number of Students Awarded Aid.
  • The column total equals Total Amount Awarded.

Line 04 - Institutional Grant or Scholarship Aid

  • Clear all filters.
  • Filter Institutional Scholarship (Column AE) to exclude 0.
  • The remaining student count equals Number of Students Awarded Aid.
  • The column total equals Total Amount Awarded.

Line 05 - Loans to Students

  • Clear all filters.
  • Filter Title IV Loans (Column Z) to exclude 0.
  • Repeat for:
    • Column AB
Important

Students appearing in multiple loan columns will be counted more than once.

Remove duplicate students when calculating the total student count.

Dollar amounts should not be de-duplicated.


Line 05a - Federal Loans to Students

  • Filter Title IV Loans (Column Z) to exclude 0.
  • The remaining student count equals Number of Students Awarded Aid.
  • The column total equals Total Amount Awarded.

Line 05b - Other Loans to Students (Including Private Loans)

  • Filter AY1 Private Loans (Column AB) to exclude 0.
  • The remaining student count equals Number of Students Awarded Aid.
  • The column total equals Total Amount Awarded.


03 - Financial Aid Part E

Before You Begin

Generate a new 07 - SFA & Cost Student List or clear all filters from the worksheet used previously.

This section only reviews First-Time, Full-Time (FTFT) students.

Apply the following filters before completing any verification steps below:
  • Grade Level (Column D) = First Year, Never Attended
  • Enrollment Type (Column C) = FULL
    • If your institution considers HALF or 3/4 enrollment as Full-Time, include those values as well.
  • Original Start Date (Column H)
    • July - December 2025
    • January - June 2026

Line 01 - Grant and Scholarship Aid from the Federal Government, State / Local Government, or the Institution

  • Filter AY1 Total Grants or Scholarships Aid (Column V) to exclude 0.
  • The remaining student count equals Number of Students Awarded Aid.
  • The sum of Column V equals Total Amount Awarded.

Line 01a - Grants or Scholarships from Federal, State / Local Government, or the Institution

  • Clear all filters except the standard FTFT filters listed above.
  • Filter AY1 Pell (Column K) to exclude 0.
  • Record:
    • Student Count
    • Total Dollars Awarded
  • Repeat for:
    • Column L
    • Column P
    • Column Q
    • Column R
Important

Students appearing in multiple aid columns will be counted more than once.

Remove duplicate students when calculating student counts.

Dollar amounts should not be de-duplicated.


Line 01b - Grants and Scholarship Aid from Other Sources

  • Clear all filters except the standard FTFT filters.
  • Filter AY1 Agencies (Column S) to exclude 0.
  • Record:
    • Student Count
    • Total Dollars Awarded
  • Repeat for:
    • Column T
    • Column U
Important

Students appearing in multiple aid columns will be counted more than once.

Remove duplicate students when calculating student counts.

Dollar amounts should not be de-duplicated.


Line 02 - Federal Grants and Scholarship Aid

  • Filter AY1 Pell (Column K) to exclude 0.
  • Repeat for:
    • Column L
    • Column P
  • Add the counts together to determine the total.
Important

Students appearing in multiple aid columns will be counted more than once.

Remove duplicate students when calculating student counts.

Dollar amounts should not be de-duplicated.


Line 02a - Federal Pell Grants

  • Clear filters from previous steps.
  • Filter AY1 Pell Total (Column K) to exclude 0.
  • The remaining student count equals Number of Students Awarded Aid.
  • The column total equals Total Amount Awarded.

Line 02b - Other Federal Grants and Scholarship Aid

  • Filter AY1 FSEOG (Column L) to exclude 0.
  • Repeat for:
    • Column Q
Important

Students appearing in multiple aid columns will be counted more than once.

Remove duplicate students when calculating student counts.

Dollar amounts should not be de-duplicated.


Line 03 - State / Local Government Grant or Scholarship Aid

  • Clear filters from previous steps.
  • Filter AY1 State / Local Grants (Column P) to exclude 0.
  • The remaining student count equals Number of Students Awarded Aid.
  • The column total equals Total Amount Awarded.

Line 04 - Institutional Grant or Scholarship Aid

  • Clear filters from previous steps.
  • Filter AY1 Institutional Scholarship (Column R) to exclude 0.
  • The remaining student count equals Number of Students Awarded Aid.
  • The column total equals Total Amount Awarded.

Line 05 - Loans to Students

  • Clear filters from previous steps.
  • Filter AY1 Title IV Loans (Column M) to exclude 0.
  • Repeat for:
    • Column O
Important

Students appearing in multiple loan columns will be counted more than once.

Remove duplicate students when calculating student counts.

Dollar amounts should not be de-duplicated.


Line 05a - Federal Loans to Students

  • Filter AY1 Title IV Loans (Column M) to exclude 0.
  • The remaining student count equals Number of Students Awarded Aid.
  • The column total equals Total Amount Awarded.

Line 05b - Other Loans to Students (Including Private Loans)

  • Filter AY1 Private Loans (Column O) to exclude 0.
  • The remaining student count equals Number of Students Awarded Aid.
  • The column total equals Total Amount Awarded.


Cost Section II

What This Report Measures

Cost Section II focuses on First-Time, Full-Time (FTFT) students enrolled in the program with the highest enrollment during the reporting period.

Verification Setup
  1. Export the 07 - SFA & Cost Student List to Excel.
  2. Click inside Cell A1.
  3. Select:

    Home → Sort & Filter → Filter

Base Filters

Apply the following filters before completing any Cost Section II verification:

  • Enrollment Type (Column C) = FULL
    • If your institution considers HALF or 3/4 enrollment as Full-Time, include those values as well.
  • Grade Level (Column D) = First Year, Never Attended
  • Course (Column E) = Program with the highest enrollment
  • Original Start Date (Column H)
    • July - December 2025
    • January - June 2026
Note

These filters serve as the default starting point for Parts A, B, and C.


04 - Cost Section II Part A

Line 01

  • Use the Base Filters only.
  • The resulting student count equals the value for Line 01.

Line 02

  • Filter AY1 Pell (Column K) to exclude 0 and record the count.
  • Repeat for:
    • Column L
    • Column P
    • Column Q
    • Column R
  • Add the counts together.
Important

Students appearing in multiple aid columns will be counted more than once.

Remove duplicate students before calculating the final total.

Line 03

  • Clear filters from Line 02.
  • Filter AY1 Title IV (Column N) to exclude 0.
  • The remaining student count equals the value for Line 03.


05 - Cost Section II Part B

Additional Filter

Along with the Base Filters, exclude 0 from:

AY1 Grant & Scholarship Aid (Fed / State / Inst) (Column W)

Line 02

  • Filter Housing Plan (Column G) for On-Campus.
Note

Most schools will report zero students in this category.

Line 03

  • Clear Line 02 filters.
  • Filter Housing Plan (Column G) for Off-Campus (With Family).

Line 04

  • Clear Line 03 filters.
  • Filter Housing Plan (Column G) for Off-Campus (Not With Family).

Line 06

  • Clear Line 04 filters.
  • The total for Line 06 equals the sum of all values in:

    AY1 Grant & Scholarship Aid (Fed / State / Inst) (Column W)


06 - Cost Section II Part C

Additional Filter

Along with the Base Filters, exclude 0 from:

AY1 Title IV (Column N)

Line 02

  • Filter Housing Plan (Column G) for On-Campus.
Note

Most schools will report zero students in this category.

Line 03

  • Clear Line 02 filters.
  • Filter Housing Plan (Column G) for Off-Campus (With Family).

Line 04

  • Clear Line 03 filters.
  • Filter Housing Plan (Column G) for Off-Campus (Not With Family).

Line 06

  • Clear Line 04 filters.
  • The total for Line 06 equals the sum of all values in:

    AY1 Title IV (Column N)


Graduation Rates

What This Report Measures

Graduation Rates reports analyze Full-Time, First-Time students who originally started a course with a valid CIP Code during:

September 1, 2023 - August 31, 2024

Students are categorized based on:
  • Race
  • Gender
  • Graduation Status
  • Transfer Status
  • Special Exclusions

Verification Setup
  1. Export the 13 - Graduation Rates List of Students to Excel.
  2. Click inside Cell A1.
  3. Select:

    Home → Sort & Filter → Filter
  4. Apply:
    • Enrollment Type (Column G) = FULL
    • Grade Level (Column H) = First Year, Never Attended

Required Student Information
  • Sex
  • Race
  • Enrollment Type
  • Grade Level
Verify these fields are not blank on the Graduation Rates Student List.


08 - Graduation Rates - Screen 1

Column 1

  • Filter by Sex (Column E) and Race (Column F) as needed.


09 - Graduation Rates - Screen 2

Column 11

  • Filter Course Hours (Column D) for 1800 hours or less.
  • Filter Sex (Column E) and Race (Column F).
  • Filter students with a Graduation Date (Column J).
  • Filter Grad Within 150% (Column W) = Y.

Column 12

  • Filter Course Hours (Column D) for 1801 hours or greater.
  • Filter Sex (Column E) and Race (Column F).
  • Filter students with a Graduation Date (Column J).
  • Filter Grad Within 150% (Column W) = Y.
Calculation

Column 29 = Column 11 + Column 12


10 - Graduation Rates - Screen 3

Column 30

  • Filter by Sex (Column E) and Race (Column F).
  • Filter students with a Graduation Date (Column J).
  • Filter Drop Description for:
    • Transfer to another school

Column 45

  • Filter by Sex (Column E) and Race (Column F).
  • Filter students with a Graduation Date (Column J).
  • Filter Drop Description for:
    • *Deceased
    • *Permanently Disabled
    • *Active Duty Armed Forces
    • *Official Church Mission
    • *Fed Govt Serv Foreign Aid

Column 51

  • Filter by Sex (Column E) and Race (Column F).
  • Filter students with a Graduation Date (Column J).
  • Filter Grad Within 150% (Column W) = Y.


11 - Graduation Rates - Screen 4

Column 55

  • Filter Course Hours (Column D) for 1800 hours or less.
  • Filter Sex (Column E) and Race (Column F).
  • Filter students with a Graduation Date (Column J).
  • Filter Grad Within 150% (Column W) = Y.

Column 56

  • Filter Course Hours (Column D) for 1801 hours or greater.
  • Filter Sex (Column E) and Race (Column F).
  • Filter students with a Graduation Date (Column J).
  • Filter Grad Within 150% (Column W) = Y.
Calculation

Column 57 = Column 55 + Column 56


12 - Graduation Rates - Screen 2 or 5

What This Report Measures

This report separates students into the following categories:
  • Recipients of a Pell Grant
  • Recipients of a Subsidized Stafford Loan who did not receive a Pell Grant
  • Students who received neither a Pell Grant nor a Subsidized Stafford Loan

Column 10

Recipients of a Pell Grant

  • Filter Pell (Column T) = Y
Note

This count may be larger than the value shown on the IPEDS report because Screen 2 or 5 only considers students who received Pell during Pay Periods 11 or 12, while the student list reflects all Pell recipients.

Recipients of a Subsidized Stafford Loan Without Pell

  • Filter Pell (Column T) = N
  • Filter Title IV Loans (Column U) = Y

Received Neither Pell nor Title IV Loans

  • Filter Pell (Column T) = N
  • Filter Title IV Loans (Column U) = N


Column 45

Apply the appropriate Pell / Loan filters above, then additionally filter:

  • Drop Description contains:
    • *Deceased
    • *Permanently Disabled
    • *Active Duty Armed Forces
    • *Official Church Mission
    • *Fed Govt Serv Foreign Aid


Column 29 or 11

Apply the appropriate Pell / Loan filters above, then additionally filter:

  • Students with a Graduation Date (Column J)
  • Grad Within 150% (Column W) = Y


For Less-Than-2-Year Institutions

Important

Less-Than-2-Year institutions only complete two IPEDS Graduation Rate screens.

Print all five OnlineSMART Graduation Rate reports and use the chart below to determine which report corresponds with each IPEDS field.

Column 10 in IPEDS is the same data as Screen 1, Column 1.

IPEDS Data Column 10 Column 45 Column 11 Column 55 Column 30 Column 51
SMART Report Screen 1 (Column 1) Screen 3 Screen 2 Screen 4 Screen 3 Screen 3

Note

When you reach IPEDS Graduation Rates - Screen 2 of 2, run the 12 - Graduation Rates Screen 2 or 5 report in OnlineSMART. The values from this report directly correspond to the fields requested by IPEDS.

If you need assistance interpreting these sections, please contact SMART Support.


200% Graduation Rates

What This Report Measures

This report reviews Full-Time, First-Time students who originally started a course with a valid CIP Code between:

September 1, 2022 - August 31, 2023

Students are categorized based on whether they:
  • Graduated between 151% and 200% of normal completion time
  • Remain actively enrolled at 200% of normal completion time
  • Qualify for additional exclusions

Verification Setup
  1. Export the 15 - 200% Graduation Rates List of Students to Excel.
  2. Click inside Cell A1.
  3. Select:

    Home → Sort & Filter → Filter

Required Student Information
  • Enrollment Type
  • Grade Level
  • Original Start Date
Verify these fields are not blank before validating report totals.

Base Filters

Apply the following filters before validating any section of the report:

  • Enrollment Type (Column D) = FULL
  • Grade Level (Column E) = First Year, Never Attended


06 - Additional Exclusions (151% - 200% of Normal Time)

  • Apply the Base Filters.
  • Filter Additional Exclusions (Column Q) = Y.


08 - Completed Between 151% - 200% of Normal Time

  • Apply the Base Filters.
  • Filter 151-200% Completer (Column R) = Y.


09 - Still Enrolled at 200% of Normal Time

  • Apply the Base Filters.
  • Filter Still Enrolled at 200% (Column S) = Y.


Need Assistance?

SMART Support is available to assist with IPEDS reporting questions during normal business hours.

Phone: (480) 744-0050
Hours: Monday - Friday, 7:00 AM - 3:30 PM MST

Email: Support@OnlineSMART.net