990 Worksheets - Part I

Access this report using Reports>990 Worksheets>Part I. It is only available if the Form 990 was selected by the Administrator and the organization's functional currency is USD (US Dollar) on Organization>Organization Information>Organization tab and you must have at least three named segments which includes Function assignments of PGM and RES on the Segments tab.

Use this report to help when completing the Form 990 Summary, Part I. The intent of the report is to mimic very closely the actual Part I – Summary section of the Form 990 Return of Organizations Exempt From Income Tax. This is a fixed report which prints in a letter-portrait format with margins set to .25. You cannot customize the columns in the report; the system has already determined them.

You must have previously assigned a Form 990 Line Number to each account. The primary way of assigning Form 990 Line numbers is using the Reports>Assign Report Groups form for the <990 Part VIII>, <990 Part IX>, and <990 Part X> Group Sets or you can make assignments using the Maintain>Chart of Accounts Codes form.

Also, select the Include GL Details check box on the Options tab to include account codes and account totals on the report.

The report consists of:

• Sixteen pre-defined rows, which cannot be changed: 8 Contributions and grants, 9 Program service revenue, 10 Investment Income, 11 Other revenue, 12 Total revenue, 13 Grants and similar amounts paid, 14 Benefits paid to or for members, 15 Salaries, other compensation, employee benefits, 16a Professional fundraising fees, 16b Total fundraising expenses, 17 Other expenses, 18 Total expenses, 19 Revenues less expenses, 20 Total assets, 21 Total liabilities, and 22 Net assets or fund balances.
• Two column sections: the Prior Year/ Current Year section (which includes the Revenue and Expenses) prints to the right of the statement, and the Beginning of Year/End of Year section (which includes the Net Assets or Fund Balances) also prints to the right of the statement. (After Revenue and Expenses, the report totals the Net Assets.)

 

Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.

Specify the date range for the data included in the report by entering Balances Dates. The Account Balances Begin date and Current Reporting Year Begins date are used to obtain the beginning balances for the Opening Balances date. Additionally, Current Period Dates are also required to specify the reporting period for this report.

The Cross Year Reporting feature (A Year-End Close will be simulated for this report) allows reports to be processed for closed years and cross-years at the same time. It allows the current fiscal year's reports to be accurate when the prior year is still open.

Note: The period of time between the Current Reporting Year Begins Date and the Ending Balance Date cannot exceed one year. Also, the Opening Balances Date should always match the Current Reporting Year for this report.

Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.

Use this tab to set up any Available Options for the report.

Options	Description
Year End Adjustments	Select this option to include year-end adjustments on the report. This entry type (A Year End Adjustments) was designated during transaction entry. The entry is posted to the last day of the fiscal year. It allows the user to make year-end adjustments and print reports including or excluding an adjustment.
Include GL Details	Select this option to print, in ascending order, the GL codes and their titles that have been assigned to each of the 990 Line Numbers. The amounts, for each line, display in their respective columns to the right and totals follow below the last row of detail. Note that when Substitute Program Group Set is selected, the Group Code and their PGM assigned segment codes display instead of the GL codes and their titles.
Rounding	Select this option to round the amounts to the nearest whole number when printing the report. Select "None" to not round the amounts.
Program Service Revenue: Substitute Program Group Set	If a Program Group Set was selected in the 990 Worksheet Part VIII, select it here in order to use the same program groups when calculating the Total Revenue. Also select the Include GL Details check box to display the GL Codes and their titles. Program Group Sets were created using Reports>Assign Report Groups and selecting the {PGM type} segment.

Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be deselected by any user other than the user that locked the report.