990 Worksheets - Part VIII

Access this report using Reports>990 Worksheets>Part VIII. 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 include Function assignments of PGM and RES on the Segments tab.

Use this report to help when completing the Form 990 Statement of Revenue, Part VIII. The intent of the report is to mimic very closely the actual Part VIII – Statement of Revenue 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> Group Set 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:

• Twelve pre-defined rows, which cannot be changed: 1a Federated campaigns, 1b Memberships, 1c Fundraising events, 1d Related organizations, 1e Government grants (contributions), 1f All other contributions, gifts, grants, and similar amounts not included above, 1g Noncash contributions included in lines 1a-1f, 1h Total. Add lines 1a-1f, 2a Program Service Revenue, 2b Program Service Revenue, 2c Program Service Revenue, 2d Program Service Revenue, 2e Program Service Revenue, 2F All other program service revenue, 2g Total. Add lines 2a - 2f, 3 Investment income (including dividends, interest and other similar amounts), 4 Income from investment of tax-exempt bond proceeds, 5 Royalties, 6a Gross Rents, 6b Less: rental expenses, 6c Rental income or (loss), 6d Net rental income or (loss), 7a Gross amount from sales of assets other than inventory, 7b Less: cost or other basis and sales expenses, 7c Gain or (loss), 7d Net gain or (loss), 8a Gross income from fundraising events not including contributions on line 1c, 8b Less: direct expenses, 8c Net income or (loss) from fundraising events, 9a Gross income from gaming activities, 9b Less: direct expenses, 9c Net income or (loss) from gaming activities, 10a Gross sales of inventory, less returns and allowances, 10b Less: cost of goods sold, 10c Net income or (loss) from sales of inventory, 11a Miscellaneous Revenue, 11b Miscellaneous Revenue, 11c Miscellaneous Revenue, 11d All other revenue, 11e Total. Add lines 11a - 11d, 12 Total Revenue. Add lines 1h, 2g, 3, 4, 5, 6d, 7d, 8c, 9c, 10c, 11e.
• Additional columns are included to assign Business Codes to the programs listed under the Program Service Revenue and revenue lines listed under Miscellaneous Revenue (assignments can be made on the Options tab).
• Four column sections: (A) Total Revenue, (B) Related or Exempt Function Revenue, (C) Unrelated Business Revenue, and (D) Revenue Excluded from Tax under sections 512, 513, or 514.

 

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 in the Program Service Revenue section 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	Select a Program Group Set from the available drop-down list. Once a Program Group Set has been substituted, the Group Codes replace the PGM assigned segment codes and are ranked by Total Revenue in descending order. Program Group Sets were created using Reports>Assign Report Groups and selecting the {PGM type} segment.
Program Service Revenue: Program Override	By default the report will rank the PGM assigned segment codes or group codes (if a Program Group Set has been substituted) based on the Total Revenue for each, in descending order. However, you can redefine the order or even exclude certain codes from the top 5 ranking, by selecting codes from the Program Override drop-down list for each of the Line 2 items. Note that all codes not listed in the top 5 ranking will be included in Line 2f – All other program service revenue.
Program Service Revenue: Business Code	Select a business code for Lines 2a - 2e Program Service Revenue. See Codes for Unrelated Business Activity for a list of available business codes.
Miscellaneous Revenue: Business Code	Select a business code for Lines 11a - 11c Miscellaneous Revenue. See Codes for Unrelated Business Activity for a list of available business codes.

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.