Analyzing 1098-T Data

Before finalizing and sending your 1098-T forms, make sure all your data is accurate and up to date. Use the audit reports and the 1098-T.pbl from MyJenzabar.net to analyze and correct your data.

Included Transactions Report Messages

Message

This ID also has transactions identified for exclusion. Please refer to the Excluded Transactions Audit report for details.

This student will be excluded from the process unless Include students with tuition less than scholarships and grants is selected.

Excluded Transactions Report Messages
Message	Note
No Payments/Charges Exist with a Matching Year/Term	All transactions for the date range that do not have a year and term with a matching payment or charge
Transactions Do Not Include Charge Year and Term	All transactions in gf1098ttransexcluded view (@C, @F and FC excluded) without a year and term
Transactions Do Not Include Charge Term	All transactions in gf1098ttransexcluded view (@C, @F and FC excluded) without a year but has a term
Transactions Do Not Include Charge Year	All transactions in gf1098ttransexcluded view (@C, @F and FC excluded) without a term but has a year
Fund Code Apply to 1098-T Not Flagged on Fund Master (Not Eligible for Box 1)	Source Code in 'FA', 'LO', 'LN', 'LD' with elig_1098T flag in 'P', 'G', 'B' and apply to 1098t eligible charges <> 'Y'
Fund Code Apply to 1098-T Flagged but Transaction Missing Eligible 1098-T Flag of P or G	Source Code in 'FA', 'LO', 'LN', 'LD' without elig_1098T flag in 'P', 'G', 'B' and apply to 1098t eligible charges = 'Y'
Unposted Transactions	All transactions in gf1098ttransexcluded view with a subsid_trans_sts of 'U'
Suspended Transactions	All transactions in gf1098ttransexcluded view with a subsid_trans_sts of 'S'
1098-T flag of N indicates transaction will be Excluded	All transactions in gf1098ttransexcluded view with a 1098-T flag of 'N'
Contains Invalid 1098-T flag	All transactions in gf1098ttransexcluded view without a 1098-T flag of NULL, Blank, N, C, G, P or B OR source_cde = CG or @C with a 1098-T flag of null
Issues with Registration Year Term Table	Does not exist in Registration Year and Term Definition
Year/Terms with missing start/end dates	Transactions with a Year and Term that is missing a Start and/or End date on the Year Term Subterm Definition
Warnings exist for name and address	First name is missing Address Line 1 is missing State is missing City is missing Zip Code is missing
ERROR No SSN exists	ID listed that does not have a SSN on the Biograph Master

Downloading the 1098-T.pbl

Jenzabar recommends using the audit reports in conjunction with the forms available in the 1098t.pbl file downloadable from MyJenzabar.net to evaluate and correct transaction history data:

Correcting 1098-T Errors

The audit reports can be generated as frequently as necessary. Once you have one or more of these reports, use one of the forms (depending on the source code associated with the transaction) from the 1098-T.pbl to modify the transaction history data.

In the BEGIN_DATE and END_DATE columns, enter the appropriate beginning and ending dates.

The Begin and End Date refer to 1098-T calendar years. In order to determine prior, current, and future year designations for each transaction, the corresponding term begin date from the year/term table is used as illustrated below:

· Prior Year: Transactions with registration periods prior to January 1 of the current 1098-T calendar year

· Future Year: Transactions with registration periods after December 1 of the current 1098-T calendar year

You must verify that the term begin dates are configured properly on the year/term table.

Each transaction on the audit reports has a Source Code. The table below lists the Source Code-Form associations:

Source Code	Form
RC	Receipt Edit
FA	Finaid Edit
CG or MS	Charge Edit
All others	Other Edit

Depending on the transactions that need modification, open the appropriate form to access the Specify Retrieval Arguments window.
Enter the values and click OK. The transaction you identified appears.
Make the necessary data corrections.
Click the Save button. The transaction history is updated.

Re-Generate 1098-Ts

After the errors have been corrected, repeat the steps to generate your 1098-Ts until no errors are produced. If additional warnings exist, a Post Process Warning Report appears. This is another step to verify the accuracy of your data. Resolve these warnings and then generate your final 1098-Ts.

Analyze and Correct 1098-T Data