1098-T Cleanup Tool - Best Practices
As part of best practices, we recommend the following steps when using the 1098-T Cleanup Tool. These steps guide you through the iterative process of filtering records based on specific criteria.
-
Select the Campus(es).
-
In the Fund Sources field, click the search icon (). In the Select Fund Sources popup, click Show Filter Row, select Yes for fund sources Configured as Scholarships or Grants, and select the fund source Names to be included in the 1098-T.
-
The values for the Transaction Date range will be based on the volume of records at your institution. For previous years, you could specify the whole reporting year, but for the current tax year you may want to limit the Transaction Date range by month or quarter.
-
Click Next. Once the records are displayed in the Results grid, click the Include All Scholarships/Grants/Qualified Expenses button in the grid toolbar.
-
Click the Identify Prior Year Refunds button in the grid toolbar.
-
Scroll to the Terms column and specify a filter for the Terms you want to include and to determine prior year refund transactions.
-
Scroll to the Amount column and filter the amounts by less than 0 and description for Title IV fund sources to determine if any refunds should be marked as multiple payments.
-
Scroll to the bottom of the page and click Save.
-
Return to the Selection Criteria section of the page.
In the Fund Sources field, click the search icon (). In the Select Fund Sources popup, click Show Filter Row, select No for fund sources Configured as Scholarships or Grants, and select the fund source Names to be included in the 1098-T.
-
The values for the Transaction Date range will be based on the volume of records at your institution. For previous years, you could specify the whole reporting year, but for the current tax year you may want to limit the Transaction Date range by month or quarter.
-
Click Next. Once the records are displayed in the Results grid, click the Clear All Scholarships/Grants/Qualified Expenses button in the grid toolbar.
-
Scroll to the bottom of the page and click Save.
-
Return to the Selection Criteria section of the page.
If your institution has HEERF or CARES fund sources, in the Fund Sources field and click search icon () and select just the CARES and HEERF fund source Names.
-
In the Transaction Date range fields, specify the full year.
-
Click Next. Once the records are displayed in the Results grid, select the check box in the Emergency Grant Box 1 column for the appropriate records. If all of them should be marked, click Select All Emergency Grant Box 1 in the grid toolbar.
-
Scroll to the bottom of the page and click Save.
-
Return to the Selection Criteria section of the page.
In the Transaction Codes field, click the search icon (). In the Select Transaction Code popup, click Show Filter Row, select Yes for transaction codes Configured as Qualified Expenses, and select the transaction code Names to be included in the 1098-T.
-
The values for the Transaction Date range will be based on the volume of records at your institution. For previous years, you could specify the whole reporting year, but for the current tax year you may want to limit the Transaction Date range by month or quarter.
-
Click Next. Once the records are displayed in the Results grid, click the Include All Scholarships/Grants/Qualified Expenses button in the grid toolbar.
-
Scroll to the Terms column and specify a filter for the Terms you want to include and to determine prior year refund transactions.
-
Scroll to the Amount column and filter the amounts by less than 0 to determine if any refunds should be marked as multiple payments.
-
Scroll to the bottom of the page and click Save.
-
Return to the Selection Criteria section of the page.
In the Transaction Codes field, click the search icon (). In the Select Transaction Code popup, click Show Filter Row, select No for transaction codes Configured as Qualified Expenses, and select the transaction code Names to be included in the 1098-T.
-
The values for the Transaction Date range will be based on the volume of records at your institution. For previous years, you could specify the whole reporting year, but for the current tax year you may want to limit the Transaction Date range by month or quarter.
-
Click Next. Once the records are displayed in the Results grid, click the Clear All Scholarships/Grants/Qualified Expenses button in the grid toolbar.
-
Scroll to the bottom of the page and click Save.