Multi-Entity Company Upgrade In Sage Intacct

Keywords: Transactions, single entity, Account, Sage, Reports, Graphs

Credit:–  Sage Photo By: FP

Struggling to Keep Your Books in Order? 📊📅

Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.

👉 Click Here for a Free Consultation!

Your Sage Intacct “Company” can be one of the following:

  • Single entity company
  • Multi-entity company

Single entity company

If you currently work in a single entity company, that entity represents a single tax identification or a single set of books. Users work in that entity, and the entity is pretty much synonymous with your company. When your Intacct company is upgraded, it will have a single entity and a top level. The top level enables administrators to manage the company and entities, and set up master data lists used throughout the company.

Multi-entity company

In a multi-entity shared company, entities represent a separate tax identification or a separately secured, fully balancing set of books. Entities typically represent divisions, franchises, affiliates, associations, locations, chapters, self-balancing funds or subsidiaries, with a shared chart of accounts. A multi-entity shared company includes one or more entities under the top level. The company has a set of data lists that’s shared among all entities. These shared data lists include users, chart of accounts, customers, vendors, and employees. Administrators define the shared data lists once at the top level and use them throughout the entities in the company. Administrators use the top level to manage entities and their data. Alternatively, users and master data list members (vendors, customers, employees) can be restricted to working at the entity level only, or even to particular entities.

One example of a multi-entity shared company might be a property management company. The company’s corporate headquarters are represented by one entity and each managed property is represented by its own separate entity.

Benefits of a multi-entity company

Multi-entity companies provide greater control for managing user access and experience based on your business needs. With a multi-entity framework, you can add entities to your company without any implementation steps, which gives you greater flexibility for your growing business. A multi-entity company enables you to benefit from features such as the following (additional fees may apply):

  • Easily add entities to your company.
  • Control user access to entities.
  • Manage inter-entity transactions by mapping separate designated payable and receivable GL accounts for each entity in your company.
  • Use Domestic Consolidations to consolidate across entities. Use Global Consolidations to consolidate across entities and base currencies.
  • Automatically eliminate inter-entity receivable and payable balances in the single reporting currency of a consolidation book. Automatically net out elimination entries in the elimination entity of a consolidation book, avoiding overstating the consolidated financial statements.
  • Work with multiple base currencies.
  • Auto-balance IET General Ledger journal entries across entities with multiple base currencies. Use automated exchange rates, ensuring up-to-date currency conversions, and, in turn, accurate reconciliations for multi-entity, multi-currency companies.

Assign an ID and name your single entity

The only thing you need to do for your company to be upgraded is to name your entity and assign it a unique ID. The unique ID identifies the entity in your multi-entity company, and distinguishes the entity from the top level of your company. If you choose to add entities to your multi-entity company, the unique ID will distinguish this entity from entities you add later.

Every entity requires a unique ID. The ID is permanent.

Entity naming conventions

It’s a best practice to set up a naming convention for your entity IDs. A clear naming convention makes it easy to find an entity name among location names, and simplifies the adding of entities in future.

A common naming convention is to prefix the letter E to a 3 or 4 digit numerical value. For example, your first entity ID is E100, the second entity ID is E200, and so on. The entity ID is fixed when you define it, and cannot be changed. You can, however, change the entity name later if needed. It’s also recommended to have a naming convention for entities, usually based on their location. For instance, San Francisco, Los Angeles, and Sacramento locations might all be part of the E100: California entity. In this example, the entity ID is E100, and the entity name is California.

  • Go to Company > Setup > Configuration and select Company.
  • On the Company information page, select Edit.
  • Scroll down to Single entity migration settings.
  • Enter identifying details for your single entity as follows:
  • Entity ID: Enter an ID to identify your single entity in your company. For example, you can enter E100 as the entity ID. The ID is permanent and cannot be changed.
  • Entity name: Enter a name to identify the entity in your company.
  • Select Save.

About how Sage Intacct upgrades your company

All existing transactions in your company are associated with the newly defined entity. Any transaction assigned to the San Francisco location, for example, is now a transaction in the California entity. The San Francisco location is still assigned. Any transactions without a location assigned are assigned to the newly defined entity. Similarly, all transactions with a location dimension will remain under that location dimension in the new entity. All master data records are assigned to the top level.

Examples of master data records include:

  • Customers
  • Vendors
  • Contacts
  • GL accounts
  • Items
  • Contracts
  • Projects
  • Employees

About your company after the upgrade to multi-entity

After your company is upgraded to a multi-entity company with a top level, you’ll find the following upgrades to components of your company.

  • Company
  • Default entity
  • Additional entities
  • Users
  • Bank accounts
  • Transactions
  • Pay bills by entity
  • Reporting
  • Dimensions
  • Locations
  • Import files

About where to work: top level or entity level

When Sage Intacct upgrades your company to having a top level, we automatically restrict work in the company to top level only. Working at the top level only is generally a best practice for a variety of business needs, and makes your company feel more like what you’re used to. You can leave the default behavior as is, or change it depending on your needs. Based on your business needs, you can decide whether to restrict work to the top level or entity level.

  • Restrict work to the top level only
  • Restrict work to the entity level only

Restrict work to the top level only

Restricting users to working at the top level only makes your company look and feel like a single entity company. When selecting this option, users work only at the top level, the entity slide-in option is hidden from the UI. Your company must have a single base currency to restrict work to the top level only.

Because this restriction hides the entity dropdown from the UI, all users must be set up to access the top level. Users restricted to two or more entities can access the top level by default. Ensure that any users restricted to a single entity have Enable access to the top level selected. Certain Intacct applications can only be used with access to the entity level, such that it’s a good idea to thoroughly examine your business needs before enabling this option.

Restrict work to the entity level only

Administrators can restrict users to working at the entity level only. By selecting Restrict subledger transaction to the entity level only in the Multi-Entity Management, you can restrict users to creating transactions at the entity level only. Users with the relevant permissions can still create records, such as vendors, customers, bank accounts, and so on at the top or entity level. Selecting the options to restrict transactions to the entity level enables users to enter transactions at the entity level only. Restricting transactions to the entity level only means users cannot work at the top level. Restricting General Ledger transactions to the entity level means that users lose all inter-entity automation in the General Ledger. Consider carefully this loss of functionality before choosing to restrict General Ledger transactions to the entity level..

Unrestricted users can still view top level transactions that were created before restricting subledger transactions to the entity level. Unrestricted users can also see all entity level transactions per entity by selecting Include private. Restricted users who can access more than one entity can only see transactions for those entities they can access.

Quick Start templates

A Quick Start template includes pre-defined infrastructure geared towards specific industries, including items such as account groups, dashboards, financial reports, and more. Quick Start templates are valuable and widely used for three main reasons:

  • Implementers can quickly and more accurately set up new companies from similar industries by providing some out-of-box, industry-standard configuration that most clients want.
  • Companies and organizations gain access to account categories, which makes it easy to pull new data into existing reports. These are only available to you if your company or organization uses a QuickStart template.
  • Sage Intacct adds new out-of-box reports, dashboards, account categories, and more to QuickStart templates on an ongoing basis. This helps you jump-start your dashboard and report creation, comply with new accounting standards that take effect, get more industry-standard reports, graphs, and more, so that you can focus on your work instead of figuring out how Intacct works.

Quick Start template benefits

Quick Start templates provide many benefits, but the most important ones include:

  • Account categories
  • Predefined account groups based on account categories
  • Out-of-box financial reports, financial graphs, and dashboards

In addition to what you get when your company is implemented, Sage Intacct adds new items to Quick Start templates from time to based on increased demand for certain industry-standard items. This could include new categories, account groups, financial reports, graphs, and dashboards.

Account categories

With account categories, you can group accounts easily without worrying about restrictive account numbering. Out-of-the-box account groups and financial reports are built based on these account categories. They automatically pull in accounts tagged with the appropriate category, which means you do not have to reconfigure reports and account groups every time you add an account. Categories are used to create pre-defined, out-of-box reports and other elements in Intacct. To ensure that these reports work correctly, you can’t change existing categories or create new ones in Intacct.

However, you can create your own account groups to group accounts however you’d like, and then use those account groups in reports.

Assign categories to accounts

Because categories are so powerful, choosing the best category for your account is important. When choosing a category, always consider how and where the account will be used. If you make a mistake or change your mind, you can always change the category later.

The Interest expense category is configured to Credit normal, even though sometimes it’s assumed to be Debit normal. This is intentional. The interest expense account has a debit balance as the default, but in reporting it appears as a negative amount, offsetting the interest income.

To assign a category to an account:

  • Go to Reports > Setup > Accounts.
  • Select Edit beside the account you want to modify.
  • Select the Category for the account and save your changes.

To see which categories are included in a particular account group, edit or view the account group.

  • Go to General Ledger > All > Reports.
  • Choose the Account groups hierarchy.
  • Filter and run the report. You can filter by account groups and categories.

Select the down arrow by Category to see a list of all available categories.

Account groups

Quick Start templates include pre-defined account groups used in the out-of-box reports, graphs, and dashboards. These account groups are also category-based, which makes categories that much more powerful. You can view a list of these pre created account groups from the Account groups library. You can modify these account groups however you want, but remember that they are also used as the basis for the out-of-box reports, graphs, and dashboards included with the Quick Start template.

To view a list of pre created account groups:

  • Go to Reports > Setup > Account groups.
  • Select Account groups library to open a list of all account groups included with your Quick Start template.

Reports, graphs, and dashboards

Quick Start templates also include out-of-box reports, graphs, and dashboards that require minimal configuration. These items are all based on the categories and account groups also included with the template, which makes it easy to include new data when you want to.

Find your Quick Start template

To find out if your company was created using a Quick Start template, go to the Accounting tab on the Company information page (Company > Setup > Configuration > Company). If a template was used, the type appears in the Quick Start template field. If the field is blank, the company wasn’t set up using a template. In most cases, you can’t add or change a Quick Start template after your company has already been implemented and records and transactions have been created. If you really want to start using a Quick Start or switch to a different template, contact your account manager to discuss your options.

Quick Start templates for implementers

Implementers can use a Quick Start setup template when creating companies to quickly and more accurately set up companies that belong to certain industries. Creating a company using a Quick Start template lets you:

  • get started faster
  • use pre-defined categories and structural information geared towards specific industries
  • take advantage of precreated account groups and financial reports
  • install system libraries, dashboards, account groups, and graphs

Benefits of using a Quick Start

Using a Quick Start setup template gives new companies a basic infrastructure right out of the box. By using this infrastructure, you can modify and populate a company much more quickly than by creating a company from scratch. While you still need to create the Chart of Accounts, a Quick Start template gives you built-in features, including:

  • financial periods
  • accounting methods
  • workflows
  • AP and AR configuration
  • dimensions
  • account categories (*specific to Quick Start templates)
  • account groups
  • financial reports and graphs
  • dashboards

These items are different for each type of Quick Start template, ensuring that every company is set up according to industry-wide standards and needs. For example, the default account groups are different in a company set up with the Services template than for one that was set up using the Nonprofit template, because their needs and requirements differ. Templates do not include actual data such as transactions, customers, vendors, items, or bank account numbers.

These built-in features improve the speed and accuracy of company creation. You can change the template values during the setup, and many items can be changed even after that. It is important to note that a Quick Start template doesn’t contain everything that you need to set up the company; some additional setup is needed, such as the Chart of Accounts and other company-specific requests. Implementers can copy a company that was created from a Quick Start template. A copied company retains all the features of the original company.

About account categories

With account categories, you can group accounts easily without worrying about restrictive account numbering. Out-of-the-box account groups and financial reports are built based on these account categories. They automatically pull in accounts tagged with the appropriate category, which means you do not have to reconfigure reports and account groups every time you add an account.

You can also use categories with custom reports and custom account groups.

Example with and without categories

Categories are used to create pre-defined, out-of-box reports and other elements in Intacct. To ensure that these reports work correctly, you can’t change existing categories or create new ones in Intacct. However, you can create your own account groups to group accounts however you’d like, and then use those account groups in reports.

Assign categories to accounts

Because categories are so powerful, choosing the best category for your account is important. When choosing a category, always consider how and where the account will be used. If you make a mistake or change your mind, you can always change the category later.

The Interest expense category is configured to Credit normal, even though sometimes it’s assumed to be Debit normal. This is intentional. The interest expense account has a debit balance as the default, but in reporting it appears as a negative amount, offsetting the interest income.

To assign a category to an account:

  • Go to Reports > Setup > Accounts.
  • Select Edit beside the account you want to modify.
  • Select the Category for the account and save your changes.

To see which categories are included in a particular account group, edit or view the account group.

  • Go to General Ledger > All > Reports.
  • Choose the Account groups hierarchy.
  • Filter and run the report. You can filter by account groups and categories.

Select the down arrow by Category to see a list of all available categories.

Check out our Free Additional Articles