Reviewing Accounts, Recipients and Sales
Creating Custom 990 Registers
Many of the account, recipient and sales fields that you need to review at the account level are also available for adding as columns to custom 990 registers. Adding these columns allows you to complete your review at the register level rather than accessing the account binder for each account. For example, you can:
- Add theForm 990 return type,Form 990 PF return type,Form 990 EZ return type,Form 990 N return typeandForm 990 T return typecolumns to review the 990 return type(s) for your 990 accounts. These columns are in theAccount Master Informationcategory on the Register Properties page.
- Add theRecipient's Relationship to Substantial Contributor,Foundation Status of Recipient and Purpose of Grant,Allocation or Contributioncolumns to a recipient-type custom register to review the grant, allocation and contribution information for the recipients listed on your 990 accounts. These columns are in the990 Specific Recipient Infocategory on the Register Properties page.
- Add the990 Category Code (all return types),990-PF Acquisition Methodand990-PF Property Typecolumns to a sales-type custom register to review the 990-specific sales fields. These columns are in theSales General Informationcategory on the Register Properties page.
- Add theLocal process dual 1041 & 990 returncolumn to set the dual processing flag for Section 4947(a)(1) trusts that require both 1041 and 990 return reporting. This column is in theAccount Tape Lock-Out Signalscategory on the Register Properties page.
Reviewing the Entity Type and 990 Return Types to Generate for a 990 Account
ONESOURCE Trust Tax considers a 990 account a separate entity type. The entity type can be set when the account is created in ONESOURCE Trust Tax or it can be included in the data that is bridged to your ONESOURCE Trust Tax database. You can use the
Account
collapsible section on the Account Information page to review the entity type and select the 990 return types that should be generated for a 990 account.note
The Account record in the Generic bridge includes the Account Type (Filing Status) and 990-T indicator fields. For accounts where Form 990-PF applies, the filing status can be reviewed from the
Type of organization
drop-down list under the General Information
collapsible section on the Form 990-PF page.The codes and descriptions for the Account Type (Filing Status) and 990-T indicator fields include:
Field | Code | Description |
|---|---|---|
Account Type (Filing Status) | 60 | 990 |
61 | 990-EZ | |
62 | 990-PF Non-operating foundation | |
63 | 990-PF operating foundation-I.R.C. Section 4942(j)(3) | |
64 | 990-PF operating foundation-I.R.C. Section 4942(j)(5) | |
65 | 990-N e-postcard for 990 or 990-EZ filer not meeting the filing threshold | |
990-T indicator | 0 | N/A |
1 | 501(c) trust | |
2 | 401(a) trust | |
3 | 501(c) corporation | |
4 | Other trust |
To review the entity type and the 990 return types that should be generated for a 990 account:
- Open the 990 account.
- Under theAccountcollapsible section on the Account Information page, review theType of Entitydrop-down list.990should be displayed. If990is not displayed, be sure to select it from the list. Otherwise, the entity type for the account will be incorrect.
- Review the check boxes in the990 Return Typesbox. If a check box is selected, the corresponding return will be generated. If a check box is not selected, the corresponding return will not be generated.
- The graphic below shows where theType of Entitydrop-down list and990 Return Typesbox is located. Notice that 990 is the entity type and that a Form 990 will be generated for the account.
- SelectSaveif you made changes.
Setting the Dual Processing Flag for Accounts Requiring 990 and 1041 Return Reporting
Beginning with tax year 2021, accounts that require dual return processing (Section 4947(a)(1) trusts that require both 1041 and 990 return reporting) can be processed, tracked and e-filed separately. For these accounts, the dual return processing flag must be set before processing.
note
You can set the dual processing flag from a custom register that has the
Local process dual 1041 & 990 return
column added to it. This column is in Account Tape Lock-Out Signals
category in the first grid under the Detail Columns
collapsible section on the Register Properties page.To set the dual processing flag in the account binder:
- Open the 990 account that requires dual return processing.
- Under theAccountcollapsible section on the Account Information page, select theThis trust files both a 1041 and a 990 (Section 4947(a)(1) trusts)check box.
- SelectSave.
- Now, you can review theType of Entitydrop-down list to ensure990is displayed, and review the check boxes in the990 Return Typesbox to ensure the applicable 990 return type will be generated. When you are ready to switch from the 990 return type to the 1041 return, selectSwitch to 1041from theAccount Actiondrop-down list.
- The Account Information page is refreshed after you selectSwitch to 1041. On the Account Information page, theThis trust files both a 1041 and 990check box shows as selected,Complex ($100)displays in theType of Entitydrop-down list, and the applicable 990 return type check box is selected but shows as unavailable for clearing.
- When the entity type isComplex ($100), ONESOURCE Trust Tax functions the same as with any complex trust return type. Likewise, when the entity type is990, ONESOURCE Trust Tax functions the same as with any 990 return type.
- If you want to switch from the 1041 return back to the 990 return type, selectSwitch to 990from theAccount Actiondrop-down list. After switching back to the 990 return type, the applicable 990 form page in theTax Review-990main topic displays.
Creating a Combined Account for Generating a Group Return on Form 990
Organizations that are exempt under a group exemption letter are allowed to file a group return on Form 990. ONESOURCE Trust Tax facilitates generating group returns by allowing you to create combined accounts. A combined account has one account identified as the parent account (for the central organization), and one or more child accounts (for the subordinate organizations) associated with the parent account. Throughout the year, the tax data for each child account is managed. When it is time, the tax return for the parent account is processed to generate the group return.
note
Prior to the 22.05 release of ONESOURCE Trust Tax, when a combined account was created, modified or removed, the association applied to all tax years. If the association was removed in a certain tax year, it was removed for all years. Beginning with the 22.05 release, when an association is added, it applies to the current tax year and will carry forward, but the association will not apply to prior years. If an association is removed, the change applies to the logged in tax year and carries forward but does not apply to prior years.
To create a combined account for generating a group return on Form 990:
- Identify the parent account for the central organization. To identify the parent account:
- Open the parent account.
- Under theRelated Accountscollapsible section on the Account Information page, select theNeeds Related Account Processingcheck box. Notice that theCombined: Main Accountoption is selected by default.
- SelectSave.
- Associate the child accounts for the subordinate organizations. To associate a child account:
- Open the child account.
- Under theRelated Accountscollapsible section, select theNeeds Related Account Processingcheck box.
- Select theCombined: Sub Account ofoption then enter the account number of the parent account in the associated field.
- SelectSave.
- Repeat steps 2a through 2d for each subordinate organization. The Combined Accounts page allows you to review the account relationships for a combined account, access each child account, and remove a relationship if an account was associated in error. To access the Combined Accounts page from the parent or a child account, selectAccountthenRelated Accountsin the topic list panel. To access a child account from the Combined Accounts page, select the link in theAccountfield for the child account. To remove a relationship, select
for the child account then select Save.
Entering 990 Ratio Amounts
990 ratio amounts allow you to report less than 100 percent of the taxable amount for a revenue or expense item in a specific column on Form 990. The task of entering 990 ratio amounts is similar to entering 990-PF ratio amounts. The differences include:
- 990 ratio amounts are available only at the account level.
- 990 ratios do not default to 100%.
The 990 Ratios page is available only for 990 accounts that generate Form 990. The fields on the 990 Ratios page are activated only after the
Use 990 Ratios for this account
check box is selected. If a 990 ratio is not entered, then no amount is reported in the column of the respective line item. The PAN-level revenue and expense tax code assignments (which are set as 990 control information) are used if the Use 990 Ratios for this account
check box is deselected after the 990 ratios are saved.To enter 990 ratio amounts:
- Open the 990 account.
- SelectAccountthen990 Ratioin the topic list panel.
- Review theUse 990 Ratios for this accountcheck box. If the check box is deselected, select it to activate the fields on the 990 Ratios page.
- For each revenue and expense item, select in the field under theRevenueandExpensecollapsible sections then enter the ratio amount as a decimal percentage.
- SelectSave.
Reviewing Recipients
The details for each recipient (including the recipient's name and address, and information about the grants, allocations and/or contributions paid to the recipient during the current year) are included on the Recipient Detail page. These details can be bridged to your ONESOURCE Trust Tax database, or they can be manually entered. If the information is bridged, set up the recipients in your tax accounting system as beneficiaries and grants, and use a beneficiary tax code, such as tax code 149 (Beneficiary Distributions), for the payments made to the recipients.
To review the information for a recipient:
- Open the 990 account.
- Select theRecipientsmain topic.
- Review the recipients listed in the grid under theRecipient Listingcollapsible section to determine if each recipient is valid. Based on this high-level review, you may need to add or delete recipients.
- To add a recipient, enter the recipient information in the row below the grid heading, press the TAB key until you move off the row then selectSave.
- To delete a recipient, select Delete for the row that includes the recipient you want to delete then selectSave.
- Select theNamelink for the recipient you want to review.
- Under theRecipient Informationcollapsible section, review the recipient's basic information. Make any necessary changes.
- Select theGrants, Allocations, and Contributionscollapsible section. The fields shown under this collapsible section depend on whether the grant, allocation or contribution is cash or noncash. The following graphic shows that a cash amount of $10,000 was awarded to Charities Management, Inc. during the current year:
- Review the grant, allocation and contribution information. Make any necessary changes.
- Selectdetailto review the details for the total amount paid to the recipient. The details display in a grid below theTotal grants, allocations and contributionsfield. Make any necessary changes to the grid.
- SelectSave.
Matching an Unmatched Distribution with a Recipient
Transactions that are not associated with a specific recipient are listed as unmatched distributions. In ONESOURCE Trust Tax, you can determine the number of unmatched distributions for a 990 account from two locations:
- TheUnmatched Distributionssubtopic
- TheGrants, Allocations, and Contributionscollapsible section on the Recipient Detail page
The following graphic shows what the
Unmatched Distributions
subtopic looks like when there is one unmatched distribution:The graphic below shows what the
Grants, Allocations, and Contributions
collapsible section looks like after detail
is selected. Notice that the total amount in the Total grants, allocations and contributions
field is incorrect and that the Match
column in the distribution grid indicates that the distribution is Unmatched
.To match an unmatched distribution with a recipient:
- Open the 990 account.
- SelectRecipientsthenUnmatched Distributionsin the topic list panel.
- Select theTransaction Detaillink for the unmatched distribution.
- Select thePaid Forcollapsible section.
- Select theActivecheck box for the recipient you want to match the distribution to.
- SelectSave. The distribution is matched to the recipient.
Reviewing Sales Details
Sales details can be reviewed at any time during the year to help minimize the amount of maintenance and review you need to complete during tax season. Although the same sales data that is bridged for 1041 returns can be bridged for 990 return types, there are some specific sales fields that apply to only 990 return types that cannot be bridged. These fields should be reviewed to ensure they are set correctly.
To review the details for a sale:
- Open the 990 account.
- Select theSalesmain topic.
- Select theSale Detaillink for the sale you want to review. You can move through the sales for an account from the Sale Detail page by selecting Back or Forward at the top of the Sale Detail page.
- Review the details of the sale. The fields to pay particular attention to depend on the 990 return type(s) generated for the account. The following table lists 990 return type(s), collapsible section where the fields can be found and the fields to review:990 Return Type(s)Collapsible SectionReview990 and 990-EZSales DetailTheBook Valuefield.For Forms 990 and 990-EZ, the book value is used as the cost basis only if theForm 990/990-EZ-use book value as the cost basis of the saleCapital Sales option on the Options and Overrides page is set toYes.990, 990-EZ, 990-PF and 990-TAssociated ActivitiesTheCategory Codedrop-down list.For Forms 990, 990-EZ and 990-T, the default selection isSecurities (990 & 990-EZ). For Form 990-PF, the default selection isInvestment Property (990-PF).TheProperty Used in Unrelated Trade or Business (990-T only)selection is used for Form 990-T reporting purposes only. The sale is not reported on Form 990 or 990-EZ if you use this selection and Form 990-T is not generated for the account.990-PFAssociated ActivitiesTheAcquisition Methoddrop-down list.This drop-down list is empty by default, but you can select whether the asset was donated or purchased.990-PFAssociated ActivitiesTheProperty Typedrop-down list.The default selection isSecurities, but you can select whether the asset is a common trust fund, real estate or other.
- If you made changes, selectSavebefore reviewing the next sale.