Triva isn't available right now.
Check out the support page for our phone number and hours
Solutions
Law firms
Tax, audit & accounting firms
Success stories
-
A true competitive advantage
Law firm Zarwin Baum’s embrace of generative AI as the natural next step in the evolution of legal work and their adoption of CoCounsel Legal has helped them achieve remarkable efficiency gains and improved client relationships.
-
Workflow transformation drives impact
Brinks, a global leader in secure logistics and security solutions, used CoCounsel to reimagine what was possible with AI tools, turning legal challenges into a competitive advantage.
-
The forefront of audit tech
A better auditing workflow solution was the answer to multiple challenges faced by The Mercadien Group. Find out how they achieved greater efficiency by embracing Cloud Audit Suite.
Questions? We are here to help.
Products
Legal
Trade & supply
Tax, audit & accounting
- 1040SCAN
- Audit Intelligence Analyze
- CoCounsel Audit
- CoCounsel Tax
- Ready to Advise
- Ready to Review
- View all
Corporate tax
Recommended products
-
CoCounsel Legal
Transform your work with the only AI legal solution uniting research, drafting, and document analysis in a single experience. Designed by legal experts and built on trusted content and advanced AI, CoCounsel Legal accelerates multistep work so you can better serve your clients and grow your business.
-
CoCounsel Tax
Transform your tax practice with CoCounsel Tax, an AI-powered assistant that combines trustworthy answers, automation, and firm knowledge into one seamless platform. Enhance efficiency, reduce risk, and improve client confidence with CoCounsel Tax.
-
CLEAR
Powerful software designed for law enforcement, compliance, risk, and fraud investigators. Conduct thorough investigations with ease using our intuitive online investigation software. Efficiently, prevent, detect, and solve crime.
Questions? We are here to help.
Purchase
Buy solutions
Resources
Insights
Events
Product training
Product communities
Developers
Highlights
-
2026 SKILLS showcase
Join weekly sessions to experience in-depth demonstrations of the leading legal AI products while connecting with strategic law firm leaders in knowledge management, innovation, and AI.
-
Ghosts on the ledger
Payroll fraud is a major compliance risk. Learn how payroll analytics and AI-powered tools can help exorcise phantom employees and employers.
-
Future of professionals report 2025
The Thomson Reuters Future of Professionals Report 2025 reveals how AI continues to shape professional work — and what it takes to get ahead. This year’s report shows that increased efficiency, productivity, and cost savings top the list of benefits professionals attribute to AI, making it indispensable for organizations facing rapid change.
Prepare a source file to import new entities
You can prepare a Microsoft Excel spreadsheet to use to import new entities and create new binders.
Use this format for the source file.
note
If any of the required elements are missing or any data element is invalid, the entity won't import.
Import Item | Required | Description |
|---|---|---|
Entity Type | yes | Must be a valid entity type:
|
Return Type | yes | Must be a valid return type:
|
Company Name | yes | Entity name, 45 characters |
Company Name, line 2 | no | Entity name line 2, 45 characters |
Company Number | yes | Used for batch importing and international processing. Required for international filing types foreign entity or foreign tax credit. 10 characters |
Street Address | no | Entity address, 45 characters |
City | no | Entity city, 20 characters |
State | no | Valid 2 letter abbreviation |
Zip/Postal Code | no | Entity zip code, 10 characters |
Country | no | Country of operations, 25 characters |
Federal Employer ID Number | yes | Required with return types:
|
Fiscal Year Beginning Date | no | Entered only if using a year other than a calendar year; can be in either format: mm/dd or mm/dd/yyyy |
Date of Incorp/Date Business Started | no | Entity date of incorporations, mm/dd/yyyy |
Incorporation State | no | Valid 2 letter abbreviation |
Incorporation Filing Type | no | Foreign Tax Credit or Foreign Entity, if an international return; valid only with a return type of 1120C |
International Div Con Data Entry Level | yes | Used to specify whether sourcing will be completed at the branch (division binder) or the div con level; import an X to mark the option; required for Divisional Consolidation binders with an international filing type of Foreign Entity or Foreign Tax Credit |
Income Tax Binder Name | no | Binder name of the new binder to be created; defaults to New Binder if the year is entered and this field is left blank |
Income Tax Binder Year | yes | Tax year of the binder to be created; this should be the prior year to allow for entry of beginning balance sheet and state property factors; yyyy format
|
Provision Binder Name | no | Binder name of the new binder to be created; defaults to New Binder if the year is entered and this field is left blank |
Provision Binder Year | yes | Tax year of the binder to be created; required if the provision binder name is defined, yyyy format |
This article applies to:
- Product: ONESOURCE Income Tax
- Subject: Import
Related Content
-
Import entity and binder information from a spreadsheet
Format:
Article,
1 min read