Triva isn't available right now.
Check out the support page for our phone number and hours
Legal
Recommended Products
-
CoCounsel
Move faster and accomplish more with a professional-grade, generative AI assistant that transforms the way you work. Thomson Reuters CoCounsel is with you every step of the way, backed by authoritative content and industry-leading expertise.
-
Westlaw
Conduct legal research efficiently and confidently using trusted content, proprietary editorial enhancements, and advanced technology.
-
Practical Law
Accelerate how you find answers with powerful generative AI capabilities and the expertise of 650+ attorney editors. With Practical Law, access thousands of expertly maintained how-to guides, templates, checklists, and more across all major practice areas.
Questions? We are here to help
Tax & Accounting
-
Top products for corporations
-
Top products for accounting firms
Recommended Products
-
CoCounsel Tax, Audit, Accounting
Move faster and accomplish more with a professional-grade, generative AI assistant that transforms the way you work. Thomson Reuters CoCounsel is with you every step of the way, backed by authoritative content and industry-leading expertise.
-
UltraTax CS
Provides a full line of federal, state, and local programs. Save time with tax planning, preparation, and compliance.
-
1040SCAN
Automate work paper preparation and eliminate data entry
Questions? We are here to help
Trade & Supply
Recommended Products
-
Foreign Trade Zone Management
Software that keeps supply chain data in one central location. Optimize operations, connect with external partners, create reports and keep inventory accurate.
-
Indirect Tax
Automate sales and use tax, GST, and VAT compliance. Consolidate multiple country-specific spreadsheets into a single, customizable solution and improve tax filing and return accuracy.
Questions? We are here to help
Risk & Fraud
Recommended Products
-
CLEAR
Search volumes of data with intuitive navigation and simple filtering parameters. Prevent, detect, and investigate crime.
-
Fraud Detect
Identify patterns of potentially fraudulent behavior with actionable analytics and protect resources and program integrity.
-
ID Risk Analytics
Analyze data to detect, prevent, and mitigate fraud. Focus investigation resources on the highest risks and protect programs by reducing improper payments.
Questions? We are here to help
News & Media
Recommended Products
-
Reuters Connect
Around the globe, with unmatched speed and scale, Reuters Connect gives you the power to serve your audiences in a whole new way.
-
Reuters Plus - Content Studio
Reuters Plus, the commercial content studio at the heart of Reuters, builds campaign content that helps you to connect with your audiences in meaningful and hyper-targeted ways.
-
Reuters.com Platform
Reuters.com provides readers with a rich, immersive multimedia experience when accessing the latest fast-moving global news and in-depth reporting.
Questions? We are here to help
Books
Recommended Products
-
What's new in legal products
Shop our latest titles
-
Shop tax customer favorites
ProView Quickfinder favorite libraries
Questions? We are here to help
Developers
-
APIs by industry
-
Related sites
-
United States Support
-
International support
-
New releases
-
Join a TR community
-
Free trials & demos
Apportionment spreadsheet (990)
Use the Apportionment spreadsheet to enter information for the apportionment factors. The spreadsheet consists of three tabs; one for each factor: Property, Payroll, and Sales.
To open the Apportionment spreadsheet, choose View, then Apportionment or press Ctrl+B with a 990 client open. Note that you'll have to attach a state return to this client to open this window.
note
- White boxes:Generally, UltraTax CS uses thewhite boxesin the state columns and the corresponding boxes in the Everywhere / (Override) column to complete the state's apportionment form. Specific information on how these boxes are combined on the form can be found in each state's Apportionment Combination table.
- Shaded boxes:Generally, UltraTax CS does not use the information you enter in theshaded boxeson a state's apportionment form. However, the amounts you enter in the shaded boxes accumulate in the Everywhere / (Override) amount, which UltraTax CS uses as the everywhere amount on the apportionment forms for other states that require information for that component.
- Statement windows:Some boxes in the spreadsheet have statement windows in which you can enter detailed information for the factor's component. UltraTax CS uses the information you enter in the statement window's Everywhere column on the state form for that component. UltraTax CS ignores the amount in the Apportionment spreadsheet's Everywhere / (Override) column for that component for that state.The statement windows include separate boxes for in-state and everywhere information. Be sure to complete the everywhere information, because UltraTax CS uses only the statement window's everywhere information for that particular component.
- Column totals:For the state, Other, and Everywhere / (Override) columns, UltraTax CS calculates the amounts entered in the white boxes and displays the total at the bottom of the column. The amounts are calculated in the same manner in which they are calculated for the apportionment form. For example, annual rents are multiplied by eight, and returns and allowances are deducted from sales.
- Detailed asset data entry allows you to classify assets for the property factor and automatically transfers the beginning-of-year and end-of-year amounts to the corresponding box in the Property tab.
- You can import data from an Excel spreadsheet or the Windows Clipboard into a statement window.
Columns in this spreadsheet
- Component- Lists the most frequently used components for this factor.
- State- Use these columns to enter the in-state amounts for the apportionment forms. Most apportionment data entry is completed in these columns. Note that only states attached to the current client's return appear as columns.
- Other- Use this column to enter component data that you would not enter in one of the state columns, such as out-of-country information or data for states that do not require income tax returns.
- Everywhere / (Override)- UltraTax CS uses the information in this column to complete the everywhere amount on the state's apportionment forms. UltraTax CS combines the amounts you enter in the state columns and the Other column, and then displays the total in the Everywhere / (Override) column.noteIf necessary, you can force the amount in the Everywhere / (Override) column. If you force the amount for all states, the overridden amount appears in red in this column.
- Federal Amount- Use this column to view information from the federal return, for your reference only. Data from this column is not used on the state apportionment forms.