990 Worksheets - Part X

Access this report using Reports>990 Worksheets>Part X. 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 Balance Sheet, Part X. The intent of the report is to mimic very closely the actual Part X – Balance Sheet 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 X> 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:

Three sections containing 34 pre-defined rows, which cannot be changed:

• Assets: 1 Cash - non-interest bearing, 2 Savings and temporary cash inventories, 3 Pledges and grants receivable, net, 4 Accounts receivable, net, 5 Receivables from current and former officers, directors, trustees, key employees or other related parties, 6 Receivables from other disqualified persons, 7 Notes and loans receivable, net, 8 Inventories for sale or use, 9 Prepaid expenses and deferred charges, 10a Land, buildings, and equipment: cost basis, 10b Less accumulated depreciation, 10c Net land, buildings, and equipment, 11 Investments - publicly traded securities, 12 Investments - other securities, 13 Investments - program-related, 14 Intangible assets, 15 Other assets, 16 Total assets. Add lines 1 through 15 (must equal line 34),
• Liabilities: 17 Accounts payable and accrued expenses, 18 Grants payable, 19 Deferred revenue, 20 Tax-exempt bond liabilities, 21 Escrow account liability, 22 Payable to officers, directors, trustees, key employees, highest paid employees and disqualified persons, 23 Secured mortgages and notes payable to unrelated third parties, 24 Unsecured notes and loans payable, 25 Other liabilities, 26 Total liabilities. Add lines 17 through 25,
• Net Assets or Fund Balances:

  • ASC 958 (SFAS 117 superseded) Organizations - line 27-29, 33, and 34 apply: 27 Unrestricted net assets, 28 Temporarily restricted net assets, 29 Permanently restricted net assets. As of December 15, 2017, ASC 958 modified or eliminated the distinctions between temporarily restricted and permanently restricted assets. All funds without donor-imposed restrictions must be classified as unrestricted, regardless of the existence of any board designations or appropriations. Line 28, Temporarily Restricted Net Assets, can be used to show the balance per books of net assets with donor-imposed restrictions that may require resources to be used after a specified date (time restrictions), or used for a specified purpose (purpose restrictions), or both. Organizations may also opt to leave Line 28 blank and report all net assets subject to donor-imposed restrictions on Line 29.

  • ASC 958 (Non-SFAS 117 superseded) Organizations - line 30-34 apply: 30 Capital stock or trust principal, or current funds, 31 Paid-in or capital surplus, or land, building, or equipment fund, 32 Retained Earnings, endowment, accumulate income, or other fundsNon-SFAS 117 Organizations - line 30-34 apply: 30 Capital stock or trust principal, or current funds, 31 Paid-in or capital surplus, or land, building, or equipment fund, 32 Retained Earnings, endowment, accumulate income, or other funds
  • 33 Total net assets or fund balances, 34 Total liabilities and net assets/fund balances.

Two column sections: (A) Beginning of Year and (B) End of Year.

 

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.
Rounding	Select this option to round the amounts to the nearest whole number when printing the report. Select "None" to not round the amounts.

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.