990EZ Worksheet
|
Access this report using Reports>990 Worksheet. It is only available if the organization's functional currency is USD (US Dollar). |
Use this report to collect amounts to transfer to the IRS Form 990EZ. This report consists of 990 or 990EZ line number codes, function columns, line numbers, part numbers, account numbers, amounts, and ending balances. The report name and available columns are based on your IRS Tax Form Preference Form 990 version (Form 990EZ) selection by the Administrator on the Organization>Organization Information form.
This report does not replicate the actual IRS Form 990 or Form 990EZ. However, it does provide a simple listing of the line numbers and the amounts. When account codes are selected, a detailed report prints, including account totals. The current year amounts are separated by each account code and totaled for each 990 line number and column, where applicable.
You must have previously assigned a Form 990 Line Number to each account using the Maintain>Chart of Accounts Codes form. Otherwise, the report will not balance.
Advanced Security Users
Account Level Security is available for this report. This feature allows the Administrator to define the account codes and related amounts a user can view in the report. When account level security is activated by the Administrator for the organization (Security>Set Up Account Level Segments) and enabled for a user or group (Security>Set Up Account Level Security), the report will only print account information the user is allowed to see. Note that if a user does not have Account Level Security enabled, the user will see all account codes.
If the "Print Disclaimer on Report" check box is selected on the Security>Set Up Account Level Segments form, "This report may be affected by Account Level Security" prints in the header of this report. In that case, an * also prints after the report title.
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 and Current Transaction Dates. The Account Balances Begin date and Current Reporting Year Begins date are used to obtain the beginning balances for the Opening Balances date.
The Cross Year Reporting feature (A Year-End Close will be simulated for this report) allows reports to be run for closed years and cross years at the same time.
Use this tab to determine what data to include in the report and to define the report layout. Note that all possible columns are discussed below. Your report may not include every field identified.
- By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
- By selecting Available Columns, the data that appears in the body of the report is determined.
|
Column |
Description |
|
Line Number Code |
Displays the IRS Form 990EZ Line Number. |
|
Program Function |
Displays the program function part and column. |
|
Restriction Function |
Displays the restriction function part and line number. |
|
Line Number |
Displays the 990 line number without alphabetic characters. |
|
Part Number |
Displays the 990 part number. |
|
{Segment Name} Code |
The code assigned to the segment. The report prints the account code, such as 201, 05, or 45001. The system displays one column for each of these code types. This code must be selected in order to run a detailed report including account totals. |
|
{Segment Name} Title |
The title associated with each code above. The system displays one column for each of these code types. |
|
{Segment Name} Short Title |
The short title for the title above (15 characters or less). The system displays one column for each code types. |
|
Amount |
The total amount for the line number. |
|
Ending Balance |
These totals come from balances using the Current Transaction Dates From and Through date range. The Ending Balance only pertains to Line Numbers 27. |
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 was designated during transaction entry. |
|
Summarize Amounts |
Select this option to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together. |
|
Suppress Lines with All Zeros |
Select this option so that documents with zero amounts do not print. This eliminates records having zero in all amount columns. If it is not selected, every line prints, even if it has a zero value. |
Use this tab to change the font and page setup for a report.
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.
- To determine if all account numbers are assigned to a 990 line number, run this report with the Print Unassigned Accounts item selected on the Filter tab.
- You can separate line numbers and part numbers using this report. This allows you to sort and filter on these numbers independently. When there are multiple lines and parts, the system takes the first line and the first part. When there are sections attached to numbers, such as 1a, 1b, or 1c, the alpha letters are removed.
- The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).